All lessons

Module 1: Audience and question · Lesson 1.4 · about 9 min

Exploring vs explaining: the charts you make for yourself and for others

Exploratory charts help you find the story; explanatory charts tell it. Why you make many of the first and show only a few of the second, with Northbay examples.

Module 1 · about 9 minutes · read first: 1.3. You’ll know which charts to keep to yourself and which to polish and show.

1. Why this matters

A common mistake is to show the audience the whole search: twenty charts, in the order you made them. That’s like a detective reading out every note instead of naming the culprit. Knowing the difference between exploring and explaining saves your audience’s time and makes your point land.

2. The idea in one picture

Exploratory: you, at your desk, asking the data questions. Fast, ugly, many charts. Explanatory: your audience, with a few polished charts that prove one message.

Small multiples

Each category has its own season (2025, by month)

Electronics

05k10k15kJAJO

Home

05k10k15kJAJO

Outdoor

05k10k15kJAJO

Grocery

05k10k15kJAJO
Four small charts on the same scale instead of four tangled lines in one. Outdoor peaks in summer, Electronics at Christmas, Grocery stays flat. Monthly split shared out from each category's total using the data's season pattern.

You might make dozens of quick charts like these while exploring, then keep just one for the story (“Electronics peaks at Christmas, so stock it in October”).

3. The two modes

Exploratory Explanatory
Who it’s for You (and your team) A decision-maker
How many Dozens Two to five
Look Default settings are fine Decluttered, focused, titled with the point
Goal Find what’s interesting Make one point stick
Typical tools Power BI, Excel, Python notebooks Slides, a report page, an email

A dashboard sits between the two: it is designed (explanatory work on layout and KPIs) so that its users can explore their own questions every day. Module 4 covers dashboards.

Principle

Principle: explore widely, explain narrowly. The effort of finding the story should be invisible to the audience; what they see is the shortest path to the point.

Analogy: a film editor shoots hours of footage and shows you 90 minutes. The cut footage was needed to find the film.

4. Worked example

Exploring Northbay’s 2025 data, an analyst makes charts of: sales by month, by store, by category, by weekday, by product, margin by category, store vs target, growth by store, line amount spread. Nine charts. The message they settle on is about like-for-like growth and February. For the presentation they keep three:

  1. All stores vs same-four-stores growth (the main point).
  2. Monthly sales vs target and last year, with February highlighted.
  3. Store vs target (to show Forks Market is on plan).

The other six go in an appendix, ready for questions.

5. Practice

  1. You found that Sunday is the busiest day. Is a chart of sales by weekday exploratory or explanatory?
  2. Why is “show your work” a bad habit in a 10-minute meeting?
  3. Name one place where exploratory charts are welcome.
Answers
  1. It depends on use: made quickly to check, it’s exploratory. Polished with a title like “Weekends bring over a third of sales” for a staffing decision, it’s explanatory.
  2. It uses the audience’s limited time on your process instead of their decision.
  3. A working session with your team, an appendix, or a notebook shared with other analysts.

Next, Module 2: choosing the right chart for the question.

Check yourself

1How many exploratory charts should you show your manager?
2What is a typical exploratory chart like?
3A dashboard used every day by store managers is mainly...

Your ticks stay in this browser. Save them as a file on the course home.

Updated 2026-11-22. Northbay Goods is a made-up shop and its numbers are generated. The writing checks are simple rules run in your browser; nothing you type is sent anywhere or kept.