This project involves the analysis of a retail store's annual sales data and the creation of an interactive Excel dashboard. The dashboard was designed to provide valuable insights into sales performance, trends, and patterns, enabling the store owner to make informed business decisions.

• Data Cleaning & Processing:
  • Handled missing, duplicate, and inconsistent data for accuracy.
• Data Analysis:
  • Extracted key metrics such as total sales, category-wise performance, and monthly trends.
• Visualization:
  • Created interactive charts, including Pie Charts, Column Charts, and Bar Charts, using Pivot Tables for better understanding.
• Dashboard:
  • Designed a user-friendly dashboard that consolidates all key metrics and charts in a single view.

• Microsoft Excel
  • Pivot Tables
  • Advanced Excel functions
  • Data Visualization (Charts)
  • Conditional Formatting
• Data Cleaning:
  • Removing duplicates
  • Handling missing values
• Data Analysis Techniques:
  • Trend Analysis
  • Category Performance Comparison

1. Provide a clear understanding of yearly sales performance.
2. Identify trends and patterns in sales data.
3. Deliver a dashboard that enables quick and informed decision-making.

1. Open the Excel file in Microsoft Excel (2016 or later recommended).
2. Navigate to the dashboard tab to view the interactive charts and metrics.
3. Use slicers to filter data by specific categories, months, or other criteria.

• Top-performing months: [e.g., January and December had the highest sales].
• Category analysis: [e.g., Electronics contributed 40% of total sales].
• Seasonal trends: [e.g., Significant sales spike during holiday seasons].

/Project Folder
├── Annual_Sales_Dashboard.xlsx   # Main Excel file with the dashboard
├── README.md                     # Project documentation
└── Images/                       # Screenshots of the dashboard

• Automate data updates with macros or Power Query.
• Add advanced visualizations using Power BI or Tableau.
• Include predictive analytics for future sales trends.

Feel free to reach out for feedback, suggestions, or collaboration:

• Email: [email protected]
• LinkedIn: https://www.linkedin.com/in/abhishek-rathore-7734771a2/

Thank you for checking out my project! Your feedback is highly appreciated.