Case Study: Bundle achieves streamlined data management and live analytics with TrackIt’s ETL pipeline and data warehouse

Bundle - Customer Case Study

Bundle, a company providing employee wellbeing and performance solutions, faced challenges with a non-normalized CMS database. This made data management difficult for their Customer Experience team, requiring a tedious manual process of exporting and importing data into spreadsheets. They sought a better solution for data analytics and engaged TrackIt to implement a data warehousing solution.

TrackIt designed and implemented an ETL pipeline using AWS Lambda, Amazon S3, and Amazon Aurora to automate data extraction, transformation, and loading into a centralized data warehouse. They also built Tableau dashboards for data visualization. This solution automated data extraction, grouped all essential data in a single location, and enabled improved productivity and enhanced decision-making across the organization.

Bundle

Tyler O’Connor

Data Analytics Lead