Fundamentals of SQL for Analysts

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

Fundamentals of SQL for Analysts is built for delegates who need to be useful in this area quickly. It starts at first principles and works through data modelling and KPI definition without assuming prior specialist training. The programme exists because most organisations have more dashboards than decisions that depend on them, and because capability in this area is usually built on the job with no structure behind it. Delegates leave able to work confidently with pivot table analysis, data warehouse concepts and DAX and calculated measures in their own organisation.

What delegates leave able to do

Explain pivot table analysis to someone who does not do the work, measured against recognised data governance frameworks
Improve data warehouse concepts within their own organisation
Take ownership of DAX and calculated measures rather than escalating it
Review storytelling with data and say plainly whether it is working

What the course covers

Data modelling
KPI definition
Pivot table analysis
Data warehouse concepts
DAX and calculated measures
Storytelling with data
Data governance

Who should attend

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

Fees

South Africa	R10 000
Elsewhere in Africa and the Gulf	USD 1 100
Live online	USD 900

Per delegate, for the full 2 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 13 Oct 2026	Cape Town	R10 000
23 to 24 Nov 2026	Nairobi	USD 1 100
11 to 12 Jan 2027	Pretoria	R10 000
15 to 16 Feb 2027	Windhoek	USD 1 100
22 to 23 Mar 2027	Pretoria	R10 000
3 to 4 May 2027	Port Louis	USD 1 100
21 to 22 Jun 2027	Cape Town	R10 000
2 to 3 Aug 2027	Windhoek	USD 1 100
13 to 14 Sep 2027	Online	USD 900
25 to 26 Oct 2027	Gaborone	USD 1 100

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)