Maven Pizza Challenge

canva.com

This challenge is sponsored by Maven.

The dataset contains 4 tables in CSV format:

Orders — the date and time of all 5,238 orders in the set

Order Details — the different pizza names and quantities ordered

Pizzas — the size, price, and type of each pizza

Pizza Types — details about the pizza types from the Pizzas table (ingredients, etc.)

Challenge Requirement:

I am to share a single-page dashboard to help Mario Maven, manager of Plato’s Pizza, improve restaurant operations.

External tools used:

Logo

PowerBi

Analyzing the pizza data

There are 32 types of pizza and 4 Pizza Categories.

Total of 50,000 pizzas were ordered

12,454 pizzas were ordered in the First Quarter

12,586 pizzas were ordered in the Second Quarter

12,450 pizzas were ordered in the Third Quarter

12,084 pizzas were ordered in the Fourth Quarter

Large pizzas were more costly than other pizzas sizes

Pizza size XL is the least most expensive pizza

The Chicken Deluxe pizza

Barbecue chicken pizza are the most ordered pizza

The Hawaiian pizza

The pepperoni pizza and The Thai chicken pizza are the most ordered pizza

Pizzas categorized as Classic are the most ordered pizzas

The Geek Pizzas are the most expensive pizzas costing $109.95

The most ordered pizzas by ingredients are;

Pepperonis, Mushrooms, Red onions, Red peppers and Bacons

My recommendations for Mario Maven, manager of Plato’s Pizza, to improve restaurant operations are:

  1. There should be discount sales for Large sized pizzas
  2. The pizza restaurant could improve on its pizza ingredients and menu
  3. Pizza are sold more during summer so the restaurant can improve on its pizza flavor and add exotic drinks along side the pizzas.

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Anuoluwapo Balogun

Anuoluwapo Balogun

55 Followers

I am a Data Analyst and I use medium as my dashboard portfolio to show case a full and well-detailed analytical summary of my dashboards.