1. 학습
    2. /
  2. 강의
    3. /
  3. Introduction to Data Modeling in Snowflake
Connected

연습 문제

Preparing dimensions

The HR department has data from employees and what training they have been doing. They have asked you to provide a model to quickly analyze large data sets, efficiently integrate reports and their business intelligence tools, and help them with data-driven decision-making.

Your task is to prepare the dimensions to connect to the fact table in the center of the star schema dimensions model.

지침 1/3

undefined XP
  • 1
    • Modify the employees entity to rename it to its dimensional name, dim_employees.
  • 2
    • Proceed to adjust the name of the departments entity to align with the dimensional format, dim_departments.
  • 3
    • Modify the name of the entity trainings to dim_trainings.