Digital Innovation and Transformation

Python Programming for Data Analysis and Automation

Python is the most popular language for data analysis and automation. This beginner-friendly course teaches Python fundamentals, data analysis with pandas, data visualisation, automating repetitive tasks with files and spreadsheets, and simple use of APIs. Participants complete practical exercises based on business data.

5 days Classroom or live online English

Smart Horizon Certified - Global Leadership Consultants

Take the course details with you.

Download the full standard outline: why attend, methodology, objectives, audience, competencies, the daily outline and current plans.

Download course PDF

Why attend

From knowledge to real-world impact.

Python skills allow you to analyse larger datasets and automate manual work. This course gives non-programmers a practical starting point.

Workplace challenges

Professional Problems This Course Is Designed to Solve

The programme explores practical approaches to the following challenges. Results depend on how the learning is applied in your organisation.

Difficulty translating subject knowledge into practical workplace decisions.
Inconsistent approaches to the activities covered in the course outline.
Lack of a structured plan for applying and reviewing new skills.

Course methodology

How you will learn.

The course is hands-on using notebooks, with step-by-step exercises, mini-projects and a capstone automation task. No prior programming experience is required.

Course objectives

What you'll take away.

By the end of this course, participants will be able to:

Write basic Python programs
Load, clean and analyse data with pandas
Create charts with Python
Automate spreadsheet and file tasks
Use APIs to retrieve data
Structure and document reusable scripts

Target audience

Who should attend.

This course is suitable for:

Business and data analysts
Finance and operations professionals
Researchers
Engineers
Professionals wanting to automate tasks

Target competencies

Capabilities you will build.

Participants will develop competencies in:

Python fundamentals
Data manipulation
Data visualisation
Task automation
API use
Script development

Course outline

Your learning journey.

A focused, practical outline with time to explore, apply and reflect.

Day 1Python Fundamentals

09:00–09:54Python environment and notebooks
09:54–10:48Variables and data types
10:48–11:00Control flow
11:00–11:30Coffee break
11:30–12:12Control flow (continued)
12:12–13:06Functions
13:06–14:00Lab: First scripts

Day 2Data Analysis with pandas

09:00–09:54DataFrames
09:54–10:48Importing data
10:48–11:00Cleaning and transforming
11:00–11:30Coffee break
11:30–12:12Cleaning and transforming (continued)
12:12–13:06Grouping and summarising
13:06–14:00Lab: Analysing sales data

Day 3Visualisation

09:00–09:54Charts with Python libraries
09:54–10:48Customising charts
10:48–11:00Exploratory analysis
11:00–11:30Coffee break
11:30–12:12Exploratory analysis (continued)
12:12–13:06Exporting results
13:06–14:00Lab: Building charts

Day 4Automation

09:00–09:54Working with files and folders
09:54–10:48Automating Excel tasks
10:48–11:00Email and report automation
11:00–11:30Coffee break
11:30–12:12Email and report automation (continued)
12:12–13:06Scheduling scripts
13:06–14:00Lab: Automating a report

Day 5APIs and Good Practice

09:00–09:54Calling APIs
09:54–10:48Error handling
10:48–11:00Code organisation
11:00–11:30Coffee break
11:30–12:12Code organisation (continued)
12:12–13:06Next steps
13:06–14:00Capstone: Automation project

The timings provided are estimates and may vary depending on the number of participants and the discussions taking place during the sessions. They are indicative only and do not constitute a binding commitment.

Dates & venues

Find a session that works for you.

Confirmed dates accept registration requests. Tentative dates are enquiry only.

Good to know

A few things to know.

How is the course delivered?

Our classroom programmes combine facilitated discussion, case studies, exercises and reflection. The precise format will be confirmed before enrolment.

Can you deliver this programme for our team?

Yes, you can enquire about a tailored programme. Share your goals, group size and preferred dates with our learning team.

Will I receive a certificate?

Participants who complete the programme receive a Smart Horizon certificate of attendance. Smart Horizon programmes are not externally accredited and do not award a professional qualification, licence or designation. Where a course title or outline refers to a professional certification (for example, AACE International's Certified Cost Professional), the programme supports learning and preparation only; the credential itself is awarded solely by the relevant professional body under its own application and examination requirements.

What should I confirm before booking travel?

Please confirm the session, exact venue, accessibility arrangements, fees and any visa requirements with the team before arranging travel. Tentative dates are not confirmed sessions.

Keep exploring

Your next horizon awaits.

All courses

The full course agenda and dates are available above. Use the session links in Dates & venues to choose a session. Registration and quotation forms require JavaScript; you can also contact our learning team directly.