📊 Retail Sales Analysis Using SQL

📊 Project Summary:

📊 US Superstore SQL Analysis

🎯 Goal: Identify sales trends, profitability issues, and customer behavior

🛠 Tools: SQL (MySQL)

📌 Key Insights:

• West region is top-performing (~713K sales)
• Technology is the most profitable category
• A small group of customers drives a large share of revenue
• Some high-sales products are actually loss-making due to discounts

🔍 Project Overview

This project analyzes the US Superstore dataset using SQL to uncover key insights related to sales performance, profitability, and customer behavior. The goal is to support data-driven decision-making by identifying trends, risks, and growth opportunities.

📁 Project Structure

• data/ → Raw dataset used for analysis
• queries/ → SQL queries for each business question
• images/ → Visual outputs and supporting screenshots
• README.md → Project documentation

🎯 Objectives

• Analyze overall sales and profit performance
• Identify top-performing regions and product categories
• Detect low-profit or loss-making products
• Understand customer purchasing behavior
• Provide actionable business recommendations

📂 Dataset

The dataset contains transactional sales data including:

• Orders
• Customers
• Products
• Sales
• Profit
• Discounts

🛠️ Tools Used

• SQL (MYSQL)

❓ Business Questions

• Which regions generate the highest revenue?
• Which products are the most profitable?
• Who are the top customers by sales?
• How do sales and profit change over time?

🧠 Key SQL Example

SELECT Region, SUM(Sales) AS total_sales
FROM superstore
GROUP BY Region
ORDER BY total_sales DESC;

This query was used to identify the top-performing region based on total sales.

📈 Key Insights

• The West region generates the highest total sales with approximately 713,471 in revenue.
• The Technology category is the most profitable, contributing around 145,387 in total profit.
• A small group of customers drives a significant portion of revenue: Sean Miller -> 25,043 in total sales Tamara Chand -> 19,018 in total sales
• Certain products generate high sales but result in losses due to high costs or discounts: Cubify CubeX 3D Printer -> 11,099 sales with -8,880 profit Lexmark MX611dhe Printer -> 16,830 sales with -4,590 profit

💡 Business Recommendations

• Focus marketing efforts on the West region to maximize revenue growth.
• Reduce excessive discounting on low-margin or loss-making products.
• Strengthen relationships with top customers through retention and upselling strategies.
• Reevaluate pricing strategies to improve overall profitability.

📈 Project Impact

This analysis highlights key areas where the business can improve profitability and optimize its strategy. By addressing discount inefficiencies and focusing on high-performing regions and customers, the company can make more informed, data-driven decisions. These insights can help the business reduce profit leakage, optimize pricing strategies, and focus on high-value customers and regions.

🚀 Conclusion

This project demonstrates the use of SQL for real-world business analysis, transforming raw data into actionable insights that support strategic decision-making.