Health-care Dashboard in Excel [Dashboard Week]

Posted on March 22nd, 2011 in Charts and Graphs - 5 comments

This post is part of Excel Dashboard Week

As part of Dashboard Week, in this post, we will take a look at Health-care Dashboard prepared and shared by Alberto.

Health-care Dashboard Snapshot:

Health-care Dashboard in Excel Snapshot

[Click here to view large version]

How is this Dashboard Made? – An Overview:

Alberto put together an excellent dashboard to visualize hospital performance and understand what is going on.

Here is what I like about the dashboard:

What can be improved in this dashboard?

  • Formulas: Alberto used IF formulas to fetch the values for each half-year (semestre). Instead using INDEX or OFFSET would make his job simpler.
  • Hardcoded targets: The target values for each metric are hard-coded. Instead, they should be put in a separate table, just like actual data.
  • Solid Fill bars: Instead of using gradient fill data bars, it is better to use solid fill bars thru in-cell charts.

How is the dashboard constructed? – An overview Video:

I have made a short video to explain this dashboard to you. Watch it to understand how this dashboard is made and how you can use similar techniques.

[Watch the video on Youtube]

Download the Health-care Dashboard Workbook

Click here to download the excel workbook for the Health-care Dashboard.

Thank you Alberto

I am really thankful to Alberto for taking time to share this file with us so we all can learn from his work.

If you enjoy this Dashboard, say thanks to Alberto.

Contribute to Excel Dashboard Week:

Share dashboard tips, snapshots, excel workbooks or links by filling out this simple online form. Go ahead and share what you got so that we all can learn from each other and become awesome.

Learn How to Make Excel Dashboards:

If you wish to learn how to make Excel Dashboards, join my Excel School online training program. We have 4 completed dashboard tutorials that teach you how to make a KPI dashboard, a Sales dashboard, a Business dashboard and a Website dashboard, all using MS Excel.

Click here to join Excel School program.

Join Excel School Online Training program by Chandoo to learn Excel Dashboards

Additional Resources:

Your email address is safe with us. Our policies

Written by Chandoo
Tags: , , , , , , , , , , , , , ,
Home: Chandoo.org Main Page
? Doubt: Ask an Excel Question

5 Responses to “Health-care Dashboard in Excel [Dashboard Week]”

  1. Busymanjohn says:

    This is nice layout and format, I can see how management would be able to get a lot of information from this, especially with the alerts for focus areas, the use of alerts seem key to the data within this Dashboard and that is what management want to see, what areas need focus right now ( so enables quicker decision making and less analysing data ). Well done Alberto.

  2. Aislan says:

    Where can I setup or see the “goals” for each topic on this spreadsheet?
    Regards,
    Aislan

  3. Aman says:

    This dashboard is great however I am unable to save onto my desktop

    Thanks

    Aman

Leave a Reply