Supermarket sales Analysis

This project features a comprehensive Excel Data Analysis Dashboard designed to monitor and analyze supermarket sales performance. By transforming raw transactional data into actionable insights, the dashboard helps in understanding customer behavior, product performance, and financial health.

Key Features & Insights

Sales Performance: Tracking Total Sales ($314.1K) and Total Invoices (971) to measure market growth.

Customer Segmentation: Analyzing sales distribution between Members vs. Normal customers, showing that Members contribute significantly more to the revenue.

Trend Analysis: A monthly breakdown (January – March) illustrating sales fluctuations and peak performance periods.

Operational Insights: Comparing Weekday vs. Weekend sales to optimize staffing and inventory levels.

Profitability & Satisfaction: Monitoring profit categories and average customer satisfaction ratings (Avg: 7/10) to ensure service quality.

Technical Skills Applied

Data Modeling: Established relationships between Fact and Dimension tables (Location, Product, Customer, and Date).

Advanced Excel: Used Pivot Tables, Power Pivot, and complex formulas for data aggregation.

Data Visualization: Designed a clean, user-friendly UI with interactive Slicers for dynamic filtering by Customer Type, Month, and Satisfaction level.