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