Client stored data across multiple sources, and the data was constantly changing. The business and IT required a unified view and consistent definition of this data for cross-functional reporting. A need for proactive impact analysis was identified to highlight dependencies when changes occurred to a data model. Another key requirement was the ability to identify sensitive data and ensure it is managed in a secure manner, known as end-to-end data lineage.
Hawkins Point evaluated metadata management and data modeling tools, providing a detailed comparison of the options/vendors. We delivered both a data architecture playbook with standards for defining conceptual, logical, and physical data models, and a fully attributed and annotated logical model for the Commercial Data subject area. The playbook detailed steps to map physical data models to the logical model, ensuring data lineage. We defined a conceptual model for the entire Commercial scope including Master Data, Sales, Marketing, Market Access, Regulatory, and Supply Chain. We mapped the client’s commercial data environment to the logical model.