Dotlabs
Hospi Housing | A complete ETL pipeline and BI Dashboard
Introduction
Hospi Housing is an application that connects hosts who want to offer their houses for living to students seeking accommodation in the Netherlands. The application collects various types of data about hosts, students, and their interactions, storing it in DynamoDB, which is configured in AWS. Our task was to set up an ETL pipeline to extract data from DynamoDB, transform it into the correct format, and make it available for visualization. To accomplish this, we utilized several AWS services, including S3, Glue, Athena, and QuickSight.