Data Lab · Career skills · Full course
Free data analysis course: spreadsheets, charts and SQL

Data Lab is a free, full course in data analysis, the skill behind decisions in almost every job. It has 8 units and 32 lessons: thinking with data and tidy tables, spreadsheet formulas and functions, cleaning messy data, honest summaries like mean, median and percent change, charts that tell the truth, SQL from SELECT to GROUP BY and JOIN, and turning analysis into decisions without falling for correlation or biased samples.
Every lesson explains one idea in plain words, works a real example step by step, then asks two or three questions that make you use it. Wrong answers explain why and come back in Review until they stick. There are 122 practice and quiz questions in all, plus five hands-on labs: spreadsheet lab, cleaning lab, mean versus median, chart lab and SQL lab.
Pass every unit quiz with 80% or more and finish the final project, answering a business question with SQL and writing it up for a manager, to earn a printable certificate of completion. Progress is saved only in this browser on this device, with nothing to sign up for.
Every lesson is free: no ads, no lives and no paywall.
What you'll learn
- What data is, how tables are organized, the kinds of values they hold and how to turn a hunch into a question data can answer.
- Cells, formulas and functions, relative and absolute references, and sorting and filtering, practiced in a working spreadsheet.
- Garbage in, garbage out: fixing spaces, spellings, duplicates, missing values and impossible numbers before you analyze.
- Mean versus median, percentages and percent change, spread, and grouping data with COUNTIF, SUMIF and pivot tables.
- Choosing the right chart, honest axes, clear labels and spotting misleading charts.
- Databases and tables, SELECT and FROM, filtering with WHERE, and sorting with ORDER BY and LIMIT, using a real database in your browser.
- COUNT, SUM and AVG, grouping with GROUP BY and HAVING, and joining tables to answer real business questions.
- Correlation versus causation, samples and bias, telling a clear data story and handling data ethically.
All 8 units
- Unit 1Thinking with dataWhat data is, and why it matters · Rows, columns and tidy tables · Kinds of data · Asking questions data can answer
- Unit 2Spreadsheet basicsCells and formulas · Functions: SUM, AVERAGE, MIN, MAX, COUNT · Copying formulas: relative and absolute references · Sorting and filtering
- Unit 3Cleaning dataGarbage in, garbage out · Fixing text: spaces, capitals and spellings · Duplicates and missing values · Outliers and sanity checks
- Unit 4Summaries that tell the truthMean versus median · Percentages and percent change · Spread: how much values vary · Grouping: COUNTIF, SUMIF and pivot tables
- Unit 5Charts that tell the truthChoosing the right chart · Honest axes · Titles, labels and one clear message · Spotting misleading charts
- Unit 6SQL basicsDatabases, tables and your first query · Filtering rows with WHERE · Sorting with ORDER BY and LIMIT · Reading a query like a database
- Unit 7SQL summaries and joinsCounting and totaling: aggregate functions · GROUP BY: summaries for each group · JOIN: combining tables · Answering a real business question
- Unit 8From analysis to decisionsCorrelation is not causation · Samples and bias · Telling the story · Data ethics and privacy
Questions
Is Data Lab really free?
Yes. Every lesson is free: no ads, no lives and no paywall. There is no account to make, and your progress is saved in your own browser.
Do I need Excel or Google Sheets?
No. The course has a working spreadsheet built in, with real formulas such as SUM, AVERAGE, COUNTIF and SUMIF, and the same skills transfer directly to Excel and Google Sheets.
Is the SQL real?
Yes. The SQL lab runs a real SQLite database in your browser, with an invented shop's customers, products and orders, and 24 challenges that check your results.
Is the certificate an industry certification?
No. It shows you completed every lesson, passed every unit quiz and finished the project of a free Forge course. The project itself is a piece of analysis you can show people.