About this Dataset

Cycle Ride Share

The bike ride share data shows behavioral data between subscription members and casual riders. The data was collected from Lyft Bikes and Scooters, LLC (“Bikeshare”) spreadsheet.

A Link to the code used for the analysis and visualization is below:
https://acidic-firefly-4be.notion.site/Cycle-Trip-Data-a7e75a8761bc4ccabf7c581715b012c8

Project Objective:

The main goal of this project is to analyze the differences in bike usage patterns between casual riders and annual members. This analysis will provide valuable insights to design data-driven marketing strategies to convert casual riders into annual members. By utilizing Cyclistic’s historical bike trip data, the project seeks to uncover key behavioral trends that will guide the development of targeted marketing campaigns. These campaigns will focus on increasing annual memberships, which are more profitable for the company compared to casual riders.

Data Analysis:
- This project centers on analyzing Cyclistic’s historical bike trip data, which includes details such as trip duration, start and end locations, and the type of pass used (casual or annual membership).
- The analysis will explore key differences between casual riders and annual members, focusing on factors like trip frequency, duration, popular stations, and preferred times of day or week for riding.
Marketing Strategy Development:

Insights from the data analysis will help the marketing team craft strategies to effectively target casual riders, especially through digital and social media campaigns.
The project will emphasize identifying optimal opportunities for seasonal promotions, localized marketing efforts, and targeted offers aimed at boosting conversions to annual memberships.

The Spreadsheet shown below is the final result
..

Tables

Year To Date Finished

@kaggle.hannizaher_cycle_ride_share.year_to_date_finished

118.54 MB
2602256 rows
13 columns


CREATE TABLE year_to_date_finished (
  "unnamed_0" BIGINT,
  "ride_id" VARCHAR,
  "rideable_type" VARCHAR,
  "started_at" TIMESTAMP,
  "ended_at" TIMESTAMP,
  "start_station_name" VARCHAR,
  "member_casual" VARCHAR,
  "ride_length" DOUBLE,
  "day_of_week" VARCHAR,
  "date" TIMESTAMP,
  "month" BIGINT,
  "day" BIGINT,
  "year" BIGINT
);