Data analysis

HomeReferencesKnowledge-baseData analysis

ID	Projekt-Titel
4897	Preparation of test and migration data for CRM introduction
4897	Preparation of test and migration data for CRM introduction
4720	Support of quality assurance in the purchase of commercial articles
4687	Decommissioning of Clarify-based legacy CRM systems
4682	SAP BW on HANA: Cleansing and further development of BW applications
4665	Statistik-Data Mining Tool for laboratory data
4662	Identification of perfomance-intense rules in a middleware rule engine,
4649	Database queries to identify workload of laboratory information systems
4608	SAP ERP 6.0: Implementation of New General Ledger
4600	Monitoring and quality assurance of web tracking data

Image: Projectpicture for industry chemical industry

Preparation of test and migration data for CRM introduction

Centralization of master data from various third-party systems in MS Excel 2016 for import into a new CRM system. Different variants and versions of the imported data serve as data and test basis for the new CRM system.

Image: Projectpicture for industry chemical industry

Preparation of test and migration data for CRM introduction

Centralization of master data from various third-party systems in MS Excel 2016 for import into a new CRM system. Different variants and versions of the imported data serve as data and test basis for the new CRM system.

Image: Projectpicture for industry pharmaceutical industry

Statistik-Data Mining Tool for laboratory data

Statistical evaluation of the throughput of samples from a laboratory and the provision of these evaluation to an external web-based monitoring tool.

Image: Projectpicture for industry pharmaceutical industry

Decommissioning of Clarify-based legacy CRM systems

The project includes the archiving and decommissioning of outdated CRM-systems in the EMEA-region and the migration of the database content into a long-time archive. Data preparations in the source database as well as the data transfer into the archive and the tests of archived data are part of this project.

Image: Projectpicture for industry trade

Support of quality assurance in the purchase of commercial articles

Several MS-Access/MS-Excel applications in the area of purchasing are continuously dynamised, optimised and expanded in accordance with department specifications. Analysis and coordinated implementation with several developers in the VBA development environment, including developer and function tests. Furthermore, direct support of the department for these applications is supported via a ticket system.

Image: Projectpicture for industry mechanical and plant engineering

SAP ERP 6.0: Implementation of New General Ledger

Introduction of the New General Ledger (new G/L, New General Ledger) for the financial accounting of an asset construction company in SAP ERP with document splitting.

Image: Projectpicture for industry mechanical and plant engineering

SAP BW on HANA: Cleansing and further development of BW applications

Analyses and cleansing of objects in SAP BW on the basis of HANA requirements as well as building up and further development of BW applications. The database changeover to SAP HANA has been completed for the BI system. The work is intended to prepare the native use of the HANA functionalities.

Image: Projectpicture for industry pharmaceutical industry

Identification of perfomance-intense rules in a middleware rule engine,

Interfacing between laboratory information systems and medical instrument, a middleware enables laboratory personnel to control complex work processes using a customizable rule engine to define their own rules. To increase the rule engine's performance within a hemotological working environment, PTA identifies those rule engine rules displaying maximum performance intensity. Such rules are prime candidates for performance optimization.

Image: Projectpicture for industry pharmaceutical industry

Database queries to identify workload of laboratory information systems

Laboratory information systems (LIS) are used as so called middlewares in medicinal-diagnostic laboratories. They support specific laboratory workflows, allow to view and store data or are responsible for the communication between host systems and laboratory devices. The manufacturer of LIS is provided with individual database queries which allow him to obtain statistical data concerning the operation of LIS as well as the workload capacity of running LIS. Moreover, the provided solution also allows to identify the hardware specification of LIS. The database queries are written in SQL and can be executed through a provided windows batch script.

Image: Projectpicture for industry trade

Monitoring and quality assurance of web tracking data

As part of the project, the tracking data collected by the individual web shops of the group companies will be quality-assured. On the one hand, this includes tool-supported monitoring of the data as well as the support of relevant group companies in problem analysis and troubleshooting in the event of an error. In addition, the replacement of the existing tracking solution is planned and the new development is accompanied