← All use cases

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

Annual sales report · open and read it (the report is in Chinese)Open full screen ↗
  • The peak-season stock list added in the second round: how the quantity is worked out, then the top 20 products month by month

How it got made

What was asked, word for word

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.

  1. Put the orders in the workspace and send that one sentence

    Put the orders in the workspace and send that one sentence
  2. 14 min later: the report, with the data cleaned first

    14 min later: the report, with the data cleaned first
  3. Passing on the boss's question: add a stock list

    Passing on the boss's question: add a stock list
  4. 8 min later: the stock section is in

    8 min later: the stock section is in