The course is based on the hypothetical user case as "Import data from Reliance, HydroOttawa and FreedomMobile for 2021 and 2020. Build graphs to display spending".

Topics

1. Overview of Power BI products:Power BI Desktop, Power BI Service and Power BI Reporting Services.

2. Data Retrieval and Transformation

2.1 Introduction to Power BI Desktop interface. Explore Report, Data and Model Views.

2.3 Retrieving data for the use in Power BI reports. We will use data from Excel and CSVfiles. We will also connect to a folder to retrieve all files inside.

2.4 Data modelling and transformation using Data Analysis Expressions (DAX). We will create Measures to illustrate the use of DAX

2.5 Creating and editing relationships between objects. We will create Many-To-Many Relationship between different tables

2.6 Using Query Editor for data transformation

2.7 Creating custom columns for data customization

2.8 Appending and merging queries

3. Data Visualization. Creating graphs

3.1 Data sorting

3.2 Learning how to group data for the use in graphs.

3.3 Data formatting and data visualization.

3.4 Creating cards, clustered column charts and tables

3.5 Using filtering and slicing

3.6 Data merging and refreshing

3.7 Using images as backgrounds . Inserting Text Boxes. Inserting Shapes. Working with Static Objects

4. Power BI Service

4.1 Publishing reports to share them with your coworkers or clients.

4.2 Steps to get a Pro license.