Description
- Welcome to eCommerce Sales Data Analysis...
- explore The data used here is an open-source dataset from Kaggle. This dataset contains two tables:
Details & Orders.
Details Table contains features like:
- order-ID, Amount, Profit, Quantity, Category, Sub-Category, Payment-mode, Avg. On Order (Self created not default feature).
Order Table contains features like:
- Order-ID, OrderDate, CustomerName, State, City. - Filter Data We meticulously clean and explore the raw data using Exploratory Data Analysis (EDA) and leverage SQL to transform and filter the information.
- Engineering Key features are then extracted through feature engineering, ensuring only the most relevant insights are culled for insightful report generation.
- Insights Power BI swoops in as the final weapon, crafting a compelling dashboard that crystallizes the unearthed eCommerce sales intelligence. This meticulous process yields actionable insights, empowering data-driven decision making for the company.
Insights From The Data Analysis
Sum of Amount analysis
SUM:
Overall Sum of Amount is currently at $161,288.Highest Amount:
Sum of Amount for Order ID B-26055 and other segments are significantly higher that others.
Sum Of Quantity Analysis
Ouantity:
Overall Sum Of Quantity is currently at 2008 Units.Highest Quantity Segment:
Sum Of Quantity for Order-ID B-26055 and other segments are significantly higer than others.
Sum Of Profit Analysis
Overall:
Overall Sum Of Profit is currently as $25,942.Less Profit Segment
Sum of Profit for Order-ID B-26097 is significantly lower than other segments.High Profit Segment:
Sum of Profit for Order-ID B-25973 and 16 other segments is significantly Higher.
Customer & City
Economic growth
Sum of Profit is greater in city Indore and Pune than other cities.Best Quarter
Sum of Profit is can be seen more in the first Quarter(qtr1).High Profitable Sub-Categories
Sum of Profit by Sub-Category is high on Printers and Bookcase Sales.