Mastering Data: An Algorithm to Clean Names
It has been a great challenge in many companies to preserve name consistency with written Latin characters in countries where…
Data Articles
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…
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…