From Data to a Data Story

Lesson 8 · taught by Pip

We've gathered every tool. This last stop ties them into one repeatable journey: the path from a messy export to a clear answer you can share. That finished thing has a name — a data story. It's a question, the honest work that answers it, and a picture that makes the answer land.

Think of a lighthouse keeper's nightly log. The keeper doesn't dump raw readings on the page; they record cleanly and end with the one line that matters: "Clear by midnight, all ships safe." A data story is that log. 🔦

The whole voyage, in order

Every good piece of data work follows the same arc. You've learned each piece; here's how they connect.

1. Start with a question. Not "let's look at the data," but a real, answerable one: "Which month was our busiest?" The question is your compass — it decides every choice that follows.
2. Clean the data. Fix typos, blanks, duplicates, and mismatched formats, so the answer can be trusted.
3. Sort and filter to explore. Order the rows and hide the ones that don't matter, to feel the shape and isolate what's relevant.
4. Summarize and group. Use formulas and a pivot table to fold the rows into the figures that answer the question.
5. Chart the answer. Pick the right chart, label it honestly, and let the eye see the conclusion at a glance.
6. Tell the story. Write the one-sentence answer in plain words, beside the chart that proves it.

That last step separates a pile of numbers from an insight. A chart alone makes the reader do the thinking; a sentence — "August was our busiest month, nearly double February" — hands over the conclusion, with the chart as evidence.

Honesty is the whole job

One thread runs through every step: tell the truth. Clean data so it's trustworthy, not so it flatters you. Summarize with the right measure (watch that average-versus-median trap). Chart with a zero baseline and clear units. If the data says something you didn't expect, that surprise is the insight — report it. Data work earns its power from being believed, and it's believed only when honest.

Your turn

Say the arc back in one breath: question, clean, sort and filter, summarize and group, chart, tell the story. If any step feels fuzzy, that's the lesson worth re-reading before you start the capstone.

Your capstone — build a data story

Here's the project that proves this whole course. Build a one-page data story from a real spreadsheet, and you'll have used every skill we covered.

Find data you care about — a personal budget, a hobby log, your steps or sleep, a public dataset. Then:

1. Write your question at the top, in one clear sentence.
2. Clean the sheet — fix typos, blanks, duplicates, and formats.
3. Sort and filter to explore and narrow to what matters.
4. Build a pivot table that summarizes by the category your question needs.
5. Make one honest chart of that summary — right type, clear title, labeled axes, zero baseline.
6. Write the answer in one or two plain sentences beside the chart.

Lay the question, the chart, and the answer-sentence on a single page. That's your data story — genuinely shareable. Anyone should grasp your question and answer in under a minute, without you there to explain.

Why this matters

This skill travels everywhere — household budgets, small-business reports, school projects, a curiosity you want to settle. All yield to the same patient voyage from raw rows to a clear picture. You came in seeing a spreadsheet as fog; you leave able to steer it to an honest answer and show that answer to anyone.

That's our voyage. Keep the lamp trimmed and your charts honest, and you'll always find your way through the numbers. Fair winds. 🐙

The rest of the shelf is waiting at /lighthouse/courses.