20
Nov
2012

Dashboards for big LCD display and Tablets with Rubbi and Dashing

 

Posted by Jakub

 

Recently we came across the Dashing dashboard library from Shopify. It allows you to create colorful mash-up of charts, gauges and other data visualizations that will look great on big LCD display in a reception room. We decided to check how hard would it be to connect it to our Rubbi reporting tool.

First we created a Mondrian OLAP cube for fish market data from one of our clients (check out our previous post about our best practices for creating OLAP cubes and creating date dimensions). Next, we connected it to Rubbi and played a little bit to create some useful reports.

When done, were able to plug saved reports into Dashing library thanks to Rubbi’s JSON API. To use data from external services in Dashing you need to create a scheduled job that will populate your widgets. Dashing’s backend code is written in Ruby so we had no problem getting it to work. Here’s the result:

Dashing’s programming model makes it good fit for displaying real time data. The default set of widgets is relatively small, but you can easily extend it based on examples. There is also no interaction between default widgets, as library was meant to be displayed on big external displays (again you can code it yourself). We were also amazed to see that our dashboard looked great on an iPad tablet.

Tags: , , , , , ,
Posted in: Business Intelligence

Interested in working with Freeport Metrics?

Request a proposal or call us at +1 207 200 4032