{"id":9848,"date":"2024-06-01T11:04:48","date_gmt":"2024-06-01T15:04:48","guid":{"rendered":"https:\/\/solutionsreview.com\/business-intelligence\/?p=9848"},"modified":"2024-08-02T15:37:51","modified_gmt":"2024-08-02T19:37:51","slug":"working-backwards-knowing-when-data-consolidation-should-be-a-priority","status":"publish","type":"post","link":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/","title":{"rendered":"Working Backwards – Knowing When Data Consolidation Should be a Priority"},"content":{"rendered":"

\"Working<\/p>\n

insightsoftware’s Jay Allardyce offers insights on knowing when data consolidation should be a priority. This article originally appeared on Solutions Review’s Insight Jam<\/a>, an enterprise IT community enabling the human conversation on AI.<\/strong><\/em><\/p>\n

Enterprises are swamped with data, but many don’t know how to leverage this data to remain competitive in their industry. This is especially true when data is siloed, making it challenging for users to share and collaborate. Too often, organizations continue old patterns and build data programs that are on the hunt for a business problem rather than addressing the problem at hand. In fact, organizations spend $115,856 per developer yearly<\/a>\u00a0to tackle data concerns like data inconsistencies and performance issues.\u00a0This is where the importance of a well-structured data consolidation project can be most effective. Let\u2019s take a look at the best ways to start a data consolidation project and the top mistakes to avoid to ensure long-term success.<\/p>\n

Kicking off Data Consolidation<\/strong><\/h4>\n

By starting with the \u2018business outcome\u2019 in mind organizations will have a deep understanding of what experiences or KPIs they want to impact. Too often, organizations focus on an outcome to be cost and or efficiencies. If this is the headline of the business case \u2013 STOP. Rather, organizations need to think about the top line and or productivity improvement that a data consolidation will bring and, therefore, what new insights it will help the business with. This means understanding where business is today and where teams want it to be – which may require asking some of the following questions: Will the project be ROI-driven? Do we want to reduce the number of servers? Should our ultimate goal be to drive cost efficiencies in the cloud? Or should we aim to bring disparate data sources together? Or rather, step back and say to yourself: I want to be able to more accurately forecast my demand and correlate this with my supply inventory, using these various data sources, both internal and external.<\/p>\n

Once these questions are answered, organizations must take the following steps to ensure they are building a data consolidation project that will reach their desired outcomes:<\/p>\n

    \n
  • \n

    Determine the company\u2019s current data-driven culture and its overall data landscape: Depending on the answer, a data consolidation project might further establish this desired culture and identify who will need to use this consolidated data the most. Find a balance between serving the business and the architecture to underpin the project.<\/p>\n<\/li>\n

  • \n

    Define\/refine the outcome via the Jobs-To-Be-Done (JTBD) framework: Be clear on who’s using the information and in what way, and work closely with the business to fulfill specific use cases. For example, if the goal is to have a daily signal on product\/competitive positioning, this might entail combining internal data (product, pricing, sales performance, marketing leads) and external data. Ultimately, teams should be outcome-driven, not architecture or technology-driven, while investing in technologies and architectural approaches that can be flexible, agile, and evolving.<\/p>\n<\/li>\n

  • \n

    Identify quick wins close to the domain and business user – Organizations should start small and expand, remaining fast, nimble, and distributed, focusing first on easy-to-achieve objectives. Once successful, organizations can move toward meeting larger goals that might require more time and resources. Be mindful of maintaining consistent source-independent master data and hierarchies but avoid full-blown companywide master data management initiatives until the project demands it due to complexity.<\/p>\n<\/li>\n

  • \n

    Develop a data governance framework: This framework should support flexibility and allow teams to access data when and how they need it, while still keeping valuable data secure. Don\u2019t constrain the user with policy, rather empower the user, who has domain context, to do their job with the right data and data access.<\/p>\n<\/li>\n<\/ul>\n

    With these steps, teams work backward from the reports and dashboards that are required by the business \u2013 a visualized end state. This is a good way to focus on the consolidation project and keep the cost profile to a minimum. It forces precision around which data sources are required and which data items need to be moved or referenced.<\/p>\n

    Data Consolidation Mistakes to Avoid<\/strong><\/h3>\n

    One of the biggest mistakes organizations can make when launching a data consolidation project is doing too much without showing results and not evaluating the project based on the company\u2019s overall goals. They must also realize that a transformation can\u2019t happen overnight. This is why it\u2019s more important to show quick wins that build credibility while still aligning with business and IT objectives. Furthermore, organizations often fail to think ahead and evaluate their KPIs or JTBD frameworks based on how their industry is evolving. They are too focused on how their business runs today.<\/p>\n

    Many organizations also don\u2019t realize that data and domain expertise need to go hand in hand. Without such knowledge, organizations will lack the context to know how their data should be used. So, instead of going right to consolidating data, they should first identify their stakeholder map and focus on how to consistently use their data to become more efficient and respond to ongoing market changes effectively. This is especially true when considering industry and regulatory environments – whether that be for healthcare, finance, government, etc. Enterprises must work within each industry’s unique boundaries to best manage and access their data. Without this knowledge, a data consolidation project can prove to be even more challenging.<\/p>\n

    Technology or implementation teams often spend too much time, money, and emphasis on the technology and tooling choices to satisfy the infrastructural requirements. Selecting a business intelligence tool, data pipeline infrastructure, cloud data warehouse, and ETL technologies isn\u2019t enough to solve the business problems alone. The expertise required to produce the reports that are needed is a combination of technical expertise and functional expertise, whether that is part of the vertical part of the department or relative to the source system, and the quality of this experience is a better indicator of success.<\/p>\n

    IT organizations tend to favor the \u201cwe can build it\u201d approach, which can manifest as an internal build or an external SI coming in to build for the business. Often underestimated as part of these projects is the cost of maintaining the solutions and the infrastructure, which can span a range of required functional and technical expertise. Overall, these projects are notoriously difficult, lengthy, and risky and also end up increasing the distance between the implementation and the business stakeholder.<\/p>\n

    Data, fuel organizations and data teams can spend 90 percent of their time consolidating data into informative reports. However, these reports are only useful if they can advise what businesses should be doing and where they should be headed – instead of only reporting on what has already happened. By taking a step back and understanding where the company is today and what problems actually need solving, an organization can determine exactly what tools are needed in order to maximize the insights that can be derived from such large data sets.<\/p>\n","protected":false},"excerpt":{"rendered":"

    insightsoftware’s Jay Allardyce offers insights on knowing when data consolidation should be a priority. This article originally appeared on Solutions Review’s Insight Jam, an enterprise IT community enabling the human conversation on AI. Enterprises are swamped with data, but many don’t know how to leverage this data to remain competitive in their industry. This is […]<\/p>\n","protected":false},"author":1106,"featured_media":9874,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[4],"tags":[1527,1889],"acf":[],"yoast_head":"\nWorking Backwards - Knowing When Data Consolidation Should be a Priority<\/title>\n<meta name=\"description\" content=\"insightsoftware's Jay Allardyce offers insights on knowing when data consolidation should be a priority - and when to work backwards.\" \/>\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\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jay Allardyce\" \/>\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\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/\",\"name\":\"Working Backwards - Knowing When Data Consolidation Should be a Priority\",\"isPartOf\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/06\/7-13.jpg\",\"datePublished\":\"2024-06-01T15:04:48+00:00\",\"dateModified\":\"2024-08-02T19:37:51+00:00\",\"author\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/db4f24e15e8725ef4e80244dbf5d89f3\"},\"description\":\"insightsoftware's Jay Allardyce offers insights on knowing when data consolidation should be a priority - and when to work backwards.\",\"breadcrumb\":{\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#primaryimage\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/06\/7-13.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/06\/7-13.jpg\",\"width\":786,\"height\":393,\"caption\":\"Working Backwards - Knowing When Data Consolidation Should be a Priority\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/solutionsreview.com\/business-intelligence\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Working Backwards – Knowing When Data Consolidation Should be a Priority\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#website\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/\",\"name\":\"Solutions Review | Business Intelligence & Analytics\",\"description\":\"Enterprise BI software reviews, buyer\u2019s guides, and expert insights from industry leaders.\",\"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\/db4f24e15e8725ef4e80244dbf5d89f3\",\"name\":\"Jay Allardyce\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/09\/Jay-Allardyce-insightsoftware.jpg\",\"contentUrl\":\"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/09\/Jay-Allardyce-insightsoftware.jpg\",\"caption\":\"Jay Allardyce\"},\"description\":\"Jay has a passion for driving data-first transformations, working across all facets of the enterprise to re-imagine their operations with data and AI. He has 24+ years across Fortune 100, startup, and private equity backed Co\u2019s, as an operator and investor.\",\"url\":\"https:\/\/solutionsreview.com\/business-intelligence\/author\/jallardyce\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Working Backwards - Knowing When Data Consolidation Should be a Priority","description":"insightsoftware's Jay Allardyce offers insights on knowing when data consolidation should be a priority - and when to work backwards.","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\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/","twitter_misc":{"Written by":"Jay Allardyce","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/","url":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/","name":"Working Backwards - Knowing When Data Consolidation Should be a Priority","isPartOf":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website"},"primaryImageOfPage":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#primaryimage"},"image":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#primaryimage"},"thumbnailUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/06\/7-13.jpg","datePublished":"2024-06-01T15:04:48+00:00","dateModified":"2024-08-02T19:37:51+00:00","author":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/db4f24e15e8725ef4e80244dbf5d89f3"},"description":"insightsoftware's Jay Allardyce offers insights on knowing when data consolidation should be a priority - and when to work backwards.","breadcrumb":{"@id":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#primaryimage","url":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/06\/7-13.jpg","contentUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/06\/7-13.jpg","width":786,"height":393,"caption":"Working Backwards - Knowing When Data Consolidation Should be a Priority"},{"@type":"BreadcrumbList","@id":"https:\/\/solutionsreview.com\/business-intelligence\/working-backwards-knowing-when-data-consolidation-should-be-a-priority\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/solutionsreview.com\/business-intelligence\/"},{"@type":"ListItem","position":2,"name":"Working Backwards – Knowing When Data Consolidation Should be a Priority"}]},{"@type":"WebSite","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#website","url":"https:\/\/solutionsreview.com\/business-intelligence\/","name":"Solutions Review | Business Intelligence & Analytics","description":"Enterprise BI software reviews, buyer\u2019s guides, and expert insights from industry leaders.","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\/db4f24e15e8725ef4e80244dbf5d89f3","name":"Jay Allardyce","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/solutionsreview.com\/business-intelligence\/#\/schema\/person\/image\/","url":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/09\/Jay-Allardyce-insightsoftware.jpg","contentUrl":"https:\/\/solutionsreview.com\/business-intelligence\/files\/2024\/09\/Jay-Allardyce-insightsoftware.jpg","caption":"Jay Allardyce"},"description":"Jay has a passion for driving data-first transformations, working across all facets of the enterprise to re-imagine their operations with data and AI. He has 24+ years across Fortune 100, startup, and private equity backed Co\u2019s, as an operator and investor.","url":"https:\/\/solutionsreview.com\/business-intelligence\/author\/jallardyce\/"}]}},"_links":{"self":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/9848"}],"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\/1106"}],"replies":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/comments?post=9848"}],"version-history":[{"count":0,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/posts\/9848\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media\/9874"}],"wp:attachment":[{"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/media?parent=9848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/categories?post=9848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/solutionsreview.com\/business-intelligence\/wp-json\/wp\/v2\/tags?post=9848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}