originalfemo / danny-ma-case-study-2-pizza-runner-

8 Week SQL Challenge - Case Study #2: Pizza Runner

Did you know that over 115 million kilograms of pizza is consumed daily worldwide??? (Well according to Wikipedia anyway…)

Danny was scrolling through his Instagram feed when something really caught his eye - “80s Retro Styling and Pizza Is The Future!”

Danny was sold on the idea, but he knew that pizza alone was not going to help him get seed funding to expand his new Pizza Empire - so he had one more genius idea to combine with it - he was going to Uberize it - and so Pizza Runner was launched!

Danny started by recruiting “runners” to deliver fresh pizza from Pizza Runner Headquarters (otherwise known as Danny’s house) and also maxed out his credit card to pay freelance developers to build a mobile app to accept orders from customers.

Aware of the importance of data collection to his business growth, Danny presented an ER diagram of his database but this still needs a bit of data cleaning and calculations to have a better understanding of his business.

This case study has LOTS of questions and are broken up by area of focus including: Pizza Metrics, Runner and Customer Experience, Ingredient Optimisation, Pricing and Ratings, and Bonus DML Challenges (DML = Data Manipulation Language).

This code contains answers to Pizza Metrics and Runner & Customer Experience. Al this was done only after some data cleaning has been carried out to ensure the data is suitable for proper EDA.