Data Modelling Auditing and Assurance
3 days|Delivered on request
This programme is written from the assurance side. Delegates learn to test whether DAX and calculated measures and self service analytics are working as claimed, and how to evidence the conclusion. Assurance work is under scrutiny because analysts are frequently self taught in the tool and untrained in the reasoning. Delegates leave able to work confidently with forecasting techniques, data governance and statistical fundamentals in their own organisation.
What delegates leave able to do
- Explain forecasting techniques to someone who does not do the work, measured against dimensional modelling practice
- Make a decision about data governance without waiting for a specialist
- Put statistical fundamentals on a footing they can defend to a reviewer
- Bring pivot table analysis into line with current good practice
What the course covers
- DAX and calculated measures
- Self service analytics
- Forecasting techniques
- Data governance
- Statistical fundamentals
- Pivot table analysis
- Dashboard design
Who should attend
- data analysts
- team leaders responsible for KPIs
- operations managers using dashboards
- business analysts
- reporting specialists
