Course Introduction
Course Guide
Meet Your Instructor
1.1 Introduction
1.2 What is Power BI?
1.3 Power BI Product Suite
1.4 Downloading Power BI Desktop
1.5 Signing Up for Power BI Pro Trial
1.6 Important Notes
1.7 Typical Workflow
Practical Exercise
Test Your Knowledge
2.1 Power Query Interface
2.2 Power Query's Home Tab
2.3 Power Query's Add Column Tab
2.4 Power Query's Transform Tab
2.5 Transpose, Pivot and Unpivot
2.6 Data Preview Tools
2.7 Power Query's Tools and Help Tabs
2.8 Parameters in Power Query
2.9 Merging or Joining Data in Power Query
2.10 Appending (Like a Union) Data in Power Query
2.11 Primary vs Foreign Keys
2.12 Database Design in Data Modeling
2.13 Slight Snowflake Schema
2.14 Ambiguity & Cross Filter Direction
2.15 Additional Transformations in Each View Type
Practical Exercise
Test Your Knowledge
3.1 Implicit vs Explicit Measures
3.2 DAX Basics
3.3 Quick Measures
3.4 DAX Syntax - Functions
3.5 DAX Syntax - Basic Operators
3.6 Deciding Between Calculated Columns and Measures
3.7 Dedicated Measures Tables
Practical Exercise
Test Your Knowledge
4.1 Custom Hierarchies
4.2 Date Hierarchies
4.3 Recreating Month Year Field in Power Query
4.4 Dedicated Date Tables
Practical Exercise
Test Your Knowledge
5.1 Visualization Basics
5.2 Bar & Column Charts
5.3 Line & Area Charts
5.4 Speciality Chart
5.5 Pie & Tree-Based Charts
5.6 Map Visuals - Basic Map
5.7 Map Visuals - Filled Map
5.8 Map Visuals - Shape Map
5.9 KPI & Summary - Gauge
5.10 KPI & Summary - Card Visuals & Multi-Row Card
5.11 KPI & Summary - KPI
5.12 KPI & Summary - Table & Matrix
5.13 AI - Anomalies
5.14 AI - Key Influencers
5.15 AI - Decomposition Tree
5.16 AI - Q&A
5.17 AI - Narratives
5.18 Filtering - Behind the Scenes Filters
5.19 Filtering - Slicer Options
5.20 Filtering - Cross Filters
5.21 Goals
5.22 Remaining Visuals
5.23 Fixing Ambiguous Geographic Fields
Practical Exercise
Test Your Knowledge
