Baselight
Sign In

Cyclistic Bike-Share - Motivate International Inc.

Data Discovery: A Beginner's Exploration into marketing strategies

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc

Loading...
Loading...

About this Dataset

Cyclistic Bike-Share - Motivate International Inc.

Welcome to my portfolio! In my recent project, I focused on designing marketing strategies for Cyclistic bikes, aiming to convert casual riders into annual members. Through analysis, I found that members and casual riders engage similarly, but peak usage differs drastically in summer. I proposed enticing casual riders with a season pass incentive. Leveraging digital media, I suggested captivating ads and influencer collaborations showcasing Cyclistic's adventurous side. This portfolio highlights my strategic approach and creative solutions to boost Cyclistic's user base by seamlessly transitioning casual riders into committed annual members.

Feel free to provide feedback on my code or any suggestions. This is my first project, and I'm eager to learn and enhance my skills.

Tables

N 202004 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202004_divvy_tripdata
  • 4.08 MB
  • 84,776 rows
  • 13 columns
Loading... 
CREATE TABLE n_202004_divvy_tripdata (
  "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
);

N 202005 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202005_divvy_tripdata
  • 9.2 MB
  • 200,274 rows
  • 13 columns
Loading... 
CREATE TABLE n_202005_divvy_tripdata (
  "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
);

N 202006 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202006_divvy_tripdata
  • 15.51 MB
  • 343,005 rows
  • 13 columns
Loading... 
CREATE TABLE n_202006_divvy_tripdata (
  "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
);

N 202007 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202007_divvy_tripdata
  • 25.64 MB
  • 551,480 rows
  • 13 columns
Loading... 
CREATE TABLE n_202007_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202008 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202008_divvy_tripdata
  • 31.48 MB
  • 622,361 rows
  • 13 columns
Loading... 
CREATE TABLE n_202008_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202009 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202009_divvy_tripdata
  • 28.95 MB
  • 532,958 rows
  • 13 columns
Loading... 
CREATE TABLE n_202009_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202010 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202010_divvy_tripdata
  • 22.14 MB
  • 388,653 rows
  • 13 columns
Loading... 
CREATE TABLE n_202010_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202011 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202011_divvy_tripdata
  • 14.95 MB
  • 259,716 rows
  • 13 columns
Loading... 
CREATE TABLE n_202011_divvy_tripdata (
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "start_station_id" DOUBLE,
  "end_station_name" VARCHAR,
  "end_station_id" DOUBLE,
  "start_lat" DOUBLE,
  "start_lng" DOUBLE,
  "end_lat" DOUBLE,
  "end_lng" DOUBLE,
  "member_casual" VARCHAR
);

N 202012 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202012_divvy_tripdata
  • 7.25 MB
  • 131,573 rows
  • 13 columns
Loading... 
CREATE TABLE n_202012_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 202101 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202101_divvy_tripdata
  • 5.45 MB
  • 96,834 rows
  • 13 columns
Loading... 
CREATE TABLE n_202101_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 202102 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202102_divvy_tripdata
  • 2.77 MB
  • 49,622 rows
  • 13 columns
Loading... 
CREATE TABLE n_202102_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 202103 Divvy Tripdata

@kaggle.hien97_cyclistic_bike_share_motivate_international_inc.n_202103_divvy_tripdata
  • 11.59 MB
  • 228,496 rows
  • 13 columns
Loading... 
CREATE TABLE n_202103_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.