This Excel Dashboard provides a comprehensive analysis of Vrinda Store's sales and order data. The dashboard encompasses various visualizations, including graphs depicting the correlation between orders and sales, top 5 sales statistics, age vs gender distribution of orders, order status overview, and a sales comparison between men and women. The inclusion of slicers enhances user interactivity, allowing for a more personalized exploration of the data.
- Order vs Sales Graph: Visual representation of the relationship between orders and sales.
- Top 5 Sales Statistics: Highlighting key statistics related to the top-performing sales.
- Age vs Gender Orders: Analyzing the distribution of orders based on age and gender.
- Order Status Overview: A breakdown of orders based on their status.
- Sales Comparison - Men vs Women: Comparative analysis of sales between different genders.
- Slicers for Enhanced Interactivity: Utilize slicers to customize and filter data according to specific criteria.
Prior to visualization, the dataset underwent thorough cleaning to ensure accurate and reliable insights. This included addressing missing values, standardizing formats, and enhancing data quality.
Explore this dashboard to gain valuable insights into Vrinda Store's sales trends, customer demographics, and order statuses. The interactive features provided by slicers allow for a tailored exploration of the data, empowering users to extract meaningful information.
- Open the Excel file to access the dashboard.
- Utilize the slicers to filter data based on specific parameters of interest.
- Analyze the visualizations to understand sales patterns, top-performing categories, and customer demographics.
If you are Data Enthusiast then try to build your Dashboard from the raw data posted in this project files!