Spreadsheet Controls for Small and Medium Enterprises
3 days|Delivered on request
Spreadsheet Controls for Small and Medium Enterprises takes the discipline and works it through the constraints of this operating context, including KPI definition, dashboard design and the compliance obligations that come with it. The sector framing is necessary because most organisations have more dashboards than decisions that depend on them, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with pivot table analysis, data modelling and data quality management in their own organisation.
What delegates leave able to do
- Take ownership of pivot table analysis rather than escalating it, measured against dimensional modelling practice
- Make a decision about data modelling without waiting for a specialist
- Review data quality management and say plainly whether it is working
- Put forecasting techniques on a footing they can defend to a reviewer
What the course covers
- KPI definition
- Dashboard design
- Pivot table analysis
- Data modelling
- Data quality management
- Forecasting techniques
- Report automation
Who should attend
- management information officers
- professionals moving into analytics
- reporting specialists
- operations managers using dashboards
