Analysis of bike store sales

Analysis of bike store sales over three yeers:2016,2017 and,2018

Key Results

Total Sales 8.58M

Net Sales 7.69M

Discount Percentage 10.37%

Total Orders 1615

Units Sold 4722

Monthly Orders 56 in 2016 , 57 in 2017 and, 24 in 2018

Sales Growth Rate

Average Purchase Value 5.36K

Average Of Delivery Duration is 2 days

Maximum Shipping Delay is 2 days

Percentage of Delay in Orders 28%

Most Store in terms of sales is "Baldwin Bikes"

Most state in sales and Count of Customers is "NY"

Top Sales Person in terms of Sales is "Marcelene Boyer"

In the last 7 Months of 2018, sales decreased by 66.8% compared to previous years due to a decline in the number of orders during this period.

Most brand name in terms of sales is "Trek" and, Category name is "Mountain Bikes" and "Cruisers Bicycles" in terms of orders