Dataset: Divvy Cyclistic (Dec'2020 - Mar'2021)

About this Dataset

Divvy Cyclistic (Dec'2020 - Mar'2021)

Context
The dataset is a part of Google data analytics course capstone project, to analyze how do annual members and casual riders use Cyclistic bikes differently? aiming to help the marketing team to design a new marketing strategy to convert casual riders into annual members.

Content
The dataset contains the rides data from Dec'2020 to Mar'2021.

Sourse
https://divvy-tripdata.s3.amazonaws.com/index.html

Tableau Data Viz.
https://public.tableau.com/app/profile/mohit.singh7485/viz/CaseStudyHowDoesaBike-ShareNavigateSpeedySuccess_16818602222800/Dashboard2

Power point Presentation
https://onedrive.live.com/edit.aspx?resid=17ABEB0904973A38!273&ithint=file%2cpptx&ct=1681947156980&wdOrigin=OFFICECOM-WEB.MAIN.EDGEWORTH&wdPreviousSessionSrc=HarmonyWeb&wdPreviousSession=f8c74bb3-bed0-44c2-a9cc-5fe8a39d6778

Tables

Trips Data202012–202103 Cyclistic Data

@kaggle.mohitsingh8057_cyclistic_data.trips_data202012_202103_cyclistic_data

6.29 MB
506087 rows
14 columns


CREATE TABLE trips_data202012_202103_cyclistic_data (
  "rideable_type" VARCHAR,
  "users" VARCHAR,
  "started_day" VARCHAR,
  "started_date" TIMESTAMP,
  "started_time" VARCHAR,
  "started_hour" BIGINT,
  "started_month" BIGINT,
  "ended_day" VARCHAR,
  "ended_date" TIMESTAMP,
  "ended_time" VARCHAR,
  "ended_hour" BIGINT,
  "ended_month" BIGINT,
  "ride_length" VARCHAR,
  "average_ride_length" VARCHAR
);