In this course you will learn to take your Power BI data modeling to the next level – both in Power BI desktop, Power BI Serivce and with third-party tools such as Tabular Editor.
We will show how you can use a Power BI dataset and utilize it to gain insight into both Power BI but also Excel. By using good governance, you can easily share and update your data between many users.
The data set we will work on is based on the import of some local files and will be added to the Power BI service during the day to show how we can increase productivity and security by separating reports and data sets.
The main focus is on creating the right DAX measures and what it takes to make this a success. It is not everything that can be written as a measure. Some things require the addition of calculated columns to succeed. You will also learn how you can easily switch your sources from looking at test data to going into production, by leveraging standard features.