Spreadsheet Controls for Non-Specialists
2 days|Delivered on request
Spreadsheet Controls for Non-Specialists is built for delegates who need to be useful in this area quickly. It starts at first principles and works through data governance and statistical fundamentals without assuming prior specialist training. The programme exists because most organisations have more dashboards than decisions that depend on them, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with report automation, SQL querying and KPI definition in their own organisation.
What delegates leave able to do
- Bring report automation into line with current good practice, measured against recognised data governance frameworks
- Take ownership of SQL querying rather than escalating it
- Improve KPI definition within their own organisation
- Explain data cleaning and preparation to someone who does not do the work
What the course covers
- Data governance
- Statistical fundamentals
- Report automation
- SQL querying
- KPI definition
- Data cleaning and preparation
- Data quality management
Who should attend
- operations managers using dashboards
- team leaders responsible for KPIs
- management information officers
- professionals moving into analytics
