Strategic SQL for Analysts
5 days|Delivered on request
Strategic SQL for Analysts looks at this work from the level at which it is resourced and defended. The focus is on KPI definition, data cleaning and preparation and how both connect to what the organisation is actually trying to achieve. This matters at the strategic level because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with visual encoding choices, dashboard design 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 dimensional modelling practice
- Make a decision about dashboard design without waiting for a specialist
- Review scenario modelling and say plainly whether it is working
- Bring statistical fundamentals into line with current good practice
What the course covers
- KPI definition
- Data cleaning and preparation
- Visual encoding choices
- Dashboard design
- Scenario modelling
- Statistical fundamentals
- SQL querying
Who should attend
- data analysts
- operations managers using dashboards
- management information officers
- business analysts
- professionals moving into analytics
