The dataset comprises of Sales data for Eastside Company. It's a retail company that deals in Fashion, Auto & Accessories, Electronic, and Home & Furniture. The dataset has Order ID, Product Name, Product Category, Sales, Profit, Shipping Cost, Customer name, Country, etc. Time frame given is for 1 year - 2022.
Objective : The primary objective of this analysis is to uncover patterns, and trends by designing a dashboard to analyze and extract meaningful insights about the data.
Dataset : Ecommerce_Dataset
Questions :
- Find Category-wise Sales for the year ( Month wise breakup).
- Find Geography-wise Sales for the year.
- Find top and bottom 5 products w.r.t Sales.
- Find top 5 products w.r.t Net Margin.
- Is there any product that needs to be discontinued?
- How many customers and orders are received from each State?
- Find the average order value for products per month.
Insights :
- Sales amount was highest for Fashion category followed by Home & Furniture which showed highest sales in the month of November and low sales in the rest of the months.
- Sales amount was highest in France of Central region followed by USA and was lowest in Canada.
- Top 5 products w.r.t Sales were T-Shirts, Titak watch, Running Shoes, Jeans and Formal Shoes. Bottom 5 products w.r.t Sales were Mouse, Watch, Mixer/Juicer, LCD and Keyboard.
- Top 5 products w.r.t Net Margin were Tyre, Car Pillow & Neck rest, Apple laptops, T-Shirts and Car speakers.
- The products, Watch and Mouse, gave very less Net Margin and Sales so, these products can be considered to be discontinued in the future.
- Highest no. of Customers and Orders were from the state of Ile-de-France with a count of 981.
- The average order value per month was highest for the product, Sports Wear, with a value of 236.
Dashboard:
