Artificial Intelligence in Advanced Excel
3 days|Delivered on request
This programme examines how the practice is shifting, and what delegates should adopt, adapt or ignore. It works through pivot table analysis and data governance as they stand today and where they are heading. The shift is worth understanding because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with statistical fundamentals, forecasting techniques and SQL querying in their own organisation.
What delegates leave able to do
- Review statistical fundamentals and say plainly whether it is working, measured against recognised data governance frameworks
- Improve forecasting techniques within their own organisation
- Explain SQL querying to someone who does not do the work
- Put self service analytics on a footing they can defend to a reviewer
What the course covers
- Pivot table analysis
- Data governance
- Statistical fundamentals
- Forecasting techniques
- SQL querying
- Self service analytics
- KPI definition
Who should attend
- management information officers
- team leaders responsible for KPIs
- operations managers using dashboards
- business analysts
