Migration to data warehouse solutions is continuing to happen across a wide range of industries, according to Panoply’s annual Data Warehouse Trends report.
Migration to data warehouse solutions is continuing to happen across a wide range of industries, according to Panoply’s annual Data Warehouse Trends report, but there are still a lot of small businesses which haven’t started moving their data online.
According to the report, 23 percent of the 800 respondents said they’re not using any data warehouse solution. A further 29 percent said they are using an on-premise warehouse solution. This means there’s still a wealth of businesses that may benefit from migration to a cloud solution.
Data warehouse solutions, while improving every year, are still too difficult to use. More than half of respondents categorized the warehouse as difficult or very difficult to use. Businesses that used on-premise solutions found it most difficult (81%), compared to Google BigQuery (66%) and Amazon Redshift (62%).
There’s clearly still a lot that could be done to improve accessibility for non-technical users, who may be in charge of the data warehouse. This is especially true for small businesses that may not be able to employ technical staff to monitor the data warehouse.
The survey also revealed issues with performance, with Azure SQL Server and BigQuery rated the most “frustrating” due to hanging or slow queries, at 64 and 62 percent, respectively. Amazon Redshift performed a little better, with 54 percent of respondents unhappy with the solution’s efficacy.
Amazon RedShift remains the most popular data warehouse solution but is losing ground to newer solutions. In 2017, 60 percent said they used RedShift, compared to 40 percent in 2019. Google BigQuery and Microsoft Azure SQL Server have not seen major percentage shifts, instead, offerings like Oracle, Snowflake and Panoply are the solutions picking up the ex-Amazon customers.
Read the full report here: https://bit.ly/2Sw3ZYm