Power BI: How to unpivot twice
Recently I had a customer providing data for a PowerBI report in the below format. We have procedures containing several tests and for each test a result and target value. As you might notice, the format of the data provided is not ideal for reporting purposes. Creating visuals based on data in this format is not easy (try it!). You would have to write a measure for each test and if an additional test is added to a procedure the setup, as is, is not workable.
How To videos: Power BI and Python (part I & II)
Python is a great addition to the Power BI family by providing you the ability to perform quick data transformation or plot cool data visualizations. You can even expand your Power BI reports further by bringing in sophisticated machine learning and AI. Our Power BI wizard Nick Faes gives you an introduction in setting up Python in Power BI and how to start creating small multiples.
Power BI and Python: scraping De Tijdloze 100 website
As you might know, Python is now available as a preview feature in Power BI. It can be used to import, transform and visualize data. It has roughly the same workflow as R: you need to point to the Python interpreter on your local system, which will do all the magic for you.
Update: De Tijdloze Power BI
Heb jij op het einde van vorig jaar ook geluisterd naar een top 100 of 1000? Bijna elke radiozender blikt terug met een muzieklijst van nummers van het voorbije jaar of telt af naar de grootse hit allertijden. De Tijdloze 100 van Studio Brussel is er zo eentje. We houden de resultaten ondertussen al enkele jaren bij in een handig Power BI dashboard. Ondertussen hebben we ook de gegevens van de meest recente editie 2018 in ons Power BI rapport geladen.
How to Automatically add measures to Power BI
Some time ago I wrote a blogpost to retrieve all the measures from your tabular cube or from your open Power BI files. I want to make a simple addition to this blog, more specifically one that unravels a technique that can be used to automate some actions in Power BI, like the creation of measures. The trick is actually pretty simple, but for some reason I just didn’t try it before.
World Cup Russia: Discover our Power BI dashboard yourself
You may have seen it pop up throughout our blogs and webinars in the past few months: the World Cup 2018 in Russia! Philippe Van Rillaer and I created a dashboard in Power BI about the historical results of previous World Cups, as well as the results of the qualifiers for this year’s World Cup, the current teams that qualified, etc.
World Cup Russia dashboard in Power BI: importing the teams from multiple web pages
While working on our World Cup dashboard my colleague Philippe Van Rillaer and I wanted to import data from tables spread out over multiple Wikipedia pages. One example was importing players that are currently selected for the teams that qualified for the upcoming World Cup. We could navigate to each country’s page separately, but of course Power BI offers more powerful options than this.
There’s always an insight with Power BI: CONCATENATEX
Not so long ago, I was working with a client who had a specific Power BI request. They wanted to do a lookup of a column in another table, but if there were multiple hits, they wanted to display all the matching rows in the same cell (Power BI doesn’t really know the concept of cells, but you know what I mean). Let’s give you an example. Imagine we have a very simple Clients dimension table with only three clients:
Azure Data Architectures: Lambda
The lambda architecture actually splits data flows into two components, receiving data centrally and doing as little as possible processing before copying and splitting the data stream into two streams, namely the real time and batch layers. Within Azure we have for example IOT Hub being capable of duplicating these streams at the entry point.
Latest Power BI update: share your portal with guest users
Power BI’s mission is crystal clear: extract crucial intelligence from data so companies can use it to grow or strengthen their business. The latest update to the software further amplifies this creed: Azure Active Directory Business-to-business (Azure AD B2B) is now integrated into Power BI to make sharing Power BI apps and dashboards with users outside of your organization a piece of cake. Even when they don’t have a Power BI license themselves.
