The Future of Data Preparation Tools

Augmented Analytics Tools Squeeze Stand-Alone Data Prep Vendors

Daren Brabham PhD | ETR Research  

| August 19, 2022

As self-service business intelligence programs mature across organizations, the challenge of data wrangling quickly becomes more apparent. Several tools on the market strive to make data preparation a self-serviceable task that relatively non-technical business users can do for themselves. With their easy, graphical, drag-and-drop interfaces, tools like Alteryx, Talend, or Matillian let business users build complex data flows for analytics. But what does the future hold for these stand-alone data preparation tools? ETR recently published an industry analysis report that explores this question.

Recent Technology Spending Intentions Survey (TSIS) data shows spending intentions remain strong and growing for Alteryx, which recently acquired competitor Trifacta, while tools like Talend and Hitachi Pentaho are on the decline:

Net Score (y-axis) over time for Alteryx (black line), Hitachi Pentaho (yellow line), and Talend (blue line) (Technology Spending Intentions Survey).
Image Credit: Net Score (y-axis) over time for Alteryx (black line), Hitachi Pentaho (yellow line), and Talend (blue line) (Technology Spending Intentions Survey).

Despite the strength of Alteryx, however, the report discusses two specific threats that may be on the horizon for stand-alone data preparation tools:

1. Improved Data Preparation Capabilities in Business Intelligence Tools

The mainstream and pervasive self-service business intelligence vendors have invested in making data preparation capabilities more business user-friendly, adding similar drag-and-drop functionality and more sophisticated governance and manageability over data flows built within the tool ecosystems. The major players here include Microsoft Power BI, with its Dataflows and Common Data Model features; Salesforce’s Tableau, with its Tableau Prep Builder; and Qlik’s Dataflows concept, Qlik Catalog, and Qlik Replicate.

Pull quote on visualization tools
Image Credit: Pull quote on visualization tools

2. Augmented Analytics Leap-Frogging Business-Led Data Preparation

Augmented analytics, which describes business intelligence and data visualization driven by natural language processing (NLP), AI/ML, and automation, poses a different kind of threat to stand-alone data preparation tools entirely. With these capabilities, business users need only type or speak simple search queries and get visualizations and explanations of data delivered to them in real-time, with no need to do any serious data preparation.

The big business intelligence tools have all invested heavily in these capabilities: Microsoft Power BI’s Q&A feature, Tableau’s Ask Data and Explain Data features, and Qlik’s Insight Bot. There are also tools in the market that focus primarily on augmented analytics capabilities, most notably ThoughtSpot. While ThoughtSpot’s Net Sentiment has been declining, it continues to grow beyond its augmented analytics niche and capture new customers with better integrations, partnerships, and governance capabilities.

Access the ETR research platform to read the full report to learn more about these industry trends. Not an ETR member yet? Request your Free Trial today.

Enterprise Technology Research (ETR) is a technology market research firm that leverages proprietary data from our targeted IT decision maker (ITDM) community to bring you actionable insights about spending intentions and industry trends. Since 2010, we have worked diligently at achieving one goal: eliminating the need for opinions in enterprise research, which are often formed from incomplete, biased, and statistically insignificant data. Our community of ITDMs represents $1+ trillion in annual IT spend and is positioned to provide best-in-class customer/evaluator perspectives. ETR’s proprietary data and insights from this community empower institutional investors, technology companies, and ITDMs to navigate the complex enterprise technology landscape amid an expanding marketplace. Discover what ETR can do for you at www.etr.ai