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.

Danny has prepared an entity relationship diagram of his database design, but requires further assistance to clean his data and apply some basic calculations so he can better direct his runners and optimise Pizza Runner’s operations.

The task and aim of this project is to provide Danny, the owner of Pizza Runner, with more insights into his business. And to help him optimize operations using the data he has provided.

Data Wrangling

Exploratory Data Analysis

Intermediate SQL

Data Manipulation

Follow this link to see the provided SQL code used to create the database schema, as well as the tables.

Look into

What caused restaurant cancellation? There were 2 cancellations, one initiated by the restaurant, and the other by the customer

Why is runner 4 not yet active? There are 4 runners, but only runners 1-3 have made any deliveries

What caused delay in the preparation and delivery of order number 8?, it had only 1 pizza, and a much higher preparation time than other orders containing just 1 pizza. How can this delay be prevented fom re-occuring?

Pizza Runner HQ needs to start with marketing and advertisements, especially with the introduction of the new Supreme pizza, it is perfect timing.

Take user ratings and feedback seriously, this is important for all businesses, especially early stage ones

To better maximize profits, Danny could look into his overall operations cost.

Are the current procurement methods as cost effective as they could be?

Are the pizza and delivery prices right? Taking note of what is leftover after paying runners

Overall, the Pizza Runner HQ seems to be doing fairly well for a new business. There are still a lot of areas to explore and look into from a business standpoint, so I hope I did a good enough job for Danny to call me back when he decides to take the next steps at the Pizza HQ. Till then, eat pizza

and stay safe!