From: Dana Whitfield, Head of Operations, Juniper Trail Outfitters
We're redesigning checkout and could make Express the highlighted shipping option. Before we do, I want to know how Express orders compare with the other options.
Data: Juniper Orders, one row per order line, 2022 to 2025, with Ship Mode, Sales, Segment and dates.
What I need: short answers to a few questions, then your recommendation. Each step builds on the view from the step before.
This is a case study: a question from a colleague, answered with the skills from the first units. Work through the steps in order. Each one starts from your view in the step before, and the last step asks for a recommendation backed by what you found.
Read the brief, then build each view and answer the question in the panel above the worksheet. If a step asks for a number, read it from a label or a tooltip. There's no single right chart for every step: any view that shows the answer clearly is fine.