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

Exercise

Retrieving data from dimensional model

With the new dimensional model in place, the HR department wants to analyze the training sessions attended by all the employees in 2023. They are trying to gather the employees' average score, which is lower than the minimum 100 points, to call them for extra training.

Your task is to extract this information from the data warehouse.

Instructions 1/4

undefined XP
    1
    2
    3
    4
  • Retrieve all the attributes from the employees entity.
  • Merge the dim_employees dimension with the fact table based on the employee_id key present in both entities.