Hello everyone 😁
I will be embarking on a 6 days challenge on a data analysis project titled “Exploratory Data analysis and visualization on a pizza Restaurant sales.
The dataset contains 500 rows, which was gotten in 4days(2015).
This pizza sales dataset makes up of 12 relevant variables:
1. Order-id: Unique identifier for each order placed by a table
2. Order details-id: Unique identifier for each pizza placed within each order (pizzas of the same type and size are kept in the same row, and the quantity increases)
3. Pizza-id: Unique key identifier that ties the pizza ordered to its details, like size and price
4. Quantity: Quantity ordered for each pizza of the same type and size
5. Order-date: Date the order was placed (entered into the system prior to cooking & serving)
6. Order-time: Time the order was placed (entered into the system prior to cooking & serving)
7. Unit-price: Price of the pizza in USD
8. Total-price: unit-price * quantity
9. Pizza-size: Size of the pizza (Small, Medium, Large, X Large, or XX Large)
10. Pizza-type: Unique key identifier that ties the pizza ordered to its details, like size and price
11. Pizza-ingredients: ingredients used in the pizza as shown in the menu (they all include Mozzarella Cheese, even -+-if not specified; and they all include Tomato Sauce, unless another sauce is specified)
12. Pizza-name: Name of the pizza as shown in the menu
THE MAIN OBJECTIVE OF THIS PROJECT IS:
• To determine the exploratory data analysis and the visualization of a pizza restaurant sales dataset.
The specific objectives are:
• To determine the overall sales trend over time.
• To determine the pizza category that generates the highest and lowest revenue for the restaurant.
• The determine the peak period for sales in the restaurant.
• To determine the particular pizza that is frequently ordered daily.
#6daysdatanalyticschallengewithharvoxx
#dataanalytics
#dashboard
#datascience
#artificialintelligence
#ai
#msexcel
#excel
#harvoxxtechhub
#10daysdataanalyticschallenge
#6daysdataanalyticschallenge
You were a natural Michael Lukianoff and congrats on the recent award.