Practical Data Analysis
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through data governance and spreadsheet controls on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: reporting effort scales badly when the underlying model is wrong, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with storytelling with data, SQL querying and KPI definition in their own organisation.
What delegates leave able to do
- Bring storytelling with data into line with current good practice, measured against dimensional modelling practice
- Explain SQL querying to someone who does not do the work
- Review KPI definition and say plainly whether it is working
- Make a decision about DAX and calculated measures without waiting for a specialist
What the course covers
- Data governance
- Spreadsheet controls
- Storytelling with data
- SQL querying
- KPI definition
- DAX and calculated measures
- Self service analytics
Who should attend
- reporting specialists
- business analysts
- operations managers using dashboards
