E-Commerce Store Sales Analysis
Python
EXECUTIVE SUMMARY
This project entails an exploratory data analysis of an e-commerce store. The business operates majorly in Europe & middle east with an annual revenue of approximately 9 million dollars in 2010.
INSIGHTS
1. 55% of sales are made between 11 am and 2 pm.
2. November had the highest number of orders, probably because it had the highest number of free orders.
3. Customers from the UK represent 90% of total customers, with Germany & France accounting for less than 5%.
4. 23% of customers are retained and they account for 51% of monthly revenue on average.
​
Orders by Hour of Day
1. 16.88% of all orders are placed by 12 noon and over 50% are made between 11 am and 2 pm.
Orders by Day of Week
Thursdays have slightly higher orders than other days of the week.
Order by Month
1. November 2011 had the most orders in the year, the orders in the month of November are over 25% higher than the second-highest month.
2. The high number of free orders in November might be responsible for the increased number of orders in the month.
Orders by Country
90% of all orders came from customers residing in the UK, and approximately 4.5% come from France and Germany
.png)
