Fuel Gauge Dashboard using Excel Web Query

How to create Dashboards using Excel Web Query? First, what is Excel Web Query? An Excel Web query allows you to bring data from a Web site into an Excel worksheet. It will find any tables on the Web page and let you select the ones containing data you want to put into your worksheet, … Read more

Airport Dashboard and Metrics- Microstrategy

Some of the important Airport related metrics that a typical dashboard should monitor are listed below Aircraft landing fee: The fee charged by the airport as landing fee per aircraft. Operating expenses: These are the costs incurred on the staff, repairs and maintenance, services per work load unit (1 work load unit= 1 passenger). Number … Read more

California Department of Transportation Dashboard

This is one cool dashboard from Microstrategy based on data from California Department of Transportation. The dashboard has a video section (top right square) which is quite engaging. On the very left there are city names that zoom in and out based on your mouse pointer. They are used as a filter on the charts … Read more

Dashboards that help lower your Car insurance?

This is an amazing piece of technology. It is a box known as Coverbox that can be installed in your car. Once installed it collects information about your driving patterns, fuel consumption and mileage. The best thing is all of this data help determine your insurance rates. You also get to analyze how to improve … Read more

Various methods of creating Digital Dashboards – Part 4

Read about the Type – 1 approach Type – 2 approach Type – 3 approach Type 4: This type defines the method of creating dashboard using Excel. The data and presentation is all part of the Excel file. This is the most popular approach as it is very easy and affordable to create dashboards. It … Read more

Various methods of creating Digital Dashboards – Part 3

Read about the Type 2 Approach Type 3: This category involves the use of some big vendor BI tool. These BI tools are quite comprehensive and come with tons of options to choose from. They provide ad-hoc reporting and easy dashboard creation options. Once installed and configured, there is often a need to define data … Read more

Various methods of creating Digital Dashboards – Part 2

This is a continuation of the Dashboard Creation Methods Type 2: This category involves the use of some Dashboard designing tool. You need to download and install the third party software and learn their basic steps in designing the dashboards. Most often the designing tools offer variety of connection methods to the various databases and … Read more

Various methods of creating Digital Dashboards – Part 1

Are you trying to build a Dashboard or a new Application? Three are three types of Dashboard Solutions Type 1: This category defines those tutorials where you built everything from scratch. You write your own SQL queries, database connection methods and create data files. Then you construct your own presentation layer by defining the html, … Read more

Shipping Dashboard | Shipment Management Dashboard | Dashboard for Shipping Management

This is another DBI dashboard (custom made) by one of our Dashboard Zone reader. It is interesting to know the different metrics that are being tracked on a daily basis. The user has this daily program that takes information from Oracle ERP and puts them in aggregated form (materialized views) On Time Qty % Shipped … Read more

Dashboard and Metrics for Transportation | Transport KPI – metrics

Frequency of damage Number of incidents during the given period divided by the total number of processed orders, multiplied by 100 Time spent picking back orders or stock-outs Number of hours spent on picking back orders or stock-outs, divided by the total number of working hours, multilpied by 100 Storage utilization Utilized storage space divided … Read more