Background
Methods
Baseline measurement
Defining data quality metrics
Metrics evaluation framework
Metrics | Formula | Description |
---|---|---|
1. SIPOC (supplier, input, process, output, customer): | – | Identifies all elements of a process improvement before measuring baseline |
2. DPU |
\( \frac{\mathrm{Number}\ \mathrm{of}\ \mathrm{defects}\ \mathrm{observed}}{\mathrm{Number}\ \mathrm{of}\ \mathrm{units}\ \mathrm{inspected}} \)
| |
3. DPO |
\( \frac{\mathrm{Number}\ \mathrm{of}\ \mathrm{defects}\ \mathrm{observed}\ \mathrm{in}\ \mathrm{a}\ \mathrm{unit}}{\mathrm{Number}\ \mathrm{of}\ \mathrm{opportunities}\ \mathrm{of}\ \mathrm{error}\ \mathrm{in}\ \mathrm{a}\ \mathrm{unit}} \)
| |
4. DPMO | DPO ∗ 1000, 000 | |
5. Yield |
\( Yield\kern0.5em \%=\frac{\left(1- DPO\right)}{100} \)
| |
6. Sigma |
Mode of intervention
-
A data completion checklist (which comprised of the twelve items based on the commonly encountered data errors from the historical data review)
-
An introductory package for PIs (which included a data structuring guide, data structuring Excel® templates, a codebook sample, and brochures for the required data elements and variables based on study type).
-
Training of research coordinators involved in a research project.
-
Video materials focusing on how to structure and enter data in excel sheets.
-
Electronic data capturing using electronic case report forms.
Statistical analysis
Results
Baseline results
Measures | Pre-Intervention
n = 45
| Post-Intervention
n = 21
| ||
---|---|---|---|---|
Distribution of defects | ||||
Zero defects | 6 (13.3) | 17 (81) | ||
One defect | 8 (17.7) | 2 (9.5) | ||
Two or more defects | 31 (69) | 2 (9.5) | ||
DPU (defects per unit) | 2.33 | 0.57 | ||
DPMO (defects per million opportunities) | 194,444.44 | 47,619.04 | ||
Yield | 80.55 | 95.23 | ||
SIGMA | 2.4 | 3.2 | ||
Pre-intervention datasets | Post-intervention datasets | |||
Not Defective | Defective | Not Defective | Defective | |
Data Capturing Points n (%) | ||||
Single data capturing point (Cross-Sectional studies) | 6 (28.6) | 15 (71.4) | 8 (66.7) | 4 (33.3) |
Multiple data capturing points (Longitudinal studies) | 0 | 24 (100)* | 9 (100) | 0 |
Research Coordinator on board n (%) | ||||
No | 5 (17.9) | 23 (82.1) | 7 (63.60) | 4 (36.4) |
Yes | 1 (5.9) | 16 (94.1) | 10 (100) | 0 |
Principal Investigators (PIs) Requesting Data Analysis n(%) | ||||
Returning PIs | 3 (30) | 7 (70) | 14 (100) | 0 |
New PIs | 3 (8.6) | 32 (91.4) | 3 (42.9) | 4 (57.1)** |