Accurate and up-to-date employee data is highly valuable as it not only enables banks to extract meaningful internal MI insights - including a comprehensive organisational structure - but also has regulatory compliance implications. In this regard, one of our banking clients tasked Monocle with facilitating the improvement of data quality and oversight of their employee data that had chronically suffered from incomplete and inaccurate records. The driving principle behind Monocle’s solution was the democratisation of data, whereby “the people most familiar with a given set of data are the best positioned to identify and correct errors therein”. As such, Monocle designed and developed an internal report that could share captured personal data directly with the employee and provide actionable pathways for correction, while adhering to strong data management principles such as security and access management to protect the sensitive personal data. Furthermore, the internal report consisted of a line manager and organisational view to provide management with broad insights into their respective teams and the firm as a whole.
The project began with an analysis of the existing employee data landscape, followed by the design of a Power BI-based solution consisting of a custom-built data model, which supports the various BI data views. Furthermore, a structured data alteration and correction process was designed so that the individual employees of the bank could review and correct their personal data. A significant portion of the project was dedicated to the visual design of the reports and their views to ensure the data could be consumed and interpreted easily. Therefore, once the data and business requirements were understood and a security framework was established to manage data access, an intensive process of stakeholder and end-user testing and feedback was initiated to establish the visual design, layout, and format of the internal reports and views.
The project’s benefit was immediately achieved as testing began, with unforeseen errors in personal and organisational data being identified upfront and proactively corrected before the official roll-out of the solution to bank employees.
