Retail Store Analysis 

This project involves a comprehensive analysis of retail store performance using Excel, focusing on key sales and customer insights for the year 2025. The data was processed and visualized through an interactive dashboard, enabling easy identification of trends and patterns.

Key aspects of the analysis include:

• Sales and Order Comparison: A single chart was used to compare overall sales and order volumes across different periods.
• Monthly Performance: Identified the month with the highest sales and orders, providing insights into seasonal trends.
• Customer Demographics: Analyzed purchase patterns based on gender, determining whether men or women contributed more to total sales.
• Order Status Breakdown: Categorized orders into different statuses (e.g., completed, pending, canceled) to track fulfillment efficiency.
• Top 10 Sales-Contributing States: Ranked the leading states driving sales, helping in regional sales strategy development.
• Age and Gender-Based Analysis: Examined the relationship between customer age and gender to uncover targeted marketing opportunities.
• Sales Channel Performance: Evaluated which sales channels (e.g., online, in-store, third-party platforms) generated the highest revenue.
• Best-Selling Category: Identified the most popular product categories, guiding inventory and promotional strategies.

The project showcases data-driven decision-making in retail by leveraging Excel for data visualization, trend identification, and actionable insights.