Baselight

Divvy Trips Sample Dataset

Bike-Share Case Study: Using Customer Data to Guide Business Strategy

@kaggle.odesanyawasiu_divvy_trips_sample_dataset

Loading...
Loading...

About this Dataset

Divvy Trips Sample Dataset

These datasets, Divvy_2019_Q1_csv_version and Divvy_2020_Q1_csv_version, respectively, have been made available by Motive International Inc. under a Bikeshare license.

The datasets support a real-world case study aimed at understanding how different types of riders (casual and annual members) use Chicago’s Divvy bike-share system. The project focuses on identifying usage patterns, uncovering behavioral insights, and developing data-informed strategies to increase annual memberships.

It was used in a portfolio project that simulates a business scenario where the marketing team is tasked with converting casual riders into annual members by leveraging trip data, seasonality, and ride duration trends.

The analysis includes:
User segmentation based on ride behavior
Time-based trend analysis
Ride duration and frequency comparison
Recommendations for customer acquisition and retention

This dataset and case study showcase practical skills in:
Exploratory Data Analysis
Data wrangling and cleaning
Data visualization (ggplot2)
Business storytelling and insight communication

Tables

Divvy Trips 2019 Q1 Version

@kaggle.odesanyawasiu_divvy_trips_sample_dataset.divvy_trips_2019_q1_version
  • 8.43 MB
  • 365069 rows
  • 14 columns
Loading...

CREATE TABLE divvy_trips_2019_q1_version (
  "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,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

Divvy Trips 2020 Q1 Version

@kaggle.odesanyawasiu_divvy_trips_sample_dataset.divvy_trips_2020_q1_version
  • 16.16 MB
  • 426887 rows
  • 15 columns
Loading...

CREATE TABLE divvy_trips_2020_q1_version (
  "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,
  "ride_length" VARCHAR,
  "day_of_week" BIGINT
);

Share link

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