Tech training programme

Data Analysis

Turn raw data into clear insights and decisions using Excel, SQL, Python and Power BI.

Enquire about this programme Send an enquiry

Duration4 months

After trainingCertificate

Programmes running since2018

Programme overview

What this programme is about.

This four-month, hands-on programme teaches you to collect, clean, analyse and visualise data. You learn the tools analysts use every day and practise on realistic datasets.

You finish by presenting a complete analysis project that shows you can move from raw data to a clear recommendation.

Who it is for

Made for people like you.

Beginners interested in a data career
Business, finance and administration professionals who work with numbers
Graduates who want employable skills
Entrepreneurs who want to make data-driven decisions

What you will learn

Skills you will gain.

By the end of the programme you will be able to do the following.

Clean and prepare data

Fix errors, handle missing values and organise messy datasets.

Analyse with statistics

Descriptive statistics, correlation and hypothesis testing.

Query databases with SQL

Retrieve and combine data from relational databases.

Use Python for analysis

Pandas, NumPy and visualisation libraries.

Build dashboards

Interactive reports in Power BI.

Communicate insights

Explain findings clearly to people who make decisions.

Syllabus

Your programme, phase by phase.

The syllabus for the Data Analysis programme (4 months). Topics may be updated to reflect current industry practice.

Month 1

Data foundations and Excel

What data analysis is and the analysis process
Excel formulas and lookup functions
Pivot tables and charts
Data cleaning and validation
Descriptive statistics: mean, median, variance and distributions
Introduction to Google Sheets

Month 2

SQL for analysts

Databases, tables and keys
SELECT, WHERE, ORDER BY and GROUP BY
Joins and subqueries
Aggregations and window functions
Working with real datasets

Month 3

Python for data analysis

Python basics for analysts
NumPy and Pandas
Cleaning, transforming and merging data
Exploratory data analysis (EDA)
Visualisation with Matplotlib and Seaborn
Sampling, correlation and hypothesis testing

Month 4

Dashboards, storytelling and capstone

Power BI: data modelling, DAX basics and dashboards
Data visualisation best practice
Communicating insights in reports and presentations
Capstone: an end-to-end analysis project
Portfolio and interview preparation
Final assessment

Tools and technologies

What you will use.

Microsoft Excel
Google Sheets
SQL (MySQL or PostgreSQL)
Python
Pandas and NumPy
Matplotlib and Seaborn
Power BI
Jupyter Notebook

Projects and assessment

What you will build.

Sales analysis in ExcelClean, summarise and chart business data.
SQL analysis projectAnswer business questions from a relational database.
Python exploratory analysisFind patterns and test ideas in a real dataset.
Power BI dashboardPresent key metrics in an interactive report.
Capstone projectAn end-to-end analysis, presented to an audience.

Career paths

Where it can take you.

Roles this training prepares you to explore. Outcomes depend on your effort and the job market.

Data analyst
Business analyst
Reporting analyst
Research and insights assistant
Excel and data specialist

Your certificate

After completing the Data Analysis programme (4 months), you receive a certificate.

How to enrol

Three simple steps.

Fees, start dates and schedules are shared when you enquire.

Contact us

Message us on WhatsApp or use the enquiry form.

Confirm your intake

We tell you about the next intake, fees and schedule.

Start learning

Begin the programme and work through the syllabus.

Ready to start Data Analysis?

Send us a message and we will share the next steps.

Chat on WhatsApp Send an enquiry

Other programmes