Data mining and visualisation

Performance dashboard

The Knowledge, Analysis and Intelligence team at HM Revenue and Customs needed an inexpensive way to measure performance to ensure that they were meeting expectations. In an initial scoping phase, Jigsaw consultants liaised with all stakeholders, including senior board representatives and internal customers, to understand the need for performance information and how best to deliver it. We then prepared a written report outlining potential solutions. We were asked to implement the preferred option, and in phase 2 developed a fully automated Business Intelligence application in Microsoft Access, pulling data from multiple disparate sources and using Excel to deliver a bespoke scorecard to monitor current performance and show how this changed over time.

Client comments: "Despite the limitations of our current technology and available funding, Jigsaw were able to develop an effective BI system. We can now effectively and efficiently manage our internal processes and measure our performance against agreed indicators to demonstrate that we are meeting customer and stakeholder expectations."