Advanced SQL for Analysts

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 self service analytics, scenario modelling and the judgement calls that sit outside established visualisation principles. At this level the constraint is rarely knowledge. It is judgement under pressure, which matters because most organisations have more dashboards than decisions that depend on them. Delegates leave able to work confidently with DAX and calculated measures, data warehouse concepts and statistical fundamentals in their own organisation.

What delegates leave able to do

Improve DAX and calculated measures within their own organisation, measured against established visualisation principles
Bring data warehouse concepts into line with current good practice
Review statistical fundamentals and say plainly whether it is working
Put KPI definition on a footing they can defend to a reviewer

What the course covers

Self service analytics
Scenario modelling
DAX and calculated measures
Data warehouse concepts
Statistical fundamentals
KPI definition
Dashboard design

Who should attend

finance professionals building reports
management information officers
operations managers using dashboards
data analysts
team leaders responsible for KPIs

Fees

South Africa	R18 000
Elsewhere in Africa and the Gulf	USD 1 800
Live online	USD 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

30 Nov to 4 Dec 2026	Johannesburg	R18 000
4 to 8 Jan 2027	Durban	R18 000
22 to 26 Feb 2027	Lusaka	USD 1 800
22 to 26 Mar 2027	Durban	R18 000
26 to 30 Apr 2027	Harare	USD 1 800
31 May to 4 Jun 2027	Nairobi	USD 1 800
19 to 23 Jul 2027	Gaborone	USD 1 800
30 Aug to 3 Sep 2027	Pretoria	R18 000
4 to 8 Oct 2027	Cape Town	R18 000
22 to 26 Nov 2027	Dar es Salaam	USD 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)