Category Archives: Transport

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 to […]

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 your […]

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 is the least favourable […]

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 layer […]

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 write […]

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, XML and […]

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 Units
Shipped Dollars
Aging Units

One […]

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 by the overall storage capacity, […]

Dashboard Zone - Your online community for everything Dashboards