Overview
In this episode of The Dashboard Effect, Kate Eberle, Director of Consulting at Blue Margin, sits down with Pedro Renteria, VP of Financial Planning and Analysis at SimonMed, to discuss what a real BI transformation looks like inside a PE-backed healthcare organization. The conversation is grounded in Pedro’s firsthand experience navigating the people, process, and technology challenges of moving from hundreds of disconnected reports to a centralized platform that the organization actually trusts and uses.
It is a candid account of what the journey required, what it produced, and what it revealed about the relationship between data and organizational culture. See how Blue Margin helps PE-backed companies build the data foundation that makes that kind of transformation possible with Private Equity Analytics & Data Dashboards.
What This Episode Covers
The Data Journey (4:27 – 6:12, 10:43 – 11:45)
SimonMed began with a reporting environment that had grown organically and ungoverned: hundreds of disparate reports with no consistent definitions and no single source of truth for critical operational metrics. The transition to a centralized Power BI platform did not just consolidate the reporting. It created the organizational agreement around what the numbers mean that makes a shared source of truth actually function as one.
Strategic Metrics and Focused Alignment (6:37 – 8:32)
Rather than attempting to measure everything at once, the team kept the initial scope narrow. High-level indicators like patient volume and procedure conversion rates were prioritized first, creating a foundation of trusted metrics before expanding into areas like sales performance and technical productivity. The discipline of starting focused is part of what allowed the broader rollout to succeed.
A Human-Centered Approach to Data (12:02 – 16:15, 23:50 – 24:17)
Pedro’s perspective on data is distinctly people-first. Giving employees visibility into their own performance data is not primarily a monitoring strategy. It is an empowerment strategy. When teams have access to accurate, timely data about their work, they develop a sense of ownership over their outcomes that improves engagement, enables better mentorship conversations, and drives decision-making at the site and director levels rather than concentrating it at the top.
Navigating Sensitivity and Change Management (16:39 – 22:50)
Introducing productivity metrics into a healthcare environment required careful change management. Pedro is candid about the resistance that surfaced and the importance of maintaining an open communication loop throughout the process. The goal was to ensure that teams experienced the data as factual and actionable rather than punitive. That distinction is not automatic. It requires deliberate effort in how metrics are framed, introduced, and discussed over time.
ROI and Organizational Health (24:36 – 29:26)
Pedro acknowledges that isolating specific financial returns from a BI investment is difficult, and he does not attempt to manufacture a number that would oversimplify what actually changed. What he can speak to is the overall health of the organization: the cultural alignment, the quality of conversations at every level, and the strategic coherence that has improved over his two years at SimonMed. Those outcomes are harder to quantify and harder to argue with.
Future Outlook (32:26 – 33:58)
The next frontier for SimonMed is deeper integration of financial data and improved visibility into Revenue Cycle Management. Pedro sees RCM as an area with significant untapped revenue potential, and building the data foundation to surface and act on that potential is where the organization’s BI investment is headed next.
Who It’s For
This episode is worth your time if you are a finance or operations leader at a PE-backed healthcare organization navigating a similar data maturity journey, a CFO or FP&A professional evaluating how to build a reporting environment that earns trust across a complex, multi-site organization, a BI or data team working through the change management challenges of introducing performance metrics to frontline employees, or anyone interested in a real-world account of what a BI transformation produces beyond the technology itself.
Why It’s Worth a Listen
Most BI case studies focus on the technical implementation and the before-and-after metrics. This conversation goes further, spending meaningful time on the human dimension of the work: how people respond to new visibility into their performance, what it takes to make that visibility feel empowering rather than threatening, and why the cultural outcomes of a data initiative can matter as much as the operational ones.
Pedro’s framing around ownership is particularly worth attention. The idea that data access creates accountability that employees want rather than resent runs counter to how productivity metrics are often introduced, and his account of how that played out at SimonMed offers a model for organizations trying to build a data culture rather than just a reporting function.
And the honest treatment of ROI is refreshing. Pedro does not claim that the BI investment paid for itself in a specific dollar amount. He describes what actually changed, which is a more credible and ultimately more persuasive account of value than a number that obscures more than it reveals.
