Baselight
Sign In

Cyclistic Case Study

Google Data Analytics Capstone Project

@kaggle.alexandria101_cyclistic_case_study

Loading...
Loading...

About this Dataset

Cyclistic Case Study

This case study was performed as part of the Google Data Analytics Course Capstone.
In this scenario, I am a junior analyst who is a part of the marketing analyst team at Cyclistic and we want to understand how to market to the riders in order to get casual riders to become annual members.

The company has two different types of customer base: Cyclistic members and casual riders. Casual riders can be defined as those who purchase single-ride passes or full-day passes. Customers who purchase annual memberships are Cyclistic members.

Annual members are more profitable than casual riders. Marketing to increase the number of annual members will be the key to maximizing profits and customer retention.

By having a clear task in place, my job is to analyze Cyclistic bike trip data to identify any trends.

Business Task:
How do annual members and casual riders use Cyclistic bikes differently?

Tables

N 202109 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202109_divvy_tripdata
  • 36.98 MB
  • 756147 rows
  • 13 columns
Loading... 

CREATE TABLE n_202109_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202110 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202110_divvy_tripdata
  • 32.2 MB
  • 631226 rows
  • 13 columns
Loading... 

CREATE TABLE n_202110_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202111 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202111_divvy_tripdata
  • 19.25 MB
  • 359978 rows
  • 13 columns
Loading... 

CREATE TABLE n_202111_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202112 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202112_divvy_tripdata
  • 12.62 MB
  • 247540 rows
  • 13 columns
Loading... 

CREATE TABLE n_202112_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202201 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202201_divvy_tripdata
  • 5.28 MB
  • 103770 rows
  • 13 columns
Loading... 

CREATE TABLE n_202201_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202202 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202202_divvy_tripdata
  • 5.83 MB
  • 115609 rows
  • 13 columns
Loading... 

CREATE TABLE n_202202_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202203 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202203_divvy_tripdata
  • 13.58 MB
  • 284042 rows
  • 13 columns
Loading... 

CREATE TABLE n_202203_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202204 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202204_divvy_tripdata
  • 17.81 MB
  • 371249 rows
  • 13 columns
Loading... 

CREATE TABLE n_202204_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202205 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202205_divvy_tripdata
  • 29.88 MB
  • 634858 rows
  • 13 columns
Loading... 

CREATE TABLE n_202205_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202206 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202206_divvy_tripdata
  • 35.78 MB
  • 769204 rows
  • 13 columns
Loading... 

CREATE TABLE n_202206_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202207 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202207_divvy_tripdata
  • 39.4 MB
  • 823488 rows
  • 13 columns
Loading... 

CREATE TABLE n_202207_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202208 Divvy Tripdata

@kaggle.alexandria101_cyclistic_case_study.n_202208_divvy_tripdata
  • 37.96 MB
  • 785932 rows
  • 13 columns
Loading... 

CREATE TABLE n_202208_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" VARCHAR,
  "end_station_name" VARCHAR,
  "end_station_id" VARCHAR,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

Share link

Anyone who has the link will be able to view this.