Data Analysis - Oxtech Academy

About Course

Every business generates data, but only those who know how to analyse it can turn it into better decisions. Data Analysts help organisations uncover trends, solve problems, and identify opportunities by transforming raw data into meaningful insights.

This 12-week Data Analysis programme is designed to equip you with the practical skills needed to confidently work with data, even if you’re starting from scratch. You’ll learn how to organise and clean datasets, analyse information using Excel and Google Sheets, create professional charts and dashboards, write SQL queries, and communicate findings in a way that supports real business decisions.

Throughout the programme, you’ll work with real-world datasets, complete practical projects, and develop analytical thinking that employers value. By the end of the course, you’ll have a portfolio-ready capstone project that demonstrates your ability to analyse data and present actionable insights with confidence.

Understand the complete data analysis workflow from raw data to actionable insights.
Navigate and work confidently with Microsoft Excel and Google Sheets.
Use essential spreadsheet formulas including SUM, AVERAGE, COUNT, IF, VLOOKUP, and XLOOKUP.
Sort, filter, organise, and validate large datasets efficiently.
Clean messy datasets by removing duplicates, correcting inconsistencies, and handling missing values.
Create Pivot Tables to summarise and analyse large amounts of information.
Build professional charts and interactive dashboards for data visualisation.
Learn the fundamentals of SQL and understand how databases work.
Write SQL queries using SELECT, WHERE, ORDER BY, GROUP BY, COUNT, and JOIN.
Turn analytical findings into clear business reports and presentations.
Apply analytical thinking to solve real-world business problems.
Build a portfolio-ready capstone project using real datasets.

Course Content

Week 1 – Introduction to Data Analysis
You will be introduced to the meaning and purpose of data analysis and how it supports better decision-making. This section explains how data is collected, organized, interpreted, and used across industries such as business, finance, marketing, healthcare, education, and technology.

Module 1 – Introduction to data

31:06
Module 1 Quiz – Introduction to Data
Module 2 – Introduction to Data Analytics

26:55
Module 2 Quiz – Introduction to Data Analytics
Module 3 – The Data Analysis Workflow

29:47
Module 3 Quiz – The Data Analysis Workflow
Module 4 – Thinking Like an Analyst

34:56
Module 4 Quiz – Thinking Like an Analyst
Module 5 – Data visualization & storytelling

38:02
Module 5 – Data Visualization and Storytelling + General Quiz

Week 2 – Microsoft Excel for Data Analytics

Week 3 – Excel foundations & data handling
You will build a strong foundation for working with data using Excel and Google Sheets. This section covers how to enter, organize, format, sort, filter, and perform simple calculations so you can begin handling data more confidently.

Week 4 – Data Cleaning & Preparation
You will understand how to prepare raw data before analysis so your results are accurate, reliable, and useful. In this module, you will work on identifying and fixing common data issues such as duplicates, missing values, wrong formats, spelling inconsistencies, blank rows, and errors. You will also organize your dataset properly, standardize entries, and structure the data in a way that makes it easier to analyze, visualize, and turn into meaningful insights.

Week 5 – Data Visualisation
You will discover how to turn raw data into clear visuals that people can quickly understand and act on. In this module, you will explore how to choose the right charts, present patterns and trends, avoid confusing visuals, and use dashboards to communicate important business insights. By the end, you will be able to make data easier to read, explain your findings with confidence, and support better decision-making through simple, purposeful visuals.

Week 6 – Introduction to SQL
You will be introduced to SQL as one of the most important tools for working with data stored in databases. In this module, you will understand what SQL is, why data analysts use it, and how it helps you retrieve, filter, organize, and analyze information from large datasets. You will also begin to see how SQL connects to real business tasks such as finding customer records, checking sales performance, tracking transactions, and generating useful reports from structured data.

Week 7 – Storytelling with Data
This week focuses on transforming data insights into clear, engaging, and decision-driven narratives. It covers how to identify important findings, choose the right visuals, explain trends, highlight key patterns, and present recommendations in a way that makes data easy to understand and act on.

Week 8 – Building a Portfolio & Career Paths
You will learn how to package their data analysis projects into a simple portfolio that shows their skills, tools, and problem-solving ability. This section also introduces different career paths in data analysis, including business analyst, data analyst, reporting analyst, BI analyst, and entry-level analytics roles, helping students understand how to position themselves for opportunities.

Week 9 – Review & Revision
You will revisit the key concepts, tools, and practical skills covered in the Data Analytics course to strengthen your understanding before the final stage. This section helps you review important areas such as spreadsheet functions, data cleaning, visualization, reporting, pivot tables, and analytical thinking. It also gives you the opportunity to clarify confusing topics, correct mistakes, and prepare confidently for your final project or assessment.

Week 10 – Peer Review & Capstone Preparation
You will review your data analysis work with your peers, receive constructive feedback, and make final improvements before your capstone project. This section helps you check the quality of your analysis, charts, reports, formulas, and presentation of insights. You will also prepare to bring together everything you have learned in the course and apply it to a complete data project that shows your ability to clean, analyze, visualize, and explain data clearly.

