To analyze pizza sales data and create an interactive dashboard that provides actionable business insights. The objective is to help decision-makers track sales performance, identify trends, and optimize business strategies.
Dataset Name: Pizza Sales Data
Source: Provided via Google Drive Access the dataset on Google Drive
What is the total revenue generated from pizza sales?
What is the average order value?
How many pizzas were sold in total?
What is the total number of orders?
How many pizzas are sold per order on average?
What are the daily and hourly order trends?
What is the sales distribution by pizza category and size?
Which are the top 5 best-selling pizzas?
Which are the bottom 5 worst-selling pizzas?
Revenue Trends: Clear identification of high and low sales periods based on day and time.
Category Performance: Top-performing pizza categories and sizes highlighted through charts.
Product Popularity: Best-selling pizzas identified for inventory and marketing focus.
Low Performers: Underperforming pizzas revealed for potential menu optimization.
Microsoft Excel:
Pivot Tables
Charts (Bar, Line, Pie, Funnel)
Power Query for database connection
SQL Server:
Database Management
T-SQL Scripts for Data Preparation and Analysis