Dataset: Cyclistic A Bike-share Company Of Chicago 2021

About this Dataset

Cyclistic A Bike-share Company Of Chicago 2021

As a junior data analyst working in the marketing analyst team at Cyclistic, I will work at a bike-share company in Chicago , with my team Ihave to understand how casual riders and annual members use Cyclistic bikes differently. From these insights, my team will design a new marketing strategy to convert casual riders into annual members. So I must be backed up with compelling data insights and professional data visualizations.

Tables

Dt 2021–05

@kaggle.luissanzetenea_bikeshare.dt_2021_05

25.97 MB
531633 rows
13 columns


CREATE TABLE dt_2021_05 (
  "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
);

Dt 2021–06

@kaggle.luissanzetenea_bikeshare.dt_2021_06

35.93 MB
729595 rows
13 columns


CREATE TABLE dt_2021_06 (
  "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
);

Dt 2021–07

@kaggle.luissanzetenea_bikeshare.dt_2021_07

39.71 MB
822410 rows
13 columns


CREATE TABLE dt_2021_07 (
  "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
);

Dt 2021–10

@kaggle.luissanzetenea_bikeshare.dt_2021_10

32.2 MB
631226 rows
13 columns


CREATE TABLE dt_2021_10 (
  "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
);

Dt 2021–11

@kaggle.luissanzetenea_bikeshare.dt_2021_11

19.25 MB
359978 rows
13 columns


CREATE TABLE dt_2021_11 (
  "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
);

Dt 2021–12

@kaggle.luissanzetenea_bikeshare.dt_2021_12

12.62 MB
247540 rows
13 columns


CREATE TABLE dt_2021_12 (
  "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
);