• Home
  • Diver BI Group
    • Diver | BI
    • Customer Commendations
    • Videos
    • Case Studies & Customers
    • Documents and Brochures
    • Training
    • Diver BI Group Privacy Policy
  • Articles
    • News
    • Accolades
    • Blog
    • Ask Anthony
  • The Team
    • Key Experts
    • Members
      • Dynamic Business Informatics
      • Envisage
      • Chartwell IT
      • Data Management Business Insight
      • Manitex
      • Equiniti ICS
      • Pinnula
      • Dataweave Solutions
    • Partners
      • Dimensional Insight US
      • Dimensional Insight EU
      • Dimensional Insight Asia
      • DI Panama
      • ID Technology (Brazil)
      • Infotool (Nordic Countries)
      • BIMAXIS – DI France
      • Vision IT
      • Zight -Partner for Transport
  • Applications
    • Property
      • Property Prices Portal
    • Supply Chain
      • Retail
      • Distributor
      • Wholesale
      • Manufacturing
      • Produce
      • Beverage Alcohol Suppliers
      • Beverage Alcohol Distributors
      • Autoparts
      • Transport
      • Public Transport
      • DI Program Advisor
    • Healthcare
      • Healthcare
      • DI Surgery Advisor
      • Pharma BI Applications of Diver
    • Finance
      • Finance
      • DI GL Advisor
    • Mobile & SaaS
      • Diver BI SaaS
      • SaaS for Sales Gap Analysis
      • BI designed for Tablet
      • DiveTab – Mobile BI
    • Diverse Industries
      • Travel & Tourism
      • Colleges & Universities
      • Waste Management
      • Parking
      • Telecom Brokerage
      • Economic Trends
      • Maps
      • Carbon Emissions Management
  • Workbench
  • Contact
    • Free Consultation with One of Our Experts
    • Add a New Revenue Stream as a Partner

DiverBIGroup

Business Intelligence Experts

Diver BI Group Blog Learn How Indicators Within Tables Can Help With Data Comprehension

Learn How Indicators Within Tables Can Help With Data Comprehension

15th July 2021

DI healthcare tablet

by Nishtha Adroja

Reading Time: 7 minutes

Dashboards are great tools for visualizing data. Large amounts of data that might be tedious to analyze can be quickly summarized and displayed as charts or a single indicator. However, tables are better for the comparison of individual items. In tables, indicators can assist visualization and improve understanding of the data in the table.

So, how can you use these indicators?  Let’s look at the two examples mentioned above: standalone indicators and indicators that are part of a table.

There are many types of indicators in DivePort, Dimensional Insight’s dashboard software. They are all simple to use and easy to configure. You can see a list of all these indicators in Dimensional Insight’s online help.

It’s great to have a lot of options from which to choose. However, having many options to choose from presents the challenge of deciding on the most appropriate indicator to communicate the data you display. To do that, here are some tips.

  • Use indicators to enhance context via visualization, like using the color red to indicate an undesirable number.
  • Choose indicators that are intuitive and obvious. Users should be able to interpret the data quickly rather than spending a lot of time attempting to understand the data.
  • Indicators should drive the users towards the meaningful insight of the data to make actionable decisions.
  • Leverage QuickViews that act upon your indicators for diving capability and more interactivity.

Figure 1

The KPI or metric used for this article is Length of Stay (LOS), an essential metric in the healthcare world. Figure 1 shows a collection of different types of standalone indicators for LOS. At the top of the image, there are text indicators that provide numbers. The bottom of the image shows visual indicators which offer additional aspects to the KPI, like color, shape, and position that add meaning.

These indicators highlight different aspects of the KPI LOS. For instance, the first visual indicator compares the Actual versus the Expected value of LOS. The types of visual indicators from left to right are: Fuel Gauge, Fill Gauge, Circular Gauge, and Vertical Bullet. The visual indicator on the leftmost and the rightmost displays the value of Length of Stay Actual versus Expected. However, they use different approaches to presenting that data.

