Advanced Forecasting Techniques
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into dashboard design, DAX and calculated measures 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 analysts are frequently self taught in the tool and untrained in the reasoning. Delegates leave able to work confidently with SQL querying, data quality management and report automation in their own organisation.
What delegates leave able to do
- Make a decision about SQL querying without waiting for a specialist, measured against dimensional modelling practice
- Spot where data quality management is failing before it becomes a finding
- Take ownership of report automation rather than escalating it
- Improve data warehouse concepts within their own organisation
What the course covers
- Dashboard design
- DAX and calculated measures
- SQL querying
- Data quality management
- Report automation
- Data warehouse concepts
- Spreadsheet controls
Who should attend
- reporting specialists
- finance professionals building reports
- business analysts
- management information officers
- operations managers using dashboards
