Report Automation in the Public Sector
3 days|Delivered on request
Report Automation in the Public Sector takes the discipline and works it through the constraints of this operating context, including data quality management, statistical fundamentals and the compliance obligations that come with it. The sector framing is necessary because analysts are frequently self taught in the tool and untrained in the reasoning, and generic training rarely survives contact with the local rules. Delegates leave able to work confidently with DAX and calculated measures, pivot table analysis and spreadsheet controls in their own organisation.
What delegates leave able to do
- Put DAX and calculated measures on a footing they can defend to a reviewer, measured against dimensional modelling practice
- Make a decision about pivot table analysis without waiting for a specialist
- Take ownership of spreadsheet controls rather than escalating it
- Bring self service analytics into line with current good practice
What the course covers
- Data quality management
- Statistical fundamentals
- DAX and calculated measures
- Pivot table analysis
- Spreadsheet controls
- Self service analytics
- SQL querying
Who should attend
- finance professionals building reports
- reporting specialists
- management information officers
- operations managers using dashboards
