Authors: K.Ravindhar, P.KamalaKar, Dr.Diana Moses
Abstract: This analysis examines a restaurant chain sales dataset covering transaction recorded across November and December 2022, spanning five major European cities — London, Lisbon, Madrid, Berlin, and Paris. The dataset capture nine key attributes including Order ID, Date, Product, Price, Quantity, Purchase Type, Payment Method, Manager, and City, forming a structured foundation for evaluating multi-dimensional sales performance. Burger emerge as the highest revenue-generating product, followed by Fries and Chicken Sandwiche, while Sides & Other contributes the least to overall revenue. Geographically, Lisbon leads in both total revenue and quantity sold, closely followed by London, whereas Berlin and Paris record comparatively lower performance. Purchase behavior analysis reveals that Online transaction are the most frequently used channel, followed by Instore and Drive thru. In terms of payment preferences, Credit Card dominates as the most widely adopted method, ahead of Cash and Gift Card usage. These finding highlight key revenue regional performance disparities, and customer purchasing preferences, offering a data-driven foundation for improving inventory planning, targeted marketing strategies, and overall operational decision-making.
