TrovaTrip Builds a Modern Data Stack & Delivers Insights 95% Faster with Sigma
Customer Company Size
Mid-size Company
Region
- America
Country
- United States
Product
- Sigma
- Snowflake
- Fivetran
- dbt
Tech Stack
- SQL
- Google Analytics
- Microsoft Excel
- Google Sheets
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Cost Savings
- Customer Satisfaction
Technology Category
- Analytics & Modeling - Real Time Analytics
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Software
- Professional Service
Applicable Functions
- Business Operation
- Sales & Marketing
Services
- Software Design & Engineering Services
- System Integration
About The Customer
TrovaTrip is a group travel platform that gives Creators everything they need to plan and build trips that bring their online communities together in real life. By connecting Creators with thoughtful itineraries planned by Trip Designers, TrovaTrip takes care of the logistics so hosts can focus on building meaningful connections with their community. TrovaTrip is on a mission to make travel easier, safer, and more accessible to all. Over the last three years, TrovaTrip has experienced significant growth, which has increased its reliance on understanding, analyzing, and responding to a significant flow of data inputs. The company serves Creators with a seamless integration with Trip Operators and Travelers, requiring the collection and streamlining of information across all three audiences. TrovaTrip's data team is responsible for building data models and writing custom SQL to get the final data products, ensuring accuracy and validity before distributing insights for data-driven decisions. The company aims to improve customer experience and drive business forward with data, necessitating a more sophisticated analytics platform beyond Microsoft Excel and Google Sheets.
The Challenge
With significant growth over the last three years, TrovaTrip has relied heavily on understanding, analyzing, and responding to a significant flow of data inputs. Serving Creators with a seamless integration with Trip Operators and Travelers requires collecting and streamlining information across all three audiences. Teams at TrovaTrip wanted to spend less time creating and managing dashboards and more time improving the customer experience and driving the business forward with data which wasn’t possible with Microsoft Excel and Google Sheets alone. As TrovaTrip grew, so did its need for data insights and a more sophisticated analytics platform. TrovaTrip’s data team had to build the data models and write custom SQL to get the final data products. After which, they had to check the accuracy and ensure the data they were using was valid before distributing the necessary insights to make data-driven decisions. This can be a time-intensive process, but with the right tool can be done efficiently. TrovaTrip needed a tool that displayed the performance of sales funnels and conversion rates. When TrovaTrip onboarded new sales members, it was important to create efficient ramp-up goals. By building a process and scalable system, data teams could spend more time cultivating the insights that could help the organization grow.
The Solution
TrovaTrip decided to modernize its data stack to reach its new analytics goals and improve workflows across the business. The new data stack consisting of Snowflake, Fivetran, and dbt, was built from scratch. The goal was to build the best foundation in order to scale and be flexible enough for a small team to maintain. All that was left now was for TrovaTrip to find an analytics tool that could support their existing tools and make it possible to automate dashboards and enable self-service analytics for teams and business users. TrovaTrip’s CEO, Nick Poggi, ultimately decided to implement Sigma to simplify their analytics workflow and maximize the return on investment they had made into operational tools. As TrovaTrip continues to grow, Sigma is equipped to support its scale with ease of use, collaboration, and data modeling features. With Sigma sitting on top of that foundation, it is very quick and simple to create and deploy reports on data models in the data warehouse. When new projects call for new data source integration or new data models to be built around business logic, Sigma's GUI (graphic user interface) shows for fast data discovery, calculations, transformations, and rapid iteration. TrovaTrip is able to onboard users in Sigma in just two weeks, 92% faster than the usual six months. With Sigma in place, business users at TrovaTrip can create unions and joins in singular tables without writing SQL. Additionally, TrovaTrip reduced report delivery time from days down to an hour in Sigma. Anything that rises to the level of department or company interest when it comes to data is now immediately started on Sigma. This means teams are able to leverage Sigma to quickly and easily build data models and accurately measure data.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
SET Creative Ditches Google Vault for Datto Backupify
When Kienholz first started at SET, the staff was using Microsoft Outlook for email with no form of data backup. It became apparent that something needed to change as the staff was often burdened with trying to recover emails from departed employees. Kienholz transitioned the team to Google’s Gmail and implemented Google Vault for backup purposes. While SET employees quickly adjusted to Gmail, which many use for personal email, the same could not be said for Google Vault. “Unlike most Google products, Vault was not user friendly at all. It’s very hard to search for items. We never really figured out how to do a restore either,” explained Kienholz. Due to SET’s work with high-profile brands, projects often go through many rounds of revisions right down to the eleventh hour. This means that every bit of information - especially data living in project managers’ emails - is crucial to delivering clients a polished design at deadline.
Case Study
Infosys achieves a 5–7 percent effort reduction across projects
Infosys, a global leader in consulting, technology, and outsourcing solutions, was facing significant challenges in application development and maintenance due to its distributed teams, changing business priorities and the need to stay in alignment with customer needs. The company used a mix of open source, home-grown and third-party applications to support application development projects. However, challenges resulting from distributed teams using manual processes increased as the company grew. It became more and more important for Infosys to execute its projects efficiently, so they could improve quality, reduce defects and minimize delays.
Case Study
Arctic Wolf Envelops Teamworks with 24x7 Cybersecurity Protection and Comprehensive Visibility
Teamworks, a leading athlete engagement platform, faced rising cyberthreats and needed enhanced visibility into its network, servers, and laptops. With software developers connecting from all over the world, the company sought to improve its security posture and position itself for future growth. The company had a secure platform but recognized the need for a more proactive solution to identify gaps within its technology infrastructure. Data exfiltration and malicious access were top concerns, prompting the need for a comprehensive security upgrade.
Case Study
Sawback IT and Datto Save Client From a Costly Mistake
Ballistic Echo, a software development house, faced a critical challenge when human error led to the deletion of thousands of lines of unique code. This incident occurred before the code was pushed to source control, resulting in significant loss of time, revenue, and work. The previous file-level backup solution they used was slow and inefficient, making it nearly impossible to manually recreate the lost work. The need for a more reliable and efficient business continuity solution became evident to avoid such disasters in the future.
Case Study
Opal Helps Customers Shine Thanks to Datto
SP Flooring & Design Center faced a ransomware attack that encrypted and locked their files. The attack was initiated through a compromised service account set up by an outside vendor. The ransomware infection was isolated quickly, but there was a concern about the extent of the data at risk. The company had backups in place but was unsure of how much information was compromised. The situation required immediate action to prevent further damage and restore the affected data.
Case Study
Zapier Aggregates Multiple Analytics in a Single Dashboard with the New Relic Platform
Zapier, a company that enables non-technical users to push data between hundreds of web applications, was facing a challenge in automating and provisioning servers for optimal performance. The company's environment consisted of 50 Linux servers on the Amazon Elastic Compute Cloud (EC2), a Django application split across several servers, and a backend consisting of a dynamic number of celery task workers fed by messages published to a RabbitMQ cluster. They also maintained a number of internal web services on nginx in front of Gunicorn and Node.js processes. Redis handled simple key and value stores, with logging handled by Graylog2 and ElasticSearch. However, they realized that no level of automation would be sufficient without an effective monitoring solution in place. They needed a tool that could provide immediate alerts when something was breaking and could be easily implemented into their environment.
