Recap and Data Model Design Principles

• Understanding the data modeling layer in Power BI
• Star and snowflake schema concepts
• Creating and managing relationships between tables

Introduction to DAX (Data Analysis Expressions)

• DAX syntax and data types
• Calculated columns vs. measures
• Common DAX functions: SUMX, CALCULATE, FILTER, RELATED

Advanced DAX and Business Logic

• Time intelligence functions (YTD, MTD, QTD)
• Conditional logic and dynamic calculations
• Ranking, running totals, and comparative metrics

Data Transformation and Optimization

• Working with Power Query for advanced transformations
• Combining multiple data sources efficiently
• Improving performance through query folding and relationships

Enhanced Visualizations and Interactivity

• Custom visuals and market extensions
• Drill-downs, bookmarks, and what-if parameters
• Creating paginated and dynamic reports

Performance and Governance in Power BI

• Best practices for dataset management
• Optimizing refresh schedules and query performance
• Implementing row-level security (RLS)

Hands-on Project: Building a Sales Intelligence Dashboard

• Developing KPIs with DAX measures
• Designing a model-driven dashboard for business insights
• Applying governance and sharing best practices

Summary and Next Steps