Capstone: your own pipeline

Pro lesson Expert

Ship the dashboard

Serve the numbers the owner asked for on day one, and prove they are right.

20 min10 hands-on steps

In this lesson you will

  • Build the owner's three dashboard views from the star schema
  • Catch a fan-out in a last-minute change, and a misleading unknown customer
  • Prove the dashboard against the raw files, and write a README an employer will believe

Words you'll meet

Dashboard view
A view shaped for one chart or table on the dashboard, read by the dashboard tool.
Repeat-customer rate
Of the known customers who ordered, the share who ordered more than once.
README
The front page of a project: what it does, how it is tested, and what comes next.

The steps

Each step teaches one idea, then has you try it hands-on in your browser, and checks your work.

  1. 1Three questions, three grains
  2. 2Daily revenue per shop
  3. 3Draw it
  4. 4Top items per shop
  5. 5Who counts as a customer?
  6. 6Repeat-customer rate
  7. 7A last-minute request
  8. 8Fix it at the right grain
  9. 9Write the README
  10. 10Challenge

This lesson is part of LearnDE Pro

$12 a month or $100 a year: every lesson, spaced-repetition flashcards, and Learn by teaching. Refund on request within 14 days.