Modern stationary bicycles in gym with the Cyclistic logo

Cyclistic bike-share: a case study

This case study is my capstone submission to the Google Data Analytics Professional Certificate. Cyclistic is a fictional bike-share company operating in Chicago, US. To unlock growth, Cyclistic wants to launch a campaign to convert casual riders into subscribed members. This case study explores the different ways that casual riders and members use Cyclistic, and offers recommendations of actions that could be taken to encourage conversions. Case study Github repository

February 4, 2025 · 1 min
A group of household recyclable materials on a kitchen counter

The seven bins of St Helens

Are seven bins more effective than one? In this case study, I explore the answer to this question using public data on recycling rates by local authority in England. Tableau dashboard Github repository Situation Last week I took my son to visit my parents for the half-term break. They live in St Helens, a town in Merseyside, north-west England. One evening while I was there, the conversation turned to the new recycling bag that the council had just issued to every household in the borough. Despite our Prime Minister’s recent promise that he will never allow ‘seven bins’ per household, it seems that is exactly what St Helens Borough Council is doing. The new 70L green bag that my parents received brings their total household waste receptacle count to exactly seven: ...

November 3, 2023 · 5 min
Photo of a white Tesla Model 3 on the road

Tesla used prices

An interactive and dynamic dashboard that monitors UK Tesla inventory. The Tesla Model 3 dashboard allows users to monitor the current inventory of used Model 3 vehicles in the UK, view data on price, mileage and age, and create a shortlist of available vehicles matching specific criteria. Data is refreshed daily. Tableau dashboard Github repository The story The lease on my current car (a Renault Zoe) is set to end in January 2024. I have loved driving an electric car over the past two and a half years, and when my lease ends I know I want to continue driving electric. However, this time I want to buy rather than lease, and I want something different to a Zoe. ...

May 25, 2023 · 2 min