Excel Dashboard Competition>Surgery Center Dashboard
2. Jim Uden – Outpatient Surgery Center Dashboard
Developed for Meridian Surgical Partners, as a one page snapshot for the review and presentation of partnership level business operations and trends. Jim also includes probably the best associated description of dashboard content and the thought processes involved which we’ve seen.
Company Background
This dashboard was built for a company that owns and operates ambulatory (outpatient) surgery centers in partnerships with surgeons. We currently have a portfolio of 9 facilities that are located all over the US. Typically, we will own a majority interest (around 55%) of the individual business and the practicing surgeons will own the rest. A typical partnership includes our company as well as 10-12 physician partners. Each partnership is a separate business entity.
Objective and Audience
The goal of this report was to provide a one page snapshot that can be reviewed and presented to each individual partnership to assess the operations of the business. This business is driven by physician case volume and that is why it is so prominent in the report. Understanding and analyzing individual physician volume trends is crucial. Due to government regulations, cash generated by the business is distributed to the owners (including the physicians) based on ownership, not on contribution.
A report is generated for each facility and then presented to each partnership individually. The audience includes the physician partners who are not familiar with financial analysis. Given this obstacle, the visualization of data is crucial to their comprehension. As a result, very little financial information is displayed. However, the business is driven by physician volume and by listing the production by partner, I am able to highlight the contributors as well as those who are not meeting expectations. This creates a competitive environment among the surgeons and serves as an excellent motivator for the partnership.
Open this PDF file for the full background story