Skuid saves 6 months of engineering time with Fivetran transformations

Unternehmensgröße
0-499
Region
North America
Branche
B2B-technologie
Quellen
Destinations
BI tool
No items found.
Cloud Platform
Amazon Web Services
Si partner
Kostenlos starten
Wichtigste Ergebnisse
  • Reports that took three to four days to generate before board meetings are now available immediately.
  • Fivetran saves Skuid an estimated six months of time for initial pipeline and transformations setup.
  • With Fivetran, Skuid can quickly generate comprehensive lists of customer tickets and metrics from Freshdesk, something support had been unable to achieve for years.
  • Skuid is currently building out more than 100 new dashboards and reports.
  • After realizing its current data warehouse approach was not scalable, Skuid used Fivetran transformations to easily and rapidly modify its warehousing strategy.

Skuid offers a digital experience toolkit that enables anyone to design, develop and deploy applications to fit their business needs. As the company expanded, Skuid outgrew its existing reporting methods. The company embarked on a data warehousing project to mature its operational data management and develop a verified single source of truth for all company data.

Manual Reporting With No Single Source of Truth

As Skuid tried to integrate multiple systems, internal teams did not establish a single source of truth. People were pulling reports out of their applications and exporting them into spreadsheets. “The biggest danger with people looking at the data in different systems or in Excel is that they either pull the incorrect fields or interpret the data incorrectly without the broader picture factored in,” explains Javid Igani, Manager of Internal Solutions at Skuid. “We wanted to give people the data they needed in a more self-service reporting model, without any choke points.”

As a consequence of the reporting challenges, the team was spending hours formatting data that should have been readily available. Skuid’s financial director had to ensure that the numbers reported to stakeholders were correct by going through each team’s reports. “Before these meetings, managers had to hole up for three to four days to manually generate these reports,” says Igani. “Our CEO should be able to click a button to load the data and make decisions off of it.”

Building a Data Stack With No Engineering Involved

Igani led the warehousing project and came across Fivetran: “I read through the entire documentation and I realized it was exactly what we needed. It had connectors to all of the systems we were trying to integrate into a data warehouse.”

Having the data centralized into Amazon Redshift, Skuid’s data warehouse of choice, enables the business to take advantage of the Redshift data source type available on the Skuid platform. “Within 24 hours I was able to turn on Fivetran, get the data into Redshift and format it in one place, then view the data on a webpage that I could give to leadership,” Igani says.

Igani would have been responsible for the data engineering himself since his team was needed on other projects, and he estimates that it would have taken six months to build out pipelines and set up transformations. Using Fivetran allowed him to reallocate that time to other strategic projects during the same time frame.

Leveraging Fivetran Transformations

With Fivetran Transformations, Igani easily set up powerful and automated in-warehouse transformations. “We have over 60 transformations right now,” he says. “They’re an extremely approachable way for someone to add that layer to their data pipeline. With Fivetran doing the ELT, all of our raw data is in the warehouse and untouched.”

Here's how Ignani describes the range of transformations Fivetran enables:

Pretty much anything you can write in SQL you can put through a transformation and benefit from it because it runs in the same way it would if you were to take that code and run it in your database client. It allows us to keep reports up to date and take snapshots of critical daily data, such as our sales pipeline, so we can understand the state of today and tomorrow through a really simple transformation. We don’t have to worry about how we’re going to get the data anymore and we can focus on delivering the types of reports that executives want. It is a really big game-changer.

More Relevant, Reliable Report Data

Before Fivetran, Skuid was able to generate some reports on large data sets manually. The Freshdesk API, for example, has a 30-row limit per request that made it difficult to get a timely overview of data for client requests without writing more code. Additionally, the reports that Freshdesk offers out-of-the-box aren’t relevant for Skuid. With Fivetran, Igani and his team can quickly build a Skuid page to interact with the data, providing a comprehensive list of tickets and metrics joined with Salesforce data per client to the Manager of Technical Support within minutes.

Having the data has increased the enthusiasm of the support team. Skuid plans to build 100 new reports and dashboards in the next few months that address broad company goals and additional departmental metrics. “Really anything that we need to report on is going to be solved this year as a direct result of how Fivetran has helped,” Igani explains. “We’re off to a great start and there are plenty of other projects that have been opened up as a result.”

Ready to see the benefits of fully automated data pipelines and centralized data on your organization? Sign up for a personalized demo of Fivetran or start your free trial today.

About Fivetran: Shaped by the real-world needs of data analysts, Fivetran technology is the smartest, fastest way to replicate your applications, databases, events and files into a high-performance cloud warehouse. Fivetran connectors deploy in minutes, require zero maintenance, and automatically adjust to source changes — so your data team can stop worrying about engineering and focus on driving insights.

About Redshift: Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse solution that makes it simple and cost-effective to efficiently analyse all of your data using your existing business intelligence tools.

[CTA_MODULE]

Die gesamtwirtschaftlichen Auswirkungen von Fivetran

Erfahren Sie, wie Sie mit automatisiertem Data Movement in Ihrem Unternehmen die Produktivität steigern und schneller Erkenntnisse gewinnen können.

Laden Sie den Bericht herunter
Zentralisierte Daten treiben das Unternehmenswachstum voran

So beschleunigen echte Fivetran-Kunden Analytics und KI

Jetzt den Leitfaden herunterladen
Why they chose Fivetran

Further reading
No items found.
No items found.
Ähnliche Kunden-Storys
Case study

RSG Group beschleunigt strategische Entscheidungen an über 900 Standorten weltweit

Case study

Adragos erzielt mit Fivetran schnellere Erkenntnisse und treibt seine globale Expansion voran

Case study

Flaschen gespart, Effizienz gewonnen: air up® zentralisiert ihre Daten für mehr Wachstum

Case study

FELFEL beschleunigt die Datenintegration mit Fivetran um das Zwanzigfache

Case study

Raiffeisen Bank International setzt für die Gewinnung von Kunden auf Echtzeitdaten

Case study

HubSpot spart bei GenAI mit Fivetran 100.000 US-Dollar ein

Case study

Deliveroo verwandelt die Essenslieferung in eine datengesteuerte Unternehmung

Case study

Westwing steigert den Marketing-ROI mit Fivetran

Case study

MyCamper startet seine datengesteuerte Reise mit Fivetran

Case study

Condé Nast bildet mit Fivetran die Customer Journey für globale Marken ab