Power BI Course: Beginner to Pro | PL-300 Exam Aligned - Adot BI Analytics

About Course

Welcome to this complete Power BI course, designed for anyone looking to excel in business intelligence and data analytics. An industry expert has carefully crafted this course to take you step-by-step from beginner to advanced levels, ensuring you gain practical skills.

You will start by working on a real-world project, where you’ll learn to create interactive reports and dashboards from scratch. The course aligns with the Microsoft Certified Data Analyst Associate PL-300 certification exam and covers all the important features of Power BI. You’ll also discover insider tips, such as using custom filter panes to improve report interactivity.

Throughout the course, you will tackle practical business scenarios. For instance, you’ll transform raw data into dynamic reports that reveal insights into sales trends, campaign performance, product analytics, and regional revenue. These projects will help you apply Power BI in real-world situations, giving you the confidence to use it professionally.

What You Will Learn

Power BI Desktop: You’ll begin by exploring the interface. You’ll also learn how to clean and transform your data to make it ready for analysis.
Data Modelling: Next, you’ll build flexible models. You will understand relationships, cardinality, and how to manage filter contexts effectively.
DAX (Data Analysis Expressions): Afterwards, you’ll work with DAX to create dynamic measures and calculated columns. You will gain the ability to extract deeper insights from your data.
Visualisation Skills: As you progress, you’ll explore various Power BI visuals, including AI-powered visuals. You’ll also learn how to optimise your reports to make them faster and more responsive.
Power BI Service: Finally, you’ll move from Power BI Desktop to the cloud-based Power BI Service. You will learn how to share and collaborate on reports, while also ensuring they are secure and always up-to-date with auto-refresh schedules.

By the end of this course, you will be able to develop advanced, interactive reports and dashboards on your own. You’ll be well-prepared to take on professional projects and confidently pass the PL-300 certification exam.

Additional Benefits of This Course

You’ll learn through practical, hands-on projects that mirror real-world scenarios.
The course is designed for both beginners and advanced learners, so no prior experience with Power BI is required.
You’ll also gain valuable insights into Power BI best practices, which will make your reports stand out.
Our support team is available to assist you throughout your learning journey, so you’ll never feel stuck.

By enrolling in this course, you’ll equip yourself with the skills to create impactful business reports, making you a valuable asset in any organisation. Don’t miss this opportunity to master Power BI and accelerate your career!

Build professional business intelligence reports from the ground up
While working on real world project, clean and Transform raw data into professional interactive dashboards
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

Introduction
Here is the introduction to this power bi course. It will take you through the contents at high level and will clear expectations about the course.

Introduction – What to expect from the course

04:13
Know you trainer

01:21
Download Rescourses

01:58
Downloading & Installing Power BI Desktop

04:11
Introduction to Power BI Interface

05:43

Data Cleaning and Transformation with Power BI Desktop
After getting the things ready as guided in introduction section. Now its time to master the power query editor to clean and transform the data for flexible data modelling ,visually appealing and insight full reports and dashboard.

Connecting to Data

03:02
How to Remove Rows from table

05:21
Adjusting or Changing Data Types of Columns

02:42
Adding Index Column and understanding alternate rows removal

05:45
How to Keep Rows

03:36
How to Choose Columns

01:43
Renaming Columns

01:46
Column Sorting

00:50
Column Profiling and Distribution

06:21
How to enable column profiling and distribution for entire rows in table

01:29
Concept of Appending Tables

01:41
Lets Append Tables

00:00
Adjusting Column Data Types in our Project

03:13
Splitting a Column

03:06
Arithmetic on Column

01:05
Adding a Conditional Column

02:23
How to merge tables on columns

04:47
Understanding & Exploring different mergers available in Power BI

20:48
How to add a Custom Column

01:42
How to add Column by Example

03:28
How to duplicate a Column

01:07
Column Formatting

05:48
Extracting from a Columns

05:02
How to Perform Scientific Calculations on a Column

03:34
Trigonometric Calculations on a Column

01:13
Rounding Numbers in a Column

02:05
Information on Columns

02:00
Date & Time Column Transformations

14:58
Group By Transformation

06:56
Transpose of a Table

02:32
Reversing Rows of a Table

01:32
How to Count Rows

00:36
How to Fill Rows

03:01
Pivot columns

03:40
Unpivot Columns

04:08
Data Cleaning & Transformation
Assignment No: 1

Data Modelling and Data Analytics Expression (DAX)
It's time to gain knowledge about various data models and acquire proficiency in creating data models within Power BI. Additionally, let's develop and enhance skills in crafting DAX expressions to extract insights from cleaned and transformed data.

Introduction to DAX

03:37
Understanding Time Intelligence Part 1

01:41
Understanding Time Intelligence Part 2

02:24
Date Table by Calendar ( ) Function

07:51
Date Table by CalendarAuto ( ) Function

03:35
Understanding and Creating Date Hierarchies in Date Table

05:31
Extracting Year with Year ( ) Function

02:20
Extracting Month with Month ( ) Function

