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