By: Ratnesh Srivastava

BIKE-SHARING ANALYSIS

Cyclistic

Where to contact me:�

08299073810

sratnesh101@gmail.com

Linkedin: www.linkedin.com/in/ratnesh-srivastava746

Source and the license

• The given dataset is an open dataset and can be downloaded through the given link:
• https://divvy-tripdata.s3.amazonaws.com/index.html

​

• License: https://ride.divvybikes.com/data-license-agreement

​

​

​

Details

A bike-share program that features more than 5,800 bicycles and 600 docking stations. Cyclistic sets itself apart by also offering reclining bikes, hand tricycles, and cargo bikes, making bike-share more inclusive to people with disabilities and riders who can’t use a standard two-wheeled bike. The majority of riders opt for traditional bikes; about 8% of riders use the assistive options. Cyclistic users are more likely to ride for leisure, but about 30% use them to commute to work each day.

Stakeholder’s Concern

The Company wants to increase the annual membership of the cycle riders. For that it is crucial to find the usage of the rental cycle broadly by the two groups i.e. casual riders and annual member riders.

Observations:

​

• On Saturday, this difference narrows the most, probably because the last day of the weekday.
• On Friday, total number of user surge is the most.

​

Observations:

​

• There is a sharp decline in the commute distance in both types of riders, hitting the steepest decline on Monday.
• Following Tuesday, there is a visible uptrend in the commute distance.

​

​

Observations:

From the pie chart as well as the bar graph, its quite clear and visible that member riders are more than their other counterparts, i.e. casual riders on the basis of 12 months analysis.

​

Observations:

• The graph denotes the twelve months starting from January.

​

• From July to August (7 to 9)there is a remarkable upsurge in the members usage regardless of there types i.e. members and casual.

​

Observations:

* Out of the three variety of bikes, the most popular ones are the docked bikes and after that the classic bikes.

• Its logical and visible that due to the convenience of docked bikes they are the most popular ones.
• Electric bikes are less preferred over classic counterpart, probably because they are easy to use without hassle.

Deductions

• As it is quite visible that the usage peaks on Friday, this day of the week would be the best for attracting the customers by giving them suitable subscriptions, especially to the casual riders.

​

• On Monday, since the commute distance plummets in both the sections, the reason can be the availability of the bikes due to which people are choosing other public transportation over the rental bikes. The solution to this is providing adequate docking facility near the subways and various work areas. To cope with the decline, lowering the price for this particular day can help battle the downfall.

​

• Beyond any shadow of doubt, the casual riders are low as compared to members. The reason could be unawareness about the convenience, price issues or the accesibilty. The company may choose to offer a promotional discount under which the money will be added to the bike-sharing mobile application’s wallet. This would create a snowball effect, as a casual user would use the wallet balance for another ride, hence spending more time riding the bike. This would nudge user to get comfortable using the bike.

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

​

• The classic bikes are more popular as compared to the electric bikes, probably because of the hassle-free usage. What needs to be done is making the electric bikes more accessible and simplifying their usage.

​

• A quick survey can be done on Friday as the usage surges the most on the day. The survey would help to get a direct feedback from the users regarding the necessary change to be made in the electric bikes to make them more convenient, as a reward giving the survey takes some app coins.

Deductions

The Five Why’s

Solution

Further possibility on the case study

• With more data regarding the users age, gender, disposable income and activity monitor(Strava, Garmin etc.) the analysis would be more comprehensive.

​

• If the data was furnished regarding the pricing structure, the analysis would be more concrete, as price itself is a big motivational factors behind the bike usage.

You

Thank