This project features a comprehensive Excel dashboard designed to provide an insightful overview of the Vrinda Store Sales performance. It is organized to display data interactively across multiple dimensions.
The dashboard offers a clear breakdown of performance across various product categories. Users can analyze key metrics such as sales, profits, and quantities sold for each category.
Data is organized to showcase trends over multiple months, enabling a better understanding of how the store's performance has evolved. It provides a month-by-month comparison to spot growth patterns and seasonal variations.
Gender wise pie chart has been created to know the trend of male and women customers.
Age wise group analysis has been done showing which age group men and women has done shopping in what trend.
Market-wise segmentation allows users to explore performance across different regions. Insights include which markets are the most profitable and which ones may need attention.
The dashboard is equipped with intuitive filters, such as drop-down menus or slicers, to enable dynamic data visualization. Users can easily click on filters to focus on specific categories, years, or markets for a tailored view. Key Metrics and Visualizations
The dashboard uses a combination of charts (like bar charts, line graphs, and pie charts) and tables to visualize data effectively. It highlights essential KPIs such as total sales, profit margins, and top-performing categories or regions. With this user-friendly dashboard, decision-makers can quickly extract valuable insights, identify trends, and drive informed strategies for the Vrinda store.