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…
Business Intelligence Articles
Business Intelligence 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…
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…
Data Cleansing vs Data Maintenance: Which One Is Most Important?
There are always two aspects to data quality improvement. Data cleansing is the one-off process of tackling errors within the…
Agile Methodologies in EDM Projects
Everybody loves Agile. Right? I see it every day. The Scrum Master opens the daily ceremony with a flourish of…
Is the “Data Asset” Really Different?
I recently presented a seminar at an event called “Data, the Vital Organisational Enabler” Information is at the Heart of ALL…
Developing a Return on Investment
This article addresses the concept of developing a Return on Investment (ROI). It does so by first defining the ROI…
Back to the Future
While I was presenting recently at a seminar called “Data, the vital organization enabler,” I hosted a session…
The Meta-Data Fiasco
The terms meta-data and metadata have been used, misused, and abused to the point that the real meaning is totally…