Uber-Data-Analytics | Python | Google Cloud Storage | Mage | ETL | Big Query | Looker

Problem Statment

Perform data analtyics on Uber Cab data and create dashboard with insights from the given dataset.

Technology Stack

• Programming Language - Python
• Google Cloud Platform
  • Google Storage
  • Compute Instance
  • BigQuery
  • Looker Studio
• Mage ETL Data Pipeine Tool - https://www.mage.ai/

Architecture Diagram

Dataset Used

TLC Trip Record Data Yellow and green taxi trip records include fields capturing pick-up and drop-off dates/times, pick-up and drop-off locations, trip distances, itemized fares, rate types, payment types, and driver-reported passenger counts.

More info about dataset can be found here:
Website - https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page
Data Dictionary - https://www.nyc.gov/assets/tlc/downloads/pdf/data_dictionary_trip_records_yellow.pdf

Data Model

Report - Looker Studio

Play with Dashboard!

https://lookerstudio.google.com/reporting/f327282a-ee3f-49f9-8e4f-76b6c2a5e301

Reference

Darshil Parmar