Fundamentals of Misys Query (Tiger and PM)

1. Fundamentals of Misys Query (Tiger and PM) Matthew Belardi August 2008

2. Agenda • What is Misys Query®? • What are the Misys Query products? • Misys Query Support • Misys Query Training experience, solutions, results 2

3. What is Misys Query? Cognos • Reporting Impromptu • Multidimensional Analysis PowerPlay • Dashboarding Visualizer experience, solutions, results 3

4. What is Misys Query®? Cognos • Reporting Impromptu • Multidimensional Analysis PowerPlay • Dashboarding Visualizer Licensing • Misys Query = Impromptu • PowerPlay = Impromptu + PowerPlay • Practice Pulse= Impromptu + PowerPlay + Visualizer experience, solutions, results 4

5. Reporting (Cognos Impromptu) Reporting Tool • Build and run custom reports • Access virtually any data in Misys Tiger®/PM™ database (also works with Misys EMR® and Misys Vision®) • Real-time data retrieval • Results can be saved to a variety of different file formats including Microsoft Excel • Licensed per PC (not per system) experience, solutions, results 5

6. Reporting (Cognos Impromptu) Reporting Tool includes • Cognos Impromptu • Catalog of data items in Misys Tiger/PMdatabase (Misys EMR and Misys Vision catalogs also available) • Cognos Scheduler (allows reports to be run unattended) • Over 100 pre-built reports (StarterKit reports) experience, solutions, results 6

7. Reporting (Cognos Impromptu) Database Misys Tiger/PM (or Misys EMR or Vision) Cognos Impromptu experience, solutions, results 7

8. Reporting (Cognos Impromptu) • Screenshot of custom Misys Tiger/PMreport experience, solutions, results 8

9. Reporting (Cognos Impromptu) • Skills used in building reports: 1. Understanding of Misys Tiger/PM application (or Misys EMR and Misys Vision) • File Maintenance, Charge Entry, Tiger/PM reporting 2. Basic Programming skills • Functions (e.g., number-to-string, totals, average, etc.) • Logical operators (e.g., AND, OR, less than, >=, etc.) • Conditional statements (e.g., if…then…else) experience, solutions, results 9

10. Reporting (Cognos Impromptu) • Technical complexity Programming Report-writing Spreadsheets Word Processing experience, solutions, results 10

11. Reporting (Cognos Impromptu) • Screenshot from Impromptu: Data tab To find data items for your report, you need to know the Misys Tiger/PM application. This is because the catalog is organized by the processes of Misys Tiger/PM experience, solutions, results 11

12. Reporting (Cognos Impromptu) • Screenshot from Impromptu: Building a Calculation Calculated data items are often defined using functions, e.g., years-between, number-to-string, etc. These must be syntactically correct. experience, solutions, results 12

13. Reporting (Cognos Impromptu) • Screenshot from Impromptu: Filter tab The Filter definition uses data items, operators, values, etc. to specify what information to retrieve. It must be syntactically correct. experience, solutions, results 13

14. Reporting (Cognos Impromptu) Training • 2 day classroom-based session (Raleigh or Pittsburgh) • 10 hours of i-Classes • 10 hours of pre-recorded i-Classes Support • Contact Misys Decision Support Services (DSS) at 1-800-877-5678 • Assist with installs, errors, and minor report modifications • Create custom reports (service fees applicable) experience, solutions, results 14

15. What is Misys Query? Cognos • Reporting Impromptu • Multidimensional Analysis PowerPlay • Dashboarding Visualizer Licensing • Misys Query = Impromptu • PowerPlay = Impromptu + PowerPlay • Practice Pulse= Impromptu + PowerPlay + Visualizer experience, solutions, results 15

16. Multidimensional Analysis (PowerPlay) Multidimensional Analysis Tool • Used for more complex data analysis • Explore business data • Table and graphical views of data • Data in a file called a cube (not Real-time data) • Refresh cube as needed • Results can be saved to a variety of formats experience, solutions, results 16

