The coronavirus pandemic has impacted the lives of millions of people and families. It is essential to provide resources to assist people during this crisis both healthcare and non-healthcare.
Also, to lower healthcare costs, improve outcomes and promote self-care through proactive remote patient monitoring and user engagement.
What it does
SolutionsReache provides connected health solutions and is committed to helping you manage the challenges presented by COVID-19 through our digital marketplace of products by providing free and paid COVID-19 apps and Solutions for government and public health with community and residents, employers and employees, hospitals and patients, as well as PPE supply chain for medical sites including labs and hospitals.
How I built it
Using the AWS Data Exchange to subscribe to data, loading the data into S3 buckets, and using Glue crawlers and mappings to load the data into Amazon Redshift. Tableau has connectors for Redshift and RDS to bring data into tableau for analysis.
Challenges I ran into
There were cumulative data for Tableau coronavirus (COVID-19) and Rearc data on AWS Data Exchange which required some data discovery, auditing and filtering to get the data in the right format.
Accomplishments that I'm proud of
Defining an end-to-end solution architecture to connect a VueJS web app to a subscribed data on AWS Data Exchange and proving out it works by creating apps and other solutions around the architecture.
What I learned
AWS Data Exchange and AWS Glue.
What's next for SolutionsReache
Implement the tasks on our roadmap including dashboards for hospitalizations, testing, and hospital capacity.