Python for Data Analytics - PCED

This five day instructor-led course provides participants with the foundational Python and analytical skills required to collect, prepare, analyse and communicate data. The course combines instructor demonstrations, practical exercises and an integrated data-analysis project. Its technical content aligns with the knowledge areas covered by the PCED syllabus. Examination preparation and mock-exam activities are available separately as an optional one-day workshop.

Duration
5 days
Format
Instructor-led, in person or live online

What the course covers

Prerequisites

There are no formal prerequisites. Participants will benefit from basic computer literacy, some familiarity with spreadsheets or structured data, foundation-level mathematics and statistics, and basic Python knowledge equivalent to PCEP level.

Who should attend

  • • Aspiring or junior data analysts
  • • Students and career changers entering data analytics
  • • Business professionals who need to analyse data using Python
  • • Reporting, operations and research staff
  • • Python beginners seeking an entry-level data analytics certification
  • • Candidates intending to progress to the PCED-30-02 examination

Learning Objectives

  • At the conclusion of this course, attendees will be able to:
  • • Explain how raw data becomes useful information and insight
  • • Classify quantitative, qualitative, structured and unstructured data
  • • Describe common data sources, collection methods and storage options
  • • Explain the data lifecycle and principal types of analytics
  • • Recognise ethical, privacy and legal considerations when handling data
  • • Use Python variables, data types, expressions and string operations
  • • Work with lists, tuples, sets and dictionaries
  • • Write functions and control program flow using conditions and loops
  • • Handle common Python errors and exceptions
  • • Read and write text and CSV files
  • • Clean, convert and normalise data for analysis
  • • Calculate aggregates and descriptive statistics
  • • Use NumPy arrays for introductory numerical analysis
  • • Identify patterns, frequencies, correlations and possible outliers
  • • Select and interpret appropriate data visualisations
  • • Communicate findings through clear reports and presentations

Day 1 - Data and Data Analysis Fundamentals

Core data concepts, sources, storage, lifecycle, analytics types and responsible data handling.

Understanding Data

  • Data, information, knowledge and insight
  • The role of data in decision-making
  • Quantitative and qualitative data
  • Structured, semi-structured and unstructured data
  • Transforming raw data into meaningful information

Data Sources and Collection

  • APIs, web pages and databases
  • Surveys, interviews and observations
  • Application logs, automated systems and IoT devices
  • Web scraping concepts
  • Representative sampling
  • Biased, incomplete and unrepresentative data
  • Comparing data-collection methods

Data Storage and Organisation

  • CSV, JSON and Excel formats
  • Relational databases
  • Data warehouses and data lakes
  • The role of metadata
  • Selecting storage based on structure, scale and purpose

The Data Lifecycle

  • Collection, storage and processing
  • Analysis and reporting
  • Archiving and deletion
  • Data quality, security and compliance
  • How errors affect subsequent stages

Data Analytics Concepts

  • Data analysis, data analytics and data science
  • Descriptive, diagnostic, predictive and prescriptive analytics
  • The data analytics workflow
  • Common roles and responsibilities

Ethics and Legal Considerations

  • Privacy, consent and transparency
  • Fairness and accountability
  • GDPR, CCPA and HIPAA awareness
  • Anonymisation and encryption
  • Responsible use of personal and sensitive data
  • Practical work: classify real-world datasets and design a suitable data lifecycle for a small analytics project.

Day 2 - Python Basics for Data Analysis

Python foundations and the core collections and string operations used in entry-level data analysis.

The Python Environment

  • Running Python interactively and from scripts
  • Python syntax and indentation
  • Comments and readable code
  • Interpreting simple Python programs

Variables and Data Types

  • Creating and assigning variables
  • Integers, floating-point values, strings and Boolean values
  • Arithmetic and string operations
  • Using type() and isinstance()
  • Converting between data types
  • Formatting values with f-strings

Lists

  • Creating and accessing lists
  • Indexing and slicing
  • Adding, updating and removing values
  • Sorting and reversing
  • Counting and locating values
  • List comprehensions for transformation and filtering

Tuples and Sets

  • Creating and accessing tuples
  • Tuple immutability
  • Creating and modifying sets
  • Union, intersection and difference
  • Removing duplicate values
  • Membership testing

Dictionaries

  • Keys and values
  • Adding, updating and deleting entries
  • Iterating through dictionaries
  • Counting, grouping and lookup operations
  • Representing records as lists of dictionaries

Working with Strings

  • Strings as sequences
  • Indexing and slicing
  • Searching and testing strings
  • Changing case and formatting text
  • startswith(), endswith(), find(), isdigit() and isalpha()
  • Practical work: develop a Python program that validates, categorises and summarises a collection of data records.

Day 3 - Python Logic, Functions, Modules and Files

Functions, program flow, error handling, modules and file-processing techniques for robust data workflows.

Functions

  • Defining and calling functions
  • Positional, keyword and default arguments
  • Returning values
  • Understanding None
  • Placeholder functions using pass
  • Local and global scope
  • Name shadowing

Conditions and Boolean Logic

  • Comparison and logical operators
  • Boolean expressions
  • if, elif and else
  • Nested conditions
  • Identifying missing, invalid and out-of-range values
  • Filtering data using conditions

Loops

  • for and while loops
  • break and continue
  • The loop else clause
  • Combining loops and conditions
  • Applying repeated operations to data

Exception Handling

  • Common runtime errors
  • TypeError, ValueError and IndexError
  • Using try and except
  • Handling file-related errors
  • Producing useful error messages
  • Writing robust data-processing programs

