Applicatieplatform congres 12 & 13 maart

1. Applicatieplatform congres12 & 13 maart

2. Business Intelligence Proactive service by using BI Erik Zeldenrust Program Manager Radar Philips Healthcare

3. Agenda Philips Healthcare Understand the Business Process Overall Architecture Radar Netforum

4. Royal Philips One of the largest global electronics company with sales in 2007 of EUR 27 billion (Healthcare 6.7 billion) Multinational workforce of 124.000 employees Active in the areas of medical systems, domestic appliances and personal care, consumer electronics and lighting Present in over 60 countries Healthcare Lifestyle Technology

5. Product Lines in Philips Medical Systems MR NuclearMedicine General X-RAY CT Cardiovascular Ultrasound Patient Monitoring Healthcare Informatics

6. Agenda Philips Healthcare Understand the Business Process Overall Architecture Radar NetForum

7. Service delivery and reliability Hospitals are facing: Budget constraints, staff shortages and turnover Increased number of patients, waiting lists Results in increased focus on productivity, ROI and skill management Extended operational hours Increased number of patient cases Harmonized user interfaces to downsize necessary training Customer expectations on the systems Improved productivity of the delivered equipment and services Need for up-time/availability of the system (Higher system endurance / quality – MTBF) Skill management of hospital employees (effective application training concepts  leadership in services) Pushing product support service to fringes of the day, during nights or in weekends

8. Key Performance Indicators for Medical Systems • Call rate (Customer Call avoidance by pro-active maintenance) • ETTR (Elapsed Time To Repair) • MTTR (Mean Time To Repair) • FTF (First Time Fix Rate) • FCO (Field Change Order) cost • Upgrade Cost • Planned Maintenance cost

9. Change of service delivery process • From Reactive • towards • Proactive / Predictive

10. Re-active support Tier 1 FSE FEDEX System Fails! SSD FSE

11. Pro-active/ Predictive support Tier 1 FSE System notifies Philips Remote fix 1 Pro-active / Faster resolution / Improved uptime

12. Agenda Philips Healthcare Understand the Business Process Overall Architecture Radar NetForum

13. Overall Architecture Clarify CRM System SAP ERP System FAULT MONITORING INTEGRATED SYSTEMS RSN Data Center CCC/BU Admin SW DISTRIBUTION Launchpad & service apps M2M Enterprise Citrix CCC/RTAC Support Specialist REMOTE DIAGNOSTICS Remote Services Network REMOTE MONITORING PSA PSA PSA HCF-B HCF-C HCF- A

14. Agenda Philips Healthcare Understand the Business Process Overall Architecture Radar NetForum

15. Radar RADAR is an acronym for Remote Application for Diagnostics Analysis and Reporting and provides an infrastructure for all Business Units and Service organizations to gather daily log files containing error and performance information from thousands of systems, aggregated with Business Information and provide one common Microsoft reporting and Archiving infrastructure to our internal and external customers. • Build on the Microsoft platform using: • .NET 3.5 • SQL Server 2005/2008 • SSAS (OLAP & Data Mining) • SSIS/ Scripting • Reporting via: • MS Reporting (SSRS) • .Net & Dundas • Proclarity & Performance Point and Excel 2007 • Pilot Report builder • Monitored by • SCOM

16. Target groups Proactive monitoring mainly Development and Service Imaging modality users: Customer Care Centre employee, Developers (of clinical systems), Helpdesk employee, Service innovations employee, Third party (e.g. supplier clinical components and material helium level), Marketing, Field service engineers, Customer Service directors.

17. Datafile Transfer RSN Zipfile 1 3 Zipfile 2 Zipfile 2 Not Used 2 Commands User Messages Information 1 New Entries Stored Stored • Agreement with the Hospital. • Never Patient related information • Batch wise once a day • On Demand 15 minutes Event Log Medical Device Microsoft OS

