DATA ENGINEERING PLATFORMS (MSCA 31012
DATA ENGINEERING PLATFORMS (MSCA 31012) Part B (Individual): Dimensional Modeling( Sakila ) , Insights Page 2 2. Download Sakila Snowflake dimensional data model (DDL) from canvas –{ 40 Points } a. Run the DDL & DML provided for the Sakila dimension model b. For the missing Fact table fact_rental create the DDL and the DML scripts to pull data from the Sakila ER model. Modify/improve the fact table script if you need more metrics for the Tableau report below ( F
Written for
- Institution
-
University Of Chicago
- Module
-
ECON 21330 Data Construction
Document information
- Uploaded on
- July 26, 2023
- Number of pages
- 10
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
data engineering platforms msca 31012