ETL Critical for Business Intelligence
BI (business intelligence) professionals are facing significant challenges in preparing raw data for analytics according to a new study from Xplenty.
The study focused on several areas of the ETL (Extract, Transform and Load) process, including preferences for on-premise or cloud-based solutions, perceived challenges, and the amount of time spent on ETL. As most BI professionals can attest, the study found that 97 percent of those surveyed indicated ETL was critical for their business intelligence efforts. More than half (51 percent) of BI professionals polled said that they currently leverage on-premise ETL solutions, versus 49 percent cloud-based. However, of those who said they presently use on-premise ETL tools, 51 percent said that they were ‘strongly considering’ moving all ETL processes to the cloud.
"While many organizations still rely heavily on existing on-premise IT for ETL, the desire to shift to a more cloud-based model has never been stronger," said Yaniv Mor, CEO & Co-Founder of Xplenty. "Cloud ETL offers a host of benefits over on-premise, from increased agility in resource deployment to reduced costs. As such, the cloud is an increasingly attractive option from both a performance and operational perspective.”