E-Commerce Sales
Project links
Skills
About this project
E-Commerce has become a new method in supporting business development. Businesses can look to sell products or services online to yield more sales and profits. E-commerce has revolutionized the way people shop and consume products and services. With the press of a button, whether on the computer or mobile phone, consumers can purchase their products with ease and without having to set foot inside the store. This project's goals are to find the top performing products purchased from many customers, the top spending customers, and where most of these purchases are made from.
The primary dataset can be found on <(https://www.kaggle.com/datasets/gabrielramos87/an-online-shop-business)>.
Key Metrics
EDA was performed to answer key questions, such as, but not limited to:
Based on the analysis, we recommend the following actions:
The business should focus primarily on supplying stock for the top 10 best performing products, in terms of sales. These products would be sold quickly to customers without a worry. Focusing on the top 10 customers would yield the most sales as these customers had the highest sales throughout the year.
This dataset did not provide profit margins or product costs. This is important in determining which products actually yielded profit or loss. This also ties to which customers had the best profit return rate. Another limitation that would greatly improve the analysis would be to categorize the products into sub-categories. This can help in determining which categories do better in terms of profit. December 2019 sales were removed from this dataset because the dataset only had 10 days worth of data which would lead to a misleading analysis.
Please visit the above Tableau link to view the dashboard and Github page to view the code and dataset.
https://public.tableau.com/app/profile/david.lee7724/viz/E-Commerce_Sales_17394108448470/Dashboard1