Business Intelligence in Healthcare

The main goal of each Healthcare Institution in a highly controlled & competitive environment, is to reduce operating costs while maintaining a consistently acceptable level of patient treatment. Reduce operating costs at all levels:

On the other hand, an acceptable level of patient treatment involves:

Evidence based medicine, accurate diagnosis and efficient treatment
On time admittance in the Hospital and healthcare treatment
Treatment with respect for the Patient- analysis of options
Reduction of risks during treatment (e.g. related to the use of medicine, biomedical equipment, blood transfusions)
Capture of medical history of the patient in order to support evidence based medicine

Moreover, goals of each Healthcare Institution are:

Reduction of medical errors and exposure of the patient to medical hazards (e.g. inappropriate levels of radiation)
Support medical research with patient & treatment data
Participate and support a larger Healthcare system, with the exchange of medical information on a patient, as well as statistics on population morbidity & mortality.

In Private Healthcare, the excellent Patient service is critical to Customer retention & loyalty and business growth. In order to achieve these goals, each modern Healthcare system aims to enhance its Organisational capability with the introduction of standard business processes, standard healthcare treatment based on standardized healthcare interventions. Medical information management is supported by the introduction of information systems aligned to the standardized processes as well as the introduction of classifications or codifications of certain information types like diseases (based on ICD), medical interventions, lab exams, biomedical equipment & consumables. Hospital information systems (HIS) are used to capture and process all information related to the administrative as well as the medical aspects of a patient event. A patient record is created which stores all the patient history, structured per event. A datamart monitoring the inpatient and outpatient service could be based on data retrieved from the HIS database. In a dimensional model it would store the dimensions involved in the service: Patient, Date, Healthcare Unit and Department, exit DRG (diagnosis related grouping) group, Diagnosis (based on ICD), Medical intervention based on selected codification, pharmaceutical treatment, medical material used, and capture all cost related facts in the fact table. The star schema captures information related to an inpatient event, which normally may last few days. In order to capture the whole lifecycle of the event, an accumulating snapshot fact table is used, as shown in the figure (check link below). Based on this star schema, a wide range of analytical tasks can be carried out. Analysis related to medical treatment of a specific event (indicatively):

Produce a medical history report on a patient
Produce stats on morbidity by restricting on specific ICD codes (e.g. frequency of an ICD as a percentage of total events, ICD related to demographic info like age or educational level)
Analyse the relation of medical interventions to ICD & DRGs, by restricting on specific DRGs
Mortal events per ICD / DRG (this can be coded in a specific Exit_diagnosis value)

Analysis related to cost incurred by a specific event (indicatively):

Analysis on the average length of stay (ALOS) per DRG as well as per Patient demographics.
Analysis on the medical material & consumables cost related to a medical intervention
Analysis on the medical material & consumables cost related to an event of specific DRG
Analysis on the pharmaceutical cost related to an event of specific DRG
Delays in payment and collection levels

Department related analysis:

Number of treatment events / medical interventions per Department
comparison of same specialty Departments

The star schema could also capture the involvement and performance of medical Professionals. In addition it could capture many more facts related to the event like manhours spent by the Doctor in charge, by the other professionals involved. The datamart can be linked to the datamart of another Hospital or Healthcare system, if the two use conformed dimensions and facts. Standardized codifications (like ICD) aim at achieving this conformance, in order to be able to consolidate information at the regional, national and international level. Why develop the star schema, instead of querying directly the Hospital Information System database. For two important reasons:

The star schema model is easily understandable by the Business Analyst
The analysis on the star schema is computationally more efficient (the symmetric structure’s simplicity allows for better query optimization)

Business of Analyzing a Business Analyst Salary

The profession of a business analyst has existed long ago. Although it may not have commanded much of a standing then, it is now fast becoming an essential element in any organization. In the event of a small establishment, the task is probably handled by the company head or owner working in close quarters with the sales and marketing team. Larger organizations tend to employ trained staff in specialized departments or sections. They handle the bulk of the job, analyzing trends, crunching numbers and churning out reports to be presented to the executive level.

To ascertain business analyst salary options, it is important to get yourself academically trained in the relevant area. Normally, most seek to study in the lines of business administration as well as business management. Achievers of computer science and information systems qualifications also make ideal candidates as this task requires one to delve in extensive usage of business software. Holding multiple degrees certainly increases your chances of commanding a better position on the salary scale, coupled with relevant years of experience. Being attached to reputable organizations work towards your favor as it embellishes your employment portfolio.

Some choices of career advancement may also be contributing factors towards a business analyst salary increase. Short of a promotion to a more senior position, you also have options to branch into other fields. Whether you are analyzing the business of financial services, insurance, investment banking, software development, healthcare or others, the principles remain the same. Hence, opportunities lie awaiting your decision to remain in the same line or make a change in the pursuit of new challenges and interests. Some of these job holders have also risen up the corporate ladder by utilizing their skills and talents, diverging into other vocations such as financial analysts, project managers and independent consultants.

When analyzing trends of employment between the genders, it is reasonable well spread. This sort of job requires one to possess analytical and detailed thought processes. Although both sexes demonstrate different wave lengths, macro and micro thinking work hand in hand to generate products of substance.