A fictitious dataset with 1 fact table and 3 dimension tables: they include date and time of each order and the pizzas served, additional details on the type, size, quantity, price and ingredients. 4 files: orders.csv, order_details.csv, pizzas.csv and pizza_types.csv
-
How many customers do we have each day? Are there any peak hours?
-
How many pizzas are typically in an order? Do we have any bestsellers?
-
How much money did we make this year? Can we indentify any seasonality in the sales?
-
Are there any pizzas we should take of the menu, or any promotions we could leverage?