Blinded Reports
reporting
Iteratively create multiple PDFs while maintaining anonymity
Description
A healthcare organization needed to send reports back to different companies who were reporting their quality and outcomes data on a monthly basis. They wanted to allow the different companies insight into how they were performing against the other companies who were submitting data, but they needed to maintain confidentiality of each reporting entity.
Methods
Quality data for each location was collected using Sharepoint Lists. The content of the lists were sourced with R. The data was wrangled using multiple functions, and finally standardized and stored in a Snowflake database.
Each month, data was transformed, analyzed and aggregated into a database that would allow for iterative reporting.
The data set was filtered for each location, and blind id’s were assigned for all other locations. Reports were generated using R Markdown. Using an iterative loop, pdf files were created and placed on a shared server for distribution.