Data Modelling: Tools and Techniques
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through pivot table analysis and dashboard design 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, data governance and DAX and calculated measures in their own organisation.
What delegates leave able to do
- Put storytelling with data on a footing they can defend to a reviewer, measured against dimensional modelling practice
- Bring data governance into line with current good practice
- Make a decision about DAX and calculated measures without waiting for a specialist
- Improve scenario modelling within their own organisation
What the course covers
- Pivot table analysis
- Dashboard design
- Storytelling with data
- Data governance
- DAX and calculated measures
- Scenario modelling
- Data warehouse concepts
Who should attend
- business analysts
- finance professionals building reports
- team leaders responsible for KPIs
