Scalefree - Fallstudien - Tuning-Bericht Leistung eines Kabelnetzbetreibers

Über den Kunden

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.

Problemstellung

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

Die Herausforderung

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

Die Lösung

Upon Überprüfung, 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.

Konkrete Ergebnisse für den Kunden

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

Verwendete Technologien

  • 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

Möchten Sie mehr erfahren? Holen Sie sich die ausführliche Fallstudie!

Marc Winkelmann Geschäftsführender Berater

Marc Winkelmann
Managing Consultant

Telefon: +49 511 87989342
Mobil: +49 151 22413517

Planen Sie Ihre
Kostenlose Erstberatung