Data Quality

Data quality tool

Analyzes information and edintifies incomplete or incorrect data.

Generalized "cleansing"

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

District Health Information System

LWAS was adopted in the context of?

Routine Data Quality Assessment (RDQA)

it aims to strengthen their data management and reporting system

Schedule Milestone

Key component of an implementation plan that outlines the high level schedule in the implementation phase

Parsing and Standardization

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

Matching

This is the identification and merging related entries within or across data sets

Enrichment

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

Kepner-Tregoe Technique

It is also known as a rational process intended to break a problem down to its root cause.

RPR Problem Diagnosis

It deals with diagnosing the causes of recurrent problems. This has three phases; discover, investigate, ans fix.

Data Quality

Is the overall utility of a database as a function of its ability to be processed easily and analyzed for a database, data warehouse, or data analytics system.

Lot Quality Assessment Sampling (LQAS)

Is a tool that allows the use of small random samples to distinguish between different groups of data elements or Lots with high and low data quality

Routine Data Quality Assessment Tool (RDQA)

Is a simplified version of the Data Quality Audit (DQA) which allows programs and projects to verify and assess the quality of their reported data.

Verify rapidly, implement, and monitor

What are the objectives of RDQA?

Implementation Plan

is a project management tool that shows how a project will evolve at a high level. It helps ensure that a development team is working to deliver and complete tasks on time.

Goals/Objectives

Key components of an Implementation plan that answers the question "What do you want to accomplish?"

Allocate Resources

Key component of an implementation plan that determines whether you have sufficient resources and decide how you will procure what's missing

Designate Team member responsibilities

Key component of an implementation plan that create a general team plan with overall roles that each member will play

Define Metrics for success

Key component on an implementation plan that defines how you will determine if you have achieved your goal

Profiling

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

Monitoring

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

Root cause analysis

Is a class of problem solving methods aimed at identifying the root causes of the problems or events instead of simply addressing the obvious symptoms.

Root cause analysis

Aims to improve the quality of the products by using systematic ways in order to be effective

Pareto anaylsis

Operates using pareto analysis principles (20% of the work creates 80% of the results). You will want to run this any time when there are multiple potential causes to a peoblem

Fault tree analysis

Uses boolean logic to determine the root causes of an undesirable event. This technique is usually used in risk analysis and safety analysis.

Current tree reality

This technique analyzes a system at once. It would be used when many problems exist and you want to get to the root causes of all the problems.

Fishbone or Ishikawa or Cause-and-Effect Diagrams

This technique will group causes into categories including people, measurements, methods, materials, environment, machines.

Fishbone or Ishikawa or Cause and effect diagrams

People, Measurements, Methods, Materials, Environment, Machines

Parsing and standardization, generalized cleansing, matching, profiling, monitoring, enrichment

What are the data quality tools used to address the data quality problem?

Goals/Objectives, Schedule milestone, allocate resources, designate team member respinsibilites, define metrics for success

What are the key components of an implementation plan?

Accuracy, completeness, relevance, consistency, reliability, presentability, accessbility

What are the aspects of data quality?

Ask why 5 times, Failure mode and effective analysis, Pareto analysis, fault tree analysis, Current reality tree, fishbone or ishikawa or cause and effect diagram, kepner-tregoe technique, rapud problem resolution

What are the techniques in root cause analysis?

Ask why 5 times

Asking why 5 times and getting progressively deeper into the problem

Failure mode of effects analysis

A technique which is aimed to find various modes for failure within a system

Data quality 101

These tools starter to focus on data wuality management, which generally integrate profiling, parsing, standardization, cleansing and matching processes.