Effective Analysis

1
Effective Analysis

• Nabila S. Riskalla, MPH
• Lahey Clinic Medical Center
• Burlington, Massachusetts

2
Ingredients of Effective Analysis

• Requirement (Need)
• Clear understanding of the requirements
• Complete Accurate Data for Analysis
• Resources (Dedicated and Committed Staff)
• Analytical Tool
• Click Perform Analysis, sit back, relax and it
  is DONE (Isnt that easy!!!)

3
Not So Easy??? Sure Can Be

• Make sure you have everything you need for your
  Report
• If NOT ask for it (I did)
• For Example We defined/designed the ACC score
  elements which are frequently required in our
  reports
• Complex Reports Ask Cedaron for Flash Reports

4
Cedaron Outcomes Analysis Tool

• Improved Tree Selections
• Flexible and Intuitive (Reduced report selection
  time)
• Enhanced Query Builder
• Create reports with complex AND/OR filter
  criteria
• Other Operators also available for numerical
  comparison (lt, gt, lt, gt, etc.)
• Patient Demographics Scores
• New ACC scores are useful in Ad-Hoc reporting
• Patient Demographics can be added to output
  reports
• Flash Reports
• Extremely useful canned reports

5

• Cedaron added Custom Scores (Pre-Calculated
  Values) to Facilitate Reporting/Analysis
• These Score can be selected as Parameter,
  Cross-Tab, Filters and Time-Frame

Select SCORES along with other fields/elements
for reporting
6
Lesions Attempted Count (Benefits)

• Selecting correct number of Lesions
• Filter on the Lesion Count

(Number of Lesions Attempted)
7

• Only need to select as many lesion data as the
  Maximum Lesion Attempted
• Saves Time Effort
• Reduced Report Size ( of columns)

(Lesion Data Based On Lesions Attempted)
8

• ACC does not have Age _at_ Procedure calculated
  value
• Age Today not sufficient for Analysis
• Extra effort to calculate Age _at_ Procedure (in
  Excel) every time
• Age Calculation in Excel
• Date of Procedure Date of Birth (gives only
  Year difference) Ignores Months/Days
• (Difference In Days)/365 is also not absolutely
  correct
• Cedaron Calculated Age _at_ Procedure
• Accurate
• Easy to select (for reporting)
• Can Filter too

(Age At Surgery/Procedure)
9
My Favorite TAB Query Builder

• Intuitive
• Powerful
• Easy
• Effective
• Above ALL Feels like Im
• IN CHARGE

(Query Builder)
10
FLASH Report

• Canned Report Per User Specification (even
  formatting)
• User defines itCedaron ships it
• Complex Periodically Run Reports go here

(Complications By Physician)
11
Conclusion

• Effective Efficient Analysis comes with
• Good report understanding
• Asking the right questions (from the tool)
• Using Query Builder (create your own complex
  reports)
• Flash Reports (whenever necessary)
• Defining custom fields/calculated values of the
  most frequently asked queries

12
Discussion