Skip to content

I developed a comprehensive project in Excel, creating multiple dashboards and to analyze the data. This process involved several stages, including data preprocessing, data visualization.

Notifications You must be signed in to change notification settings

Anjalikumariyes/Vrinda-Store-Data-Analysis-Dashboard

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 

Repository files navigation

Vrinda-Store-Data Analysis (Interactive Dashboard creation using MS Excel)

Project Objective

The Vrinda Store wants to create an annual sales report for 2022. So that, the owner of the Vrinda can understand their customers and grow more sales in 2023 & 2024.

Dataset used

Ouestions (KPIs)

  • Compare the sales and orders using single chart.

  • Which month got the highest sales and orders?

  • Who purchased more-men or women in 2022?

  • What are different order status in 2022?

  • List top 10 states contributing to the sales?

  • Relation between age and gender based on number.

  • Which channel is contributing to the sales?

  • Highest selling category?

  • Percentage of Total Orders delivered

  • Dashboard Interaction view Dashboard

Process

  • Verify data for any missing value and anomalies, and sort out the same.
  • Made sure data is consistent and clean with respect to data type, data format and values used.
  • Created pivot table according to the questions asked.
  • Merge all pivot table into one dashboard and apply slicer to make dynamic.

Dashboard

Screenshot 2025-01-04 010719

Project Insights

  • Women are more likely to buy compared to men (~65%)
  • The states of Maharashtra, Karnataka and Uttar Pradesh are the top 3 product buyers.
  • The adult age group (30-49 years) is max Contributing (~50%) and buys the most products.
  • The maximum number of products customer orders from Amazon, Flipkart and Myntra Channels.
  • More than 90% of the products delivered

Final Conclusion:

To improve the sales of Vrind Store, a strategic marketing plan focused on woman aged 30-49 years Residing in Maharashtra, Karnataka and Uttar Pradesh should be implemented. This demographic Represents a key consumer segment, as they often make significant household and lifestyle Purchases. The approach should include targeted digital marketing campaigns and personalized Promotions to capture their attention.

About

I developed a comprehensive project in Excel, creating multiple dashboards and to analyze the data. This process involved several stages, including data preprocessing, data visualization.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published