Data Analysis

beginner

Checking your access…

Module 1Introduction to Data Analysis

  • L1What is Data Analysis?

  • L2Types of Data

  • L3The Analysis Process

  • L4Sources and Quality of Data

Module 2Spreadsheet Foundations

  • L1The Spreadsheet as a Data Tool

  • L2Formulas and Cell References

  • L3Essential Functions I

  • L4Essential Functions II — IF, SUMIF, COUNTIF, VLOOKUP

Module 3Data Cleaning & Preparation

  • L1Inspecting Data Before You Clean

  • L2Handling Missing Values

  • L3Duplicates and Wrong Values

  • L4Standardising Formats

Module 4Descriptive Statistics

  • L1Central Tendency — Mean, Median, Mode

  • L2Measures of Spread — Range, Variance, Standard Deviation

  • L3Distributions and Shape

  • L4Percentiles and Outliers

Module 5Data Visualisation

  • L1Choosing the Right Chart

  • L2Bar and Column Charts

  • L3Line Charts

  • L4Pie Charts and Alternatives

Module 6Programming for Data (Python)

  • L1Why Program, and Setting Up Colab

  • L2Python Basics for Analysis

  • L3DataFrames with pandas

  • L4Filtering and Summarising

Module 7Exploratory Data Analysis

  • L1Question-First EDA

  • L2Univariate Exploration

  • L3Bivariate Exploration

  • L4From Exploration to Insight

Module 8Reporting & Dashboards

  • L1Structuring an Analysis Report

  • L2Dashboard Design Principles

  • L3Building a Simple Dashboard

  • L4Presenting Findings

Module 9Capstone: Analyse a Real Dataset End-to-End

  • L1Scoping and Understanding the Dataset

  • L2Cleaning and Preparing the Capstone Data

  • L3Analysing and Visualising the Capstone Data

  • L4The Report and the Presentation