This project was 'shoehorned' in at the end of our deployment with Metro Vancouver. The client required a dashboard to display energy consumption and treated water flow at any number of facilities scattered around the Lower Mainland (Vancouver, BC). Data is captured and stored continously, but there existed no means of reporting it to staff. A third party solution proposed by the vendors was considered much too expensive.
ShakingHand built a web 2.0 dashboard project using an embedded noSQL database (RavenDB) and extensive AJAX, jQuery and Knockout.js for a responsive, asynchronous front end and very easy to administer back end. Raw data is cached for performance and all data access is performed asynchronously for a rich user experience. A simple query interface was also built to allow users to interact with the data by selecting their own date range and data granularity (i.e. hourly, daily, weekly or monthly averages).
This application took about 2.5 weeks to complete. It saved the client buying a very expensive system and ended up delivering more functionality.