18. Some figures 1 Medical System = Large Server (Microsoft 2003, SQL Server) 1 Medical System can store 10 events per ms. > 4000 Medical Systems connected (45.000 planned) Log files Storage ( > 100.000 log files a month) Total amount of files > 20 TB unzipped OLTP and DWH (> 2 TB) >10 milj records upload a day DWH contains bilj. records 24 hours/7 days a week operational

19. Radar and BI Interactivity/Complexity SSAS and Excel/Prom Data/Process Mining < 1% Analysts Proclarity/Excel/Minitab 5-10% Information Explorers 15-25% PerformancePoint/Excel 65-80% Information Consumers Reporting Services/.Net

20. Radar Architecture RADAR DWH RADAR Operational

21. Radar DWH SCOM • SSIS • SQL Server Integration Services Business Intelligence Domain Extract Transform Load Domain (ODS) Data Warehouse Domain Share Point Cube Generation Domain Sources Cube Performance Point SSRS Proclarity SSAS Server Others SQL Server 2005/2008 Excel 2007

22. Radar and BI

23. Radar and “BI” (Raw Files)

24. Monitoring Example: MR He+ boil off

25. Radar and BI (PDF)

26. Radar and BI (Mail Alert)

27. Radar and “real” BI

28. SharePoint with Excel Services

29. Excel Excel is becoming more and more important for Radar users due to: Self Service and Off Line Reporting Forecasting algorithms for proactive BI Flexibility with > 300.000 records Direct connection with the Radar database (Single point of truth) Statistical and data mining functionality.

30. Radar and other BI tooling

31. Radar and other BI tooling

32. Radar and “non” BI Complex workflows around knowledge base Web Service enabled

33. Workflows and Reporting Screen clipping taken: 2009-02-22, 3:53 PM

34. Who/What is Monitoring Radar ? Monitoring IT Processes Hardware Storage ETL Processes Monitoring Web Usage Top 10 Reports Web Performance Usage

35. Radar Application monitoring via SCOM

36. Proactive Monitoring Web Performance

37. Proactive Monitoring Web Usage

38. Agenda Philips Healthcare Understand the Business Process Overall Architecture Radar NetForum

39. Why Pro Active Monitoring in Hospitals ? For Example: 250 Work days 12 Patients per day +1%Uptime = 30more patients

40. NetForum Delivering a win-win proposition for Philips Healthcare and its customers; providing invaluable information for hospitals and Clinical Image Centers for two user groups being; End users Radiologists, Cardiologist, Senior Clinicians etcetera Have to cope with the advanced and specialist nature of the equipment. Product owners CEO, COO, financial managers etc Are forced to perform sophisticated financial planning and calculated decision making to deal with: Significant investments (0.5 - 1.2 M€) Long lifetimes (8 - 12 years),

41. NetForum End users need: Clinical information exchange and education ExamCard exchange and direct download Application and product training Easy Web-enabled access Product owners need: Insight how the scanner can upgraded to the latest technology Ability to try and buy SW options and coils Detailed insight how the scanner is used Information and support to identify and implement improvements and proactive monitoring of the usage

42. Netforum Collaboration

43. Netforum Reporting

44. Hospital specific reports

45. Hospital specific reports

46. Benchmark

47. Benchmark

48. Why Microsoft for Remote Monitoring Philips Healthcare is one of the largest SQL Server consumers MS Software installed on the medical systems Integration of the software on the medical systems and remote service applications in Philips Healthcare License costs, Development costs and Maintenance costs (DBA) Microsoft developers are easy to find, so projects are easy to scale One Microsoft BI Developer can develop the whole IT chain (ETL, DWH/OLAP and Reporting) Time to market is very short (pilots) MS tooling has proven to be scalable for a large amount of data ( DWH > 1.000.000.000 records) Excellent End user Performance Open environment (non MS tooling as statistical and data mining tooling) is critical for development of systems User experience

49. Bedankt voor uw aandacht