PR Company

April 11, 2022
PR Company

Overview

The PR Company had developed an internal system to capture the confidential details of their clients with the digital signature as a key differentiator from one record to another. The system has millions of records of users and handling the user data, the ETL Processes had become cumbersome.

Challenge

The most difficult task was to reduce the ETL process time, especially at the time of adhoc reporting. The overall process of extracting and transforming the data itself took weeks due to the complexity of the legacy system. Even extracting a simple report would take hours.

Implementation

The management finally decided to upgrade a part of the system to Amazon Web services due to its speed and performance. AWS Data pipeline allowed the data movement and transformations across the AWS Services that were being used. Since its pay as you go service, the costs were reduced a significant amount as well.

Benefits Achieved

  • 25% reduction in the cost
  • Runtime of ETL processes reduced by 60%
More Case Studies
Supermarket
Overview A regional supermarket has been working on generating insights on location and competitor analysis. To analyse the sales data, […]
IT BPO Service provider
Overview This IT Support organisation possesses massive amounts of data about their customers across the globe. The ticketing system has […]
Ticket booking company. (Data Analysis)
Overview A ticket booking system company serves about 12 destinations. The marketing department wanted to create deeper insights to deliver […]
It’s free and easy to post your project

Get your data results fast and accelerate your business performance with the insights you need today.

close icon