PowerBI is a very powerful tool and a market leader for BI applications - creating and publishing reports and dashboards.
In the session, we discussed the following:
Recap of the Data Analysis Process
Introduction to PowerBI
Query Editor - Data Transformation
Data Modelling
Cardinality (relationships) - 1:1 and 1:Many
Measures and DAX
A basic report
You can download the dataset and the pbix file here.
NOTE: You will have to go to the query editor and change the source file to your file location.
Follow the steps below:
1. Go to Transform Data.
2. Find the tables on the left and click on the settings icon next to "Source."
3. Select your new source and click "OK."
You can find the next session here: