How COVID Affected Baywheels

COVID and Its Effects on Baywheels

My analysis on the Baywheels bikeshare program before and after the COVID pandemic and stay-at-home order in the Bay Area back in December 2023. You can see the presentation slides on Tableau Public.

A lot of work went into building my own PostgreSQL database from scratch on my own local machine. From there, I pushed the Baywheels data taken from their website into the database via Python and SQLalchemy. I had to modified the table schema because it was modified midway through the pandemic. Once all the data was fixed, I was then able to clean and manipulate the data. From there, I proceeded to connect my database into Tableau Desktop and then proceeded to create my dashboards and presentation.