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.
- Anyone who will be creating Power BI Desktop models.
- The course is aimed at both non-technical 'power users' and IT Professionals who will be creating models.
Please note - Delegates attending an Extended Classroom delivery will need access to a second monitor.
There are no technical pre-requisites for this course and it assumes no prior knowledge of SQL Server.
Module 1: Overview
This module provides essential background information Power BI Desktop such as connections with Power BI Service, Analysis Services and data warehouses.
- Installing Power BI Desktop
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.
- Connecting to a live source
- Importing Excel and CSV data
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.
- Remove unwanted columns and rows
- Cleansing data
- Normalise datasets
- Merging data
- Importing multiple Excel files (M)
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.
- Managing relationships
- Customising fields view
Module 5: Visualisation
This module how to create report pages using Power BI Desktop for consumption by others.
- Visualise tabular
- Adding charts
- Adding maps
- Adding slicers
- Drillthrough pages
- Bookmarks, selections and buttons
- Custom tooltips