A data project to analyse and visualise business performance to allow informed operational decision making. The aim of this project was to further enhance skills working with data utilising SQL, Python, and visualisation tools.
- Generating Sales Data: Creating initial data for a restaurant menu, then generating realistic (dummy) sales data for a restaurant chain with Python scripts.
- Preparing the Data for a Data Warehouse: Data manipulation in Python.
- Data Staging: Importing data into a PostgreSQL data base and staging it to create final dimension and fact tables. Adding tables to data warehouse and adding table constraints.
- Visualisations in Tableau Public: Importing data into Tableau, creating reports and dashboards to allow tracking organisation's and restaurant's performance on annual and monthly basis.
Try both of the dashboards through this link.
Allows users to track the restaurant organisation's performance based on number of orders, sales, cost, and profit. Also gives the user the possibility to easily identify which product bring in the most sales.
For the purposes of the operational managers in restarants to track their monthly performance and allow improved planning of staffing and ingredients in stock/purchasing needs.
- Generating additional data for the project to allow more realistic analysis of organisation's performance: e.g. employee data, working hours, spoilage data, etc.
- Adding dashboards to analyse the demand for ingredients to allow restaurants to keep accurate levels of ingredients in stock