You’ll see a black line in the yellow in the fuel gauge, which is the expected target value for the Length of Stay. But because our actual Length of Stay is higher than expected, the pointer shows that the value is in the red color zone.

The second gauge is a Fill Gauge and displays the ratio of actual versus expected Length of Stay. The target is ‘1.0’. But because the actual value is higher than the target, the fill is colored red. If the actual Length of Stay were less than or equal to the target, the fill would be colored green.

The circular gauge shows that there is a 27% opportunity for improvement in terms of reducing the length of stay.

All the indicators are easy to configure. Users have a lot of control over their appearance and can choose different colors for the targets. Users can also edit the target value and use markers or Measure Factory standard measures to define the values in these indicators.

So this is the first approach, where you can use standalone indicators.

Now, let us look at a second indicator type, which adds meaning to numbers in a table.

Figure 2

In Figure 2, we have implemented the second approach. We have incorporated indicators in our tabular presentation. We have used DivePort’s measures portlet, but you can also use the matrix portlet to define these indicators. This table is divided into three sections to compare Volumes, Utilization, and Opportunity. You can select different values from the QuickViews: “Facility,” “Discharge year,” or “Service Line,” and you’ll see that all the numbers in the table change. For example, if we choose the Service Line “Endocrinology,” the table will display Endocrinology Volume and Endocrinology Opportunity. The best part about this page is that you can start at a high level and dive deeper for more information. You can see data for a KPI such as Length of Stay at an organization level. And then, you can dive deeper to find out if there’s an opportunity in any service line or any providers where you can reduce the Length of Stay.


Figure 4

The indicators in this table are easy and straightforward to configure, and there are many alternative indicator styles that you can incorporate.

Figure 3 utilizes all of these indicators. There are standalone indicators, text indicators, and visual indicators. There is also a table at the bottom of the image, which has indicators right in the table. So if we take a look at the example, we have selected all Service Lines. Looking at the “Attending Provider Service,” this view shows that Internal Medicine has the highest opportunity to improve by reducing the length of stay. The opportunity percent total is 55.3, and the most significant opportunity. The green circle in the racetrack indicator under “Opportunity” emphasizes that this is the most significant opportunity. These indicators provide information about the actual and expected LOS value. If the actual is higher than expected, the slope indicator points upwards and is colored red to indicate an undesirable value.

Figure 4 shows that we can dive further down on internal medicine by Attending Provider to determine if any specific provider shows a need for improvement. Here, the first provider shown has an 8.4% of the length of stay days. And there’s 9.5% of opportunity.

Figure 5

Figure 5 shows that if we want to dive further down, we can check the type of diagnoses that make up these values and see if there’s any room for improvement. We can dive on the provider’s name by Principal Dx Clinical Class to figure out the diagnoses with the greatest need for improvement. So from this dive, we can see the two top diagnoses, Diabetes and Congestive Heart Failure. They both are chronic conditions.

 

Figure 6

 

Figure 6 shows that we can dive further down by an account ID on congestive heart failure to find out if there are any specific account IDs with a high level of opportunity for improvement. Here, you can see the top three account IDs out of 16, which have the highest opportunity for improvement.

This is how you can start with the high-level Length of Stay information and then dive deeper into the numbers to find if there’s an opportunity for improvement or not.

To summarize how we achieved this analysis, we used standalone indicators and indicators that are part of a table. Like we saw in the dashboard example, while creating a dashboard page, you have to keep the user’s perspective in mind to create intuitive and actionable dashboard pages with effectively communicated information. Do not add so much information that you confuse the user. Also, make the dashboard pages interactive so that users can dive into the numbers. Users can slice and dice and get the information that they seek. Proactively diving into the data for the information they need can drive a user towards a meaningful insight into the data. And finally, indicators are an excellent opportunity to improve visual appeal for dashboard pages.

For more information, you can visit Dimensional Insight’s online help.

Nishtha Adroja
Nishtha is a Leading Business Intelligence Consultant at Dimensional Insight.

