{"id":497,"date":"2024-01-01T09:25:27","date_gmt":"2024-01-01T09:25:27","guid":{"rendered":"https:\/\/solutionsreview.com\/expert\/?p=497"},"modified":"2024-02-06T13:58:46","modified_gmt":"2024-02-06T13:58:46","slug":"how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/","title":{"rendered":"How to Succeed with Self-Service Analytics Part 3: The Key to Self-Service: Trust but Verify"},"content":{"rendered":"

Self-service analytics goes awry when business users publish and distribute reports broadly without submitting to an agile review process. This chapter shows how to create a governance process to manage standard reports. <\/em><\/p>\n

Most business users reflexively dislike governance of any kind. Governance processes slow them down, undermine their effectiveness, and make it more difficult to achieve business goals, they say. Yet, without governance, self-service goes awry quickly.<\/p>\n

For governance to work, business users must embrace it. They must see it as an incentive, not an obstacle or punishment. When that happens, report authors gain both empowerment and influence, and the business avoids data chaos. There are several ways to create governance incentives, as we\u2019ll see. Besides, governance must be lightweight and efficient: Service level agreements (SLAs) should be associated with each step in the governance process so business users know they won\u2019t be caught in a permanent IT backlog.<\/p>\n

Without proper governance, the promised land of self-service empowerment quickly descends into hellish data chaos. The goal is to implement lightweight controls that channel user empowerment without creating confusion and misalignment.<\/p>\n

Report Governance<\/h2>\n

Gateway<\/strong>. The first step in governing self-service analytics is to establish a report governance gateway for the publication of approved standard reports for decision-making. Most companies start by standardizing a dozen or so enterprise reports that executives use. Some departments also create standard reports for local consumption.<\/p>\n

An enterprise report gateway governs the distribution of dashboards and reports created by power users for the broader community of casual users. If power users (and IT developers) want their reports consumed by the enterprise, they must submit their report (or a change to an approved report) through the gateway. Business units and departments can also establish report governance gateways for their standard reports.<\/p>\n

The gateway consists of three components:<\/p>\n

1) A report governance review,<\/p>\n

2) An optional production handoff<\/p>\n

3) Platform permissions<\/p>\n

Report Governance Review<\/strong>. Power users kick off the report governance process by submitting a form that describes the new report or requested changes to an existing standard report. Typically, the analytics director or a triage committee review the form for completeness and clarity and then passes it to a review board. With a typical SLA of 2 to 6 days, the board reviews the proposed changes for conformance with corporate data and design standards, then passes the request to a technical sub committee for review of the SQL code, APIs, and query performance. Once approved, the report receives a watermark or seal of approval with a time-stamp.<\/p>\n

The diagram shows a generic process for governing enterprise and departmental reports. Reports that aren\u2019t governed are stored in a personal workspace and shared according to platform permissions. Watermark. The seal of approval is the incentive that drives power users to embrace the governance process because it increases the demand for their reports. The seal is a powerful change agent that gives business users the confidence to trust the figures in the report. As one data analytics leader said, \u201cOur watermark has changed behavior in our organization. When executives open a [self-service] report, they first look for the watermark in the bottom right corner. If it\u2019s not there, they ask why not and question the data.\u201d<\/p>\n

\u201cWhen executives open a [self-service] report, they first look for <\/em>the watermark in the bottom right <\/em>corner. If it\u2019s not there, they ask <\/em>why not and question the data.\u201d<\/em><\/p>\n

This doesn\u2019t mean that every report needs a watermark. Far from it. \u201cNon-certified\u201d reports serve to answer point-in-time questions or are used by a department or workgroup outside of the governance domain. One data analytics leader described following the 80\/20 rule: 80% of reports should be standard reports created or certified by the corporate BI team (or departmental teams), while 20% are non-standard reports created for ad hoc analysis.<\/p>\n

Production<\/strong> Handoff<\/strong>. In the case that a power user submits a report in a non-standard format such as Excel, the review board decides whether the report should be rewritten in a standard format. If the new report contains data, not in the existing data warehouse or data lake, the review board again must decide whether to extend the data warehouse with new data before approving the report.<\/p>\n

Some companies support an array of \u201centerprise standard\u201d reports written in different tools and formats, while others do not. Often, the deciding factor is query performance and data security. Users won\u2019t use a standard enterprise report if it is too slow, and the IT team won\u2019t release a report if it can\u2019t protect against unauthorized data access.<\/p>\n

