Predictive Analytics in the Public Sector
3 days|Delivered on request
Predictive Analytics in the Public Sector takes the discipline and works it through the constraints of this operating context, including DAX and calculated measures, spreadsheet controls 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, self service analytics and SQL querying in their own organisation.
What delegates leave able to do
- Explain pivot table analysis to someone who does not do the work, measured against established visualisation principles
- Spot where self service analytics is failing before it becomes a finding
- Make a decision about SQL querying without waiting for a specialist
- Improve data cleaning and preparation within their own organisation
What the course covers
- DAX and calculated measures
- Spreadsheet controls
- Pivot table analysis
- Self service analytics
- SQL querying
- Data cleaning and preparation
- KPI definition
Who should attend
- operations managers using dashboards
- professionals moving into analytics
- data analysts
- management information officers
