SQL for Analysts for Non-Specialists
2 days|Delivered on request
SQL for Analysts for Non-Specialists is built for delegates who need to be useful in this area quickly. It starts at first principles and works through data modelling and visual encoding choices without assuming prior specialist training. The programme exists because reporting effort scales badly when the underlying model is wrong, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with self service analytics, DAX and calculated measures and KPI definition in their own organisation.
What delegates leave able to do
- Make a decision about self service analytics without waiting for a specialist, measured against dimensional modelling practice
- Review DAX and calculated measures and say plainly whether it is working
- Improve KPI definition within their own organisation
- Take ownership of data quality management rather than escalating it
What the course covers
- Data modelling
- Visual encoding choices
- Self service analytics
- DAX and calculated measures
- KPI definition
- Data quality management
- Storytelling with data
Who should attend
- finance professionals building reports
- team leaders responsible for KPIs
- management information officers
- professionals moving into analytics
