This project assisted Milliman, an actuarial consulting firm, by creating a PowerBI dashboard to inform them of the implications Social Determinants of Health (SDoH) have on health outcomes of people 65 and older on Medicare. The dashboard includes filters to change certain SDoH or percentile of data to see the change in the average hospitalizations/emergency room visits by county. To determine the SDoH included in the dashboard, the team utilized information from various models to select the most significant variables. The team designed and created dashboards available to Milliman on the potential impacts that SDoH have on people’s health outcomes.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Pham, Ngoc
• McGonigle, Kevin
• Murdza, Eric
• Doherty, Demetre

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-121422-222946
• 83281

Advisor

• Abraham, Jon P.
• Posterro, Barry John

Year

• 2022

Sponsor

• Milliman

Date created

• 2022-12-14

Resource type

• Major Qualifying Project

Major

• Actuarial Mathematics

Source

• E-project-121422-222946

Rights statement

• In Copyright

Last modified

• 2023-01-12