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
Fear of missing out? Then don’t!
Do you wonder why so many students wear nice clothes, have money to spare and enjoy tons of free time? Well, they sell on Stuvia! Imagine your study notes being downloaded a dozen times for $15 each. Every. Single. Day. Discover all about earning on Stuvia