{"id":167,"date":"2011-06-18T18:17:55","date_gmt":"2011-06-18T12:47:55","guid":{"rendered":"http:\/\/www.jkspeaks.com\/wordpress\/?p=167"},"modified":"2026-07-05T00:58:30","modified_gmt":"2026-07-05T05:58:30","slug":"dw_rationalization","status":"publish","type":"post","link":"https:\/\/www.jkspeaks.com\/wordpress\/consulting\/dw_rationalization\/","title":{"rendered":"Data Warehouse Rationalization: The Next Level"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\"><span style=\"color: #333333;\">Introduction<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">As the organization grows organically or inorganically, there will be an infusion of multiple technologies, loss of governance, and a drift away from the centralized model. In some organizations where the BI environment is not robust, there will be an increased usage of MS Excel and MS Access to meet various business needs like cross-functional reporting, dashboards, etc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When the organization is small, one can cater to the business requirements by manually crunching numbers. But as it grows, factors like localization, compliance, availability, and skill set of resources make it unmanageable and tedious. Similarly, when the usage of Excel spreadsheets grows, the complexity also grows along with it (macros, interlinked excels, etc.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">There are various models and frameworks for rationalization available in the industry today. Each model is designed to address a specific problem and offer an excellent short-term solution. Interestingly, all these industry models lack two important factors. A governance component and pillars\/enablers to sustain the effort and add value to the client.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"color: #333333;\">Rationalization \u2013 The piecemeal problem:<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When the environment slowly starts to become unmanageable, organizations look towards rationalization as a solution. Some of the factors that lead to the need for rationalization are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Compliance issues<\/li>\n\n\n\n<li>License fees consuming a large portion of the revenue<\/li>\n\n\n\n<li>Consolidation of operations is a bottleneck<\/li>\n\n\n\n<li>Data inconsistency start to creep in<\/li>\n\n\n\n<li>Integration post merger or acquisition<\/li>\n\n\n\n<li>Analysts spending more time validating the data rather than analyzing the information<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Generally organizations identify what needs\u00a0rationalization based on what is impacting their revenue or productivity the most. E.g., tool license fee. Consultants are then called\u00a0to fix that particular problem and move on. There are two issues here:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the consultant concentrates only on the problem at hand and does not validate the environment for the root cause to fix it permanently<\/li>\n\n\n\n<li>Second, the framework used by the consultant fixes the problem perfectly from a short-term perspective and does not guarantee a long-term solution<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"color: #333333;\">The Solution:<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Rationalization models in the industry today need\u00a0an update for the inclusion of a governance component to help assess, rectify, and sustain the rationalization effort in the long run. In addition to this, enabling components need to be identified and included to add value to the overall exercise.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/steps.png\"><img loading=\"lazy\" decoding=\"async\" width=\"391\" height=\"38\" src=\"https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/steps.png\" alt=\"\" class=\"wp-image-169\" srcset=\"https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/steps.png 391w, https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/steps-300x29.png 300w\" sizes=\"auto, (max-width: 391px) 100vw, 391px\" \/><\/a><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">A typical rationalization model with a governance component and post-rationalization enablers would look as shown in Figure 2. This model is not comprehensive and shows only the most common rationalization scenarios.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"color: #333333;\">Pre-Rationalization Assessment<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">A pre-assessment, when\u00a0conducted,\u00a0would\u00a0evaluate if the requested rationalization is all that is required to fix the existing problems or if something more is needed\u00a0for a permanent fix. Typically a root cause analysis helps\u00a0identify the actual reason behind the current scenario. Along with this, the existing governance maturity and value creation opportunities are also identified to help enhance the user experience, adoption, sustainability, and stability of the environment.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A simple Excel questionnaire should help initiate the pre-assessment phase (contact<em> the author if you are interested in this <\/em>Excel) without\u00a0dwelling\u00a0deep in trying to understand the intricacies in the environment. Based on the assessment findings, the course of the rationalization exercise can be altered. For example, a formal data governance program kicked off in parallel.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span style=\"color: #333333;\">Rationalize<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">This is the phase where the actual rationalization takes place using customized models and frameworks. Complete inventory gathering, metadata analysis, business discussions to understand the needs, etc. are performed. At this point, the client\u2019s need from a short-term perspective is met. Sustainability of the environment would still be questionable.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Governance Component<\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">The depth of coverage for the governance component is to be mutually decided between the client and consultant based on environmental factors. Parameters like size of the IT team, existing processes and policies, maturity, etc. play a major role in deciding the depth required.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The governance component introduced within the rationalization framework would typically deep-dive into the system to understand the policies &amp; standards, roles &amp; responsibilities, etc from various perspectives to fix or find a work-around to the problem and ensure the scenario does not repeat itself.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/Rationalization-model.png\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"201\" src=\"https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/Rationalization-model-300x201.png\" alt=\"Click to enlarge\" class=\"wp-image-168\" title=\"Rationalization model\" srcset=\"https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/Rationalization-model-300x201.png 300w, https:\/\/www.jkspeaks.com\/wordpress\/wp-content\/uploads\/2011\/06\/Rationalization-model.png 814w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><span style=\"color: #333333;\">Enablers<\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\">Post rationalization enablers have no dependency on either the rationalization effort or the governance component. This component is kicked off post the rationalization phase, either as a separate project or as an extension to the rationalization phase. The enabling components, though they are optional, will play a vital role in adding value to the client by sustaining the setup from a long-term perspective and user adoption perspective. On occasions where more than one enabler has been identified, it is sufficient if the key enabler is addressed as a priority.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, if the client requests report rationalization, there is a high probability that the data model was not flexible, and hence the users were creating multiple reports, or there was a training issue. This would have gotten identified during the pre-assessment phase and can be addressed as part of this phase by setting up something like a Global Report Shop. The governance component would have helped address a part of this issue by ensuring policies are in place to see that the users do not create reports at will and, at the same time, they are directed to the right team or process to meet their requirements.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Taking another example, if the client goes for a KPI and metrics standardization exercise, there is a good chance that there is a need for data model changes, dashboards to be recreated, and analytic reports to be designed from scratch. This can be handled by setting up a core analytics team well in advance. If this was not identified and addressed as part of the KPI standardization project, users&#8217; day-to-day activities would get hampered and result in poor adoption.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"color: #333333;\">Benefits<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The primary advantages of this rationalization model are<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Maximum revenue realization in a short duration<\/li>\n\n\n\n<li>Helps sustain the quality of the environment<\/li>\n\n\n\n<li>Enhances users&#8217; productivity and adoption<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span style=\"color: #333333;\">Conclusion<\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Rationalization must be seen from a broader and long-term perspective. Rationalization without addressing the governance component will not be strong, and one without any supporting pillars like the enablers mentioned will not serve the long-term purpose.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u00a0#Rationalization<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction As the organization grows organically or inorganically, there will be an infusion of multiple technologies, loss of governance, and a drift away from the centralized model. In some organizations where the BI environment is not robust, there will be an increased usage of MS Excel and MS Access to meet various business needs like&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":"","_links_to":"","_links_to_target":""},"categories":[21,4],"tags":[44,50,7,49,46,45,47,42,48,43],"class_list":["post-167","post","type-post","status-publish","format-standard","hentry","category-ai-data","category-consulting","tag-consolidation","tag-enablers","tag-framework","tag-governance","tag-kpi","tag-model","tag-portfolio","tag-rationalization","tag-report","tag-standardization"],"acf":{"phase":"1","cluster":"Technical","topics":["Business Intelligence","Data Strategy","Frameworks"]},"_links":{"self":[{"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/posts\/167","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/comments?post=167"}],"version-history":[{"count":6,"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/posts\/167\/revisions"}],"predecessor-version":[{"id":1187,"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/posts\/167\/revisions\/1187"}],"wp:attachment":[{"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/media?parent=167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/categories?post=167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jkspeaks.com\/wordpress\/wp-json\/wp\/v2\/tags?post=167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}