CCO is a new Data Service Platform to govern the structure of Deutsche Bank's CIB data. I helped created views to clearly display the Enterprise Data Model — allow streamlined data onboarding for upstream Publisher & downstream Consumers.
The project involved extensive collaboration with cross-functional leadership & teams to ensure the experience met both technical requirements & user needs while adhering to strict governance standards.
Objectives
Create a unified data discovery, service experience to govern mature, complete, & timely data for the whole bank.
Model & visualise complex data relationships to support the distribution of measured & governed data.
Provide an efficient, mutually agreed workflow for data distribution & utilisation.
Trust In Our Data
The challenge was to create a unified data discovery platform that will dimistify the complexity of Deutsche Bank's data ownership hierarchy—providing an intuitive 'Self-Service' experience for users with varying levels Enterprise Data Model exposure search, discover & utilise data.
Challenge
Solution
Data Complexity
The bank's data ecosystem was highly complex with numerous systems and data sources.
Created intuitive visualisations that simplified complex data relationships and hierarchies.
Regulatory Compliance
Strict regulatory requirements necessitated robust data governance and audit capabilities.
Designed comprehensive audit trails and governance dashboards to ensure compliance.
User Diversity
Users ranged from technical data specialists to business executives with varying needs.
Created role-based interfaces with appropriate levels of detail and complexity for each user type.
Structured, Searchable, Discoverable & Cleansed Data; CCO Home, Ownership Discovery, Self Service Data, Data Maturity & Timeliness Dashboards
Discovering the Data Platform
Unified Data Catalog
Worked with Product Owner to successfully deliver a comprehensive Data Search & Discovery experience roadmap, providing a single source of cleansed data, with clearly defined Ownership Structure & Governance processes.
Data Visualisation
Collaborated with business intelligence analyst generating dashboards visualising the full Ownership Data Structure, Timeliness & Maturity Status.
Self Service Data
Partnered with Onboarding Lead analyst to reconstruct undocumented data publishing & consumption request processes, workflows & to deliver fully trusted Publisher & Consumer "self service" applications.
Outcomes
Improved Data Quality and Accessibility
Data Quality Metrics
Achieved a 75% improvement in data quality metrics across critical data domains.
Data Discovery
Reduced time to discover relevant data assets by 60%, improving analyst productivity.
Enhanced Governance and Compliance
Regulatory Reporting
Streamlined internal reporting processes, reducing preparation time significantly as required data attributes were easily analysed from ownership to protocol.
Audit Capabilities
Enhanced audit capabilities with comprehensive data lineage and change tracking.
Data Ownership
The experience supported clear established data ownership & governance across the organisation.
Business Impact
Decision Making
Improved data-driven decision making with visibly validated & approved data.
Cross-Functional Collaboration
With integrated notifications & state of data visualised & shared in dashboards, collaboration between upstream & downstream technical teams was vastly improved.
Research, Discover & Realise
Throughout the discovery phase of the project, workshops and knowledge-sharing sessions were instrumental in providing context to the challenges ahead and rallying the team around a common strategy.
These sessions were also utilised to document existing workflows and touch-points, exposing gaps and bringing clarity to where processes were broken or workarounds had been adopted.
-
Leadership Workshop
Facilitated workshops with leadership, business users & compliance officers to outline their processes, expose gaps & detail pain-points to identify opportunities & challenges.
Facilitated leadership session sketching full onboarding workflow detailing all upstream & downstream touch-points, dependencies.
High level Identified requirements from session
Onboarding workflow diagram rationalised from facilitated session mapping existing workflow, processes & touch-points
Ideation & Collaboration
The navigation structure was developed from the initial roadmap outline through a series of interviews & reviews with senior product leads and programme managers to best group & service across the themes.
-
Information Architecture
Application navigation mapped across Themes, Entry Points, Attributes & Actuals
Wireframes layout of expected application navigation experience -
Content Planning — Wireframes
In collaboration with the Onboarding Product Owner, a series of diagrams were produced to translate Excel process documentation into a logical data grid. This grid reflects the publisher and consumer data onboarding process stages and statuses.
At each stage of the data onboarding workflow, progress is reported and monitored using this grid.
CCO Overview of full Publisher Onboarding process in relation to overall solution
Diagram mapping required fields for a standardised "Publisher Population" process
Wireframes aligned to mapping diagram
Visual Communication
During the application's design, various concepts were generated across its sections. One key area of focus was the visualisation of a complex "Data Structure" to provide an overview of the bank's "Data Ownership Structure".
The goal was to create a searchable and navigable model that allows users to explore the "Data Model" from the business unit level down to individual data protocols.
Multiple versions were created, each exploring different themes. These ranged from a simplified Enterprise-Data Model (EDM) to a quantitative analysis of data models. The iterative process aimed to identify the most effective way to represent and interact with the complex data ownership structure.
-
Design Iteration
Tree structure style providing ownership & commentary features, but lacking scale
Mosaic theme driven by quantitative qualities of the composite attributes of the data structure
An extension of the Mosaic theme providing enhanced visual details localised to each business units composite content
An elaborate theme derived from 6 driving principles of the project — Governed, Owned, Cleansed, Timely, Complete & Mature data. -
Interactive Prototypes
Developed interactive prototypes to test and validate design concepts.
Developed interactive prototypes to test and validate design concepts.
Implementation
As part of the delivery process a series of scenario based storyboards were created to tell the story of a particular workflow, or interaction providing context, relevant content with clear descriptions & components.
-
Developer Collaboration
Annotated designs provide scenario derived guidance for wider audience & development teams
Old skool pixel perfect layout guidelines
Colour usage guidelines
Retrospective
Balancing Technical and Business Needs
One of the key challenges was balancing the technical complexity required for accurate data representation with the need for intuitive interfaces that business users could understand. The project required continuous iteration and feedback to find the right balance.
Organisational Change Management
The success of the data discovery platform depended not just on the technical implementation but also on broad organisational adoption. Significant effort was invested in change management, training, and communication to ensure users embraced the new tools and processes.
