Print this page or save it as a PDF to circulate internally.
Back to the course
Executive and professional training
305 Glenwood Road, Faerie Glen, Pretoria, South Africa
069 221 6943
info@isptrainings.co.za
Leading Advanced Excel Teams
Data and Business Intelligence|3 days|Classroom or live online
This programme is for the person accountable for the work rather than the person doing it. It covers self service analytics and DAX and calculated measures from the position of someone who must review, approve and answer for the output. Managers carry this because analysts are frequently self taught in the tool and untrained in the reasoning, and the accountability does not delegate cleanly. Delegates leave able to work confidently with SQL querying, visual encoding choices and data warehouse concepts in their own organisation.
What delegates leave able to do
- Review SQL querying and say plainly whether it is working, measured against dimensional modelling practice
- Put visual encoding choices on a footing they can defend to a reviewer
- Take ownership of data warehouse concepts rather than escalating it
- Improve dashboard design within their own organisation
What the course covers
- Self service analytics
- DAX and calculated measures
- SQL querying
- Visual encoding choices
- Data warehouse concepts
- Dashboard design
- Storytelling with data
Who should attend
- management information officers
- professionals moving into analytics
- team leaders responsible for KPIs
- reporting specialists
- data analysts
Fees
| South Africa | R13 000 |
| Elsewhere in Africa and the Gulf | USD 1 500 |
| Live online | USD 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
| 4 to 6 Jan 2027 | Johannesburg | R13 000 |
| 22 to 24 Feb 2027 | Online | USD 900 |
| 5 to 7 Apr 2027 | Johannesburg | R13 000 |
| 10 to 12 May 2027 | Johannesburg | R13 000 |
| 21 to 23 Jun 2027 | Kampala | USD 1 500 |
| 19 to 21 Jul 2027 | Online | USD 900 |
| 30 Aug to 1 Sep 2027 | Cape Town | R13 000 |
| 27 to 29 Sep 2027 | Pretoria | R13 000 |
| 8 to 10 Nov 2027 | Pretoria | R13 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)