Other Key Industries
Scientific Institute of the AOK (WIdO)

Analytics platform to improve healthcare provision

The Challenge

Creating knowledge for practice - that is the core task of the Scientific Institute of the AOK (WIdO). It offers well-founded expertise on all areas of statutory health insurance and focuses primarily on patient care. The WIdO has two central tasks: On the one hand, the research and development work carried out supports the AOK community in particular in ensuring high-quality, cost-effective healthcare. On the other hand, it is concerned with research, teaching and the further development of statutory health insurance.

AOK's integrated data, library and analytics platform (DiAna) provides users in the AOK community with a powerful database. The basis for analyses is the anonymized performance data of the 27 million AOK insured persons from several years, as well as a large number of medically and pharmaceutically validated sets of rules. This provides a flexible and high-performance analysis tool that enables AOK experts from areas such as medicine, pharmacy, contract design or controlling to provide answers to questions without programming knowledge - using big data and complex classification systems.

HyPlus successfully submitted a bid in response to a request for proposals from WIdO—the R&D unit within the AOK network—and was awarded the contract because its portfolio and long-standing partnership with MicroStrategy perfectly met the client’s requirements. In addition, HyPlus Solutions had demonstrated its MicroStrategy expertise in previous projects.

Our solution

HyPlus was responsible for the entire front-end implementation using MicroStrategy in the AOK’s DiAna project. A MicroStrategy Intelligence Server, a separate MicroStrategy Web Server, and the MicroStrategy Enterprise Manager were installed and configured. During the course of the project, HyPlus Solutions gathered the requirements and developed the architecture for the DiAna application. Based on this architecture, the data model was implemented in MicroStrategy. To build the report library, it was necessary to develop a complex, three-level nested filter structure that utilized various report objects (filter reports, prompts, etc.). Building on this, HyPlus Solutions was able to design additional metrics, reports, and documents. In collaboration with WiDO’s DWH team, HyPlus Solutions was able to optimize the execution time of reports from the library through VLDB settings and changes to the data model. Since the functionalities of MicroStrategy Web did not meet the requirements of the DiAna application, it was also necessary to make various customizations using the MicroStrategy SDK. This included, among other things, the implementation of an automatic import of several thousand report definitions from an external database. An export function was also implemented, allowing report definitions to be saved from MicroStrategy Web to a CSV file. For mass backup, further processing, and editing, a bulk export was also implemented, which exports the thousands of report definitions from MicroStrategy to a database. In addition, it was necessary to adapt the user interface functionalities on the input side (responding to prompts) for reports in MicroStrategy Web. Finally, various display formats in MicroStrategy Web were modified to ensure better usability. Another task in the project was training project participants. The main focus here was on administration, the use of Report Services, and project design. Building on the user community’s positive experiences with DiAnaclassic, an agile approach was used to develop additional applications such as DiAnalight—a streamlined version of DiAna designed for interactive exploration of AOK performance data—as well as DiAnamobile, a mobile app that enables such analyses on iOS devices. The app runs on “BlackBerry Secured” and employs all modern security standards necessary for handling sensitive data.

The result

The customer was provided with a future-proof application (GIS analyses, mobile, self-service, etc.) on the basis of which further development for new functionalities/analyses can be built (e.g. time series, map display, predictive analysis, R integration, etc.).

Discover our digital solutions

You too can benefit from our extensive experience with projects involving companies of all sizes.

Ensure deadlines are met and significantly reduce administrative burdens

Efficiently connect supply chains and significantly speed up processes

Unlock vehicle features flexibly and directly

Detect errors early and prevent data loss

Detect issues faster and ensure stable system operation

Reduce processing times and streamline processes

Targeted talent development and faster filling of internal positions

Reduce complexity and integrate systems more quickly

Deliver new services faster and scale systems flexibly

Boost sales success and better identify profitable target audiences

Update fund data faster and manage releases more efficiently

Increase customer satisfaction and scale services flexibly

Develop new services faster and analyze data flexibly

Ensuring consistent standards in an efficient and transparent manner

Reduce processing times and adapt processes more quickly

Optimize resource utilization and significantly reduce planning efforts

Identify vehicles faster and streamline processes

Efficiently manage transportation processes and reduce maintenance costs

Reduce processing times and increase customer satisfaction

Manage inquiries transparently and reduce response times

Reduce churn and build long-term customer loyalty

Manage complex master data efficiently and flexibly

Streamline planning processes and minimize sources of error

Minimize data protection risks and ensure reliable compliance

Identify risks early and reliably comply with legal requirements

Identify new business opportunities and minimize risks

HyExpert

Would you like to know how our customized IT solutions can help your business succeed? Do you have questions about specific digital challenges?

Get in touch with us—we’re here to help!

✕