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

Digital Transformation in Excel Automation and Macros

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

This programme examines how the practice is shifting, and what delegates should adopt, adapt or ignore. It works through forecasting techniques and KPI definition as they stand today and where they are heading. The shift is worth understanding because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with SQL querying, data warehouse concepts and visual encoding choices in their own organisation.

What delegates leave able to do

  • Review SQL querying and say plainly whether it is working, measured against recognised data governance frameworks
  • Spot where data warehouse concepts is failing before it becomes a finding
  • Improve visual encoding choices within their own organisation
  • Make a decision about dashboard design without waiting for a specialist

What the course covers

  • Forecasting techniques
  • KPI definition
  • SQL querying
  • Data warehouse concepts
  • Visual encoding choices
  • Dashboard design
  • Statistical fundamentals

Who should attend

  • management information officers
  • operations managers using dashboards
  • business analysts
  • professionals moving into analytics

Fees

South AfricaR13 000
Elsewhere in Africa and the GulfUSD 1 500
Live onlineUSD 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

5 to 7 Oct 2026AccraUSD 1 500
23 to 25 Nov 2026Cape TownR13 000
1 to 3 Feb 2027DubaiUSD 1 500
8 to 10 Mar 2027Dar es SalaamUSD 1 500
26 to 28 Apr 2027DurbanR13 000
31 May to 2 Jun 2027PretoriaR13 000
28 to 30 Jun 2027JohannesburgR13 000
2 to 4 Aug 2027Dar es SalaamUSD 1 500
13 to 15 Sep 2027DurbanR13 000
18 to 20 Oct 2027OnlineUSD 900
22 to 24 Nov 2027DubaiUSD 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)