Learn from Power BI developers! Master transformations, data modeling, DAX, dynamic reports, advanced report concepts and get Pro tips & tricks.
In two days, two experienced Power BI developers will show you path to achieve pro-level Power BI proficiency.
Agenda:
Day 1:
- Transformations (Using parameters; Changing data sources; Load multiple sheets from multiple files; Advanced editor)
- Data modeling basics (Facts / dimensions; Star schema; Relationships)
- Data modeling scenarios (Multiple fact tables; Granularity - Actuals vs Budget; Invoice header / invoice detail)
Day 2:
- DAX Basics (Row / filter context; Calculated columns vs measures; Date dimension with DAX; Time intelligence; What-if parameters)
- Dynamic reports (Bookmarks, selections, buttons; Drill-through buttons; Sync slicers; Conditional formatting)
- Advanced report concepts (Row Level Security; Incremental refresh; Aggregations)
- Pro tips & tricks (DAX studio; Tabular editor; Development best practices)