Stories of becoming data-driven.

We integrated an external data source - Salesforce this time - into Google BigQuery. The integration was made possible through a number of custom made solutions and scripts that combine a number of Google Cloud products.

With a Data Warehouse Health Dashboard (created in Looker Studio for their BigQuery warehouse), our client has easy access to the status of last data integrations and is able to quickly spot any potential problems though colour alerts.

An automatic backup is done every 7 days, without a need of human triggers. Hebe is protected in case of a catastrophic failure, but since the backup is automatically removed after 30 days, the solution remains economical.

To build a new data warehouse for our client, and transfer the company's existing data from AWS, we used a number of Google Cloud based solutions. The Data Warehouse was built in Google BigQuery, and for seamless transfer of data, we took advantage of Google Transfer Service and Cloud Composer with Apache Airflow 2.

Using our own model of RIVA audit, we helped Kompania Piwowarska transform the way they use their data. Finding out whether the data collected is recent, important, what is its volume and how accessible it is, we helped to better understand the insights it provides.

The Hebe Quiz was a technical project at the junction of several areas of IT, Marketing Automation, Project Management, and communication. The key was to implement the project with minimum interference in client’s existing technological solutions and take advantage of previously implemented tools to create an extraordinary experience for the users.

Empik needed a complex marketing personalization strategy for loyalty program members, that they were missing at that time, along with a reliable data warehouse for customer, transactional and behavioral data. Four years later, there were over 5 million members of Mój Empik and a long list of automated marketing campaigns.