Wij zijn Business Intelligence- & data enthousiastelingen. Met vele jaren ervaring in elke schakel van de keten van Business Intelligence denken wij in oplossingen voor onze klanten.
In het blog vind je artikelen over Business Intelligence in het algemeen en verscheidene tools in het bijzonder. Voorbeelden van onderwerpen zijn Power BI, DAX, SQL, Data Warehousing, Data Modeling, etc.
Nieuwsgierig naar onze projecten? Enkele voorbeelden betreffen het ontsluiten van data middels een webscraper ontwikkeld in Python, het toepassen van business logica en de opslag van data in Azure SQL DB en rapportages in Power BI.
Did you know you can use SQL queries in your Python worksheets in Snowflake? This works as follows: dataframe = session.sql( ”’ YOUR SQL QUERY GOES HERE ”’ ) And voila! Don’t forget to return it in the function in the worksheet if you wish to inspect the resulting dataframe in the results pane. I…
Are you looking for a way to speed up queries in Snowflake without altering the size of the warehouse? One way you might achieve this is by taking the largest table in your query and applying the necessary filters before you start using it in your query. This means that the aforementioned largest table that…
The interwebs is a scary place. I am working on a project where I am developing a webserver using Python as backend and HTML as frontend. With some help of my brother I created a Docker container containing the necessary resources for the website. I pushed the docker image to Azure Container Registry, used this…
I’ve been using Python for a few years now and I have been using libraries, packages and modules during those years and took them for granted I have never stopped and wondered how these relate to each other. The way I understand it, the relation between libraries, packages and modules is hierarchical: libraries consist of…
Would you like a list of all users in your organization? Including email, name, phone, etc? At the mere push of a button? The Microsoft Graph API may help with this wish. Add a sprinkle of Python and you can automate this process leaving you to do other important and eh … fun things like…
I like learning new stuff. Which is why I invest time and moneys into courses. I really enjoy courses where you are forced into rolling up your own sleeves in order to create something. Recently a course I did allowed me to do a project in AWS CloudFormation. Using a YAML CloudFormation template, I created…
Are looking to give some extra context to your SQL query output before you deliver to business users WITHOUT the use of Excel? A colleague of yours would like to see the sales per person including a GRAND TOTAL row. Using GROUP BY ROLLUP ( ColumnName ) you can easily create this, But this will…
I have been working with AWS CloudFormation and the AWS Cloud Development Kit (CDK) for some time now. Both are tools that help you create Infrastructure as Code (IaC). Infrastructure as Code can immensely speed up your development process. Instead of creating each resource one by one and configuring IAM settings manually, you can create…
Are you losing track of which Power BI objects your organization has? Or would you like to embed your reports somewhere? Would you like to know who the last person was who modified a certain report? The Power BI REST API may help you solve these issues. Getting access to the API can be quite…
In Snowflake there are useful commands like SHOW USERS (shows the users in your environment) or SHOW GRANTS TO ROLE (shows the privileges given to a certain role). The results of these commands are shown like tables however, you cannot filter them like SHOW USERS WHERE … You can however use the commands TABLE and…