SQL for Analysts for Managers
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers self service analytics and SQL querying from the position of someone who must review, approve and answer for the output. Managers carry this because most organisations have more dashboards than decisions that depend on them, and the accountability does not delegate cleanly. Delegates leave able to work confidently with KPI definition, data cleaning and preparation and data warehouse concepts in their own organisation.
What delegates leave able to do
- Spot where KPI definition is failing before it becomes a finding, measured against established visualisation principles
- Improve data cleaning and preparation within their own organisation
- Bring data warehouse concepts into line with current good practice
- Make a decision about statistical fundamentals without waiting for a specialist
What the course covers
- Self service analytics
- SQL querying
- KPI definition
- Data cleaning and preparation
- Data warehouse concepts
- Statistical fundamentals
- Pivot table analysis
Who should attend
- reporting specialists
- team leaders responsible for KPIs
- management information officers
- professionals moving into analytics
- business analysts
