Advanced Excel Reporting and Analytics
5 days|Delivered on request
Advanced Excel Reporting and Analytics focuses on the measurement layer: what to count, what it means and how to present it. Delegates work through data quality management and self service analytics 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 storytelling with data, data warehouse concepts 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 recognised data governance frameworks
- Improve data warehouse concepts within their own organisation
- Put KPI definition on a footing they can defend to a reviewer
- Spot where forecasting techniques is failing before it becomes a finding
What the course covers
- Data quality management
- Self service analytics
- Storytelling with data
- Data warehouse concepts
- KPI definition
- Forecasting techniques
- Visual encoding choices
Who should attend
- business analysts
- professionals moving into analytics
- finance professionals building reports
- management information officers
