Teach on Udemy

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

Learn More

Your cart is empty.

Keep shopping

Power BI - Data Analytics Essentials with Power BI

Name: Power BI - Data Analytics Essentials with Power BI
Rating: 4.5 (8283 reviews)

Get Started Quickly with Visualization, Data Prep and DAX on Power BI

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

Last updated 1/2026

English

English [Auto],French [Auto],

What you'll learn

Simple methods to Analyze data with Power BI and gain Insights
Automate manual reporting processes with Power BI
Make reports available to stakeholders 24/7 on all devices
Select the appropriate charts for visualization (Data Visualization)
Create links in reports with Book Marks (Data Visualization)
Design Interactive Reports and Dashboards (Data Visualization)
Logical steps to build Data Models from (Data Modeling & DAX)
Understand concept of Fact and Dimension Tables (Data Modeling & DAX)
Simplified methods to write your own DAX Measures (Data Modeling & DAX)
Build your Calendar/Date Table from Scratch with DAX (Data Modeling & DAX)
Combine multiple Excel Workbooks (Data Preparation)
Combine Multiple Excel Worksheets (Data Preparation)
Master the rules for Data Preparation (Data Preparation)

Course content

6 sections • 81 lectures • 4h 56m total length

Welcome!0:34
Introductions4:07
About the Course6:07
Downloading Power BI Desktop2:38
Update to Power BI User Interface0:08
Understanding the Power BI User Interface8:03
Explore the five core areas of the Power BI Desktop interface—the top tabs and ribbon, right-hand panes, bottom page navigation, left-side views, and the canvas.
Power BI Interface
Understanding the Case Study Data4:24
Importing Data to Power BI3:53
Import data into Power BI by using the get data button, selecting Excel, and navigating to the orders worksheet, then transform data in the Power Query Editor before loading.
Understanding the Power Query User Interface5:26
Intro to Transforming Data with Power Query3:29
Intro to Transforming Data with Power Query Continued5:05
Review how to set accurate data types in Power Query for Power BI, using change type and quick icon cues (ABC for text, calendar for date) to ensure correct categorization.
Re-Using M Scripts in Microsoft Excel and Loading Data to Power BI3:46
Copy M scripts from Power BI using the advanced editor, paste into Excel's Power Query, apply the same transformations, and load the data back into Power BI.
More Information on using copied M Scripts to Excel0:30
Editing Queries and Refreshing Data
Power Query Transformation

Introduction to Power BI Reporting3:36
Update - how to create charts with the new User Interface8:10
Visualizing a timeline report with Line Chart3:33
Formatting Power BI Charts5:54
The New Power BI Visualizations & Formatting Pane0:06
Adding a new chart to the canvass3:23
Creating a Top N Report with a Bar Chart3:34
Sorting a Visual3:20
Update: Using Slicers0:15
Filtering a page with Filters Pane and Using Slicers5:44
Controlling Visual Interactions on the Canvass3:07
Using Visuals Background to enhance Report Page1:56
Enhance Power BI reports by arranging visuals, aligning with guides, and using a light gray background. Adjust slicer interactions, add boundaries, and insert a title for readability.
Using Shadows to enhance Reports0:16
Chart Elements
Working with Shapes and Text Box3:03
Create a horizontal boundary by inserting a line and rotating it 90 degrees, slim-fit to width, then add a bold reddish text box for the title at the top left.
Working with Report Themes3:45
Re-Using a Report Page as Template4:40
Adding a back button to return to a previous page1:48
Designing a Report optimized for Mobile View3:21
Create a Microsoft 365 Developer Account for Power BI0:18
Publishing Reports to the Power BI Service5:25
Introduction to Q & A3:18
Selecting the right Visuals3:12
Module Outro0:46
Assignment

Introduction to Data Modeling3:12
Why build a Data Model?4:36
Step 1 - 4 of Building a Data Model11:27
Step 5 of Building a Data Model6:34
Preparing Data Model Files in Power Query3:25
Extracting the Fact and Dimension Tables4:44
Investigating & Resolving issues with Relationships 14:49
Investigating & Resolving issues with Relationships 27:46
Testing the Relationships in Report View2:13
Test relationships across tables in the Power BI report view by selecting fields from customer segments, regions, and product categories and comparing them to a numeric field.
Data Modeling Quiz

