This course will provide you with the basic knowledge and skills to import / ingest data, create a model and create visualisations using Power BI Desktop.
Please note – Delegates attending an Extended Classroom delivery will need access to a second monitor.
Module 1: Overview
This module provides essential background information Power BI Desktop such as connections with Power BI Service, Analysis Services and data warehouses.
Module 2: Accessing data
This module describes the process of importing data into a Power BI Model. The sources used as demonstrations include CSV, Excel and Azure SQL Databases.
Module 3: Transforming Data
This module describes how you can transform the data from an imported source into a table. The module describes most of the options with the Power Query Editor and M language.
Module 4: Modelling Data
Once the data is imported into the model, the model can be enhanced by adding column and measure properties, calculations, hierarchies and relationships.
Module 5: Visualisation
This module how to create report pages using Power BI Desktop for consumption by others.
There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.