03:19
Extracting Week number with Weeknum ( ) Function

03:37
Extracting Quarter number with Quarter Function

02:02
Implementing Date Hierarchies Manually

04:18
Creating a Separate Table for Measures

01:51
DAX Function SUM ( )

04:20
DAX Functions MAX ( ) & MIN ( )

06:16
DAX Function COUNTROWS ( ) & AVERAGE ( )

07:41
DAX Function CALCULATE ( )

12:38
DAX Function TOTALYTD ( )

09:52
DAX Function DATEADD ( )

06:30
DAX , Arithmetic among measures

00:00
DAX Function IF ( ) Part 1

13:05
DAX Function IF ( ) Part 2

03:24
DAX Function SWITCH ( )

08:16
DAX VARIABLES

00:00
DAX Functions FIRSTNONBLANK ( ) and LASTNONBLANK ( )

13:45
Adjusting Stock Table Dates Hierarchy

00:00
DAX Function SAMEPERIODLASTYEAR ( )

09:31
Data Model View – Properties pane and Display Folders

10:21
Data Model View – Properties pane Continue

00:00
What is Data Modeling?

02:37
Types of Data Model

00:00
What is Cardinality? one-to-many Relation

07:09
Cardinality – one-to one Relation

00:00
Cardinality – many-to-many

00:00
Hiding Tables using Model View

00:00
Data modeling for our Project – Part 1

00:00
Data modeling for our Project – Part 2

00:00
Data Modelling and DAX

Data Visualisation and Creating Dynamic Reports and Dashboards
Let's gain proficiency in crafting accurate visual representations of datasets to ensure clarity and comprehension for end users. Deploying appropriate visualisations is crucial for end users to make informed decisions.

Giving Stylish Heading to Dashboard – Shapes & Text

04:33
Deploying Card Visual and its formatting

06:46
Card Visual with Currency Sign

01:33
Deploying 2nd Card Visual

04:53
Quick Deployment of Card Visual with formatting copied – adding one more measure

04:26
Deploying Line Chart

03:39
Formatting the Visuals e.g. Line Chart – Part 1

08:00
Formatting the Visuals e.g. Line Chart – Part 2

14:16
Formatting the Visuals e.g. Line Chart – Part 3

10:37
Deploying Column Clustered Chart with Hierarchical X-Axis

10:09
Understanding Filter Context and Relationships in Data Model View

03:17
Deploying Donut Chart

05:52
Star Schema Data Model Flexibility and Dataset Adjustment

09:32
Adding Constant Lines in Line Chart

08:37
Enabling Map Visuals from Settings

01:17
Deploying Filled Map Visual

08:27
Map Visual

03:28
Deploying Area Chart Visual

05:21
Deploying Area Chart Visual for YTD Values

04:52
Visualising Top 10 Products by Sales

05:36
Deploying Waterfall Chart Visual

09:47
Visualising further Sales KPIs using Cards

03:15
Adding Realistic Target in our Dataset

06:23
Deploying KPI Card Visual and a Slicer

15:03
Slicer Interaction Explained

05:46
Interaction among visuals Explained

05:29
Controlling or Editing Interactions among Visuals

06:29
Deploying Table Visual

11:22
Deploying Matrix Visual

08:16
Conditional Formatting of a Column of Table

06:03
Conditional Formatting of Column Chart Visual

06:59
Deploying AI Visual – Q&A

07:35
Understanding AI Visual – Key Influencers

03:53
Deploying AI Visual – Key Influencers

11:42
Book Marks

11:15
Adding Real Targets in Line Graph Visual

08:13
Introducing the Advance Tool Tip

04:45
Implementing the Advance Tool Tip

11:57
Use of Parameters

08:45
Navigation Buttons

03:33
Implementing Drill Through Report Pages

11:04
What is Grouping?

07:36
What is Binning?

08:17
Themes for the Report

07:33
Mobile Layout of the Report

06:34
Implementing Pro-Custom Filter Pane Part 1

07:18
Implementing Pro-Custom Filter Pane Part 2

25:03
Pro Tip – Copying entire Custom filter pane Part – 1

05:02
Pro Tip – Copying entire Custom filter pane Part – 2

04:15
Formatting Slicer as per theme

02:06
Page Formatting

02:11
Editing interaction of slicers with visuals in our Project

02:20
Implementing Special Button – Clear All Filters

03:39
Data Visualisation , Reports and Dashboards
Assignment No: 2

Power BI Service : Publishing and Managing Assets
You'll learn how to publish Power BI reports to the Power BI service. You'll also learn how to create workspaces, Apps, manage related items, schedule data refreshes, deploying pipelines, RLS and data gateway implementations and much more. It's time to master power bi service environment

Introduction to Power BI Service

03:23
Power BI Service License Types

07:55
Signing into Power BI Service and Workspaces

03:28
Creating a Worksapce

02:37
Publishing Report in Power BI Service Workspace

05:10
Sharing Reports with others in Power BI Service

03:06
Workspaces, Apps and User Roles

