Founded in 2008, Legends is a premium experiences company with six divisions operating worldwide - Global Planning, Global Sales, Hospitality, Global Partnerships, Global Merchandise, and Global Technology Solutions - offering clients and partners a 360-degree service solution platform to elevate their brand and execute their vision. Currently, Legends works with marquee clients across business verticals including professional sports; collegiate; attractions; entertainment; and conventions and leisure. We are the industry leaders in designing, planning and realizing exceptional experiences in sports and entertainment.

Tech Holding is contracted with Legends to build an end-to-end hospitality platform that allows multiple clients (NBA, NFL, USGA) to list their inventory and create hospitality packages around it to sell at a higher price. This allows the client to package their tickets with Hotel, Travel, Dining, and add-on packages to create a hospitality package.

Legends faced the challenge of managing and processing data from multiple sources, including Google Analytics, Salesforce and Salesforce Marketing Cloud. The data, arriving in both real-time and batch modes, needed to be processed efficiently and stored in a structured format for downstream analytics and reporting. The client required a scalable, automated ETL solution to consolidate data from these various sources and prepare it for use in business intelligence dashboards. Additionally, they needed a solution to handle large data volumes without compromising performance

AWS was selected due to its scalable infrastructure and a suite of fully managed services. With Amazon S3 for storage, AWS Glue for ETL, and Amazon Redshift for data warehousing, the client could seamlessly integrate data from multiple sources while leveraging AWS's reliability and cost-efficiency. AWS also provided native support for real-time data ingestion through AWS Kinesis and the ability to trigger data processing via AWS Lambda and ECS tasks.

Why the Customer Chose the Partner

Legends has selected Tech Holding because of our comprehensive experience in architecting and building cloud applications and services and our in-depth knowledge of creating large scale online applications. Tech Holding has a deep knowledge of integrating multiple endpoints with third party services via API, data ingestion and proven ability to architect and implement data pipelines and data warehouse at scale.

Solution

Tech Holding implemented a comprehensive data pipeline using AWS Glue to handle the ETL process for scheduled jobs. The solution leveraged AWS Lambda to periodically ingest data from Google Analytics and Salesforce Marketing Cloud into Amazon S3, which was then processed by AWS Glue. The key components included:

• Amazon S3 as the central storage for all raw data.
• Scheduled AWS Lambda jobs for ingesting data from Google Analytics and SFMC.
• AWS Glue for transforming the ingested data and loading it into Amazon Redshift.
• Amazon Redshift as the final destination for structured data used in dashboards and reporting.