Spreadsheet Controls in the Public Sector
3 days|Delivered on request
Spreadsheet Controls in the Public Sector takes the discipline and works it through the constraints of this operating context, including report automation, visual encoding choices and the compliance obligations that come with it. The sector framing is necessary because reporting effort scales badly when the underlying model is wrong, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with forecasting techniques, statistical fundamentals and data quality management in their own organisation.
What delegates leave able to do
- Take ownership of forecasting techniques rather than escalating it, measured against dimensional modelling practice
- Put statistical fundamentals on a footing they can defend to a reviewer
- Spot where data quality management is failing before it becomes a finding
- Explain data warehouse concepts to someone who does not do the work
What the course covers
- Report automation
- Visual encoding choices
- Forecasting techniques
- Statistical fundamentals
- Data quality management
- Data warehouse concepts
- Data modelling
Who should attend
- operations managers using dashboards
- data analysts
- team leaders responsible for KPIs
- finance professionals building reports