17. Multidimensional Analysis (PowerPlay) Multidimensional Analysis Tool includes: • Third-party applications • Cognos Transformer - Used to build Cube • Cognos PowerPlay- Used to analyze Cube • Several pre-built cubes (StarterKit Transformer models) experience, solutions, results 17

18. Multidimensional Analysis (PowerPlay) Database Database(s) Cognos Impromptu Misys Tiger/PM (or Misys EMR or Vision) Query Definition File(s) Cube Cognos Transformer Cognos PowerPlay experience, solutions, results 18

19. Multidimensional Analysis (PowerPlay) • Screenshots of Cognos PowerPlay views: cross-tab and bar chart experience, solutions, results 19

20. Multidimensional Analysis (PowerPlay) • Training • 1 day classroom-based session (Raleigh or Pittsburgh) • 2 hours of i-Classes • 2 hours of pre-recorded i-Classes • * Must first complete Impromptu® training Support • Contact Misys Decision Support Services (DSS) at 1-800-877-5678 • Assist with installs, errors, and minor cube modifications • Create custom cubes (service fees applicable) experience, solutions, results 20

21. What is Misys Query? Cognos • Reporting Impromptu • Multidimensional Analysis PowerPlay • Dashboarding Visualizer Licensing • Misys Query = Impromptu • PowerPlay = Impromptu + PowerPlay • Practice Pulse= Impromptu + PowerPlay + Visualizer experience, solutions, results 21

22. Dashboarding (Misys Practice Pulse™) Dashboarding (Misys Practice Pulse) • Views of key business data on one screen • Business data is stored in cubes • not real-time data • Refresh cubes as needed • usually automatically with Cognos Scheduler experience, solutions, results 22

23. Dashboarding (Misys Practice Pulse) Dashboarding (Misys Practice Pulse) includes: • Third-party application: Cognos Visualizer® • Several pre-built dashboards • StarterKit dashboards • 2 Self Based Training cds (CBT’s) • Fundamentals • Advanced experience, solutions, results 23

24. Multidimensional Analysis (PowerPlay) Database Database(s) Cognos Impromptu Misys Tiger/PM (or Misys EMR or Vision) Query Definition File(s) Cube(s) Cube(s) Cognos Transformer Cognos Visualizer® experience, solutions, results 24

25. Dashboarding (Misys Practice Pulse) experience, solutions, results 25

26. Reporting (Cognos Impromptu) Training • 2 Self Based Training cds (CBT’s) • Fundamentals • Advanced * Must first complete Impromptu® and PowerPlay® Training Support • Contact Misys Decision Support Services (DSS) at 1-800-877-5678 • Assist with installs, errors, and minor report modifications • Create custom dashboards (service fees applicable) experience, solutions, results 26

27. What is Misys Query? Cognos • Reporting Impromptu • Multidimensional Analysis PowerPlay • Dashboarding Visualizer Licensing • Misys Query = Impromptu • PowerPlay = Impromptu + PowerPlay • Practice Pulse= Impromptu + PowerPlay + Visualizer experience, solutions, results 27

28. Misys Query Central Access various training and support documentation View and access each of the Starter Kit reports Open the Various Cognos applications experience, solutions, results 28

29. Summary • What is Misys Query? • What are the Misys Query products? • Misys Query Support • Misys Query Training experience, solutions, results 29

30. Continuing Education through Misys AcademyVisit the Services booth in the Expo Hall today! Even experienced users often ignore, misuse, or under-utilize new technology and solutions Misys Academy • World class education • Available 24/7 • Learn at your own pace • Consistent training for all staff • Cost effective What is Misys Academy? • Misys Academy Subscription • Virtual Instructor-Led Classes • Classroom Instruction • 1 on 1 Phone Training Solutions • Manage staff turnover • Increase productivity • Improve self-sufficiency • Maximize return on investment Results 30 experience, solutions, results © 2008 Misys Healthcare Systems, L.L.C. All rights reserved