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.
Each category has its own season (2025, by month)
Electronics
Home
Outdoor
Grocery
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:
- All stores vs same-four-stores growth (the main point).
- Monthly sales vs target and last year, with February highlighted.
- Store vs target (to show Forks Market is on plan).
The other six go in an appendix, ready for questions.
5. Practice
- You found that Sunday is the busiest day. Is a chart of sales by weekday exploratory or explanatory?
- Why is “show your work” a bad habit in a 10-minute meeting?
- Name one place where exploratory charts are welcome.
Answers
- 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.
- It uses the audience’s limited time on your process instead of their decision.
- 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
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.