The project was initiated to deliver a set of informational tools which would enable business improvements to be made. These dashboards built on data logic were designed to highlight specific areas of importance and, by including data drilldown components, allow an understanding of the root cause of potential security issues and areas of non-compliance within the estate.
To ensure data information validity, we focused on all figures and tables being traceable from original source to final dashboard and that they were presented clearly and concisely. Additionally, we undertook an analysis of the full data available and completed a gap analysis against the requirements to understand where potential data points were missing from datasets.
The first step was to fully understand the requirements of the various teams that used the dashboards and what their challenges were in using the existing ones.
This resulted in the creation of a data silo for each dashboard that was then assigned a dedicated developer who owned that silo. The developer would then work with the client team that used the dashboard to get the real depth of understanding on their specific requirements. By working closely with the user team(s) aligned to each silo we promoted positive dialogue on their requirements and current challenges.
Also within the scope of this silo approach was to gain knowledge and understanding about the various tools that provided the data feeds into the data warehouse solution. An iterative approach to development with regular playback sessions of ongoing prototypes helped to enable a rapid short cycle of change and feedback.
A study of the existing User Interface was also carried out and a consistent “Look and Feel” designed from scratch. This design approach was then applied to any new or existing dashboards that were in scope across all the silos.