Homework 1: Docker, SQL and Terraform
- Submissions
- 1102
- Completion
- 42.7%
- Median score
- 6
- Lecture time
- 8h
- Homework time
- 4h
- Total time
- 13h
Data Engineering Zoomcamp 2025
Data Engineering Zoomcamp 2025 Dashboard
Course-level participation, homework, and project statistics.
Course overview
- Total enrollments
- 2581
- Project submissions
- 398
- Project completion rate
- 14.2%
- Average total score
- 14.8
- Overall completion rate
- 22.0%
- Graduates
- 345
Project outcomes
- Score to pass
- 0
- Passed
- 358
- Failed
- 40
- Median project score
- 33
Homework statistics
Median time and score by homework. Hover values on desktop for interquartile ranges.
| Homework | Submissions | Completion | Lecture time | Homework time | Total time | Median score |
|---|---|---|---|---|---|---|
| Homework 1: Docker, SQL and Terraform | 1102 | 42.7% | 8h | 4h | 13h | 6 |
| Homework 2: Workflow Orchestration | 686 | 26.6% | 6h | 3h | 9h | 6 |
| Workshop 1: Ingestion with dlt | 504 | 19.5% | 2h | 1h | 3.5h | 4 |
| Homework 3: Data Warehousing | 583 | 22.6% | 3h | 2h | 6h | 8 |
| Homework 4: Analytics Engineering | 456 | 17.7% | 6h | 8h | 14h | 6 |
| Homework 5: Batch | 408 | 15.8% | 6h | 2h | 9h | 6 |
| Homework 6: Streaming | 228 | 8.8% | 5h | 6h | 12.5h | 6 |
Homework 2: Workflow Orchestration
- Submissions
- 686
- Completion
- 26.6%
- Median score
- 6
- Lecture time
- 6h
- Homework time
- 3h
- Total time
- 9h
Workshop 1: Ingestion with dlt
- Submissions
- 504
- Completion
- 19.5%
- Median score
- 4
- Lecture time
- 2h
- Homework time
- 1h
- Total time
- 3.5h
Homework 3: Data Warehousing
- Submissions
- 583
- Completion
- 22.6%
- Median score
- 8
- Lecture time
- 3h
- Homework time
- 2h
- Total time
- 6h
Homework 4: Analytics Engineering
- Submissions
- 456
- Completion
- 17.7%
- Median score
- 6
- Lecture time
- 6h
- Homework time
- 8h
- Total time
- 14h
Homework 5: Batch
- Submissions
- 408
- Completion
- 15.8%
- Median score
- 6
- Lecture time
- 6h
- Homework time
- 2h
- Total time
- 9h
Homework 6: Streaming
- Submissions
- 228
- Completion
- 8.8%
- Median score
- 6
- Lecture time
- 5h
- Homework time
- 6h
- Total time
- 12.5h
Assignment difficulty
Ranked by lowest median question score relative to the maximum achievable. Normalizing by question count makes homeworks of different lengths comparable; a lower percentage indicates a harder assignment.
| Rank | Homework | Median score | Score % | Completion |
|---|---|---|---|---|
| 1 | Homework 4: Analytics Engineering | 6 / 8 | 75.0% | 17.7% |
| 2 | Homework 1: Docker, SQL and Terraform | 6 / 7 | 85.7% | 42.7% |
| 3 | Homework 2: Workflow Orchestration | 6 / 6 | 100.0% | 26.6% |
| 4 | Homework 3: Data Warehousing | 8 / 8 | 100.0% | 22.6% |
| 5 | Workshop 1: Ingestion with dlt | 4 / 4 | 100.0% | 19.5% |
| 6 | Homework 5: Batch | 6 / 6 | 100.0% | 15.8% |
| 7 | Homework 6: Streaming | 6 / 6 | 100.0% | 8.8% |
Question difficulty
Share of submitted answers that were correct, per question. A lower percentage points to a harder or more confusing question. Participation-only questions are excluded.
| Homework | Question | Correct | Answers | % correct |
|---|---|---|---|---|
| Homework 1: Docker, SQL and Terraform | Version of pip | 1018 | 1102 | 92.4% |
| Docker networking and docker-compose | 862 | 1102 | 78.2% | |
| Trip Segmentation Count | 631 | 1102 | 57.3% | |
| Longest trip | 966 | 1102 | 87.7% | |
| Biggest pickup zones | 1018 | 1102 | 92.4% | |
| Largest tip | 928 | 1102 | 84.2% | |
| Terraform | 970 | 1102 | 88.0% | |
| Homework 2: Workflow Orchestration | File size | 578 | 685 | 84.4% |
| Rendered value | 647 | 685 | 94.5% | |
| Number of rows (yellow, 2020) | 637 | 685 | 93.0% | |
| Number of rows (green, 2020) | 634 | 685 | 92.6% | |
| Number of rows (yellow, March 2021) | 636 | 685 | 92.8% | |
| Timezone for trigger | 628 | 685 | 91.7% | |
| Workshop 1: Ingestion with dlt | How many tables were created? | 480 | 504 | 95.2% |
| The total number of records extracted? | 482 | 504 | 95.6% | |
| Average trip duration | 480 | 504 | 95.2% | |
| Homework 3: Data Warehousing | Count of records for the 2024 Yellow Taxi Data | 567 | 583 | 97.3% |
| Estimated amount of data | 522 | 583 | 89.5% | |
| Why are the estimated number of Bytes different? | 567 | 583 | 97.3% | |
| How many records have a fare_amount of 0? | 553 | 583 | 94.9% | |
| The best strategy to make an optimized table in Big Query | 569 | 583 | 97.6% | |
| Estimated processed bytes | 554 | 583 | 95.0% | |
| Where is the data for external tables stored? | 566 | 582 | 97.3% | |
| Always clustering | 545 | 582 | 93.6% | |
| Homework 4: Analytics Engineering | Model resolution | 226 | 456 | 49.6% |
| Change the query | 391 | 456 | 85.7% | |
| Lineage | 335 | 456 | 73.5% | |
| Macros and Jinja | 327 | 456 | 71.7% | |
| Taxi Quarterly Revenue Growth | 328 | 456 | 71.9% | |
| P97/P95/P90 Taxi Monthly Fare | 295 | 456 | 64.7% | |
| Top #Nth longest P90 travel time Location for FHV | 308 | 456 | 67.5% | |
| Homework 5: Batch | Size of partition | 381 | 408 | 93.4% |
| Number of trips | 388 | 408 | 95.1% | |
| Longest trip | 384 | 408 | 94.1% | |
| User Interface | 391 | 408 | 95.8% | |
| Least frequent pickup location zone | 379 | 408 | 92.9% |
Submission timing
When homework submissions arrive relative to the deadline, across all assignments.
- A week or more early
- 336 (8.5%)
- 3-7 days early
- 790 (19.9%)
- 1-3 days early
- 795 (20.0%)
- Final day
- 1086 (27.4%)
- After the deadline
- 960 (24.2%)
Engagement over time
Homework submissions per week, across all assignments. Bars are scaled to the busiest week.
- Jan 06, 2025
- 1
- Jan 13, 2025
- 138
- Jan 20, 2025
- 401
- Jan 27, 2025
- 813
- Feb 03, 2025
- 618
- Feb 10, 2025
- 765
- Feb 17, 2025
- 235
- Feb 24, 2025
- 426
- Mar 03, 2025
- 277
- Mar 10, 2025
- 124
- Mar 17, 2025
- 156
- Mar 24, 2025
- 13
Graduates
345 students completed the course and received certificates.