Advanced Spreadsheet Controls
5 days|Delivered on request
This advanced programme assumes delegates already work in the field. It goes past the basics into storytelling with data, spreadsheet controls and the judgement calls that sit outside dimensional modelling practice. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because reporting effort scales badly when the underlying model is wrong. Delegates leave able to work confidently with data warehouse concepts, scenario modelling and visual encoding choices in their own organisation.
What delegates leave able to do
- Spot where data warehouse concepts is failing before it becomes a finding, measured against dimensional modelling practice
- Bring scenario modelling into line with current good practice
- Review visual encoding choices and say plainly whether it is working
- Explain data quality management to someone who does not do the work
What the course covers
- Storytelling with data
- Spreadsheet controls
- Data warehouse concepts
- Scenario modelling
- Visual encoding choices
- Data quality management
- Report automation
Who should attend
- reporting specialists
- team leaders responsible for KPIs
- business analysts
- management information officers
- finance professionals building reports
