From application to insights with Quickstart data models

Fivetran’s new Quickstart data models let you turn your application data into analytics-ready tables, all with the click of a button.
February 13, 2023

Thousands of organizations have come to rely on Fivetran for our data movement platform. Whether it’s for marketing analytics, finance or business operations, we have the connectors you need to drive a data-backed business.

But, having access to the data is only a part of the process. In a survey by Dimensional Research, 44 percent of data professionals said that crucial data they have access to is not yet usable for decision-making, and 68 percent of that group shared they could extract more insights from existing data if they only had the time.

To address this challenge, we’re excited to introduce Quickstart data models, an efficient and automated way to turn application data into analytics-ready tables.

Quickstart data models are in-platform deployments of our entire dbt Core™-compatible single source data models that our team has built for our most popular connectors. The big advantage? You can transform your data without building out your own dbt project. All you need to do is click a few buttons and in the background, Fivetran creates the dbt project and orchestrates the transformations for you. You can then view, edit and delete each transformation from your Transformations dashboard. All without affecting your consumption in Fivetran.

This new approach gives you faster, more reliable reporting your organization needs, without adding complexity or cost to your tech stack. Don’t take our word for it, just ask our customers:

For even the most experienced data teams, extracting, loading and modeling data into production-ready reporting takes at least a week. With Fivetran Quickstart data models and Sigma templates, we did it in an hour. I'm not sure what other platforms provide that experience.
- Jake Hannan, Senior Manager, Data Platform at Sigma

Let’s dive a bit deeper into just how easy it is to turn the data from your applications into insights.

[CTA_MODULE]

Step one: Add a connector

We have Quickstart data models for many of your most used connectors — with more rolling out every quarter. Feel free to skip this step if you already have a connector setup with data you want to transform.

Step two: Add a Quickstart transformation

Navigate to the Transformation tab and either click “Quickstart transformation” if you’re starting from scratch or “Add transformation” > “Quickstart transformation” if you have existing dbt transformations (which you can continue to use in parallel).

Step three: Configure your Quickstart transformation

You only need to make three choices: The data source, the connector with the data you want to transform and the orchestration schedule. For the last piece, we recommend “fully integrated” so you can take advantage of complete automation.

From that last step, you can also read about the models and the tables we build for you in your end destination. If you find you need custom logic, you can still manage and orchestrate your custom dbt packages in Fivetran using our dbt Core integration. Quickstart data models and custom data models can coincide in your Fivetran account.

Step four: Turn your analytics-ready tables into insights

Now you have the analytics-ready data in your destination. Turn that data into visualizations, reports, business intelligence or ad-hoc analysis.

You have completed all of the steps you need to turn your data into actionable insights for all of your stakeholders. You’ve done so efficiently and imparted automation into the process. This means you have more time for deeper analysis, which further amplifies the impact of your data and drives your organization even further.

Fivetran's new Quickstart data model for Salesforce have been incredibly valuable for my small data team. We really value no or low code solutions, so being able to stand up really valuable data transformations without involving a data engineer is a huge win! This frees up our time to do deeper analysis and better service our clients.
- Mark Sussman, Director of Data & Analytics, Strategus

But, what if something goes wrong? What if there’s an error in the process?

Bonus step: Monitor your pipelines

Fivetran provides real-time logs for your data transformations in the same platform as your connector logs. This means you can monitor your entire pipeline from one location. You can even receive an alert or notification directly to your email.

You now have all the steps you need. It’s that simple! Start transforming your data and data practices today with Quickstart data models.

[CTA_MODULE]

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Product
Product

From application to insights with Quickstart data models

From application to insights with Quickstart data models

February 13, 2023
February 13, 2023
From application to insights with Quickstart data models
Fivetran’s new Quickstart data models let you turn your application data into analytics-ready tables, all with the click of a button.

Thousands of organizations have come to rely on Fivetran for our data movement platform. Whether it’s for marketing analytics, finance or business operations, we have the connectors you need to drive a data-backed business.

