This is one of 4544 IT projects that we have successfully completed with our customers.
How can we support you?

PTA / IT project database / Projekt ID: 4864

Concept for the implementation of detailed data reporting in the data warehouse

Project duration: 5 months

Brief description

Within the framework of the project for the modernization of the Business Intelligence/Data Warehouse landscape, a concept for the implementation of detailed data reporting is required. In order to avoid the complex generation of aggregates in data marts, an abstract technical data model is to be developed and evaluated, which enables reporting on detailed mass data.

Supplement

The technical possibilities of a data warehouse based on Teradata are to be identified and evaluated by suitable benchmarks regarding the feasibility. This includes the evaluation of the following Teradata concepts: primary, secondary and join indices; statistics; partitioning (row and column based); compression (multivalue compression, algorithmic compression). Benchmarking is based on the expected quantity structure with tables of more than 20 billion rows.

Subject description

Index structures or other technical measures that enable fast response times must be able to be generated in an acceptable time so that data management can also take place several times a day (hourly, sometimes every 15 minutes). It should also be possible for departments to create their own self-service reports using standard reporting tools such as Tableau or SAP Business Objects.

Overview

Branchen traffic / transport / logistics
Fachaufgaben Big Data, business intelligence, column oriented data base, data warehouse, performance analysis, Reporting
DV-Aufgaben IT consulting
Systemumgebungen Business Intelligence, Cloud Computing, Middleware
Vorgehensmodell customer standard
Datenbanken Teradata
Entwicklungs- und Testtool Aqua Data Studio, Teradata Studio,

Project period01.10.2017 - 03.03.2018

This is one of 4544 IT projects that we have successfully completed with our customers.
How can we support you?

Concept for the implementation of detailed data reporting in the data warehouse

Brief description

Supplement

Subject description

Overview

Have we sparked your interest?

Gerd Minners

Key Account Manager

Contact

Company

Service

Social

This is one of 4544 IT projects that we have successfully completed with our customers.How can we support you?

Concept for the implementation of detailed data reporting in the data warehouse

Brief description

Supplement

Subject description

Overview

Have we sparked your interest?

Gerd Minners

Key Account Manager

Contact

Company

Service

Social

Jetzt Kontakt aufnehmen

Contact now

Download file

This is one of 4544 IT projects that we have successfully completed with our customers.
How can we support you?