Objective To analyze sales performance and customer demand using SQL and derive actionable business insights from transactional data. Analysis Performed Total revenue and order volume analysis Top-selling pizzas by quantity and revenue Category-wise sales contribution Hourly and daily order trends Cumulative revenue analysis Top products per category using window functions Key SQL Concepts Used INNER JOINs GROUP BY & Aggregations Subqueries CTEs Window Functions (RANK, OVER) Date & Time functions Skills Demonstrated Advanced SQL querying Analytical thinking Business-focused data interpretation
-
Notifications
You must be signed in to change notification settings - Fork 0
End-to-end SQL project analyzing pizza sales data using joins, aggregations, subqueries, and window functions to derive business insights such as revenue trends, top-selling products, customer demand patterns, and operational performance.
amankashyap-hue/End-to-End-SQL-Sales-Analysis
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
End-to-end SQL project analyzing pizza sales data using joins, aggregations, subqueries, and window functions to derive business insights such as revenue trends, top-selling products, customer demand patterns, and operational performance.
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published