{"id":35851,"date":"2026-02-04T12:18:18","date_gmt":"2026-02-04T11:18:18","guid":{"rendered":"https:\/\/risc.web-email.at\/referenzprojekte\/process-mining-and-real-time-bi-in-medical-technology\/"},"modified":"2026-02-24T15:31:10","modified_gmt":"2026-02-24T14:31:10","slug":"process-mining-and-real-time-bi-in-medical-technology","status":"publish","type":"project","link":"https:\/\/risc.web-email.at\/en\/referenceprojects\/process-mining-and-real-time-bi-in-medical-technology\/","title":{"rendered":"Process mining and real-time BI in medical technology"},"content":{"rendered":"\n

Scalable data warehouse for CADS GmbH: the basis for agile process optimization and data-driven decisions<\/h2>\n\n\n\n
\n
\n

RISC Software GmbH developed a customized data warehousing solution for CADS GmbH that serves as the basis for process mining and optimizes business intelligence activities. The project included the creation of an analytical data model and the implementation of a real-time capable data transfer from the operational database to the new data warehouse. <\/p>\n<\/div>\n\n\n\n

\n
\"Screenshot\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/div>\n<\/div>\n\n\n
\n
\n

Real-time analysis of complex process data from the operational database<\/strong><\/h3>\n\n\n\n

The control and optimization of business processes requires a fast, error-free and comprehensive database. The challenges were complex: the process data was stored in an operational database that was not optimized for either complex or analytical queries in real time. Analytical queries on this database would have significantly impacted the performance of ongoing business operations. In addition, there was no easy way to centrally integrate different data sources, such as future machine data, and the existing data structure was not ideal for analytical activities and business intelligence (BI). <\/p>\n<\/div>\n<\/div>\n\n

\n
\n

The solution: Real-time data warehouse<\/strong><\/h3>\n\n\n\n

RISC Software GmbH developed a holistic solution based on modern data architecture concepts. Apache Kafka was chosen as the central component for real-time capable data transfer. This decouples the system speeds and enables the future integration of new sources. Debezium ensures that changes in the source database are continuously transferred to Kafka. <\/p>\n\n\n\n

An analytically optimized data model was created for the data warehouse. Highly correlated tables were merged to speed up queries. The mapping to the target data model is carried out via a configuration file, which allows adjustments to be made without code changes. <\/p>\n<\/div>\n<\/div>\n\n

\n
\n

Better solutions for customers<\/strong><\/h3>\n\n\n\n

The data warehouse offers CADS GmbH decisive advantages for analysis and control. Thanks to the connection to Microsoft PowerBI, process data can be tracked in real time on dashboards, allowing direct intervention in the event of bottlenecks. The optimized data model significantly accelerates complex analytical queries. Above all, the data warehouse forms the high-performance basis for process mining, allowing internal processes to be analyzed and optimized in detail. The future-proof architecture is also designed for scaling and the simple integration of new data sources. <\/p>\n<\/div>\n<\/div>\n\n

\n
\n
\n
\n
\n
\n
\n
\n

Durch die Implementierung des Data Warehouses haben wir erstmals die M\u00f6glichkeit, unsere zentralen Gesch\u00e4ftsprozesse in Echtzeit zu \u00fcberwachen und datenbasiert zu optimieren. Das schafft die essenzielle Grundlage f\u00fcr unsere zuk\u00fcnftigen Process-Mining-Aktivit\u00e4ten.<\/span><\/p>\n\n <\/div>\n <\/div>\n

Mario Moser, CEO CADS GmbH<\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/div>\n <\/section>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
\n
\n

Project partners<\/h2>\n<\/div>\n\n\n\n
\n

Project details<\/h2>\n\n\n\n
    \n
  • Project long title<\/strong>: Design and development of a data platform for real-time process mining<\/li>\n\n\n\n
  • Customer:<\/strong>\n
      \n
    • CADS GmbH<\/li>\n<\/ul>\n<\/li>\n\n\n\n
    • Duration: <\/strong>07\/2025-10\/2025 (4 months)<\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
      <\/div>\n\n\n\n
      \n
      \n

      Contact us<\/h2>\n\n\n\n
      \n
      \n

      <\/p>

        <\/ul><\/div>\n
        \n
        \n<\/fieldset>\n
        \n\t
        \n\t\t

        \n\t\t

        \n\t
        \n\t\t

        \n\t\t

        \n\t
        \n\t\t