Power BI Syllabus -Intermediate
Module 1: Power BI Introduction
- What is Power BI? Desktop vs. Service (Free vs. Pro vs. Premium)
- Power BI Architecture and Data Flow
- Exploring the Power BI Desktop Interface
Module 2: Data Transformation Using Power Query
- Connecting to Excel, CSV, and Web Data
- Cleaning: Remove/Fill/Replace/Trim
- Splitting & Merging Columns
- Pivoting, Unpivoting, Grouping
- Basic Parameter Use (Manual Parameters)
Module 3: Data Modeling & Relationships
- Tables, Columns, and Data Types
- Star Schema Basics
- Relationships and Cardinality
- Creating and Using a Date Table
- Managing Hierarchies in Data
Module 4: Core DAX for Measures
- DAX Syntax & Concepts: Row vs Filter Context
- Calculated Columns vs Measures
- Common DAX: SUM, AVERAGE, COUNT, DISTINCTCOUNT
- Logical Functions: IF, SWITCH
- Core Functions: CALCULATE, FILTER
- Time Intelligence: YTD, MTD, SAMEPERIODLASTYEAR
- Context & Filter Modifiers: ALL, ALLSELECTED, ALLEXCEPT
- What-if Parameters & Quick Measures
Module 5: Visualizations & Report Design
- Bar, Column, Line, Card, Matrix, Map Visuals
- Slicers and Filters
- Tooltips, Drill-through, Bookmarks
- Conditional Formatting: Colors, Icons, Data Bars
- Report Layout and Theme Tips
Module 6: Power BI Service Concepts
- Power BI Service Overview
- Publishing Reports to My Workspace
- Introduction to Power BI Gateway:
Data Refresh Concepts:
- Manual refresh vs Scheduled refresh
- Gateway requirement for automatic refresh
- Local refresh best practices in Power BI Desktop
Module 7: Row-Level Security
- RLS Concept and Real-world Use Cases
- Creating Static RLS Roles in Power BI Desktop
- Testing RLS in Desktop
- Understanding RLS Limitations in Free License (interview guidance)
Module 8: Optimization
- Performance Analyzer Tool
- Visual Optimization Tips