- Refreshing Key Concepts
- Importance of data modeling
- Relationships between tables
- Basic DAX formulas and measures
- Advanced Visualizations
- When and how to use matrices, maps, funnels and other visuals
- Demo creating a map visualization with layers
- Tips for customizing visuals for better insights
- Complex DAX Measures
- Explain difference between calculated columns and measures
- Write measures using SUMX, CALCULATE, FILTER, etc.
- Demo a year-over-year sales growth measure
- Optimizing Query Performance
- Explain Import vs DirectQuery
- Tips for improving refresh speeds
- Demo aggregating data queries for faster refresh
- Q&A
Every participant who attends the complete live webinar will receive a Certificate of Participation from Cognixia.