Professional Programme · Get job-ready as a junior data analyst

Data Analysis

The route we recommend from no experience to a junior data analyst role. Learn how analysis works, then the tools teams use every day (Excel, SQL, Power BI and Python) on realistic company data. Build portfolio projects that answer real business questions, and finish with your CV, LinkedIn and interview preparation.

What you'll be able to do

Spreadsheet analysis in Excel
Statistics: averages, spread, confidence intervals and tests
Querying databases with SQL, from first SELECT to cohorts and window functions
Data modelling and star schemas
Dashboards in Power BI, with DAX measures you can trust
Analysis in Python and pandas
Turning data into findings a manager can act on

CloudTech Data Analyst

Complete every required course and the capstone project to earn the free programme badge, then claim your official Professional Certificate.

Start with Data Analytics Foundations

What you'll learn, module by module

Work through the modules in order. Open one to see exactly what it covers.

1Module 1FoundationHow analysis works, and the spreadsheet skills every analyst uses.
Professional courseLevel 1 · Foundations
Data Analytics Foundations
How analysis works: questions, data types, cleaning and telling the story.
About 6 hours
You'll learn
- What is Data Analytics?
- How Businesses Use Data
- Types of Data
- Understanding Databases
- Data Cleaning
- Data Analysis
- Data Visualization
- Business Intelligence
- From Question to Insight
- Your First Analytics Project
Professional courseLevel 2 · Practical Skills
Excel for Data Analysis
The tool almost every business already uses, from formulas to pivot tables.
About 9 hours
You'll learn
- Excel for Analysts
- Working with Data
- Sorting and Filtering
- Formulas and Functions
- IF, SUMIF, COUNTIF
- XLOOKUP
- Data Cleaning
- Pivot Tables
- Charts and Visualization
- Building an Analysis
- Mini Project
Professional courseLevel 2 · Practical Skills
Statistics for Data Analysis
Averages, spread, outliers, confidence intervals and tests: telling a finding from noise.
About 8 hours
You'll learn
- Statistics for Analysts
- Averages: Mean, Median and Mode
- Spread: Range, IQR and Standard Deviation
- Distributions and Outliers
- Rates, Percentages and Weighted Averages
- Correlation
- Sampling and the Normal Distribution
- Confidence Intervals
- Comparing Groups
- Regression and Trends
- Final Project
2Module 2CoreGet data out of databases, model it properly and turn it into dashboards.
Professional courseLevel 2 · Practical Skills
SQL for Data Analysis
Pull and summarise data straight from a database.
About 10 hours
You'll learn
- Introduction to Databases
- Relational Databases and SQL Tools
- SELECT
- WHERE
- ORDER BY
- LIMIT
- Aggregate Functions
- GROUP BY
- HAVING
- JOINs
- CASE Statements
- Subqueries
- CTEs
- Window Functions
- Business Analysis with SQL
- Final Project
Professional courseLevel 3 · Professional
Data Modelling
Design the tables, keys and star schemas reliable reports are built on.
About 6 hours
You'll learn
- What Is a Data Model?
- Entities, Attributes and Grain
- Keys
- Relationships and Cardinality
- Entity-Relationship Diagrams
- Normalisation
- Dimensional Modelling
- Stars, Snowflakes, Dates and History
- Modelling in Practice
Professional courseLevel 2 · Practical Skills
Power BI Fundamentals
Turn the numbers into dashboards people can use.
About 8 hours
You'll learn
- Introduction to Business Intelligence
- Power BI Interface
- Importing Data
- Power Query
- Data Cleaning
- Data Relationships
- Data Modelling
- DAX Fundamentals
- Measures
- Visualizations
- Dashboard Design
- Business Storytelling
- Publishing Reports
- Final Dashboard Project
Professional courseLevel 3 · Professional
Power BI DAX
Filter context, CALCULATE, time intelligence and customer measures in depth.
About 7 hours
You'll learn
- How DAX Thinks
- Filter Context and Row Context
- Iterators
- CALCULATE in Depth
- Variables, BLANKs and Readable DAX
- Time Intelligence
- Table Functions
- Ranking and Top N
- Customer Analytics Patterns
- Performance and Testing
- Final Project
3Module 3AdvancedAutomate and scale your analysis, and handle harder questions.
Professional courseLevel 2 · Practical Skills
Python for Data Analytics
Write an analysis once and run it again in seconds, with every step on record.
About 9 hours
You'll learn
- Python and Colab for Analysts
- Lists, Dictionaries, Loops and Functions
- DataFrames: Load and Explore
- Filtering and Sorting
- Calculated Columns and Dates
- Cleaning Messy Data
- groupby and Aggregation
- Merging Tables
- Pivot Tables and Trends
- Charts with pandas and matplotlib
- From Question to Insight
- Final Project
Professional courseLevel 3 · Professional
Advanced SQL
Window functions in depth, cohorts, date logic, data quality checks and query performance.
About 6 hours
You'll learn
- Readable SQL and NULL Traps
- Date Logic
- Data Quality Checks
- Window Functions in Depth
- Top N per Group and Deduplication
- Cohorts and Retention
- Pivots and Period Comparisons
- Advanced Joins
- Query Performance
- Business Analysis Patterns
- Final Project
4Module 4ProjectsPortfolio projects on realistic data. Each one answers a business question end to end.
Portfolio projectLevel 4 · Career Projects
Sales Performance Analysis
Where is a distributor's revenue coming from, and where is it slipping?
Portfolio projectLevel 4 · Career Projects
Logistics Operations Analysis
Find the late routes and the customers who owe money.
Portfolio projectLevel 4 · Career Projects
Employee Analytics
Who leaves, when, and why: an HR analysis.
Portfolio projectLevel 4 · Career Projects
Customer Data Clean-up
Turn a messy export into a list a business can trust.
CapstoneLevel 4 · Career Projects
Data Analyst Capstone: End-to-End BI Project
From a raw till export to a reviewed dashboard and a board-ready executive summary.
About 14 hours
You'll learn
- The Brief and the Plan
- Profile the Raw Data
- Clean and Prepare
- Model and Measures
- Analyse
- Dashboard and Story
- Review, Present and Publish
5Module 5CareerTurn your skills into applications that get interviews.
Short courseLevel 1 · Foundations
Career Essentials
An ATS-friendly CV and a LinkedIn profile recruiters can find.
1 hr 30 min
You'll learn
- Build a CV with AI
- A Professional LinkedIn Profile
- Quick Excel Analysis
Short courseLevel 1 · Foundations· Optional
Build Your Student Portfolio
One link that shows your projects.
1 hr 25 min
You'll learn
- Plan Your Portfolio
- Show Your Work
- Build Your Portfolio Page
- Share Your Work on LinkedIn
Short courseLevel 1 · Foundations· Optional
Get Your First Internship
Find, apply for and interview for your first role.
1 hr 30 min
You'll learn
- Get Ready for an Internship
- Find Opportunities (Including Remote)
- Apply and Stand Out
- Ace the Interview

