data academy

Setting up your first data pipeline

Setting up your first data pipeline

A beginner’s guide to setting up ELT data pipelines

Read post →
Demystifying the transactional database

Demystifying the transactional database

Transactional databases are essential to many apps and software. Learn more about them and their benefits with Fivetran.

Read post →
Build vs. buy data pipelines: Costs to consider

Build vs. buy data pipelines: Costs to consider

A few simple calculations illustrate why it's ill-advised to build your own data pipeline.

Read post →
The modern data science stack

The modern data science stack

Automated data integration can help you jump-start your machine learning efforts.

Read post →
What is the architecture of automated data integration?

What is the architecture of automated data integration?

Automated data integration depends on several key concepts.

Read post →
Announcing the Modern Data Stack Boot Camp

Announcing the Modern Data Stack Boot Camp

Learn how to set up a modern data stack and transform your analytics in three steps.

Read post →
Databases Demystified Chapter 10 – Query Planning and Optimization

Databases Demystified Chapter 10 – Query Planning and Optimization

Take a look under the hood to learn how you can help databases execute queries more efficiently.

Read post →
Databases Demystified Chapter 9 – Indexes

Databases Demystified Chapter 9 – Indexes

Indexes aren’t just for catalogs or textbooks. Learn how indexes make queries faster.

Read post →
Databases Demystified Chapter 8 – Distributed Databases Part 3

Databases Demystified Chapter 8 – Distributed Databases Part 3

What is “consensus,” and what does it have to do with distributed databases?

Read post →
Databases Demystified Chapter 7 – Distributed Databases Part 2

Databases Demystified Chapter 7 – Distributed Databases Part 2

Distributed databases are powerful, but they come with lots of complications.

Read post →
Databases Demystified Chapter 5 – Transactions Part 2

Databases Demystified Chapter 5 – Transactions Part 2

Learn about the relationship between isolation and concurrency.

Read post →
Databases Demystified Chapter 4 – Transactions Part 1

Databases Demystified Chapter 4 – Transactions Part 1

Take a deep dive into transactional databases.

Read post →
Databases Demystified Chapter 3 – Row Store vs. Column Store

Databases Demystified Chapter 3 – Row Store vs. Column Store

Take a closer look at the differences in architecture between row- and column-based databases

Read post →
Databases Demystified Chapter 1 – Databases and SQL

Databases Demystified Chapter 1 – Databases and SQL

Learn about the history of databases, important terminology, and different types of databases you might encounter.

Read post →
What is idempotence?

What is idempotence?

Idempotence is an important characteristic of many systems, including Fivetran. Here's what it means.

Read post →
Three kinds of metrics GitHub data can answer

Three kinds of metrics GitHub data can answer

Data from GitHub can help your engineers quantify how they are doing.

Read post →
Five dashboards to jump-start your analytics

Five dashboards to jump-start your analytics

Consider building these dashboards that help answer essential business questions.

Read post →
How no-code empowers non-engineers without sacrificing data and analytics

How no-code empowers non-engineers without sacrificing data and analytics

You don’t have to build all of the systems that support your business functions.

Read post →
Use Fivetran to sync any unsupported source

Use Fivetran to sync any unsupported source

Learn how Fivetran cloud function connectors can pull data when there is no prebuilt connector.

Read post →
 Why you need automated schema migration

Why you need automated schema migration

Schema changes can completely disrupt a data pipeline. Automated data integration offers a solution.

Read post →
How to organize your analytics team

How to organize your analytics team

People and processes matter as much as your technology stack.

Read post →
How to migrate your enterprise data warehouse to a cloud data warehouse

How to migrate your enterprise data warehouse to a cloud data warehouse

The modern data stack lives in the cloud. Here are the steps you'll need to take to migrate your on-prem system.

Read post →
The definitive glossary of data integration terms

The definitive glossary of data integration terms

New to analytics? Don’t know what an ERD is? Read this comprehensive list of important data integration terms.

Read post →
How Fivetran built its Klaviyo connector

How Fivetran built its Klaviyo connector

The process of building a connector is inextricably linked with schema design.

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.