Learning Unit 1: Importing Data into Power BI Desktop

• Using Get Data feature
• Get Data from text files
• Get Data from spreadsheet files
• Get Data from database files
• Get Data from websites

Learning Unit 2: Shape and Clean Data using Power Query

• Navigating Power Query Editor
• Removing rows and columns within Power Query
• Changing Data Types
• Entering data via Power Query
• Creating headers in Power Query
• Find and replacing values in columns
• Splitting and merging columns
• Using Unpivot feature
• Understanding Applied Steps in Query Editor

Learning Unit 3: Building Data Models

• What is a Data Model?
• Types of Relationships
• Creating Relationships between Tables
• Creating a Link Table
• Creating a New Calculated Columns

Learning Unit 4: Creating Basic Data Visualization

• Conditional Formating using background colours and data bars
• Using Bar, Column, Pie and other standard visualization
• Using KPI visualization and other visualization types

Learning Unit 5: Introduction to Measures

• What is a measure?
• Creating measures
• Using measures for Gauge chart and KPI visualization
• Creating measures table

Learning Unit 6: Introduction to DAX

• What is DAX?
• Basic DAX functions and formulas like SUM, AVERAGE, CALCULATE
• Difference between Iterator and Aggregator functions i.e. SUM vs SUMX
• Creating DAX with multiple tables
• Other DAX functions like COUNT, COUNTROWS, MAX, MIN, DIVIDE functions

Learning Unit 7: Additional Data Visualization

• Creating Drillthroughs
• Creating Tooltips

Learning Unit 8: Using Predictive Analytics and other Reference Lines

• Using Constant Line
• Using Min and MAX Line
• Using Average Line
• Using Median Line
• Using Percentile Line
• Creating Forecasting values