Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Microsoft Power BI: Data Analytics with Power BI Bootcamp

Name: Microsoft Power BI: Data Analytics with Power BI Bootcamp
Rating: 4.7 (193 reviews)

Deep-dive into Power BI with Visualization, Data Preparation, ETL & Cleaning, Data Modeling and DAX

Created byAhmed Oyelowo, Foresight BI & Analytics. 100,000+ Learners

Last updated 5/2026

English

What you'll learn

Build a complete Power BI report and dashboard from scratch using business data
Prepare and transform data with Power Query for Power BI reporting and dashboard development
Create Power BI data models by building relationships and organizing tables for analysis
Design interactive Power BI reports using slicers, filters, drill-downs, tooltips, and visual interactions
Use different Power BI chart types to present business insights clearly and effectively
Publish Power BI reports to the Power BI Service and generate shareable report links
Design mobile-friendly Power BI reports that work well on phones and other devices
Create a personal Power BI portfolio project that demonstrates dashboard design, reporting, and data visualization skills

Course content

15 sections • 171 lectures • 12h 39m total length

Welcome0:15
Introduction2:05
Prerequisites1:36
Overview of Power BI1:28
Downloading & Installing Power BI2:33
Typical Flow of Power BI Development2:32
Understanding the Power BI Desktop User Interface6:32
Configuring the Report Page (Part 1)5:20
Changing the Canvass Background and Wall Paper3:36
Power BI Overview
Introducing the Sample Dataset4:11
Introduction to Getting Data in Power BI2:06
Importing Data with Power Query5:49
Understanding how Power Query works8:16
Changing Data Types in Power Query7:55
Refreshing Data and Re-opening Power Query Editor3:20
Reusing Power Query M Queries3:47
Importing Data

Introduction to Data Analysis & Visualization6:10
Categorizing Data for Visualization5:43
Introduction to Visualization in Power BI Desktop4:02
Explore Power BI desktop data view with an orders dataset, examining ship modes, segments, locations, product categories and sales metrics, and report sales by segment and region for visual insights.
Data Visualization Basics
Creating Visuals on Power BI Desktop3:36
Introduction to Formatting Charts4:11
Adding more visuals to the reporting canvass3:46
Common Visuals Formatting Options8:03
Changing Visuals1:56
Introducing Visuals Field Buckets3:44
Understanding the Axes and Legend4:11
X axis, Y axis and Legend in use2:51
Introduction to Small Multiples1:22
Using Tool Tips2:39
Small Multiples in Use5:33
Enabling Visuals Drill Down4:30
Configuring Visuals on Power BI

Introduction to Reporting in Power BI5:33
Preparing Data For Reporting5:29
Working with Shapes in Power BI2:09
Working with Text Boxes8:15
Displaying Trends with Line Charts3:24
Displaying Ranking Changes and Variance with Ribbon Charts5:13
Sorting of Visuals in Power BI Desktop7:04
Applying Gradient Conditional Formatting to highlight number ranges3:50
Reusing Charts and Editing Conditional Formatting6:08
Editing Visual Interactions on the Reporting Canvas5:37
Filtering Report Pages with Slicers8:04
Synchronizing Slicers for multiple pages4:59
Introduction to the Filters Pane4:04
Displaying Top N Categories on a Visual5:30
Creating Bottom N2:04
Using Tables and Matrix Tables7:09
Applying Conditional Formatting on Matrix1:51
Basic Formatting of Matrix Visual2:37
Using Maps on Power BI Desktop6:41
Creating Report Page Tool Tips6:23
Creating Report Drill Through3:48
Customizing Text Header on Drill Through Pages2:31
Summarizing the reports3:51
Using Decomposition Tree Visual3:38
Drill Decomposition Tree with AI2:29
Using the Key Influencer Visual4:20
Introduction to Bookmarks and Selection5:29
Implementing Bookmarks in Power BI Desktop8:56
Using Q and A Visual in Power BI Desktop3:39
Designing Mobile View of Reports and Preparing to Publish5:06
Get a Power BI Developer Account with Pro Licence0:10
Exporting Reports to PDF and Publishing Reports to Power BI Online7:52
Visualization wrap up0:36

Intro to Data Prep3:01
Getting data into Power Query6:33
Connect to Excel data using Power Query, preview and transform three worksheets—consumer, corporate, and home office—handle nulls and errors, then close and apply to load into Power BI Desktop.
Understanding how powerquery works1:29
Previewing Empty and Error values with Column Quality3:37
Previewing Distinct and Unique with Column Distribution4:15
Previewing Column Statistical Summaries with Column Profile3:20
Setting Data Preview checks for entire dataset2:07

Introduction to Combining Data Queries1:58
Understanding Append Queries7:07
What you must know about Append Queries4:15
Understanding Merge Queries6:30
Using Multiple Columns as Keys for Merging Queries8:02
Understanding Join Kinds4:53
Using the different Join Kinds in Power Query10:15
What you must know about Merge Queries4:29
Introduction to Transposing Data4:12
Transposing Data when there is Header Row5:15
Understanding Unpivot Columns6:40
Unpivoting Columns when there are null values3:25
Unpivoting Columns without Header Rows3:38
Understanding Pivot Columns6:31
Understanding Group By9:21

Adding Duplicate and Index Columns4:39
Deriving new Columns from a Text Column4:00
Deriving new Columns from Numbers and Date Columns5:07
Derive new columns from numbers and dates in Power Query within Power BI, including price per unit, and age calculations, with year, month, and day name extractions.
Adding Conditional Columns (1)4:18
Adding Conditional Columns (2)5:59
Adding Custom Columns (1)6:27
Adding Custom Columns (2)4:18
Adding Columns From Examples2:41

