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....

ISB, Systems Biology of Disease, Course

ISB Course: Systems Biology of Disease

About: I have been the Event Manager for ISB’s annual Systems Biology of Disease Summer Course since 2014, driving event strategy, technical production, and execution of the weeklong event. Interesting note: the use of R programming in this course is what sparked my interest in Data Analytics. The goal of the ISB summer course is to introduce the core concepts of systems biology and their application to systems biomedicine....

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....

Bellabeat Case Study with R by Joey Petosa

Bellabeat Case Study with R

Bellabeat is the go-to wellness brand for women with an ecosystem of products and services that focuses on women’s health. They empower women with knowledge about their own health and habits by collecting data on activity, sleep, stress, and reproductive health. In this case study, I analyze smart device fitness data that could help unlock new growth opportunities for the company. Joey’s Case Study Website: https://joeypetosa.github.io/bellabeat_cs/ Google Slides...