dimitribenevieri.com - Cyclisti Case Study

CYCLISTIC CASE STUDY

Google Data Analytics Professional Certificate

Capstone Project

For the completion of the Google Data Analytics Professional Certificate, I was asked to help a fictional bike sharing company based in Chicago to analyze the differences between casual riders and annual members in order to help the marketing director create a campaign to maximize the number of annual members.

The company, called Cyclistic, has thousand of sharing bikes that are geotracked and locked in a network of stations across Chicago. They can be unlocked from one station and returned to any other station in the system anytime.

Cyclistic has 3 pricing plans: single-ride passes, full-day passes and annual membership. Customers who purchase single-ride or full-day passes are reffered to as casual riders, insted customers who purchase annual memberships are Cyclistic members.

This was my first complete data analysis project and it was really interesting to put in action what I learned during the data analytics course.

Since the dataset was quite big, I decided to perform the steps of the data analysis process in Big Query because SQL was a better tool for managing a lot of data.

The cleaning part took me a little longer than I expected and I had to solve a couple of problems because I use the free version of Big Query (the sandbox version) but in the end I was satisfied enough of the result.

After cleaning and analyzing the data, I transfered the dataset on Tableau and began to create some graphs and visuals for better answering the question asked me.

In the end I made a presentation to show what I've found, with interesting conclusions and a few suggestions.

Video

Presentation

Cyclistic Bike-Share

note that the original presentation is in Powerpoint and not in Google Slides

Detailed Report

Report_v2.pdf

Page updated

Google Sites

Report abuse