Data management

Ubiquitous - The digital transformation

The digital transformation is profoundly shaping the economy and revolutionizing existing business models worldwide. IT architectures are being rethought and processes are being redesigned to meet the requirements of the modern business world.

Our role as Data & Analytics Pioneers

Our role as Data & Analytics Pioneers

 

In our data management division, we create the basis for well-founded decisions and strategic corporate management by providing a comprehensive overview of historical and current company data.

We offer customized solutions that are specifically tailored to the individual requirements of our customers.

Our data management experts provide you with competent and efficient support in the following areas:

Data warehousing as a basis for reporting and planning

Establishment of a stable and scalable data infrastructure to support reporting and planning processes.

Industrialized reporting

Efficient reporting including integrated planning functions for controllers, both in Excel and on the web.

Visualisations

Development of mobile dashboards for management, enabled by a sophisticated data warehousing strategy.

Empowerment of your Data Analysts & Scientists

Provision of advanced analytics options that support and advance your data analysts and data scientists in their work.

Automation

Use of data warehousing as a basis for the automation and optimization of business processes with the help of analytical functions.

CONTACT
Head of the Data Workshop

"We are the specialists for SAP's data warehousing solutions. My team was the first consulting firm in the world to license and successfully implement the SAP Data Warehouse Cloud (DWC) for a customer. We therefore have particular expertise in this area. My team and I look forward to hearing from you."

Eugen Gering, Head of Data Management

Eugen Gering
Head of Data Warehousing

Our specialization in data management

We specialize in the following SAP data warehousing solutions:

SAP Datasphere

SAP BW/4HANA

SAP BW ON HANA

FAQ - Data management

FAQ Data Workshop

A data warehouse is a company-wide database that integrates data from various heterogeneous data sources and makes it available for analysis and evaluation purposes. A well-designed data warehouse delivers high data throughput, performs queries quickly and offers end users the ability to break the data into smaller pieces to view it from different angles.

  • Topic-oriented = The data structure in a DW is used to support management decisions and is not designed to support operational business processes. Data is stored according to specific objects such as customer or product. Decision makers analyse the data of these objects and make their decisions based on them.
  • Integrated = The data is integrated from various heterogeneous data sources into a common dataset. For the integration, the data must be transferred into a uniform data structure and a common data format
  • Non-volatile = In a DW, the stored data is neither deleted nor modified. Only to correct errors can the data in a DW be changed. In the course of time, a historical data stock is thus created, which is composed of the data of the individual operative application systems
  • Time-related = The data are loaded into a DW at different times. The newly loaded data records do not overwrite the old data stock, but merely supplement it. This creates a snapshot of what is happening in the company each time. Accordingly, the data can be compared over different periods of time and trends can be identified.

Business Intelligence (BI) includes access to information with the help of IT systems. The analysis, evaluation and presentation of business-relevant company data should provide insights into the current state of the company. These insights contribute significantly to strategic and operational decision support. The goal is to provide management with high-quality data and to support them in their decisions in the best possible way. For the technical implementation of a BI solution, a DW is necessary, which forms the foundation of every BI solution.

A database management system - also called a database system for short - has been designed to manage large amounts of information. The primary goal of a database system is to provide the most efficient and convenient way to store and retrieve database information. A database system is an organised collection of electronically structured information or data stored in a computer system. The core task of a database is to store large amounts of data efficiently, permanently and without errors, and to provide the required information as needed.

The name cloud computing is a metaphor for the internet. The internet is typically represented in network diagrams as a cloud. The cloud symbol represents unknown network infrastructures that make the network work.

Probably one of the most currently recognised definitions of cloud computing is that of the National Institute of Standards and Technology (NIST), which is also often referred to in specialist circles. NIST defines cloud computing as a model that enables ubiquitous, convenient and on-demand network access to a shared pool of configurable computing resources (e.g. network, servers, applications, services and storage). These computing resources can be rapidly provisioned and released with minimal management effort or interaction with the service provider. The cloud model is composed of three service models (Infrastructure-as-a-Service, Platform as a Service and Software-as-a-Service) and four deployment models (Private, Public, Hybrid and Community Cloud).

In contrast to cloud computing, solutions are also made available on-premises. "On-Premises" in German means something like "on one's own premises" or "on site". The description of on-premise refers to the use of one's own servers and IT environment. While access in the cloud takes place via the internet, on-premise solutions are operated locally on one's own computer.

Knowing what to do

Data & Analytics

is running!

HOW WE WORK

More information

Reporting and planning

Google Cloud Platform (GCP)

Innovation

Management consulting