By Pete Stiglich In a dimensional model, how do you handle missing or invalid values in a fact table source record that are used to…
Normalization of Knowledge
By Donavon Gooldy Normalization is NOT an engineering exercise. The central principle that underlies its rules is that data redundancy, whether repeating groups of attributes or…
What is Data?
By Donavon Gooldy A leader of one of the consulting firms I’ve worked for in my career answered our title question by stating that “Data…
Conceptual Modeling to Enhance Data Quality
By Pete Stiglich Explores how conceptual modeling improves data quality by forcing clarity on business concepts, definitions, and the rules that connect them. By identifying…
Start Your BI Journey with the Data Model
By Jeremiah Willett Data Principles is currently building a training course for a client: Introduction to Power BI. One of the most important topics in…
Conceptual Data Models and Relationships
By Pete Stiglich Explains how conceptual data models (CDMs) capture core business concepts and the meaning of relationships before you get into implementation details. It…
A Wish List for Data Modeling Technology
By Pete Stiglich A practitioner’s “wish list” for what modern data-modeling tools should do better: support collaboration, manage definitions and metadata as first‑class artifacts, and…
Healthcare Data Modeling Governance
By Pete Stiglich Discusses why healthcare environments need both strong data modeling discipline and governance to achieve trustworthy analytics and compliance. It highlights that complex…
