1 / 13

Integrated Health System Planning

Integrated Health System Planning. An exclusive Executive Circle Briefing. Mount Sinai Hospital. Patient Care, Research & Teaching Hospital Established in 1923 Serve 134,000 Patient Days/year 3,200 Full & Part Time Staff. Mount Sinai Hospital (Toronto). Scorecard Goals:

donaldburnett
Download Presentation

Integrated Health System Planning

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Integrated Health System Planning An exclusive Executive Circle Briefing

  2. Mount Sinai Hospital • Patient Care, Research & Teaching Hospital • Established in 1923 • Serve 134,000 Patient Days/year • 3,200 Full & Part Time Staff

  3. Mount Sinai Hospital (Toronto) Scorecard Goals: • Strategic Alignment of Priorities • Performance Measurement • Enterprise-Wide Communication Scorecard Measures: • Patient/Family Centered Care and Service Delivery (Customer) • Learning and Innovation (Learning and Growth) • Organizational Safety and Organizational Efficiency and Growth (Financial).

  4. Challenges • Create corporate balanced scorecard by manually collecting data from 10 different systems • Time consuming and prone to error • Relies on spreadsheets and e-mails • Result in a single page document, delivered to board of directors • Scorecard not available to all staff • No ability to drill down into the details to explain the results

  5. Pilot Implementation Corporate Scorecard created using Business Scorecard Manager 2005 • Data feeds manually from databases and spreadsheets into Scorecard • Scorecard displayed in SharePoint Portal 2007and available to all staff • Some drill-down capability to investigate deeper into the data using Excel

  6. Future Solution • Automated data feeds from source systems into Business Scorecard Manager 2005 • Full set of indicators exposed in SharePoint • Significant reduction in time to create the scorecard • Reduced risk of errors • More timely data • Data available for deeper analysis by multiple departments

  7. Original Scorecard

  8. Original Case Mix Analysis

  9. Business Scorecard Manager

  10. Next Steps • Investigate a broader SQL 2005 data warehouse strategy • Increase the automation of the data collection • Implement the full set of scorecards • Integrate more Office 2007 into the solution • Excel Server • Look at departmental reporting needs

  11. Case Mix Analysis in Excel 2007

  12. Case Mix in Excel Services

  13. Thank you for your attention.

More Related