Leading Spreadsheet Controls Teams
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers forecasting techniques and data cleaning and preparation from the position of someone who must review, approve and answer for the output. Managers carry this because most organisations have more dashboards than decisions that depend on them, and the accountability does not delegate cleanly. Delegates leave able to work confidently with data quality management, spreadsheet controls and KPI definition in their own organisation.
What delegates leave able to do
- Take ownership of data quality management rather than escalating it, measured against dimensional modelling practice
- Improve spreadsheet controls within their own organisation
- Review KPI definition and say plainly whether it is working
- Make a decision about data modelling without waiting for a specialist
What the course covers
- Forecasting techniques
- Data cleaning and preparation
- Data quality management
- Spreadsheet controls
- KPI definition
- Data modelling
- Data warehouse concepts
Who should attend
- management information officers
- data analysts
- professionals moving into analytics
- business analysts
- reporting specialists
