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

Looking Beyond VLOOKUP to Data Preparation Platforms

June 26, 2018

Your executives expect answers faster than they did just a few years ago. At the same time, your data’s getting bigger: pulled from more sources, stored in Hadoop clusters, and managed with tools like Cloudera. But the data’s not getting any cleaner. In fact, Forrester reports that over 80% of an analyst’s time is spent just doing the preparation work required to start analyzing the data (our experience suggests that could even be the low end).

And if you’ve been using Excel to do that preparation, you know full well the pain of dealing with VLOOKUP.

So what’s the cure?

Standalone software tools designed solely for data preparation have become a necessary part of a modern analytics stack. The rising size and complexity of datasets has resulted in a need for correspondingly powerful, flexible solutions. Trifacta was designed to help reduce data cleaning and preparation time by:

  • Enabling better up-front assessment of data sources
  • Supplying smart extraction that learns preferences over time
  • Providing easy-to-use, intelligent, beautiful visualizations that improve data understanding and speed up insights

Trifacta can already do basic VLOOKUP functions, including using multiple columns and more specificity in matching, regardless of column position or case. But there’s so much more you can do with Trifacta:

Crunch the numbers faster
Combine rows from separate datasets to create a new dataset. Picking and choosing individual columns from multiple datasets results in fewer rows — meaning faster load times for your machine.

Wrangle big data
Work without fear of something becoming too big to open. Trifacta handles datasets of any size.

Point and click
Forget building and troubleshooting complex VLOOKUP formulas. Just point and click to perform data operations.

Easily manipulate data elements
Aggregate and multiply data, creating new columns to reference on the fly. For example, you can calculate a percent change and then store that as its own value to graph.

Debug as you go
Why wait until you’re done to see if you’re building something right? Trifacta’s tools update as you go so you can spot potential problems right away.

Collaborate with coworkers
Save and share joins and lookups with colleagues.

Automate your work
Reduce errors and increase speed to insight with Trifacta’s built-in automation tools.

Track changes
Preserve source values and data lineage. If you’re in financial services, you know how critical this is for data compliance.

Progress only goes in one direction, and your data will only get more and more complex as time goes on. Save yourself countless hours of VLOOKUP frustration. Sign up for Trifacta Wrangler and try it for free right now.

Related Posts

Interactive Data Visualization

Interactive data visualization tools that deliver your data in a graphically compelling, easy-to-understand... more

  |  July 27, 2016

Why Hadoop Data Architects Must Be Salespeople

Data architects are expected to create the blueprint for data management. Their world typically revolves... more

  |  May 19, 2016

Designing Visualization Tools: From Data Wrangling to Exploration

The current “big data” era has lead to a proliferation of new technologies that enable a broader... more

  |  November 24, 2015