Dashboards by Example
    Dashboard: Examples & Best Practices.   From Excel Dashboards to Enterprise Business Intelligence, these dashboard implementations contain KPIs, metrics, charts, trends and more.

For more Business Intelligence Dashboard Examples, use this link to the Dashboard Spy sitemap: Dashboard

Note: Dashboards By Example readers can get these interesting business intelligence dashboard white papers and I.T. trade magazines at no cost.

Performance Benchmarking Dashboards

Topic: Performance Benchmarking Dashboard Example: Medical Practice Costs Dashboard.

Executive Dashboards display metrics from across an enterprise. We, as business managers and information technology professionals, work hard at compiling, cleaning and delivering the correct data from sources distribution across corporate systems and data stores. Of course, you say, “That’s what we’re trying to accomplish with our enterprise dashboard projects. What are you getting at?”

My point is that usually the point of view of our corporate dashboards is inward. We compare metrics with past periods or targets, but we usually don’t bring into our dashboard targets much in the way of industry metrics.

So, let’s look at performance benchmarking and dashboarding. I came across some interesting management dashboard applications from the MGMA (Medical Group Management Association). Their dashboards specialize in allowing medical practice management users to benchmark the metrics of their facility against industry standards.

I thought this worth highlighting for Dashboard Spy readers, because it’s not often that our dashboard metrics incorporate comparisions against standards external to the enterprise.

The dashboards are simple to use and understand. They are powered by Xcelsius as you can see in this video.

If you can’t play the video of the dashboard example, click on the more link below to bring up the rest of this Dashboards By Example post. I’ll provide screenshots of the dashboards and links to the xcelsius dashboard examples.

Here is the video of the Medical Practice Costs Benchmarking Dashboard (yes, it’s fuzzy, but click on the image and it’ll be sharp when the video runs): 

See “more” for the link to the dashboard as well as details about the practice management KPIs and metrics.

Try out the Medical Practice Costs Dashboard for yourself at the MGMA site.

Let’s look at some dashboard screenshots before checking out the key performance indicators.
The idea is to input into these data capture screen some practice metrics. You choose a specialty and enter values for KPIs such as A/R, Revenue, Support Staff Cost, General Operating Cost, etc.
Practice Cost Inputs:
Practice Cost Dashboard for Performance Benchmarks
After clicking the “Display Dashboard” button, you get the following dashboard screen:
Practice Rankings Dashboard
The dashboard gauges show your performance as benchmarked against industry norms.
Here is a clipping from their instructions screen regarding the KPI inputs:

Accounts Receivable

Amounts owed to the practice by patients, third-party payers, employer groups and unions for feefor-service activities before adjustments for anticipated payment reductions, allowances for adjustments or bad debts. Amounts assigned to “Accounts receivable” are due to “Gross fee-forservice charges.” Assigning a charge into “Accounts receivable” initiates at the time a practice submits an invoice to the payer or patient for payment. For example, if an obstetrics practice establishes an open account for accumulation of charges when a patient is accepted into a prenatal program and the account will not be invoiced until after delivery, then “Accounts receivable” will not reflect these charges until the creation of an invoice. Deletion of charges from “Accounts receivable” is done when the practice receives payment, turns over debt to a collection agency or writes off the account as bad debt. “Accounts payable to patients and payers” are subtracted from “Accounts receivable” before reporting “Accounts receivable.” This is the net amount owed after patient refunds.

Do not include:

1. Capitation payments owed to the practice by HMOs.

Total medical revenue

Add “Total net fee-for-service collections/revenue,” “Net capitation revenue,” and “Net other medical revenue.”

Support staff cost

1. Salaries, bonuses, incentive payments, honoraria and profit distributions;
2. Voluntary employee salary deductions used as contributions to 401(k), 403(b), or Section 125 plans;
3. Compensation for all support staff employed by all of the legal entities working in support of the medical practice represented on this questionnaire;
4. Temporary staff working for temporary agencies;
5. The allocated support staff cost where the practice consists of multiple legal entities. For example, an MSO managing two medical practices and employing one billing clerk who devotes an equal amount of time to each practice would add 50 percent of the one billing clerk’s compensation to the total cost of “Patient accounting”, Cost column, for each managed practice; and
6. Compensation for both full-time and part-time employed support staff.

Do not include:

1. Nonphysician provider cost;
2. Expense reimbursements.

General operating cost

1. Information technology;
2. Drug supply;
3. Medical and surgical supply;
4. Building and occupancy;
5. Furniture and equipment;
6. Administrative supplies and services;
7. Professional liability insurance premiums;
8. Other insurance premiums;
9. Outside professional fees;
10. Promotion and marketing;
11. Clinical laboratory;
12. Radiology and imaging;
13. Other ancillary services;
14. Billing and collections purchased services;
15. Management fees paid to an MSO or PPMC;
16. Miscellaneous operating cost; and
17. Cost allocated to medical practice from parent organization

Do not include:

1. “Cost of sales and/or cost of other medical activities”;
2. Support staff cost;
3. Nonphysician provider cost;
4. “Purchased services for capitation patients”; and
5. “Nonmedical cost.”

Total operating cost

Add “Total support staff cost” and “Total general operating cost.”

Total medical revenue after operating cost

Subtract “Total operating cost” from “Total medical revenue.”

 

For a related dashboard by the same developer see this post:

Healthcare Xcelsius Dashboard used to Track Physician Compensation

 

Was this enterprise dashboard interesting enough to share? Help spread the news about Dashboards By Example. Click on the "Share" icon above to submit this post to your social bookmark service or email the link to a fellow dashboarder or even yourself.  


What do you think about this dashboard post? Please leave a comment. Your opinions are valuable to the entire business dashboarding community.  

Leave a Reply




Want to see a different randomly selected business intelligence dashboard example? Click here to view another Digital Dashboard from the Dashboard Spy.

Dashboard Spy Readers: See these related Business Intelligence Dashboard posts:

Learn how to create Excel dashboards.

Latest posts of interest to the business intelligence dashboarding community - Have you read these recent enterprise dashboard posts?