Data Modeling & Design
A great data model is like a blueprint for a skyscraper—without it, you’re just stacking bricks and hoping for the best.
Definition
Data Modeling & Design is the practice of creating formal data structures that represent the business and technical requirements of an organization. It forms the foundation for how data is captured, stored, organized, and used throughout its lifecycle.
- Maps out your data for organized storage and use
- Key types: Conceptual, Logical, Physical
- Provides structure for analysis, integration, and governance
Core Components
- Conceptual, Logical, and Physical Data Models
- Entity-Relationship Modeling
- Normalization & Denormalization
- Data Modeling Standards & Conventions
- Model Repositories and Collaboration Tools
Example in Practice
Consider a hospital designing a new electronic medical record (EMR) system. A strong data model defines what a patient is, how visits and treatments are linked, and how billing information relates to both. A clear model prevents data duplication and ensures accurate reporting.
Key Techniques & Tools
- ER/Studio, ERwin, dbt, Lucidchart
- Unified Modeling Language (UML)
- Star and Snowflake Schemas
- Business Glossaries
Upcoming Events & Content
June 12, 2025: "Modeling for Agility: Aligning Data Structures with Changing Business Needs"
Who Should Attend: Data architects, engineers, analysts, BI developers
Vendor Partners in this Space
DAMA International (DAMA-I) is a not-for-profit, vendor independent association of technical and business professionals dedicated to advancing the concepts and practices for data resource management and enterprise information. DAMA-I is the parent organization of the DAMA-MN, and has chapters and members throughout the world.