Dashboard Day 5 - New York Taxis

Today began with a brief instructing us to download data from Uber and present a dashboard on the difference in demand due to Covid. The process of accessing the data was quite difficult for me to understand so I went to one of our coaches (Robbin) who patiently went through the process with me and helped me to build up a very good scope. I re-entered the meeting room where the rest of my cohort was, feeling very happy and ready to build a great dashboard. I was then informed that the brief had changed entirely and we were now looking at building a dashboard on Taxi trips instead. Guess the coaches didn't want to make the last day of training too easy...

So I went back to the drawing board. Figuring out how to convert a Parquet file to a csv was the first big struggle, but with some help from the cohort and Chat GPT we managed. We then decided on a scope of only looking at the impact of surcharge rates on demand.

Next we put together a sketch. I'd originally thought surcharges varied by time, which had guided the thought process in my sketch. I later however found out this wasn't the case and that they varied by location only. Thus some of what we'd planned had to be scrapped.

I took to Alteryx to get the data into a useable format and calculate some metrics. Nadia (my teammate) went straight into Tableau and started building. At this point we only had an hour and a half to build so we were very pressured for time.

Although our final product is quite short, I'm very happy with the scoping we did and think we've found some interesting insights.

Author:
Asha Daniels
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab