Complete Microsoft Power Bi Master Class – 2022 Expert Guide

Course Curriculum

Chapter 1: Course Introduction

Lecture 1: Introduction to Microsoft Power BI Data Analysis & Data Visualization Course

Lecture 2: Download & Install – Microsoft Power BI Desktop

Lecture 3: Download – Microsoft Power BI supporting files (Practice files used)

Lecture 4: 11 reasons why you should learn and use Power BI.

Chapter 2: An Introduction to Power BI and Power Query (M Language)

Lecture 1: Overview of Power BI Desktop Interface

Lecture 2: Power BI data sources and how to connect them

Lecture 3: Connect to data sources like Excel, CSV and Website

Lecture 4: Connecting to other data sources

Lecture 5: Combine data from multiple excel files – Use Query Editor to reduce data set

Lecture 6: Power Query Editor – An overview

Lecture 7: M Query Language – An Overview

Lecture 8: Renaming, Editing and Error handling in Power Query advanced editor

Lecture 9: Consolidate and add custom data types in Power BI using M formula language

Lecture 10: Change data types, replace values, group data, transpose and unpivot

Lecture 11: Text column functions (split , format, merge and extract columns)

Lecture 12: Append data to a query, Insert custom columns and index column

Lecture 13: Build relation between tables, merge data, show and hide queries

Lecture 14: Lookup tables in a data set

Lecture 15: Adding Text Formulas in Custom Columns and Conditional Formulas

Lecture 16: Power Query List function

Lecture 17: Groupby aggregation and find sum by unique column values in Power Query

Lecture 18: Date Function in Power Query

Lecture 19: Number Functions in Power Query

Lecture 20: Percentage, Percent of, Fill Up and Fill Down in Power Query

Lecture 21: Add Prefix and Suffix to a Text in Power Query

Lecture 22: Dynamically Merge Related Data Spilled Out in Different Columns

Lecture 23: How to GroupBy All Rows in Power Query

Lecture 24: 3 Ways to Extract Text and Numbers from a string using Power Query

Lecture 25: Reduce row data with Power Query

Lecture 26: Get Top N records using List .Range function in Power Query

Lecture 27: IF Error function in Power Query

Lecture 28: Merge tables based on conditions

Lecture 29: Power Query Let and Nested Let statement

Lecture 30: Create Functions in Power Query – Part 1

Lecture 31: Create Functions in Power Query – Part 2

Lecture 32: How to Add Parameters in a Data Table using Power Query

Lecture 33: Group By Maximum Value in a table using Power Query

Lecture 34: How to use Fill Up or Fill Down in your data based on conditions

Lecture 35: How to Index columns in Power Query to get value of previous row

Lecture 36: How to do conditional join or conditional merge using Power Query

Lecture 37: How to use IF Function in Power Query

Lecture 38: Dynamically change column names using Power Query

Lecture 39: How to create a delimited list in Power Query

Lecture 40: Create Dynamic Start date & End date for data tables in Power Query

Lecture 41: Match data based on Approximate or Close Match in Power Query

Lecture 42: How to Combine tables with Different Columns

Lecture 43: How to work with Nulls or Blank values in Power Query

Lecture 44: How to create a Dynamic Calendar table in Power Query

Lecture 45: How to Pivot data in Power Query

Lecture 46: How to Filter data based on Multiple Criteria using Power Query

Lecture 47: How to Summarize and Group data using Power Query

Lecture 48: Dynamically Rank with Ties in Power Query

Lecture 49: How to convert multiple Columns in to Rows

Lecture 50: How to calculate Running Totals in Power Query

Lecture 51: How to Stack Data from Columns to Rows in Power Query

Lecture 52: Rename and Sort multiple column in Power Query

Lecture 53: Find TopN rows in each group using Power Query

Lecture 54: For Each Group create a Row Number using Power Query

Lecture 55: Retain recent records and remove duplicate records

Lecture 56: How to perform VLOOKUP in Power Query

Lecture 57: Extract Min date & Max date for column category dynamically

Lecture 58: Create Unique Combinations From Multiple Column Values

Lecture 59: How to Unstack data from Uneven Rows to Separate Columns

Lecture 60: How to create a Date Time column in power query

Lecture 61: How to reverse Running Totals in Power Query

Lecture 62: Dynamic Filters in Power Query

Lecture 63: How to add an index column to subgroups

Lecture 64: How to use Custom Function In Power Query

Lecture 65: How to Extract data from Top Rows using Power Query

Lecture 66: Define Data Types and Define Dynamic Data Types

Lecture 67: How to create hierarchies in Power Query

Lecture 68: How to use SUMIF between two table using Power Query

Lecture 69: How to Remove Empty Columns Dynamically in Power Query

Lecture 70: VLOOKUP based on Fuzzy Matching in Power Query

Lecture 71: How to convert a date to Fiscal Periods with Power Query

Lecture 72: How to create Conditional Columns in Power Query

Lecture 73: How to do a full Anti Join in Power Query

Lecture 74: How to add Zeros before Numbers in Power Query

Lecture 75: How to Count the number of times a value appears in a column in Power Query

Lecture 76: Unpivot data Dynamically in Power Query

Lecture 77: Change column names dynamically in a visual using slicer in Power BI

Lecture 78: Complete Hidden Function List in Power Query

Lecture 79: An overview of Power BI Report View (Filters, Visualizations, Fields)

Lecture 80: An overview of Visualizations (Text, chart, Cards, Table, Slicer, Filters)

Lecture 81: Q&A feature in Power BI

Chapter 3: Data Modeling and Data Analysis using Data Analysis Expressions (DAX )

Lecture 1: An overview of Data Analysis Expressions (DAX) – Data Modeling and Data Visualiz

Lecture 2: Import data and Create Relationships – Transform data using DAX

Lecture 3: DAX Lookup function – Add a calculated column and get details from a lookup fiel

Lecture 4: Create a DAX function with calculated column to find Product of two column

Lecture 5: Create a DAX function with calculated column to Divide & find difference of two

Lecture 6: DAX Aggregate Functions such as SUM, SUMX

Lecture 7: DAX Aggregate Functions such as MIN, MAX

Lecture 8: DAX Aggregate Functions AVERAGE

Lecture 9: Visualization – Create a Simple Dashboard

Lecture 10: COUNT, COUNTA, COUNTAX, COUNTROWS, COUNTX, COUNTBLANK & DISTINCTCOUNT

Lecture 11: DAX Logical Functions such as AND, OR, NOT, IF, NESTED IF, IFERROR, TRUE, False

Lecture 12: DAX Text Functions such as COMBINEVALUES, SEARCH, FIND, EXACT and TRIM