Advanced Power BI MasterClass (19 Hours Content)
Power BI MasterClass – Course Content
Total Duration: 25 Hours
Level: Beginner to Advanced
Module 1: Power BI Basics & Data Modeling
• Introduction to Power BI & Interface Walkthrough
• Connecting to Data Sources
- Excel
- SQL
- CSV
- Web
• Power Query (ETL Basics)
- Importing & Cleaning Data
- Merge Queries
- Append Queries
- Conditional Columns
- Custom Columns
• Basic Visualizations
- Bar Charts
- Column Charts
- Line Charts
- Pie Charts
- Donut Charts
- Cards
- KPI Visuals
Module 2: Intermediate Power BI
• Data Modeling Fundamentals
• Schema Design
- Star Schema
- Snowflake Schema
• Relationships
- One-to-Many
- Many-to-Many
- Active vs Inactive Relationships
Module 3: DAX – Data Analysis Expressions
• Introduction to DAX
• Calculated Columns vs Measures
• Aggregate Functions
- SUM
- AVERAGE
- COUNTROWS
• Time Intelligence Functions
- TOTALYTD
- SAMEPERIODLASTYEAR
- DATEDIFF
• Filter Context & CALCULATE
• Advanced DAX Functions
- ALL
- VALUES
- FILTER
- RANKX
- DIVIDE
- IF
- ISBLANK
- SUM
- AVERAGE
- SUMX
- AVERAGEX
- MAX
- MIN
- COUNTROWS
- CALCULATE
- TOPN
- RELATED
- EARLIER
- EARLIEST
- CURRENTGROUP
- TOTALYTD
- SAMEPERIODLASTYEAR
- CALENDAR
- CALENDARAUTO
- DATE
- YEAR
- MONTH
- DAY
- DATEDIFF
- ADDCOLUMNS
- SUMMARIZE
- GROUPBY
Module 4: Advanced Power BI
• Power BI Service
• Power BI Mobile
• Licenses
• Workspace
• Roles
• Data Refresh
- Refresh
- Scheduled Refresh
- Gateway
- Incremental Refresh
• Row Level Security (RLS)
• Interactivity
- Drill-through
- Drill Down
- Bookmarks
- Selection Pane
- Buttons (Page / Bookmarks)
• Connectivity Modes
- Import
- DirectQuery
- Live Connection
• Slicers vs Filters
• Tooltip
Module 5: Power BI Project
• Volkswagen LIVE Power BI Project
• 4 Critical Business Questions