In my previous post, I showed you how to stream real time tweets to Power BI using Azure Databricks, Azure Streaming Analytics and Power BI. Then, I showed you how to store those tweets for long time storage in your data lake. But how do we bring that data to our data warehouse?First of all:
Continue reading...
Azure
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...
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...
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...
Retrieving SharePoint Online List data SharePoint Online List data is one of those sources that can be of interest to integrate with other data in your Azure Data Platform. If your organization or client is already using SharePoint then Lists are often easy to set up and provide users a friendly way of data entry.
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...
Recently I have seen implementations of Analysis Services that go directly to the Data Lake. In order to speed things up and to remove redundancy, there is no relational data storage even if the data is relational in nature. Data is persisted raw in the lake and goes directly to a user friendly data model
Continue reading...