The goal of this project is to perform ETL and Data Analysis on Cab booking data with the help of Mage AI , MySQL and Looker Studio.
- Programming Language - Python
- Storage - Local Machine
- MySQL
- Looker Studio
- Dokcer
Modern Data Pipeine Tool - https://www.mage.ai/
Downloaded via the Docker installation and ran the Mage AI in a Docker Container
Default Mage Port : 6789
Default MySQL Port : 3306
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.
Dataset used : https://github.com/Atrij-Paul/Cab_DE_DA/blob/main/cab_data.csv
Data Analysis Report : https://github.com/Atrij-Paul/Cab_DE_DA/blob/main/Cab_Data_Analysis_Report.pdf