An Introduction to Power BI

​

• Recognise the benefits of Power BI

• Understand the architecture of Power BI

• Explore possible data sources

• Navigate Power Query

• Compare licences and the difference between the online service and the desktop application

Data Models and Relationships

​

• Create a data model

• Understand the star schema

• Build different types of cardinality between data sets

• Explore the importance of relationships to reports and visualizations

Creating Reports​

​

• Explore different types of visualization

• Build meaningful reports from data sets

• Format the appearance of reports

Transforming Data

• Import data from Excel spreadsheets into Power Query

• Work with queries

• Understand applied steps

• Cleanse data using transformation techniques

• Close and load data into the data model

Shaping Data​

​

• An introduction to DAX calculations

• Work with basic DAX in Power BI

• Add Measures and Calculated columns into data models

Creating and Sharing Dashboards

​

• Create workspaces on the Power BI online service

• Publish reports and semantic models

• Create dashboards

• Pin individual visualisations and whole report pages

• Share dashboards