Practical Excel Automation and Macros
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through visual encoding choices and scenario modelling on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: analysts are frequently self taught in the tool and untrained in the reasoning, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with SQL querying, DAX and calculated measures and report automation in their own organisation.
What delegates leave able to do
- Spot where SQL querying is failing before it becomes a finding, measured against recognised data governance frameworks
- Make a decision about DAX and calculated measures without waiting for a specialist
- Put report automation on a footing they can defend to a reviewer
- Bring self service analytics into line with current good practice
What the course covers
- Visual encoding choices
- Scenario modelling
- SQL querying
- DAX and calculated measures
- Report automation
- Self service analytics
- Dashboard design
Who should attend
- team leaders responsible for KPIs
- data analysts
- management information officers
