1 / 28

Reporting on Steroids: Alternatives to Cognos Impromptu

Reporting on Steroids: Alternatives to Cognos Impromptu. Kenneth N. Sable, MD, FACEP Vice Chairman for Operations, Department of Emergency Medicine, Maimonides Medical Center. Presentation Outline. Who Are We? What Are We Trying to Do? Cognos : The Good and Bad Custom Reporting Framework

efia
Download Presentation

Reporting on Steroids: Alternatives to Cognos Impromptu

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. Reporting on Steroids: Alternatives to Cognos Impromptu Kenneth N. Sable, MD, FACEPVice Chairman for Operations, Department of Emergency Medicine, Maimonides Medical Center

  2. Presentation Outline • Who Are We? • What Are We Trying to Do? • Cognos: The Good and Bad • Custom Reporting Framework • Real Applications • Questions?

  3. Who Are We? • Kenneth N. Sable, MD, FACEP • Vice Chairman for Operations • University of Pennsylvania, Bachelor’s Degree in Computer Science and Engineering • Corey M. Weiner, MD • Director, Division of Medical Informatics • Duke University, Bachelor’s Degree in Biomedical Engineering

  4. What Are We Trying to Do? Your Allscripts ED database contains a wealth of data that can be effectively and efficiently mined to improve: patient care, administrative management, and financial operations With some creativity and the right tools, you can take full advantage of your vast data warehouse that is Allscripts ED Focus on patient safety, quality assurance, performance metrics, and mitigating liability and risk 5

  5. What Are We Trying to Do? • Create an automated, graphical dashboard for key performance metrics for daily distribution to clinical and administrative leadership • Create automated, dynamic reports to assist quality assurance and improvement activities • Automate process of managing both physician and nursing signoff for the Incomplete Board!

  6. Cognos: The Good and Bad • Our experience with Cognos Impromptu • Pros: • Catalog provides user-friendly method of generating SQL queries • Cons: • Still on version 7.0 in Allscripts ED • Output limited to PDF format within Allscripts ED • No ability to add URL or other dynamic content • Slow to process

  7. Custom Reporting Framework • Custom reporting framework • Pros: • Allows for maximal customization and control • Fast to process • Increased flexibility to meet future demands and requirements • Cons: • Requires a fair amount of technical background

  8. Technology Perl: Practical Extraction and Report Language SQL functions and procedures Google Charts API Reporting Formats: XLS, CVS, PDF 9

  9. Real Applications • Daily Dashboard • Automated Dynamic Reports • Managing Incomplete Board

  10. Daily Dashboard Goals: • Automated and consistent measurement and delivery of key performance indicators (KPI) to department staff and hospital leadership • Proactive monitoring for trends affecting clinical, non-clinical, and financial operations • Increase overall transparency of ED operations 11

  11. Daily Dashboard 12

  12. Daily Dashboard 13

  13. Daily Dashboard 14

  14. Daily Dashboard 15

  15. Daily Dashboard 16

  16. Daily Dashboard 17

  17. Daily Dashboard 18

  18. Daily Dashboard 19

  19. Daily Dashboard 20

  20. Automated Dynamic Reports Goals: • Deliver focused, customized reports to support both internal and external clinical and financial operations (Internal Medicine, Orthopedics, Durable Medical Equipment) • Increase efficiency in specific patient care activities (Rapid HIV, Stress Tests, Congestive Heart Failure) • Assist with hospital-wide quality assurance and improvement activities (Central Lines, Pediatric Cultures, Domestic Violence) 21

  21. Automated Dynamic Reports Rapid HIV 22

  22. Automated Dynamic Reports Central Lines 23

  23. Automated Dynamic Reports Pediatric Cultures 24

  24. Managing Incomplete Board Goals: • Automate the process of tracking and notifying physicians and nurses about remaining charts on the incomplete board after a defined period of time • Mitigate liability and risk from incomplete charts • Improve CQI • Improve cash collections by faster turnaround times on entire coding/billing process 25

  25. Managing Incomplete Board 26

  26. Managing Incomplete Board 27

  27. Questions? • Kenneth N. Sable, MD, FACEPksable@maimonidesmed.org718.283.1419 • Corey M. Weiner, MDcweiner@maimonidesmed.org718.283.8661 • Emil Soleyman-Zomalan, MD esoleyman@maimonidesmed.org

More Related