{"id":1741,"date":"2019-02-14T14:16:28","date_gmt":"2019-02-14T19:16:28","guid":{"rendered":"https:\/\/solutionsreview.com\/data-management\/?p=1741"},"modified":"2019-02-14T14:16:44","modified_gmt":"2019-02-14T19:16:44","slug":"80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/","title":{"rendered":"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex"},"content":{"rendered":"

\"80<\/p>\n

According to a new study<\/a> commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex, making it a key big data pain point. However, with little evidence to suggest that widespread progress is being made toward those wishing to transition their data management practices to the cloud, one has to wonder what the immediate future looks like for. Panoply polled more than 800 Amazon re:Invent attendees for its third annual Data Warehouse Trend Report<\/em><\/a>, with respondents coming from a variety of roles and ways in which they use data warehousing.<\/p>\n

\t\t\t
\"Download<\/a><\/div>\n\t\t<\/div><\/div>\n

Users aren’t just frustrated with their on-prem environments, as more than half of those polled characterize their data warehouse solutions as either difficult or very difficult to use. This includes cloud products as well, and Panoply notes that responses included nearly every major data warehouse brand in the marketplace. They picked on Redshift a bit more obviously than the rest, with 62 percent of responses taking issue with the complexity of the offering. The report correctly notes that Redshift remains the most adopted data warehouse out there – with a nearly 40 percent market share.<\/p>\n

The biggest performance issue plaguing data warehouses right now is hanging or slow query speeds, with more than half of the 800 respondents citing varying degrees of frustration. It’s likely that the majority of these users are utilizing outdated technologies, and as the need for more complex queries, growing data volumes and deeper analysis continues to grow, the problem will likely fester. The report also outlines other factors likely to play a role, including integration of multiple data sources, lackluster database normalization and shrinking human and technical bandwidth.<\/p>\n

As organizations continue relying on big data to bring them the deep insight they seek, these “feed the beast” processes (as Panoply so eloquently puts it) are only going to increase. This will, in turn, create a need for streamlining and automating many common data management chores in order for organizations to keep pace.<\/p>\n

We encourage you to read the report<\/a> in its entirety.<\/p>\n

<\/div>\n
\t\t\t

\"Download<\/a><\/p>\n<\/div>\n\t\t<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

According to a new study commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex, making it a key big data pain point. However, with little evidence to suggest that widespread progress is being made toward those wishing to transition their data management practices to the […]<\/p>\n","protected":false},"author":23,"featured_media":1743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[1],"tags":[11,37,21,525],"acf":[],"yoast_head":"\n80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex<\/title>\n<meta name=\"description\" content=\"According to a new study commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex\" \/>\n<meta property=\"og:description\" content=\"According to a new study commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/\" \/>\n<meta property=\"og:site_name\" content=\"Data Management Software & Infrastructure | Solutions Review\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-14T19:16:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-14T19:16:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Tim King\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim King\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/\",\"name\":\"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg\",\"datePublished\":\"2019-02-14T19:16:28+00:00\",\"dateModified\":\"2019-02-14T19:16:44+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\"},\"description\":\"According to a new study commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg\",\"width\":800,\"height\":400,\"caption\":\"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/data-management\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#website\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/\",\"name\":\"Data Management Software & Infrastructure | Solutions Review\",\"description\":\"Evaluating Enterprise Master Data Management, Data Governance & Storage Tools.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c\",\"name\":\"Tim King\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg\",\"caption\":\"Tim King\"},\"description\":\"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \\\"Who's Who\\\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.\",\"url\":\"https:\/\/solutionsreview.com\/data-management\/author\/timking\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex","description":"According to a new study commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/","og_locale":"en_US","og_type":"article","og_title":"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex","og_description":"According to a new study commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex.","og_url":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/","og_site_name":"Data Management Software & Infrastructure | Solutions Review","article_published_time":"2019-02-14T19:16:28+00:00","article_modified_time":"2019-02-14T19:16:44+00:00","og_image":[{"width":800,"height":400,"url":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg","type":"image\/jpeg"}],"author":"Tim King","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tim King","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/","url":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/","name":"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex","isPartOf":{"@id":"https:\/\/solutionsreview.com\/data-management\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg","datePublished":"2019-02-14T19:16:28+00:00","dateModified":"2019-02-14T19:16:44+00:00","author":{"@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c"},"description":"According to a new study commissioned by data management provider Panoply, 81 percent of users say their on-prem data warehouse solutions are too complex.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#primaryimage","url":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2019\/02\/oie_ItUkV2FNS90V.jpg","width":800,"height":400,"caption":"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/data-management\/80-percent-of-users-say-their-on-prem-data-warehouse-is-too-complex\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/data-management\/"},{"@type":"ListItem","position":2,"name":"80 Percent of Users Say Their On-Prem Data Warehouse Is Too Complex"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/data-management\/#website","url":"https:\/\/solutionsreview.com\/data-management\/","name":"Data Management Software & Infrastructure | Solutions Review","description":"Evaluating Enterprise Master Data Management, Data Governance & Storage Tools.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/data-management\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/154e152a275103e373e24ada7f2feb5c","name":"Tim King","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/data-management\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg","contentUrl":"https:\/\/solutionsreview.com\/data-management\/files\/2023\/12\/tk.jpg","caption":"Tim King"},"description":"Tim is Solutions Review's Executive Editor covering the human impact of AI on the future of work and learning. He is also the Media Strategist behind Insight Jam (1M+ on YouTube) events and programming. A 2017 and 2018 Most Influential Business Journalist and 2021 \"Who's Who\" in multiple categories, Tim is a recognized thought leader in enterprise tech and AI.","url":"https:\/\/solutionsreview.com\/data-management\/author\/timking\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/1741"}],"collection":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/users\/23"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/comments?post=1741"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/posts\/1741\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media\/1743"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/media?parent=1741"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/categories?post=1741"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/data-management\/wp-json\/wp\/v2\/tags?post=1741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}