Advanced Excel Auditing and Assurance
5 days|Delivered on request
This programme is written from the assurance side. Delegates learn to test whether KPI definition and visual encoding choices are working as claimed, and how to evidence the conclusion. Assurance work is under scrutiny because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with scenario modelling, dashboard design and forecasting techniques in their own organisation.
What delegates leave able to do
- Put scenario modelling on a footing they can defend to a reviewer, measured against dimensional modelling practice
- Make a decision about dashboard design without waiting for a specialist
- Bring forecasting techniques into line with current good practice
- Explain data cleaning and preparation to someone who does not do the work
What the course covers
- KPI definition
- Visual encoding choices
- Scenario modelling
- Dashboard design
- Forecasting techniques
- Data cleaning and preparation
- Data modelling
Who should attend
- professionals moving into analytics
- team leaders responsible for KPIs
- reporting specialists
- finance professionals building reports
- operations managers using dashboards
