Dataset: Cyclistic Rider Marketing Analysis

About this Dataset

Cyclistic Rider Marketing Analysis

The dataset is about a bike sharing company that is looking to increase its membership base. The company is Cyclistics. The dataset shows Cyclistic’s historical trip data to analyze and identify trends. I have downloaded the previous 12 months of Cyclistic trip data here. (Note: The datasets have a dierent name because Cyclistic is a fictional company. For the purposes of this case study, the datasets are appropriate and will enable you to understand the business questions. The data has been made available by Motivate International Inc. This is public data that i have used to explore how dierent customer types are using Cyclistic bikes. But note that data-privacy issues prohibit me from using riders’ personally identiable information. This means that I was not to connect pass purchases to credit card numbers to determine if casual riders live in the Cyclistic service area or if they have purchased multiple single passes.

Tables

Divvy Trips 2019 Q1

@kaggle.icanbe444_cyclistic_rider_marketing_analysis.divvy_trips_2019_q1

10.15 MB
365069 rows
12 columns


CREATE TABLE divvy_trips_2019_q1 (
  "trip_id" BIGINT,
  "start_time" TIMESTAMP,
  "end_time" TIMESTAMP,
  "bikeid" BIGINT,
  "tripduration" DOUBLE,
  "from_station_id" BIGINT,
  "from_station_name" VARCHAR,
  "to_station_id" BIGINT,
  "to_station_name" VARCHAR,
  "usertype" VARCHAR,
  "gender" VARCHAR,
  "birthyear" DOUBLE
);

Divvy Trips 2020 Q1

@kaggle.icanbe444_cyclistic_rider_marketing_analysis.divvy_trips_2020_q1

18.44 MB
426887 rows
13 columns


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