Module 1: Introduction to Power BI
What is Power BI; Power BI Desktop vs Service vs Mobile; Installing Power BI Desktop; Overview of interface; Connecting to data sources
Module 2: Data Loading & Transformation (Power Query)
Connecting to Excel, CSV, SQL, Web data; Using Power Query Editor; Cleaning and shaping data; Removing duplicates; Splitting columns; Changing data types
Module 3: Data Modeling
Creating relationships between tables; Star schema vs Snowflake schema; Data types and formatting; Calculated columns and measures; Introduction to DAX basics
Module 4: DAX for Data Analysis
DAX basics: SUM, AVERAGE, COUNT, DISTINCTCOUNT; Logical functions: IF, SWITCH; Time intelligence: TOTALYTD, SAMEPERIODLASTYEAR; Filter functions: CALCULATE, FILTER
Module 5: Data Visualization & Reports
Creating visuals: bar, column, line, pie, table, matrix; Formatting visuals; Slicers and filters; Bookmarks and navigation buttons
Module 6: Advanced Visuals & Customization
Conditional formatting; Hierarchies; Drillthrough and drilldown; Custom visuals from AppSource; Tooltips and visual interactions
Module 7: Power BI Service & Sharing
Publishing reports to Power BI Service; Workspaces and apps; Row-level security (RLS); Sharing dashboards; Power BI mobile access
Module 8: Power BI Advanced Analytics
Using DAX for advanced calculations; What-if parameters; Forecasting; Quick insights; Integration with AI visuals
Module 9: Data Refresh & Automation
Scheduled refresh; Gateway setup; Connecting to live and DirectQuery sources; Alerts and subscriptions
Module 10: Power BI Certification Preparation
Review of all exam objectives; Practice exercises; Mock exam; Best practices for Power BI report design