Skip to content

ayush6441/Pizza-sales-analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 

Repository files navigation

🍕 Pizza Sales Data Analysis Project

This project analyzes a pizza sales dataset using SQL. It showcases key business insights such as revenue trends, best-selling pizzas, and category performance.

📁 Files Included

  • data/pizza_sales.csv: Raw data file.
  • data/pizza_sales excel file.xlsx: Excel version used for dashboarding or analysis.
  • queries/pizza_sales_sql_queries.md: SQL queries used to extract insights.

🔍 Key Metrics Analyzed

  • Total Revenue
  • Average Order Value
  • Total Pizzas Sold
  • Order Trends (Daily/Hourly)
  • Category & Size-wise Sales Share
  • Best & Worst Selling Pizzas

📊 Tools Used

  • MySQL
  • Microsoft Excel

Note: This project is for learning and demonstration purposes.

About

This project explores a pizza restaurant’s sales data to uncover valuable business insights using SQL. It includes a variety of performance metrics and trend analyses, making it a great addition to a data analytics portfolio.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors