Project Details
The Challenge
The organization needed to understand where to expand services across 4 states: South Dakota, Minnesota, Iowa, and Nebraska. They had mountains of data but no way to visualize the opportunity. Without clear answers, major investment decisions would have to be made on gut feeling alone.
The Solution
I built interactive data dashboards that mapped everything decision-makers needed to see:
- Patient populations across 100+ counties: where the need was highest
- Competitor locations and services: where the market was already crowded
- Existing facility coverage: where gaps existed in their own network
- Demographic trends and healthcare needs: where demand was growing
I created a comprehensive provider directory to support physician outreach and presented the full analysis directly to executive leadership, including the Assistant Vice President.
The Results
- Clear visual data that executive leadership could understand at a glance
- 3 key expansion opportunities identified and prioritized
- Presented directly to the Assistant Vice President: my analysis became the foundation of their long-term strategic plan
- Used for ongoing strategic planning well beyond the initial presentation
What This Means for You
You don’t need to be a healthcare organization to benefit from this kind of analysis. Any business facing a decision about where to grow, which markets to enter, or how to allocate resources can benefit from clear, visual data. I take what you have and make it usable.