Leading SQL for Analysts Teams
3 days|Delivered on request
This programme is for the person accountable for the work rather than the person doing it. It covers spreadsheet controls and KPI definition from the position of someone who must review, approve and answer for the output. Managers carry this because reporting effort scales badly when the underlying model is wrong, and the accountability does not delegate cleanly. Delegates leave able to work confidently with visual encoding choices, SQL querying and scenario modelling in their own organisation.
What delegates leave able to do
- Put visual encoding choices on a footing they can defend to a reviewer, measured against established visualisation principles
- Explain SQL querying to someone who does not do the work
- Spot where scenario modelling is failing before it becomes a finding
- Take ownership of DAX and calculated measures rather than escalating it
What the course covers
- Spreadsheet controls
- KPI definition
- Visual encoding choices
- SQL querying
- Scenario modelling
- DAX and calculated measures
- Data modelling
Who should attend
- data analysts
- team leaders responsible for KPIs
- operations managers using dashboards
- finance professionals building reports
- business analysts
