1 of 10

CYCLISTIC BIKE-SHARE ANALYSIS

BY- JAGRATI BIYANI

2 of 10

BUSINESS TASK

ANALYZE- How do annual members and casual riders use Cyclistic bikes differently?

TOOLS- EXCEL for cleaning, analysing and visualisation

DATASET- CYCLISTIC BIKE SHARE TRIP DATA FROM FEB 2021-JAN 2022

Converted all CSV files into EXCEL files and removed unused columns, made pivot tables, and pivot charts.

3 of 10

  • TRIP DURATION�Trip duration for casuals is 2.4 times more than member riders.

Average trip duration is at peak during the weekends for both members and casuals.

Average ride length peaks during spring months and summer and comes down during winters.

​

  • MEMBERS v/s CASUAL�Ratio of members is a bit higher than the casual riders over the year.

​

WHAT I FOUND FROM THE DATA

4 of 10

THOUGH THE NO. OF MEMBERS ARE HIGHER OVERALL THE CASUALS PEAK DURING JULY AT A MUCH HIGHER RATE

5 of 10

AVERAGE TRIP DURATION OR RIDE LENGTH ARE PEAK DURING SUMMERS IN MAY AND JUNE AND ALSO SHOW A HYPE DURING SPRING MONTHS AND THE DURATION COMES DOWN DURING WINTER MONTHS

6 of 10

AVERAGE TRIP DURATION ARE AT PEAK DURING WEEKENDS( SATURDAYS AND SUNDAYS), FOR BOTH THE MEMBERS AND CASUALS. AVERAGE TRIP DURATION IS HIGHER FOR CASUALS OVERALL THAN THE MEMBERS.

7 of 10

Meet Alberto.

He recently moved from Spain to a small town in Northern Ireland.

He loved soccer, but feared he had no way to talk to a coach or teammates.

NO. OF TRIPS FOR CASUALS ARE AT PEAK DURING WEEKENDS AND FOR MEMBERS IT IS DURING WEEKDAYS.

​

CONSIDERING, THE CASUALS ARE TOURISTS, STUDENTS, ETC. AND THE MEMBERS ARE MAINLY WORKERS AND EMPLOYEES.

8 of 10

CLASSIC BIKE IS THE MOST PREFERRED FOR BOTH THE MEMBERS AND CASUALS OVER THE ELECTRIC BIKES. DOCKED BIKES ARE MOSTLY USED BY CASUALS AS THE DOCKED BIKES ARE ALSO USED FOR RENTING PURPOSES FROM VARIOUS DOCK STATIONS.

Tip

If one example isn’t sufficient to help people understand the breadth of your idea, pick a couple of examples.

CASUALS v/s MEMBERS USING DIFFERENT TYPES OF BIKES

9 of 10

​

  • Members are higher in number but their ride length is shorter than that of casuals.
  • No. of riders start to increase from february to september due to seasonal changes and as winters arrive, the trip count comes down.
  • For casual riders the peak days are weekends and for members its weekdays, suggesting that the casuals are mainly the tourists and children while the members are employees.
  • Use of classic bikes is popular among both types.�

SUMMARY

10 of 10

​

  • Memberships cost during seasonal changes, i.e, during winters can be pulled down to increase the no. of trips and trip duration.�
  • As casuals peak at weekends, we can go for weekend memberships to increase conversion.�
  • Modification in membership subscription by reducing the cost as the ride length increases, which will give the existing members incentives to go for long drives!!!�

RECOMMENDATIONS