Using Business Intelligence Tools to Support Medical Validation of Laboratory Tests

Modern clinical laboratories have to confirm that the procedures used for specific tests are reliable and valid. There are several sources of errors and interferences that can invalidate the results. Medical validation refers to the plausibility check of the test results. Implausible results indicate that something might went wrong with a sample retrieved from the patient, e.g., the blood sample got contaminated with another fluid, which requires re-examination. Here, we describe how an integrated R-based business intelligence (BI) tool can be developed that increase the efficiency of the medical validation at the Institute of Clinical Chemistry (ICC) of the University Hospital Zurich. A BI software environment allowed us to digitalize steps in the validation process that were manually done in Excel worksheets, e.g., importing the data, calculating percentiles, and producing graphical outputs.