piza sales dashboard

In this project, I worked on analyzing pizza sales data using Excel. My goal was to understand the sales performance and turn raw data into clear and useful insights.

First, I cleaned and organized the dataset to make sure everything was accurate and ready for analysis. Then, I created Pivot Tables to calculate key metrics like total revenue, total quantity sold, and average order value.

I analyzed sales by category, pizza size, hour of the day, and day of the week to identify trends and peak times. After that, I designed an interactive dashboard using slicers so the user can easily filter by month and category.

This project helped me improve my skills in data cleaning, data analysis, and dashboard creation using Excel.