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.
Diese Übung ist Teil des Kurses
Introduction to Data Modeling in Snowflake
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT
-- Retrieve all attributes from the dimension
___
FROM fact_employee_trainings
-- Merge fact table with dimension
JOIN ___
ON fact_employee_trainings.employee_id = ___;