Ultimate Microsoft Power BI Course – From Beginner to Pro

Microsoft Power BI, DAX, Data Visualization

Created bySandeep Pendyala

Last updated 11/2025

English

What you'll learn

Connect to and import data from various sources using Power BI Desktop
Clean and shape data using Power Query Editor for better analysis, Create relationships between tables to build efficient data models
Master DAX to create custom calculations and advanced data models for powerful analytics.
Build interactive dashboards using Power BI Desktop and transform raw data into meaningful insights.
Design effective visualizations and publish reports to Power BI Service and Report Server.
Integrate R and Python scripts in Power BI for advanced analytics and data science workflows
Reinforce learning with hands-on projects, quizzes, and assignments designed to test your skills and apply knowledge in real-world scenarios.
Complete a capstone project using real data to build a model, write DAX, and publish an interactive report to Power BI Service.

Course content

4 sections • 103 lectures • 7h 8m total length

Introduction to Business Intelligence and Course Outline5:48
Introduction to Power BI11:07
PL-300 Exam5:31
Section Review0:45
Quiz on Introduction to Business Intelligence

Installing Power BI Desktop3:46
Power BI Settings2:38
Working with Power BI3:33
Assignment - Case Study on Global SuperStore Dataset1:26
Solution - Case Study Explanation - Understanding Global Super Store dataset3:29
First Report - Loading Data to Power BI1:13
7 - Power BI Desktop features5:37
8 - Data Cleansing - First Row as header3:40
9 - Data Cleansing - Removing Unnecessary columns2:50
10 - Data Cleansing - Renaming Columns1:05
11 - Assignment - Load 3rd sheet1:45
12 - PDF Data Source and Renaming Table4:21
13 - Fixing Typographical Errors in Data1:10
14 - Splitting a column into multiple columns and renaming column3:16
15 - AutoSave Functionality & Loading data back to Power Query Editor2:59
16 - Merge Column Transformation2:06
17 - Understanding Datatypes in Power Query Editor - Changing Data Types4:05
18 - Understanding pbix file size and Auto Compressing functionality4:30
19 - Folder Data Source8:19
20 - Folder Data Source - Continued3:26
21 - Introduction to OData4:34
22 - Assignment - Case Study - OData feed0:28
23 - Solution - Case Study Explanation - OData feed5:06
24 - OData feed Data Cleansing2:33
25 - OData feed report - first report2:20
26 - Refresh, Verify Primary Key3:17
27 - Date Datatype conversion, Add Column to extract year from date3:52
28 - Data Transformation - Adding Prefix. Extract Quarter from date using add co2:47
29 - Data Transformation - Merge Columns2:31
30 - Data Transformation - Merge Tables or Merge Queries6:03
31 - Data Transformation - Merge Table Revision, Copying table to excel4:56
32 - Replacing Null with NA & Using Goto column to navigate to a column & Column6:09
33 - Data Transformation - Calculated Columns using conditional columns2:46
34 - Conditional Column Continued2:46
35 - Rounding2:32
36 - Blank Query, Assignment of Blank Query6:01
37 - Blank Query Assignment Solution5:29
38 - Data Transformation - Column Filters, Duplicate Table, Group by, Assignment3:36
39 - Multi Column Group By Assignment Solution2:32
40 - Reference Table, difference between reference table and duplicate table5:13
41 - Case Study - Understanding New Data Source1:20
42 - Append Query11:10
43 - Append Query Assignment4:02
44 - Append Query Assignment Solution, Remove Duplicate data4:11

