Skip to content

shubhangipnawale/Pizza-sale-excel-project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

14 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

##πŸ•Pizza Sales Analysis Dashboard ##πŸ“Š Project Overview This project analyzes pizza sales data to understand customer purchasing behavior, sales performance, and product trends. The analysis helps identify top-selling pizzas, peak order times, and revenue contribution across different categories and sizes.

##πŸ›  Tools & Technologies Used -Microsoft Excel (Data Cleaning & Analysis)

##πŸ“ Files in this Repository -pizza_sales excel project.xlsx – Dataset and analysis -Dashboard Screenshots (if added)

##πŸ”Key Insights -Total revenue and total orders analysis -Best-selling and least-selling pizzas -Category-wise and size-wise sales performance -Peak order days and hours -Average order value and quantity analysis

##πŸ”„Data Preparation Process -Cleaned raw sales data -Removed duplicates and handled missing values -Created calculated columns and measures -Aggregated data for meaningful insights

##🎯 Project Objective To help business stakeholders understand sales trends, optimize product offerings, and improve overall revenue through data-driven insights.

##πŸ“Έ Dashboard Preview Pizza Sales Dashboard

##πŸ“šLearning Outcomes -Hands-on experience with sales data analysis -Improved Excel and Power BI dashboard skills -Understanding of business KPIs and performance metrics -Data storytelling using visual analytics

##πŸ‘©β€πŸ’» Author Shubhangi Nawale Aspiring Data Analyst | Excel | Power BI | SQL

Releases

No releases published

Packages

 
 
 

Contributors