Advanced Excel Automation and Macros
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into storytelling with data, KPI definition and the judgement calls that sit outside dimensional modelling practice. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with dashboard design, forecasting techniques and self service analytics in their own organisation.
What delegates leave able to do
- Make a decision about dashboard design without waiting for a specialist, measured against dimensional modelling practice
- Bring forecasting techniques into line with current good practice
- Review self service analytics and say plainly whether it is working
- Put DAX and calculated measures on a footing they can defend to a reviewer
What the course covers
- Storytelling with data
- KPI definition
- Dashboard design
- Forecasting techniques
- Self service analytics
- DAX and calculated measures
- Spreadsheet controls
Who should attend
- reporting specialists
- finance professionals building reports
- professionals moving into analytics
- business analysts
- data analysts
