Business Intelligence Solution for UnivesitatsKlinikum AACHEN.

1. Business Intelligence Solution for UnivesitatsKlinikum AACHEN. Presented by: Fernanda Castillo Almeida HarikaJanagama Yakup Arslan Business Consulting Masters 2011

2. Agenda • Introduction / Overview • Business Case • KPIs • Roadmap / Project Management. • Reports.   • Lessons Learned (Conclusion) 

3. 1. Introduction. • Health is a complex area and is influenced by many factors outside of the provision of health services. • Hospitals must deliver high-quality care, comply with regulatory requirements and enhance patient satisfaction while trying to reduce costs and enhance efficiencies. • Hospitals looking to improve their clinical, operational and financial operations need to understand previous, present and future opportunities. • Business Intelligence provides this integrated view and enables decision makers to drill down and understand improvement opportunities within the hospital.

4. 2. Business Case. • The Klinikum Aachen, full German name "Universitätsklinikum Aachen" (University Hospital Aachen), abbreviated UKA, formerly known as "Neues Klinikum", is a very large hospital in Aachen(Germany). It is part of the RWTH Aachen and contains its whole medical faculty • The Klinikum Aachen contains many specialized clinics, theoretical and clinical institutes and other research facilities, lecture halls, schools for jobs in the medical field, and all facilities necessary for a hospital like a laundry and central sterilization • Health is a complex area and is influenced by many factors outside of the provision of health services • Hospitals looking to improve their clinical, operational and financial operations need to understand previous, present and future opportunities. • Gaining this level of understanding requires information about the hospital. Business Intelligence provides this integrated view and enables decision makers to drill down and understand improvement opportunities within the hospital.

5. 2. Business Case.

6. 2. 1. Objetives. • To integrate data previously dispersed in clinical, financial and operational systems • To provide users with more accurate insights into key areas such as service-line spending, quality of care and organizational performance. • Developed a Business Intelligence solution for a Healthcare management through useful KPI’s, resulting in improved Patient satisfaction and better care by reducing costs for the Management

7. 3. KPIs.

8. 4. Road Map.

9. 4.1. Dimensions. Status ID Patient ID Insurance ID Dimensions Section ID Disease ID Rooms ID Medical Proceedures ID

10. Patient_ID Rooms_Id Disease_Id Patient_ID Name Country City Gender DOB Rooms_ID Room_Number Description Disease_Id Disease_Name Time_ID Fact Table Insurance_ID Time_ID Date Hour Time_ID Patient_ID Type_ID Insurance_ID Section_ID Diseases_ID Rooms_ID Patiente Number Duration Time Insurance_ID Insurance_Name Section_Id Section_ID Section_name Type_ID Status Mprocedures_Id Mprocedures_Name Type_ID Medical_Procedures_Id 4.2. Start Schema.

11. 4.3. Key Figures.

12. 4.4. 1. InfoObjects (KF).

13. 4.4. 2. InfoObjects (CH).

14. 4.5. Uploading Master Data from Excel Sheet .

15. 4. 6. InfoCube.

16. 4.7. Transformation.

17. 4.8. Formula.

18. 4.9. Data Flow.

19. 4.10. Master and Transactional Data.

20. 5. Reports. General Report

21. 5.2. Patient’s Health Insurance.

22. 5.3. Patient’s Death Rate per Disease.

23. 5.4. Patient’s most common Diseases.

24. 5.4. Patient’s most common Diseases.

25. 5.5. Average of Hospitalization time per Medical Procedure and Disease.

26. 5.6. Occupancy of Rooms.

27. 6. Lessons Learnt. • First understand the Dimensions and its Attributes carefully • Don‘t forget to activate all the Objects immediately after creating • Take the datas which are needed, according to the KPI‘s • You can‘t do the right thing without doing the wrong.

28. Questions. ?