Skip to content

Training across Africa, the Middle East and live online

069 221 6943

ISP TrainingsInnovative Special Projects

Arrow keys to moveEnter to openEsc to close

Print this page or save it as a PDF to circulate internally.

Back to the course
Innovative Special Projects

Executive and professional training

305 Glenwood Road, Faerie Glen, Pretoria, South Africa

069 221 6943

info@isptrainings.co.za

Advanced Spreadsheet Controls

Data and Business Intelligence|5 days|Classroom or live online

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

Fees

South AfricaR18 000
Elsewhere in Africa and the GulfUSD 1 800
Live onlineUSD 900

Per delegate, for the full 5 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

12 to 16 Oct 2026Cape TownR18 000
23 to 27 Nov 2026PretoriaR18 000
4 to 8 Jan 2027DurbanR18 000
15 to 19 Feb 2027AccraUSD 1 800
5 to 9 Apr 2027NairobiUSD 1 800
17 to 21 May 2027DurbanR18 000
14 to 18 Jun 2027WindhoekUSD 1 800
12 to 16 Jul 2027AccraUSD 1 800
30 Aug to 3 Sep 2027LagosUSD 1 800
27 Sep to 1 Oct 2027JohannesburgR18 000
25 to 29 Oct 2027OnlineUSD 900
29 Nov to 3 Dec 2027KigaliUSD 1 800

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)