B Products Cloud Suite – EMindfactorY

Analytics Suite

Which data is generated in which processes and how can I use it for my company? This question is not easy to answer due to the ever-increasing variety and complexity of data. Although data is considered the “oil of the 21st century,” its potential often remains untapped. The main causes are a lack of transparency in digital value creation and the complexity of data structures. In addition, there is the high effort associated with data preparation and integration. This is because the data can only be analyzed appropriately if it is loaded from the respective data silos into a Big Data database.

The EM Analytics Suite, with its four modules Process Management, Data Management, ETL and Analytics & Reporting, supports you in the above mentioned problems and helps you to generate a competitive advantage from your data.

Process Management

In the EM Process Management module, you can map the process management lifecycle. The objective is the documentation, design, implementation, control and optimization of business processes as well as the documentation of the internal control system (ICS).

Data Management

In the EM Data Management module you can design the data model. The objective is to create an enterprise data bus in which the transaction data or fact data are linked by means of dimensions according to the star schema. In addition, you can map your digital value creation and understand which data is generated from which processes.

ETL

Module EM-ETL ( Extract, Transform, Load) supports them in the ETL processes. The objective is to extract the data from the various internal and external data sources, prepare it and load it into the Big Data database according to the information design. To achieve a high degree of automation, the ETL processes can be scheduled as jobs.

Analytics & Reporting

In the EM Analytics and Reporting module, you can analyze and evaluate data based on Analytics Notebook. The results of the evaluations can be compiled as reports in the Report Designer and made available to specific authorization groups.

Integrated approach

The four modules are highly interrelated and the outcome of each module feeds into the subsequent module. The individual work steps are continuous from process entry to report design and enable efficient and goal-oriented work.

1. process recording
Recording and documentation of the essential processes and data flows. Identification of internal and external data sources.
2. implementation of the data model
The table schemas are designed in the Data Management module and then the tables are generated in the Analytics platform. The integration of the tables is done by means of dimensions (star schema).
3. conception of digital value creation
By linking the tables with the processes, the digital value creation becomes visible. This makes it possible to trace which data is generated from which processes.
4. loading the data
The data for the respective processes is extracted from the corresponding data sources using ETL processes, prepared, transformed and loaded into the Big Data database.
5. analysis of the data
After the data has been loaded into the Big Data database, it can be further processed for analytics. According to the business requirements, the data is processed into information.
6. reporting of the results
The results of the analyses are compiled as reports and made available to the addressees.

This post is also available in: German