AI and Digital TransformationPython for Data Analysis and Automation
A great deal of analytical work is repeated monthly by hand because the person doing it has no way to automate it, and Python is the shortest route from that position to a script that runs itself. This course teaches it for that purpose. Delegates work through the language fundamentals needed for data work rather than a full programming syllabus, then reading data from files, databases and interfaces. Cleaning, reshaping and merging datasets are covered in depth, since that is where the time goes. Summarising, grouping and charting follow. Automation is addressed: scheduling, error handling and writing a script somebody else can run. The course closes on reproducibility and on knowing when a spreadsheet is still the right answer.
Course objectives
- Use the language fundamentals that data work requires
- Read data from files, databases and interfaces
- Clean, reshape and merge datasets reliably
- Summarise, group and chart results
- Automate a recurring task including scheduling and error handling
- Write a script another person can run and maintain
- Judge when a spreadsheet remains the better tool
Who should attend
- Analysts repeating manual work each month
- Finance, operations and reporting staff
- Engineers and scientists processing data
- Internal auditors handling large extracts
- Anyone moving beyond spreadsheet limits
Course outline
- 01From monthly by hand to a script that runs itself
- 02Language fundamentals for data work
- 03Reading data from files and databases
- 04Cleaning and reshaping
- 05Merging and joining datasets
- 06Summarising, grouping and charting
- 07Automation, scheduling and error handling
- 08Reproducibility and choosing the right tool
Scheduled sessions
| Dates | Venue | Format | Price | Register |
|---|---|---|---|---|
| 19 to 23 October 2026 | Mbabane, Eswatini | Classroom | R19,950 per delegate | Register Now |
| 26 to 30 October 2026 | Johannesburg, South Africa | Classroom | R19,950 per delegate | Register Now |
| 23 to 27 November 2026 | Harare, Zimbabwe | Classroom | USD 1,325 per delegate | Register Now |
| 7 to 11 December 2026 | Durban, South Africa | Classroom | R19,950 per delegate | Register Now |
| 4 to 8 January 2027 | Cape Town, South Africa | Classroom | R19,950 per delegate | Register Now |
| 25 to 29 January 2027 | Online | Online | R8,500 per delegate | Register Now |