Cloud Data Lake
1
Challenge
The aim of the project was to ensure effective reporting for several thousand restaurants located in different countries. Additionally, the business goal was to reduce licensing costs within the existing warehouses and databases.
2
Solution
- Google BigQuery
- SQL Server
- Tableau
- Snaplogic (ETL)
3
Result
- Development of a data warehouse in the cloud native architecture
- Development of a data repository based on Google BigQuery distributed processing technology
- Development of several dozen report templates regarding the operation of restaurants
- Delivery of operational information to several thousand recipients
It was possible to provide reporting information to several thousand recipients in the sales network and management staff