👉 If you're an existing student, click on My Dashboard (on the menu bar above) to access the course.
👉 If you're not an enrolled student, click here to learn more and apply to join LearnPowerBI
Course curriculum
-
1
Updates
- Power BI User Interface Updates
-
2
1. Zero to Dashboard
- 1.0 Downloads
- 1.01 Get Data, Connect to AdventureWorks Database
- 1.02 Get Data, Connect to Budget
- 1.03 Data Democracy and the Kitchen of Power BI
- 1.04A Get Data, Budget Cleanup
- 1.04B Get Data, Budget Unpivot & Data Types
- 1.05A Self-Documenting Awesomeness
- 1.05B Self-Documenting Awesomeness – Query Dependencies View
- 1.06 Query Editor vs. Macros (Changing an Existing Query)
- 1.07 Relationships: Data Table and Lookup Tables
- 1.08 Relationships: Visualize Data without Relationships
- 1.09 Relationships: Creating Relationships
- 1.10 DAX: Calculated Column
- 1.11 DAX: Measures
- 1.12 DAX: Calculated Column vs. Measures
- 1.13 DAX: Mo’ Measures
- 1.14 DAX: Implicit vs. Explicit Measures
- 1.15 DAX: Implicit vs. Explicit Measures – Analyze in Excel
- 1.16 DAX: Define Additional Measures (Budget Table)
- 1.17 DAX: Define “Hybrid” Measures
- 1.18 DAX: Magic Just Happened!
- 1.19 Visualization: Getting Started & Concepts
- 1.20 Visualization: First Elements – Text, Image & Cards
- 1.21 Visualization: Column and Bar Charts
- 1.22 Visualization: Line Chart, Top 10 Table
- 1.23 PowerBI.com: Publish and PowerBI.com Overview
- 1.24 PowerBI.com: Create a Dashboard
- CONGRATS! 🎉 You're Now Eligible to Participate in Our Dashboard Challenge
-
3
2. Query Engine
- 2.0 Downloads
- 2.1 Why? Query Editor
- 2.2 Connecting to Data
- 2.3 Query Transformations I - Filter, Fill Down
- 2.4 Query Transformations II - Replace Values
- 2.5 Query Transformations III - Split Column, Add Column
- 2.6 Query Transformations IV - Group By, Sort By Column
- 2.7 Best Practices
- 2.8 Append, From Folder, Multiple Excel Sheets
- 2.9 Flat to Star!
- 2.10 A "Functional" Language to handle the Dysfunctional Data in your Life
- 2.11 Example: Remove a Dynamic Number of Top Rows
- 2.12 Ultimate Calendar, Challenges!
-
4
3. Relationships
- 3.0 Downloads
- 3.2 Power BI Modeling
- 3.3 Relationships = Filter Transmission Wires
- 3.4 Measures Defined on Data Table
- 3.5 Measures Defined on Lookup Table vs Data Table
- 3.6 Use CALCULATE to Force Relationship Filter Uphill
- 3.7 Use Bi-Directional Filtering to Force Relationship Filter Uphill
- 3.8 Many-to-Many Relationships: Introduction
- 3.9 Many-to-Many Relationship: Analyze Data
- 3.10 Multiple Data Tables
- 3.11 Relate Tables using Multiple Fields (Using DAX)
- 3.12 Relate Tables using Multiple Fields (Using Table Copy)
-
5
4. DAX
- 4.0 Downloads
- 4.01 Filter Context
- 4.02 Incoming Filter Context
- 4.03 Relationship Filter Context
- 4.04 CALCULATE(): Simple Filters
- 4.05 CALCULATE(): Data Exploration
- 4.06 CALCULATE() Combine Simple Filters
- 4.07 ALL
- 4.08 Variables
- 4.09 X Functions
- 4.10 Filter
- 4.11 Setup and Blank
- 4.12 Disconnected Slicer
- 4.13 Profit Range Data Explore
- 4.14 Time Intelligence I
- 4.15 Time Intelligence II
- 4.16 Time Intelligence III
- 4.17 Row Context Transition
- 4.18 Sales LTD
- 4.19 ICAN
-
6
5. Visualization
- 05.01 Visualization: Why and What
- 05.02 Set the Stage
- 05.03 Power Pattern Principles
- 05.04 Power Pattern Usage Tips
- 05.05 How We See
- 05.06 Pre-Attentive Attributes
- 05.07 Pattern Recognition
- 05.08 Pattern Recognition Examples
- 05.09 Dashboard Audit
- 05.10 Dashboard Audit - Pixel Economy
- 05.11 Pixel Economy Example
- 05.12.1 Dashboard Audit - Full Audit Example
- 05.12.2 Dashboard Audit - Updated Dashboard
- 05.12.3 BONUS: Dashboard Audit - Update Dashboard Detail
- 05.12.4 BONUS: Download the Power BI File Used for Dashboard Full Audit Example
- BONUS: Visualization (Archived Lessons)
-
7
6. PowerBI.com Platform
- 6. Downloads
- 6.0 Power BI Premium vs Pro vs Free
- 6.0 Power BI Premium Explained
- 6.0 New Navigation Experience
- 6.1 Create Dashboard
- 6.2 Share Dashboard within Organization
- 6.3 Share Dashboard outside Organization and Publicly
- 6.4 Dashboard Tiles Tips and Tricks
- 6.5 Dashboard Tiles Actions and Quick Insightsf
- 6.6 Share via Groups (Workspaces)
- 6.7 Share via Power BI Apps
- 6.8 Create Excel & Power BI Reports connected to Published Model
- 6.9 Import Excel, Pin from Excel and Power BI Publisher for Excel
- 6.10 Refresh Overview and Refresh with Cloud Data Source
- 6.11 Refresh Model on OneDrive (Cloud)
- 6.12 Refresh with On Premise Data Source
- 6.13 Refresh with On Premise Data Source Contd...
- 6.14 On-Prem Data Source Refresh / Power Update
- 6.15 Mobile BI: Phone Layout for Dashboard and Reports
- 6.16 Role Level Security
-
8
Congratulations! Journey continues...
- Learn Power BI Class Survey
- Get Your Certificate of Completion!