For the healthcare market
- Integration of the data of the IT systems
- Integration of the data between the healthcare facilities
- The analysis of profitability and efficiency, budgeting
- Comparative statistical reports, anomalies detection
- Verification of the medical data
For the healthcare market
The health protection market was, is and will be the continuous dynamic development area. The managers of the healthcare facilities are required to observe, control and in a certain, responsible way manage the work of the facility or the facilities network. In order to execute the management tasks efficiently, and take the right decisions, the executing persons must have access to proven, reliable information.
WHAT CAN EFFECTIVELY IMPEDE ACCESS TO THE MANAGEMENT INFORMATION?
In their daily work, the healthcare facilities use several systems to collect and process the data. Another system is used to the outpatients’ advice records, another to register hospitalization, another to supervise over the medical employees’ contracts or medical financial and accounting settlements. The practice shows that these systems are rarely integrated.
No data integration between the systems means that the terms meaning in fact the same (e.g. a person of the medical staff, patient, ICD9 procedure, ICD10 diagnosis etc.) are described and identified differently in different systems.
If in your system it is not possible to quickly and easy execute the monthly summary of the doctors of the selected specialties, which collects the information about: the number and value of the provided advice, the number of commissioned examinations and the amount of the remuneration, this can be due to no integration of the data between the systems.
Another complication can involve the geographical dispersion of the facilities included in the medical network, which often occurs in larger entities. In this case, next to the problems related to integration of the data in a single facility, there are new ones, related to existence of several recording systems of the same type of the data (e.g. several installations of the advice recording system). It is also possible that some IT systems are used by the independent facilities, and some are shared.
For example: each facility has its own advice recording system, and all facilities work on one financial and accounting system and one HR system.
Integration of data between systems is not an easy task and, regarding the size of the data sets, it certainly cannot be executed manually. Within the works, it is necessary to establish the rules for integration, and often reversely complement the data in the field systems.
However, it is worth to spend time and resources to integrate. The possibility to analyse, on one summary, the data from different systems and even from different location provides, unreachable by integration, possibility to look at the company’s work as a whole, without division into the systems or the locations.
Data warehouse as data source for reports and analyses
The solution to the problem of data integration and thereby to achieve a consistent and reliable source of data for analysis and reporting is to build a central repository of data based on the idea of a data warehouse. Unlike to the databases, the data warehouse stores the data so as to meet any reporting demand the best and as quickly as possible.
The data are transferred from field systems to the data warehouses by the ETL process, which assures their accuracy, integrity and up-to-datedness. The ETL process can obtain the data from a number of sources, and therefore the concept of the data warehouse is not limited to a particular system or the place on the map.
REPORTING AND ANALYSES OF BUSINESS INTELLIGENCE CLASS
Establishing a central repository of the reporting data (the data warehouse) opens a very wide range of possibilities to develop credible, current and useful information based on the collected data.
The advantages of BI reporting based on the data warehouse are:
- Possibility of connecting the data from different substantive areas,
- Possibility of developing the cross-summaries,
- Possibility of relating the data from the current time periods to the archive data.
For example, the analyses groups for the medical facilities Patients
- Profiles of the treated patients (age, sex, residence).
- Division of the patients into the age groups submitting the BMC declarations.
- Number of children below the age of 1-year-old were treated in the facility/facilities.
ICD9 medical procedures.
- Procedures statistics.
- Profile of the patients, for whom the procedures are executed.
- Procedures profitability.
Medical facility profitability.
- Is the medical facility profitable? If not, why? Which costs are the most?
Comparison of the medical facilities.
- Comparison of the medical facilities with the same business profile.
- Comparison of the medical facilities operations over several years.
- Comparison of the costs generated by doctors in the treatment of comparable groups of patients.
- Comparison of the number of the recommended examinations.
The following examples are just a part of the analyses to be developed for the medical facility. The above statement does not include the statistical reports, verification reports, observation of implementation of the plan and many others.
The developed analyses should be properly presented, stressing the cases requiring immediate attention. With the development of the reporting system, the number of analyses increase, therefore they are grouped together in the form of the reporting desktops with varying levels of accessibility for the users.
The information presented in the analysis can be visualized in different ways, depending on the needs: table, pivot table, chart, measuring instrument etc. The information can be in one form or many forms. Each analysis can be exported to a spreadsheet to make changes.
If, despite having the finished reporting desktops, the operator needs its own analysis, it can create, visualize and save it on its own desktop by itself.
Specialist IT knowledge or programming skills are not required in order to execute these operations.