Leading Excel Automation and Macros Teams
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers forecasting techniques and storytelling with data 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 data warehouse concepts, data quality management and SQL querying in their own organisation.
What delegates leave able to do
- Improve data warehouse concepts within their own organisation, measured against recognised data governance frameworks
- Take ownership of data quality management rather than escalating it
- Review SQL querying and say plainly whether it is working
- Explain statistical fundamentals to someone who does not do the work
What the course covers
- Forecasting techniques
- Storytelling with data
- Data warehouse concepts
- Data quality management
- SQL querying
- Statistical fundamentals
- Visual encoding choices
Who should attend
- professionals moving into analytics
- management information officers
- team leaders responsible for KPIs
- operations managers using dashboards
- data analysts
