Skip to content

Vamsi9694/sql-retail-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

4 Commits
Β 
Β 

Repository files navigation

πŸ“Š Retail Sales Analysis using SQL

🎯 Objective

Analyze retail sales data to uncover trends, identify top-performing regions, and generate business insights using SQL.


πŸ“ Dataset

  • Superstore dataset
  • Contains sales, customer, region, and product information

πŸ› οΈ Tools Used

  • SQL (SQLite / MySQL)
  • Google Colab (for execution)
  • Excel (for initial data handling)

πŸ“Š Key Analysis Performed

  • Total sales by region
  • Sales by customer segment
  • Top customers by revenue
  • Profit vs Sales analysis
  • Monthly sales trends

πŸ” Key Insights

  • Central region generates the highest sales
  • Consumer segment drives most revenue
  • Some high-sales transactions are unprofitable
  • Sales show seasonal trends

πŸ“Œ Conclusion

This project demonstrates how SQL can be used to extract meaningful business insights from raw data and support decision-making.

About

SQL-based retail data analysis project using real-world dataset. Includes data cleaning, aggregation, and business insights using SQL queries.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors