All lessons

Module 6: Presenting to managers · Lesson 6.3 · about 60 min

Capstone: tell the Northbay 2025 story

Put the whole course together. Use the Northbay Goods data to write a big idea, build five slides with action titles and decluttered charts, write the summary email and prepare for questions.

Module 6 · about 60 minutes · read first: the whole course. You’ll have a five-slide data story and a summary email you can put in your portfolio.

1. Why this matters

Reading about storytelling isn’t the same as doing it. This project makes you go from raw numbers to a finished story, the way you would at work, and leaves you with something to show in interviews.

2. The brief

You are an analyst at Northbay Goods, a made-up chain of five stores (the same data as the Power BI course). The regional manager asks: “How did 2025 go, and what should we change for 2026?” You have 10 minutes in next week’s meeting.

Get the data: download the CSV files from Meet Northbay, or use the numbers in this course’s charts. Use any tool: Power BI, Excel, or the charts on these pages.

3. The key facts you can use

Headline growth vs like-for-like

Same data, two honest answers: say which one you show

2024, all stores203k2025, all stores262k2025, same 4 stores232k
All stores: +29 %. The same four stores that traded in both years: +14 %. The difference is Forks Market, opened in March 2025.
  • 2025 sales $262k vs $203k in 2024 (+29 %); target $246k (+6.6 % vs target).
  • Same four stores: +14 %. Forks Market opened 1 March 2025: $30.2k, 99.6 % of target.
  • Every month beat 2024 except February ($13.4k vs $13.6k); February also missed target by 8 %.
  • Rideau grew fastest (+19 %), Falls Centre slowest (+9 %).
  • Weekends: over a third of sales. Electronics: 36 % of sales, 49 % margin vs 54 % for Home and Outdoor.

4. Steps

  1. Audience (Lesson 1.2): write three lines: who decides, what they believe, what you want.
  2. Big idea (1.3): one sentence with a finding, a reason and an ask.
  3. Titles (5.2): five slide titles that tell the story on their own, in SCR order (5.1).
  4. Charts (Module 2): one per slide, chosen from the question.
  5. Design (Module 3): declutter, grey plus one colour, labels, an action title, alt text.
  6. KPI (Module 4): one slide or card with your recommended monthly KPIs.
  7. Summary email (5.3): answer first, under 100 words.
  8. Caveats (5.4): the one or two that matter, next to their claims.
  9. Questions (6.2): write the three hardest questions you might get, with answers; make an appendix slide for each.

5. Check your work

  • Reading only the titles gives the whole story.
  • Every chart proves its title in five seconds (test it on someone).
  • Growth is labelled: all stores or like-for-like.
  • No truncated bar axes, no 3D, no rainbow colours.
  • Colour is never the only cue.
  • The email has the finding and the ask in the first two sentences.

6. A sample outline (try yours first)

Show the sample

Big idea: “2025 beat target by 6.6 %, but our older stores grew 14 %, half the headline, so we should judge 2026 on like-for-like growth and fix what went wrong in February.”

  1. 2025 beat target by 6.6 %, but growth in our older stores is half the headline. (summary, one KPI row)
  2. Sales beat 2024 in every month except February. (line chart, February circled)
  3. Without Forks Market, growth was 14 %, not 29 %. (headline vs like-for-like bars)
  4. Forks Market is on plan: 99.6 % of target in its first 10 months. (store vs target bars)
  5. We recommend monthly like-for-like reporting and a February review before setting 2026 targets. (proposed KPI cards, owners and dates)

Appendix: weekday sales, category margin, Rideau vs Falls Centre.

7. Put it in your portfolio

Export the slides as PDF, add the summary email, and write a short page: the question, your big idea, two before-and-after charts, and what you’d do next. Showing storytelling in your portfolio shows how. If you also built the Northbay dashboard in the Power BI capstone, link the two: the dashboard explores, the deck explains.

Check yourself

1What should you write first in the capstone?
2Which comparison should the capstone use for growth?
3How do you know your deck is finished?

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.