Survey: Rapid time to value is the main driver for analytics projects, yet making data available is a barrier for 90% of enterprises

Findings from MarketPulse survey by Matillion and IDG Research examine enterprise challenges in sequencing, processing and utilizing data

DENVER and MANCHESTER, England, Oct. 21, 2019 /PRNewswire/ -- Matillion, the leading provider of data transformation software for cloud data warehouses (CDWs), and IDG Research have released findings of an IDG Research MarketPulse survey, "Optimizing Business Analytics by Transforming Data in the Cloud." The research exposes the challenges companies face and the strategies they use to prepare data for BI and analytics, with faster time-to-value for implementing analytics projects rising as the main driver for migrating to a cloud approach.

A MarketPulse survey by Matillion and IDG Research finds more than 90% of enterprises find it challenging to make data available in a format usable for analytics.

The survey polled more than 200 IT, data science, and data engineering professionals at North American organizations with at least 1,000 employees. The top takeaways include:

Enterprises struggle to use data volumes for actionable insights.

On average, data volumes are growing at a rate of 63% a month

12% report that their data volumes are growing at 100% or more per month More than 20% of those surveyed report drawing from 1,000 or more data sources

Responsibility for exploiting data is divided between IT groups (55%) and business units (45%)

Enterprises are tapping the cloud to simplify and scale data management.

While less than one-quarter (23%) of respondents have completely centralized their BI and analytics teams, virtually all plan to tap the cloud for data management, migrate or continue to migrate data to the cloud over the next 24 months

90% have already placed some data in CDWs

37% of organizational data is in CDWs, 35% is in on-premises data warehouses, and 25% is in offsite, non-CDWs

Three CDWs dominate: Amazon Redshift (used by 54% of the respondents), Google BigQuery (50%), and Snowflake (26%)

The top reason enterprises migrate their data to cloud platforms is faster time-to-value for implementing analytics projects

Despite broad and growing use of CDWs, they aren't a panacea;

CDW adoption alone does not address all data analytics needs.

More than 90% said it is challenging to make data available in a format usable for analytics

Respondents cited several obstacles slowing their data analytics projects, including a lack of necessary data granularity; manual coding of data pipelines; and difficulty connecting with multiple data sources Part of the challenge is in how enterprises are using legacy ETL processes in a modern data environment.

Many struggle with the sequence and process of data transformation; more than one-third (37%) manually code data into the necessary format before loading it into BI and analytics tools

Only 28% load data into the cloud and then use the cloud platform to automate the transformation process

Data portability (45%) and scalability (46%) top the list of perceived benefits of a modern approach to data transformation

"Without the right data management strategy, growing data volumes go from a competitive advantage to a company-wide struggle to make it useful," said Matthew Scullion, CEO of Matillion. "Our research underscores the demand and the urgency to use the flexibility and scalability of the cloud - not just to store data, but also to accelerate insights through data transformation."

For the full results of the Matillion IDG Research MarketPulse survey, visit For an infographic depicting the results, visit

About Matillion

Matillion is data transformation for cloud data warehouses. Only Matillion is purpose-built for Amazon Redshift, Snowflake, and Google BigQuery, enabling businesses to achieve new levels of simplicity, speed, scale, and savings. Trusted by companies of all sizes to meet their data integration and transformation needs, Matillion products are highly rated across the AWS, GCP and Microsoft Azure Marketplaces. Dual-headquartered in Manchester, UK and Denver, Colorado, Matillion also has offices in New York City and Seattle. Learn more about how you can unlock the potential of your data with Matillion's cloud-based approach to data transformation. Visit us at

SOURCE Matillion

Related Link

DSS Home |  About Us |  Contact Us |  Site Index |  Subscribe | What's New
Please Tell 
Your Friends about DSSResources.COM Copyright © 1995-2015 by D. J. Power (see his home page). DSSResources.COMsm is maintained by Daniel J. Power. Please contact him at djpower1950 at with questions. See disclaimer and privacy statement.