Data analysis
Spootyfi learning pathway · Beginner to advanced
Ages 16+ · English · 8 suggested study hours · 3 levels
Clean data, calculate useful measures, create clear charts and turn findings into recommendations.
- Clean messy datasets
- Use descriptive statistics
- Build decision-ready charts
Beginner · Lesson 1 of 3
Asking analytical questions
Good questions are specific, measurable and connected to a decision.
Practical activity
Write a question and decision it supports.
Beginner · Lesson 2 of 3
Cleaning data
Check duplicates, missing values, inconsistent spellings, wrong data types and impossible values.
Practical activity
Find duplicates and missing values in a fictional table.
Beginner · Lesson 3 of 3
Descriptive statistics
Mean, median, mode, range and standard deviation summarise data. The median is less affected by extreme values.
Practical activity
For 2, 3, 4, 5, 100 calculate median 4 and mean 22.8.
Reference desk
- Google data analytics learning topics
- OpenStax Introductory Statistics
- PostgreSQL documentation
Original Spootyfi lessons and exercises; reference materials are not reproduced. Not affiliated with or endorsed by the reference providers. Course text is English; translations and expert editorial review are pending. Illustrations are conceptual.