Data Analysis
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