{"id":8292,"date":"2018-03-06T10:52:04","date_gmt":"2018-03-06T09:52:04","guid":{"rendered":"http:\/\/blog.scalefree.com\/?p=8292"},"modified":"2026-04-16T11:54:31","modified_gmt":"2026-04-16T09:54:31","slug":"wie-man-managed-self-service-bi-mit-data-vault-2-0-kombiniert","status":"publish","type":"post","link":"https:\/\/www.scalefree.com\/de\/blog\/data-vault\/how-to-combine-managed-self-service-bi-with-data-vault-2-0\/","title":{"rendered":"Wie l\u00e4sst sich Managed Self-Service BI mit Data Vault 2.0 kombinieren?"},"content":{"rendered":"<div id=\"fws_69efa64a4ec82\"  data-column-margin=\"default\" data-midnight=\"dark\"  class=\"wpb_row vc_row-fluid vc_row\"  style=\"padding-top: 0px; padding-bottom: 0px; \"><div class=\"row-bg-wrap\" data-bg-animation=\"none\" data-bg-animation-delay=\"\" data-bg-overlay=\"false\"><div class=\"inner-wrap row-bg-layer\" ><div class=\"row-bg viewport-desktop\"  style=\"\"><\/div><\/div><\/div><div class=\"row_col_wrap_12 col span_12 dark left\">\n\t<div  class=\"vc_col-sm-12 wpb_column column_container vc_column_container col no-extra-padding inherit_tablet inherit_phone\"  data-padding-pos=\"all\" data-has-bg-color=\"false\" data-bg-color=\"\" data-bg-opacity=\"1\" data-animation=\"\" data-delay=\"0\" >\n\t\t<div class=\"vc_column-inner\" >\n\t\t\t<div class=\"wpb_wrapper\">\n\t\t\t\t\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2>Combining Managed Self-Service BI with Data Vault 2.0<\/h2>\n<p>Dieser Artikel untersucht, wie die Kombination von <a href=\"https:\/\/www.scalefree.com\/de\/beratung\/managed-self-service-bi\/\">Managed Self-Service BI<\/a> mit <a href=\"https:\/\/www.scalefree.com\/de\/beratung\/data-vault-2-0\/\">Data Vault 2.0<\/a> enables organizations to balance data governance and agility, ensuring both control and flexibility in their analytics processes.Last month we talked about a <a href=\"http:\/\/blog.scalefree.com\/2018\/02\/05\/hybrid-architecture-in-data-vault-2-0\/\">hybrid architecture in Data Vault 2.0<\/a>, where we explain how to combine structured and unstructured data with a hybrid architecture. To follow up on this topic, we now want to explain how your business users (especially power users) can take a benefit from it with the managed Self-Service Business Intelligence (mSSBI) approach in Data Vault 2.0.<\/p>\n<div class=\"ci\"><\/div>\n\t<\/div>\n<\/div>\n\n\n\n\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<div class=\"content-list-wrapper\"><p class=\"content-heading\">In diesem Artikel:<\/p><ul class=\"content-list\"><li><a href=\"#about-self-service-bi\">About Self-Service BI<\/a><li><a href=\"#about-the-managed-self-service-bi-approach\">About the Managed Self-Service BI Approach<\/a><li><a href=\"#implement-mssi-in-the-data-vault-2-0-architecture\">Implement MSSI in the Data Vault 2.0 Architecture<\/a><li><a href=\"#conclusion\">Fazit<\/a><\/ul><\/div>\n<div class=\"ci\"><\/div>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2><span style=\"font-weight: 400; text-align: justify;\">About Self-Service BI<\/span><\/h2>\n\t<\/div>\n<\/div>\n\n\n\n\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"font-weight: 400;\">Self-service BI allows end-users to completely circumvent IT due to this unresponsiveness of IT. In this approach, business users are left on their own with the whole process of sourcing the data from operational systems, integration and consolidation of the raw data. There are many problems with this self-service approach without the involvement of IT:<\/span><\/p>\n<ul>\n<li>Direct access to<a href=\"https:\/\/www.scalefree.com\/scalefree-newsletter\/satellite-modeling-for-any-structural-changes-in-the-source-system\/\"> Quellensysteme<\/a><\/li>\n<li>Unintegrated raw data<\/li>\n<li>Niedrig <a href=\"https:\/\/www.scalefree.com\/scalefree-newsletter\/data-quality-in-the-data-vault-architecture\/\">hoher Datenqualit\u00e4t<\/a><\/li>\n<li>Unconsolidated raw data<\/li>\n<li>Non-standardized business rules<\/li>\n<\/ul>\n<p>In many cases, end-users &#8211; even if they are power users with the knowledge to SQL, MDX, and other techniques, don&#8217;t have the right tools available to solve the tasks. Instead, much work is done manually and error-prone. But from our experience, it is not possible to completely prevent such power users from obtaining data from source systems, preparing it, and eventually reporting the data to upper management. What organizations need is a compromise between IT agility and data management that allows power users to obtain the data they need quickly, in a usable quality. To overcome these problems, the Data Vault 2.0 standard allows experienced or advanced business users to perform their own data analysis tasks on the raw data of the data warehouse.<\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2><span style=\"font-weight: 400; text-align: justify;\">About the Managed Self-Service BI Approach<\/span><\/h2>\n\t<\/div>\n<\/div>\n\n\n\n\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"font-weight: 400; text-align: justify;\">In fact, a Data Vault 2.0 powered IT welcomes business users to take the data that is available in the <a href=\"https:\/\/www.scalefree.com\/consultingterprise-data-warehouse\/\">Enterprise Data Warehouses<\/a> (either in the Raw Data Vault or in the <a href=\"https:\/\/www.scalefree.com\/consulting\/data-vault-2-0\/#business-vault\">Business Vault<\/a>) to create local <a href=\"https:\/\/www.scalefree.com\/scalefree-newsletter\/about-information-marts-in-data-vault-2-0\/\">Information Marts<\/a> using specialized tools. These tools retrieve the data from the enterprise data warehouse, apply a set of user-defined business rules and present the output to the end-user. IT might also create structures where organizational-wide business rules are applied to provide a consolidated view on parts of the model or pre-calculate KPIs to ensure consistency among such calculations. Because both types of data (raw data and business rule applied data) is already integrated, the business user can also join consolidated data with raw data from specific source systems. <\/span>This approach is called Managed Self-Service BI, where IT evolves to a service organization that provides those power users with the data they want, in the timeframe they need. The data is integrated by its business key and can be consolidated as well as quality checked.<\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2><span style=\"font-weight: 400;\">Implement MSSI in the Data Vault 2.0 Architecture<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">The Data Vault 2.0 architecture provides self-service capabilities for power users in the organization:<\/span><\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"img-with-aniamtion-wrap center\" data-max-width=\"100%\" data-max-width-mobile=\"default\" data-shadow=\"none\" data-animation=\"none\" >\n      <div class=\"inner\">\n        <div class=\"hover-wrap\"> \n          <div class=\"hover-wrap-inner\">\n            <img loading=\"lazy\" decoding=\"async\" class=\"img-with-animation Hybrid_architecture skip-lazy nectar-lazy\" data-delay=\"0\" height=\"1838\" width=\"2640\" data-animation=\"none\" data-nectar-img-src=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture.png\" src=\"data:image\/svg+xml;charset=utf-8,%3Csvg%20xmlns%3D'http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg'%20viewBox%3D'0%200%202640%201838'%2F%3E\" alt=\"Verwaltete Selbstbedienung BI und Data Vault 2.0\" data-nectar-img-srcset=\"https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture.png 2640w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-300x209.png 300w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-1024x713.png 1024w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-768x535.png 768w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-1536x1069.png 1536w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-2048x1426.png 2048w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-320x223.png 320w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-640x446.png 640w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-360x251.png 360w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-720x501.png 720w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-1080x752.png 1080w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-800x557.png 800w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-1280x891.png 1280w, https:\/\/www.scalefree.com\/wp-content\/uploads\/2018\/03\/Figure1-mSSBI-Architecture-600x418.png 600w\" sizes=\"auto, (max-width: 2640px) 100vw, 2640px\" \/>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div><div style=\"text-align: center;font-family:Droid Serif;font-weight:400;font-style:normal\" class=\"vc_custom_heading vc_do_custom_heading\" >Figure1 : mSSBI Architecture<\/div><div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<p><span style=\"font-weight: 400;\">In this case, power users who build their own, custom solutions can<a href=\"https:\/\/www.scalefree.com\/de\/blog\/architektur\/write-backs-in-der-enterprise-data-warehouse-architektur\/\"> write back data and information into the Enterprise Data Warehouse<\/a> by leveraging a dedicated user space for this purpose. The write-back can then later be re-used in the solution for information delivery. Furthermore, the business users can manage their own master data by using an MDM application. It enables authorized business users to change the parameter values and therefore influence the results of the business rules.<\/span><\/p>\n<p>The difference between \u201cmanaged\u201d Self-Service BI to the standard Self-Service BI approach from the general industry is that Data Vault 2.0 provides a managed environment where data and information are provided in a controlled and secure manner. Power users can only query the data they are allowed to see from a data security perspective.<br \/>\nAnother advantage is that this approach enables organizations in security and banking industries to provide a fully auditable and traceable environment that meets the highest security requirements.<\/p>\n<p>Managed Self-Service BI does require a write-back possibility in the enterprise data warehouse <a href=\"https:\/\/www.scalefree.com\/scalefree-newsletter\/an-enterprise-document-warehouse-architecture\/\">Architektur-<\/a>, otherwise, it&#8217;s just plain old BI solution. Without write-back, there are no differentiators. Beyond that, write-back is necessary in order for enriching or enhancing the quality of the data being put forward. Data scientists, for example, do this all the time: when using Hadoop they create a new target file as a result of their processing output. This is a direct write-back in the Hadoop space. We have required write-back in Self Service BI for years, otherwise, master data, and hierarchy management don&#8217;t work properly.<\/p>\n<p><span style=\"font-weight: 400;\">Bei dieser \u00c4nderung der Architektur aus dem vorherigen Abschnitt wird der relationale Staging-Bereich durch einen HDFS-basierten Staging-Bereich ersetzt, der alle unstrukturierten und strukturierten Daten erfasst. W\u00e4hrend die Erfassung strukturierter Daten im HDFS auf den ersten Blick als Overhead erscheint, reduziert diese Strategie tats\u00e4chlich die Belastung des Quellsystems, indem sie sicherstellt, dass die Quelldaten immer extrahiert werden, unabh\u00e4ngig von strukturellen \u00c4nderungen. Die Daten werden dann mit Apache Drill, Hive External oder \u00e4hnlichen Technologien extrahiert. <\/span><span style=\"font-weight: 400;\">It is also possible to store the Raw Data Vault and the Business Vault (the structured data in the Data Vault model) on Hive Internal.<\/span><\/p>\n\t<\/div>\n<\/div>\n\n\n\n<div class=\"divider-wrap\" data-alignment=\"default\"><div style=\"height: 25px;\" class=\"divider\"><\/div><\/div>\n<div class=\"wpb_text_column wpb_content_element\" >\n\t<div class=\"wpb_wrapper\">\n\t\t<h2>Fazit<\/h2>\n<p>Combining Managed Self-Service BI with Data Vault 2.0 empowers organizations to strike a balance between governance and agility in their data ecosystems. By leveraging Data Vault&#8217;s structured, auditable architecture alongside self-service BI&#8217;s flexibility, businesses can ensure data accuracy, security, and scalability while enabling users to gain faster insights. This approach enables collaboration between IT and business users, driving more informed decision-making and accelerating data-driven innovation.<\/p>\n\t<\/div>\n<\/div>\n\n\n\n\n\t\t\t<\/div> \n\t\t<\/div>\n\t<\/div> \n<\/div><\/div>","protected":false},"excerpt":{"rendered":"Combining Managed Self-Service BI with Data Vault 2.0 This article explores how combining Managed Self-Service BI with Data Vault 2.0 enables organizations to balance data governance and agility, ensuring both...","protected":false},"author":2,"featured_media":29695,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[101],"tags":[986,1264,586,1327,738,355,890,327,425,1304,1330,1332,1331,436,1326,1325,469,1328,402,857,1329,889],"class_list":{"0":"post-8292","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-data-vault","8":"tag-apache-drill","9":"tag-auditable","10":"tag-business-vault","11":"tag-data-analysis","12":"tag-data-management","13":"tag-data-scientists","14":"tag-data-security","15":"tag-data-vault-2-0","16":"tag-enterprise-data-warehouse","17":"tag-hadoop","18":"tag-hdfs","19":"tag-hierarchy-management","20":"tag-hive-external","21":"tag-hybrid-architecture","22":"tag-it-agility","23":"tag-managed-self-service-business-intelligence","24":"tag-master-data","25":"tag-mssbi","26":"tag-raw-data-vault","27":"tag-self-service-bi","28":"tag-traceable","29":"tag-write-back"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts\/8292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/comments?post=8292"}],"version-history":[{"count":0,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/posts\/8292\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/media\/29695"}],"wp:attachment":[{"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/media?parent=8292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/categories?post=8292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scalefree.com\/de\/wp-json\/wp\/v2\/tags?post=8292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}