Data Analysis

Starts 5 June 2025•6 months

Explore Programme View Curriculum

Overview

About this programme

This comprehensive program builds your expertise across five core areas that form the foundation of modern data analysis. You'll begin with Excel for data manipulation and visualization, developing advanced skills in formulas, pivot tables, statistical functions, and dashboard creation for immediate business impact. The course then introduces essential mathematical and statistical concepts, covering descriptive and inferential statistics, probability distributions, hypothesis testing, and regression analysis that underpin all analytical work.

Database skills form the next pillar, with SQL training that covers complex queries, table joins, data aggregation, and optimization techniques for working efficiently with large datasets. Power BI training follows, enabling you to create interactive dashboards, perform advanced data modeling with DAX calculations, and share insights across organizations. Finally, Python programming rounds out your technical toolkit, teaching data manipulation with Pandas and NumPy, statistical analysis with SciPy, and compelling visualizations with Matplotlib and Seaborn. The learning approach emphasizes project-based work using real business cases from finance, marketing, healthcare, and retail sectors.

Each module builds progressively on previous knowledge while demonstrating how different tools integrate within the complete data analysis workflow. You'll understand not just how to use each tool, but when and why to apply specific techniques for maximum impact. This course serves career changers transitioning into data roles, business professionals enhancing their analytical capabilities, recent graduates preparing for analyst positions, entrepreneurs seeking to leverage data for growth, and current analysts expanding their technical skills. The only prerequisites are basic computer literacy, high school level mathematics, and curiosity about problem-solving with data.

Upon completion, graduates are prepared for roles including data analyst, business intelligence analyst, reporting specialist, market research analyst, operations analyst, and junior data scientist positions. This cohort-based program is fully instructor-led — you learn live alongside a peer group over roughly six months, combining live classes, hands-on exercises, and capstone projects, with session recordings to revisit anytime plus direct instructor guidance and career services. Students earn a professional certificate demonstrating mastery across the complete data analysis spectrum, setting them apart with a comprehensive toolkit rather than single-tool expertise.

Curriculum

Programme structure

Prerequisites

Be ready to learn

What you'll learn

Create advanced formulas and functions for complex data calculations and analysis in Excel
Build dynamic pivot tables and pivot charts to summarize and explore large datasets
Design interactive dashboards with slicers, timelines, and conditional formatting
Perform statistical analysis using Excel's built-in tools and add-ins
Clean and transform messy data using Excel's data preparation features
Apply descriptive statistics to summarize and interpret dataset characteristics
Conduct hypothesis testing and interpret p-values and confidence intervals
Perform correlation and regression analysis to identify relationships between variables
Select appropriate statistical tests based on data types and research questions
Communicate statistical findings clearly to non-technical stakeholders

9 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