Last week I was visiting a customer in the transportation business. They were showing me a new safety business intelligence dashboard they were working on to analyze accidents and crashes. The first phase of the project focused on all accidents and crashes over a three year period. With more than 16,000 commercial vehicles on the road every day, this is a lot of data to analyze. However, what really struck me was the incredible number of ways they were able to slice, dice and analyze this data in the dashboard looking visually at data by region, depot, type of vehicle at the same time as looking at personnel and all the different categories of accidents and to compare all this at different time periods.
I was floored by the incredible amount of detailed information available at the click of a button and had to ask the question as to how much data was actually available to the dashboard. The customer explained that they had reduced the amount of data from about 500,000 rows to about 300,000 rows by organizing it as a cube in their Teradata Data warehouse and were loading it daily into the XML Data Cache (XDC) and using their XDC connectors in the Xcelsius dashboard solution.
They then showed me phase 2 of the project where they had placed a series of bubble charts on top of a geographical map to show location and type of accidents. They had built in the ability to zoom in on different regions of the country which was really cool.
But what really blew my mind were their plans for phase 3 where they are looking to collect geographic location information from the vehicles which are all equipped with satellite navigation systems that would transmit the location of the accident. The Business Intelligence dashboard would then display where most accidents and accidents of the same type were happening down to the exact street location so they could look for patterns and trends.
This is a truly inspired business intelligence solution and one of many that I am seeing these days. It is for this reason that at this year’s IBIS 2012 event in Dana Point, CA in June, there will be a 3-day Executive Track dedicated to “Inspired Business Intelligence Solutions”.
The track will consist of 12 inspired BI solutions presented by the customers themselves that created them. We have already encouraged several customers to present their solutions but we are still looking for a few more.
Inspired people with inspired ideas create inspired BI solutions so if you would like to submit your solution for this year’s IBIS and receive a $500 discount if selected then Just email firstname.lastname@example.org a description of your inspired solution focusing on the following points :
– Why did you create it?
– How did you create it?
– What were the benefits?
Please include any additional diagrams, screenshots, documents, quotes , photos or anything else that will help to further explain your inspired solution. Also provide your contact information and the best times to call you to discuss your entry.
Of course, if you would just like to come along and listen to 12 highly informative inspired business intelligence customer case studies and save $400 then be sure to Register by March 31 to take advantage of the early bird discount.