Introduction to Data Cleaning1:47
Data Cleaning Example 18:00
Identify and fix misaligned data by transposing and unpivoting in Power Query, align ship mode and segment into columns, and clean order date in Power BI from Excel.
Data Cleaning Example 26:13
learn to clean and reshape badly structured sales data in Power Query, using transpose, merge columns, unpivot, and split by delimiter to align order IDs and dates.
Data Cleaning Example 36:07
Data Cleaning Example 44:34
Data Cleaning Example 57:41
Data Cleaning Example 611:46

Introduction to connecting to Data Sources1:10
Connecting to Folders (1)8:26
Connecting to Folders (2)7:35
Connecting to Excel and combining multiple Worksheets7:24
Intro to SharePoint Data Source3:13
Connecting to Excel File on SharePoint or OneDrive for Business3:39
Connecting to a Folder on SharePoint7:13
Connecting to OData Feeds1:51
Importing Data from Microsoft SQL Server3:55
Using Embedded Queries to get data from SQL Server1:34
Introduction to Query Folding3:55
Introduction to Direct Query Connection5:01
Power Query Wrap Up1:17

Introduction & Prerequisites2:33
Understanding Data Normalization (part 1)3:17
Understanding Data Normalization (part 2)2:47
Understanding Data Normalization (Part 3)3:41
Understanding Fact and Dimension Fields4:17
Eliminating Redundancy in data with Normalization5:24
Understanding the requirements for Normalizing Data1:24
Planning for Data Normalization7:21
Mapping Data for Normalization8:30
Mapping out the Fact Fields3:42
Map out the data by defining dimensions such as customer, location, and product using related columns, and identify fact fields by pairing measurements with dimension keys while avoiding redundancy.
Creating an Entity Relationship Diagram from Mapped Model6:24

Requirements

No programming experience required
A Windows computer with minimum of Windows 10 OS
Power BI Desktop Installation (You will learn how to install inside the course)
You should have an open mind to learning

Description

Microsoft Power BI is the most trending Data Analysis and Visualization Tool. The Roles for skilled users are enormous, just search on Indeed or any other sites to see how many Power BI roles are being advertised.

The good news is, anybody can learn Power BI and it is easy to start and learn. But it is easier and faster with the right Course and the right Trainer.

In this Bootcamp course, Ahmed Oyelowo (5 times Microsoft MVP for Data Platform and Microsoft Certified Trainer and Certified Educator) will take you from beginner to advanced concepts of using Power BI for carrying out:

Data Analysis and Visualization
Data Preparation & Data Cleaning (with 6 dirty data cleaning examples)
Data Modeling (with methods of troubleshooting problematic data models)
DAX

You will immediately, within the first 4 hours of the course, create your own Data Visualization Showcase or Portfolio that immediately improves your career prospects.

In this course, you will learn:

Where to download and install Power BI Desktop
How to Import Data Into Power BI
How to use different Power BI charts for different data story telling scenarios
How to set up and configure charts to enable different functionalities
How to Build Power BI Reports
How to design mobile view of Power BI reports
How to export your Power BI reports and Publish to Power BI Service
How to get a Power BI Pro License for free
How to use Power Query for Data Preparation
Different methods for Transforming data with Power Query
How to clean dirty data with Power Query
How to use Power Query to connect to different data sources
How to work with Data models with multiple tables
Fact & Dimension Tables
How to normalize data for Data Modeling
How to create ideal Power BI Data Model relationships
How to build date tables with DAX and with Power Query
How to troubleshoot problematic Power BI Data Models
And many more Power BI concepts

This course is mostly ideal for all Power BI skill levels from beginners to intermediate, or any other self taught Power BI users who may not have the pieces put together.

Enroll now to learn effective methods to Analyze and Visualize Data, Prepare & Clean Data, Build Efficient Power BI Data Models and write DAX formulas.

Who this course is for:

Beginners who want to learn Power BI from scratch and build complete reports and dashboards
Excel users who want to move into Power BI, business intelligence, and data visualization
Aspiring data analysts who want practical Power BI skills for reporting, dashboard development, and career growth
Data analysts and business analysts who want to create interactive Power BI reports using real-world data
Working professionals in finance, HR, sales, marketing, operations, and administration who need to analyze and present data
Report developers who want to design professional Power BI dashboards with slicers, filters, charts, and visual interactions
Learners who want to understand Power Query, data preparation, data modeling, and dashboard design in Power BI
SQL and database professionals who want to visualize data and create business reports in Power BI
Tableau, Qlik, Python, or R users who want to add Microsoft Power BI to their analytics toolkit
Students, graduates, and job seekers who want to build portfolio-ready Power BI projects
Anyone preparing for the Microsoft PL-300 Power BI Data Analyst certification
Professionals who want to publish Power BI reports online using the Power BI Service

Microsoft Power BI: Data Analytics with Power BI Bootcamp

What you'll learn

Explore related topics

Course content

Introduction and Getting Data16 lectures • 1hr 1min

Creating and Configuring Power BI Charts15 lectures • 1hr 2min

Building Reports in Power BI33 lectures • 2hr 34min

Introduction to Data Preparation with Power Query7 lectures • 24min

Data Transformation with Power Query15 lectures • 1hr 27min

Creating New Data Columns in Power Query8 lectures • 37min

Other Transformations and Dealing with Cell Errors4 lectures • 24min

Cleaning Dirty Data with Power Query7 lectures • 46min

Connecting to Popular Data Sources13 lectures • 56min

Introduction to Data Modeling11 lectures • 49min

Requirements

Description

Who this course is for: