UrbanPro
true

Learn BI Reporting from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

What is a Dashboard?

ITech Analytic Solutions
30/12/2016 0 0

Introduction

There are many different ideas of what a dashboard is. This article will clearly define it along with other presentation tools. In article, What is BI? - A Business Intelligence Primer, it is discussed the presentation layer of the business intelligence technology stack. To reiterate, there are typically four types of presentation media: dashboards, visual analysis tools, scorecards, and reports. These are all visual representations of data that help people identify correlations, trends, outliers (anomalies), patterns, and business conditions. However, they all have their own unique attributes.

Dashboards

Dashboard Insight uses Stephen Few’s definition of a dashboard:

A dashboard is a visual display of the most important information needed to achieve one or more objectives; consolidated and arranged on a single screen so the information can be monitored at a glance.

Here are the key characteristics of a dashboard:

  • All the visualizations fit on a single computer screen — scrolling to see more violates the definition of a dashboard.
  • It shows the most important performance indicators / performance measures to be monitored.
  • Interactivity such as filtering and drill-down can be used in a dashboard; however, those types of actions should not be required to see which performance indicators are under performing.
  • It is not designed exclusively for executives but rather should be used by the general workforce as effective dashboards are easy to understand and use.
  • The displayed data automatically updated without any assistance from the user. The frequency of the update will vary by organization and by purpose. The most effective dashboards have data updated at least on a daily basis.



Visual Analysis Tools

Some consider tools that offer the ability to select various date ranges, pick different products, or drill down to more detailed data to be dashboards. At Dashboard Insight, we classify these as visual analysis tools.
Here are the key characteristics of a visual analysis tool:

  • It fits on one screen, but there may be scroll bars for tables with too many rows or charts with too many data points.
  • It is highly interactive and usually provides functionality like filtering and drill downs.
  • It is primarily used to find correlations, trends, outliers (anomalies), patterns, and business conditions in data.
  • The data used in a visual analysis tool is generally historical data. However, there are some cases where real-time data is analyzed.
  • It helps to identify performance indicators for use in dashboards.
  • It is typically relied on by technically savvy users like data analysts and researchers.



Scorecards

Scorecards and dashboards are often used interchangeably, but Dashboard Insight has a specific definition:

A scorecard is a tabular visualization of measures and their respective targets with visual indicators to see how each measure is performing against their targets at a glance

In addition, it should not be confused with Kaplan and Norton’s Balanced Scorecard. Here are the key characteristics of a scorecard:

  • It contains at least a measure, its value, its target, and a visual indication of the status (e.g. a circular traffic light that is green for good, yellow for warning, and red for bad) on each row.
  • It can be used in a dashboard but the scorecard should not be interactive nor contain scroll bars.
  • It can be used in a visual analysis tool but the scorecard doesn’t need to be interactive.
  • It may contain columns that show trends in sparklines.



Reports

Reports contain detailed data in a tabular format and typically display numbers and text only, but they can use visualizations to highlight key data.
Here are the key characteristics of a report

  • It presents numbers and text in a table.
  • It can contain visualizations but only used to highlight findings in the data.
  • It is optimized for printing and exporting to a digital document format such as Word or PDF.
  • It is geared towards people who prefer to read data, for example,  lawyers, who would rather read text over interpreting visualizations, and accountants, who are comfortable working with raw numbers.
0 Dislike
Follow 0

Please Enter a comment

Submit

Other Lessons for You

Pivot table - Transform numbers in calculated field
How to convert the absolute numbers in pivot table into Lakhs, Millions, Trillions without adding a spare column in the data source. Name the field in the Calculated field and apply the formula by Double-clicking...

Database Normalization
Database Normalization is the process of reducing duplication in database by decomposing the table1. Normal Form (1NF): Every attribute is atomic, Each cell to be single valued No multivalued attribute:...

Five Stages of Team Development
Tuckman Ladder developed by Tuckman describes five stages of team progression Forming. Team members meet and learn about the project. Individuality is high Storming. Team members start working....

Working with Different Versions of VBA
Office 2010 introduces a new version of Microsoft Visual Basic for Applications (VBA) known as VBA 7.0 that is updated to work with 64-bit client installations. VBA 7.0 improves the performance of your...

Hide Duplicate Values & Apply Borders Using Conditional Formatting
Please refer following screenshots:1st Screenshot: Original Dataset2nd Screenshot: After Conditioinal Formatting is applied In 2nd screenshot, using Conditional Formatting:1) Repeat months are...

Looking for BI Reporting Training?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for BI Reporting Classes?

The best tutors for BI Reporting Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn BI Reporting with the Best Tutors

The best Tutors for BI Reporting Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more