Courses marked "In preparation" join the programme when they're ready. If you've already earned the programme badge by then, you keep it.

Loading…

Data Analysis

What you'll be able to do

Spreadsheet analysis in Excel
Statistics: averages, spread, confidence intervals and tests
Querying databases with SQL, from first SELECT to cohorts and window functions
Data modelling and star schemas
Dashboards in Power BI, with DAX measures you can trust
Analysis in Python and pandas
Turning data into findings a manager can act on

CloudTech Data Analyst

Complete every required course and the capstone project to earn the free programme badge, then claim your official Professional Certificate.

Start with Data Analytics Foundations

What you'll learn, module by module

Work through the modules in order. Open one to see exactly what it covers.

1Module 1FoundationHow analysis works, and the spreadsheet skills every analyst uses.

Professional courseLevel 1 · Foundations

Data Analytics Foundations

How analysis works: questions, data types, cleaning and telling the story.

About 6 hours

You'll learn

What is Data Analytics?
How Businesses Use Data
Types of Data
Understanding Databases
Data Cleaning
Data Analysis
Data Visualization
Business Intelligence
From Question to Insight
Your First Analytics Project

Professional courseLevel 2 · Practical Skills

Excel for Data Analysis

The tool almost every business already uses, from formulas to pivot tables.

About 9 hours

You'll learn

Excel for Analysts
Working with Data
Sorting and Filtering
Formulas and Functions
IF, SUMIF, COUNTIF
XLOOKUP
Data Cleaning
Pivot Tables
Charts and Visualization
Building an Analysis
Mini Project

Professional courseLevel 2 · Practical Skills

Statistics for Data Analysis

Averages, spread, outliers, confidence intervals and tests: telling a finding from noise.

About 8 hours

You'll learn

Statistics for Analysts
Averages: Mean, Median and Mode
Spread: Range, IQR and Standard Deviation
Distributions and Outliers
Rates, Percentages and Weighted Averages
Correlation
Sampling and the Normal Distribution
Confidence Intervals
Comparing Groups
Regression and Trends
Final Project

