Tales & Tips from the Trenches: A Tool for Agile Data Transformation (MDOX)
Data Transformation is usually thought of in the context of database ETL (Extraction, Transformation, and Loading)— i.e. moving data wholesale…
data modeling
Databases Do Not Build Themselves
Unfortunately, a lot of databases start as a gleam in someone’s eye. Maybe it consists of a couple of tables needed…
Improve Data Governance in Your Data Models
The practice of improving data governance in data models is inefficient and can cause a potentially dangerous situation. This practice…
The Book Look: Achieving Buzzword Compliance
Come back in time with me to 1999. What a year for both movies and data! You probably can guess…
Applying Top-down, Big-Picture Models to Data Vault Part 2
Data Vaults have enormous potential to deliver value, but to do so, we’ve got to turn the spotlight off the…
Data Governance is a Hot Topic (Data Modeling Too)
Data governance is a hot topic lately. Companies are trying to devise and implement governance programs to provide some structure…
Applying Top-Down, Big-Picture Models to a Data Vault Part 1
Data Vaults have enormous potential to deliver value, but to do so, we’ve got to turn the spotlight off the…
How to Do Top-Down, Big-Picture Modeling – Part 2
This paper forms the second part of a big-picture top-down data modeling trilogy. The first paper on why to take…
When You Wish Upon a Star Schema
If there was ever a time when I was uncertain about the future of data, it’s now. I am not…
Why Do Top-Down Big-Picture Modeling? Part 2
The preceding article in this series looks at some real-world case studies that suggest that starting with an enterprise-wide, top-down…