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.
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…
“THE DATABASE MOST USED IN YOUR QUERIES WILL BE DELETED!” “But don’t you worry pal, we are gonna migrate the tables and views you use to another database!” “If you could just give me a list of the objects you use in the soon-to-be-history-database, that would be great.” Migrations are a common animal in any…
Want to append the data of several files into ONE table? You could do this using Power BI Dataflows. However, you can also do this in Snowflake using the COPY INTO command. Imagine you have an AWS S3 bucket with a folder containing a lot of files that need to be appended into a single…
