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

Download Vietnamese subtitle: Click here

Download English subtitle: Click here

Previous
Next

Please contact me via telegram

DMCA.com Protection Status