Professional Programme · Build a career

Professional Data Analytics

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.

3 months
Hybrid: self-paced and live
14 courses
Capstone project
Professional certificate

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

₦250,000

One-off payment. Every professional course in the programme unlocks the moment your payment is confirmed.

Enroll Now — ₦250,000

You'll create a free account first, then pay.

What's included

14 courses in one structured programme, 5 of them professional-only
Hybrid: self-paced and live
Capstone project
Professional certificate included when you earn the programme badge
Instructor support
CloudTech WhatsApp community access
Live classes, online or in person, in small batches of 15 to 25
Recorded sessions for revision
Job assistance

Programme overview

Professional Data Analytics takes you from spreadsheets to dashboards and Python in one structured programme. You work through ten courses in order on realistic company data, build projects as you go, and finish with an end-to-end capstone that turns a raw till export into a reviewed dashboard and a board-ready summary.

Professional outcome

Get job-ready as a junior data analyst.

Who this is for

Beginners who want a career in data analytics
Excel users ready to move into SQL, Power BI and Python
Graduates and career changers who need a job-ready portfolio

Projects you'll build

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

Full curriculum, module by module

Free introductions are open to everyone. The professional curriculum goes deeper, with real-world projects and assessments, and unlocks when you enroll.

1Module 1FoundationHow analysis works, and the spreadsheet skills every analyst uses.
Full courseFree introductionLevel 1 · Foundations· Optional
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
Full courseFree introductionLevel 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
Full courseFree introductionLevel 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
Full courseFree introductionLevel 2 · Practical Skills
Business Analysis Fundamentals
Problems, stakeholders and requirements: the business side of every analysis.
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
2Module 2CoreGet data out of databases, model it properly and turn it into dashboards.
Full courseFree introductionLevel 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
Full courseProfessional curriculumLevel 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
Full courseFree introductionLevel 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
Full courseProfessional curriculumLevel 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.
Full courseProfessional curriculumLevel 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
Full courseProfessional curriculumLevel 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.
CapstoneProfessional curriculumLevel 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 courseFree introductionLevel 1 · Foundations· Optional
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 courseFree introductionLevel 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 courseFree introductionLevel 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…

Professional Data Analytics

3 months

Hybrid: self-paced and live

14 courses

Capstone project

Professional certificate

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

₦250,000

One-off payment. Every professional course in the programme unlocks the moment your payment is confirmed.

Enroll Now — ₦250,000

You'll create a free account first, then pay.

What's included

14 courses in one structured programme, 5 of them professional-only
Hybrid: self-paced and live
Capstone project
Professional certificate included when you earn the programme badge
Instructor support
CloudTech WhatsApp community access
Live classes, online or in person, in small batches of 15 to 25
Recorded sessions for revision
Job assistance

Programme overview

Professional outcome

Get job-ready as a junior data analyst.

Full curriculum, module by module

Free introductions are open to everyone. The professional curriculum goes deeper, with real-world projects and assessments, and unlocks when you enroll.

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

Full courseFree introductionLevel 1 · Foundations· Optional

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

Full courseFree introductionLevel 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

Full courseFree introductionLevel 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

Full courseFree introductionLevel 2 · Practical Skills

Business Analysis Fundamentals

Problems, stakeholders and requirements: the business side of every analysis.

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

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

Full courseFree introductionLevel 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

Full courseProfessional curriculumLevel 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

Full courseFree introductionLevel 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

Full courseProfessional curriculumLevel 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.

Full courseProfessional curriculumLevel 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

Full courseProfessional curriculumLevel 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.

CapstoneProfessional curriculumLevel 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 courseFree introductionLevel 1 · Foundations· Optional

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 courseFree introductionLevel 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 courseFree introductionLevel 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.