NYC Taxi Trips Report (2017 - 2018)

Title: NYC Taxi Trips Report (2017 - 2018)

Data Visualization Tool: Microsoft Excel, Power BI

Datasets Source: Quantum Analytics NG

The datasets contain a total of 28 million Green Taxi trips in New York City from 2017 to 2020. Each record represents one trip, with fields containing details about the pick-up/drop-off times and locations, distances, fares, passengers, and more. The raw data has some issues, so adjustments and proper cleaning were done using both Microsoft Excel and Power BI

Insights generated:

• Average Trips

• Average fare per trip

• Average fare per trip

• Busiest month

• Total Passenger moved

See live analysis here