During the 1st semester of my junior year, my team and I worked to create a website that brought awareness to mental health and effects within Provo.
Creating the Project
As part of the project, we were given a data set of survey responses from citizens in Provo, UT about their mental health. We had to clean the data and put it in 3rd normal form so that we could put the data into PostgreSQL database which could be added to through a survey on website.We input the data into a notebook and used pandas, numpy, and matplot lib packages to help us analyze the results of the survey. With the database, we used a Domo dashboard that updated every 15 minutes to display the data for presentation to stakeholders. Our website was built using a JavaScript-based frontend and Node Express backend. We built an AWS CodePipeline and CodeCommit to house our code repo. We deployed the PostgreSQL database to RDS and used Elastic Beanstalk to deploy our application.
Links to project
Converted 3rd Normal Form Survey Data
Data Exploration and Data Visualization w/ Python/Pandas/MatPlotLib