Unit 1: Getting Started with Power BI
Introduction to Power BI: Desktop, Service, Mobile, Power BI interface and navigation, Data sources and data connectivity, Importing and transforming data using Power Query, Data load options: Import vs DirectQuery, Saving and publishing reports to Power BI Service
Unit 2: Data Preparation and Modeling
Data cleaning and shaping using Power Query Editor, Creating relationships and data models, Working with calculated columns and measures, Introduction to DAX (Data Analysis Expressions), Creating hierarchies and date tables, Managing data types, categories, and formatting
Unit 3: Data Visualization and Charts
Basic visualizations: bar, column, line, pie, table, matrix, Advanced charts: funnel, gauge, waterfall, KPI, maps, Conditional formatting and drill-through, Creating and using slicers and filters , Tooltips, bookmarks, buttons, and selections, Custom visuals and themes
Unit 4: Calculations and Advanced Analytics
Creating and using DAX functions: SUMX, CALCULATE, FILTER, etc., Time Intelligence functions in DAX, Calculated tables and fields, Aggregations and nested measures, What-if analysis using parameters, Using analytics pane: trend lines, forecasts, reference lines
Unit 5: Storytelling and Sharing Insights
Creating dashboards and reports, Layout optimization for desktop and mobile, Designing effective data stories using bookmarks and navigation, Embedding insights in PowerPoint, Teams, and SharePoint, Exporting to PDF and Power BI Service sharing, Best practices in dashboard design and storytelling