Physical Data Model and Data Governance
The Problem
An Australian Government agency needed to improve data quality and implement uplift initiatives. They also lacked a complete physical data model and faced challenges in capturing user feedback and tracking staff time.
What We Did
Bluebird, in collaboration with the client, identified performance metrics and developed a governance structure for dashboards. We designed solutions for user feedback capture, created a methodology for tracking staff time, and devised a change management plan. We also expanded the physical data model and developed a data dictionary for consistency.
The Outcome
As a result of these efforts, the agency completed the data warehouse using the physical data model, capturing all 72 performance metrics. They could now act upon user feedback recommendations and utilize website analytics.