A modern data platform should be able to handle streaming data, both in batch and real time. We as a society have come to expect organizations and people to respond to situations fast . We cannot always wait a day until the data warehouse has processed the nightly batch to analyze the data the next
Continue reading...
Power BI
If you would like to automate Power BI deployments, or want to include Power BI reports in your devops pipeline you should check out Power BI Actions which a former colleague of mine created: https://marketplace.visualstudio.com/items?itemName=maikvandergaag.maikvandergaag-power-bi-actions Power BI is both a self service BI and an enterprise BI tool. In a lot of cases, people publish
Continue reading...
If you ever have created a stacked column chart in Power BI, you may have noticed that it is not possible to get the total data value shown as a label. What it will do, is show the total for each slice of the bar, which is nice, but you then have to add up
Continue reading...
When you start a new Power BI report, you may run into some options that might confuse you. Maybe you already know what they are, but you don't really know when to use what? This is the blog post for you 🙂 Import This option loads all the data into the Power BI report. This
Continue reading...
Some time ago a colleague of mine - let's call him John - was bouncing up and down, saying we need Power BI Premium. A report was not performing very well and he had read that Premium would give us dedicated capacity. A quick glance at the problem made me realize he was having trouble
Continue reading...
4 years ago I was a speaker for an event called "Power BI for municipalities". The first speaker showed some of the reports they had been making at their organization. The audience was very involved and enthusiastic. They simply loved it. The main feeling going through everyone's mind was "I want to start with Power
Continue reading...
Organizations that start with Power BI often ask me "Jesse, how do you go about development, test and production environments when using Power BI?". I have decided to write about my experiences - I have been implementing Power BI since the beginning of the product - and share you my ideas. The reason why this
Continue reading...
In Microsoft BI, a tabular model is often the way to go. OLAP gets more and more often replaced by Tabular cubes and Power BI models. However, it's really hard to create a model that covers the whole enterprise. In this post I propose a solution for doing just that in a simple way. In
Continue reading...
The last two and a half years I have been helping organizations adopt and implement Power BI. With the right approach Power BI can be a huge success. But if you are not sure how to do it right, you might make the data landscape messier and more confusing. Here are the 5 simple lessons
Continue reading...
In an enterprise environment there are various ways of how users can interact with data using Power BI. Some users have a need for consuming pre-defined management reports, while other users wish to build their own datasets and create their own analysis. In discussion with colleagues we came up with five types of business users
Continue reading...