The Customer is a US leading health information exchange (HIE) vendor.
Having an HIE platform, the Customer wanted to aggregate the patients’ data available from different healthcare providers, as well as extend platform’s functionality by adopting risk management. The Customer also wanted to establish a role-based access control to the reports and dashboards, so security was another challenge to solve.
As the Customer needed a comprehensive BI solution, ScienceSoft’s BI consulting team started with creating a data warehouse from scratch using Microsoft SQL Server. For ETL development, ScienceSoft suggested Microsoft SQL Server Integration Services. As a next step, two analytical cubes were created using Microsoft SQL Server Analysis Services. For the user interface, ScienceSoft offered Kyubit BI, as the technology was Microsoft SSAS-compatible and quick in report development.
At the final stage of the project, the following reports and dashboards were delivered:
In the context of this project, an event means a health problem a patient encounters (for example, a serious injury, hospitalization, unexpected illness, etc.).
To ensure data security, ScienceSoft implemented a role-based access control to the reports and dashboards:
At the closing project stages, ScienceSoft’s team was developing the dashboards that revealed no sensitive information, but gave an overall picture needed to analyze the trends and dependencies.
At the end of the project, the Customer got a flexible BI solution that allows aggregating the patients’ data. According to the Customer’s requirements, several security levels (all data, organization level, community level, personal level) were set based on the user roles.
ScienceSoft delivered informative and easy to use reports and dashboards. One of the dashboards shows the impact of patients’ diagnoses and medications they have received (extracted from the health records) on an event probability. Based on medical data analysis, the healthcare providers can take measures to reduce the risk of an event.
Microsoft SQL Server, Microsoft SQL Server Analysis Services, Microsoft SQL Server Integration Services, Kyubit Business Intelligence.