skip to main content
Close Icon We use cookies to improve your website experience.  To learn about our use of cookies and how you can manage your cookie settings, please see our Cookie Policy.  By continuing to use the website, you consent to our use of cookies.
Global Search Configuration

Ovum view


Data preparation and the process to extract, transform, and load (ETL) data for use in analytics manipulation both represent a growing pain in the market for data management. For the large enterprise, this process is difficult enough; the big data era necessitates ingestion and quality control of a vast variety and volume of data types that must frequently be standardized for cross analysis, often requiring a team of data scientists. But for smaller organizations that cannot maintain a full team of dedicated professionals and tools for ETL, this task is even more daunting. To accelerate the move into a true analytics-driven business model and increase access to data, these groups need more intuitive ETL and data prep tools in order to democratize the data quality process among knowledge workers.

Data veracity drives business value, and ETL is a bottleneck

Enterprise size can often be used as a rough proxy for the volume of data being leveraged on a regular basis. Generally, larger sets of data provide more robust statistical findings and insight … but only if the data is accurate to begin with. For smaller organizations dealing with smaller sets of data, the challenge of data quality is further compounded, and ETL presents a major bottleneck. To bridge the gap from reactive ad hoc analysis of data to more fluid and iterative use of data, these businesses need ETL capabilities that can be implemented by a more diverse audience of users.

The pressure to extend analytics tool functionality to a wider, less technical user audience is a natural consequence of the rise of self-serve analytics models. However, an increase in the number of “casual” business users of analytics also necessitates an increase in vigilance towards data quality and security, because more decisions are being made on the basis of the findings. Ovum believes that as businesses try to advance towards a holistic, governed data lake approach, there is a need for more user-friendly ETL features so that the data lake itself can be more quickly populated with validated content. With ETL and data preparation often acting as the middle infrastructure layer between data collection and data use, ease of use would create more transparency, speed, and value for the entire process.



Paige Bartley, Senior Analyst, Information Management

Recommended Articles

  • Service Provider Markets, Consumer & Entertainment Services,...

    MWC 2018 Highlights

    By Ronan De Renesse 27 Feb 2018

    Over 20 of our senior Ovum analysts and consultants attended this year’s Mobile World Congress in Barcelona at the end of February. In between meetings, briefings and presentations, our analyst team were blogging and tweeting about key developments, trends and rumors. Have a look through our daily MWC 2018 Highlights to find out what happened.

    Topics 5G AI IoT Cloud Payments SDN/NFV Smart home

  • Consumer & Entertainment Services

    US pay TV: Is it facing an existential threat?

    By Adam Thomas 28 Mar 2018

    With US pay TV having endured the worst year in its history, thoughts have inevitably turned to the future. The likelihood remains that the immediate future will remain highly uncomfortable for everyone except the scaled multinational digital platforms.

  • Enterprise Decision Maker, Enterprise IT Strategy and Select...

    2017 Trends to Watch: Big Data

    By Tony Baer 21 Nov 2016

    The breakout use case for big data will be fast data. The Internet of Things (IoT) is increasing the urgency for enterprises to embrace real-time streaming analytics, as use cases from mobile devices and sensors become compelling to a wide range of industry sectors.

    Topics Big data and analytics IoT


Have any questions? Speak to a Specialist

Europe, Middle East & Africa team - +44 (0) 207 017 7700

Asia-Pacific team - +61 (0)3 960 16700

US team - +1 646 957 8878

Email us at

You can also contact your named/allocated Client Services Executive using their direct dial.
PR enquiries - Call us at +44 788 597 5160 or email us at

Contact marketing -

Already an Ovum client? Login to the Knowledge Center now