Data

Data analysis

Turn raw data into clear answers. Learn how to ask good questions, clean data, find patterns and explain what you found.

30 lessons3 sectionsFreeUpdated November 2026

Turn raw data into clear answers. Learn how to ask good questions, clean data, find patterns and explain what you found.

What You Will Learn

  • Asking questions and choosing what to measure
  • Cleaning and preparing data
  • Summarising with averages, counts and percentages
  • Spotting trends, outliers and bias
  • Visualising data clearly
  • Presenting findings to non-experts

What You Will Build

  • A cleaned dataset with documented steps
  • A one-page insights report
  • A chart story about a real dataset

Who This Course Is For

Beginners who want to work with data, and professionals who need to back decisions with evidence.

What You Need

Basic spreadsheet skills are helpful.

How The Course Works

Every course on Skills in Minutes is free and follows the same five sections: Beginner, Intermediate, Advanced, Projects and Go pro. Each lesson is short, ends with a quick quiz and a summary, and builds on the one before. You can stop and return at any time.

Where It Can Lead

  • Data analyst
  • Business or marketing analyst
  • Operations and reporting roles

Results depend on your practice, your goals and your market. This course gives you the skills and a portfolio of practical work to show for it.

Course Outline

Beginner10 lessons1What Data Analysis Is, and How to Ask a Good Question2Tables, Columns and Data Types: Look Before You Analyse3Cleaning Data, Part One: Duplicates, Gaps and Wrong Types4Cleaning Data, Part Two: Text, Dates, Outliers and a Cleaning Log5Summaries: Counts, Means, Medians and Percentages6Comparing Groups: Grouping, Shares and Small Samples7Change Over Time: Weekly Counts, Moving Averages and Trends8Bias and Traps: Simpson’s Paradox, Missing Answers and Cause9Charts That Tell the Truth10Beginner Project: A Cleaned Dataset and a One-Page Insights Report
Intermediate10 lessons11Designing Measures and a Data Dictionary12Combining Tables: Joins, Keys and the Danger of Fan-Out13Reshaping Data: Crosstabs, Pivot Tables, Wide and Long14Dates and Time Series: Months, Partial Periods and Seasons15Sampling and Uncertainty: Standard Errors and the Bootstrap16Comparing Two Groups: Is the Gap Luck? A Permutation Test17Correlation and a Simple Line Fit, with Cautions18Coding Free-Text Survey Comments into Themes19Dashboards and Reports in Plain Text, with Built-in Checks20Intermediate Project: Do Members Visit More?
Advanced10 lessons21Cleaning Pipelines You Can Run Again: Functions, Config and a Log22Testing Your Analysis Code: Small Tests Catch Silent Bugs23Outliers and Robust Summaries: Spot, Look, Decide24Missing Data in Depth: Why It Is Missing and What Filling Does25Many Comparisons and Effect Sizes: Do Not Fool Yourself26Simple Forecasts and Honest Ranges: Test on Sessions You Held Back27Responsible Data: Privacy, Small Groups and Bias (an Outline)28Data Analysis in Professional Life: A Worked Pricing Example29Handling Analysis Projects: Scope, Critical Path and Change30Capstone: Should the Workshop Open a Second Evening?

Questions

Do I need to code?

No. The course starts in spreadsheets and points to SQL and Python when you are ready.

Do I need strong maths?

Basic arithmetic and percentages are enough to begin.

What tools does it use?

Spreadsheets mainly, with free tools introduced for charts.