Spreadsheet Controls for Managers
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers report automation and SQL querying from the position of someone who must review, approve and answer for the output. Managers carry this because reporting effort scales badly when the underlying model is wrong, and the accountability does not delegate cleanly. Delegates leave able to work confidently with spreadsheet controls, storytelling with data and pivot table analysis in their own organisation.
What delegates leave able to do
- Take ownership of spreadsheet controls rather than escalating it, measured against recognised data governance frameworks
- Improve storytelling with data within their own organisation
- Make a decision about pivot table analysis without waiting for a specialist
- Explain DAX and calculated measures to someone who does not do the work
What the course covers
- Report automation
- SQL querying
- Spreadsheet controls
- Storytelling with data
- Pivot table analysis
- DAX and calculated measures
- Dashboard design
Who should attend
- business analysts
- reporting specialists
- team leaders responsible for KPIs
- professionals moving into analytics
- operations managers using dashboards
