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

Business Analysis

The route from no experience to a junior business analyst role. Learn to turn requests into the right changes: understand the problem, map the process, write requirements and user stories, and make the business case. Back it up with the data skills employers now expect from BAs (Excel, SQL and Power BI), then present yourself for the job.

What you'll be able to do

Problem statements and stakeholder analysis
Process mapping in BPMN, and Lean process improvement
Testable requirements, user stories and acceptance criteria
Business cases, KPIs and acceptance testing
Measuring problems with Excel and SQL
Reporting in Power BI

CloudTech Business Analyst

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

Start with Business Analysis Fundamentals

What you'll learn, module by module

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

1Module 1FoundationWhat business analysts do, and the data basics every BA needs.
Professional courseLevel 2 · Practical Skills
Business Analysis Fundamentals
Problems, stakeholders, processes, requirements, user stories and business cases, on a real firm's data.
About 7 hours
You'll learn
- What Business Analysts Do
- Stakeholders
- Eliciting Requirements
- The Current State in Numbers
- Process Mapping
- Writing Requirements
- User Stories and Acceptance Criteria
- Data and Reporting Requirements
- The Business Case
- Testing and Adoption
- Final Project
Professional courseLevel 1 · Foundations
Data Analytics Foundations
How to ask a good question of data and read the answer critically.
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
Measure the current state and build a business case in a spreadsheet.
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
2Module 2CoreGet your own numbers from systems, and understand how data is structured.
Professional courseLevel 2 · Practical Skills
SQL for Data Analysis
Answer your own questions from a database instead of waiting for a report.
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
Read and specify the data behind a system: entities, keys and relationships.
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
Specify, and build, the reports that prove a change worked.
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
3Module 3SpecialistGo deeper into how BAs work in modern teams.
Professional courseLevel 3 · Professional
Agile Business Analysis
Story maps, splitting, refinement, WSJF, velocity forecasts and pilots, inside a Scrum team.
About 6 hours
You'll learn
- Agile and the Business Analyst
- Product Vision and Outcomes
- Story Mapping
- Splitting Stories
- Refinement, Ready and Done
- Estimation and Prioritisation
- Velocity and Release Forecasting
- Measuring Flow and Quality
- Reviews, Pilots and Outcomes
- Final Project
Professional courseLevel 3 · Professional
Process Improvement with BPMN and Lean
BPMN, event logs, value streams, bottlenecks and root causes, on a real port clearance process.
About 6 hours
You'll learn
- Process Improvement and the BA
- BPMN in Depth
- Event Logs and Process Mining
- Value Stream Mapping
- The Eight Wastes
- Bottlenecks and Flow
- Root Cause Analysis
- Designing the Future State
- Pilot, Measure and Sustain
- Final Project
4Module 4ProjectsPortfolio work that shows you can analyse a real problem end to end.
Portfolio projectLevel 4 · Career Projects
Law Firm Operations Analysis
Measure a law firm's workload, court delays and unpaid bills.
Portfolio projectLevel 4 · Career Projects
Logistics Operations Analysis
Find the late routes and the customers who owe money.
CapstoneLevel 4 · Career Projects
Business Analyst Capstone: From Problem to Board Decision
From a vague complaint about slow claims to a board-ready decision paper, with every step evidenced.
About 12 hours
You'll learn
- The Brief and the Plan
- The Current State in Numbers
- The Process from the Event Log
- Root Causes
- Did the Pilot Work?
- Options and the Business Case
- Requirements and Readiness
- The Decision Paper
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 analysis packs and 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…

Business Analysis

What you'll be able to do

Problem statements and stakeholder analysis
Process mapping in BPMN, and Lean process improvement
Testable requirements, user stories and acceptance criteria
Business cases, KPIs and acceptance testing
Measuring problems with Excel and SQL
Reporting in Power BI

CloudTech Business Analyst

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

Start with Business Analysis Fundamentals

What you'll learn, module by module

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

1Module 1FoundationWhat business analysts do, and the data basics every BA needs.

Professional courseLevel 2 · Practical Skills

Business Analysis Fundamentals

Problems, stakeholders, processes, requirements, user stories and business cases, on a real firm's data.

About 7 hours

You'll learn

What Business Analysts Do
Stakeholders
Eliciting Requirements
The Current State in Numbers
Process Mapping
Writing Requirements
User Stories and Acceptance Criteria
Data and Reporting Requirements
The Business Case
Testing and Adoption
Final Project

Professional courseLevel 1 · Foundations

Data Analytics Foundations

How to ask a good question of data and read the answer critically.

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

Measure the current state and build a business case in a spreadsheet.

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

2Module 2CoreGet your own numbers from systems, and understand how data is structured.

Professional courseLevel 2 · Practical Skills

SQL for Data Analysis

Answer your own questions from a database instead of waiting for a report.

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

Read and specify the data behind a system: entities, keys and relationships.

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

Specify, and build, the reports that prove a change worked.

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

3Module 3SpecialistGo deeper into how BAs work in modern teams.

Professional courseLevel 3 · Professional

Agile Business Analysis

Story maps, splitting, refinement, WSJF, velocity forecasts and pilots, inside a Scrum team.

About 6 hours

You'll learn

Agile and the Business Analyst
Product Vision and Outcomes
Story Mapping
Splitting Stories
Refinement, Ready and Done
Estimation and Prioritisation
Velocity and Release Forecasting
Measuring Flow and Quality
Reviews, Pilots and Outcomes
Final Project

Professional courseLevel 3 · Professional

Process Improvement with BPMN and Lean

BPMN, event logs, value streams, bottlenecks and root causes, on a real port clearance process.

About 6 hours

You'll learn

Process Improvement and the BA
BPMN in Depth
Event Logs and Process Mining
Value Stream Mapping
The Eight Wastes
Bottlenecks and Flow
Root Cause Analysis
Designing the Future State
Pilot, Measure and Sustain
Final Project

4Module 4ProjectsPortfolio work that shows you can analyse a real problem end to end.

Portfolio projectLevel 4 · Career Projects

Law Firm Operations Analysis

Measure a law firm's workload, court delays and unpaid bills.

Portfolio projectLevel 4 · Career Projects

Logistics Operations Analysis

Find the late routes and the customers who owe money.

CapstoneLevel 4 · Career Projects

Business Analyst Capstone: From Problem to Board Decision

From a vague complaint about slow claims to a board-ready decision paper, with every step evidenced.

About 12 hours

You'll learn

The Brief and the Plan
The Current State in Numbers
The Process from the Event Log
Root Causes
Did the Pilot Work?
Options and the Business Case
Requirements and Readiness
The Decision Paper

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 analysis packs and 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.