Beziehungen (EN)

Relationships in the Data Model

Relationships are connections between tables in a data model that are based on common key fields. They define how data from different tables can be merged and analyzed. In BI tools like Power BI, relationships must be explicitly defined to ensure consistent calculations. Circular references between tables should be avoided as they can lead to unexpected results in data analysis. Correct relationships are the foundation for meaningful data models and visualizations.

Architecture

flowchart LR   A[Customer Table] -->|Foreign Key| B[Orders Table]   B -->|Foreign Key| C[Products Table]   D[Categories Table] -->|Foreign Key| C 

In Context

• Typically used together with dimensions and facts in star and snowflake models
• Related to: Normalization, data integrity, keys (primary, foreign)
• Example use: Linking customer data with order history for customer analysis