Data Quality

Question 1

IT SIGNIFIES THE DATA’S APPROPRIATENESS TO SERVE ITS PURPOSE IN A GIVEN CONTEXT

Answer 1

Data Quality

Question 2

Is the overall utility of a dataset(s) as a function of its ability to be processed easily and analyzed for a database, data warehouse, or data analvtics system

Answer 2

Data Quality

Question 3

Data Quality

Used in the areas of:

Answer 3

Customer relationship management
(CRM)
Data integration
Regulation requirements

Question 4

generates costs, affects customer satisfaction, company reputation, and even strategic decisions of the management

Answer 4

Poor data quality

Question 5

A tool that allows the use of small random samples (19 sxs) to distinguish between different groups of data elements (or lots) with high and low data quality

Widely applied in the health care industry for decades and has been used for quality assurance of products

Answer 5

Lot Quality Assurance Sampling (LQAS)

Question 6

• Smallest sampling size to use and still become statistically accurate. Samples that are more than____ are more expensive while sampling size less than___ is not accurate.

Answer 6

19 sxs

Question 7

is adopted in the context of District Health Information System (DHIS) data quality assurance (DQA)

Answer 7

Lot Quality Assurance Sampling (LQAS)

Question 8

Formula for report timeliness rate

Answer 8

= # of on-time reports / total # of
reports for that section x 100

Question 9

Level of acceptable error =

Answer 9

70% +/-10% (60 - 80%)

Question 10

• It is a simplified version of the Data Quality Audit (DOA) tool which allows programs and projects to verify and assess the quality of reported data

Answer 10

Routine Data Quality Assessment (RDQA)

Question 11

Rapidly verify the quality of reported data

Implement corrective measures with action plans for strengthening data management and reporting system and improving data quality

Answer 11

RDQA

Question 12

EXAMPLE: DENGUE PREVENTION AND CONTROL
PROGRAM IN MINDANAO
• External auditors are important to check for flaws in the system and their visits can be more frequent, more organized, and less resource intensive to benefit the institution at the end of the day

Answer 12

RDQA

Question 13

• A project management tool that illustrates how a project is expected to progress at a high level

• Important in ensuring the efficient flow of communication between those involved in the project

• Minimize issues that would delay delivery of the project

Answer 13

Development Implementation Plan

Question 14

TOOLS THAT ARE CRUCIAL IN MAINTAINING ACCURACY & RELEVANCY IN HEALTH INFORMATION

Answer 14

Data Quality Tools

Question 15

• Analyzes information and identifies incomplete or incorrect data

Answer 15

Data Quality Tools

Question 16

• removing of abnormalities of data or repeated information

Answer 16

Data cleansing

Question 17

By maintaining________, the process enhances the reliability of the information used by an organization

Answer 17

data integrity

Question 18

• Decomposition of fields into component parts and formatting the values into consistent layouts based on industry standards and patterns and user-defined business rules

Answer 18

Parsing and standardization

Question 19

Is the modification of data values to meet domain restrictions, constraints on integrity, or other rules that define data quality as sufficient for the organization

Answer 19

Generalized cleansing

Question 20

Identification and merging of related entries within or across data sets

Answer 20

Matching

Question 21

Refers to the analysis of data to capture statistics or metadata to determine the quality of the data and identify data quality issues

Answer 21

Profiling

Question 22

Refers to the deployment of controls to ensure conformity of data to business rules set by the organization

Answer 22

Monitoring

Question 23

Enhancement of the value of the data by using related attributes from external sources such as consumer demographic attributes or geographic descriptors

Answer 23

Enrichment

Question 24

PROBLEM SOLVING METHOD THAT IDENTIFIES THE “ROOT CAUSE” OF PROBLEMS OR EVENTS INSTEAD OF SIMPLY ADDRESSING THE OBVIOUS SYMPTOMS.

Answer 24

Root Cause Analysis

Question 25

• Aims to find various modes of failure within a system and addresses the following questions for execution: • What is the mode in which an observed failure occurs? • How many times does a cause of failure occur? • What actions are implemented to prevent this cause from occurring again? • Are these actions effective and efficient?

Answer 25

Failure Mode and Effects Analysis (FMEA)

Question 26

• Uses the Pareto principle (80/20 rule) which states that roughly 80% of the effects come from 20% of the causes

Answer 26

Pareto Analysis

Question 27

• • • Used when there are multiple potential causes to a problem Created using Excel software Lays down potential causes in a bar graph Tracks the collective percentage in a line graph to the top of the table

Answer 27

Pareto Analysis

Question 28

is a form of algebra which is centered around three simple words known as Boolean Operators: "Or," "And," and "Not".

Answer 28

Boolean Logic

Question 29

• Uses Boolean logic to determine the root causes of an undesirable event

Answer 29

Fault Tree Analysis

Question 30

• Idea that all values are either True or False • Used in risk and safety analysis A single undesirable event is listed at the top the tree • All potential causes are listed down to form the shape of an upside down tree

Answer 30

Fault Tree Analysis

Question 31

Used when the root causes of multiple problems need to be analyzed all at once Problems are listed first followed by the potential cause for a problem (Undesirable Effects or UDEs) By doing so, a cause common to all problems will appear

Answer 31

Current Reality Tree (CRT)

Question 32

• Also called the Ishikawa or cause-and-effect diagram • Shows the categorized causes and sub-causes of a problem • Useful in grouping causes (e.g. people, measurements, methods, materials, environment, machines) into categories

Answer 32

Fishbone Diagram

Question 33

• Breaks a problem down to its root cause by assessing a situation using priorities and orders of concern for specific issues • Various decisions to address problem are outlined to ensure that actions recommended are sustainable

Answer 33

Kepner-Tregoe Technique

Question 34

• Diagnoses the causes of recurrent problems by following the 3 phases: a. ________- data gathering and analysis of findings b._________ creation of diagnostic plan and identification of the root cause through careful analysis c.______ - fixing the problem and monitoring to confirm and validate if the root cause was correctly identified

Answer 34

Rapid Problem Resolution (RPR Problem Diagnosis) Discover Investigate Fix