Pizza sales analysis

Nazmul Islam Rakin

Data Scientist
Data Visualizer
Data Analyst
Microsoft Excel
SQL

Demo:

This project showcases an analysis of a pizza sales dataset using Excel and SQL, leveraging tools such as Power Query, PivotTables, and Excel’s data visualization features. The analysis focuses on key performance indicators (KPIs), trends, and sales insights across various dimensions, culminating in an interactive and dynamic dashboard.

Key Objectives:

Calculate important KPIs, including:

Total Revenue

Total Orders

Total Quantity Sold

Average Order Value

Average Pizza Quantity per Order

Analyze daily and hourly sales trends to identify peak business hours and high-revenue days.

Perform a sales analysis by pizza category and size to understand customer preferences.

Identify the Top 5 and Worst 5 pizzas by sales performance.

Build an interactive and dynamic dashboard for real-time insights and business monitoring.

Tools & Techniques Used

Excel: Power Query for data cleaning and transformation, PivotTables for analysis, and data visualization features for creating an interactive dashboard.

Power Query: To clean and standardize data formats, especially inconsistent date formats.

PivotTables: For quick aggregation and slicing of sales data to generate KPIs and sales insights.

Excel Charts: Used to create visualizations for trends, categories, and pizza performance.

SQL: Used to cross-validate the analysis

Partner With Nazmul Islam
View Services

More Projects by Nazmul Islam