Data Modeling

  • Data Modeling is a process to visualize the data warehouse.

  • It helps to set standards in naming conventions, creating relationships between datasets, and establishing compliance and security.

  • Most Complex phase in data warehouse design.

  • Recollect Top - Down vs. Bottom - Up that decision plays a vital role.

  • Data Modelling typically starts at the data mart level and then branches out to the data warehouse.

  • Three popular data models for data warehouses

    • Star Schema

    • Galaxy Schema

    • Snowflake Schema

PreviousEnvironmentNextChoosing ETL / ELT Solution

Last updated