Reporting on Steroids: Alternatives to Cognos Impromptu

2. Reporting on Steroids: Alternatives to Cognos Impromptu Kenneth N. Sable, MD, FACEPVice Chairman for Operations, Department of Emergency Medicine, Maimonides Medical Center

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

4. 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

5. 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

6. 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!

7. 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

8. 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

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

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

11. 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

12. Daily Dashboard 12

13. Daily Dashboard 13

14. Daily Dashboard 14

15. Daily Dashboard 15

16. Daily Dashboard 16

17. Daily Dashboard 17

18. Daily Dashboard 18

19. Daily Dashboard 19

20. Daily Dashboard 20

21. 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

22. Automated Dynamic Reports Rapid HIV 22

23. Automated Dynamic Reports Central Lines 23

24. Automated Dynamic Reports Pediatric Cultures 24

25. 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

26. Managing Incomplete Board 26

27. Managing Incomplete Board 27

28. 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