Skip to content

chandanaamarendra/Sales_performance

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Sales-Performance

Overview

You can find a PDF of the Pizza Sales Report dashboard in the dashboard folder. This dashboard provides a comprehensive analysis of pizza sales data, including key metrics, trends, and performance indicators.

Key Metrics

  1. Total revenue: 817.86K
  2. Average Order Value: 38.31
  3. Total Orders: 21,350
  4. Total Pizzas Sold: 49,574
  5. Average Pizzas per Order: 2.32

Analysis

Best/Worst Sellers:

Top Sellers:

  1. The Thai Chicken Pizza contributes to maximum revenue.

Screenshot 2024-09-01 141043

  1. The Classic Deluxe Pizza contributes to maximum total quantities and orders.

Screenshot 2024-09-01 141325

Bottom Sellers:

The Brie Carre Pizza contributes to minimum revenue, total quantities, and orders.

Screenshot 2024-09-01 142353

Sales Performance:

Revenue:

The Thai Chicken Pizza is the top seller, while the Brie Carre Pizza is the least.

Quantity:

The Classic Deluxe Pizza is the top seller, while the Spinach Pizza is the least.

Total Orders:

The Classic Deluxe Pizza is the top seller, while the Brie Carre Pizza is the least.

Insights

Peak Sales:

Orders are highest on weekends (Friday/Saturday) and evenings.

Screenshot 2024-09-01 142615

Popular Months:

July and January have the highest number of orders.

Screenshot 2024-09-01 142812

Top-Selling Categories:

Classic category contributes the most to sales and orders.

Screenshot 2024-09-01 142946

Popular Sizes:

Large size pizza contributes significantly to sales.

Screenshot 2024-09-01 143151

Usage

This README provides information about the Pizza Sales Report dashboard. You can find a PDF of the dashboard in the dashboard folder.

Key Features:

Overview of key metrics:

Total revenue, average order value, total orders, etc.

Visualizations:

Bar charts, pie charts, and other interactive elements.

Filters:

Ability to filter data by date range, pizza category, and size.

How to Use:

  1. Open the PDF and review the dashboard's contents.
  2. Examine the various visualizations and metrics.
  3. Utilize the filters (if applicable) to explore different data perspectives.
  4. Analyze the insights to identify trends, opportunities, and areas for improvement.

Data Sources

Sales Data:

A CSV file containing order details, pizza information, and pricing.

column names :

pizza id, order id, pizza name id, quantity, order date, order time, unit price, total price, pizza size, pizza category, pizza ingrediants, pizza name

Technologies

Power BI
SQL(for data analysis)

License

This project is licensed under the MIT License - see the LICENSE file for details.

About

No description, website, or topics provided.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors