Print this page or save it as a PDF to circulate internally.
Back to the course
Executive and professional training
305 Glenwood Road, Faerie Glen, Pretoria, South Africa
069 221 6943
info@isptrainings.co.za
Spreadsheet Controls Reporting and Analytics
Data and Business Intelligence|3 days|Classroom or live online
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
Fees
| South Africa | R13 000 |
| Elsewhere in Africa and the Gulf | USD 1 500 |
| Live online | USD 900 |
Per delegate, for the full 3 days. Covers tuition, course materials and refreshments. Excludes travel and accommodation. South African courses carry VAT at 15%; on deliveries outside South Africa the VAT position is confirmed on the quotation, because it depends on where your organisation is registered.
Scheduled dates
| 16 to 18 Nov 2026 | Dubai | USD 1 500 |
| 4 to 6 Jan 2027 | Durban | R13 000 |
| 1 to 3 Feb 2027 | Online | USD 900 |
| 8 to 10 Mar 2027 | Johannesburg | R13 000 |
| 5 to 7 Apr 2027 | Cape Town | R13 000 |
| 17 to 19 May 2027 | Lagos | USD 1 500 |
| 21 to 23 Jun 2027 | Johannesburg | R13 000 |
| 26 to 28 Jul 2027 | Pretoria | R13 000 |
| 13 to 15 Sep 2027 | Cape Town | R13 000 |
| 11 to 13 Oct 2027 | Pretoria | R13 000 |
| 29 Nov to 1 Dec 2027 | Dubai | USD 1 500 |
Dates are the published schedule at the time this page was printed. We also run this programme on request, and in-house for a full team.
How to book
Call 069 221 6943 or email info@isptrainings.co.za with the date and the number of delegates. We reply with a written quotation and an invoice. A registration is not a confirmed booking until we confirm it in writing.
Innovative Special Projects|Monday to Friday, 08:00 to 18:00 (SAST)