Epi_Helper

Epi_Helper

Welcome to the Epi_Helper Guidebook!

Installation Instructions

  • Create a new file folder in your working directory for Epi_Helper.
  • Click the Download Epi_Helper button.
  • Extract all files from the newly downloaded Epi_Helper zip file into your newly created file folder.

Epi_Helper Overview

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 relevent 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

Epi_helper is designed for 5-year MDSS surveillance reports, and has only been tested on Kent County data.

Epi_Helper Info

  • Epi_Helper requires python version 3.9.0 or higher.
  • The project expects a config.json file in the working directory.
  • This project relies on tkinter and is only tested on Windows.
Full Demo
0:00/1×
Script Guide
How to run Epi_Helper
Connecting Power BI to out.csv
How to update FINAL.pbix after the first script run
GitHub - tyg3rr/Epi_Helper: Automated pipeline to transform MDSS csv reports into PowerBI-friendly format. Also assists user with MDSS report queries
Automated pipeline to transform MDSS csv reports into PowerBI-friendly format. Also assists user with MDSS report queries - GitHub - tyg3rr/Epi_Helper: Automated pipeline to transform MDSS csv repo…