But, having access to the data is only a part of the process. In a survey by Dimensional Research, 44 percent of data professionals said that crucial data they have access to is not yet usable for decision-making, and 68 percent of that group shared they could extract more insights from existing data if they only had the time.

To address this challenge, we’re excited to introduce Quickstart data models, an efficient and automated way to turn application data into analytics-ready tables.

Quickstart data models are in-platform deployments of our entire dbt Core™-compatible single source data models that our team has built for our most popular connectors. The big advantage? You can transform your data without building out your own dbt project. All you need to do is click a few buttons and in the background, Fivetran creates the dbt project and orchestrates the transformations for you. You can then view, edit and delete each transformation from your Transformations dashboard. All without affecting your consumption in Fivetran.

This new approach gives you faster, more reliable reporting your organization needs, without adding complexity or cost to your tech stack. Don’t take our word for it, just ask our customers:

For even the most experienced data teams, extracting, loading and modeling data into production-ready reporting takes at least a week. With Fivetran Quickstart data models and Sigma templates, we did it in an hour. I'm not sure what other platforms provide that experience.
- Jake Hannan, Senior Manager, Data Platform at Sigma

Let’s dive a bit deeper into just how easy it is to turn the data from your applications into insights.

[CTA_MODULE]

Step one: Add a connector

We have Quickstart data models for many of your most used connectors — with more rolling out every quarter. Feel free to skip this step if you already have a connector setup with data you want to transform.

Step two: Add a Quickstart transformation

Navigate to the Transformation tab and either click “Quickstart transformation” if you’re starting from scratch or “Add transformation” > “Quickstart transformation” if you have existing dbt transformations (which you can continue to use in parallel).

Step three: Configure your Quickstart transformation

You only need to make three choices: The data source, the connector with the data you want to transform and the orchestration schedule. For the last piece, we recommend “fully integrated” so you can take advantage of complete automation.

From that last step, you can also read about the models and the tables we build for you in your end destination. If you find you need custom logic, you can still manage and orchestrate your custom dbt packages in Fivetran using our dbt Core integration. Quickstart data models and custom data models can coincide in your Fivetran account.

Step four: Turn your analytics-ready tables into insights

Now you have the analytics-ready data in your destination. Turn that data into visualizations, reports, business intelligence or ad-hoc analysis.

You have completed all of the steps you need to turn your data into actionable insights for all of your stakeholders. You’ve done so efficiently and imparted automation into the process. This means you have more time for deeper analysis, which further amplifies the impact of your data and drives your organization even further.

Fivetran's new Quickstart data model for Salesforce have been incredibly valuable for my small data team. We really value no or low code solutions, so being able to stand up really valuable data transformations without involving a data engineer is a huge win! This frees up our time to do deeper analysis and better service our clients.
- Mark Sussman, Director of Data & Analytics, Strategus

But, what if something goes wrong? What if there’s an error in the process?

Bonus step: Monitor your pipelines

Fivetran provides real-time logs for your data transformations in the same platform as your connector logs. This means you can monitor your entire pipeline from one location. You can even receive an alert or notification directly to your email.

You now have all the steps you need. It’s that simple! Start transforming your data and data practices today with Quickstart data models.

[CTA_MODULE]

Uplevel your data transformation skills
Download our free ebook
Start your 14-day free trial today!
Get started now

Related blog posts

Fivetran gives analysts a new way to transform data
Product

Fivetran gives analysts a new way to transform data

Read post
Three ways to transform your data analyst processes
Data insights

Three ways to transform your data analyst processes

Read post
No items found.
Fivetran Product Update: October 2024
Blog

Fivetran Product Update: October 2024

Read post
Data replication tools: Comparing Fivetran’s deployment options
Blog

Data replication tools: Comparing Fivetran’s deployment options

Read post
Try out the Fivetran dbt™ package for SAP
Blog

Try out the Fivetran dbt™ package for SAP

Read post

Start for free

Join the thousands of companies using Fivetran to centralize and transform their data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.