Practical Spreadsheet Controls
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through SQL querying and visual encoding choices 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 scenario modelling, self service analytics and data governance in their own organisation.
What delegates leave able to do
- Make a decision about scenario modelling without waiting for a specialist, measured against dimensional modelling practice
- Take ownership of self service analytics rather than escalating it
- Spot where data governance is failing before it becomes a finding
- Improve statistical fundamentals within their own organisation
What the course covers
- SQL querying
- Visual encoding choices
- Scenario modelling
- Self service analytics
- Data governance
- Statistical fundamentals
- Dashboard design
Who should attend
- professionals moving into analytics
- business analysts
- data analysts
