Data Analysis Foundations

Starts 12 October 2026•8 weeks

Explore Programme View Curriculum

Overview

About this programme

Go from spreadsheets to real analysis in eight weeks. Data Analysis Foundations covers Excel, statistics, SQL, and Power BI — the exact toolkit junior data analysts use every day — and ends with a dashboard you build from a real dataset.

Curriculum

Programme structure

Prerequisites

None. Basic computer literacy, a laptop, and an internet connection. No coding or maths background required.

What you'll learn

Clean, structure, and prepare messy datasets for analysis in Excel
Use formulas, lookups, and pivot tables to summarise and explore data
Apply core statistics — averages, spread, and distributions — to interpret data correctly
Write SQL queries using SELECT, WHERE, JOIN, and GROUP BY to pull and combine data
Model data and build an interactive dashboard in Power BI
Translate a business question into the right analysis and a clear answer
Complete a capstone: take a real dataset from raw file to a finished, insight-driven dashboard

6 modules

Master the fundamental tool that every professional developer uses daily. Learn to track changes, collaborate with others, and manage your code like a pro from the very beginning of your development journey.
- Understand version control concepts and why Git is essential for modern software development
- Use GitHub effectively for remote repositories, collaboration, and showcasing your work to potential employers
- Master Git basics including repositories, commits, branches, and merging for effective code management.
You'll build: a version-controlled project on GitHub, with branches, pull requests and a history an employer can read

Module 1: Version control with Git and Github

Master the fundamental tool that every professional developer uses daily. Learn to track changes, collaborate with others, and manage your code like a pro from the very beginning of your development journey.

Understand version control concepts and why Git is essential for modern software development
Use GitHub effectively for remote repositories, collaboration, and showcasing your work to potential employers
Master Git basics including repositories, commits, branches, and merging for effective code management.

You'll build: a version-controlled project on GitHub, with branches, pull requests and a history an employer can read