Fundamentals of SQL for Analysts
2 days|Delivered on request
Fundamentals of SQL for Analysts is built for delegates who need to be useful in this area quickly. It starts at first principles and works through data modelling and KPI definition without assuming prior specialist training. The programme exists because most organisations have more dashboards than decisions that depend on them, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with pivot table analysis, data warehouse concepts and DAX and calculated measures in their own organisation.
What delegates leave able to do
- Explain pivot table analysis to someone who does not do the work, measured against recognised data governance frameworks
- Improve data warehouse concepts within their own organisation
- Take ownership of DAX and calculated measures rather than escalating it
- Review storytelling with data and say plainly whether it is working
What the course covers
- Data modelling
- KPI definition
- Pivot table analysis
- Data warehouse concepts
- DAX and calculated measures
- Storytelling with data
- Data governance
Who should attend
- management information officers
- operations managers using dashboards
- professionals moving into analytics
- data analysts