05:55
Managing Access to Workspace and Assign roles

03:41
Dashboard in Power BI Service

05:42
Creating and Sharing Power BI App

10:26
Updating App Contents

03:11
Managing Access to App

02:10
Alerts, Subscription and downloading of Reports

09:31
What is On-Premises Data Gateway ?

04:48
Removing Existing Data Gateway

01:39
Deploying Data Gateway and Scheduling Auto Refresh

16:13
Understanding & Implementing Row Level Security (RLS)

08:01
Row Level Security (RLS) Configuration in Power BI Service

03:24
Dynamic Row Level Security (RLS)

07:18
Understanding Incremental Refresh

03:26
Implementing Incremental Refresh

15:23
Getting Quick Insights on Dataset from Power BI Service

03:38
Endorsement of Semantic Models etc

04:01
Performance Analyzer

07:23
Tips to Enhance Report Performance

05:29
Power BI Service : Publishing and Managing Assets

Additional Content: Deploying Pipelines
For collaboration , pipelines are the best way to manage development, testing and production environments.

Student Ratings & Reviews

No Review Yet

About Course

What You Will Learn

Additional Benefits of This Course

What Will You Learn?

Course Content

Introduction Here is the introduction to this power bi course. It will take you through the contents at high level and will clear expectations about the course.

Introduction – What to expect from the course

Know you trainer

Download Rescourses

Downloading & Installing Power BI Desktop

Introduction to Power BI Interface

Data Cleaning and Transformation with Power BI Desktop After getting the things ready as guided in introduction section. Now its time to master the power query editor to clean and transform the data for flexible data modelling ,visually appealing and insight full reports and dashboard.

Connecting to Data

How to Remove Rows from table

Adjusting or Changing Data Types of Columns

Adding Index Column and understanding alternate rows removal

How to Keep Rows

How to Choose Columns

Renaming Columns

Column Sorting

Column Profiling and Distribution

How to enable column profiling and distribution for entire rows in table

Concept of Appending Tables

Lets Append Tables

Adjusting Column Data Types in our Project

Splitting a Column

Arithmetic on Column

Adding a Conditional Column

How to merge tables on columns

Understanding & Exploring different mergers available in Power BI

How to add a Custom Column

How to add Column by Example

How to duplicate a Column

Column Formatting

Extracting from a Columns

How to Perform Scientific Calculations on a Column

Trigonometric Calculations on a Column

Rounding Numbers in a Column

Information on Columns

Date & Time Column Transformations

Group By Transformation

Transpose of a Table

Reversing Rows of a Table

How to Count Rows

How to Fill Rows

Pivot columns

Unpivot Columns

Data Cleaning & Transformation

Assignment No: 1

Data Modelling and Data Analytics Expression (DAX) It's time to gain knowledge about various data models and acquire proficiency in creating data models within Power BI. Additionally, let's develop and enhance skills in crafting DAX expressions to extract insights from cleaned and transformed data.

Introduction to DAX

Understanding Time Intelligence Part 1

Understanding Time Intelligence Part 2

Date Table by Calendar ( ) Function

Date Table by CalendarAuto ( ) Function

Understanding and Creating Date Hierarchies in Date Table

Extracting Year with Year ( ) Function

Extracting Month with Month ( ) Function

Extracting Week number with Weeknum ( ) Function

Extracting Quarter number with Quarter Function

Implementing Date Hierarchies Manually

Creating a Separate Table for Measures

DAX Function SUM ( )

DAX Functions MAX ( ) & MIN ( )

DAX Function COUNTROWS ( ) & AVERAGE ( )

DAX Function CALCULATE ( )

DAX Function TOTALYTD ( )

DAX Function DATEADD ( )

DAX , Arithmetic among measures

DAX Function IF ( ) Part 1

DAX Function IF ( ) Part 2

DAX Function SWITCH ( )

DAX VARIABLES

DAX Functions FIRSTNONBLANK ( ) and LASTNONBLANK ( )

Adjusting Stock Table Dates Hierarchy

DAX Function SAMEPERIODLASTYEAR ( )

Data Model View – Properties pane and Display Folders

Data Model View – Properties pane Continue

What is Data Modeling?

Types of Data Model

Introduction
Here is the introduction to this power bi course. It will take you through the contents at high level and will clear expectations about the course.

Data Cleaning and Transformation with Power BI Desktop
After getting the things ready as guided in introduction section. Now its time to master the power query editor to clean and transform the data for flexible data modelling ,visually appealing and insight full reports and dashboard.

Data Modelling and Data Analytics Expression (DAX)
It's time to gain knowledge about various data models and acquire proficiency in creating data models within Power BI. Additionally, let's develop and enhance skills in crafting DAX expressions to extract insights from cleaned and transformed data.

Data Visualisation and Creating Dynamic Reports and Dashboards
Let's gain proficiency in crafting accurate visual representations of datasets to ensure clarity and comprehension for end users. Deploying appropriate visualisations is crucial for end users to make informed decisions.