📊 Superstore Sales Data Analysis

This project analyzes sales data from a superstore to uncover insights into sales performance, profitability, and customer trends. The analysis was performed using Python in Google Colab, using the Sample - Superstore.csv dataset.

🔍 Objective

To explore, analyze, and visualize sales data to provide meaningful business insights that can assist decision-makers in identifying:

• High-performing regions and categories
• Profit and sales trends over time
• Areas of improvement based on shipping mode, segment, and sub-categories

📁 Dataset

Name: Sample - Superstore.csv Source: Kaggle

Features include:

• Order ID, Order Date, Ship Date
• Customer and Segment Information
• Product Categories and Sub-Categories
• Sales, Quantity, Discount, Profit
• Region, State, and City

🛠️ Tools & Libraries Used

• Python (Google Colab)
• Pandas
• NumPy
• Matplotlib
• Seaborn
• Plotly (optional for interactive visuals)

📈 Key Analyses Performed

• Data Cleaning and Preprocessing
• Exploratory Data Analysis (EDA)
• Trend Analysis (Sales & Profit over Time)
• Regional Performance Visualization
• Customer Segmentation Insights
• Correlation

📊 Sample Visualizations

• Sales vs Profit by Category/Sub-category
• Monthly Sales Trends
• Regional Profit Distribution
• Top Performing Products

📝 How to Use

1. Clone the repository.
2. Open the Colab notebook
3. Upload the Sample - Superstore.csv file to the environment or link it from Google Drive.
4. Run the cells to explore and visualize the data.

📌 Results

Based on the analysis aligned with project objectives:

• Top-performing regions: The West and East regions consistently generated high sales and profits.
• Category insights: While Technology and Office Supplies were profitable, Furniture (especially Chairs and Tables) had high sales but low or negative profits.
• Segment performance: The Corporate and Consumer segments contributed the most revenue, while the Home Office segment underperformed.
• Shipping mode impact: Standard Class was the most used shipping mode but didn't always align with profit efficiency.
• Seasonality observed: Sales spiked toward the end of the year, indicating strong seasonal demand patterns.

These results support strategic decisions in inventory management, pricing optimization, and targeted marketing.

👩‍💻 Author

Syeda Zainab Kamal M.Sc. Statistics LinkedIn Profile (optional) Email (optional)