Built with datascienceportfol.io

E-Commerce Sales

Project photo

Project links

Skills

About this project

Project Overview

 

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.

 

About the Data

 

The primary dataset can be found on <(https://www.kaggle.com/datasets/gabrielramos87/an-online-shop-business)>. 

 

Tools Used

 

  • Excel - Data Cleaning
  • SQL - Data Cleaning & Data Analysis
  • Tableau - Data Visualization

 

Data Cleaning/Preparation

 

  • Data loading and Joining
  • Data Cleaning and Sorting
  • Data Formatting and Transforming

 

Key Metrics

 

  • Total Sales
  • Total Products
  • Total Customers

 

Exploratory Data Analysis (EDA)

 

EDA was performed to answer key questions, such as, but not limited to:

  • How was the sales trend over the months?
  • Which products had the most sales?
  • How many products does the customer purchase in each transaction?
  • What are the most profitable segment customers?

 

Results/Findings

 

  • We see that the early months of the year had constant sales from 12/2018 to 08/2019. Afterwards, we start to see an upwards trend in the amount of sales from 09/2019 to 11/2019. Between 08/2019 and 09/2019, there was an increase of 42% in sales.

image

  • Popcorn holder, world war 2 gliders, and paper crafts little birdies were amongst the top products being sold to consumers. These 3 products had over 500,000 pounds in sales.

image

  • Customer 14585 had purchased 1,111 products, followed by customer 16219 with 747 products, and customer 15492 with 730 products. Many customers amongst the list had made other orders, but these orders represents the highest amount of products purchased in 1 transaction.

image

  • We see customer 14646 as the most profitable segment customer with 2.1million pounds in sales alone. The following customers purchased half of customer 14646 between 800,000 and 1 million pounds in sales.

image

 

Recommendations

 

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.

 

Limitations

 

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