This is one of 4620 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
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
- Industries traffic / transport / logistics
- Specialist tasks Big Data, business intelligence, column oriented data base, data warehouse, performance analysis, Reporting
- DV tasks IT consulting
- System environment Business Intelligence, Cloud Computing, Middleware
- Procedure model customer standard
- Databases Teradata
- Development/ test tools Aqua Data Studio, Teradata Studio,
Project period01.10.2017 - 03.03.2018
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
