Skip to content

ritikaa13/sales-sql-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

Sales SQL Analysis

Project Overview

This project analyzes sales data using SQL on the Superstore dataset. The objective is to extract meaningful insights and understand business performance.

Tools Used

  • MySQL
  • SQL

Dataset

  • Superstore dataset (CSV file)

Key Analysis

  • Total Sales and Profit
  • Total Orders
  • Sales by Region and Category
  • Top Customers and Sub-Categories
  • Monthly Sales Trends
  • Loss-making Sub-Categories
  • Profit Ratio

Insights

  • West region contributes the highest sales
  • Technology category generates maximum profit
  • Some sub-categories are loss-making
  • Top customers contribute significantly to total revenue
  • Sales vary across months indicating seasonal trends

Conclusion

This project demonstrates SQL skills for real-world business analysis and decision-making.

About

Sales Data Analysis using SQL (Superstore Dataset)

Topics

Resources

Stars

Watchers

Forks

Contributors