Case Study: Corner Shop, Preparing the Data
A corner shop keeps a stock list. The owner wants to know which goods earn the most and what needs reordering. This case follows the steps you would take in Excel: tidy the list, calculate what the owner needs, then analyse it in the next lesson.
Step 1: make sure the data is a tidy table. Step 2: add calculated columns: stock value (units x price) and a reorder flag when units fall below the reorder level. Step 3: total the value.
Exampleexcel
Quick check
Which column makes the reorder decision?
Your turn: write the code
Fill G2:G4 with REORDER when units (C) are below the reorder level (D), otherwise ok.
Finish the quick check (and any code exercise) to complete this lesson, or mark it done yourself.
Tip: use the left and right arrow keys to move between lessons.