STORE SALES ANALYS

Super_Store_Sales_Analysis

? Project Overview

Super Store Sales Analysis is a data analysis project built entirely using Microsoft Excel to explore sales performance, customer behavior, and profitability trends.

This project focuses on transforming raw retail data into a structured analytical model and building a fully interactive dashboard for business decision-making.

The final result is a dynamic Excel dashboard that allows users to analyze sales metrics across multiple dimensions such as region, category, segment, and time.

? Dataset Description

The dataset contains transactional retail data including:

Order Date

Customer Segment

Region

Product Category & Sub-Category

Sales

Quantity

Profit

Discount

The data simulates a real-world retail environment and supports multi-dimensional performance analysis.

?️ Tools & Techniques Used

Microsoft Excel

Data Cleaning & Preparation

Pivot Tables

Pivot Charts

Slicers & Timeline Filters

KPI Calculations

Dashboard Design & Layout Optimization

? Project Workflow

1️⃣ Data Cleaning & Preparation

Removed duplicate and inconsistent records

Standardized formatting (dates, currency, text fields)

Created calculated columns (Profit Margin, Sales per Order, etc.)

Structured the dataset for efficient Pivot Table analysis

2️⃣ Data Analysis with Pivot Tables

Built analytical views to evaluate:

Sales by Region

Profit by Category & Sub-Category

Monthly & Yearly Sales Trends

Customer Segment Performance

Discount Impact on Profit

3️⃣ KPI & Metrics Development

Developed key business metrics such as:

Total Sales

Total Profit

Profit Margin (%)

Total Orders

Average Order Value

Year-over-Year Growth (placeholder example)

4️⃣ Dashboard Design

Created interactive slicers (Region, Segment, Category, Year)

Linked multiple Pivot Charts to filters

Designed a clean and professional layout

Highlighted KPIs at the top for quick insights