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.
Deze oefening maakt deel uit van de cursus
Introduction to Data Modeling in Snowflake
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
--Modify entity
ALTER ___ IF EXISTS ___
___ TO dim_employees;