Excel Automation and Macros Masterclass
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into data quality management, visual encoding choices and the judgement calls that sit outside recognised data governance frameworks. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because analysts are frequently self taught in the tool and untrained in the reasoning. Delegates leave able to work confidently with dashboard design, DAX and calculated measures and forecasting techniques in their own organisation.
What delegates leave able to do
- Bring dashboard design into line with current good practice, measured against recognised data governance frameworks
- Take ownership of DAX and calculated measures rather than escalating it
- Spot where forecasting techniques is failing before it becomes a finding
- Review KPI definition and say plainly whether it is working
What the course covers
- Data quality management
- Visual encoding choices
- Dashboard design
- DAX and calculated measures
- Forecasting techniques
- KPI definition
- Data governance
Who should attend
- operations managers using dashboards
- business analysts
- management information officers
- reporting specialists
- finance professionals building reports
