ZRST Traffic Safety InstituteProfessional learning · ZambiaEnquire about training CERT-02 · Skills award certificate
Skills Award Certificate in Crash Data & Analytics (Excel/Power BI basics)
Turn crash records into clearer evidence for decisions, with careful checks on quality and gaps.
Course overview
A 3-month technical programme developing competency in crash data management, analysis, and communication using Excel and Power BI basics. Covers data quality, hotspot analysis, dashboard design, and briefing note writing.
What the course covers
- Apply minimum crash data variables and quality checks
- Identify data gaps, duplicates and coding inconsistencies
- Produce simple summaries and hotspot lists for decision-makers
- Explain limits, bias and under-reporting responsibly
Topics you will study
- Crash Data Systems and Quality Standards
- Data Collection and Minimum Data Dictionary
- Data Cleaning and Quality Assurance
- Analysis Methods: Hotspots and Trends
- Visualisation and Dashboard Design (Excel/Power BI)
- Reporting and Decision-Support Communication
Practical learning
Develop a crash-data workflow from collection and cleaning to hotspot analysis, an Excel or Power BI dashboard and a briefing note.
Who should enquire?
Data analysts, police data staff, RTSA analysts, health information officers. ZTSI will confirm entry criteria and suitability for your role.
Duration and study periods
3 months. The next cohort starts in January 2027, with a planned January–March 2027 study period. This is a three-month programme within the first half of the academic year.
Learning combines taught sessions, case work and practical tasks. ZTSI will confirm teaching days, assessment dates, breaks and any field or placement arrangements before enrolment.
Entry and prior experience
Proposed entry requirement: Grade 12 Certificate or O Levels; recognition of prior learning may apply for working professionals.
Ask ZTSI to confirm the admission criteria and how prior experience may be considered.
Start with an enquiry. ZTSI confirms intake dates and delivery arrangements. Ask about the proposed award and its recognition. Expressing interest does not confirm admission or reserve a place.
Course fee
ZMW 10,500 standard fee per participant.
Ask ZTSI for an approved invoice, fee coverage and the payment schedule before booking. Institutional or group training is quoted separately.
Talk to ZTSI
Discuss this course with ZTSI.
Our team can explain the programme’s readiness, fee coverage, delivery arrangements and next steps.