SQL for Analysts
3 days|Delivered on request
This SQL for Analysts programme gives delegates a working command of forecasting techniques and storytelling with data, grounded in dimensional modelling practice. Organisations invest here because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with self service analytics, scenario modelling and data cleaning and preparation in their own organisation.
What delegates leave able to do
- Bring self service analytics into line with current good practice, measured against dimensional modelling practice
- Explain scenario modelling to someone who does not do the work
- Take ownership of data cleaning and preparation rather than escalating it
- Make a decision about pivot table analysis without waiting for a specialist
What the course covers
- Forecasting techniques
- Storytelling with data
- Self service analytics
- Scenario modelling
- Data cleaning and preparation
- Pivot table analysis
- KPI definition
Who should attend
- reporting specialists
- data analysts
- operations managers using dashboards
