1

I'm looking for some recommendations in terms of data visualisation tools.

At my current place of work we have 'Wallboards' - these are basically web pages which are displayed on the big screens, similar to a call centre, but which show some key metrics for the business area inside individual 'tiles', aka pre-sized boxes. As an example, in the warehouse the board may have tiles such as total orders, outstanding orders and date/time of oldest order. The data is provided via embedded queries from our MSSQL databases.

I'm looking at options for replacing them based on the following key reasons:

  • They look bad - the layout/presentation is basic and not very appealing

  • They are a resource drain - changes to the wallboard require a webapp/programming developer to make the front-end changes, and an SQL Developer to write the back-end data retrieval

  • They aren't dynamic - any amends need to be manually added in, which in a fairly fast-paced business can be a problem

Any recommendations people can make regarding a good solution for displaying this sort of thing would be much appreciated. Even just something which removes the need for the front-end changes would be a step in the right direction. We currently have SQL Server 2008R2 up to 2014, but any new features in 2016 would be considered, as would external tools such as PowerBI, Tableau, QlikView etc.

To take a good example, each of our delivery routes has a tile. If we add a new route we need to manually add a new tile for it. I would love something which could take the source data (i.e. a T-SQL query or SProc which is grouped by route number) and display the stats for each route in their own tile automatically. I have toyed with calling a subreport in SSRS for each row in a dataset, but it's very difficult to control the layout the way I would want. Something responsive which knew my canvas was X inches by Y inches (to fit to the panel display) and set out the tiles automatically would be great.

Thanks in advance!

1

Syncfusion Dashboard is an end to end Dashboard solution that can be used to create wall board type displays from SQL Server (or other data sources).

The specific requirement of having a dynamic number of tiles can be achieved using the Card widget.

Configure data to Card widget in Dashboard application link.

Dynamic number of tiles is achieved using the field in “Series” of the Card widget. For example we have added “OrderID” in series and the number of Cards will be generated based on “OrderID” count.

Dynamic tiles using Card Widget

We can refresh Card count with new data added in database using “Auto Refresh” support. link

Auto Refresh of Dashboard

The Dashboard Platform available for free through the community license if you qualify (less than 1 million USD in revenue) and flat licensing is available even otherwise.

Note: I work for Syncfusion.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.