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 dbt Core™-compatible data models for our most popular connectors. The big advantage? You can essentially 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.
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
As Fivetran now manages your end-to-end data movement, we can visualize the entire flow and help you quickly identify when and where issues occur. 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.