Elements of Dimensional Modelling

Fact tables

• Measurements, metrics or facts
• Corresponds to a business process (eg. sales)
• Verbs

Dimension tables

• Corresponds to a business entity
• Provides context to a business process (eg. customers)
• Nouns

Architecture of Dimensional Modelling

Stage area

• Contains the raw data
• Not meant to be exposed

Processing area

• Raw data to data models
• Focuses in efficiency and perfomance (query optimatization )
• Ensuring standards

Presentation area

• Final presentation of the data (eg. Tableau)

What is dbt?