__STYLES__
Introduction
One year’s worth of transactional data (including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients) for Plato’s Pizza. The objective of the analysis is to improve operational efficiency and increase revenue.
Business needs.
Process.
Data cleaning and normalization using Power Query.
Data Modelling.
Data exploration using measures and various visuals.
Analysis
To determine seating capacity, some assumptions were made based on the number of orders received in an hour, and an order being equal to an occupied table such that whenever orders exceeded 15 (number of tables) in an hour, we were at capacity.
Recommendations: