Name: Microsoft Power BI - beginners to advance Level Exam PL-300
Rating: 4.6 (89 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byAdnan Ali

Last updated 3/2026

English

What you'll learn

Build professional business intelligence reports from the ground up
While working on real world project, clean and Transform raw data into professional interactive dashboards and Reports
Data Analytics Expressions (DAX), Data Modelling, Creating and managing relationships among tables
Data Visualisation using Microsoft Power BI Desktop & Service
Creating and managing workspace, Apps, data refreshes , assigning roles and other settings
Become Master in Microsoft Power BI Desktop and Service

Course content

7 sections • 158 lectures • 15h 44m total length

Introduction - What to expect from the course4:13
Know Your Trainer1:21
Download Resources1:57
Downloading & Installing Power BI Desktop4:11
Introduction to Power BI Desktop Interface5:42

Connecting to Data3:01
Remove Rows from Table5:20
Adjusting or Changing Data Types of Columns2:42
Adding Index Column and understanding alternate rows removal5:45
How to Keep Rows3:35
Choose Columns1:43
Renaming Columns1:46
Column Sorting0:50
Column Profiling and Distribution6:20
How to enable column profiling and distribution for entire rows in table1:28
Concept of Appending Tables1:40
Appending Queries3:49
Adjusting Column Data Types in our Project3:12
Splitting a Column3:06
Arithmetic on Column1:04
Adding a Conditional Column2:23
Merging Queries - Price Column4:47
Understanding & Exploring different mergers available in Power BI20:47
Adding a Custom Column1:42
Adding Column by Example3:28
Duplicating a Column1:06
Column Formatting5:47
Extracting from a Column5:01
Scientific Calculations on a Column3:34
Trigonometric Calculations on a Column1:12
Rounding Numbers in a Column2:05
Information on Columns2:00
Date & Time Column Transformations14:58
Group By Transformation6:56
Transpose of a Table2:31
Reversing Rows of a Table1:32
Count Rows0:35
Fill Rows3:00
Pivot columns3:39
Unpivot Columns4:08
Data Cleaning & Transformation
Data Cleaning and Transformation in Power query Editor

Introduction to DAX3:37
Understanding Time Intelligence Part 11:41
Understanding Time Intelligence Part 22:23
Date Table by Calendar ( ) Function7:51
Date Table by CalendarAuto ( ) Function3:34
Understanding and Creating Date Hierarchies in Date Table5:30
Extracting Year with Year ( ) Function2:20
Extracting Month with Month ( ) Function3:18
Extracting Week number with Weeknum ( ) Function3:37
Extracting Quarter number with Quarter Function2:02
Implementing Date Hierarchies Manually4:17
Creating a Separate Table for Measures1:50
DAX Function SUM ( )4:20
DAX Functions MAX ( ) & MIN ( )6:15
DAX Function COUNTROWS ( ) & AVERAGE ( )7:41
DAX Function CALCULATE ( )12:38
DAX Function TOTALYTD ( )9:51
DAX Function DATEADD ( )6:29
DAX , Arithmetic among measures5:08
DAX Function IF ( ) Part 113:04
DAX Function IF ( ) Part 23:23
DAX Function SWITCH ( )8:15
DAX VARIABLES8:05
DAX Functions FIRSTNONBLANK ( ) and LASTNONBLANK ( )13:44
Explore DAX FIRSTNONBLANK and LASTNONBLANK in Power BI to derive opening and closing stock per month by filtering for non-blank dates.
Adjusting Stock Table Dates Hierarchy1:41
DAX Function SAMEPERIODLASTYEAR ( )9:30
Data Model View - Properties pane and Display Folders10:21
Data Model View - Properties pane Continue6:47
What is Data Modeling?2:37
Why Data Modeling?6:00
Types of Data Model9:20
What is Cardinality? one-to-many Relation7:08
Cardinality - one-to one Relation4:51
Cardinality - many-to-many3:44
Hiding Tables using Model View2:43
Data modeling for our Project - Part 14:35
Data modeling for our Project - Part 223:22
Data Modelling and DAX

Giving Stylish Heading to Dashboard - Shapes & Text4:33
Deploying Card Visual and its formatting6:46
Card Visual with Currency Sign1:32
Deploying 2nd Card Visual4:53
Quick Deployment of Card Visual with formatting copied - adding one more measure4:26
Deploying Line Chart3:38
Formatting the Visuals e.g. Line Chart - Part 18:00
Demonstrates formatting a Power BI line chart, using focus mode and date hierarchy to drill up and down, and adjusting x/y axes, legends, colors, and fonts in the visualization pane.
Formatting the Visuals e.g. Line Chart - Part 214:16
Formatting the Visuals e.g. Line Chart - Part 310:37
Deploying Column Clustered Chart with Hierarchical X-Axis10:09
Understanding Filter Context and Relationships in Data Model View3:17
Deploying Donut Chart5:52
Star Schema Data Model Flexibility and Dataset Adjustment9:32
Adding Constant Lines in Line Chart8:37
Enabling Map Visuals from Settings1:16
Deploying Filled Map Visual8:27
Map Visual3:28
Deploying Area Chart Visual5:21
Deploying Area Chart Visual for YTD Values4:52
Visualising Top 10 Products by Sales5:36
Deploying Waterfall Chart Visual9:47
Visualising further Sales KPIs using Cards3:14
Adding Realistic Target in our Dataset6:23
Deploying KPI Card Visual and a Slicer15:03
Slicer Interaction Explained5:45
Interaction among visuals Explained5:29
Controlling or Editing Interactions among Visuals6:29
Deploying Table Visual11:22
Deploying Matrix Visual8:16
Conditional Formatting of a Column of Table6:03
Conditional Formatting of Column Chart Visual6:59
Deploying AI Visual - Q&A7:35
Understanding AI Visual - Key Influencers3:53
Deploying AI Visual - Key Influencers11:42
Book Marks11:15
Adding Real Targets in Line Graph Visual8:13
Introducing the Advance Tool Tip4:45
Implementing the Advance Tool Tip11:57
Use of Parameters8:45
Navigation Buttons3:33
Implementing Drill Through Report Pages11:04
What is Grouping?7:36
What is Binning?8:17
Themes for the Report7:33
Mobile Layout of the Report6:34
Implementing Pro-Custom Filter Pane Part 17:18
Implement a pro custom filter pane in Power BI to house slicers and filters in a collapsible panel, updating charts as you apply key accounts and clothing.
Implementing Pro-Custom Filter Pane Part 225:03
Pro Tip - Copying entire Custom filter pane Part - 15:02
Pro Tip - Copying entire Custom filter pane Part - 24:15
Formatting Slicer as per theme2:05
Page Formatting2:11
Editing interaction of slicers with visuals in our Project2:20
Implementing Special Button - Clear All Filters3:39
Assignment 2: Data Modelling, DAX and Visualisation
Data Visualisation , Reports and Dashboards

Introduction to Power BI Service3:22
Power BI Service License Types7:54
Signing into Power BI Service and Workspaces3:28
Creating a Worksapce2:37
Publishing Report in Power BI Service Workspace5:09
Sharing Reports with others in Power BI Service3:05
Workspaces, Apps and User Roles5:55
128. Managing Access to Workspace and Assign roles3:41
Dashboard in Power BI Service5:42
Creating and Sharing Power BI App10:26
Updating App Contents3:11
Managing Access to App2:10
Alerts, Subscription and downloading of Reports9:31
What is On-Premises Data Gateway ?4:47
Removing Existing Data Gateway1:39
Deploying Data Gateway and Scheduling Auto Refresh16:13
Understanding & Implementing Row Level Security (RLS)8:01
Row Level Security (RLS) Configuration in Power BI Service3:23
Dynamic Row Level Security (RLS)7:17
Understanding Incremental Refresh3:26
Implementing Incremental Refresh15:22
Getting Quick Insights on Dataset from Power BI Service3:37
Endorsement of Semantic Models etc4:00
Performance Analyzer7:23
Tips to Enhance Report Performance5:28
Power BI Service : Publishing and Managing Assets

Requirements

No Prior experience required with Power BI to take this course. I will take you from begining till advance level one step a time so that by the end of this course you will be self sufficient to do data analysis and all associated steps in MS Power BI. Just Have a Laptop/Desktop and you are ready to go to become Master of MS Power BI

Description

Welcome to this comprehensive Microsoft Power BI Course for business intelligence and data analytics. Designed by industry expert trainer and professional in the field of Data analysis using power bi , in such a way that it takes the learners from beginner’s level to advance level step by step. This course implements real-world project, guiding you through the creation of interactive reports and dashboards from scratch. Aligned with the PL-300 certification exam, offering practice test aligned with exam, our curriculum covers all the features of MS Power BI while providing insider tips on effective visualisation techniques, such as deploying custom filter panes.

Our Claim is that once you learned using this course, you will not be needing to buy any other course for MS Power BI, it is so comprehensively designed. It will also help you to earn microsoft power bi data analyst professional certificate

Throughout the program, you'll dive into practical scenarios, transforming raw data into dynamic reports that uncover sales trends, campaign performance, product analytics, and regional revenue insights. Starting with an introduction to Power BI Desktop, you'll gain mastery over its interface, learning data cleaning and transformation techniques to prepare your datasets effectively. It is a well designed power bi training

Delving deeper, you'll explore data modeling, understanding relationships, cardinality, and filter contexts to build flexible data models. Leveraging Data Analysis Expressions (DAX), you'll create dynamic measures and calculated columns, extracting valuable insights from your data. Our course emphasises the importance of effective visualisation, guiding you through the deployment of various Power BI visuals, including AI-powered options, and optimising report performance for responsiveness and speed.

A highlight of this course is the transition from Power BI Desktop to Power BI Service, where you'll learn to collaborate and share reports securely in the cloud. From data security concepts to configuring auto-refresh schedules, you'll ensure your reports are always up-to-date and accessible to relevant stakeholders. By course completion, you'll possess the skills to develop advanced, interactive reports and dashboards independently, preparing you for success in both professional endeavours and the PL-300 certification exam.

Who this course is for:

Data related Professionals or Students who want to learn Data Cleaning, Transformation, Modelling, DAX, visualisation using MS Power BI with deployment and managing assets in MS Power BI Service

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 17min

Data Cleaning and Transformation with Power BI Desktop35 lectures • 2hr 17min

Data Modelling and Data Analytics Expression (DAX)37 lectures • 3hr 54min

Data Visualisation and Creating Dynamic Reports and Dashboards53 lectures • 6hr 15min

Power BI Service : Publishing and Managing Assets25 lectures • 2hr 27min

Additional Content3 lectures • 36min

Practice Test Aligned with PL-300 Exam0

Requirements

Description

Who this course is for: