Power BI Front-End vs. Back-End
Basic Table Transformations
ASSIGNMENT: Table Transformations
SOLUTION: Table Transformations
PRO TIP: Storage & Connection Modes
Extracting Data from the Web
Data QA & Profiling Tools
ASSIGNMENT: Text-Specific Tools
SOLUTION: Text-Specific Tools
ASSIGNMENT: Numerical Tools
SOLUTION: Numerical Tools
PRO TIP: Rolling Calendars
ASSIGNMENT: Calendar Tables
SOLUTION: Calendar Tables
Index & Conditional Columns
Calculated Column Best Practices
PRO TIP: Appending Files from a Folder
PRO TIP: Data Source Parameters
PRO TIP: Importing Excel Models
Power Query Best Practices
QUIZ: Connecting & Shaping Data
Relationships vs. Merged Tables
Creating Table Relationships
Managing & Editing Relationships
ASSIGNMENT: Table Relationships
SOLUTION: Table Relationships
PRO TIP: Active & Inactive Relationships
Connecting Multiple Fact Tables
Filter Context & Filter Flow
Bi-Directional Filters & Ambiguity
Hiding Fields from Report View
Data Formats & Categories
Data Model Best Practices
QUIZ: Creating a Data Model
Data Analysis Expressions 101
Intro to DAX Calculated Columns
Implicit vs. Explicit Measures
RECAP: Calculated Columns vs. Measures
PRO TIP: Dedicated Measure Tables
Understanding Filter Context
Step-by-Step DAX Measure Calculation
Common DAX Function Categories
Basic Math & Stats Functions
ASSIGNMENT: Math & Stats Functions
SOLUTION: Math & Stats Functions
Conditional & Logical Functions
ASSIGNMENT: Logical Functions
SOLUTION: Logical Functions
ASSIGNMENT: Text Functions
Basic Date & Time Functions
Joining Data with RELATED
ASSIGNMENT: CALCULATE & ALL
SOLUTION: CALCULATE & ALL
Time Intelligence Patterns
ASSIGNMENT: Time Intelligence
SOLUTION: Time Intelligence
QUIZ: Calculated Fields with DAX
Dashboard Design Framework
Sketching the Dashboard Layout
Adding Report Pages & Objects
Naming & Grouping Objects
Building & Formatting Charts
PRO TIP: Trend Lines & Forecasts
ASSIGNMENT: Line Chart & Trend
SOLUTION: Line Chart & Trend
ASSIGNMENT: Donuts & Filters
SOLUTION: Donuts & Filters
ASSIGNMENT: Top N Text Cards
SOLUTION: Top N Text Cards
PRO TIP: Advanced Conditional Formatting
ASSIGNMENT: Drill Up & Drill Down
SOLUTION: Drill Up & Drill Down
Editing Report Interactions
ASSIGNMENT: Report Interactions
SOLUTION: Report Interactions
PRO TIP: Custom Navigation Buttons
ASSIGNMENT: Fields Parameters
SOLUTION: Fields Parameters
PRO TIP: Custom Tool Tips
PREVIEW: Publishing to Power BI Service
Data Visualization Best Practices
QUIZ: Visualizing Data with Reports