Week 11 – Capstone Project Submission & Final Exam
The final week brings together everything covered in the Data Analysis course through a practical capstone project and final assessment. It focuses on applying key skills such as data cleaning, spreadsheet analysis, visualization, interpretation, and insight presentation, while assessing overall readiness to use data analysis in real-world scenarios.

Week 12 – Graduation & Certificate Preparation
You will complete the final requirements for the Data Analysis course, including project submission, assessment review, attendance confirmation, and certificate processing. This stage marks the end of your learning journey and prepares you to showcase your new data skills confidently.

About Course

What Will You Learn?

Course Content

Module 1 – Introduction to data

Module 1 Quiz – Introduction to Data

Module 2 – Introduction to Data Analytics

Module 2 Quiz – Introduction to Data Analytics

Module 3 – The Data Analysis Workflow

Module 3 Quiz – The Data Analysis Workflow

Module 4 – Thinking Like an Analyst

Module 4 Quiz – Thinking Like an Analyst

Module 5 – Data visualization & storytelling

Module 5 – Data Visualization and Storytelling + General Quiz

Week 2 – Microsoft Excel for Data Analytics

Module 6 – Introduction to Spreadsheet Fundamentals

Module 6 Quiz

Module 7 – Data Entry, Formatting & Worksheet Management

Module 7 Quiz

Module 8 – Essential Formulas & Functions

Module 8 Quiz

Module 9 – Tables, Sorting & Filtering

Module 9 Quiz

Module 10 – Data Cleaning for Analytics

Module 10 Quiz

Mini Challenge: Build an Analytical KPI Sheet

Week 3 – Excel foundations & data handling You will build a strong foundation for working with data using Excel and Google Sheets. This section covers how to enter, organize, format, sort, filter, and perform simple calculations so you can begin handling data more confidently.

Module 11 – Excel foundations & data handling

Module 11 – Advanced Functions for Data Analytics

Module 12 – Lookup Functions & Data Relationships in Excel.

Module 12 – Lookup Functions & Data Relationships

Module 13 – Pivot Tables for Business Analysis in Excel

Module 13 – Pivot Tables for Business Analysis

Module 14 – Data Visualization & Charting in Excel for Analytics

Module 14 – Pivot Charts & Analytical Reporting

Module 15 – Building Interactive Excel Dashboards for Business Intelligence

Module 15 Quiz – Advanced Dashboard Enhancement & Interactive BI

Module 16 – Introduction to Advanced Excel Analytics & Business Reporting

Module 16 – Advanced Excel Analytics & Business Reporting

Module 17 – Advanced Dashboard Enhancement & Interactive Business Intelligence in Excel

Module 17 Quiz – Advanced Dashboard Enhancement & Interactive BI

Module 18 – Scenario Analysis, Business Simulation & Decision Support in Excel

Module 18 Quiz – Scenario Analysis, Business Simulation & Decision Support

Module 19 – Power Pivot & Data Modeling Fundamentals for Business Intelligence

Module 19 Quiz – Power Pivot and Data Modeling

Module 20 – Capstone Business Analytics Project in Excel

Module 20 Quiz – Capstone Business Analytics Project

Module 21 – Understanding Data Visualization

Module 21 Quiz – Understanding Data Visualization

Module 22 – Choosing the Right Chart Type

Module 22 – Choosing the Right Chart Type

Module 23 – Creating Charts in Excel & Google Sheets (Part 1)

Module 23 – Creating Charts in Excel & Google Sheets (Part 2)

Module 23 – Creating Charts in Excel & Google Sheets

Module 24 – Introduction to Dashboards & Power BI

Module 24 – Introduction to Dashboards & Power BI Practical (Part 2)

Module 24 – Introduction to Dashboards & Power BI

Module 25 – Practical Application & Weekly Challenge

Module 25 Quiz – Practical Application & Weekly Challenge

Module 26 – Introduction to SQL

Module 26 – Introduction to SQL

Module 27 – Writing Basic SQL Queries

Module 27 (Part II) – Writing Basic SQL Queries (Practical)

Module 27 – Writing Basic SQL Queries

Module 28 – Filtering & Sorting Data

Module 28 – Filtering & Sorting Data II (Practical)

Module 28 – Filtering & Sorting Data

Module 29 – Aggregating & Combining Data

Module 29 – Aggregating & Combining Data II (Practical)

Module 29 – Aggregating & Combining Data

Module 30 – Practical Application & Weekly Challenge

End Of Week 6 Challenge

Module 31 – Understanding Data Storytelling

Module 31 – Understanding Data Storytelling

Module 32- Structuring a Data Presentation

Module 32 – Structuring a Data Presentation

Module 33 – Designing Effective Presentation Slides

Module 34- Presenting Insights to Different Audiences

Module 35 – Practical Applications

Module 36 – Building a Portfolio & Career Path

Module 37 – Publishing Projects Online

Week 3 – Excel foundations & data handling
You will build a strong foundation for working with data using Excel and Google Sheets. This section covers how to enter, organize, format, sort, filter, and perform simple calculations so you can begin handling data more confidently.