Strategic Excel Automation and Macros
5 days|Delivered on request
Strategic Excel Automation and Macros looks at this work from the level at which it is resourced and defended. The focus is on pivot table analysis, forecasting techniques and how both connect to what the organisation is actually trying to achieve. This matters at the strategic level because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with SQL querying, self service analytics and visual encoding choices in their own organisation.
What delegates leave able to do
- Explain SQL querying to someone who does not do the work, measured against recognised data governance frameworks
- Put self service analytics on a footing they can defend to a reviewer
- Improve visual encoding choices within their own organisation
- Take ownership of dashboard design rather than escalating it
What the course covers
- Pivot table analysis
- Forecasting techniques
- SQL querying
- Self service analytics
- Visual encoding choices
- Dashboard design
- KPI definition
Who should attend
- business analysts
- finance professionals building reports
- management information officers
- data analysts
- team leaders responsible for KPIs
