Skip to content

These dashboards collectively provide a detailed analysis of sales performance, customer preferences, and product-level insights. They enable decision-makers to identify top-performing products, optimize offerings, and adjust strategies to boost revenue and efficiency.

License

Notifications You must be signed in to change notification settings

abda11ah1brahem/Pizza-Sales-Report

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

"Home" Page

This dashboard provides a comprehensive overview of Pizza Sales Performance. Key insights and KPIs presented are: Total Revenue: $817.86K, reflecting overall sales performance. Total Orders: 21,350 total orders made within the reporting period. Average Order Value: $38.31, indicating the average spending per order. Average Pizzas Per Order: 2.32, highlighting the number of pizzas purchased per transaction. Total Pizzas Sold: 49,574 pizzas. The dashboard also shows: Top 5 and Bottom 5 Pizzas by Revenue, Quantity, and Total Orders, providing insights into the best and worst-performing pizzas. This data helps identify customer preferences and underperforming products for further analysis.

"Best & Worst Sellers" Page

This dashboard focuses on Sales Trends and Performance Metrics for better decision-making. Key insights include: Monthly Trend for Total Orders : Displays the fluctuation of orders across months, highlighting peak months (July and May). Daily Trend for Total Orders : Shows which days of the week see the highest sales, with Friday and Thursday leading. Sales by Category : Classic and Supreme pizzas dominate sales, accounting for significant market share. Sales by Size : Large (45.9%) and Medium (30.5%) pizzas are the most popular sizes. Total Revenue Per Category : Classic pizzas generate the highest revenue at $220.05K, followed by Supreme at $208.19K.

Purpose and Insights :

These dashboards collectively provide a detailed analysis of sales performance, customer preferences, and product-level insights. They enable decision-makers to identify top-performing products, optimize offerings, and adjust strategies to boost revenue and efficiency.

View an interactive dashboard in my portfolio : https://mavenanalytics.io/project/23282

Dashboards :

1- Home Page : Home (1) 2- Best & Worst Sellers Page : Best   Worst Sellers (2)

SQL Queries :

1- query ( 1 ) 2- query ( 2 ) 3- query ( 3 ) 4- query ( 4 )

About

These dashboards collectively provide a detailed analysis of sales performance, customer preferences, and product-level insights. They enable decision-makers to identify top-performing products, optimize offerings, and adjust strategies to boost revenue and efficiency.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published