• Module 1: Getting Started with Power BI
Power BI Desktop interface, key concepts, data types, and best practices for working with reports.
• Module 2: Connecting to Data Sources
Importing data from Excel, CSV, databases, SharePoint, and online services. Handling refreshes and basic data quality checks.
• Module 3: Data Cleaning with Power Query
Removing duplicates, handling missing values, splitting/merging columns, unpivoting data, and building repeatable query steps.
• Module 4: Data Modeling and Relationships
Star schema design, relationships, filters, and model optimization for performance and clarity.
• Module 5: DAX Fundamentals
Calculated columns vs. measures, basic DAX functions, aggregations, time intelligence, and common business calculations.
• Module 6: Visual Design and Dashboards
Choosing the right visuals, formatting, using slicers and filters, drill through pages, and building an executive dashboard.
• Module 7: Power BI Service and Sharing
Publishing reports, managing workspaces, sharing with stakeholders, scheduled refresh, and basic security concepts.
• Module 8: Capstone Dashboard Project
End to end project where you build a complete Power BI dashboard from raw data, present your findings, and receive feedback.