Superstore

Introduction

Analysis and Insights

• For shipping mode, Standard class is the most popular, taking over 50% of the orders, followed by Second Class, First Class, and Same Day. The Processing Days (time range between the Order date and Ship date) have a range from 0-7 days and most are around 3 days.

• For sales, our main customer is direct consumer, the second place is corporate and the last position is a home office.

• Sales by categories are not very different. Technology is the largest with 36.6%, followed by Furniture (32.2%) and Office Supplies ( 31.2%)

• According to revenue, each category also has its own dominant sub-category product. For technology is Phones, furniture is Chair, and Office Supplies is Storage.

• The distribution of sales during one year seems to follow a similar pattern, which reak a peak in March, September, and November.

• Among 4 years under research, the growth rate in 2016 was negative. Although the growth rate in 2017, and 2018 are all good, the revenue growth in 2018 tends to grow slower than it did in 2017.

• The top 3 Cities that gain the highest revenue are New York City, Los Angeles, and Seattle. Most orders come from the Technology category, followed by Furniture and Office Supplies. This trend applies to all three cities.