Would you voluntarily spend another five hours on this kind of problem? Why?
Data Analytics & BI · 75–120 min
Challenge one metric before drawing the dashboard
Experience analysis as question, validation, metric definition and communication—not chart decoration.
Start the experiment01 · Setup
What you need
- Basic spreadsheet or SQL skill and a local tool already set up. Create a fictional 20-row orders CSV with date, channel, amount and status; do not use personal or confidential data.
You may stop when the timebox ends. An incomplete result is still useful evidence.
02 · Task
The work sequence
- 01
Write one decision question: which channel deserves a closer look next week? Define order count, completed revenue and cancellation rate before calculating them.
- 02
Check row count, types, duplicate order IDs, missing values and impossible amounts. Record each check and repair only your fictional data.
- 03
Calculate the three metrics by channel. Independently recompute one total or inspect its contributing rows so the tool is not your only evidence.
- 04
Create one accessible chart and a small table. Add a title that states the question, labels that do not rely only on color and a note defining the denominator.
- 05
Write a three-sentence recommendation: finding, caveat and next evidence. Change one definition—for example include cancelled revenue—and explain why the conclusion changes.
03 · Pay attention
Watch your reaction, not only the output
- Was defining the metric harder than making the chart?
- Could another person reproduce your number and understand its limitation?
Plot twist
Difficulty does not mean the career is a bad fit. The useful question is whether curiosity returned after the difficulty.
04 · Reflect
Three honest questions
Which part gave you energy, and which part drained it?
What evidence—not a salary video—would you gather before choosing this path?
This site does not save your answers. Put them in your own notebook if useful.
05 · Where to go next