Power BI Basic to Advanced

Power BI - Data Visualization (Level 1)

Day 1 – Importing Data and Creating Visualizations

5 Topics

Introducing Power BI

Importing Data and Creating First Chart

Formatting Column Chart

Creating Pie and Line Chart

Creating Heading for Dashboard

Day 2 – Working with Slicers

4 Topics

Creating Tree Map and Bar Chart

Getting Distinct Count

Creating Slicer for Interactivity

Day 3 – Page Navigation Refresh Data and Animation

6 Topics

Creating Page Navigation

Edit Interaction

Animated Scrolled Visual

Making Horizontal Slicer

Power BI Shortcuts

Day 4 – Decomposition Tree and Reset All Filters

2 Topics

Creating Decomposition Tree

Reset All Filters with Button

Day 5 – Publishing Dashboard

4 Topics

Using Natural Language for getting Reports

Publish Dashboard and Mobile View

Importing Multiple Files and Creating Reports

HR Dashboard Project Explanation

Power Query (Level 2)

Day 1 – Cleaning Messy Data using Power Query

7 Topics

Day 2 – Cleaning Complex & Messy Data using Power Query

3 Topics

Day 3 – Combining Sheets, Files & PDF

5 Topics

Lesson 11 (Combining Sheets)

Lesson 12 (Adding Extra Sheet)

Lesson 13 (Adding More Records)

Lesson 14 (Combining Files)

Lesson 15 (Merge Query)

DATA MODELING (LEVEL 2)

Day 4 – Data Modeling – Creating Relationship Between Tables

4 Topics

Introduction to Data Modeling

Data Modeling Practical 1

Bi-Directional Filter

Data Modeling Practical 2

Day 5 – Data Modeling Project

3 Topics

Auto Detect Relationship Setting

Project on PowerQuery and Data Modeling

What’s Next after PowerQuery and Data Modeling

Getting Distinct Count

Power BI Basic to Advanced Day 2 – Working with Slicers Getting Distinct Count