E-commerce Data Analysis

Process:-

• To perform accurate analysis and fetch useful insights, I viewed the data and came forward to fight the missing and abnormality in data.
• After making the data crystal clear for analysis, I took out the basic insights of the dataset with the help of Descriptive Statistical analysis such as Total Sales, Average Sales, Unique Product Categories, Minimum and Maximum Sales, Midpoint of Data, etc.
• The next step was to analyze the data by taking a deep dive into it with the help of Pivot Table. I created numerous tables to fetch all the important insights such as *Top 10 States, Orders by Brands, Orders and Sales by Months, B2B orders, Average Amount by Gender and Age-Group, Max Orders by Gender, Product Sizes, and Categories.
• Then comes my favorite step creating a dashboard full of useful insights. I arranged all of them and used storytelling to make the crucial insights speak clearly with the help of Pivot Charts.

Important Insights:-

• Amazon is the most popular brand having 11,016 orders in 2022.
• March was the most profitable month having ₹1.93M sales and 2,819 Orders.
• Maharashtra holds the first position in the Top 10 States having 4,519 orders.
• Adults spent a little higher as compared to Senior Citizens.
• Approximately 28,600 orders were delivered out of 31,047 orders.
• Around 0.96% of orders were coming from B2B.
• 69.4% of orders were ordered by Women.
• In 2022, a total of 31,047 orders were placed having sales of ₹21.07 million.
• Store having ₹682.07 average sales with 11 product sizes and 8 product categories.