Latest / SHSMD Podcast Rapid Insights for Health Care Marketers, Planners, and Communicators / Unlocking the Power of Health Care Data: Data Analytics and Visualizations That Drive Strategic Growth
Transcript
- 0:00Intro: The following SHSMD Podcast is a production of DoctorPodcasting.com.
- 0:05Bill Klaproth (host): On this edition of the SHSMD Podcast, we're talking
- 0:08data, people, as we learn how Children's Nebraska transformed fragmented data
- 0:13into a powerful decision-making engine.
- 0:16Basically, you want to know how to pull all your dashboards together to support
- 0:20strategic planning, improve operational decision-making, and help deliver better
- 0:24care for your patients and families?
- 0:27Well, of course you do.
- 0:28Then, listen to this episode and attend their session at SHSMD Connections 2026.
- 0:33Joining me are Sergio Orozco, Director of Strategic Planning and Project
- 0:38Management, and Amber Marquiss, Manager Business Intelligence,
- 0:42both from Children's Nebraska.
- 0:44That's coming up on the SHSMD Podcast right now.
- 0:49This is the SHSMD Podcast: Rapid Insights for Healthcare Strategy Professionals and
- 0:54Planning, Business Development, Marketing Communications, and Public Relations.
- 1:00I'm your host, Bill Klaproth.
- 1:02Sergio and Amber, welcome
- 1:04Sergio Orozco: Hey, Bill.
- 1:05Thank you for having us.
- 1:06Amber Marquiss: Great.
- 1:06Thank you for having us.
- 1:08Host: You bet.
- 1:09Happy to talk with both of you.
- 1:10So Sergio, I'm going to start with you.
- 1:12Your session is called Turning Fragmented Data into a Decision-Making Engine.
- 1:17What was happening at Children's Nebraska that made you realize your existing
- 1:21approach to data wasn't enough anymore?
- 1:24Sergio Orozco: One of the biggest items that we've noticed at Children's is we
- 1:29have a lot of access to a lot of data.
- 1:32However, we noticed in the last few years that the data that we were
- 1:36working with was sometimes siloed, and it lived in different departments
- 1:41or different siloed systems.
- 1:43Sometimes we had to do a lot of manual work, which caused a lot
- 1:47of delay on data accuracy in allowing us to make decisions.So,
- 1:52we really had to think as an org, how can we turn the data into
- 1:57actionable data that's going to help us with our strategic growth?
- 2:00Host: You know, Sergio, I think that's a common thing.
- 2:03People have this siloed data, and they don't really talk to each other.
- 2:08So Amber, that brings me to my question to you.
- 2:11So, you brought together claims, scheduling, finance, demographic, and
- 2:17other data into a single enterprise view.
- 2:21What were the biggest challenges, maybe not technically, but organizationally,
- 2:27in getting everyone aligned around, let's call it, one source of truth?
- 2:31Amber Marquiss: One of our biggest challenges was getting everybody
- 2:35to agree to kind of become data stewards to our organization.
- 2:41Having people who really know the information well and helping us to
- 2:46write the correct KPIs, the correct numerators, the correct denominators, and
- 2:52having kind of groups held accountable for their data and how they want it
- 2:57represented within the organization
- 3:00Host: Yeah, that sounds like that was a really important cog to this whole thing.
- 3:03Would that be right?
- 3:04Amber Marquiss: Correct.
- 3:05It is.
- 3:05Data governance has been a big, benefit to us in getting that organized and
- 3:10getting people engaged to help us get the correct answer we want organizationally.
- 3:17And sometimes they are siloed.
- 3:18You might have a department-level metric, but we try to have
- 3:21this as the organization metric that we want people to use.
- 3:25Host: Well, that seems like a real critical step in all of this.
- 3:28And then,let me ask you, Amber, I know a lot of organizations, they
- 3:31have dashboards, and like Sergio was saying, they're all siloed.
- 3:35But not all of them change behavior, and it sounds like that's
- 3:39what you have accomplished here.
- 3:41Can you share an example of how your Power BI dashboards helped leaders make a
- 3:45better strategic or operational decision?
- 3:49Amber Marquiss: With the help of the strategic planning group, with
- 3:52having this dashboard built, we're able to quickly answer questions that
- 3:56come up, where historically it would take us a couple weeks to kind of
- 4:01get all the data put together, munge it into the right look and feel.
- 4:06And with the dashboards, having the data right at your fingertips with the ability
- 4:10to change your graphing, change what you're pulling in, changing the different
- 4:15KPIs very quickly within the dashboard, it has made it so that we can get answers
- 4:20to leadership very quickly, and it has changed how we can respond to questions
- 4:26where before people would have to wait.
- 4:28Now, we can get that immediately out to them, helping us
- 4:32drive the business quicker.
- 4:34Host: That speed is really important.
- 4:36In any business, the faster you can come to conclusions or decisions or
- 4:40understand data, really important.
- 4:42So, by putting all these dashboards together, it sounds like you
- 4:45really sped things up when you needed to find information.
- 4:48Is that right?
- 4:49Amber Marquiss: Correct.
- 4:50And it's allowing for more self-service too as well, with having that
- 4:53ability to go in and get your answers quickly without having to wait and
- 4:58put in a help desk ticket, wait for your data to come back to you.
- 5:01That self-service has been a huge win for us.
- 5:04Host: Yeah.
- 5:05Yeah.
- 5:05That is really important.
- 5:06And Sergio, I know one of your learning objectives focuses on
- 5:11collaboration and governance, and Amber was talking about governance.
- 5:15What did you do to standardize definitions, workflows, and reporting
- 5:21so people actually trusted the data?
- 5:24Sergio Orozco: I want to elaborate a little bit that not only is data
- 5:27a consolidation of data, it's not just a technical component of this.
- 5:32The biggest item is, like, how do we find an organizational alignment?
- 5:37So, we kind of use three goals as we were coming up with our data excellence.
- 5:41How do we focus on having data literacy and definitions that we
- 5:46all agree between departments?
- 5:48How do we agree on having data quality?
- 5:51And then, to Amber's point, how do we create those data uses where
- 5:55we're using data in a way that is scalable, easy for people to use?
- 6:00We also have a unifying method when we onboard a new team member.
- 6:05We have them go through a Power BI 101 where they kind of understand the high
- 6:11level, how to use it, how to function it.
- 6:14One of the things that I really like about our partnership and collaboration with
- 6:18strategic planning and our data governance team and our data analytics is the ability
- 6:22to create dashboards that are meaningful, where you're able to drill down what
- 6:27the function that you're looking at.
- 6:29If you're going to look at it from an enterprise level or a service line or
- 6:33specific division, down to maybe that provider KPI or growth opportunity.
- 6:39Host: So, I like those three.
- 6:40You said data literacy, data quality, and data usage.
- 6:44And then, you said to make sure it's scalable, easy.
- 6:47And then, I like that onboarding process where you talk about
- 6:49a unifying method as well.
- 6:52And I know you're going to go into detail in all of these things in your session,
- 6:56which I think is going to be great.
- 6:58And then, Amber, for healthcare marketers and strategy leaders
- 7:02listening who feel like their own data is scattered across multiple systems,
- 7:06which is a common thing, we know this.
- 7:10So, tell us, in your opinion, what's the first step they should
- 7:13take to begin building a more unified, actionable data strategy?
- 7:19Amber Marquiss: We took the approach of we were going to create a data warehouse.
- 7:24And our reasoning behind that is it allows us to be able to do link
- 7:30servers, so that we can link multiple different databases and different
- 7:34servers together to pull data.
- 7:37We have a lot of external sources, so we are working with different areas.
- 7:42So, having somebody who knows how to do API connections, having somebody who
- 7:46knows how to do like an SSIS package to ingest potentially flat files.
- 7:52You need to create a team that can do the data munging for you,
- 7:56because there's a lot of that that has to happen in the background.
- 7:59I do believe having a unified data warehouse where you start to pull all of
- 8:03those things into one area has been one of our biggest successes in how we've
- 8:08been able to, quickly turn data around and have it at people's fingertips.
- 8:13So, I do think having a data warehouse strategy is probably very important.
- 8:18And then, again, data governance and data stewards.
- 8:22having those three pieces kind of combined together has been a
- 8:25huge lift for our organization.
- 8:28Sergio Orozco: I want to add a little bit more to Amber's point.
- 8:30The biggest impact that we have noticed with our collaboration is now that we have
- 8:35created this data warehouse, we're not only able to make faster decisions, but it
- 8:40also allows us to remove all of the manual reporting that we were previously doing.
- 8:46But it also allowed us to have data accuracy, so that way we can improve
- 8:50alignment between leadership teams.
- 8:52So now, when different leaders asking us to provide us with a certain metric,
- 8:58we all collectively agree if we're trying to answer how many patients did
- 9:03this clinic saw, we all are able to provide with the same number of answer
- 9:08in finance, strategy, data analytics.
- 9:12We're now providing the same number instead of having different numbers
- 9:15based on our own interpretation of the data or how we siloed had it before.
- 9:20Host: Sergio, thank you for bringing that up.
- 9:21Yeah, removing the manual labor, that'scertainly got to speed things up.
- 9:25and you said it also improves accuracy, which is a huge benefit as well.
- 9:31This has been a great interview.
- 9:32I want to thank you both of you for your time.
- 9:34I would like to ask each of you one last question, same question to get
- 9:37each of your viewpoints on this.
- 9:39Sergio, let me start with you.
- 9:40As analytics and AI continue to evolve, how do you see real-time
- 9:44data shaping strategic planning in pediatric care over the next few years?
- 9:49And what should organizations be doing now to prepare?
- 9:53Sergio Orozco: One of the items that we're hoping to get as we
- 9:56evolve with this is go from reactive reporting to proactive intelligence.
- 10:02And now that we are able to break down our silo teams, we're also able to create
- 10:07accountability and shared accountability.
- 10:10As you know, with the integration of AI and tools, I'm hoping that in the near
- 10:15future we can really focus on AI-enabled insights such as forecasting growth
- 10:21opportunities, also the ability to analyze data in a more meaningful way, and also
- 10:28be able to create real-time analytics that is hopefully going to help us improve
- 10:33the quality of care for our patients.
- 10:35And we're able to see trends based on population trends that
- 10:39we've seen for our community.
- 10:41Host: Yeah, tying all those together, that'd be really, really important.
- 10:44And when anytime you talk about growth opportunities, I know people
- 10:47are going to listen for sure.
- 10:49Amber, let me ask you the same question.
- 10:51As analytics and AI continue to evolve, where do you see us going in
- 10:56the next few years, and what should organizations be doing now to prepare?
- 11:01Amber Marquiss: I feel like organizations really need to focus on data and
- 11:04getting their data ready for AI.
- 11:07Because AI can do a lot of things, but if your data is not well-structured,
- 11:13you're going to get false positives, errors in your information.
- 11:17And so, I feel like organizations are really going to have to start focusing
- 11:20on having clean data to help make sure they're getting the right answers for AI.
- 11:26As you use AI, you'll see sometimes you get great answers,
- 11:30sometimes it's not so great.
- 11:32So, I feel like having clean data that is ready for predictive
- 11:35analytics and moving into that more prescriptive, and risk analysis kind
- 11:40of levels, you're going to need to have clean data to do that accurately.
- 11:45Host: So focus on data, make sure it's well-structured and clean.
- 11:49So, I think that's great.
- 11:51Well, this is going to be a dynamite session, you guys.
- 11:53I know a lot of people are going to come to this.
- 11:55I know you're going to go into this way more in depth than this quick interview.
- 11:59But thank you so much for sharing some of this information with us today.
- 12:03We really appreciate it.
- 12:04Sergio Orozco: It's a pleasure talking to you, Bill.
- 12:06Amber Marquiss: Thank you for your time.
- 12:07Host: You bet.
- 12:08Once again, that is Sergio Orozco and Amber Marquiss.
- 12:12And for more information and to dive deeper into strategies like the ones
- 12:16we were just talking about, make sure you register for SHSMD Connections.
- 12:20Just go to shsmd.org/education/annualconference
- 12:26to learn more and to get registered and, of course, to connect with
- 12:29healthcare marketing and strategy leaders from across the country.
- 12:33And if you found this podcast helpful, please share it on your social channels,
- 12:37and please hit the subscribe or follow button to get every episode.
- 12:40And to access our full podcast library or other topics of interest
- 12:44to you, visit shsmd.org/podcasts.
- 12:49This has been a production of Doctor Podcasting.
- 12:52I'm Bill Klaproth.
- 12:54See ya!