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
As you read this, a fellow student has made another $4.70
How did he do that? By selling his study resources on Stuvia. Try it yourself! Discover all about earning on Stuvia