For the Maven Pizza Challenge, you’ll be playing the role of a BI Consultant hired by Plato's Pizza, a Greek-inspired pizza place in New Jersey. You've been hired to help the restaurant use data to improve operations, and just received the following note:
Welcome aboard, we're glad you're here to help!
Things are going OK here at Plato's, but there's room for improvement. We've been collecting transactional data for the past year, but really haven't been able to put it to good use. Hoping you can analyze the data and put together a report to help us find opportunities to drive more sales and work more efficiently.
Here are some questions that we'd like to be able to answer:
- What days and times do we tend to be busiest?
- How many pizzas are we making during peak periods?
- What are our best and worst selling pizzas?
- What's our average order value?
- How well are we utilizing our seating capacity? (we have 15 tables and 60 seats)
That's all I can think of for now, but if you have any other ideas I'd love to hear them – you're the expert!
Thanks in advance,
Mario Maven (Manager, Plato's Pizza)
For this challenge, your task is to build a single-page dashboard based on Mario's email to help him improve the restaurant's operations.
Publication submitted: https://www.linkedin.com/posts/edolivasan_maven-pizza-challenge-dashboard-activity-6992206623754625024-90Sg?utm_source=share&utm_medium=member_desktop
For more information about challenge: https://www.mavenanalytics.io/blog/maven-pizza-challenge