Before:
Limiting Manual Processes
One of the key services that The Equal Group offers to their corporate clients are EDI audits which help organisations identify areas of improvement with regards to workforce equality, diversity and inclusion. One key activity included collecting survey data from employees, using Excel to analyse results, and then presenting static reports to clients with PowerPoint.
Solution:
Quick Turnaround on Dashboards With Drillable Data
The Equal Group wanted to give their clients the ability to further interrogate their data by creating dynamic and drillable dashboards that could be embedded within their client application. The Equal Group tasked Spaulding Ridge with the configuration of a whole new data stack that would allow them to generate reports within days of receiving the data.
The team at Spaulding Ridge created a data stack on GCP to fulfill The Equal Group’s requirements. After setting up the new data warehouse, we created a flexible modeling layer within Looker that allowed for quick turnaround of new client dashboards. The model also ensured that strict data security policies could be applied such that the dashboard would allow for drill-downs into subsections of the data without exposing the identity of the employees.