Analytical data warehouse for a chain of bars and restaurants
About the client
The client is a wide chain of mono-brand bars and restaurants located in various European countries.
The task
Previously the client exported receipt data into Google Sheets by hand, which made sales analysis inconvenient and time-consuming. It was necessary to create automated reporting for real-time sales tracking and decision-making by the company's management.
Goals
- →Automate the collection of sales data from the bars and restaurants
- →Create dashboards for operational, real-time sales monitoring.
What was built
- 01
REST API for receiving data
An API service was implemented in Python to receive data from the point-of-sale program. The service transforms the data and stores it in Google BigQuery for subsequent use in dashboards .
- 02
Exporting receipts from the POS service
A connector was created to obtain receipt data from the point-of-sale program. The purchase information from receipts is transformed and loaded into Google BigQuery.
- 03
Building data marts
Tables and views were created in Google BigQuery, used by the company's specialists to prepare dashboards in Google Looker Studio and for analysis via Google Sheets..
Result
Automatic real-time data collection was implemented, pulling from several point-of-sale programs into a single Google BigQuery database. Historical receipt data was imported. Sales data marts were developed for use in dashboards and for export to Google Sheets.