The details:

Our ETL tool allows you to process files comprehensively, regardless of their format or structure. Structured database tables or semi-structured Excel, csv or txt files can be processed seamlessly, making it much easier to integrate data from different sources. Plus, you have the option of connecting different types of interfaces.

The ETL flexibility allows you to map and customize the fields supplied in the input file (e.g. price lists from suppliers) as required. This is done in a user-friendly way using drag & drop. A variety of different functions are available to transform the data in the source file so that it corresponds to the various data schemes and business requirements. The option to link conditions to the functions allows the output to be further specified.

The structured and intuitive interface of the Fiori app also allows users without IT knowledge to define the transformation steps and the time of the assignment. To process a new price list, you simply create and trigger a run that executes the predefined mapping steps. Delta loading only creates or updates the data that has changed since the last update. Once the initial definition has been made, the ETL tool can automatically integrate further data into the system.

The details:

The definition of data quality rules and their systematic classification in the repository creates a clear structure for the quality guidelines. Both the BRF+ included in S/4HANA and an integrated DMP function enable intuitive modelling and management in order to implement the rules and integrate complex business logic into the system. The user interface of the Fiori app also allows users without IT knowledge to manage the quality check of the data.

An integral part of the rule management process is the configuration of a data quality index. This determines how this index is calculated on the basis of master data and in conjunction with the defined data quality rules. The data quality index provides a quantitative metric for evaluating the quality of the data - the basis for introducing targeted measures to improve it.

The defined data quality rules are used for active analyses and checks of data. Check runs can be controlled easily and efficiently in a clear user interface and set up as a job. This enables continuous monitoring and evaluation of data quality. Potential quality problems can be recognised and rectified at an early stage.

Integration into the Data Process Stream (DPS) module enables automated cleansing of incorrect data. In addition, connecting other systems via mechanisms such as Smart Data Access enables access to external data and corresponding checks. By integrating the defined rules into the new creation process, potentially incorrect entries can be prevented right from the start.

The details:

DDC enables you to efficiently manage individual duplicate runs. Customer-specific evaluations with various check rules are defined via customizing. The module allows you to check all SAP tables - and therefore both master and transaction data - using these rules. Once the initial definition has been made, the checks can be carried out automatically via a user-friendly interface.

In addition to checking internal data in the system, the integration of an import function also enables data to be imported directly from an Excel file, for example, and compared with the database tables in the system. Use cases include classic migration work (e.g. as part of an S/4HANA conversion) or price comparisons (e.g. allocation of article prices from web crawling and existing articles already in the system).

When running a check, conditions are set to limit the data analysed and further refine the result. Once the duplicate check has been successfully completed, clear result values are presented for each potential duplicate. These results provide a structured basis for the targeted processing and cleansing of duplicates.

The duplicate check can not only be applied to existing data, but can also be integrated into the dialogue for creating new data.

The details:

In addition to our existing set of rules, we also present extended solutions in the area of data mining based on PAL (Predictive Analysis Library) and APL (Analytic Processing Library). These solutions enable multi-faceted data analysis, including classification, clustering (profiling) and anomaly detection.

The Predictive Analysis Library offers powerful statistical algorithms for comprehensive data analyses. The association algorithm in rule mining recognises patterns and rules in data, evaluates them statistically and enables hidden patterns and anomalies to be identified. After plausibility checks, the rules identified provide clear insights into data correlations. In master and transaction data, the association algorithm reveals how and why certain data elements are linked to each other. A practical example of this is analysing shopping baskets to determine which items frequently appear together in transactions. The users thus benefit from automated analyses to discover correlations in their data. In addition to the PAL algorithm, we use various statistical methods, including AI libraries in Python, to identify anomalies in the data. An example use case here is the analysis of deviations in order or bank transfer processes.

The data presented is displayed in clear dashboards that enable user-friendly visualisation and interpretation. From here, users can seamlessly process the data to quickly make informed decisions and derive measures. Depending on the application, we integrate the results into the various modules of our iDM toolkit.

The details:

DPS enables the mapping of processes to check and cleanse data and carry out transactions. This makes it possible to update or create master data or generate transaction data such as purchase orders.

The individual steps and their sequence can be individually configured via customizing. Our "Data Mining and Profiling" and "Duplicate Check" applications can be seamlessly integrated and existing analyses can be reused in the various apps. The integration of AI algorithms makes it possible, for example, to make intelligent predictions for product groups or to shorten material descriptions to 40 characters. Suggestions made by the system can be overridden by the user at any time.

The application therefore offers the possibility of mapping numerous processes in which data is transformed, prepared and then further processed in the system. In addition to the creation of articles and business partners, other examples include the entry of orders via Excel and the checking and posting of sales data from various transactions.