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 :
- 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.
Lab :
- 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.
Lab :
- 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.
Lab :
- Managing relationships
- Customising fields view
- Calculations
Module 5: Visualisation
This module how to create report pages using Power BI Desktop for consumption by others.
Lab :
- Visualise tabular
- Adding charts
- Adding maps
- Adding slicers
- Drillthrough pages
- Bookmarks, selections and buttons
- Custom tooltips
A101 YENI MAĞAZACILIK A.S.
Rated the training 5 stars.
A101 YENI MAĞAZACILIK A.S.
Rated the training 5 stars.
A101 YENI MAĞAZACILIK A.S.
Rated the training 5 stars.
A101 YENI MAĞAZACILIK A.S.
Rated the training 5 stars.
A101 YENI MAĞAZACILIK A.S.
Rated the training 5 stars.
A101 YENI MAĞAZACILIK A.S.
Rated the training 5 stars.
A101 YENI MAĞAZACILIK A.S.
Rated the training 5 stars.