W8 ni aya Flashcards
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 analytics
system.
DATA QUALITY
(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.
Routine Data Quality Assessment Tool
An _________ is a project management tool that shows how a
project will evolve at a high level.
Implementation Plan
analyzes information and identifies
incomplete or incorrect data. Cleansing such data follows after the completion of
the profiling of data concerns, which could range anywhere from removing
abnormalities to merging repeated information.
Data Quality Tools
A _________ 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
Answers the question “What do you want to accomplish?”
Define Goals/Objectives
Outline the high level schedule in the implementation phase
Outline the high level schedule in the implementation phase
Determine whether you have sufficient resources, and decide how you will procure what’s missing
Allocate Resources
Create a general team plan with overall roles that each team member will play.
Designate Team Member Responsibilities:
How will you determine if you have achieved your goal? (Smartsheet, 2017)
Define Metrics for Success:
Refers to the decomposition of fields into component parts and formatting the values into consistent layouts based on industry standard and patterns and user defined business rules
PARSING AND STANDARDIZATION
means the modification of data values to meet domain restrictions, constraints of integrity or other rules that define data quality as sufficient for the org.
GENERALIZED CLEANSING
This is the identification and merging related entries within or across data sets
MATCHING
Refers to the analysis of data to capture statistics or metadata to determine the quality of data and identify data quality issues
PROFILING
The deployment of controls to ensure conformity of data to business rules set by the org
MONITORING
Enhancing the value of the data by using related attributes from external sources such as consumer demographic attributes or geographic descriptors
ENRICHMENT
This might sound like the technique of a five-year-old wanting to get out of going to bed, but the five whys analysis can be quite useful for getting to the underlying causes of a problem.
ASK WHY 5 TIMES
(FMEA) is a technique which is
aimed to find various modes for failure within a system. FMEA requires several steps for execution
Failure Mode and Effects Analysis
The________ operates using the Pareto principle (20% of the work creates 80% of the results). You will want to run Pareto analysis any time when there are multiple potential causes to a problem
Pareto Analysis
Uses “Boolean Logic” to determine the root causes of an undesirable event. This technique is usually used in risk analysis and safety analysis.
Fault Tree Analysis (FTA)
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.
Current Reality Tree (CRT)
No matter what term you use for the fishbone diagram, the truth is, that it is a useful technique that will help you in your root cause analysis.
Fishbone or Ishikawa or Cause-and-Effect Diagrams
also known as rational process is intended to
break a problem down to its root cause
Kepner-Tregoe Technique
what are the priorities and orders for concerns
for specific issues?
Appraisal of the situation
One final technique used in root cause analyses is the RPR
Problem diagnosis. RPR stands for __________ and it deals with diagnosing the causes of recurrent problems.
“Rapid Problem Resolution”
team members gather data and analyze their
findings
Discover
a diagnostic plan is created and the root cause is
identified through careful analysis of the diagnostic data
Investigate
the problem is fixed and monitored to ensure that the
proper root cause was identified.
Fix
