Tiêu đề MS Case Study - FamousFoods.pdf ✅

Background © 2025 ProcDNA 2 FamousFoods is a rapidly expanding cloud kitchen brand operating in three major Indian cities — Pune, Delhi, and Bangalore. With a purely online ordering model and multiple cuisine offerings, the brand caters to a wide range of customer preferences across urban markets. As the company scales, it faces challenges in maintaining consistent service quality, understanding customer behavior, and optimizing operational efficiency across locations. To support its next phase of growth, FamousFoods has partnered with our analytics firm to extract insights from its growing volume of data. The business has outlined key objectives for this engagement: • Identify patterns in customer behavior to drive loyalty. • Understand cancellations related to pricing. • Compare performance across cities. • Surface high-value customer segments. • Provide data-driven recommendations. The company has shared structured datasets including customer profiles, detailed order histories, sales transactions, and cancellation logs. These datasets contain valuable information about customer demographics, order preferences, delivery performance, pricing sensitivity, and more. You'll be expected to apply SQL and Python for data exploration and modeling and combine analytical rigor with business insight to shape strategic decisions.

Questions © 2025 ProcDNA 4 Write a SQL or Python code to attempt the following – • Question 1: Explain the ER diagram representing the relationships between these datasets. • Question 2: There are some inconsistencies in the data. What quality checks would you implement to ensure the datasets are clean, consistent, and analytics-ready? Write SQL or Python code to find data inconsistencies. • Question 3: Which day of the week brings in the highest sales across all outlets, and is that pattern the same in each city? • Question 4: Find the count of customers who have placed a successful order from all the three outlets. Please refer to this file for a detailed guide on connecting to the platform and data sources, along with the steps to submit your solutions: Guide – DataLab