Data Analytics Fundamentals

← Back to Training

Course Overview

Organisations today generate more data than ever before, yet the ability to transform that data into actionable insight remains one of the most sought-after skills in the modern workforce. This course equips you with the practical knowledge and hands-on experience needed to collect, clean, analyse, and communicate data effectively — regardless of your technical background.

Across eight carefully structured modules, you will progress from foundational concepts such as data types and structures through to advanced topics including statistical analysis, interactive dashboard design, and persuasive data storytelling. Each module combines concise video lessons with real-world datasets so you can immediately apply what you learn.

Without data, you're just another person with an opinion. This course ensures you become the person who turns numbers into narratives that drive real outcomes.

By the end of this course you will have a portfolio-ready capstone project that demonstrates your ability to take a messy, real-world dataset and deliver a polished analysis with clear recommendations — a tangible asset you can present to employers or stakeholders.

Who Should Enrol

This course is designed for professionals who work with data in any capacity and want to strengthen their analytical capabilities. It is equally suited to career-changers looking to break into analytics and to experienced professionals seeking to formalise their self-taught skills.

• Business analysts and operations managers who need to extract insight from spreadsheets and databases but lack formal training in analytics methodology.
• Marketing and sales professionals who want to move beyond vanity metrics and build dashboards that genuinely inform campaign strategy.
• Aspiring data analysts preparing for roles that require demonstrated competency in data wrangling, visualisation, and statistical reasoning.
• Team leads and managers who review reports and dashboards daily and want to ask better questions of their data teams.
• Entrepreneurs and consultants who need to make data-backed decisions without relying on expensive external analysts.

Module Breakdown

Module 1 — Data Foundations

This opening module establishes the conceptual groundwork for everything that follows. You will explore the different types of data — structured, semi-structured, and unstructured — and learn how databases, data warehouses, and data lakes store and organise information. The module also introduces the analytics lifecycle: from defining the business question through to delivering actionable recommendations. By the end, you will understand how to frame any business problem as a data question and identify which datasets are needed to answer it.

Module 2 — Data Collection & Cleaning

Raw data is rarely ready for analysis. This module teaches you the essential techniques for gathering data from multiple sources — APIs, flat files, web scraping, and survey instruments — and transforming it into a usable format. You will learn to identify and handle missing values, duplicates, outliers, and inconsistent formatting. Hands-on labs walk you through cleaning messy datasets using both spreadsheet tools and Python's Pandas library, giving you a practical toolkit you can apply immediately.

Module 3 — Exploratory Data Analysis

Before building models or dashboards, skilled analysts spend time exploring their data to uncover patterns, anomalies, and relationships. This module covers summary statistics, frequency distributions, correlation analysis, and cross-tabulation. You will learn how to generate hypotheses from data and use exploratory techniques to validate or refute them. Labs in this module use real-world retail and healthcare datasets so you can practise identifying meaningful trends amid noisy data.

Module 4 — Statistical Fundamentals

Statistics provides the rigour that separates guesswork from genuine insight. This module covers descriptive statistics, probability distributions, hypothesis testing, confidence intervals, and regression basics. The emphasis is on practical application rather than mathematical proofs — every concept is illustrated with a business scenario and accompanied by a guided exercise. By the end, you will be able to determine whether observed differences in your data are statistically significant and communicate that finding clearly to non-technical audiences.

Module 5 — Data Visualisation Principles

A chart can illuminate or mislead depending on the choices behind it. This module covers the principles of effective data visualisation: choosing the right chart type, using colour intentionally, designing for accessibility, and avoiding common pitfalls like truncated axes and misleading scales. You will study examples of both exemplary and deceptive visualisations and develop a critical eye for evaluating the charts you encounter in reports, news articles, and dashboards.

Module 6 — Dashboard Design

Dashboards are how most organisations consume analytics on a daily basis. This module teaches you how to design dashboards that are focused, intuitive, and aligned with the decisions they support. You will learn layout principles, filter and drill-down design, KPI selection, and the difference between operational, tactical, and strategic dashboards. Labs guide you through building interactive dashboards in both Excel/Google Sheets and a dedicated BI tool, complete with dynamic filters and conditional formatting.

Module 7 — Data Storytelling

The most technically brilliant analysis is worthless if it fails to persuade its audience. This module focuses on the narrative layer of analytics: structuring a data story with a clear beginning, middle, and end; selecting the right level of detail for your audience; and using annotations, callouts, and sequencing to guide the viewer's attention. You will practise presenting findings in both written report and live presentation formats, receiving feedback on clarity, persuasiveness, and visual design.

Module 8 — Capstone Project

The capstone draws together every skill covered in the course. You will receive a realistic brief from a fictitious organisation along with a raw, uncleaned dataset. Over the course of this module, you will define the analytical question, clean and explore the data, perform statistical analysis, build a dashboard, and deliver a polished data story — complete with an executive summary and recommendations. The finished project becomes a portfolio piece that demonstrates end-to-end analytical competence.

Learning Outcomes

Upon successful completion of this course, you will be able to:

1. Frame business problems as data questions and identify the datasets required to answer them.
2. Collect data from multiple sources and apply systematic cleaning techniques to prepare it for analysis.
3. Conduct exploratory data analysis to uncover patterns, trends, and outliers in complex datasets.
4. Apply core statistical methods — including hypothesis testing and regression — to validate findings with appropriate rigour.
5. Select and design visualisations that accurately represent data while adhering to accessibility standards.
6. Build interactive dashboards tailored to different organisational audiences and decision contexts.
7. Construct and deliver compelling data stories that translate analytical findings into clear, actionable recommendations.
8. Execute a complete analytics project from brief to final presentation, demonstrating professional-grade methodology.

Prerequisites

This course is designed to be accessible to learners without a strong technical background. However, the following will help you get the most from the material:

• Basic spreadsheet proficiency — you should be comfortable creating formulas, sorting data, and using filters in Excel or Google Sheets.
• Comfort with numbers — no advanced maths is required, but you should be at ease interpreting percentages, averages, and simple charts.
• Curiosity and persistence — the labs involve working with real data, which means encountering ambiguity and troubleshooting issues as part of the learning process.

No prior programming experience is necessary. Python basics are introduced gently in Module 2 and scaffolded throughout subsequent modules.

Tools & Technologies Covered

Throughout the course you will gain hands-on experience with industry-standard tools used across analytics teams worldwide:

• Microsoft Excel / Google Sheets — pivot tables, VLOOKUP/XLOOKUP, conditional formatting, and chart creation.
• Python (Pandas, Matplotlib, Seaborn) — data manipulation, cleaning, and programmatic visualisation.
• SQL — querying relational databases to extract and aggregate data.
• Tableau / Power BI — building interactive dashboards with drag-and-drop interfaces and calculated fields.
• Jupyter Notebooks — documenting analysis workflows in a reproducible, shareable format.
• Google Looker Studio — creating web-based dashboards connected to live data sources.

All software used in this course is either free or available through free trial licences. Setup guides are provided at the start of each relevant module.