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
Group of people putting fingers together to form a star shape

Build a multi-fact star schema in Tableau in 5 easy steps

I haven’t always used star schema data models in Tableau. In fact, up until around two years ago I had never heard of them. At that time, the company I was then working for made a decision to switch from Tableau to Power BI for its self-service business intelligence software. I jumped into a multitude of online learning resources for Power BI (in case you want a recommendation my favourites were the courses offered by Maven Analytics, available on their own platform or through Udemy), and soon discovered the importance of data modeling (and in particular the star schema) for Power BI. ...

October 18, 2022 · 4 min