Tags: dashboard design, Dimensional Insight, Diveport, Diveport Design, Hospital Length of Stay, Indicators, KPI

Articles

  • News
  • Accolades
  • Blog
  • Ask Anthony
  • Diver | BI
  • Customer Commendations
  • Videos
  • Case Studies & Customers
  • Documents and Brochures
  • Training
  • Diver BI Group Privacy Policy

Dynamic Business Informatics Ltd

Distributors of The Diver Platform, providing business consultancy services, products and applications derived from Diver Gateway & Diver Platform.
14 Mellifont Avenue
Dun Laoghaire
Co. Dublin

+353 1 2302022

10 Kenyon Street
Nenagh
Co Tipperary

+353 67 43309

Contact Us

We would love to hear from you! Please submit your query and we will get in touch with you shortly.

Email addresses are never sold, rented, or shared. See our Privacy Policy.

  • This field is for validation purposes and should be left unchanged.

Accolades

  • High Praise for Dimensional Insight for 14th Straight Year in 2023 Wisdom of Crowds Business Intelligence Market Study
  • Best in Klas Report 2023 – Straight A Grades for Dimensional Insight
  • Dimensional Insight Named an Overall Leader by Dresner Advisory Services in 2022 Industry Excellence Awards
  • Dresner Wisdom of Crowds 2022 – Best in Class Results
  • Klas 2022 – A Grades for Dimensional Insight

Copyright © 2023 Diver BI Group · Privacy Policy · website by cubecolour

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.


What Are Cookies?


As is common practice with almost all professional websites this site uses cookies, which are tiny files that are downloaded to your computer, to improve your experience. This page describes what information they gather, how we use it and why we sometimes need to store these cookies. We will also share how you can prevent these cookies from being stored however this may downgrade or 'break' certain elements of the sites functionality.


For more general information on cookies, please read "What Are Cookies".


How We Use Cookies


We use cookies for a variety of reasons detailed below. Unfortunately in most cases there are no industry standard options for disabling cookies without completely disabling the functionality and features they add to this site. It is recommended that you leave on all cookies if you are not sure whether you need them or not in case they are used to provide a service that you use.


Disabling Cookies


You can prevent the setting of cookies by adjusting the settings on your browser (see your browser Help for how to do this). Be aware that disabling cookies will affect the functionality of this and many other websites that you visit. Disabling cookies will usually result in also disabling certain functionality and features of the this site. Therefore it is recommended that you do not disable cookies.


The Cookies We Set




  • Account related cookies


    If you create an account with us then we will use cookies for the management of the signup process and general administration. These cookies will usually be deleted when you log out however in some cases they may remain afterwards to remember your site preferences when logged out.




  • Login related cookies


    We use cookies when you are logged in so that we can remember this fact. This prevents you from having to log in every single time you visit a new page. These cookies are typically removed or cleared when you log out to ensure that you can only access restricted features and areas when logged in.




  • Forms related cookies


    When you submit data to through a form such as those found on contact pages or comment forms cookies may be set to remember your user details for future correspondence.




  • Site preferences cookies


    In order to provide you with a great experience on this site we provide the functionality to set your preferences for how this site runs when you use it. In order to remember your preferences we need to set cookies so that this information can be called whenever you interact with a page is affected by your preferences.




Third Party Cookies


In some special cases we also use cookies provided by trusted third parties. The following section details which third party cookies you might encounter through this site.




  • This site uses Google Analytics which is one of the most widespread and trusted analytics solution on the web for helping us to understand how you use the site and ways that we can improve your experience. These cookies may track things such as how long you spend on the site and the pages that you visit so we can continue to produce engaging content.


    For more information on Google Analytics cookies, see the official Google Analytics page.




More Information


Hopefully that has clarified things for you and as was previously mentioned if there is something that you aren't sure whether you need or not it's usually safer to leave cookies enabled in case it does interact with one of the features you use on our site.


However if you are still looking for more information then you can contact us through our contact page

Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT