Module 5: Building the story · Lesson 5.2 · about 11 min
From dashboard to slides: one point per slide
A dashboard answers many questions; a presentation makes one argument. How to pick the charts, write a title for each slide, and build a short deck from your Power BI report.
Module 5 · about 11 minutes · read first: 5.1. You’ll be able to turn a dashboard into a short deck where every slide makes one point.
1. Why this matters
Pasting dashboard screenshots into slides is the most common way to lose a room: tiny charts, many numbers, no message. A dashboard is a tool for exploring; a presentation is an argument. Converting one into the other is a skill you’ll use every month in a BI job.
2. The idea in one picture
Each slide: an action title (the point), one chart that proves it, highlighted where it matters, and nothing else.
The last step is a slide: title, subtitle, one chart, one note.
3. Steps
- Write the big idea (Lesson 1.3) and the SCR outline (5.1).
- List the 3 to 6 points that support it. Each becomes a slide.
- Write each slide’s title as a sentence first. Read the titles in order: do they tell the whole story? (This is the “horizontal logic” test.)
- Pick or make one chart per slide that proves its title. Rebuild it for the slide: bigger text, decluttered, one highlight. Don’t screenshot the dashboard.
- Add one opening slide with the answer (the executive summary) and one closing slide with the ask.
- Move everything else to the appendix.
Principle
Principle: horizontal and vertical logic. Horizontally, the titles read in order make the argument. Vertically, everything on a slide supports that slide’s title. A slide that fails either test needs fixing or cutting.
Analogy: chapters in a book. Each has one job, and the chapter titles alone give you the plot.
4. Worked example
Northbay’s 2025 dashboard has 4 pages and 18 visuals. The deck for the regional manager:
- “2025 beat target by 6.6 %, but growth in our older stores is half the headline” (summary)
- “Sales grew 29 %, with every month above 2024 except February” (trend chart)
- “Without Forks Market, growth was 14 %” (headline vs like-for-like bars)
- “Forks Market reached 99.6 % of target in its first 10 months” (store vs target bars, Forks highlighted)
- “February missed target by 8 %: we need to find out why” (monthly vs target, February circled)
- “We recommend monthly like-for-like reporting from January” (the ask, with a mock KPI card)
Read just the titles: the whole story is there.
5. Practice
- Write slide titles for a three-slide deck about weekend sales and staffing.
- A slide has four charts. What do you do?
- Your manager will read the deck without you there. What changes?
Answers
- For example: “Weekends bring over a third of our sales” · “But we staff every day the same” · “We suggest moving 2 shifts a week from Tuesday and Wednesday to the weekend”.
- Find the one that proves the title; move the others to the appendix or their own slides.
- Titles and notes must carry the explanation on their own: add a short note to each chart, and write the summary slide as full sentences.
Next, Lesson 5.3: writing summaries and emails that put the answer first.
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.