ECON 21330 Data Construction
University Of Chicago
All 1 results
Sort by
-
DATA ENGINEERING PLATFORMS (MSCA 31012
- Exam (elaborations) • 10 pages • 2023
-
- $9.99
- 2x sold
- + learn more
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
Make study stress less painful
Study stress? For sellers on Stuvia, these are actually golden times. KA-CHING! Earn from your study resources too and start uploading now. Discover all about earning on Stuvia