QUALITY IN QUALITY OUT ENSURING DATA QUALITY FOR

QUALITY IN QUALITY OUT ENSURING DATA QUALITY FOR SUCCESSFUL FINANCIAL AND CLINICAL REPORTING PRESENTED BY RUSSELL TINKHAM DIRECTOR OF DATA WAREHOUSING AND BUSINESS INTELLIGENCE WESTERN RESERVE HOSPITAL SYSTEM RTINKHAM@WESTERNRESERVEHOSPITAL. ORG

DATA QUALITY Are you satisfied with the quality of your data? Are you able to say what percent of your data is high quality? Are people in your organization held accountable for poor quality data? Is there a person, or department, in your organization whose primary responsibility is data quality?

WHAT IS QUALITY? Quality is Defect Free

WHAT IS QUALITY? Conforms to Specifications

WHAT IS QUALITY? Suited to Purpose

WHAT IS QUALITY? Meets Expectations

WHAT IS QUALITY? Defect Free Conforms to Specifications Suited to Purpose Meets Expectations Understanding expectations and purpose Defining specifications Deliver defect free products

WHAT IS DATA QUALITY? Correctness Accurate, precise, complete Integrity Relational, unique identities, logging Timeliness Create and analyze timely Value Aligns with organization goals Usability Access, ease of use, understandable Communication Effective knowledge transfer

DATA QUALITY LIFECYCLE Data Profiling What data is important to our organization? What are expectations and purposes for the data? What are the data specifications? Data Quality Assessment How to measure data quality? What’s the root cause? Don’t fix symptoms. Data Quality Initiatives How do we fix the root cause? How do we clean what is already there? Data Quality Processes How to monitor and fix data quality issues after project is complete? How do we maintain accountability for data quality?

DATA QUALITY SCENARIO Craft a population health initiative using BMI, BP, RBC and Specific Gravity from Urinalysis. Correctness Weight 3% Height 7% BP 4% RBC 6% Specific Gravity 3% Minimum Effect 7% Maximum Effect 23%

DATA QUALITY SCENARIO Craft a population health initiative using BMI, BP, RBC and Specific Gravity from Urinalysis. Correctness 7% 23% Integrity 15% 19% Duplicate Patients 0. 5% Labs not Mapped 3. 5% Lab Data in Notes 15%

DATA QUALITY SCENARIO Craft a population health initiative using BMI, BP, RBC and Specific Gravity from Urinalysis. Correctness 7% 23% Integrity 15% 19% Timeliness 5% 5% Labs needing reviewed greater one year 5%

DATA QUALITY SCENARIO Craft a population health initiative using BMI, BP, RBC and Specific Gravity from Urinalysis. Correctness 7% 23% Integrity 15% 19% Timeliness 5% 5% Value 0% 0% Usability 5% 5% You need to combine the results of 5 reports into one Excel spreadsheet and combine data using a VLOOKUP function by patient name. 5%

DATA QUALITY SCENARIO Craft a population health initiative using BMI, BP, RBC and Specific Gravity from Urinalysis. Correctness 7% 23% Integrity 15% 19% Timeliness 5% 5% Value 0% 0% Usability 5% 5% Communication 0% 0% Total 15% 52% 33. 5%

DATA QUALITY SCENARIO Craft a population health initiative using BMI, BP, RBC and Specific Gravity from Urinalysis. Root Cause Analysis Why are BP data in Height data? People are typing in the wrong field Why the wrong field? Templates have the fields reversed Why are the template fields reversed? Different people make different templates with no design standards

DATA QUALITY RESPONSIBILITY Is there a person, or department, in your organization whose primary responsibility is data quality? Are people in your organization held accountable for poor quality data? Are data quality projects coordinated or competing?

DATA GOVERNANCE Data Governance is a system of decision rights and accountabilities for information-related processes, executed according to agreedupon models which describe who can take what actions with what information, and when, under what circumstances, using what methods. http: //www. datagovernance. com/defining-data-governance/

DATA GOVERNANCE http: //its. yale. edu/about/its-leadership-and-organization/organization-within-its/office-cto

DATA GOVERNANCE MATURITY MODEL http: //blogs. sas. com/content/datamanagement/2014/09/29/the-celebrity-of-data-big-data-goes-big-time-in-yourorganization/

SUMMARY Quality Data Quality Defect Free Correctness Conforms to Specifications Suited to Purpose Governance Integrity Data Stewardship Timeliness Data Management Value Meets Expectations Data Governance Compliance Usability Communication Profiling Assessment Initiatives Processes

THANK YOU PRESENTED BY RUSSELL TINKHAM DIRECTOR OF DATA WAREHOUSING AND BUSINESS INTELLIGENCE WESTERN RESERVE HOSPITAL SYSTEM RTINKHAM@WESTERNRESERVEHOSPITAL. ORG