Home > Dashboard Digest > Users >  

Sample Excel Report:

Hospital Measures: Abstracting & Submission Turnaround Dashboard

Like many other industries, hospitals must report information to a variety of agencies. This Excel dashboard reports each hospital's
record of performance in submitting such data.

Created by:
Neman Khokhar
Hospital Administrator
British Columbia, Canada
Also see his Ambulatory Care Sensitive Conditions Dashboard

by Charley Kyd

Neman Khokhar, who has owned Dashboard Reporting With Excel for several years, wrote that this is one of the first dashboards he created after buying my book.

"It compares the turnaround time for submitting data to a national database, showing several institutions in a health authority. I’ve also grouped the facilities by color to denote different sizes of facilities."

As  I quoted him in Excel Dashboards in Hospitals & Clinics, he found the dashboard format useful because it allows him to present the data in an abbreviated form, which allows him to display more measures on one page. Although Neman said he's not a technical person, he created this dashboard from scratch, using the techniques explained in the book.

Notice that Neman's Legend also includes other explanatory notes. Chapter 2 of the book explains how to set up one legend per page, rather than one legend per chart.

If you want to set up something like this quickly, here's an example of a report that you could set up in a few hours with IncSight DB.

Note to non-financial people: Excel users who work outside of Finance often write me to say that dashboards seem to be designed only for financial information. So if you're a non-financial person, notice that both of Neman's dashboards have nothing to do with finance.