Start Wrangling

Speed up your data preparation with Trifacta

Free Sign Up
Trifacta Ranked #1 in Data Preparation Market Study

Dresner Advisory Services study reviews and ranks 24 vendors

Get the Report
Schedule a Demo

What’s the difference between Data Wrangling and ETL?

February 16, 2017

Born out of necessity, data wrangling has emerged as a solution used to facilitate and expedite the data analysis process. With the constantly expanding amount of new and diverse data sources, business analysts can easily spend up to 80 percent of their time formatting and standardizing data before ever getting a chance to derive value from it. While traditional ETL technologies focus on enabling IT users to extract, transform and load data into a centralized enterprise data warehouse for reporting, data wrangling solutions are specifically designed for business users to explore and prepare diverse data themselves for a variety of downstream uses.

As head of products at Trifacta, clients, partners and analysts are always asking me to differentiate data wrangling and ETL. Given there is some overlap in functionality across the two tool sets, I can understand why there is some confusion. To highlight the differences between data wrangling and ETL, I’ll explain three major differences between the two technologies.

Check out the full article on TDWI here.

Related Posts

Guest Post – Knowledgent’s TeKathon Using Trifacta for Financial Services Analytics

Marjon Rahimian, Informationist at Knowledgent, blogs on the Financial Services team of this year’s... more

  |  August 26, 2015

Trifacta for Marketers: Accelerating Marketing Data Onboarding

This is the first post in a series about how marketers are leveraging Trifacta, authored by Trifacta’s VP... more

  |  April 24, 2018

Data Cleaning Techniques Make Databases Sparkle

Without data cleaning techniques, your data can get ugly, and your analysis might be incomplete. “Dirty”... more

  |  June 23, 2016