Platform<\/strong> Permissions<\/strong>. The best way to govern self-service activity is to set the default mode for publishing reports to \u201cSelf Only.\u201d This means that business users can create or modify a report or dashboard but they can\u2019t share it with others. The creator can store the report in a personal workspace for future reference, or they can print the report and show it to colleagues. But they cannot electronically send the report to someone else until they have the authorization to do so, either permanently or on a case-by-case basis.<\/p>\n

The best way to govern self-service activity is to set the <\/em>default mode for publishing <\/em>reports to \u201cSelf Only.\u201d<\/em><\/p>\n

Controlling permissions to hit the \u201csend\u201d button on a report is a key to governance, but few companies consider this until it\u2019s too late. Also, some BI tools don\u2019t support personal workspaces, which makes it impossible to shut down the report floodgates in time.<\/p>\n

Analyst Certification<\/h2>\n

Another way to incent business users to embrace governance is to require them to demonstrate their knowledge of corporate data, standards, and tooling before receiving permission to distribute reports, a license to a self-service tool, or access to corporate data repositories. This can be done through training courses or certification tests, or a combination. The data analytics leader quoted earlier also said, \u201cWe require our data analysts to pass two tests to get a license [to a self-service tool.]\u201d With rights come responsibilities!<\/p>\n

\u201cWe require our data analysts to <\/em>pass two tests to get a license <\/em>[to a self-service tool.]\u201d With <\/em>rights come responsibilities!<\/em><\/p>\n

To get certified, business users should demonstrate knowledge of the company\u2019s key metrics, filters, and hierarchies, and how they are defined and calculated, logically and in SQL. They should also be familiar with the company\u2019s visual design standards and templates and know how to use them correctly. They should also know how to navigate the data warehouse or local data mart and use the self-service tool.<\/p>\n

Some companies also require users to know basic SQL and statistical and numeracy concepts.<\/p>\n

Some power users might object to certification\u2014putting their \u201crights\u201d ahead of any responsibilities\u2014but over time the majority will see certification as a badge of honor. They will aspire to move through multiple tiers of certification to gain status, advance their careers, and perform rewarding work. This quickly becomes a self-reinforcing cycle as business users who have achieved \u201cstatus\u201d motivate others to do likewise.<\/p>\n

Over time the majority will see <\/em>certification as a badge of honor<\/em>.<\/p>\n

Self-service analytics without governance is a disaster in the making. But governance without empowerment is a bureaucratic nightmare. To balance the two, companies need to turn governance into an incentive that business users embrace because they get something they want\u2014a seal of approval or access to a self-service tool or data.<\/p>\n","protected":false},"excerpt":{"rendered":"

