Practical Report Automation
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through spreadsheet controls and KPI definition on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: most organisations have more dashboards than decisions that depend on them, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with data governance, SQL querying and dashboard design in their own organisation.
What delegates leave able to do
- Take ownership of data governance rather than escalating it, measured against recognised data governance frameworks
- Make a decision about SQL querying without waiting for a specialist
- Explain dashboard design to someone who does not do the work
- Bring statistical fundamentals into line with current good practice
What the course covers
- Spreadsheet controls
- KPI definition
- Data governance
- SQL querying
- Dashboard design
- Statistical fundamentals
- Pivot table analysis
Who should attend
- finance professionals building reports
- business analysts
- data analysts
