Retail Sales SQL Analysis

Overview

This project uses SQL queries to analyze the Superstore dataset.
The goal is to answer business questions like:

• Total sales and profit
• Best performing products and customers
• Sales trends over time
• Shipping performance

All queries are written in SQLite, demonstrating real-world data analysis skills.

Dataset

• Superstore CSV converted to SQLite database (superstore.db)
• Columns: Order Date, Ship Date, Customer Name, Segment, Region, Product Name, Category, Sales, Profit, Discount, Ship Mode, etc.

Key SQL Analysis

1. Sales Overview

   • Total Sales & Total Profit

2. Sales by Region & Category

   • Grouped totals per region/category

3. Top Customers & Products

   • Top 10 based on total sales

4. Profit vs Discount

   • Orders with losses
   • High discount analysis

5. Time-based Analysis

   • Monthly sales & profit trends

6. Shipping Performance

   • Average shipping days by Ship Mode

7. Combined Insights

   • Profit by Region and Segment

How to Use

1. Open superstore.db in SQLite or DB Browser for SQLite
2. Run queries from analysis.sql
3. Explore trends and insights

Skills Demonstrated

• SELECT, SUM, AVG, COUNT
• GROUP BY, ORDER BY
• Filtering with WHERE
• Combining conditions
• Business insights extraction