Pizza Sales Dashboard

Dashboard Link : https://public.tableau.com/app/profile/maxim.yurchak/viz/PizzaSalesReport_17314966904410/Home?publish=yes

Overview

This project showcases a Pizza Sales Dashboard created using Tableau to visualize and analyze key metrics and trends for a pizza sales dataset. The dashboard highlights important KPIs, such as total revenue, total pizzas sold, and order trends, to aid in data-driven decision-making.

Key Features

• KPIs:
  • Total Revenue
  • Average Order Value
  • Total Pizzas Sold
  • Total Orders
  • Average Pizzas Per Order
• Charts:
  • Hourly trend of pizzas sold
  • Weekly trend of orders
  • Sales breakdown by pizza category and size
  • Top and bottom pizzas by revenue and quantity
• Interactive Filters:
  • Ability to filter by date, pizza category, and size for granular insights.

Data Sources

• Pizza Sales Dataset:

  • File: Pizza.csv
  • Contains details about orders, including order time, pizza size, category, revenue, and quantity.

• SQL Queries:

  • Document: PIZZA SALES SQL QUERIES.docx
  • Contains MySQL queries used to generate key metrics and trends for visualization in Tableau.

Files Included

1. Pizza Sales Report dashboard.twbx: Tableau Packaged Workbook containing the dashboard.
2. Pizza.csv: CSV file with the raw data used for analysis.
3. PIZZA SALES SQL QUERIES.docx: Document with SQL queries used for data preparation.

How to Use

1. Open the Pizza Sales Report dashboard.twbx file in Tableau Desktop or Tableau Public to explore the dashboard.
2. Use filters and parameters to interact with the data and uncover insights.
3. The dataset Pizza.csv and SQL queries are included for further analysis or modification.

Insights

• Hourly Trends: Peak pizza sales occur during specific times of the day.
• Category Breakdown: Identifies the best-selling pizza categories and sizes.
• Top Performers: Lists the pizzas that contribute the most to revenue and quantity.
• Customer Behavior: Provides insights into average order value and pizzas per order.

Technologies Used

• Tableau: For data visualization and dashboard creation.
• MySQL: For data aggregation and transformation.

Repository Structure

Pizza-Sales-Dashboard/ ├── Pizza Sales Report dashboard.twbx # Tableau dashboard ├── Pizza.csv # Pizza sales data ├── PIZZA SALES SQL QUERIES.docx # SQL queries for analysis └── README.md # Project documentation

About

This project was designed to provide actionable insights into pizza sales for businesses looking to optimize their operations and enhance decision-making.

---