Risk Data Aggregation and Reporting for BCBS 239
1.0 Introduction The lack of any prescribed reporting framework, workflow, or any other prescribed action is perhaps the most striking…
Data Articles
How to Avoid the Requirements Trap
Jason Williscroft has written elsewhere about sources of inertia that can send an EDM project sideways. In that piece he…
Protection of PII Data is Vital: A Slice of PII
“It is not me!” I am not the one making the rules. I was not the person who decided that…
Toward a Better Understanding of Metadata – Governance
New business and technological disruptions are changing the nature and meaning of Data Governance, fostering new ways to manage and…
How to Manage Null Values in Your Data Warehouse
I’m sure many business intelligence developers have experienced a customer asking why there are null values in their report and…
Data Modeling Techniques – Efficiency of Meta-Entities in an ERD
This article considers the simplification of entity-relationship diagrams by the use of meta-entities. Indexes to measure the effectiveness of simplification…
Topology of Data Models within the Enterprise
Introduction There are four data models that form the overall data model topology within an enterprise. These are depicted in…
Toward a Better Understanding of Metadata – Examples of Metadata in Business
This is the second in a series of articles on improving people’s understanding of a widely misunderstood term – “metadata”…
Data as an Enabler of Corporate Value
Data Quality Management’s Break The accuracy and speed of execution in many corporate processes rely on the quality of the…
A Really Close Look at the “Universal Data Vault” (UDV)
This is the second of two articles from John Giles on Universal Data Vault (UDV) design. Part one of the…