Digital Transformation in Excel Automation and Macros
3 days|Delivered on request
This programme examines how the practice is shifting, and what delegates should adopt, adapt or ignore. It works through forecasting techniques and KPI definition as they stand today and where they are heading. The shift is worth understanding because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with SQL querying, data warehouse concepts and visual encoding choices in their own organisation.
What delegates leave able to do
- Review SQL querying and say plainly whether it is working, measured against recognised data governance frameworks
- Spot where data warehouse concepts is failing before it becomes a finding
- Improve visual encoding choices within their own organisation
- Make a decision about dashboard design without waiting for a specialist
What the course covers
- Forecasting techniques
- KPI definition
- SQL querying
- Data warehouse concepts
- Visual encoding choices
- Dashboard design
- Statistical fundamentals
Who should attend
- management information officers
- operations managers using dashboards
- business analysts
- professionals moving into analytics
