Advanced analytics and modelling path
Fiscal calendars, filter-context control and performance on larger models.
For people who already write measures daily. Work through the trickier patterns and a bigger dataset.
What you will be able to do
- Implement fiscal-year calculations
- Control filter context with REMOVEFILTERS and KEEPFILTERS
- Compare actual with target and explain the variance
- Model a banking dataset with facts and dimensions
Before you start
- Solid DAX fundamentals (CALCULATE, filter context)
- Experience building star schemas
The path, step by step
- Fiscal year-to-date total - Year-to-date for any fiscal year
- Remove a filter with REMOVEFILTERS - Remove one table's filters
- Keep slicer selections with KEEPFILTERS - Respect slicers with KEEPFILTERS
- Actual vs target variance and attainment - Variance and attainment
- Retail Banking Accounts and Loans (synthetic) - A larger model to practise on
- SQL for Analytics - Optional: sharpen your SQL (optional)