Lesson 1: Introduction

• Understanding Business Intelligence

• What is Power BI?

• Understanding Power BI Ecosystem

Lesson 2: Introduction to Power BI Desktop

• Getting to know Power BI Desktop Interface

• Navigating with the application

Lesson 3: Getting started with Reports

• Get Data

  • Import data into Power BI Desktop

  • Identifying various data sources

  • Import Single table 

• Create Basic Report

  • Setup canvas size and background formatting

  • Add Visuals, set fields and formatting

Lesson 4: Working with Data Model

• Introduction to Data Model

• Designing Data Model

• Set relationships between tables using the MODEL view

• Create reports using data model

Concluding Task:

Creating Our First Chart!

Lesson 5: Analyzing

• Analyzing Sales Person Performance

• Adding More Measures

• Formatting The Visuals + Conditional Formatting

Lesson 6: Working With More Report Features

• Understanding different filters that are available

  • Visual, Page, Report and Slicer

  • Enable/Disable filter interactions between visuals

• Setting up Drill through

Lesson 7: Working with Data Cleaning

• Understanding Power Query Editor

  • Load data into Power Query Editor

  • Explore the interface

• Transforming, clean, append and merge data

  • Removing Unwanted Columns

  • Renaming Columns

  • Removing Duplicates

  • Merging Columns

  • Splitting Columns

  • Replacing Null Values

  • Changing Data Types

  • Sorting Data

  • Filter Data
    

Lesson 8: Working with DAX Functions

• Introduction to DAX

• Working with Calculated Columns & Measures

  • Adding Calculated Colum

  • Adding Measures

• Aggregations Functions

• Filter Functions

• Logical Functions

• Time Intelligence Functions

Lesson 9: Enhance Power BI Report

• Report Drillthrough

• Enable Drilldown data in visuals

• Bookmarks and Buttons

• Selection and Layers

• Build and format a custom tooltip

Lesson 10: Top 10 Power Bi Tips and Techniques.

• Power BI Dashboard Tips and Tricks

• Conditional Formatting of Charts

• Align Objects