WorksheetsDesigning Data Model in Power BI
Total questions: 10
Worksheet time: 3mins
It is the process of analyzing and defining all the different data your business collects and produces, as well as the relationships between those bits of data.
Data Ingestion
Data Modeling
Data Warehousing
Data Transformation
A mature modeling approach which requires modelers to classify their model tables as either dimension or fact.
Snowflake Schema
Galaxy Schema
Star Schema
Star Cluster Schema
Tables containing observational or event data values and can contain several repeated values.
Data Model
Dimension Table
Primary key
Fact Table
Tables in Star Schema which support summarization
Fact Tables
Foreign keys
Primary keys
Dimension Tables
IDs or other key values that are used to uniquely identify instances of each entity
Foreign keys
Fact Tables
Primary keys
Dimension Tables
Most common type of cardinality and is the Power BI default when you are automatically creating relationships
One-to-One
Many-to-Many
Many-to-One or One-to-Many
Bi-directional Cross-filter
This type of cardinality is not recommended since it stores redundant information and suggests that the model is not designed correctly.
Many-to-many
One-to-Many
Many-to-One
One-to-One
Type of cardinality which does not require unique values in either table in a relationship
Many-to-Many
Many-to-One
One-to-One
One-to-Many
With this cross-filter direction, only one table in a relationship can be used to filter the data.
Both cross-filter directions
Bi-directional cross-filtering
Double cross-filter directions
Single cross-filter direction
These allow us to view increasing levels of data on a single view
Cardinalities
Hierarchies
Relationships
Cross-filter directions
