This is Tuva Health's Readmissions Mart, which is a dbt project to do hospital readmission analytics. It is based on the CMS Readmission Measures Methodology and includes other features, such as data quality checks specific to readmissions.
-
Short video giving a high-level overview of what it looks like to do proper analytics on hospital readmissions
-
Video explanation of how to run this readmissions dbt project
-
Latest Tuva Readmissions DAG
-
Tuva Docs
The main output tables from this dbt project are:
encounter_augmented
: lists all acute inpatient encounters with fields that give extra information about the encounter (e.g. length_of_stay, index_admission_flag, planned_flag, specialty_cohort, etc.), as well as data quality flags.readmission_summary
: lists all encounters that are not discarded due to data quality problems, together with fields giving extra information about the encounter and it's associated readmission (if the encounter had a readmission).
- You have healthcare data (e.g. EHR, claims, lab, HIE, etc.) in a data warehouse
- You have dbt installed and configured (i.e. connected to your data warehouse)
Here are instructions for installing dbt.
Execute the following steps to load all seed files, build all data marts, and run all data quality tests in your data warehouse:
- Clone this repo to your local machine or environment
- This project will run automatically off of Tuva Core.
- Alternatively, if you haven't installed Tuva Core you can directly map your data to the source schema described in source.yml
- Configure dbt_project.yml
- profile: write the name of the profile in the profile.yml file that connects to your data warehouse
- vars: configure source_name, source_database name, and source_schema name
- Run project
- Navigate to the project directory in the command line
- Execute "dbt build" to create all tables/views in your data warehouse
Don't see a model or specific metric you would have liked to be included? Notice any bugs when installing and running the package? If so, we highly encourage and welcome contributions to this package!
Join the conversation on Slack!
This package has been tested on Snowflake and Redshift. We are planning to expand testing to BigQuery in the near future.