What is a Dashboard?
The dashboard generally is like an information hub for the Driver of a vehicle, giving key stats of what is happening with the vehicle in real time, and the controls allows him to make fine adjustments and probe further to understand what’s happening to the vehicle. In the context of Business Intelligence, I would define a Dashboard as: A panel that displays the current status of metrics and key performance indicators (KPIs) for an enterprise, with the ability to pull real-time data from multiple sources
Let’s go back to our Vehicle analogy earlier to better understand how a Dashboard is crucial to Business Intelligence. Let’s assume the car to be a company, now take a look at the images below.
Obviously the second image looks cleaner.
I replicated the information from the Car dashboard into an Excel Sheet, it’s quite clear form the Car dashboard I can see a precise snapshot of information that is important and the less important ones are totally out of my view. The ABS column from the sheet tells everything is Okay, while on the Car Dashboard the ABS light isn’t turned on which means everything is Okay too. There are lots of other lights turned off, which means they are all okay, but from the sheet its clear there is information overload, with irrelevant information shouting for attention. This will surely be difficult to get much insight from while trying to navigate multiple roads and junctions, as compared to a dashboard.
Data has been described as a means to an end, the end is insight. Insight gives you leverage over your competitors. Business Intelligence tools will help you pull data from any disparate data source; from Excel sheets to an SQL Server Database and present it to you in formats that are intuitive to understand and manipulate in the form of feature rich Dashboards.