Excel Automation and Macros Auditing and Assurance
3 days|Delivered on request
This programme is written from the assurance side. Delegates learn to test whether scenario modelling and data warehouse concepts are working as claimed, and how to evidence the conclusion. Assurance work is under scrutiny because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with data governance, DAX and calculated measures and dashboard design in their own organisation.
What delegates leave able to do
- Spot where data governance is failing before it becomes a finding, measured against established visualisation principles
- Bring DAX and calculated measures into line with current good practice
- Improve dashboard design within their own organisation
- Make a decision about storytelling with data without waiting for a specialist
What the course covers
- Scenario modelling
- Data warehouse concepts
- Data governance
- DAX and calculated measures
- Dashboard design
- Storytelling with data
- Visual encoding choices
Who should attend
- operations managers using dashboards
- management information officers
- business analysts
- reporting specialists
- team leaders responsible for KPIs
