BI Tool Conversion & Consolidation - Prominence
BI Tool Conversion & Consolidation02/09/2022
Advanced AnalyticsAdvanced AnalyticsAI and Data GovernanceAlign People, Processes, and TechnologiesAlign People, Processes, and TechnologiesAnalyticsAnalytics TeamArchitectArchitectCase StudyCollibraCultureCustomer Case StudyDashboard and Metric ConfigurationData GovernanceData Lakehouse and Medallion ArchitectureData Lakehouse and Medallion ArchitectureDatabricksDeploymentEpicEpicEpic ServicesEpic StaffingEpic StaffingEventsGenerative AIGenerative AIInformaticaInformaticaKLASMachine Learning and Data ScienceMachine Learning and Data ScienceModelOperationalizeOperationalizeOrganizeOrganizePlatform MigrationsPlatform MigrationsProminence BasecampRevenue CycleSnowflakeTableauTableauVisualizeVisualizeWebinarWebinarsWorkflow integration All posts

Something many people don’t realize is that BI tool proliferation is a symptom of a really good thing – people want to be data driven. They are trying to do whatever they can to get the information they need to execute at a higher level.

While it is the symptom of something great, it’s still an undesirable situation. It leads to ungoverned data with many people reporting on the same metric but getting different numbers, additional costs, an untenable support situation, and many, many other challenges.

In our work with hundreds of healthcare organizations across the nation, we’ve found there are two approaches to driving a conversion or consolidation:

  1. Executive Mandate: the most common approach. Leadership understand the challenges and costs of having many tools and wants to convert / consolidate to one standard as much as possible.
  2. IT Directive: less common, but not unheard of. In this scenario IT are driving the conversion / consolidation in order to provide better support, higher performance, and greater data trust.

Both are legitimate approaches, and Prominence’s proven process for converting / consolidating on a primary platform works for both (with minor tweaks). Here’s how we’ve successfully helped organizations with this transformative work:

Roadmap

In this phase we learn your current state of development practices, tools, stakeholders, users, etc., and establish the target future state. This includes finalizing the set of tools for data prep and visualization, and establishing development best practices to adhere to during the conversion/consolidation process. We’ll also prioritize assets to convert, review data dependencies to find heaviest use data sets, and review user distribution and security. The result: a roadmap that clearly outlines the steps to take, roles involved, and processes to follow to ensure a smooth transition.

Plan

At this time we work with you to identify and document key stakeholders, sponsors and SMEs involved in existing analytics and BI tools. Working with these staff, we compile metric definitions for conversion and ensure that any duplicate metrics are normalized to provide trusted information to all consumers. We’ll also work with your team to create an enterprise data structure and optimize development practices to ensure a successful transition.

Develop

During this phase the rubber meets the road. Data pipelines are built and transformations constructed based on documentation from the previous phase. The re-usable metrics and dimensions are re-used across data models that feed visualizations. The re-use of metrics ensures that people accessing different dashboards that contain the same metric see the same number – building trust and literacy. Additionally, the new visualizations built are refined from what consumers previously had to be easier to use and provide more relevant information, thus making them substantially better than what they were using before.

Deploy

Finally, the new solutions are configured for users and security and deployed after sign-off is obtained from stakeholders. During this time, additional education and adoption activities are conducted to ensure users can rapidly adopt the new solution and integrate into their workflows to drive the best possible actions.

The results? Our customers are able to not only convert / consolidate to an enterprise BI platform, but they also improve their analytics capabilities as well. It’s not just ‘lift-and-shift’, but forward progress toward organizational goals as well.

Some specific outcomes include:

If you’re ready to get your your arms around the BI tools in use and how data is distributed, contact Prominence and we’ll set up a short, no-strings conversations with one of our experts!

Recent Posts
At Prominence, “Do Great Work” isn’t just one of our values—it’s a principle we live by, extending beyond our professional realm to the communities w…
At Prominence, “Do Great Work” transcends our professional commitments—it’s a core value that extends to the communities we serve. Our community serv…
We are thrilled to announce that Prominence Advisors has been named one of Healthcare Innovation’s Top Companies to Work for in Healthcare. This reco…
Our team recently gathered in Madison, Wisconsin, for our much-anticipated Summit. Here at Prominence, these semi-annual meetings embody our relentle…
https://prominenceadvisors.com/wp-content/uploads/2024/10/Informatica-Epic-Use-Cases.pdf
© 2024 Prominence Advisors, Inc, All Rights Reserved

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Fermentum leo vel orci porta non pulvinar. Luctus venenatis lectus magna fringilla urna porttitor. Sodales ut eu sem integer vitae justo eget magna. Ultrices eros in cursus turpis massa tincidunt dui. Urna duis convallis convallis tellus id. Sed elementum tempus egestas sed sed risus pretium quam. Aliquam nulla facilisi cras fermentum odio eu feugiat pretium. Tellus in metus vulputate eu scelerisque. Sem nulla pharetra diam sit. Urna et pharetra pharetra massa massa ultricies mi quis hendrerit. Sed risus ultricies tristique nulla. Euismod lacinia at quis risus sed vulputate odio ut. Mauris rhoncus aenean vel elit. Tortor posuere ac ut consequat semper viverra nam libero. Pellentesque habitant morbi tristique senectus et netus et. Sem integer vitae justo eget magna fermentum iaculis eu non. Adipiscing diam donec adipiscing tristique. Massa sapien faucibus et molestie ac feugiat sed lectus vestibulum. Id diam vel quam elementum pulvinar.

Lorem ipsum dolor sit amet. Lobortis elementum nibh tellus molestie. Blandit volutpat maecenas volutpat blandit aliquam etiam erat velit scelerisque. Tellus cras adipiscing enim eu turpis egestas pretium aenean. Feugiat nisl pretium fusce id velit ut. Auctor urna nunc id cursus. Velit dignissim sodales ut eu sem integer vitae justo. Pellentesque adipiscing commodo elit at imperdiet dui accumsan sit. Nisi vitae suscipit tellus mauris. Interdum varius sit amet mattis vulputate enim. At risus viverra adipiscing at in tellus integer. Nunc scelerisque viverra mauris in aliquam sem. Convallis posuere morbi leo urna. In vitae turpis massa sed elementum tempus. Cursus euismod quis viverra nibh cras. Eros donec ac odio tempor orci dapibus ultrices in. Augue ut lectus arcu bibendum. Eget sit amet tellus cras adipiscing enim. Tincidunt praesent semper feugiat nibh sed pulvinar proin gravida.