Power BI & R in a Public Health Lab: Automating Lab Data Analysis
The problem: data drudgery. Our solution: business intelligence tools. Two business intelligence tools are available for use at the Napa-Solano-Yolo-Marin Public Health Laboratory (NSYM PHL): Power BI and R. I described how the laboratory staff use these tools during my presentation to LabAspire Fellows and their mentors. I'm sharing part of it here. Context The NSYM PHL processes over 10,000 specimens annually, with more than 75% being environmental specimens (i.e., water samples and ticks). The rest are clinical specimens. Once these specimens are in the laboratory, they undergo three phases of testing: Pre-analytical phase Information about the specimen is derived from the requisition form that comes with it: patient information (i.e., unique identifiers, travel history), submitter (oftentimes the medical facility) information, and sample information (i.e., sample source and type, collection date and time, type of test requested). The information is then entered...