About the Client

A provider of cable network services in Germany wanted to understand why their Data Warehouse development had constant delays and results were not being delivered in the requested time frame which necessitated guidance on fixing those issues.

Problem Statement

The provider had poor overall performance in their BI system. Some of the problems observed were:

  • Getting data from multiple sources and loading data was taking an extended amount of time
  • Full automation was not possible with in-house automation tools
  • Development was missing deadlines 
  • Business users were unable to build reports before end of production

Therefore, the goals of the assessment were: 

  • Identify the weaknesses in their system 
  • Collaborate with the client on the elaboration of mitigation strategies

The Challenge

The client had adopted some Data Vault concepts but still had problems with the overall system, so they needed a broader expertise to:

  • Review the current implementation following the best practices
  • List options for going forward with an overview of advantages and disadvantages in the short-term and long-term
See the Extended Case Study

The Solution

Upon review, Scalefree provided a list of actionable recommendations to some of their current issues:

  • Replace the current automation generator with a purchased off-the-shelf automation tool to better support their case
  • Leverage Data Vault 2.0 Methodology to achieve agile delivery
  • Refactor the whole data model
  • Insert-only driven data loads
  • Implement a Managed Self-service BI
  • Change from bitmap to hash diff calculation in Delta Checks

Following these actions allowed the improvement of the performance of the overall Enterprise Data Warehouse.

Tangible Results for the Client

There were important takeaways the client got from the assessment:

  1. Discovery of the causes of impacted performance and how to solve them
  2. Potential to improve their performance by  following the recommended actions provided

Technologies used

  • Custom in-house generator based on Oracle database and Oracle APEX
  • Oracle 12, Client has a wide-range of Oracle licenses available
  • Attunity for CDC of AS/400 data
  • Automic for job management

Interested in learning more? Get the detailed case study!

Make An Appointment with Us

Profile Photo of Jürgen Dackweiler


Phone: +49 (511) 879 89342
Mobile: +49 (175) 811 0336