Cloud Data Lake

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.

Solution

  • Google BigQuery
  • SQL Server
  • Tableau
  • Snaplogic (ETL)
google_bigquery_logo
microsoft_sql_server_logo

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