Transcript Extracting and Using CDS Data

Extracting and Using
CDS Data
Dolores Hagan, RN, BSN
K-HEN Education/Data Manager
Kentucky Hospital Association
Objectives
Upon completion of this activity, the participant
will be able to:
1. Demonstrate how to access data tables and
graphs in the Comprehensive Data System
(CDS)
2. Export data tables from CDS to Excel
3. Export run charts from the CDS and insert
them into a Progress Report
4. Use Excel tools for creating charts and graphs
5. Prepare HEN data for reporting to others
Accessing CDS Data
1. Select Reports tab
2. Select Topic
3. Select
Measure
Data Table
Data by month appears in data table
Exporting Data
Exporting Data
• Click on ‘Export to Excel’ button
• Select ‘Open’
• Warning message appears
– Select ‘Yes’
– Opens the file as an html file
– Select File Save As and save the file as an
Excel spreadsheet in your preferred location
Exporting Charts
Select Chart Tab
Print or Download Options
Exporting Charts
Select ‘Measure Comparison’
Downloading Charts
• Click on the Download button
• Two choices
– Download PNG image
– Download PDF document
• PNG Image (portable network graphic)
– Select ‘Open’ or ‘Save’
• May open the image with Paint and add
annotations, then insert into Progress Report
• If select ‘Open’, can Right-click and copy, then
paste directly into your Progress Report
Useful Tools
Tools from HRET and Cynosure Health are now
available on the K-HEN website at the following
link under ‘Other Tools’:
http://www.k-hen.com/ToolsandResources.aspx
• Days Between Events Template
– Useful for tracking and graphing infrequently
occurring events
• HRET Calculator spreadsheet and
Instructions
– Useful for presenting the potential ROI and
harm reduction of your efforts.