As a data analyst, I conducted an in-depth analysis of historical data from a pizza shop to identify factors contributing to a decline in revenue and areas for improvement. Through the examination of various key performance indicators (KPIs), I focused on seasonal variations, top-selling and bottom-selling pizzas, and compared attributes such as pricing, ingredients, size, and preparation methods between the bestsellers and worstsellers. This comprehensive analysis aims to provide actionable insights for the pizza shop, enabling better management of staff allocation during peak and off-peak seasons, as well as the strategic utilization of offers and promotions to enhance overall performance.