Modules and Packages

  • import and from...import
  • Module aliases
  • math, random, statistics and collections
  • os and datetime
  • Built-in modules and third-party packages
  • Installing packages with pip
  • Introducing NumPy

Working with Files

  • Opening, reading and writing text files
  • Safe file handling with with
  • File paths and os.path.exists()
  • Reading CSV data with csv.reader()
  • Writing CSV data with csv.writer()
  • Parsing delimited text
  • Producing formatted summaries
  • Practical work: import a CSV dataset, validate its records, handle file errors and produce a formatted summary file.

Day 4 - Data Preparation and Analysis

Cleaning, transforming, summarising and exploring data with Python and NumPy.

Cleaning and Converting Data

  • Detecting missing and null values
  • Removing or replacing missing values
  • Validating types, formats and ranges
  • Detecting and removing duplicates
  • Cleaning text with string methods
  • Splitting and joining values
  • Converting between strings, numbers and Boolean values
  • Formatting numeric values

Dates and Times

  • Parsing dates with datetime.strptime()
  • Formatting dates with strftime()
  • Validating and standardising date values

Normalising Data

  • Understanding differences in scale
  • Manual min-max normalisation
  • Indexed transformations using enumerate()
  • Preparing clean data for analysis

Aggregations and Descriptive Statistics

  • len(), sum(), min(), max() and round()
  • Counting values
  • Mean, median and standard deviation
  • Square root, ceiling and floor operations
  • Frequency analysis using collections.Counter
  • Conditional metrics
  • Grouping and summarising categories

NumPy Fundamentals

  • Creating NumPy arrays
  • NumPy arrays compared with lists
  • Generating sequences
  • Sum, mean, median and standard deviation
  • Sorting and filtering arrays
  • Boolean indexing
  • Finding unique values

Exploratory Data Analysis

  • Sorting and filtering records
  • Identifying patterns and trends
  • Calculating frequencies
  • Grouping by category
  • Introductory correlation analysis
  • Correlation versus causation
  • Detecting possible outliers
  • Interpreting analytical findings
  • Practical work: clean and explore a realistic dataset, calculate statistics and document significant patterns, relationships and possible outliers.

Day 5 - Communicating Insights and Integrated Project

Visualisation, data storytelling, analytical reporting and an integrated end-to-end data project.

Data Visualisation Principles

  • Bar, line and pie charts
  • Choosing a suitable chart
  • Communicating comparisons, trends and proportions
  • Strengths and limitations of common chart types
  • Effective titles, labels, colours and font sizes
  • Recognising misleading or unclear visualisations
  • Improving charts to support the intended message

Data Storytelling

  • Moving from analytical results to a clear message
  • Introduction, insights and conclusion
  • Leading with the principal finding
  • Supporting claims with evidence
  • Transitions and signposting
  • Adapting tone and detail for different audiences

Analytical Reports

  • Defining the business or analytical problem
  • Describing the analysis
  • Presenting insights
  • Making evidence-based recommendations
  • Writing concise summaries
  • Organising content with headings and bullet points
  • Combining narrative, data and visual evidence

Presenting Findings

  • Explaining charts and analytical results
  • Presenting to technical and non-technical audiences
  • Using effective visual and verbal techniques
  • Responding to questions using evidence
  • Recognising unsupported conclusions

Integrated Data Analysis Project

  • Defining an analytical question
  • Importing a CSV dataset
  • Validating and cleaning its records
  • Calculating descriptive and conditional metrics
  • Identifying trends, frequencies and possible outliers
  • Selecting appropriate visualisations
  • Producing a concise analytical report
  • Presenting findings and recommendations
  • Receiving instructor feedback

Optional Day 6 - PCED Examination Preparation Workshop

A separate one-day instructor-led workshop for candidates who have completed the five-day course or possess equivalent knowledge.

PCED Examination Overview

  • Examination structure and question formats
  • The four PCED syllabus blocks
  • Weighting of each examination block
  • Current passing requirements
  • Single-select questions
  • Multiple-select questions
  • Scenario-based questions
  • Managing the available examination time

Structured Syllabus Review

  • Data and data-analysis concepts
  • Python fundamentals for data analysis
  • Data preparation and simple analytical techniques
  • Communicating insights and reporting
  • High-frequency concepts and common areas of confusion
  • Identifying individual knowledge gaps

Question-Answering Techniques

  • Reading questions precisely
  • Identifying what a scenario is testing
  • Evaluating code without executing it
  • Tracing variables, conditions and loops
  • Eliminating implausible answers
  • Handling questions with multiple correct selections
  • Avoiding unsupported assumptions
  • Recognising common distractors

Guided Practice

  • Topic-based examination questions
  • Python code-tracing exercises
  • Data-cleaning and statistical scenarios
  • Visualisation interpretation questions
  • Instructor explanations and group discussion

Mock Examination

  • Timed 40-question mock examination
  • Simulation of examination conditions
  • Review of every question and answer
  • Explanation of incorrect alternatives
  • Analysis of performance by syllabus block
  • Identification of final revision priorities

Personal Preparation Plan

  • Individual feedback
  • Targeted revision recommendations
  • Examination-day preparation
  • Time-management strategy
  • Recommended follow-up practice and study resources

Course dates

Scheduled dates for Python for Data Analytics - PCED
DateLocationBooking
Online Book Python for Data Analytics - PCED, Mon 15 Feb 2027, Online