Spreadsheet Controls: Tools and Techniques
3 days|Delivered on request
This is a hands-on programme. Delegates spend most of the time working through DAX and calculated measures and data cleaning and preparation on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: most organisations have more dashboards than decisions that depend on them, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with pivot table analysis, data governance and self service analytics in their own organisation.
What delegates leave able to do
- Review pivot table analysis and say plainly whether it is working, measured against dimensional modelling practice
- Improve data governance within their own organisation
- Explain self service analytics to someone who does not do the work
- Put forecasting techniques on a footing they can defend to a reviewer
What the course covers
- DAX and calculated measures
- Data cleaning and preparation
- Pivot table analysis
- Data governance
- Self service analytics
- Forecasting techniques
- Statistical fundamentals
Who should attend
- business analysts
- finance professionals building reports
- operations managers using dashboards
