Welcome to my Pizza Sales Dashboard project! This document serves as a guide to understanding the setup, data analysis, and visualization techniques used in this project.
For this project, I aimed to analyze pizza sales data obtained from Kaggle to gain insights into business performance. The goal was to calculate key performance indicators (KPIs) and visualize trends using Power BI.
Link to Dataset: https://www.kaggle.com/datasets/nextmillionaire/pizza-sales-dataset
To assess the business performance, I identified the following KPIs:
- Total Revenue: Sum of the total price of all pizza orders.
- Average Order Value: Average amount spent per order.
- Total Pizzas Sold: Sum of the quantities of all pizzas sold.
- Total Orders: Total number of orders placed.
- Average Pizzas Per Order: Average number of pizzas sold per order.
In addition to KPIs, I wanted to visualize various aspects of the pizza sales data. The following charts were identified for this purpose:
- Daily Trend for Total Orders: Bar chart displaying the daily trend of total orders over a specific time period.
- Monthly Trend for Total Orders: Line chart illustrating the hourly trend of total orders throughout the day.
- Percentage of Sales by Pizza Category: Pie chart showing the distribution of sales across different pizza categories.
-
Data Import and Database Setup:
- Imported data into MySQL for storage and analysis.
-
Data Analysis with MySQL:
- Performed various queries to extract relevant information for analysis.
-
Connect MySQL to Power BI:
- Connected MySQL database to Power BI to visualize the data.
-
Data Cleaning and KPI Building in Power BI:
- Conducted basic data cleaning to ensure data quality.
- Calculated key performance indicators (KPIs) using DAX formulas.
-
Chart Creation in Power BI:
- Created relevant and insightful charts to visualize the data as per the requirements stated.