Budget allocation: combining different levels of granularity in Power BI
Allocating budgets on a different level is not easy to manage in DAX. It was (and still is) a DAX struggle for me. This blog post will guide you through the different steps I took to easily manage the different granularities (and write easy DAX afterwards) by allocating budget on day level using Power Query.
Kohera’s Modern Data Platform: Choosing the model – Pt.1
Kohera’s Modern Data platform does not come with a canned data model by default. This makes the framework extremely flexible to adapt to a variety of project workflows, but it also means during the Analysis phase we will need to think about how to structure the data before continuing.
Should I use serverless for all my Azure SQL Databases?
But first things first, what the heck is serverless? Azure SQL Database serverless is a new compute tier made for single databases. This new model automatically scales the compute based on the actual workload per second. This means that you only have to pay for the compute resources (memory & vCores) you use. Furthermore, serverless has an autopause function. It will pause your database when it remains inactive for a period of minimum 1 hour. For a paused database, only the storage is charged.
The hidden gems of the function Web.Contents()
Some of my customers want me to import their data from a standard on-premises or cloud-based (Azure) SQL-database, but others want me to import their data from a REST API. If ever, you’ll have to import data from a REST API, you’ll surely encounter some obstacles. That’s why I write this article to prevent you from this. Based on a real-life example, I’ll talk about the most common problems when using REST API’s, where for some of them still no solution has been found by Microsoft itself (although not that I’m aware of).
How to create a Time Table in Power BI in a few simple steps
In a previous blogpost, we already explained how to make a date table in Power BI with DAX. Besides the dates you can add extra properties for each date: year, month-names, weekday-names,…
De Tijdloze 2019: de follow-up
31 december was het zo ver, we zaten aan de radio gekluisterd om de Tijdloze op de voet te volgen. Op plaats 93 noteerden we onze eerste voltreffer en hoe dichter we bij de top 10 kwamen, hoe beter onze voorspelling (zie blogpost: De Tijdloze van StuBru: onze Power BI-voorspelling) . Negen van de tien nummers uit de top 10 hadden we voorspeld en drie hiervan hadden de voorspelde ranking.
Custom email notification in Azure Data Factory
Tired of logging on to Azure Data Factory every day and checking the status of your pipeline(s)? What if you forget to look at the pipeline monitor for a week and the pipeline has failed?
Creating a Secure Databricks Environment
Azure Databricks is a cloud native (Big) Data analytics service, offered as a managed PaaS environment. It’s designed to hide the underlying distributed systems and networking complexity as much as possible from the end user.
Integrate PowerApps in Power BI
How can you integrate a Powerapps in Power BI to interact with your data, what are the possibilities? And Why would you want to integrate them in Power BI? Power BI is an amazing tool to visualize your data, but if you want to take actions depending on your data, PowerApps comes in handy.
Azure Synapse Analytics: Where Azure DWH, Spark & ADF meet
When I started to jump from DBA to Data Architect, I thought that these roles would diverge further and further until they became two separate roles and functions. Both with their own skillset and their own purpose in the (big) Data Analytics world. The current evolution Microsoft launched proved me wrong though. Enter Azure Synapse Analytics.
