Data Warehouse on Cloud

By August 9, 2019 Case Study

A fin-tech company

Problem Statement

The fin-tech customer processes millions of transactions and API calls in a month in
their on-prem setup and this reduced their flexibility in using some advanced cloud
services. The customer was looking to migrate their massive Data Warehouse and
Reporting modules to cloud to reduce the overall time taken for generating insights
and reports on a daily basis.

Proposed Solution

Powerup helped the customer move their 5-year old legacy data and 100+ complex
SSIS jobs to Azure SQL Data Warehouse. Powerup also helped the customer in
optimizing most of their long-running queries & data model, optimizing SSIS jobs &
Tableau jobs to help them run the whole DWH set up effectively in the cloud.

Cloud Platform

Azure

Technologies used

Azure SQL Data Warehouse, SSIS, Tableau.

Leave a Reply