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
Same data, two honest answers: say which one you show
- 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
- Audience (Lesson 1.2): write three lines: who decides, what they believe, what you want.
- Big idea (1.3): one sentence with a finding, a reason and an ask.
- Titles (5.2): five slide titles that tell the story on their own, in SCR order (5.1).
- Charts (Module 2): one per slide, chosen from the question.
- Design (Module 3): declutter, grey plus one colour, labels, an action title, alt text.
- KPI (Module 4): one slide or card with your recommended monthly KPIs.
- Summary email (5.3): answer first, under 100 words.
- Caveats (5.4): the one or two that matter, next to their claims.
- 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.”
- 2025 beat target by 6.6 %, but growth in our older stores is half the headline. (summary, one KPI row)
- Sales beat 2024 in every month except February. (line chart, February circled)
- Without Forks Market, growth was 14 %, not 29 %. (headline vs like-for-like bars)
- Forks Market is on plan: 99.6 % of target in its first 10 months. (store vs target bars)
- 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
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.