Todd Schneider has posted a thorough analysis of 1.1 Billion NYC Taxi and Uber Trips where he explores the city's neighbourhoods, night-life, airport traffic etc. You can replicated all that using publicly available data, R, PostgreSQL and PostGIS. GitHub repository here.
