SQL for Analysts Masterclass
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into statistical fundamentals, data cleaning and preparation 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 KPI definition, storytelling with data and forecasting techniques in their own organisation.
What delegates leave able to do
- Take ownership of KPI definition rather than escalating it, measured against dimensional modelling practice
- Explain storytelling with data to someone who does not do the work
- Review forecasting techniques and say plainly whether it is working
- Put data governance on a footing they can defend to a reviewer
What the course covers
- Statistical fundamentals
- Data cleaning and preparation
- KPI definition
- Storytelling with data
- Forecasting techniques
- Data governance
- DAX and calculated measures
Who should attend
- management information officers
- data analysts
- operations managers using dashboards
- finance professionals building reports
- business analysts
