Heart Disease and Stroke Prevention In US
Completion Date:
Project Overview
This data covers Medicare & Medicaid Services of both inpatient and outpatient across a variety of categories and years. Indicators from this data source have been computed by personnel in CDC\\\\\\\'s Division for Heart Disease and Stroke Prevention (DHDSP).This Dataset provides a comprehensive picture of the public health burden of CVDs(Cardiovascular Disease).The data are organized by location (national and state) and different indicators such as age, gender, race, and ethnicity.
The solution consists of a Staging, Operational Data Store, and Data Warehousing Layer.
Role:
Problem Statement
Heart disease is the leading cause of death for men, women, and people of most racial and ethnic groups in the United States. Hospitalization rate, also known as admission rate or inpatient rate, refers to the frequency or number of individuals admitted to a hospital for medical care within a specific time period. From CDC’s data, building data warehouse using ETL, provide suggestion after data analysis.
Executive Summary
The solution consists of a Staging, Operational Data Store, and Data Warehousing Layer. The Staging Layer extracts data from a JSON source using a Script Component. The Dictionary Tables in the ODS Layer are loaded and updated using Lookup Transformations. The Data Warehouse Layer is designed with 2fact tables, 5 Dimension Tables, and a Star Schema . All the tables in the Data Warehouse are loaded using Merge Statements implemented using Stored Procedures and Execute SQL Tasks.
Data Dictionary
Key Takeaways
1.In the year 2004,hospitalization rate is 1.49 and YOY it got decreased , the lowest rate is 1.32 in the year 2013.
Hospitalization rate is low in the year 2013 and decrease in YOY.
2.Hospitalization rate by age over 75+(75 and above) values are inconsistently increasing and decreasing YOY in between each year from 2004 to 2013
Next Steps
1.Encourage them to schedule regular check-ups with their healthcare providers to monitor their blood
pressure, cholesterol levels, and overall cardiovascular health. Early detection and intervention can
significantly reduce the risk of heart disease over the year.
2. Increased Awareness and Education, focus on raising awareness about heart disease risk factors,
symptoms, and preventive measures within community. This can be done through community outreach
programs, partnerships with local organizations, and educational campaigns tailored specifically to this
population at state level.
3.State health departments can further develop systems of stroke care through quality improvement
initiatives and partnerships to coordinate statewide stroke policies. If the person isn\\\\\\\'t breathing or you
don\\\\\\\'t find a pulse, begin CPR to keep blood flowing after you call 911 for emergency medical help.
Deployment
