Urban Mobility Data Analysis

Executed a comprehensive project utilizing ride data of an urban mobility service provider, with the primary objective of transforming raw data into a structured and optimized format. Commenced with data modeling in Python, crafting both data and fact tables to enhance data organization and accessibility. Implemented robust data pipelines to seamlessly upload the processed data to Google Cloud. Transferred the curated data to Google BigQuery, leveraging SQL to construct pertinent tables with the essential dataset. Utilized Google Looker Studio for the creation of impactful data visualizations, offering valuable insights and facilitating informed decision-making.