{"id":1434,"date":"2012-07-12T07:52:03","date_gmt":"2012-07-12T10:52:03","guid":{"rendered":"http:\/\/www.bxbsoft.com\/en\/?p=1434"},"modified":"2012-07-12T07:52:03","modified_gmt":"2012-07-12T10:52:03","slug":"riding-herd-excel-bi-use-isnt-easy-necessary","status":"publish","type":"post","link":"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/","title":{"rendered":"Riding herd on Excel BI use isn&#8217;t easy, but it&#8217;s necessary"},"content":{"rendered":"<p style=\"text-align: justify;\">Business intelligence managers once talked longingly about weaning end users off their Excel addictions to help ensure that BI data remained consistent and secure. Yeah, right: In most cases, efforts to eradicate Excel from BI processes went nowhere, forcing BI teams to shift to a strategy of accommodating rather than eliminating it.<\/p>\n<p style=\"text-align: justify;\">\u201cWe have fought the war for 20 years and we have lost,\u201d said Boris Evelson, an analyst at Forrester Research Inc. in Cambridge, Mass. What BI managers need to do now, he added, is work to control and <a title=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240018042\/Gartner-BI-Summit-Wave-the-white-flag-on-using-Excel-for-business-intelligence\" href=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240018042\/Gartner-BI-Summit-Wave-the-white-flag-on-using-Excel-for-business-intelligence\">manage Excel BI use<\/a> as best they can. For example, Evelson recommended that Excel be integrated with <a title=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240147171\/Cryptic-BI-software-prices-need-decoding-observers-say\" href=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240147171\/Cryptic-BI-software-prices-need-decoding-observers-say\">BI software<\/a> that can export data to spreadsheets, enabling Excel to function more as a user interface and data presentation layer than as a data manipulation tool itself.<\/p>\n<p style=\"text-align: justify;\">There\u2019s no simple recipe, though, for keeping business users from going in their own directions with Excel. \u201cIt\u2019s sort of like herding cats,\u201d said Rick Sherman, founder of consultancy Athena IT Solutions in Stow, Mass. \u201cYou\u2019re never going to fully control Excel. Anyone who thinks they will is fooling themselves.\u201d<\/p>\n<p style=\"text-align: justify;\">To achieve that goal, Sherman, Evelson and Bill Brydges, a managing director at consulting company MorganFranklin in McLean, Va., all cited the same keyword: governance.<\/p>\n<p><strong>Excel BI use OK here, not there<\/strong><\/p>\n<p style=\"text-align: justify;\">Evelson said companies should implement spreadsheet-usage governance policies that are flexible but will be enforced. Under such policies, Excel use could be allowed for reporting and analysis within individual workgroups but not for <a title=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240020354\/Gartner-Enterprise-BI-strategy-rarely-a-one-size-fits-all-approach\" href=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240020354\/Gartner-Enterprise-BI-strategy-rarely-a-one-size-fits-all-approach\">enterprisewide BI functions<\/a>. Nor should it be allowed as part of particularly sensitive processes, such as regulatory reporting, he said.<\/p>\n<p style=\"text-align: justify;\">Similarly, Sherman said companies could extend existing <a title=\"http:\/\/searchdatamanagement.techtarget.com\/news\/2240146590\/Data-governance-programs-expose-hills-to-climb-on-path-to-success\" href=\"http:\/\/searchdatamanagement.techtarget.com\/news\/2240146590\/Data-governance-programs-expose-hills-to-climb-on-path-to-success\">data governance programs<\/a> to include Excel usage. He cautioned, though, that BI managers should tread lightly and try to sell proposed governance policies on the basis of factors such as potential productivity improvements they could lead to or the need to provide uniform BI data and findings to corporate executives. \u201cIf you try to be heavy-handed, that\u2019s a losing battle,\u201d he said.<\/p>\n<p style=\"text-align: justify;\">Excel usage for BI purposes is \u201cmore of a symptom than a problem in and of itself,\u201d Brydges said. \u201cPeople turn to Excel when it is the only tool they have to manipulate data.\u201d To prevent its use from becoming problematic, he advised, BI teams should incorporate Excel as a key component of fully integrated <a title=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240025274\/Efforts-to-expand-business-intelligence-process-slow-to-take-hold\" href=\"http:\/\/searchbusinessanalytics.techtarget.com\/news\/2240025274\/Efforts-to-expand-business-intelligence-process-slow-to-take-hold\">BI processes<\/a> so it isn\u2019t treated as a standalone technology or a bridge to <a title=\"http:\/\/searchbusinessanalytics.techtarget.com\/video\/In-the-trenches-Benefits-and-pitfalls-of-deploying-a-BI-system\" href=\"http:\/\/searchbusinessanalytics.techtarget.com\/video\/In-the-trenches-Benefits-and-pitfalls-of-deploying-a-BI-system\">BI systems<\/a>.<\/p>\n<p style=\"text-align: justify;\">\u201cUsers will continue to rely on Excel and other tools to get simple tasks done, and they should,\u201d Brydges said. \u201cThe point is to control the governance of when data from that type of approach is integrated into enterprise business processes and reporting.\u201d<\/p>\n<p style=\"text-align: justify;\">Sherman added, though, that BI tools in general support tighter integration with Excel than they did in the days when spreadsheets were viewed as the enemy of <a title=\"http:\/\/searchbusinessanalytics.techtarget.com\/answer\/Tips-on-how-to-properly-use-Excel-for-business-intelligence-projects\" href=\"http:\/\/searchbusinessanalytics.techtarget.com\/answer\/Tips-on-how-to-properly-use-Excel-for-business-intelligence-projects\">proper business intelligence techniques<\/a>. For the most part, he said, BI vendors have now adopted a coexistence strategy when it comes to dealing with Excel.<\/p>\n<p style=\"text-align: justify;\">\u00a0<\/p>\n<p style=\"text-align: justify;\"><em>Author: Alan R. Earls, a Boston-area freelance writer focused on business and technology. Craig Stedman, executive editor of SearchBusinessAnalytics.com, also contributed to this story.<\/em><\/p>\n<p style=\"text-align: justify;\"><em>\u00a0<\/em><\/p>\n<p><em>Source:<\/em><\/p>\n<p><a title=\"http:\/\/searchbusinessanalytics.techtarget.com\/feature\/Riding-herd-on-Excel-BI-use-isnt-easy-but-its-necessary?asrc=EM_EDA_17998171\" href=\"http:\/\/searchbusinessanalytics.techtarget.com\/feature\/Riding-herd-on-Excel-BI-use-isnt-easy-but-its-necessary?asrc=EM_EDA_17998171\">http:\/\/searchbusinessanalytics.techtarget.com\/feature\/Riding-herd-on-Excel-BI-use-isnt-easy-but-its-necessary?asrc=EM_EDA_17998171<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Business intelligence managers once talked longingly about weaning end users off their Excel addictions to help ensure that BI data remained consistent and secure. Yeah, right: In most cases, efforts to eradicate Excel from BI processes went nowhere, forcing BI teams to shift to a strategy of accommodating rather than eliminating it. \u201cWe have fought [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Riding herd on Excel BI use isn&#039;t easy, but it&#039;s necessary - Business Intelligence software - BXBsoft<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Riding herd on Excel BI use isn&#039;t easy, but it&#039;s necessary - Business Intelligence software - BXBsoft\" \/>\n<meta property=\"og:description\" content=\"Business intelligence managers once talked longingly about weaning end users off their Excel addictions to help ensure that BI data remained consistent and secure. Yeah, right: In most cases, efforts to eradicate Excel from BI processes went nowhere, forcing BI teams to shift to a strategy of accommodating rather than eliminating it. \u201cWe have fought [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/\" \/>\n<meta property=\"og:site_name\" content=\"Business Intelligence software - BXBsoft\" \/>\n<meta property=\"article:published_time\" content=\"2012-07-12T10:52:03+00:00\" \/>\n<meta name=\"author\" content=\"adminwp\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"adminwp\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/\",\"url\":\"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/\",\"name\":\"Riding herd on Excel BI use isn't easy, but it's necessary - Business Intelligence software - BXBsoft\",\"isPartOf\":{\"@id\":\"https:\/\/www.bxbsoft.com\/en\/#website\"},\"datePublished\":\"2012-07-12T10:52:03+00:00\",\"dateModified\":\"2012-07-12T10:52:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.bxbsoft.com\/en\/#\/schema\/person\/74369fed9274a37d983a99a899edb64c\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bxbsoft.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Riding herd on Excel BI use isn&#8217;t easy, but it&#8217;s necessary\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bxbsoft.com\/en\/#website\",\"url\":\"https:\/\/www.bxbsoft.com\/en\/\",\"name\":\"Business Intelligence software - BXBsoft\",\"description\":\"Business Intelligence software - BXBsoft\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bxbsoft.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.bxbsoft.com\/en\/#\/schema\/person\/74369fed9274a37d983a99a899edb64c\",\"name\":\"adminwp\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bxbsoft.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/199c0be7796c948f6810671e1492cf53?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/199c0be7796c948f6810671e1492cf53?s=96&d=mm&r=g\",\"caption\":\"adminwp\"},\"url\":\"https:\/\/www.bxbsoft.com\/en\/author\/adminwp\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Riding herd on Excel BI use isn't easy, but it's necessary - Business Intelligence software - BXBsoft","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:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/","og_locale":"en_US","og_type":"article","og_title":"Riding herd on Excel BI use isn't easy, but it's necessary - Business Intelligence software - BXBsoft","og_description":"Business intelligence managers once talked longingly about weaning end users off their Excel addictions to help ensure that BI data remained consistent and secure. Yeah, right: In most cases, efforts to eradicate Excel from BI processes went nowhere, forcing BI teams to shift to a strategy of accommodating rather than eliminating it. \u201cWe have fought [&hellip;]","og_url":"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/","og_site_name":"Business Intelligence software - BXBsoft","article_published_time":"2012-07-12T10:52:03+00:00","author":"adminwp","twitter_misc":{"Written by":"adminwp","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/","url":"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/","name":"Riding herd on Excel BI use isn't easy, but it's necessary - Business Intelligence software - BXBsoft","isPartOf":{"@id":"https:\/\/www.bxbsoft.com\/en\/#website"},"datePublished":"2012-07-12T10:52:03+00:00","dateModified":"2012-07-12T10:52:03+00:00","author":{"@id":"https:\/\/www.bxbsoft.com\/en\/#\/schema\/person\/74369fed9274a37d983a99a899edb64c"},"breadcrumb":{"@id":"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bxbsoft.com\/en\/riding-herd-excel-bi-use-isnt-easy-necessary\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bxbsoft.com\/en\/"},{"@type":"ListItem","position":2,"name":"Riding herd on Excel BI use isn&#8217;t easy, but it&#8217;s necessary"}]},{"@type":"WebSite","@id":"https:\/\/www.bxbsoft.com\/en\/#website","url":"https:\/\/www.bxbsoft.com\/en\/","name":"Business Intelligence software - BXBsoft","description":"Business Intelligence software - BXBsoft","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bxbsoft.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.bxbsoft.com\/en\/#\/schema\/person\/74369fed9274a37d983a99a899edb64c","name":"adminwp","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bxbsoft.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/199c0be7796c948f6810671e1492cf53?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/199c0be7796c948f6810671e1492cf53?s=96&d=mm&r=g","caption":"adminwp"},"url":"https:\/\/www.bxbsoft.com\/en\/author\/adminwp\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/posts\/1434"}],"collection":[{"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/comments?post=1434"}],"version-history":[{"count":0,"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/posts\/1434\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/media?parent=1434"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/categories?post=1434"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bxbsoft.com\/en\/wp-json\/wp\/v2\/tags?post=1434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}