Data Models

Introduction In data warehouse, a data model is like a blueprint that shows how information is arranged. It helps that data is stored and used in a way that's good for analyzing and reporting. Fact tables A fact table is a central table in data warehouse. Fact tables have foreign key columns that link to the primary keys of dimension tables. These foreign keys establish relationships between the fact table and dimension table Dimension tables Dimension tables store descriptive attributes that provide context to the quantitative data stored in the fact table. E ach dimension table has a primary key, a unique identity for each record in the table. The primary key is used to establish relationships with the fact table. Dimension tables can have different levels that show how things are related in more or less detail. for example year > quarter > month > day Types of data model Star Schema T he star schema is a popular type data model because it is easy to understand and