Pizza Database SQL Project

### **Pizza Sales Data Analysis – SQL Portfolio Project**

This project involves analyzing a **pizza sales database** using **SQL** to extract key business insights. The queries focus on revenue tracking, sales performance, and customer ordering behavior.

### **Key Analyses & Insights:**

**Total Revenue Calculation** – Aggregates total sales revenue.

**Daily Revenue Tracking** – Analyzes revenue trends over time.

**Average Order Value (AOV)** – Determines the average customer spend per order.

**Total Pizzas Sold** – Computes the total number of pizzas purchased.

**Total Orders Count** – Identifies the number of unique customer orders.

**Average Pizzas per Order** – Measures customer purchasing behavior.

**Most Ordered Pizza Category** – Finds the most popular pizza category.

### **Business Impact:**

**Revenue Optimization** – Helps track sales growth and profitability.

**Inventory Management** – Identifies top-selling pizza categories to optimize stock levels.

**Customer Insights** – Understands purchasing behavior for better marketing strategies.

This SQL-based project provides **actionable business intelligence**, supporting data-driven decision-making for restaurant and food service businesses.