Skip to content

Training across Africa, the Middle East and live online

069 221 6943

ISP TrainingsInnovative Special Projects

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

Practical SQL for Analysts

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

This is a hands-on programme. Delegates spend most of the time working through data cleaning and preparation and report automation on live scenarios rather than listening to theory about them. The practical emphasis is deliberate: analysts are frequently self taught in the tool and untrained in the reasoning, and reading about the method has repeatedly proved insufficient. Delegates leave able to work confidently with dashboard design, statistical fundamentals and DAX and calculated measures in their own organisation.

What delegates leave able to do

  • Put dashboard design on a footing they can defend to a reviewer, measured against dimensional modelling practice
  • Improve statistical fundamentals within their own organisation
  • Explain DAX and calculated measures to someone who does not do the work
  • Bring scenario modelling into line with current good practice

What the course covers

  • Data cleaning and preparation
  • Report automation
  • Dashboard design
  • Statistical fundamentals
  • DAX and calculated measures
  • Scenario modelling
  • Data quality management

Who should attend

  • data analysts
  • management information officers
  • business analysts

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

11 to 13 Jan 2027DubaiUSD 1 500
1 to 3 Mar 2027DubaiUSD 1 500
29 to 31 Mar 2027PretoriaR13 000
17 to 19 May 2027DurbanR13 000
28 to 30 Jun 2027Dar es SalaamUSD 1 500
2 to 4 Aug 2027PretoriaR13 000
13 to 15 Sep 2027OnlineUSD 900
25 to 27 Oct 2027LagosUSD 1 500
22 to 24 Nov 2027PretoriaR13 000

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)