Power BI for Data Analysis

Name: Power BI for Data Analysis
Rating: 4.4 (215 reviews)

From data to beautiful insights

Created byCleverson Esene PhD

Last updated 1/2026

English

What you'll learn

Able to analyze data with Power BI and gain insight
Able to connect and extract data from the web, excel etc.
Able to design interactive reports and dashboards
Able to understand the logical steps in data models
Able to write DAX expressions
Data mash ups using the Power query editor
Able to write your own DAX measures
Able to design and interactive reports and dashboards
Able to understand the concepts of facts and dimension table
Able to create a Power BI mobile dashboard

Course content

5 sections • 41 lectures • 3h 12m total length

Welcome/Home0:17
Introduction1:44
Downloading Power BI Desktop App and Dataset1:14
Download and install the Power BI desktop app and dataset from the Microsoft Store on a Windows machine, following step-by-step guidance to locate and open the app.
Overview of Power BI User Interface3:48
Understanding the Case Study2:56
Explore a case study to identify data types and business context for Power BI data analysis, focusing on raw data, descriptive elements, and facts tables like sales, quantity, and profit.
Importing Data into Power BI3:05
Power Query Overview6:13
Data Transformation with Power Query Editor4:05

Overview of Power BI Reporting4:45
Transform data in pocket editor by removing the raw id and converting post code to text, then load into Power BI to build visuals of sales, quantity, discount, and profits.
Creating your First Visual - Line Chart5:39
Formatting Power BI Charts6:29
Learn how to format Power BI visuals, adjust axis titles, fonts, and units, reposition legends, and add analysis features like average lines for monthly sales charts.
Creating a Top N Report with a Bar Chart10:13
Creating a Donut Chart2:50
Creating a Bottom N Report with a Bar Chart6:27
Using Filters Pane and Slicers6:51
Learn to filter and slice Power BI reports using the filters pane and slicers, enabling segment-level analysis for consumer, corporate, and home office data.
Slicer 24:08
Add and arrange date and segment slicers on a Power BI dashboard, tune their size and interactions, and address a month-year visual distortion by excluding a chart from slicer actions.
Editing Interactions4:37
More on Formating8:45
Module Outro3:14

Quiz Solution1:37
Introduction to Data Modelling3:14
Very Important Module. Spend more time here
Workflow for Data Modelling1:48
List headers and identify events to begin a data model, group events to reveal relationships, assign a key for granularity, break data into dimension and fact tables with primary keys.
Building the Data Model for our Data15:37
Build a data model to reduce repetition and optimize data handling by identifying keys and relationships across customers, geography, and products.
Building the Data Model for our Data 26:54
Building the Data Model for our Data 32:47
Building the Data Model for our Data 42:54
Testing the Data Model Part 16:23
Build a Power BI data model by linking orders to customer, geography, and product tables with primary and foreign keys, while removing duplicates to maintain unique lists and fix links.
Fixing the Data Model Part 110:19

Data Analysis Expressions - DAX0:10
Building a Calendar Table3:21
Adding Columns to our Calendar Table (Month, Year etc)7:23
Adding Columns to our Calendar Table (Quarter)3:12
Investigating the Date Table4:32
Measure - Revenue4:51
Measure - Previous Month7:01
Measure -Month on Month Variance4:42
Line Chart3:30
Water Fall Chart3:14
Matrix Table2:55
Build a matrix table with month rows and year columns to display revenue, block slicer interactions, and use data bars in cells to show revenue strength.
Analysis3:32

Requirements

No programing skills needed.
Able to poke around your PC

Description

I have created this course with a very simplified approach and many students who have taken this course have found it clear and easy to understand. The Power BI course is designed to give the participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to extract from their data to gain great insights.

At the end of the course, you would have progressed from a zero level to an intermediate level at a very tailored pace.

This course covers the essentials of Power BI Desktop including:

1. Data Preparation

2. Data Modeling

3. Data Visualization

4. 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 and the minimum transformation that you can do for data clean up.

In the Data Visualization section, I have explained thoroughly and included a guide you that will hep you in selecting the right kind of charts for your reporting.

The Data Modeling section, I have shown how to methodologically create a data model and how you can eliminate redundant data by separating 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 on excel, before transferring to using the power query editor

Although, I have not gone very deep on DAX, the DAX content here is excellent, and it is a super place to start.

I hope you enjoy the course!

Who this course is for:

Data analysts
Students
Business oriented
Freelancers
Anyone curious about data science and what to have a change of career

Power BI for Data Analysis

What you'll learn

Explore related topics

Course content

Introduction & General Overview8 lectures • 23min

Data Visualization Reports using Power BI11 lectures • 1hr 4min

Data Modelling9 lectures • 52min

DAX Fundamentals12 lectures • 48min

Forecasting1 lecture • 6min

Requirements

Description

Who this course is for: