Day 56 · Dashboard and story 80 min 50 XP

📊Capstone: dashboard and story

Everything you found now has to reach a reader who was not there. Today you build the dashboard, write a one-page story with three findings, and finish the project. This is the piece that goes into your portfolio.

What you'll learn

Build a one-page Looker Studio dashboard from clean_orders.csv
Write three findings, each with a number and a recommendation
State the limits of the analysis honestly

A peek inside

Build the dashboard

Upload clean_orders.csv to Google Sheets and connect it in Looker Studio. Follow day 48's wireframe: top row of KPI cards paid revenue 637, paid orders 34, average order value 18.74, refunds and cancellations 4 of 38 orders, a monthly revenue chart, revenue by category, and a top customers table. Create `Paid revenue` and `Order size` from day 49 and add a date range and a category control. Mark April as partial in the chart title.

The rest of Day 56 is a Pro lesson

You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).

3 deep-dive lessons
A copy-paste worked example
3 hands-on practice tasks
Studio task: Ship the dashboard and story
3-question quiz, up to 45 XP
3 quick-glance glossary cards
50 XP + streak tracking

Unlock everything — go Pro

Already Pro? Sign in