Excel Automation and Macros
3 days|Delivered on request
This Excel Automation and Macros programme gives delegates a working command of statistical fundamentals and pivot table analysis, grounded in dimensional modelling practice. Organisations invest here because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with visual encoding choices, KPI definition and scenario modelling in their own organisation.
What delegates leave able to do
- Spot where visual encoding choices is failing before it becomes a finding, measured against dimensional modelling practice
- Bring KPI definition into line with current good practice
- Make a decision about scenario modelling without waiting for a specialist
- Explain DAX and calculated measures to someone who does not do the work
What the course covers
- Statistical fundamentals
- Pivot table analysis
- Visual encoding choices
- KPI definition
- Scenario modelling
- DAX and calculated measures
- Forecasting techniques
Who should attend
- professionals moving into analytics
- business analysts
- data analysts
