Power BI is a powerful data visualization and business intelligence tool that allows users to easily create interactive dashboards and reports. Whether you are new to Power BI or looking to expand your knowledge, it’s important to have a solid foundation to build upon. In this blog post, we’ll explore some key concepts and resources […]
Tag: powerbi
Once a pawn a time Power BI meets chess…
Did you ever watch the Netflix series The Queen’s Gambit, in which the story follows the life of Beth Harmon, a fictional chess prodigy on her rise to the top of the chess world? This series, released in October 2020, didn’t only triple the revenue of chess set vendors during the first months post release […]
Charticulator in Power BI
Sometimes getting the right insights in your data is more complex than any already existing Power BI visual can offer. Maybe you want to display your own branding inside visuals? Or you just like to play around to create the most beautiful and unique visuals. Here, Charticulator enters the field. This open-source project by Microsoft […]
Synapse Dedicated SQL Pool vs. Serverless SQL Pool
Microsoft’s Synapse Analytics Suite aims to provide solutions for various data usage, consumption, and exploratory situations while also ensuring that clients can control costs in a straightforward and predictable manner. To address these distinct circumstances, Microsoft has built two separate techniques to controlling and allocating computation. In this blog we will go through both techniques. […]
Power BI Aggregations
Have you ever worked with a large Power BI report that’s just very slow to load? You’ve tried tweaking the model to improve the performance but without any luck. Then maybe aggregations is something to look into. Using aggregations, you can store the values of a (large) table aggregated by, for example, a date, a […]
Power BI Deployment Options [Part 1]
Ever wondered how software engineers are able to work in massive teams on the same project/code and get changes pushed to the end users at frightening speed and consistency? Wonder no more! In this series, I will explain all there is to know about Application Lifecycle Management when using Power BI. At the end of […]
CI/CD of Synapse Serverless – Part 1/2
Introduction As can be noticed in several other blogposts, Azure Synapse provides a wide variety of functionalities to support organizations in creating a Data Platform. In this blog post, we’ll specifically focus on ‘Synapse Serverless’ which virtualizes data residing in your data lake making it SQL-query-friendly for business users and data scientists. As every of […]
Lesson learned at the customer: Merging two tables to calculate On Time In Full (OTIF) [Part III]
In this final blog, we discuss the measures that have to be made. Note: this is the third part of the blog. Missed the second part? Read it here. Calculations From here on out we will continue with all the calculations that have to take place to get to the end result of the time aspect of OTIF. […]
Lesson learned at the customer: Merging two tables to calculate On Time In Full (OTIF) [Part II]
Bringing everything together in one table Note: this is the second part of the blog. Missed the first part? Read it here. Step 1 Select the new Orders table you just made and click “Append Queries as New” Now append the newly created Orders table with the newly created Deliveries table If you have more than 2 tables […]
Premium Per User (PPU) explained
Just last week, the Power BI CAT team extended their current licensing model with the release of Premium Per User (PPU) under public preview. On what ground exactly do current licensing models differ from this new release? We’re reaching our next destination: Premium Per User! What Power BI licensing offerings Microsoft already had in store? First […]
