The aim of this set of articles is to introduce “Power BI”, the self-service BI suite of Microsoft. Each article will guide you through the steps to create a dashboard that can be used to analyze the data related to the events organized by a Microsoft User Group. By following all the articles, you will have a good understanding of “Power BI”, what it is, how it works and how you can use it.
The articles are:
Building an analytical model means preparing a model that can easily be understandable and used by an end user. Typical tasks are:
In this article, we will see how to use “Power BI Desktop” to access, import and transform data. Once this is done, the data will be available for the modeling step of this set of articles.
As explained briefly during the article “Power BI – Introduction”, we want to create a dashboard to analyze some information about a Microsoft User Group and more specifically, the events that were organized by this group.
The data available can be grouped in two different kind of files: