Plato Restaurant 2015 Pizza Sales Analysis

Dismiss

Plato’s Pizza

.pptx

Saved to Drive

Slideshow

Share

File

Edit

View

Help

View only

1PLATO’SPIZZASALESREPORT(2015)2INTRODUCTIONThispresentationisananalysisofthetransactionaldatacollectedoverthepastyearbyPLATORESTAURANT.ThegoalofthispowerBiprojectistouncoveractionableinsightsandrecommendationsthatcanhelpimprovesalesandenhanceoverallefficiencyoftheRestaurant.3PROBLEMSTATEMENTThispizzasalesReportprovidesacomprehensiveanalysisofpizzarestaurantsalesin2015.Thereportaimstoassessperformance,salestrends,forcastingandtotalrevenuemadefrompizzasales.Byanalyzingthekeyfactorswhichincludeorder_id,orderquantities,ordertime,date,pizzatypes,pizzacategory,priceandoverallsales.Theseinsightswillhelpinstrategicdecision–makingwhilethereportservesasavaluabletooltoidentifystrengths,addresschallengesandenhancecustomersatisfaction.4WORKFLOWSTRUCTUREDatacollectionDatacleaningAnalysisandinsightsDatavisualizationRecommendationandConclusion5CLEANEDDATA6ANALYSISANDINSIGHTSTotalRevenue;1182mTotalPizzasold;50kTotalNoOfOrder;21kAverageOrderValue;32OrdesarehighduringtheweekendsFriday/Saturdaywithin11am-4pm.TherearemaximumordersfromthemonthofjulytoDecember.Topsellingpizzasare;TheClassicDeluxePizzaTheBarbecueChickenPizzaTheHawaiianPizzaThePepperoniPizzaTheThaiChickenPizzaTheCalifoniaChickenPizzaBottomSellingPizzaTheSoppressataPizzaTheSpinachPestoPizzaTheSpinachSupremePizzaTheCalabresePizzaTheMediterianPizzaTheBrieCarrePizzaLargeSizePizzacontributestomaximumsales7VISUALIZATION8RECOMMENDATIONS•Promotethebest-sellingpizzasthroughtargetedmarketingcampaigns;combodealsorlimited-timeofferstoboostsalesfurther.•Evaluatetherecipesandpricingofthebottom-sellingpizzas.Ifimprovementisnotfeasible,considerphasingthemouttostreamlinethemenu.•Increaseaverageordervaluebyintroducingupsellingstrategysuchasmealbundles,add-ons(drinksorsides)anddiscountsforlargerorders.•Introducetimelypromotionssuchasholiday-themedpizzasorspecialdiscountsduringslowermonths(january-june)tomaintainconsistentrevenue.•Implementafeedbackmechanismtounderstandcustomerpreferencesbetterandaddresspainpointsinreal-time.•Adjuststaffschedulestoalignwiththeidentifiedbusiestdays&timestoimprovecustomerserviceandreducewaittimes.9CONCLUSIONTheanalysishasprovidedvaluableinsightsintooperationalpatternsandcustomerbehavior;byidentifyingpeaktimes,topperformingproductsandseasonaltrends,data-drivendecisionstooptimizestaffing,streamlinethemenuanddesigntargetedpromotionscanbemadethroughtheseactionablestrategiestoenhanceefficiency,improvesalesandcustomersatisfactioninordertomaintainacompetitiveedgeandachievesustainablegrowth.10THANKYOU!FORYOURTIME.