Automated Building of Data Warehouses & Data Marts

Automation and quality assurance in the shortest possible time with our project accelerator - first-class, resource-saving, cost-efficient, fast and agile

Decisions are based on data. Unused, unstructured data and even data silos can paralyse decision-making processes or even lead to wrong decisions.

Use our accelerator to create automated data warehouses and data marts in the shortest possible time as the ideal basis for gaining information. Work with your data in your company holistically and in all areas.

REDESIGN & IMPLEMENTATION

HEALTH CHECK & MODERNISATION

HARMONISATION DATA WAREHOUSE & REPORTING

VERSATILE BI DATA MANAGEMENT

Conventional data warehousing is time-consuming, cost-intensive and robs many resources. With our project accelerator, the concept changes essentially - acceleration through automation of data warehouses and data marts. Manual processes and lengthy implementations are a thing of the past. The metadata-based data management platform forms the basis for complete modelling and documentation. This platform thus enables you to work with your data in an accurate, optimised and flexible way with the following benefits:

Single installation*

Multi-client capable, for severaldata warehouses & data marts

DATA-LINEAGE REPORTS

From the source to the data mart

COMPLETE VERSIONING OF METADATA

Storage and comparison of intermediate data

FREE CHOICE OF MODELLING METHOD

Flexible and customisable approach

* After implementation, you can operate your data warehouse without our project accelerator, the results are licence-free. Alternatively, by using our accelerator on an ongoing basis, you benefit from optimal operation and secure maintenance.

SCOPE OF SERVICES OF THE BI DATA MANAGEMENT PLATFORM

ACCELERATOR FOR YOUR PROJECT

In addition to the above-mentioned benefits, which bring the department forward, the following technical features are decisive for the outstanding quality of the platform.

Get all environments at a glance

Central process control for all environments

The dev, test and prod environments can be viewed and edited centrally via the BI Management Platform. Through dependency analysis, the platform automatically avoids subsequent errors in loading. The integrated AI permanently optimises the loading logic and thus reduces loading times and costs for the infrastructure.

Customise your templates

Customisable templates for code generation

Use our basic templates to integrate your individual code generation requirements for your data warehouse(s). The partial integration of your own code artefacts works quickly and intuitively.

Relieve your IT and accelerate your processes

Central Build & Deployment

The Data Management Platform impresses with the advantage that the build and deployment definitions take place on a central server environment.
The tedious transfer and overloading in IT is saved: provisioning, configuration, updating and maintenance take place at the push of a button, any error messages are displayed in a targeted and user-friendly manner. This eliminates the need for manual reconciliation of individual objects, troubleshooting can be done directly in the specialist department and does not require in-depth technical know-how.

"THE AUTOMATED DEPLOYMENT SPEEDS UP THE PROVISION OF DATA WAREHOUSES & DATA MARTS MANY TIMES OVER - FOR EFFICIENT IT MANAGEMENT IN THE COMPANY."
Jonas Fiedler, Developer, avantum consult

Meet your security requirements

Guaranteed data governance & DSGVO compliance

To ensure IT security, data governance-relevant attributes can be defined centrally with our project accelerator. These security requirements are handled separately during code generation, while the specific data warehouse definitions remain unaffected. The necessary template changes per data warehouse are enforced centrally for all cores, thus comprehensively fulfilling the DSGVO requirements.

Scope of services of the generated data warehouse architecture

Data Warehouses & Data Marts

Your new data warehouse offers you the highest quality thanks to best practice standardisation.

Control your processes agilely and flexibly

Multi-level layer model & historisation

The multi-level layer model of your data warehouse classifies and segments the necessary preparation processes of your data. Through consistent and plausible consolidation, the data from the various source systems is merged, cleansed and prepared. A complete, customisable and automated historisation also allows you to retroactively track changes in your source data and access former data records if necessary.

Access subject-specific subject areas

Central Business Core & subject-specific data marts

The Business Core - the top layer in your data warehouse - serves as a central location for your company-specific business logics. This means that they can be made available, processed and maintained quickly and easily. In addition, your data is already created there in the form of a star schema. In this way, the provision of your subject-specific, both relational and multidimensional, data marts runs ideally and smoothly.

Get high quality data sets & reliable reports

Adjusted charge cycles, partial & delta load

In your new data warehouse, your data is not only matched with attribute accuracy, missing or unknown references are also automatically replaced by default values. As a result, you receive complete data sets that enable accurate and first-class reporting - without manual effort.

Maintain your data warehouse in a simple and regulated way

Standardised architecture

The segmented and historised layer model makes it easy for every user to understand and maintain the preparation processes of your data. In addition, work processes within the data warehouse are harmonised and standardised thanks to the high degree of standardisation of the architecture and data management. A solid and constant quality of your data warehouse is thus guaranteed throughout.

Currently, we use our project accelerator exclusively for the automation of data warehouses and data marts within the Microsoft Data Platform. We are planning to extend this to the SAP components HANA and Data Warehouse Cloud.

Our offer for you

Based on our many years of expertise in data warehousing and our focus on automated processes, we offer the following consulting services with our project accelerator. Arrange an initial meeting with us and get to know our project approach better.

New conception & implementation

You would like to start in data-driven business and introduce a data warehouse.

Health Check & Modernisation

You already have a data warehouse, but it needs optimisation and/or expansion.

Harmonisation of data warehouse & reporting

You are satisfied with your data warehouse, you need the implementation of your data basis in the form of data marts based on Microsoft Power BI for your reporting.