2Module 2CoreGet data out of databases, model it properly and turn it into dashboards.

Professional courseLevel 2 · Practical Skills

SQL for Data Analysis

Pull and summarise data straight from a database.

About 10 hours

You'll learn

Introduction to Databases
Relational Databases and SQL Tools
SELECT
WHERE
ORDER BY
LIMIT
Aggregate Functions
GROUP BY
HAVING
JOINs
CASE Statements
Subqueries
CTEs
Window Functions
Business Analysis with SQL
Final Project

Professional courseLevel 3 · Professional

Data Modelling

Design the tables, keys and star schemas reliable reports are built on.

About 6 hours

You'll learn

What Is a Data Model?
Entities, Attributes and Grain
Keys
Relationships and Cardinality
Entity-Relationship Diagrams
Normalisation
Dimensional Modelling
Stars, Snowflakes, Dates and History
Modelling in Practice

Professional courseLevel 2 · Practical Skills

Power BI Fundamentals

Turn the numbers into dashboards people can use.

About 8 hours

You'll learn

Introduction to Business Intelligence
Power BI Interface
Importing Data
Power Query
Data Cleaning
Data Relationships
Data Modelling
DAX Fundamentals
Measures
Visualizations
Dashboard Design
Business Storytelling
Publishing Reports
Final Dashboard Project

Professional courseLevel 3 · Professional

Power BI DAX

Filter context, CALCULATE, time intelligence and customer measures in depth.

About 7 hours

You'll learn

How DAX Thinks
Filter Context and Row Context
Iterators
CALCULATE in Depth
Variables, BLANKs and Readable DAX
Time Intelligence
Table Functions
Ranking and Top N
Customer Analytics Patterns
Performance and Testing
Final Project

3Module 3AdvancedAutomate and scale your analysis, and handle harder questions.

Professional courseLevel 2 · Practical Skills

Python for Data Analytics

Write an analysis once and run it again in seconds, with every step on record.

About 9 hours

You'll learn

Python and Colab for Analysts
Lists, Dictionaries, Loops and Functions
DataFrames: Load and Explore
Filtering and Sorting
Calculated Columns and Dates
Cleaning Messy Data
groupby and Aggregation
Merging Tables
Pivot Tables and Trends
Charts with pandas and matplotlib
From Question to Insight
Final Project

Professional courseLevel 3 · Professional

Advanced SQL

Window functions in depth, cohorts, date logic, data quality checks and query performance.

About 6 hours

You'll learn

Readable SQL and NULL Traps
Date Logic
Data Quality Checks
Window Functions in Depth
Top N per Group and Deduplication
Cohorts and Retention
Pivots and Period Comparisons
Advanced Joins
Query Performance
Business Analysis Patterns
Final Project

4Module 4ProjectsPortfolio projects on realistic data. Each one answers a business question end to end.

Portfolio projectLevel 4 · Career Projects

Sales Performance Analysis

Where is a distributor's revenue coming from, and where is it slipping?

Portfolio projectLevel 4 · Career Projects

Logistics Operations Analysis

Find the late routes and the customers who owe money.

Portfolio projectLevel 4 · Career Projects

Employee Analytics

Who leaves, when, and why: an HR analysis.

Portfolio projectLevel 4 · Career Projects

Customer Data Clean-up

Turn a messy export into a list a business can trust.

CapstoneLevel 4 · Career Projects

Data Analyst Capstone: End-to-End BI Project

From a raw till export to a reviewed dashboard and a board-ready executive summary.

About 14 hours

You'll learn

The Brief and the Plan
Profile the Raw Data
Clean and Prepare
Model and Measures
Analyse
Dashboard and Story
Review, Present and Publish

5Module 5CareerTurn your skills into applications that get interviews.

Short courseLevel 1 · Foundations

Career Essentials

An ATS-friendly CV and a LinkedIn profile recruiters can find.

1 hr 30 min

You'll learn

Build a CV with AI
A Professional LinkedIn Profile
Quick Excel Analysis

Short courseLevel 1 · Foundations· Optional

Build Your Student Portfolio

One link that shows your projects.

1 hr 25 min

You'll learn

Plan Your Portfolio
Show Your Work
Build Your Portfolio Page
Share Your Work on LinkedIn

Short courseLevel 1 · Foundations· Optional

Get Your First Internship

Find, apply for and interview for your first role.

1 hr 30 min

You'll learn

Get Ready for an Internship
Find Opportunities (Including Remote)
Apply and Stand Out
Ace the Interview

Courses marked "In preparation" join the programme when they're ready. If you've already earned the programme badge by then, you keep it.