Despite potential challenges, switching to an outside analytics partner is worth the effort.

*To keep the identity of this system private, we will be referring to them as MHS throughout this story.

After years of gathering and analyzing data using an in-house system, it may seem like
too daunting a process to switch to an outside analytics partner. There are many issues you will likely consider, such as the challenges that could come with training your team on a new process. You may have to overcome hurdles as you learn the ins and outs of working with an external partner.

Conversely, there are also risks to consider if you opt to keep things the same. Sticking with the status quo could lead to investments in costly service-line developments that are not equipped for success, ill-informed marketing outreach, and growth planning initiatives that are poorly executed.

In particular, a multi-state hospital system has many compelling reasons to make the move to an outside data analytics partner. In 2015, MHS* did just that. In this paper, we discuss the issues they were facing before making the switch and why, in the end, it was a profitable and worthwhile move.

MHS faced the enormous challenge of needing to combine and analyze quarterly data sets created by eight hospitals in three states. Central to their problem was how hospitals in each state report their data differently. Variances from state to state can include:

  • Different release schedules

  • Varying code formats: decimal vs. non-decimal, or FIPS codes vs. state-specific codes

  • Different data formats: flat files, .csv, etc.

The in-house system that MHS used was incapable of accurately reformatting and curating the reported data so that it could be understood as one seamless data set. This frequently led to errors in the data which caused system-wide reports to be unreliable.

Instead of remaining stuck in this data quagmire, the MHS strategic planning team initiated a search for a data intelligence partner who could help them focus more on achieving their mission of providing the best healthcare possible. They needed a partner who could give them the necessary data-collection tools and help them develop a process to properly handle and analyze their multi-state data.


Three essential needs fueled MHS’s motivation to find an outside data intelligence partner:

  1. MHS needed a comprehensive set of tools that could effortlessly handle multiple state’s data sets and meet the needs of a range of users.

  2. MHS needed a data process they could trust so that their strategic growth decisions would no longer be based upon inaccurate data sets.

  3. MHS needed a trustworthy outside partner who could objectively process and analyze their data so their internal team, as the true market experts, could be free to focus on big-picture growth strategy decisions.


After some research and searching, MHS made the decision to partner with Stratasan based on how well Stratasan was positioned to address their three main needs:


A comprehensive set of tools:

Stratasan’s analytics platform is capable of seamlessly processing multiple state data sets in ways that meet the needs of users at every level of the organization.


A data process they could trust:

Stratasan’s data processing is out of sight and out of mind for the client. It functions behind the scenes to properly verify and accurately map raw, multi- state data, while also translating codes into easy-to-query descriptions, thus creating a unified data set that is ready for analysis.


A trustworthy outside partner:

