Data & analysis
A sales report from a year of shop orders
- Time
- 14 min + 8 min
- What was said
- 2 sentences
- Delivered
- Report: 8 findings, 8 ideas, stock list
The finished work
How it got made
online-retail.csv in the workspace is a full year of order lines from an online shop selling gifts and small homeware (December 2010 to November 2011, amounts in pounds). Put together a sales analysis for the boss: how sales change month to month, which products and which countries contribute most, how often customers come back, whether there are many returns; pick out the findings worth noting, and end with a few concrete suggestions to lift sales, each with its basis spelled out. Make it a laid-out HTML report (report/index.html) with all the charts in it, opening offline with no CDN.
Put the orders in the workspace and send that one sentence

14 min later: the report, with the data cleaned first

Passing on the boss's question: add a stock list

8 min later: the stock section is in