Self-service analytics goes awry when business users publish and distribute reports broadly without submitting to an agile review process. This chapter shows how to create a governance process to manage standard reports. Most business users reflexively dislike governance of any kind. Governance processes slow them down, undermine their effectiveness, and make it more difficult to […]<\/p>\n","protected":false},"author":299,"featured_media":651,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[10],"tags":[],"acf":[],"yoast_head":"\nThe Key to Self-Service: Trust but Verify<\/title>\n<meta name=\"description\" content=\"Eckerson Group President Wayne Eckerson explains that the keys to self-service are to "trust but verify" and he shares his thoughts.\" \/>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Key to Self-Service: Trust but Verify\" \/>\n<meta property=\"og:description\" content=\"Eckerson Group President Wayne Eckerson explains that the keys to self-service are to "trust but verify" and he shares his thoughts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/\" \/>\n<meta property=\"og:site_name\" content=\"Solutions Review Thought Leaders\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-01T09:25:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-06T13:58:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Wayne Eckerson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/weckerson\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Wayne Eckerson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/\",\"name\":\"The Key to Self-Service: Trust but Verify\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg\",\"datePublished\":\"2024-01-01T09:25:27+00:00\",\"dateModified\":\"2024-02-06T13:58:46+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/d75007acd275fc4e2eb0f514050d1ca8\"},\"description\":\"Eckerson Group President Wayne Eckerson explains that the keys to self-service are to \\\"trust but verify\\\" and he shares his thoughts.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg\",\"width\":800,\"height\":350,\"caption\":\"The Key to Self-Service: Trust but Verify\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/thought-leaders\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Succeed with Self-Service Analytics Part 3: The Key to Self-Service: Trust but Verify\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#website\",\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/\",\"name\":\"Solutions Review Thought Leaders\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/solutionsreview.com\/thought-leaders\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/d75007acd275fc4e2eb0f514050d1ca8\",\"name\":\"Wayne Eckerson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ea1e94439e0be8b4ecd527de5dcbb3c1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ea1e94439e0be8b4ecd527de5dcbb3c1?s=96&d=mm&r=g\",\"caption\":\"Wayne Eckerson\"},\"description\":\"Wayne Eckerson is an international thought leader in the data and analytics field since the early 1990s. He is a noted speaker, sought-after consultant, and widely read author. Eckerson has conducted groundbreaking research studies, chaired numerous conferences, and consulted with organizations around the world during his 25 years in the field. In 2014, Eckerson formed Eckerson Group to help organizations get more value from their data. His goal was to provide organizations with expert guidance during every stage of their data and analytics journey. As an industry analyst, Wayne thinks critically, writes clearly, and presents persuasively about complex topics. As a consultant, Wayne listens carefully, synthesizes accurately, and delivers highly tailored advice based on local context and personal experience. As an educator, Wayne creates vibrant communities of practice that encourage people to exchange ideas and share lessons learned.\",\"sameAs\":[\"https:\/\/www.eckerson.com\/\",\"https:\/\/www.linkedin.com\/in\/weckerson\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/weckerson\"],\"url\":\"https:\/\/solutionsreview.com\/thought-leaders\/author\/wayne-eckerson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"The Key to Self-Service: Trust but Verify","description":"Eckerson Group President Wayne Eckerson explains that the keys to self-service are to \"trust but verify\" and he shares his thoughts.","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"The Key to Self-Service: Trust but Verify","og_description":"Eckerson Group President Wayne Eckerson explains that the keys to self-service are to \"trust but verify\" and he shares his thoughts.","og_url":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/","og_site_name":"Solutions Review Thought Leaders","article_published_time":"2024-01-01T09:25:27+00:00","article_modified_time":"2024-02-06T13:58:46+00:00","og_image":[{"width":800,"height":350,"url":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg","type":"image\/png"}],"author":"Wayne Eckerson","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/weckerson","twitter_misc":{"Written by":"Wayne Eckerson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/","url":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/","name":"The Key to Self-Service: Trust but Verify","isPartOf":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg","datePublished":"2024-01-01T09:25:27+00:00","dateModified":"2024-02-06T13:58:46+00:00","author":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/d75007acd275fc4e2eb0f514050d1ca8"},"description":"Eckerson Group President Wayne Eckerson explains that the keys to self-service are to \"trust but verify\" and he shares his thoughts.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#primaryimage","url":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg","contentUrl":"https:\/\/solutionsreview.com\/thought-leaders\/files\/2022\/12\/MicrosoftTeams-image-14.jpg","width":800,"height":350,"caption":"The Key to Self-Service: Trust but Verify"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/thought-leaders\/how-to-succeed-with-self-service-analytics-part-3-the-key-to-self-service-trust-but-verify\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/thought-leaders\/"},{"@type":"ListItem","position":2,"name":"How to Succeed with Self-Service Analytics Part 3: The Key to Self-Service: Trust but Verify"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/thought-leaders\/#website","url":"https:\/\/solutionsreview.com\/thought-leaders\/","name":"Solutions Review Thought Leaders","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/solutionsreview.com\/thought-leaders\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/d75007acd275fc4e2eb0f514050d1ca8","name":"Wayne Eckerson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/thought-leaders\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ea1e94439e0be8b4ecd527de5dcbb3c1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea1e94439e0be8b4ecd527de5dcbb3c1?s=96&d=mm&r=g","caption":"Wayne Eckerson"},"description":"Wayne Eckerson is an international thought leader in the data and analytics field since the early 1990s. He is a noted speaker, sought-after consultant, and widely read author. Eckerson has conducted groundbreaking research studies, chaired numerous conferences, and consulted with organizations around the world during his 25 years in the field. In 2014, Eckerson formed Eckerson Group to help organizations get more value from their data. His goal was to provide organizations with expert guidance during every stage of their data and analytics journey. As an industry analyst, Wayne thinks critically, writes clearly, and presents persuasively about complex topics. As a consultant, Wayne listens carefully, synthesizes accurately, and delivers highly tailored advice based on local context and personal experience. As an educator, Wayne creates vibrant communities of practice that encourage people to exchange ideas and share lessons learned.","sameAs":["https:\/\/www.eckerson.com\/","https:\/\/www.linkedin.com\/in\/weckerson\/","https:\/\/x.com\/https:\/\/twitter.com\/weckerson"],"url":"https:\/\/solutionsreview.com\/thought-leaders\/author\/wayne-eckerson\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/posts\/497"}],"collection":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/users\/299"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/comments?post=497"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/posts\/497\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/media\/651"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/media?parent=497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/categories?post=497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/thought-leaders\/wp-json\/wp\/v2\/tags?post=497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}