Project 1 – NYC Taxi Trip Analysis Using BigQuery Public Datasets

📌 Topics Covered

• Querying large-scale NYC taxi datasets
• Aggregating trip volumes and fare distributions
• Hourly, monthly, and borough-level trend analysis
• Cost-aware querying with partition filters

📝 Project Summary
Learners will explore hundreds of millions of NYC taxi trip records in BigQuery. The project focuses on analyzing trip demand, fares, and peak times while learning best practices for large dataset querying. Results help understand fleet management needs and demand patterns with high-speed SQL queries.

✅ What You Will Learn

• Count trips and calculate average fares by hour
• Aggregate trip volume and revenue by pickup location
• Analyse trip distance distributions
• Compare monthly trip volumes year-over-year
• Apply cost-efficient querying techniques in BigQuery

Note to Students –

Live Classes will held on Google Meet.
Mentor will provide files, dataset in the Google Classroom.
Class video will be provided on Google Classroom.

Click “Mark as Complete” button.

Good Luck.