In this project, I demonstrated my ETL skills using GCP to analyze Uber data. I used Cloud Storage for data storage, Python for pre-processing, Compute Instance and Mage Data Pipeline for running scripts and data transformation, BigQuery for the database, and Looker Studio for data visualization. This enabled smooth data extraction, transformation, and loading, leading to valuable insights for decision-making.
![Screenshot 2023-11-20 at 1 25 32 PM](https://private-user-images.githubusercontent.com/64974464/284394691-9de19048-f6d9-4075-950e-cf87e808703e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQwMTI0NzMsIm5iZiI6MTcyNDAxMjE3MywicGF0aCI6Ii82NDk3NDQ2NC8yODQzOTQ2OTEtOWRlMTkwNDgtZjZkOS00MDc1LTk1MGUtY2Y4N2U4MDg3MDNlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MTglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODE4VDIwMTYxM1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTQzNjUwYmI1MTE1Y2FmOWRjOWJhYmZkOGQwZTg4MGVhZGEzMWFhYzE4ZWVlZWQ2N2Q5ZTVhMGNkOGJhMTgwZGYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.47z_L1W3ztjuTGdVnEZFotg2kuRmcjtkSD15cbDQDhc)
- Programing language: Python
- Google Cloud Storage
- Compute Engine (VM instances)
- BigQuery
- Looker Studio
- Data pipeline tool: mage.ai (open source project:https://github.com/mage-ai/mage-ai)
The TLC Trip Record Data for yellow and green taxis includes details such as pick-up and drop-off times, locations, trip distances, fares, rate types, payment methods, and passenger counts reported by the driver. (https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page)
![Screenshot 2023-11-20 at 6 00 08 PM](https://private-user-images.githubusercontent.com/64974464/284413730-66f8d289-83a5-488b-95f5-3bbc14dc025a.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQwMTI0NzMsIm5iZiI6MTcyNDAxMjE3MywicGF0aCI6Ii82NDk3NDQ2NC8yODQ0MTM3MzAtNjZmOGQyODktODNhNS00ODhiLTk1ZjUtM2JiYzE0ZGMwMjVhLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MTglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODE4VDIwMTYxM1omWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIyODJkZjRjMDRkNjE5NjM5NzE1MzBmN2M0NDJhYmUzYzgyZmVlODRmNTgwN2JiYTg5YmM0YjZmYjM1NWNkN2MmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.qWb7o5iHpB4XEHhZbPTX9AK6bv3nGtfZnjqbdhnTnzk)