Founded as a technology company, Stratasan builds its software in house, enabling customization and fast response times to market changes. We treat our customers as partners, recognizing them as local experts because of their proximity and personal investment in the area. We prefer to allow for flexibility in our service offerings so partners can get the help they need while freeing
up internal resources so teams can focus on big-picture decision-making and growth strategies.


    The Stratasan Analytics Platform is designed with three users in mind:

    • A data-savvy super analyst.

    • An intermediate analyst desiring quick access to intelligence.

    • Administrative users who need immediate access to up-to-date intelligence without the complexity of report building.


    For the data-savvy super user

    Stratasan’s Blackbird application provides unrestricted access to well-organized, curated, multi-state data sets.

    This makes it possible for MHS to run all of their state data sets at the same time and deliver relevant, enterprise-wide reporting. Blackbird does not limit MHS’s analysts to pre-templated reports, antiquated pivot tables, or a predetermined number of rows or columns.

    Additionally, Blackbird automates queries, making it easy to get regular data updates. With the capability to consistently pull and review curated, multi-state data queries, MHS’s analysts are able to quickly cut through the chaff and get straight to the intelligence they need to analyze.


    For the intermediate analyst

    Stratasan’s Canvas application provides easy-to-use and easy-to-understand report templates, taking the hassle out of report building.

    This application generates market intelligence based on a curated view of patient age ranges, ZIP codes, market share, cost reporting, and demographics with a few clicks.

    Canvas also provides financial insights and market projections for inpatient, outpatient, ED, and physician office volume.


    For MHS’s service line leaders, executives, and growth stakeholders

    Stratasan’s Gallery application provides an online portal to data intelligence and real-time reports.

    Market share reports and custom queries are automatically updated as new data is released. This online portal provides a one-stop destination for every team to access up-to-date reporting and ensures that all stakeholders are aligned around the same information.


    Analytics can only be trusted when the underlying data is understandable, clean, well organized, and well curated.

    Unfortunately, the viability of MHS’s multi-state data set—and therefore the analysis that was performed based on their data—was questionable.

    One of the biggest difficulties MHS experienced before partnering with Stratasan was that their calculated market share changed significantly each quarter for no apparent reason. Stratasan’s data experts discovered the underlying problem was that MHS’s manual system crosswalked ZIP code data into county data using a geocentric model that produced inaccurate results.


    On the contrary, Stratasan’s approach uses a population-centric model that produces accurate market share results, even across state lines.

    Stratasan believes that hospitals shouldn’t spend time worrying about whether they’ve processed ZIP code data correctly or incorrectly. The data should be effortlessly accurate so that organization-wide alignment can be reached around the right initiatives that will most effectively benefit each service area and allow every department to focus more on providing the best healthcare possible. Since their partnership with Stratasan, when new data comes in each quarter, MHS doesn’t have to transfer it to another platform to scrub it. They can trust that their data is accurate and instantly ready for comprehensive analysis.


    MHS was able to test Stratasan’s capabilities.

    MHS was able to test Stratasan’s capabilities prior to switching when they hired Stratasan to conduct several large strategic market analysis projects (SMAs) for each of their eight hospitals. The SMAs provided an overall measure of each hos- pital’s performance, as well as a consideration of their competition’s health and growth potential. The resulting reports allowed their strategic planners to better and more deeply understand their market so they could maximize the impact of their growth efforts and increase the likelihood of successful outcomes.

    Based on the experience they had with the SMA development and the results they received, MHS knew that Stratasan was a partner who could perform the heavy lift of data processing and objective data analysis so that their internal team could focus on bigger-picture growth strategy decisions.


    The decision to switch from their in-house system to Stratasan.

    The decision to switch from their in-house system to Stratasan has yielded a wide range of benefits for MHS. Having an outside data analytics partner who under- stands the complexities of multi-state data gathering and curation has led to sig- nificantly fewer data errors. It has also led to a higher level of focus and efficiency for MHS’s internal team.

    Instead of regularly spinning their wheels scrubbing raw data, they can simply insert clean, standardized, multi-state data into templated reports and receive analyses that are useful for future expansion and growth planning. All of this has resulted in tremendous time (and therefore financial) savings quarter over quarter, and more effective strategic planning.

    Moreover, now that they have moved away from a siloed data approach and have embraced a centralized, multi-state approach, MHS can more quickly and easily locate problem areas within their hospital system and address them right away. This newfound ability has lead to improved organizational alignment around how change should be implemented and has enabled focus on efficacious initiatives and long-term goals.


    At Stratasan, we understand the concerns.

    At Stratasan, we understand the concerns around transitioning from an in-house system to an outside market analytics partner. We see how it could be perceived as a complicated and overbearing process.

    Below you will find a 60-day timeline that addresses these concerns head on, demonstrating that with proper planning and execution, the transition can be made easily and efficiently, resulting in a better process overall and with
    little lost time.


    Transitioning from an in-house data system to an outside data analytics partner can seem like an arduous undertaking.

    If your current system can’t properly curate and process multi-state data in a way that supports accurate and effective analysis, then it’s time to start considering your options. The risks of sticking with the status quo could mean costly ser- vice-line developments that are not equipped for success, ill-informed marketing outreach, and growth planning initiatives that are poorly executed.

    In developing this four-part series, we hope to highlight the potential liabilities and pitfalls every hospital and healthcare system could face if matched with the wrong data analytics partner or when trying to manage the complexities of multi-state data alone. The chance for misstep is possible for service providers of every size and offering. With this in mind, we’ve included in this series stories about the larg- est sole community provider, a teaching hospital, and the largest hospital system in the country—all of which have made the choice to switch to Stratasan.

    The Stratasan Analytics Platform provides strategic planners and hospital executives immediate and unrestricted access to healthcare intelligence. With similar players in the market such as Intellimed, Crimson Market Advantage, Sg2, and Truven, we can say with confidence that Stratasan’s software suite is the most robust planning software on the market.

    Additionally, Stratasan’s Spark Services is a team of seasoned healthcare strategic growth professionals. A diverse team of experts with specialized skills in GIS mapping, health analysis, and data handling, Spark is a complement and extension to any hospital planning team, available on a project-by-project basis or as an ongoing partnership.