Pizza Sales Analysis

Project Overview

This project analyzes a Pizza Sales Dataset using SQL to extract key business insights and visualize them in an interactive Power BI dashboard. The objective is to identify sales performance trends, customer ordering behavior, and top-performing products to support business decision-making

Objectives

• Calculate key business KPIs like total revenue, average order value, and total pizzas sold.
• Identify busiest days and months to optimize staffing and inventory.
• Analyze sales performance by pizza category and size.
• Determine top and bottom-selling pizzas by revenue, quantity, and orders.
• Build a Power BI dashboard for interactive visualization of insights.

Tools & Technologies

• SQL – Data cleaning, querying, and analysis.
• PostgreSQL – Database management system used.
• Power BI – Interactive dashboard creation.
• Excel – For additional validation and formatting.

Key SQL Analysis Performed

KPIs Requirement

Important Insights

Power BI Dashboard Insights

The dashboard contains:

• KPI Cards: Total Revenue, Avg Order Value, Total Pizzas Sold, Total Orders, Avg Pizzas per Order.
• Trends: Daily & Monthly order trends.
• Pie Charts: Sales % by Category & Size.
• Bar Charts: Top & Bottom selling pizzas.
• Filters: By pizza category and date range.

Key Insights

• Revenue Generated: $817.86K
• Busiest Days: Friday and Saturday evenings.
• Peak Months: July and January.
• Top Performing Category: Classic pizzas.
• Most Popular Size: Large pizzas (45.89% of sales).
• Top Seller by Revenue: Thai Chicken Pizza ($43K).
• Worst Seller by Revenue: Brie Carre Pizza ($12K).

Dashboard

Contact: Email: [mdsadique752@gmail.com] Mob. No : [7277856540]