Skip to content

Releases: tyg3rr/Epi_Helper

v0.1.0.alpha

24 Jun 22:41
960aa9f
Compare
Choose a tag to compare
v0.1.0.alpha Pre-release
Pre-release

Epi_Helper v0.1.0.alpha

Epi_Helper was created to help local health departments in MI quickly and easily create communicable disease surveillance reports from MDSS output csv data files. The tool includes two parts:

  1. Query Assistant - remembers the case status and investigation status settings for groups of reportable diseases of interest. Guides the user through MDSS report queries
  2. Automated Pipeline - intakes MDSS-generated csv files, extracts relevant disease data, cleans & preprocesses, then inputs data into a master dataset.csv

The pipeline is dynamic in that the user creates a config file to select case and investigation status settings for groups of reportable diseases. The Query Assistant checks MDSS output csv files case and investigation status metadata against the config file, and rejects csv files that do not match the config settings for that particular group of diseases.

The output dataset.csv is optimized for use in PowerBI. Once PowerBI is configured to generate surveillance reports from output Epi_Helper data, the user only has to refresh PowerBI after generating dataset.csv for each new surveillance data period moving forward

See the Readme for more information.