Spreadsheet Controls Reporting and Analytics
3 days|Delivered on request
Spreadsheet Controls Reporting and Analytics focuses on the measurement layer: what to count, what it means and how to present it. Delegates work through spreadsheet controls and data warehouse concepts and the reporting built on top of them. The reporting layer matters because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with report automation, scenario modelling and data cleaning and preparation in their own organisation.
What delegates leave able to do
- Explain report automation to someone who does not do the work, measured against dimensional modelling practice
- Take ownership of scenario modelling rather than escalating it
- Make a decision about data cleaning and preparation without waiting for a specialist
- Put forecasting techniques on a footing they can defend to a reviewer
What the course covers
- Spreadsheet controls
- Data warehouse concepts
- Report automation
- Scenario modelling
- Data cleaning and preparation
- Forecasting techniques
- Pivot table analysis
Who should attend
- business analysts
- data analysts
- team leaders responsible for KPIs
- operations managers using dashboards
