CPD Accredited Data Analytics Professional Certificate

Module 1: Python & data analytics

✓ Understand what data analytics is & its real-world applications

Explore the data pipeline and how data-driven decisions are made across industries.

✓ Python syntax, variables & data types

Write your first Python programs using comments, variables, and core data types.

Module 2: SQL & working with databases

✓ Retrieve, filter & sort data using SQL queries

Use SELECT, FROM, WHERE, and ORDER BY to query and organise data.

✓ Group & aggregate data with GROUP BY, SUM, AVG & COUNT

Summarise data to produce meaningful totals, averages, and counts across categories.

Module 3: Data structures & control flow

✓ Understand lists, tuples, sets & dictionaries

Work with Python's core data structures and understand when to use each one.

✓ For & while loops with if/else conditions

Use control structures to process and filter data with logic and repetition.

Module 4: Functions & error handling

✓ Write reusable functions with parameters & return values

Define and call functions to make your code cleaner, modular, and reusable.

✓ Handle errors gracefully using try/except

Prevent programs from crashing by catching and managing errors effectively.

Module 5: Files & CSV data

✓ Read & write text and CSV files

Load and save data from files, the foundation of real-world data workflows.

✓ Introduction to Pandas DataFrames

Get started with Pandas, the industry-standard library for working with structured data.

Module 6: Data cleaning with Pandas

✓ Select, filter & sort data with Pandas

Manipulate DataFrames to isolate and organise the data you need for analysis.

✓ Handle missing values & remove duplicates

Clean real-world data by identifying gaps, filling nulls, and eliminating duplicates.

Module 7: Data visualisation with Python

✓ Create line, bar, pie & scatter charts with Matplotlib

Build the most commonly used chart types to visualise and communicate data.

✓ Introduction to Seaborn for enhanced visualisations

Use Seaborn to produce polished, publication-quality charts with less code.

Module 8: Getting started with Power BI

✓ Import & explore datasets from CSV & Excel

Bring your cleaned data into Power BI and begin exploring it visually.

✓ Build a report showing sales by region & product category

Apply your skills to create a meaningful, real-world Power BI business report.

Module 9: Intermediate Power BI

✓ Write DAX formulas: SUM, AVERAGE, COUNTROWS & CALCULATE

Use DAX to build calculated columns and measures that power your reports.

✓ Build an interactive dashboard filterable by year & region

Deliver a fully interactive Power BI dashboard that responds to user selections.

Module 10: Combining Python and Power BI

✓ Export Python-cleaned data for use in Power BI

Build a seamless end-to-end workflow: clean data in Python, visualise it in Power BI.

✓ Build a hybrid dashboard combining Power BI & Python charts

Deliver a complete dashboard that blends native Power BI visuals with a Python-based chart.

Module 11: Capstone project

✓ Apply all learned skills to a real-world dataset

Work on a dataset of your choice and apply the full analytics workflow from cleaning to insight.

✓ Build an interactive Power BI dashboard summarising insights

Present your findings through a polished, fully interactive Power BI report.