This repository contains an Excel-based project focused on analyzing store sales data and presenting key insights through an interactive dashboard.
This project demonstrates the process of transforming raw store sales data into actionable intelligence using Microsoft Excel. The dashboard provides a clear and concise overview of key performance indicators (KPIs) and trends, allowing for data-driven decision-making.
The interactive dashboard includes visualizations for:
- Order vs. Sales: Comparing the number of orders placed with the total sales revenue generated.
- Sales by Gender: Analyzing the sales contribution from male and female customers.
- Order Status: Tracking the distribution of orders across different statuses (e.g., pending, shipped, delivered, cancelled).
- Top Sales States: Identifying the states with the highest sales performance.
- Sales by Age Group: Understanding the sales distribution across different customer age segments.
- Order Channels: Analyzing the sales volume generated through various order channels (e.g., online, in-store). Interactive Slicers: Implementing slicers to allow users to dynamically filter and explore the data based on different categories (e.g., product category, channel, month).
- Microsoft Excel: The primary tool used for data cleaning, formatting, PivotTable creation, visualization, and dashboard development.
Ahsan Sheeraz
Feel free to explore the project and provide any feedback or suggestions!