“Actual KPIs and metrics from real business cases! Real operations dashboards – That’s what we want examples of.” says a long-time reader of The Dashboard Spy who reminded me that I’ve gotten away from showing the nitty gritty details of business intelligence dashboards. She said that it’s all well and good that I’ve been pointing out design fundamentals and implementation best practices, but she misses the hard core “let’s see what other dashboard teams are working on” approach of the old Dashboard Spy days.
OK, I get the message. Let’s focus on more actual dashboards. Today we look at how the managers of the Singapore Subway system monitor the operational status of their trains, stations and other assets. How’s that for a specific business area of focus for us dashboard fans?
First, let’s take a quick journey to Singapore for a quick getaway before buckling down to some business intelligence.
The Mass Rapid Transit system (or MRT) of Singapore is currently composed of a total of 64 operating stations that serve a daily ridership of over 1.5 million people. There are plans for a large expansion project. Among rail buffs, the Singapore MRT system is of note in several areas. The stations are famous for being absolutely spotless. There are multiple train lines of the system, with the northeast line being completely underground using driverless trains. The platforms are sealed off from the tracks with safety screen doors to prevent access to the tracks and ensure climate control. The MRT is complemented by the LRT (Light Rail Transit). The LRT is close in spirit to people mover systems found in airports.
OK. Back to BI, metrics, KPIs and dashboard reports! Now let’s take a look at how they monitor their operations.
Thanks to the good graces of a Dashboard Spy located at the headquarters of Elixir Technology in Singapore, we have the following dashboard screenshots of the operations monitoring dashboard project. The dashboards are powered by Elixir Repertoire – a product for Dashboarding, Reporting, and Data ETL and Scheduling.
Here is the Command and Control Dashboard.
Click on the “more” link for more dashboard screenshots from this system as well additional commentary.
Here is some information that my source at Elixir Technology sent me:
It is a Singapore sub-way/metro/train station map, whereby one can have an overview of the current train status, and based on your selection, see which engineers have been deployed and active.
Drilling in further, one can also slice and dice through the cube, or represent them with the 32 different charts we provide. The one used here is a 3D chart with a camera angle to
be able to defined by users.
After one selects the records to view, a report can be printed out as seen from the last two slides.
Map and charts can be included, and reports can thus be printed out, saved as a softcopy (PDF with encryption, Excel, etc), or even emailed out to the right party.
Elixir Repertoire embraces Service-Oriented Architecture (SOA) through its REST APIs, making available Business Intelligence capabilities as Web Services. Web-enabled applications can interface with Repertoire Server, regardless of the application front end in use.
Do let me know if the screenshots are fine, and, fellow Dashboards by Example readers, please feel free to comment on this dashboard.
Here is another view of the Operations Monitoring Dashboard:
This next dashboard view shows some key performance metrics.
The first portlet shows trouble cases and their resolution status. Status, severity and service level agreement misses are shown. The dashboard portlet below that one provides absense management of the engineers with absent, idle and occupied statuses for the headcount in the system. The third portlet tracks software application, hardware, network and security issues for the IT department.
These next two dashboard screens show a resource utilization report.
Tags: Rapid Transit Operations Management Dashboard, Singapore subway KPI, Metrics Dashboard, Operational Monitoring Dashboard Reports