1 of 12

How Does a Bike-Share Navigate Speedy Success?

Cyclistic Case Study by �Michael Karanikolas

2 of 12

About Cyclistic…

  • Chicago-based bike-sharing company founded in 2016.
  • The company aims to increase annual memberships for greater profitability.
  • Tremendous growth since the company’s inception.

2

3 of 12

Business Task

3

To provide actionable insights for converting casual riders of Cyclistic into annual members.

A key driver for the company's profitability and sustainability.

4 of 12

Data Source and Relevance

  • The primary data source hails from a 12-month collection of trip records from Motivate International Inc.’s Divvy bike-sharing service based in Chicago.

​

  • This dataset includes details such as ride start and end times, the type of bicycle used, location coordinates, and membership classifications.

​

  • One must note: All data utilisation is in line with the terms of the Data License Agreement, ensuring no invasion of personal privacy.

4

5 of 12

Data Cleaning and Manipulation

Preliminary Data Refinement with Excel

  • In the initial phase, Microsoft Excel was used for preparing the data.

​

  • Two columns were introduced: 'ride_length' to illustrate the duration of each trip and 'day_of_week' to indicate the specific day of each ride.

​

​

.

6 of 12

Data Cleaning and Manipulation

  • Monthly data was grouped into one table for easier analysis.

​

  • Trips with unusual timings, like negative or zero, were removed to ensure accuracy.

​

  • Entries missing vital information were also deleted to maintain data quality.

​

6

Tidy Up using SQL

7 of 12

Casual riders often take longer trips, particularly from March to July.��Data suggests that bikes are possibly used for leisure by casual riders.

Initial findings revealed distinct differences between casual and regular riders.

7

What the Data Shows

8 of 12

What the Data Shows

  • The data showed a higher count of regular riders compared to casual ones.

​

  • An increase in casual ridership was noted from April to June, potentially due to the season.

​

  • This indicates opportunities for seasonal promotions.

8

9 of 12

Bike Choices and Ride Times

  • Graphs illustrated a preference for electric bikes among casual riders.

​

  • Ride durations for casual riders varied, whereas regular riders displayed consistent patterns.

9

10 of 12

When People �Usually Ride

​

​

​

​

​

​

​

​

  • Data indicated casual riders being more active on weekends, especially Saturdays.

​

  • Peak hours for casual riders were observed around 5 pm, while regular riders had varied peak times.

10

11 of 12

Top 3 Recommendations

11

12 of 12

Thank you for listening!

Questions…

12