_further_industries
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.
Hyand successfully applied for a tender from the WIdO - the R&D unit in the AOK community - and was awarded the contract because it was able to perfectly fulfill the customer's requirements with its portfolio and long-standing MicroStrategy partnership. In addition, Hyand Solutions had proven its MicroStrategy expertise in previous projects.
Hyand was responsible for the entire front-end implementation using MicroStrategy in the AOK DiAna project. A MicroStrategy Intelligence Server, a separate MicroStrategy Web Server and the MicroStrategy Enterprise Manager were installed and configured. In the course of the project, Hyand Solutions took up the requirements and developed the architecture for the DiAna application. Based on the architecture, the data model was implemented in MicroStrategy.
To build the report library, it was necessary to develop a complex, three-level nested filter construct in which various report objects were used (filter reports, prompts, etc.). Based on this, further metrics, reports and documents were designed by Hyand Solutions. In collaboration with the WiDO DWH team, Hyand Solutions was able to optimize the execution time of the reports from the library through VLDB settings and changes to the data model.
As the functionalities of MicroStrategy Web did not meet the requirements of the DiAna application, it was also necessary to make various adjustments using MicroStrategy SDK. These included the implementation of an automatic import of several thousand report definitions from an external database. An export function was also implemented, with which report definitions can be saved in a CSV file from MicroStrategy Web. 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 operating functionalities on the input page (answering prompts) for reports in MicroStrategy Web. Finally, various display formats in MicroStrategy Web were changed to ensure better usability.
Another task in the project was the training of project participants. The main focus here was on administration, the use of report services and project design.
Building on the positive experiences of the user community with DiAnaclassic, further applications such as DiAnalight - a focused DiAna version that invites users to interactively explore AOK performance data - and DiAnamobile, a mobile app that allows such analyses on the iOS end device, were developed in an agile approach. The app runs "Blackberry secured" and uses all the modern security standards required for the use of sensitive data.
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.).
_hyand_success_stories
Discover our solutions
You too can benefit from our extensive experience from
projects for companies of all sizes.
HyExpert - the IT talk.
Would you like to know how you can take your company forward with our customized IT solutions? Do you have questions about specific digital challenges?
Contact us - we'll help you!