Forecasting Techniques in the Public Sector
3 days|Delivered on request
Forecasting Techniques in the Public Sector takes the discipline and works it through the constraints of this operating context, including self service analytics, data cleaning and preparation 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 spreadsheet controls, pivot table analysis and storytelling with data in their own organisation.
What delegates leave able to do
- Make a decision about spreadsheet controls without waiting for a specialist, measured against recognised data governance frameworks
- Take ownership of pivot table analysis rather than escalating it
- Bring storytelling with data into line with current good practice
- Spot where SQL querying is failing before it becomes a finding
What the course covers
- Self service analytics
- Data cleaning and preparation
- Spreadsheet controls
- Pivot table analysis
- Storytelling with data
- SQL querying
- Data modelling
Who should attend
- business analysts
- data analysts
- reporting specialists
- finance professionals building reports
