Cyclistic Case Study Using Spreadsheets, SQL and Tableau by Joey Petosa

Cyclistic Case Study Using Spreadsheets, SQL and Tableau

In this case study, I analyze historical data from a Chicago based bike-share company in order to identify trends in how their customers use bikes differently. The main tools I use are spreadsheets, SQL and Tableau. Here are the highlights: Tableau Dashboard: Cyclistic Bikeshare in Chicago Slides: Where Rubber Meets Road in Converting Casual Riders to Cyclistic Members GitHub: Cyclistic Case Study Repository A more in-depth breakdown of the case study scenario is included below, followed by my full report....

Microbiome Series

ISB Virtual Microbiome Series

About: As Event Manager and Technical Director for ISB’s Virtual Microbiome Series, I led the event’s core organizing team, ran production operations, and was responsible for overall project management throughout the event’s lifecycle. 2021 ISB Virtual Microbiome Series 2020 ISB Virtual Microbiome Series Event Evolution During a Pandemic: “A crisis is a terrible thing to waste.” When ISB, along with the rest of the world, had to cancel all of our in-person events in 2020 due to the COVID-19 pandemic, I saw an opportunity to try something novel....

Technical Skills

Learning and applying new technical skills has been a major priority throughout my career. These technical skills help me take my work to the next level analytically, creatively and operationally. In fact, I built this website myself using RStudio, Blogdown, Hugo, GitHub, Netlify and AWS. Feel free to check out my website repository here. My technical skills are listed below. Google Data Analytics Professional Certificate: In order to strengthen my skills as a data analyst, I recently completed the 8-course Google Data Analytics Certificate offered by Coursera– a rigorous, hands-on program that covers the entire scope of the data analysis process....