Overview

  • Rivery was initially used to load all of Sweet Inn’s R&D’s data hosted on Amazon Postgresql to BigQuery – loading, transforming data and adding logics to meet the BI team’s needs. 
  • Rivery’s platform then provided a solution to streamline their DataOps processes – aggregating and orchestrating all data sources to create a single source of truth so BI team could deliver insights and serve all divisions.
  • Streamlining and automating all the data flows means data is always ready for analysis, and as a result report generation now takes a fifth of the time for the company’s BI team.

 

Background

“Reporting since we got Rivery has radically changed for the better. For the BI team, it felt like moving from yesterday’s Windows 95 to Windows 2000. It takes our team a fifth of the time to generate the reports our teams need in order to be able to make the most crucial business decisions.” – David Piazza, Data & BI Analyst 

Sweet Inn is changing the way people travel.

Combining the best of both worlds, Sweet Inn paired the luxurious accommodation and amenities of a 5-star hotel with beautifully designed apartments, situated in the heart of the most exciting cities in the world.

The travel tech startup was founded in 2014. Active in Europe and in Israel, the company offers upscale vacation apartments with hotel services for tourists and business travelers. Operating in major cities, with a unique vision of the future, Sweet Inn is fast becoming a leading brand in smart travel.

 

The Challenge

Sweet Inn’s R&D department used AWS for their data needs, while the BI team relied on Google’s BigQuery to slice and dice business data.

Because of this, the first challenge was loading data from Amazon to BigQuery – running some processes on this data so that it could adapt to the needs of the BI team.  

The second challenge was for the BI team to adopt a tool that would enable them to aggregate and orchestrate all data.

Since they serve all departments across the company, from marketing to product to sales to customer service – they needed a solution to streamline their DataOps processes.

 

The Solution

SweetInn’s BI team serves the entire company, including marketing, product, sales, and customer service teams.

The first and most urgent solution that Rivery provided was the ability to import data from R&D, so it could be further manipulated and used for analysis. To achieve this, they had to import data from Amazon Postgresql to Big Query.

In addition, they were capable of integrating data from multiple sources from across all divisions from platforms such as Google Analytics. Google Sheets was easy to integrate with Rivery’s ready-made API connectors.

For other sources such as their pricing data tool, the team used Rivery’s REST API. With over 150 pre-built connectors, plus REST API access, SweetInn was able to orchestrate and connect all data sources in a centralized BI hub.

As an ETL solution, Rivery helped SweetInn improve the company’s DataOps, with a streamlined operation that simplified the reporting processes. Rivery automated all the data flows to ensure data is always ready for analysis and reporting is available for anyone in the business.

 

The Outcome

The benefits that Rivery brought to Sweet Inn’s team can be described in three words: simplicity, efficiency, and agility. Having DataOps under control, Sweet Inn’s team can be fully data-driven.

This means simplifying all processes to create and share reports. What’s more, their new system is even programmed to send automatic alerts to the relevant departments when an issue such as suspected fraud or a pricing discrepancies arise.

Rivery also saves the BI team precious time. Previously they had to download CVS files from their PMS system and cross the data manually, which was extremely time consuming.

Now they can automatically use an ETL tool that helps them receive the data in the format they need, with the adaptations required for further processing and analysis. 

It now takes a fifth of the time for the BI team to generate the reports they need. Automating and orchestrating DataOps processes with Rivery is helping them become more efficient at managing data processes.

As a result, SweetInn is more data-driven and ready to expand with accessible insights across all teams.

“The service itself is incredibly user-friendly, easy to understand and adaptable to our needs. The pricing model is fair and transparent and competitive with other suppliers. We conducted a comprehensive analysis of all suppliers before we chose to proceed with Rivery, we are incredibly satisfied.”
Adam A., Digital Advisor
“The most cost-effective ETL\ELT product in the market. Best support for complex transformations. Best philosophy and understanding of the problem.”
Dor R., Head of Data
“The amazing thing about Rivery is that I don’t need to use it. I set it up and it just works, that’s the beauty of it.”
Elik R., Product Manager

Time to Ride the River

Rivery is free to try - no credit card required.