Data analyst||Business analyst ||Data cleaning and visualization||SQL||PowerBi||Tableau ||Python||Driving business success and growth
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
Data analyst||Business analyst ||Data cleaning and visualization||SQL||PowerBi||Tableau ||Python||Driving business success and growth
1yThank you 😊