Upscaling the Business by Migrating to the Cloud

BI,Case Study

UPSCALING THE BUSINESS BY MIGRATING TO THE CLOUD

INTRODUCTION A sub-company of one of the leading media companies in Germany wanted to upscale their internal processes and take advantage of cloud technologies. To do so, they want to migrate their architecture to the Google Cloud Platform. CASE DESCRIPTION The client wanted to find a way to upscale their architecture to improve the business. However, the current architecture ran into limitations because it is on-premise. As the amount of data kept grow- ing, the current solution showed long runtimes, bad performance and lack of storage which could not be resolved unless additional hardware was bought and provided. Therefore, the client changed their strategy and decided to migrate to the Google Cloud Platform to take advantage of the scalabil- ity and performance which various cloud technologies offer.

Before starting the migration process, it was necessary to organize and create a timeline whose purpose was to maintain an accurate overview of the migration process for manage- ment purposes. By doing so, the client was able to see which data would be available at a given time. Furthermore, the current business and its various reports and analysis had to be able to function properly which required adaptations and translations from the Microsoft SQL-Serv- er-Language to BigQuery-Language. Optimizing the processes while adhering to the Data Vault 2.0 standards was also a major point of this pro- cess. In order to reach these goals, the client was mainly looking for an external developer with deep knowledge of the given data warehouse

approach and technology stack who could also offer consultations regarding Data Vault 2.0. As a solution, Scalefree and the client have joint- ly developed a python tool that is able to auto- matically generate DBT-models which shorten the data loading processes significantly. Fur- thermore, a major part of the old architecture was successfully migrated to the Google Cloud Platform using BigQuery as the primary data warehouse. Based on that, various analyses as well as reports were built on Looker and are currently used in the daily business. As a result, Scalefree and the client have already reached a significant milestone in the migration of the on-premise architecture to the Google Cloud Platform. The achieved cloud architecture looks like the following:

2/3

Upscaling the Business by Migrating to the Cloud © Scalefree International GmbH 202 3

While it was expected that the runtimes would be improved by changing to cloud technologies, the solution exceeded expectations and cut down the ETL runtimes from two hours to three minutes. Furthermore, having part of the architecture already running on the new environment, the end-us- ers were able to analyze and build reports based on the provided data.

Scalefree International GmbH Schützenallee 3, 30519 Hannover, Germany

P: +49 (511) 879 893 41 M:+49 (175) 811 0336 F: +49 (511) 879 893 49

info@scalefree.com www.scalefree.com

CEOs: Michael Olschimke & Christof Wenzeritt

3/3

Upscaling the Business by Migrating to the Cloud © Scalefree International GmbH 202 3

Page 1 Page 2 Page 3

www.scalefree.com

Powered by