Master Microsoft Power BI in 21 Days

Course Curriculum

Chapter 1: Day 1-2 : Overview of Microsoft Power BI

Lecture 1: Welcome to the Course

Lecture 2: What is Microsoft Power BI?

Lecture 3: How to Install Power BI & Necessary Project Setup

Lecture 4: How to Connect Power BI to Source Files

Lecture 5: What is Query Editor & how to work with Query Editor

Lecture 6: What is Data Model & How to create your first Visual

Lecture 7: Useful Resources

Chapter 2: Day 3 – 4 : Power BI Desktop : Introduction

Lecture 1: Introduction

Lecture 2: How to use Course resources

Lecture 3: Understand Power BI Desktop workflow

Lecture 4: Understand the interface of Data Model & Query Editor

Lecture 5: How to create Project Files & recommended settings

Lecture 6: Useful Resources

Chapter 3: Day 5 – 6: Query Editor : All about Query Editor & interface

Lecture 1: Connect source files to Power BI Desktop

Lecture 2: Data Transformation – Keeping & Removing rows, Remove Empty Rows

Lecture 3: Append Queries, Working with Columns – Rename Columns, Replacing Values

Lecture 4: How to Format Data & Handling Formatting Errors

Lecture 5: How to Pivot and Unpivot data

Lecture 6: How to Split Data

Lecture 7: Create Groups & Clean up project

Lecture 8: What we learned and Next steps

Chapter 4: Day 7- 10 : Part II : Query Editor

Lecture 1: What is Star Schema?

Lecture 2: How to use Star Schema in our Project

Lecture 3: What is Query Duplicates & References?

Lecture 4: Creating Dimension Table – DIM Region table & Remove duplicates

Lecture 5: Understanding Merging Queries – Theory

Lecture 6: Merging Queries – Practically

Lecture 7: What is Join Kind? Theory

Lecture 8: Merging Queries Applied & Finish Dimension Table – DIM Region table

Lecture 9: Solution to Merge issue in Previous Lecture

Lecture 10: Take a Break – Understand Next steps

Lecture 11: Creating Dimension table – Creating DIM-Age table

Lecture 12: What is FACT table & How to Create FACT table

Lecture 13: Speed up the performance of our Project

Chapter 5: Day 11 – 14 : Data Model Part I : Data & Relationship View

Lecture 1: Module Introduction

Lecture 2: What is relationships?

Lecture 3: What is Cardinality? Understand Types of Cardinality

Lecture 4: Cross Filter Direction & Active Properties & its Use

Lecture 5: What is M Language? What is DAX?

Lecture 6: Difference between M and DAX with Practical Example

Lecture 7: Basics of DAX and its syntax

Lecture 8: Understand DAX Data Types

Lecture 9: Understand Operators & DAX Functions

Lecture 10: Calendar Function Example

Lecture 11: Apply DAX basics practically

Lecture 12: Understanding IF & Related

Lecture 13: What is Calculated Columns and Measures & Its Difference & Create First Measure

Lecture 14: CALCULATE & FILTER Understanding

Lecture 15: Calculate & Filter – Practically

Lecture 16: Conclusion

Lecture 17: Useful Resources

Chapter 6: Day 15 – 17 : Visuals in Report View

Lecture 1: Module Introduction

Lecture 2: Basic Visual Concepts

Lecture 3: Creating our First Visuals

Lecture 4: Understanding Tooltips & Interactions

Lecture 5: Diving into Hierarchies & Drill Mode

Lecture 6: Data Colors & Conditional formatting

Lecture 7: Formatting Reports

Lecture 8: Formatting report pages & Visuals

Lecture 9: Working with Report themes

Lecture 10: What is Slicer and its Use

Lecture 11: Default Summarization & Sorting

Lecture 12: Working with Treempas & Tables & Syncing Slicers

Lecture 13: Filter Types : Visual, Page & Report

Lecture 14: Working with Row cards

Lecture 15: Creating Combined Visuals & Waterfalls

Lecture 16: Using Custom Visuals

Lecture 17: Conclusion

Lecture 18: Useful Resources

Chapter 7: Day 17 – 18 : Power BI Pro (Service) : Move the project to Cloud

Lecture 1: Module Introduction

Lecture 2: Need of Power BI Pro (Service) & Service vs Pro vs Premium

Lecture 3: How to Register for Power BI Pro

Lecture 4: Alternative to non-business emails

Lecture 5: Explore Power BI pro Interface

Lecture 6: Connecting Power BI Pro & power BI Desktop

Lecture 7: Understanding Datasets in Power BI Pro & Work with reports

Lecture 8: Creating Dashboards

Lecture 9: Refreshing Data with Gateways

Lecture 10: Sharing and Collaboration

Lecture 11: Working with Power BI Mobile

Lecture 12: Conclusion

Chapter 8: Day – 19 Other Data Sources

Lecture 1: How to Import JSON Data

Lecture 2: Importing Data from REST APIs

Lecture 3: Setting up mySQL Server

Lecture 4: Importing data from mySQL Server

Lecture 5: Conclusion

Chapter 9: Day -19 Stay updated with Power BI World

Lecture 1: Introduction

Lecture 2: Helpful Resources

Chapter 10: Day 20 – 21 : Custom Visuals : Power BI for developers

Lecture 1: Module Introduction

Lecture 2: The required Technologies & Tools