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.
No prior knowledge of Power BI Desktop is required, but knowledge of running queries in SQL Server would be useful
Module 1: Overview
This module provides essential background information Power BI Desktop such as connections with Power BI Service, Analysis Services and data warehouses.
Lab :
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.
Lab :
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.
Lab :
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.
Lab :
Module 5: Visualisation
This module how to create report pages using Power BI Desktop for consumption by others.
Lab :
Join our public courses in our Hong Kong facilities. Private class trainings will be organized at the location of your preference, according to your schedule.