Course Introduction
Course Guide
Meet Your Instructor
Syllabus
Practical Exercises Combined - Download
Data Sources
Calculation Items Demo
Connection & Storage Modes
DAX Formula Bar Shortcuts
DAX Functions by Category
Join Types & Join Relationships Explained
Most Common DAX Functions by Category
Sales Analysis
M Code Function for Creating Date Table
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
