ETL and Visualization Implementation for a Non-Profit

Background

Challenger Center is originally founded by the families of the Challenger mission in an effort to promote educational interest in STEM. They develop interactive virtual programs ('missions') and space mission simulations to encourage teamwork and collaboration while learning for teams of 'learners'.

Challenge

Challenger had begun acquiring survey feedback data for their missions from attendees and wanted to measure how effective each mission was, how much interested they garnered and how much each learner enjoyed their experience. Before engaging with Keyrus, Challenger only had CSV outputs of their survey responses and no way to readily visualize or even use the data.

Approach

We architected a solution to leverage AWS' Glue for ETL, AWS Redshift for data warehousing and AWS' QuickSight for the visualizations.

Key results

Readily available, immediately actionable visualizations that show feedback based on mission, location and demographic.

Benefits

Better direction in what programs to fund/expand/develop and how to better leverage their educational grants. Demographic insights for better audience targeting per program.