1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Data Modeling in Snowflake
Connected

Exercise

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.

Instructions 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.