Data cleaning
Before data is being analysed , the first thing to consider is working with a clean data , Here are the
steps to lean this specific dataset.
Initial appearance of the dataset
Changed ‘W’ to ‘women’ in the gender aspect using find and replace
Converted all quantity i.e ‘qty’ column to numeric
Created a column called age group using IF statement
IF statement
Extracting the ‘month’ from the Date column , thereby making it a separate column.
Extracting Month
Data analysis
The first step was to create pivot tables to help analysis better . We will compare the sales and
orders using single charts.
Question 2 is reviewing the purchasing power between both genders in the year 2022, if we have a
look at the chart , this is what we see .
How can the various order statuses for 2022 be categorized? While the dataset initially presented
the Order ID as a sum of items, it was subsequently converted into percentages for a clearer
visualization.
Identifying the top 5 states contributing the most to sales is crucial for businesses to optimize
resource allocation and marketing strategies. This analysis highlights key markets for targeted efforts
to enhance profitability and strategic growth.
This reveals the relationship between age and gender across multiple orders. This will uncover
trends and disparities in order frequency among different demographic groups.
Determining which channel contributes the most to sales involves analysing data across various
platforms. We can view clearly in the order of percentage.
Dashboard visualization
Utilizing all these tables and charts, I compiled everything into a dashboard on a separate sheet. This
act was done to achieve a professional appearance and provide a clear summary of all the data.
Final dashboard
Insights
1. Sales and Order Trends: There is a clear seasonality in sales and orders, with peaks around
March and a notable dip in November. The trend line indicates that while the number of
orders has slight fluctuations, the total amount of sales has a downward trend in the latter
months.
2. Gender-based Sales: Women contribute more to sales than men, accounting for over 64% of
total sales, suggesting that the store’s product line resonates more with female customers.
3. Order Status: A majority of orders are delivered (over 60%), with cancellations, refunds, and
returns comprising the rest. This shows effective order fulfillment with a relatively low
return rate.
4. Top States by Sales: The top 5 states contribute significantly to the sales, with Maharashtra
leading. This indicates a strong market presence in these regions.
5. Age Group & Gender Demographics: The predominant age group purchasing from the store
is adults, and among them, women again dominate the sales.
6. Sales Channels: Amazon is the leading sales channel, followed by Flipkart and Myntra. This
shows a diverse and effective multi-channel retail strategy.
Conclusion:
The N Store’s performance in 2022 highlights its strong market presence, particularly among female
customers and in key states like Maharashtra. While there’s seasonal variability in sales, the overall
order fulfilment process appears robust with high delivery rates. To optimize future strategies, the
store may focus on strengthening sales during low-peak months and further leverage the successful
channels like Amazon. Continued attention to the preferences of the adult demographic and
exploration of strategies to engage more male customers could also be beneficial.