This project presents a visual analysis of sales data from a Pan Pizza shop using Power BI and Python. The aim is to identify key trends, insights, and performance indicators that can assist in decision-making.
Objectives of the Project
- Understand customer behavior and preferences.
- Analyze which pizzas are best-sellers by size and type.
- Visualize peak hours/days for pizza sales.
- Summarize overall business performance via an interactive dashboard.
Dataset
- File:
Pan Pizza details.xlsx - Contents:
- Order ID
- Order date and time
- Pizza size
- Pizza type
- Quantity sold
- Total price
Tools & Technologies Used
- Power BI – For data visualizations and dashboards
- Excel – Excel – Used for initial raw data inspection and basic structuring
- Python (Jupyter Notebook) – Used for further data cleaning, preprocessing, and visualizations
Visualizations & Insights
Power BI Dashboard:
The Power BI dashboard provides the following insights:
- 🔸 Top-selling pizza types and sizes
- 🔸 Daily and monthly sales patterns
- 🔸 Sales revenue trends
- 🔸 Customer order frequency and peak demand times
Visualizations done with Colab:
