Data Engineering Zoomcamp 2025

Homework 4: Analytics Engineering Statistics

Distribution of scores and reported study time for this homework.

Submissions

455

Median total score

6

Average total score

6

Score distribution

All values are points.

Questions score

Min
-
Median
6.0
Max
8
Q1
4.0
Avg
5.5
Q3
7.0

Learning in public score

Min
-
Median
0.0
Max
7
Q1
0.0
Avg
0.7
Q3
0.0

Total score

Min
-
Median
6.0
Max
16
Q1
4.0
Avg
6.4
Q3
8.0

Time distribution

All values are hours reported by students.

Lectures

Min
0.0
Median
6.0
Max
48.0
Q1
4.0
Avg
9.4
Q3
12.0

Homework

Min
1.0
Median
7.5
Max
70.0
Q1
4.3
Avg
9.6
Q3
10.0

Question breakdown

Correctness and answer distribution per question.

1. Model resolution

226 / 456 correct (49.6%)

1 select * from dtc_zoomcamp_2025.raw_nyc_tripdata.ext_green_taxi 63 (13.8%)
2 select * from dtc_zoomcamp_2025.my_nyc_tripdata.ext_green_taxi 5 (1.1%)
3 select * from myproject.raw_nyc_tripdata.ext_green_taxi 226 (49.6%)
4 select * from myproject.my_nyc_tripdata.ext_green_taxi 154 (33.8%)
5 select * from dtc_zoomcamp_2025.raw_nyc_tripdata.green_taxi 6 (1.3%)

2. Change the query

391 / 456 correct (85.7%)

1 Add ORDER BY pickup_datetime DESC and LIMIT {{ var("days_back", 30) }} 5 (1.1%)
2 Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ var("days_back", 30) }}' DAY 20 (4.4%)
3 Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ env_var("DAYS_BACK", "30") }}' DAY 20 (4.4%)
4 Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ var("days_back", env_var("DAYS_BACK", "30")) }}' DAY 392 (86.0%)
5 Update the WHERE clause to pickup_datetime >= CURRENT_DATE - INTERVAL '{{ env_var("DAYS_BACK", var("days_back", "30")) }}' DAY 17 (3.7%)

3. Lineage

335 / 456 correct (73.5%)

1 dbt run 7 (1.5%)
2 dbt run --select +models/core/dim_taxi_trips.sql+ --target prod 43 (9.4%)
3 dbt run --select +models/core/fct_taxi_monthly_zone_revenue.sql 17 (3.7%)
4 dbt run --select +models/core/ 49 (10.7%)
5 dbt run --select models/staging/+ 336 (73.7%)

4. Macros and Jinja

327 / 456 correct (71.7%)

1 Setting a value for DBT_BIGQUERY_TARGET_DATASET env var is mandatory, or it'll fail to compile 398 (87.3%)
2 Setting a value for DBT_BIGQUERY_STAGING_DATASET env var is mandatory, or it'll fail to compile 46 (10.1%)
3 When using core, it materializes in the dataset defined in DBT_BIGQUERY_TARGET_DATASET 419 (91.9%)
4 When using stg, it materializes in the dataset defined in DBT_BIGQUERY_STAGING_DATASET, or defaults to DBT_BIGQUERY_TARGET_DATASET 390 (85.5%)
5 When using staging, it materializes in the dataset defined in DBT_BIGQUERY_STAGING_DATASET, or defaults to DBT_BIGQUERY_TARGET_DATASET 404 (88.6%)

5. Taxi Quarterly Revenue Growth

328 / 456 correct (71.9%)

1 green: {best: 2020/Q2, worst: 2020/Q1}, yellow: {best: 2020/Q2, worst: 2020/Q1} 39 (8.6%)
2 green: {best: 2020/Q2, worst: 2020/Q1}, yellow: {best: 2020/Q3, worst: 2020/Q4} 41 (9.0%)
3 green: {best: 2020/Q1, worst: 2020/Q2}, yellow: {best: 2020/Q2, worst: 2020/Q1} 22 (4.8%)
4 green: {best: 2020/Q1, worst: 2020/Q2}, yellow: {best: 2020/Q1, worst: 2020/Q2} 329 (72.1%)
5 green: {best: 2020/Q1, worst: 2020/Q2}, yellow: {best: 2020/Q3, worst: 2020/Q4} 5 (1.1%)

6. P97/P95/P90 Taxi Monthly Fare

295 / 456 correct (64.7%)

1 green: {p97: 55.0, p95: 45.0, p90: 26.5}, yellow: {p97: 52.0, p95: 37.0, p90: 25.5} 40 (8.8%)
2 green: {p97: 55.0, p95: 45.0, p90: 26.5}, yellow: {p97: 31.5, p95: 25.5, p90: 19.0} 296 (64.9%)
3 green: {p97: 40.0, p95: 33.0, p90: 24.5}, yellow: {p97: 52.0, p95: 37.0, p90: 25.5} 27 (5.9%)
4 green: {p97: 40.0, p95: 33.0, p90: 24.5}, yellow: {p97: 31.5, p95: 25.5, p90: 19.0} 54 (11.8%)
5 green: {p97: 55.0, p95: 45.0, p90: 26.5}, yellow: {p97: 52.0, p95: 25.5, p90: 19.0} 11 (2.4%)

7. Top #Nth longest P90 travel time Location for FHV

308 / 456 correct (67.5%)

1 LaGuardia Airport, Chinatown, Garment District 309 (67.8%)
2 LaGuardia Airport, Park Slope, Clinton East 38 (8.3%)
3 LaGuardia Airport, Saint Albans, Howard Beach 46 (10.1%)
4 LaGuardia Airport, Rosedale, Bath Beach 16 (3.5%)
5 LaGuardia Airport, Yorkville East, Greenpoint 15 (3.3%)

Calculated: 8 March 2025, 18:13