Microsoft Power BI - The Practical Guide 2025
0% Completed
01 – Getting Started
Download Attachment
Reading
Lesson 001 Welcome to This Course
Video - 00:00:55 mins
Lesson 002 What is Power BI
Video - 00:5:46 mins
Lesson 003 Installing Power BI Desktop
Video - 00:3:33 mins
Lesson 004 Connecting Power BI Desktop to Source Files
Video - 00:10:6 mins
Lesson 005 Creating our First Visuals
Video - 00:7:34 mins
Lesson 007 Comparing Excel & Power BI
Video - 00:3:20 mins
Lesson 008 Course Outline
Video - 00:5:30 mins
Lesson 009 The Two Ways (Paths) Of Taking This Course
Video - 00:2:22 mins
Lesson 010 How to Get the Most Out of This Course
Video - 00:3:14 mins
Lesson 011 Important How to Access Course Resources, Project Files & Slides
Video - 00:9:48 mins
02 – Understanding the Power BI Desktop Basics & Preparing the Course Project
03 – Data Preparation in the Power Query Editor
Download Attachment
Reading
Lesson 001 Module Introduction
Video - 00:1:12 mins
Lesson 002 Understanding Data Preparation Cleaning Cleansing
Video - 00:4:50 mins
Lesson 003 Connecting Power BI Desktop to Source Files
Video - 00:10:36 mins
Lesson 004 How Power BI Queries Data
Video - 00:5:1 mins
Lesson 005 Understanding Basic Row Operations
Video - 00:9:7 mins
Lesson 006 Filtering Data
Video - 00:6:00 mins
Lesson 007 Analyzing Columns & Removing Blank Fields
Video - 00:10:59 mins
Lesson 008 Understanding & Using the Append Feature
Video - 00:8:27 mins
Lesson 009 Choosing & Removing Columns
Video - 00:7:6 mins
Lesson 010 Append Behind the Scenes
Video - 00:2:50 mins
Lesson 011 Understanding the Transpose Feature
Video - 00:2:58 mins
Lesson 012 Replacing Values
Video - 00:7:35 mins
Lesson 013 Working with Dates - The Basics
Video - 00:6:50 mins
Lesson 014 Understanding Data Formats
Video - 00:5:50 mins
Lesson 015 Handling Data Format Errors
Video - 00:8:18 mins
Lesson 016 Understanding Pivoting & Unpivoting
Video - 00:4:30 mins
Lesson 017 Applying Pivoting & Unpivoting
Video - 00:3:55 mins
Lesson 018 Fixing a Sorting Problem
Video - 00:2:11 mins
Lesson 019 Extracting Data, Splitting Columns & Sorting Multiple Columns
Video - 00:9:24 mins
Lesson 020 Introducing the Group By Feature
Video - 00:4:20 mins
Lesson 021 Improving the Project Structure
Video - 00:3:16 mins
Lesson 022 Wrap Up
Video - 00:3:6 mins
04 – Data Transformation in the Power Query Editor
Download Attachment
Reading
Lesson 001 Module Introduction
Video - 00:00:56 mins
Lesson 002 Data Warehouse, Data Model & Data Schema
Video - 00:5:45 mins
Lesson 003 The Star Schema - Theory
Video - 00:6:14 mins
Lesson 004 Applying the Star Schema to our Project
Video - 00:2:26 mins
Lesson 005 Understanding References
Video - 00:4:7 mins
Lesson 006 Comparing References & Duplicates
Video - 00:6:40 mins
Lesson 007 Importing Country & Region Codes
Video - 00:7:53 mins
Lesson 008 Using Enter Data to Create a Table
Video - 00:3:1 mins
Lesson 009 Understanding the Merge Feature
Video - 00:3:29 mins
Lesson 010 How to Join Tables
Video - 00:3:19 mins
Lesson 011 Understanding Outer, Inner & Anti Joins
Video - 00:5:37 mins
Lesson 012 Join Kind in Practice
Video - 00:5:2 mins
Lesson 013 Handling Merge Errors
Video - 00:11:31 mins
Lesson 014 Understanding the DIM-age Table
Video - 00:3:26 mins
Lesson 015 Bringing Back the age-group Column
Video - 00:4:41 mins
Lesson 016 Getting the Maximum Values From Each Age Group
Video - 00:3:31 mins
Lesson 017 Creating Conditional Columns
Video - 00:7:23 mins
Lesson 018 Creating an Index Column
Video - 00:2:26 mins
Lesson 019 Creating a DIM-gender Table
Video - 00:3:16 mins
Lesson 020 Understanding the FACT Table
Video - 00:3:2 mins
Lesson 021 Finishing the FACT Table
Video - 00:8:50 mins
Lesson 022 Applying Basic Mathematical Operations
Video - 00:2:30 mins
Lesson 023 Using the Enable Load Feature
Video - 00:6:58 mins
Lesson 024 Wrap Up
Video - 00:2:46 mins
05 – The Data Model Working with Relationships & DAX (Data Analysis Espressions)
Download Attachment
Reading
Lesson 001 Module Introduction
Video - 00:1:26 mins
Lesson 002 Query Editor vs Data Model
Video - 00:4:39 mins
Lesson 003 Understanding Relationships
Video - 00:2:35 mins
Lesson 004 Creating our First Relationship
Video - 00:9:59 mins
Lesson 005 Understanding Cardinality & Difference Relationship Types
Video - 00:2:23 mins
Lesson 006 One to Many & Many to One
Video - 00:2:23 mins
Lesson 007 One to One
Video - 00:1:38 mins
Lesson 008 Many to Many
Video - 00:3:28 mins
Lesson 009 Fixing the Column Order Bug
Video - 00:3:33 mins
Lesson 010 Understanding the Cross Filter Direction
Video - 00:11:16 mins
Lesson 011 Understanding Active Properties
Video - 00:1:41 mins
Lesson 012 Adding Relationships to the Project
Video - 00:6:56 mins
Lesson 013 M-Language vs DAX (Data Analysis Expressions)
Video - 00:4:17 mins
Lesson 014 Creating a Custom Column with the M-Language
Video - 00:6:30 mins
Lesson 015 Creating a Calculated Column with DAX
Video - 00:7:1 mins
Lesson 016 M vs DAX - What Should I Choose
Video - 00:2:24 mins
Lesson 017 The DAX Basics
Video - 00:2:59 mins
Lesson 018 The Core DAX Syntax
Video - 00:4:1 mins
Lesson 019 DAX Data Types
Video - 00:2:59 mins
Lesson 020 DAX Operators
Video - 00:4:54 mins
Lesson 021 DAX Core Functions
Video - 00:4:19 mins
Lesson 022 Creating a Table with the CALENDAR Function
Video - 00:11:48 mins
Lesson 023 Extracting Data with the DOT Notation
Video - 00:4:5 mins
Lesson 024 Adding & Dividing Columns
Video - 00:8:00 mins
Lesson 025 Working with IF Functions
Video - 00:6:42 mins
Lesson 026 Understanding Relationship Functions
Video - 00:4:40 mins
Lesson 027 Calculated Column vs Measure
Video - 00:1:51 mins
Lesson 028 Understanding & Creating Measures
Video - 00:5:14 mins
Lesson 029 Working with FILTER & CALCULATE Functions - Theory
Video - 00:5:44 mins
Lesson 030 Combining CALCULATED & FILTER Functions
Video - 00:9:11 mins
Lesson 031 Adding the Filter Condition to CALCULATE
Video - 00:3:32 mins
Lesson 032 Using Measures in Measures
Video - 00:4:24 mins
Lesson 033 Changing the Measure's Home Table
Video - 00:4:20 mins
Lesson 034 Understanding the Data Category
Video - 00:3:00 mins
Lesson 035 Wrap Up
Video - 00:2:39 mins
06 – Creating Visuals in the Report View
Download Attachment
Reading
Lesson 001 Module Introduction
Video - 00:1:3 mins
Lesson 002 The Power BI Workflow & Understanding Basics Visual Elements
Video - 00:4:49 mins
Lesson 003 Creating & Duplicating Pages
Video - 00:2:8 mins
Lesson 004 Organizing Visuals
Video - 00:6:2 mins
Lesson 005 Creating a New Visual
Video - 00:3:00 mins
Lesson 006 Creating Line & Column Charts
Video - 00:7:2 mins
Lesson 007 How FILTER Affects the Visual
Video - 00:6:40 mins
Lesson 008 Understanding Interactions
Video - 00:5:22 mins
Lesson 009 Hierarchies & Drill Down
Video - 00:7:30 mins
Lesson 010 Formatting Chart Colors
Video - 00:7:50 mins
Lesson 011 The Canvas
Video - 00:3:00 mins
Lesson 012 Formatting the Page Background Wallpaper
Video - 00:2:37 mins
Lesson 013 Formatting the Filter Pane & Filter Cards
Video - 00:7:17 mins
Lesson 014 Formatting Visuals General Settings
Video - 00:4:42 mins
Lesson 015 Diving Deeper Into Formatting Visuals
Video - 00:8:4 mins
Lesson 016 Working with Report Themes
Video - 00:7:13 mins
Lesson 017 Finishing the Report Theme
Video - 00:2:23 mins
Lesson 018 Understanding the Slicer
Video - 00:9:35 mins
Lesson 019 Default Summarization & Sorting Order
Video - 00:4:20 mins
Lesson 020 Creating Treemaps & Working with Multiple Slicers
Video - 00:6:36 mins
Lesson 021 Creating Tables
Video - 00:6:36 mins
Lesson 022 Syncing Slicers
Video - 00:3:12 mins
Lesson 023 Filter on Visual, Page & Report Level
Video - 00:9:47 mins
Lesson 024 Creating Single & Multi Row Cards
Video - 00:7:48 mins
Lesson 025 Adding a Secondary Y-Axis
Video - 00:4:34 mins
Lesson 026 Combining Column & Line Charts
Video - 00:2:51 mins
Lesson 027 The Waterfall Chart
Video - 00:3:11 mins
Lesson 028 Importing Visuals
Video - 00:2:19 mins
Lesson 029 Finishing Touches
Video - 00:5:9 mins
Lesson 030 Wrap Up
Video - 00:4:24 mins
07 – Power BI Pro & Mobile Sharing & Collaborating with Workspaces & Apps
Download Attachment
Reading
Lesson 001 Module Introduction
Video - 00:1:52 mins
Lesson 002 The Next Steps
Video - 00:4:57 mins
Lesson 003 Power BI Pro Pricing
Video - 00:4:14 mins
Lesson 004 Power BI Pro Interface Tour
Video - 00:6:38 mins
Lesson 005 Publishing & My Workspace - Theory
Video - 00:3:19 mins
Lesson 006 Publishing Importing Power BI Desktop Projects to Pro
Video - 00:4:10 mins
Lesson 007 Datesets Walkthrough
Video - 00:4:25 mins
Lesson 008 List View vs Lineage View
Video - 00:4:2 mins
Lesson 009 Exploring Reports In Pro
Video - 00:4:46 mins
Lesson 010 Understanding Dashboards
Video - 00:7:20 mins
Lesson 011 Creating Reports & Dashboards
Video - 00:7:32 mins
Lesson 012 Diving Deeper Into My Workspace, Understanding Refresh and a Refresh Error
Video - 00:4:34 mins
Lesson 013 Gateways - Theory
Video - 00:1:40 mins
Lesson 014 Gateways Configuring Manual & Scheduled Refreshs
Video - 00:11:53 mins
Lesson 015 Sharing Data From My Workspace via Direct Access
Video - 00:13:44 mins
Lesson 016 Sharing Links
Video - 00:5:42 mins
Lesson 017 Understanding Collaboration Workspaces - Theory
Video - 00:1:37 mins
Lesson 018 Creating Colaboration Workspaces
Video - 00:8:9 mins
Lesson 019 Sharing Data via Apps
Video - 00:1:38 mins
Lesson 020 Publishing & Unpublishing Apps
Video - 00:9:20 mins
Lesson 021 Deleting Collaboration Workspaces
Video - 00:1:15 mins
Lesson 022 Workspaces vs Apps
Video - 00:2:19 mins
Lesson 023 Working with Power BI Mobile
Video - 00:5:48 mins
Lesson 024 Wrap Up
Video - 00:2:48 mins
08 – Other Data Sources
Download Attachment
Reading
Lesson 001 Module Introduction
Video - 00:1:21 mins
Lesson 002 Importing JSON Data
Video - 00:6:28 mins
Lesson 004 Importing Data from REST APIs
Video - 00:5:1 mins
Lesson 005 Preparation Setting up a MySQL Server
Video - 00:8:9 mins
Lesson 006 Importing Data from a MySQL Server (and other SQL Servers)
Video - 00:6:38 mins
Lesson 007 Wrap Up
Video - 00:00:56 mins
09 – How to Stay Up-to-Date in the Power BI World
10 – Course Round Up
11 – Optional Power BI Desktop Crash Course Introduction & Summary
Download Attachment
Reading
Lesson 001 Module Introduction
Video - 00:1:29 mins
Lesson 002 Project Setup
Video - 00:3:55 mins
Lesson 003 Connecting Power BI Desktop to the Source Files
Video - 00:1:53 mins
Lesson 004 Query Editor Walkthrough
Video - 00:4:27 mins
Lesson 005 Removing Blank Rows & Fixing Format Errors
Video - 00:5:8 mins
Lesson 006 Saving the Project
Video - 00:00:54 mins
Lesson 007 Duplicates vs References
Video - 00:7:27 mins
Lesson 008 Appending Queries
Video - 00:4:46 mins
Lesson 009 Splitting Columns & Extracting Data
Video - 00:3:4 mins
Lesson 010 Basic Column Interactions
Video - 00:2:56 mins
Lesson 011 Data Modelling Theory
Video - 00:6:20 mins
Lesson 012 Creating the Orders Table
Video - 00:3:41 mins
Lesson 013 Working with Indexes
Video - 00:3:15 mins
Lesson 014 The Formula Bar
Video - 00:4:17 mins
Lesson 015 Merging Queries
Video - 00:4:25 mins
Lesson 016 Loading Data Into the Data Model
Video - 00:6:11 mins
Lesson 017 Creating Line Charts
Video - 00:5:28 mins
Lesson 018 Understanding Relationships
Video - 00:5:32 mins
Lesson 019 Formatting Numbers in Charts
Video - 00:3:15 mins
Lesson 020 Understanding Interactions
Video - 00:3:12 mins
Lesson 021 Hierarchies & Drill-Down
Video - 00:5:10 mins
Lesson 022 Sorting Axis Values
Video - 00:1:37 mins
Lesson 023 Formatting Visuals & Applying Report Themes
Video - 00:3:15 mins
Lesson 024 Reports, Map Visual & Default Summarization
Video - 00:4:35 mins
Lesson 025 The Data Category
Video - 00:1:40 mins
Lesson 026 Applying Filters to Visuals
Video - 00:4:53 mins
Lesson 027 Understanding Slicers
Video - 00:4:10 mins
Lesson 028 Creating Tables
Video - 00:4:59 mins
Lesson 029 Working with DAX (Data Analytics Expressions)
Video - 00:6:7 mins
Lesson 030 Sorting Weekdays with Calculated Columns
Video - 00:4:25 mins
Lesson 031 Fixing the Revenue Calculation
Video - 00:1:50 mins
Lesson 032 Introducing Measures
Video - 00:7:14 mins
Lesson 033 Working with Quick Measures
Video - 00:5:3 mins
12 – Bonus Selected Features by Example & Refresher Project
Download Attachment
Reading
Lesson 002 Understanding Column from Examples
Video - 00:6:35 mins
Lesson 003 Group By, Big Data & DAX Studio
Video - 00:9:42 mins
Lesson 005 Taxi Project - Query Editor
Video - 00:22:12 mins
Lesson 006 Taxi Project - Data Model & Visuals
Video - 00:22:20 mins
Lesson 007 Taxi Project - Power BI Service
Video - 00:15:32 mins
13 – This Course Was Completely Updated
14 – Course Roundup
Download Attachment: Click here
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
