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

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

ISB, Sleeping Lady Resort, Annual Retreat

ISB Annual Retreat

About: I have been the Event Manager for ISB’s organizational offsite retreat for the past eight years, leading in development, production, and execution of the annual 160 person two day event. In 2014, I researched and visited venues across Washington State, presented my findings to ISB leadership, and orchestrated a radical move of the retreat from it’s long-time homes in the Hood Canal and Olympic Peninsula to Sleeping Lady Resort in Leavenworth, WA....

LH80

Visions of the Future

About: A symposium and party held in 2018 in honor of Dr. Lee Hood’s 80th birthday. Dr. Hood, a pioneer in the field of biotechnology and recipient of the National Medal of Science in 2011, is co-founder and chief strategy officer of ISB. Event Website Event Summary Symposium Videos (YouTube) As Event Manager, my scope included budget and stakeholder management, overall project management, vendor selection and negotiation, cross-functional collaboration with Communication, Development, Leadership and Scientific groups within ISB to ensure successful execution of event program....

ISB, Town Hall Seattle, Microbiome

The promise of the human microbiome

About: The public extension of ISB’s 2021 Virtual Microbiome Series. The goal of this event was to raise awareness about an exciting field of research. More about the event and program here: Dr. Jack Gilbert on the State of the Microbiome Field. ISB and Town Hall Seattle have put on a number of virtual events focusing on a range of important scientific issues. As Event Manager, my responsibilities included talent booking, logistical production, speaker advancement and livestream execution....

November 4, 2021
ISB, Town Hall Seattle, Aging

Health Span, Life Span, and the New Science of Longevity

About: A fireside chat between longevity and aging researcher Dr. Nir Barzilai and ISB Co-founder and Professor Dr. Lee Hood. More about the event and program here: Nir Barzilai on Health Span, Life Span and the New Science of Longevity. ISB and Town Hall Seattle have put on a number of virtual events focusing on a range of important scientific issues. As Event Manager, my responsibilities included talent booking, logistical production, speaker advancement and livestream execution....

September 30, 2021
ISB, Town Hall Seattle, The Outdoor Scientist

The Outdoor Scientist: The Wonder of Observing the Natural World

About: Dr. Temple Grandin was the keynote speaker in this iteration of the ISB-Town Hall Seattle Science Series. Grandin discussed her book – “The Outdoor Scientist: The Wonder of Observing the Natural World” – and a variety of other topics. ISB President Dr. Jim Heath joined at the end of her talk for a wide ranging Q&A discussion. More about the event and program here: Dr. Temple Grandin and the Importance of Getting Kids Outside....

June 10, 2021
ISB, Town Hall Seattle, Aging

Why We Age—And Why We Don’t Have To

About: A fireside chat between Harvard Medical School professor and New York Times bestselling author Dr. David Sinclair and ISB Co-founder and Professor Dr. Lee Hood. Their wide ranging discussion covered the very latest in aging research. More about the event and program here: David Sinclair On Why We Age — And Why We Don’t Have To. ISB and Town Hall Seattle have put on a number of virtual events focusing on a range of important scientific issues....

April 15, 2021
ISB, Town Hall Seattle, Healthcare Post-COVID

How Will Healthcare Be Different After COVID?

About: A fireside chat between Providence President and CEO Dr. Rod Hochman and ISB President and Professor Dr. Jim Heath. Their hour-long discussion explored how healthcare and science will be different after COVID-19. More about the event and program here: How Will Healthcare and Scientific Research Be Different in a Post-Pandemic World?. ISB and Town Hall Seattle have put on a number of virtual events focusing on a range of important scientific issues....

January 22, 2021