Data Analysis Expressions (DAX)0:33
Introduction to DAX2:21
Discover DAX, the data analysis expressions language in Power BI, to generate new tables, add columns, and write measures, and use a calendar table for date functions.
Using CALENDARAUTO() to generate a Calendar Table5:02
Using FORMAT() Function to add Month, Year and Quarter Columns to Calendar6:45
Connecting the Calendar Table to the Fact Table3:26
Using the MONTH() Function to Create a Custom Sort Column for the Month Column2:39
In Power BI, create a new column called month number using the MONTH() function, then sort the month column by this numeric order to achieve January to December.
Writing simple Aggregation Measure4:09
Aggregation Measures0:19
Understanding Filter Context 13:57
Explore how Power BI uses a revenue measure across visuals to show revenue by month or by customer segment, and understand how evaluation context and filter context drive these calculations.
Understanding Filter Context 22:31
Explore how filter context shapes Power BI visuals by month and consumer segment, showing how selecting January filters charts and cards to reveal precise values.
Introduction to CALCULATE() function5:31
Demonstrates using the calculate function to modify the filter context and compute revenue by region, creating central revenue and revenue versus central measures.
Creating a shell table to keep Measures2:35
Writing Time Intelligence Formulas - the PREVIOUSMONTH() Function6:41
Calculating Month on Month Variance3:42
Using the REMOVEFILTERS() function and Calculating Percentage share4:50
During the March 2020 update, the REMOVEFILTERS() function used in this lesson has stopped showing up in the Power BI Intellisense. So you will have to type out the full name of the function, open parenthesis and enter the arguments as shown in the video, then close the parenthesis as usual. It still works very fine.
Using SAMEPERIODLASTYEAR() to calculate SPLY Values2:28
Create a measure using same period last year to compare revenue for a chosen period against the previous year, so January 2015 values reflect January 2014 figures in the visual.
Calculating Year to Date Values5:02
Calculate year-to-date revenue in Power BI using two dax methods—calculate with datesytd and totalytd—aggregating from January to the currently selected month.
Automatic Measures with Quick Measures3:06
Learn to create automatic measures with quick measures in Power BI, using a base value and calendar dates to calculate revenue year-to-date.
Time intelligence Formulas0:17

Customizing the Report Theme1:51
Creating a Report Page Template4:32
Visualizing Monthly Revenue vs SPLY on a Line Chart2:53
Creating a Forecast from a Line Chart4:31
Visualizing Monthly Variance with a Waterfall Chart2:44
Creating a Matrix Table report with Data Bars2:24
Create a matrix table report in Power BI to display revenue by year and month, using a revenue metric, data bars conditional formatting, and controlled interactions for precise insights.
Creating a simple Donut Chart1:46
Visualizing Current & Previous Period with Clustered Bar Chart1:58
Visualizing Changes in ranking over time with Ribbon Chart5:00

Introduction to Data Preparation1:10
Using Append method to combine Excel Worksheets5:11
Using Workbook Property Method to combine Excel Worksheets7:02
Learn to consolidate multiple Excel worksheets in Power BI using the workbook property method, transforming workbook metadata, selecting worksheets, handling headers, and refreshing to evaluate the best consolidation method.
Comparing Append & Workbook Property Consolidation Methods4:00
Consolidating Clean Excel Workbooks from a Folder5:42
Use the folder approach in Power BI to consolidate workbooks with the same structure, select the contents, remove corrupt files, and use the combine files feature.
Consolidating un-clean Excel Workbooks from a Folder9:45
Consolidate un-clean Excel workbooks from a folder by connecting to the folder, cleaning headers, removing top rows, and aggregating one contents column across all workbooks.
What next?0:43

Requirements

Basic Reporting
Fundamental Excel Knowledge is an added advantage
Knowledge of Excel Pivot Tables is an added advantage

Description

Power BI - Data Analytics Essentials with Power BI:

Many students who have taken this course have found it detailed and easy to understand. At the end of the course, you will be able to take my virtual Power BI Developer Internship program that also comes with a Certificate.

“In God we trust, all others must bring data”.

The famous quote by W. Edwards Deming has never been more true than it does in today's world.

Far gone are the days business decision makers take critical decisions based on haunches, intuition and gut feelings.

These days, everyone has come to realize that better and more accurate decisions can be made when data is put into good use. And there is data everywhere. The problem is, there is a shortage in the number of people who can put it into good use.

The Power BI course is designed to arm participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to go from data to insights.

Participants will quickly learn from a Microsoft Certified Trainer and 5 times MVP, the bolts of the key concepts required to be a Power BI expert.

Complex concepts are described in simplified manner to make the learners' journey easier.

And not just that, the facilitator will be on ground, supporting any participant with challenges working with Power BI afterwards.

This course covers the essentials of Power BI Desktop including:

Data Preparation
Data Modeling
Data Visualization
DAX

In the Data Preparation section, I explained the rules for clean data structure. I also show how to connect Power BI to a system Folder, an approach that eases data updates for reports.

The Data Modeling section shows how you can eliminate redundant data from a large data set by separating the tables into Fact and Dimension Tables. You will see how to do this from scratch using a methodical approach.

In the Data Visualization section, I have included a write up that will guide you in ensuring that you always select the right kind of charts for your reporting and dashboards

Although, I have created a separate dedicated course for more in-depth explanations on DAX, the DAX content here is an excellent place to start your DAX Knowledge.

Enjoy the course!

Who this course is for:

Power BI Beginners to Intermediate Users
Looking to earn the Power BI Certification
Business Intelligence enthusiasts
Data Science enthusiasts
Interested in Data Analysis
Interested in Data Visualization
Interested in Data Analysis Expressions (DAX)
Interested in Data Modeling
Interested in ETL and Data Cleaning

Power BI - Data Analytics Essentials with Power BI

What you'll learn

Explore related topics

Course content

Intro & Overview14 lectures • 48min

Visualizing Reports in Power BI23 lectures • 1hr 13min

Understanding Data Modeling in Power BI9 lectures • 49min

Introduction to DAX19 lectures • 1hr 6min

Visualizing the Measures9 lectures • 28min

Data Preparation Techniques7 lectures • 34min

Requirements

Description

Who this course is for: