{"id":9272,"date":"2023-08-17T12:39:04","date_gmt":"2023-08-17T16:39:04","guid":{"rendered":"https:\/\/solutionsreview.com\/business-intelligence\/?p=9272"},"modified":"2023-08-18T12:05:16","modified_gmt":"2023-08-18T16:05:16","slug":"how-a-semantic-layer-saves-time-and-money","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/","title":{"rendered":"How a Semantic Layer Saves Time and Money"},"content":{"rendered":"

\"\"<\/p>\n

Solutions Review\u2019s <\/strong><\/i>Contributed Content Series<\/u><\/strong><\/i><\/a> is a collection of contributed articles written by thought leaders in enterprise technology. In this feature, AtScale<\/a> CEO David P. Mariani offers commentary on how a semantic layer can save time and money for enterprise organizations.<\/strong><\/i><\/span><\/p>\n

After a brutal pandemic and with a recession looming, just about every organization is trying to figure out how to use data to improve its business and the bottom line. There\u2019s no doubt that organizations that leverage data do better<\/a> than their peers. However, investing in data and analytics can be costly and time-consuming. In this article, we will discuss how introducing a semantic layer into your modern data stack can deliver results faster and cost less.<\/p>\n

Recent Research Indicates Cost and Speed Improvements<\/strong><\/h4>\n

DBP Institute<\/a>, a data and analytics research firm, conducted a survey of data leaders to study how their investment in a semantic layer improved results and lowered costs. In the report Business Impact of Using a Semantic Layer for BI & AI,<\/em><\/a> the DBP Institute found that a semantic layer reduced costs by 3.7 times while reducing time to insights by 4.4 times.<\/p>\n

The study found that a semantic layer primarily had a positive effect in 3 areas:<\/p>\n

    \n
  1. A reduction in required manual labor<\/li>\n
  2. A reduction in cloud computing costs<\/li>\n
  3. An improvement in overall ROI<\/li>\n<\/ol>\n

    Let\u2019s take a closer look at each of these impacts.<\/p>\n

    \t\t\t

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

    Benefits of a Semantic Layer<\/strong><\/h2>\n

    Reducing Required Manual Labor<\/strong><\/h3>\n

    Delivering a new data asset to the business typically requires several manual steps to be taken by data engineers, including moving and transforming the data (ETL\/ELT); and optimizing the data for acceptable query performance.<\/p>\n

    Writing, testing, and optimizing code is a costly and time-consuming task that\u2019s never quite \u201cdone.\u201d According to a Wakefield Research survey<\/a>, data engineers spent 44 percent of their time maintaining ETL (Extract, Transform, Load) pipelines at an average cost of $520,000 a year.<\/p>\n

    A semantic layer eliminates most manual ETL steps by employing data virtualization to logically map and transform data using a semantic data model. A virtual data model, authored by a business-oriented data steward, removes most dependencies on data engineers and empowers the business to create their own data products.<\/p>\n

    Besides removing the data engineering middleman, a semantic layer also automates query tuning by learning query patterns and optimizing queries without the need for data engineering intervention.<\/p>\n

    By replacing time-consuming ETL\/ELT (Extract, Load, Transform) tasks with data virtualization and automating performance tuning, DBP\u2019s research respondents reported that a \u201ctypical\u201d project not using a semantic layer would require approximately 903 hours. Performing the same \u201ctypical\u201d project using a semantic layer would take only 484 hours, a reduction of 419 hours, or 46 percent.<\/p>\n

    Reducing Cloud Computing Costs<\/strong><\/h3>\n

    Most organizations have already migrated or are migrating their analytics infrastructure to the cloud. In doing so, enterprises are implicitly trading fixed capital expenditures (CAPEX) for variable operational expenditures (OPEX), making budgeting challenging and cloud computing costs unpredictable. Simultaneously, the cloud\u2019s infinite elasticity enables more users and more queries, driving more analytics demand and even more variable costs.<\/p>\n

    A semantic layer can reduce cloud computing costs substantially and make those costs more predictable with automated query optimization. By tracking end-user queries and using AI to cache data and optimize queries autonomously, a semantic layer reduces or eliminates redundant queries and eliminates unnecessary I\/O, the primary driver for most cloud data platform computing costs.<\/p>\n

    Since the semantic layer \u201cunderstands\u201d the semantics of each query, it can rewrite queries to find the lowest cost approach that answers end-users questions, thereby reducing costs by 3.1x.<\/p>\n

    Improving Overall Return on Investment<\/strong><\/h3>\n

    Organizations, on average, spend between 2-6 percent of their total budget<\/a> for data and analytics, and for good reason. We already know that organizations that use data effectively perform better than their peers.<\/p>\n

    There\u2019s a nuance to these statistics, though. For data to make a difference in the business, it\u2019s imperative that everyone uses data to make decisions, not just those with advanced data skills. By presenting data in a business-friendly way, a semantic layer makes more data accessible to more users, enabling the organization to make more informed decisions.<\/p>\n

    By distributing the costs or producing analytics over a larger number of users, organizations can expect to see a 3.9x improvement in their return on investment.<\/p>\n

    A Key Part of the Modern Data and Analytics Stack<\/strong><\/h3>\n

    As you can see above, a semantic layer can improve an organization’s ability to deliver new data to the business faster and at scale by reducing manual labor. In addition, by eliminating workload repetition, a semantic layer can significantly reduce data platform computing costs while improving query performance by an order of magnitude for users.<\/p>\n

    It\u2019s not surprising that a semantic layer is becoming an increasingly popular addition to the modern data and analytics stack.<\/p>\n

    \t\t\t

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

    Solutions Review\u2019s Contributed Content Series is a collection of contributed articles written by thought leaders in enterprise technology. In this feature, AtScale CEO David P. Mariani offers commentary on how a semantic layer can save time and money for enterprise organizations. After a brutal pandemic and with a recession looming, just about every organization is […]<\/p>\n","protected":false},"author":158,"featured_media":9273,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[4],"tags":[366,1794],"acf":[],"yoast_head":"\nHow a Semantic Layer Saves Time and Money<\/title>\n<meta name=\"description\" content=\"AtScale CEO David P. Mariani offers commentary on how a semantic layer can save time and money for enterprise organizations.\" \/>\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\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dave Mariani\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/\",\"name\":\"How a Semantic Layer Saves Time and Money\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2023\/08\/Data-Integration-1.jpg\",\"datePublished\":\"2023-08-17T16:39:04+00:00\",\"dateModified\":\"2023-08-18T16:05:16+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/822a84fd4e77e62019eb7594e8e172b1\"},\"description\":\"AtScale CEO David P. Mariani offers commentary on how a semantic layer can save time and money for enterprise organizations.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2023\/08\/Data-Integration-1.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2023\/08\/Data-Integration-1.jpg\",\"width\":800,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/business-intelligence\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How a Semantic Layer Saves Time and Money\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/\",\"name\":\"Business Intelligence & Data Analytics Platforms | Solutions Review\",\"description\":\"Evaluating Enterprise BI Tools, Visual Dashboards & Embedded Analytics Software.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/business-intelligence\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/822a84fd4e77e62019eb7594e8e172b1\",\"name\":\"Dave Mariani\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ce5c707765629afdea0a9725e86f835b?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ce5c707765629afdea0a9725e86f835b?s=96&d=blank&r=g\",\"caption\":\"Dave Mariani\"},\"description\":\"Dave is the founder and Chief Technology Officer for AtScale. Prior to AtScale, Dave ran data and analytics for Yahoo! where he pioneered the development of Hadoop for analytics and created the world's largest multi-dimensional analytics platform.\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/author\/dmariani\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How a Semantic Layer Saves Time and Money","description":"AtScale CEO David P. Mariani offers commentary on how a semantic layer can save time and money for enterprise organizations.","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\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/","twitter_misc":{"Written by":"Dave Mariani","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/","url":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/","name":"How a Semantic Layer Saves Time and Money","isPartOf":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2023\/08\/Data-Integration-1.jpg","datePublished":"2023-08-17T16:39:04+00:00","dateModified":"2023-08-18T16:05:16+00:00","author":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/822a84fd4e77e62019eb7594e8e172b1"},"description":"AtScale CEO David P. Mariani offers commentary on how a semantic layer can save time and money for enterprise organizations.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#primaryimage","url":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2023\/08\/Data-Integration-1.jpg","contentUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2023\/08\/Data-Integration-1.jpg","width":800,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/business-intelligence\/how-a-semantic-layer-saves-time-and-money\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/business-intelligence\/"},{"@type":"ListItem","position":2,"name":"How a Semantic Layer Saves Time and Money"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website","url":"https:\/\/solutionsreview.com\/business-intelligence\/","name":"Business Intelligence & Data Analytics Platforms | Solutions Review","description":"Evaluating Enterprise BI Tools, Visual Dashboards & Embedded Analytics Software.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/business-intelligence\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/822a84fd4e77e62019eb7594e8e172b1","name":"Dave Mariani","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ce5c707765629afdea0a9725e86f835b?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ce5c707765629afdea0a9725e86f835b?s=96&d=blank&r=g","caption":"Dave Mariani"},"description":"Dave is the founder and Chief Technology Officer for AtScale. Prior to AtScale, Dave ran data and analytics for Yahoo! where he pioneered the development of Hadoop for analytics and created the world's largest multi-dimensional analytics platform.","url":"https:\/\/solutionsreview.com\/business-intelligence\/author\/dmariani\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/9272"}],"collection":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/users\/158"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/comments?post=9272"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/9272\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media\/9273"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media?parent=9272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/categories?post=9272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/tags?post=9272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}