1 - Introduction to DAX and Relationships between tables in Power BI10:47
2 - Demo - Need for Relationship5:24
3 - Relationships vs Merge columns2:06
4 - Fact and Dimension Tables5:47
5 - New Column3:56
6 - New Column - If Condition3:55
7 - New Column - Nested If Statement2:22
8 - New Column - Switch Statement4:15
9 - New Column - RELATED Function2:54
10 - New Column - ISBLANK Function3:22
11 - New Column - DATEDIFF Function2:48
12 - New Column - SWITCH Statement2:56
13 - Quiz2:00
14 - Calculated Tables - SUMMARIZE Function, SUM Function4:34
15 - Calculated Tables - SUMMARIZE Function, COUNT Function2:45
16 - Introduction to Star Schema, Date Dimension Table2:17
17 - Date Dimension Table Creation - CALENDAR Function4:48
18 - Date Dimension Table - Formatting Date Using Column Tools1:21
19 - Date Dimension Table - New Columns Inside Calculated Table - Date functions4:27
20 - Establishing relationship to Date Dimension Table2:06
21 - Dim Date Dimension Table - Format Function1:15
22 - Introduction to Time Intelligence Functions - Measures1:59
23 - Time Intelligence Functions - Measures - SUM Function3:31
24 - Time Intelligence Functions - Measures - COUNT, DISTINCT COUNT Function4:09
25 - Time Intelligence Functions - Measures - CALCULATE Function3:04
26 - Time Intelligence Functions - Measures - Total Sales, CY Sales using SUM &3:13
27 - Quiz2:45
28 - Blank Table using Create Table feature2:06
29 - Previous Year Sales - Same Period Last Year using CALCULATE Function5:07
30 - Setting Home table for all measures and Assignment2:25
31 - Assignment Solution and DIVIDE Function3:36
32 - LY Sales - Full Year Using CALCULATE Function3:40
33 - Introduction to FILTER Function1:56
34 - Targetted Tables Using CALCULATETABLE, FILTER Function2:40
35 - Smart Logic Using CALCULATE, SUM, COUNT, FILTER Function4:08
36 - Custom Time Intelligence Functions - Using CALCULATE, SUM, FILTER Function4:01
37 - Flexible Date Filter - Using CALCULATE, SUM, FILTER Function, AND Logic2:17
38 - Iterator Functions6:11
39 - ALL Function6:13

1 - Introduction to Power BI Data Visualizations2:22
2 - Power BI Data Visualizations and Desgin Techniques4:04
3 - Setting up Microsoft Developer Account7:15
4 - First Blank Dashboard using shapes, images, text boxes8:51
5 - Card Visualization5:57
6 - Card Visualization Continuation2:18
7 - Built In Filters4:05
8 - Slicers6:15
9 - Slicers Continuation9:32
10 - Line Chart10:38
11 - Line Chart Continuation6:52
12 - Donut Chart5:38
13 - Stacked Bar chart - Top 10 Customers by Sales3:51
14 - Stacked Bar Chart Custom formatting and Assignment11:14
15 - Assignment Solution - Date Slicer3:32
16 - Matrix Visualization12:03

Requirements

Windows PC (Power BI currently not available on Mac)

Description

Welcome to the Ultimate course on Microsoft Power BI. Where you can unlock the power of data and transform raw information into compelling visual stories!

This comprehensive Microsoft Power BI course is designed for beginners and aspiring data professionals who want to build real-world analytics skills and create stunning, interactive dashboards that drive smarter business decisions.

Whether you’re a business analyst, student, manager, or simply someone looking to upgrade your career, this course provides a hands-on path to becoming confident and job-ready in Power BI.

What You’ll Learn

Build beautiful, interactive dashboards from scratch
Import, clean, and shape data using Power Query
Create powerful data models and relationships
Use DAX formulas to perform advanced calculations
Transform messy datasets into meaningful insights
Publish and share dashboards across your organization
Apply best practices for design, performance, and usability

Why This Course Stands Out

Instead of overwhelming you with technical jargon, this course is structured to teach Power BI the way professionals use it in the real world. Every concept is reinforced through practical examples, step-by-step explanations, and projects you can immediately apply at work.

You’ll learn not just how Power BI works, but why—so you can approach data analysis with confidence, clarity, and creativity.

Perfect For:

Beginners with no prior Power BI experience

Students and professionals wanting a data-driven career

Business users looking to level up their analytics skills

Anyone who wants to make better decisions using data

By the End of This Course, You Will Be Able To:

Build dynamic dashboards that impress stakeholders
Analyze trends, patterns, and KPIs with ease
Automate manual reporting tasks
Present insights with clarity and impact
Use Power BI like a data analytics pro

Who this course is for:

For Everyone, From Any Background – Whether you're in tech, business, or just data-curious, this course makes Power BI easy, practical, and powerful for all.
Students and Graduates looking to build in-demand data skills and boost their career prospects.
IT Professionals who want to expand into data analysis and business intelligence.
Beginners in Data Analysis eager to learn how to turn data into actionable insights using Power BI.
Entrepreneurs and Small Business Owners who want to visualize data and make smarter business decisions.
Business Executives and Managers seeking to understand dashboards and leverage data-driven strategies.
Curious Minds who love data and want to explore the world of analytics and visualization tools.

Ultimate Microsoft Power BI Course – From Beginner to Pro

What you'll learn

Explore related topics

Course content

Getting Started4 lectures • 23min

Power BI Desktop44 lectures • 2hr 41min

Data Analysis Expressions (DAX)39 lectures • 2hr 19min

Power BI Data Visualization16 lectures • 1hr 44min

Requirements

Description

Who this course is for: