Dashboard Design in the Public Sector
3 days|Delivered on request
Dashboard Design in the Public Sector takes the discipline and works it through the constraints of this operating context, including dashboard design, DAX and calculated measures 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 SQL querying, data governance and visual encoding choices in their own organisation.
What delegates leave able to do
- Bring SQL querying into line with current good practice, measured against recognised data governance frameworks
- Explain data governance to someone who does not do the work
- Spot where visual encoding choices is failing before it becomes a finding
- Review spreadsheet controls and say plainly whether it is working
What the course covers
- Dashboard design
- DAX and calculated measures
- SQL querying
- Data governance
- Visual encoding choices
- Spreadsheet controls
- Pivot table analysis
Who should attend
- finance professionals building reports
- operations managers using dashboards
- team leaders responsible for KPIs
- professionals moving into analytics
