Skip to content

SQL Data Analysis project using Superstore dataset. Performed aggregations, grouping, filtering, and business insights generation using MySQL on DB-Fiddle.

Notifications You must be signed in to change notification settings

Ramiishha/Superstore-SQL-Analysis

Repository files navigation

Task 3: SQL Data Analysis

Tool Used:

DB-Fiddle (MySQL 5.7)

Dataset:

Superstore Dataset

DB Fiddle Link:

https://www.db-fiddle.com/f/aeshZYGostuQSQRsXComa8/1


Queries Performed:

  1. Total Sales
  2. Total Profit
  3. Sales by Region
  4. Profit by Category
  5. Top Customer by Sales
  6. Monthly Sales Trend

Key Insights:

  • Total Sales and Profit calculated
  • South region performed well
  • Technology category generated highest profit
  • Identified top customer
  • Monthly sales trend observed

Screenshots:

All query outputs are attached.

About

SQL Data Analysis project using Superstore dataset. Performed aggregations, grouping, filtering, and business insights generation using MySQL on DB-Fiddle.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages