TrovaTrip Builds a Modern Data Stack & Delivers Insights 95% Faster with Sigma

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.

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.

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.

• Today, teams at TrovaTrip look at Sigma reports to quickly and seamlessly filter and explore data to answer their own questions.
• Sigma easily connects to TrovaTrip’s other tools, such as dbt, Fivetran, and CRMs. With this seamless connection, TrovaTrip is able to ingest Facebook, Instagram, and Google Analytics data for analysis and make data-driven marketing and operations decisions.
• It is incredibly simple and quick to identify key metrics such as sales funnel performance and conversion rates using Sigma. Because all the data is sitting live in Snowflake, TrovaTrip is able to instantly tap into it.
• Executives at TrovaTrip now leverage Sigma to conduct revenue planning and forecasting to develop business strategies based on data and measure economic and industry trends.
• As more people at TrovaTrip gain access to Sigma, data remains secure and governed in Snowflake because it never leaves the warehouse. Sigma allows for role-based permissions, meaning users only see the data they need to work with.

• 95% reduction in time to update the foreign currency liability report, down from 6 hours to 15 minutes.
• 92% reduction in report builder onboarding time, down from 6 months to 2 weeks.
• Reduced report delivery time from days with Excel down to an hour with Sigma.