📊 Annual Sales Report 2022 – Data Analysis Project

This project focuses on analyzing the Annual Sales Report of 2022 using Microsoft Excel. It demonstrates the complete data analysis workflow, from raw data cleaning to creating insightful visualizations and dashboards.

---

🔧 Steps Performed

• Data Cleaning (handling missing values, removing duplicates, formatting)
• Data Preprocessing
• Data Analysis
• Pivot Table Creation
• Dashboard & Chart Visualization

---

📈 Key Insights

• Identified monthly sales trends and seasonality
• Determined top-performing products and categories
• Analyzed regional sales performance
• Evaluated customer purchasing behavior

---

🛠 Tools Used

• Microsoft Excel
  • Pivot Tables
  • Charts & Graphs
  • Data Cleaning Functions

---

📸 Screenshots

Project screenshots are available in the screenshots folder:

• 1.png – Dashboard Overview

  

• 2.png – Sales Analysis Charts

  

---

📁 Project Structure

├── Annual_Sales_Report.xlsx   
├── screenshots/   
│ ├── 1.jpg   
│ └── 2.jpg  
└── README.md

---

🚀 Conclusion

This project highlights how raw sales data can be transformed into meaningful insights using Excel. It showcases essential data analysis skills such as cleaning, preprocessing, and visualization, which are crucial for data-driven decision-making.

---

👨‍💻 Author

Mayank Raj