© 2026 Wangari Maina

GDAC Capstone Project

Bike Share Analysis – Key Findings
1 / 8

Bike Share Usage Analysis

Key Findings & Strategic Insights

Understanding usage patterns to drive membership conversion

User Base Composition

Members represent the foundation of the bike share system

86.9% Member Trips
13.1% Casual Trips
  • Strong subscription loyalty provides stable revenue base
  • Consistent usage patterns enable predictable capacity planning
  • Member dominance indicates successful retention strategies

Seasonal Usage Patterns

Clear seasonal variations with extreme casual rider volatility

2,827%

Increase in casual usage from Q1 to Q3

  • Q2-Q3 show peak usage across all rider types
  • Members maintain consistent usage year-round
  • Q1 2020 shows 50% decline due to COVID-19 impact
  • Seasonal swings create targeted engagement opportunities

Behavioral Differences by User Type

Distinct usage patterns reveal different motivations

70.6% Member Weekday Usage
50.5% Casual Weekend Usage
  • Members show distinct rush hour peaks (8 AM and 5 PM)
  • Casual users maintain consistent usage throughout the day
  • Clear commuter vs. leisure usage patterns

Trip Duration Analysis

Consistent differences reveal distinct usage purposes

12-16 Member Trip Minutes
36-95+ Casual Trip Minutes
  • Duration differences support commuter vs. leisure theory
  • Q4 2019 data excluded due to critical anomalies
  • Members show stable, efficient trip patterns
  • Data quality controls needed for operational tracking

Station Usage Patterns

Geographic usage reveals dual system serving different needs

Tourist Stations: Buckingham Fountain, Shedd Aquarium

Commuter Hubs: Burnham Harbor

  • Tourist stations attract more casual users
  • Commuter hubs dominated by members
  • Top 10 stations account for disproportionate share
  • Clear geographic segmentation by user type

Conversion Opportunities

Significant untapped potential for membership growth

140,856

Casual weekday trips showing “member-like” behavior

  • Only 13.1% casual trips indicate enormous growth potential
  • Peak summer engagement creates optimal conversion windows
  • Midday casual usage presents additional opportunities
  • Focus on conversion rather than new customer acquisition

Data Quality & Action Required

Critical operational insights for system integrity

Q4 2019 Anomaly:

53 hours average (casual) | 12.5 hours average (members)

  • Root cause: Operational issues with bike docking systems
  • Industry best practice: Filter trips exceeding 3-4 hours
  • Automated alert systems needed for extended trips
  • Operational review required to prevent future issues
Bike Share Analysis - Key Findings
1 / 8

Bike Share Usage Analysis

Key Findings & Strategic Insights

Understanding usage patterns to drive membership conversion

User Base Composition

Members represent the foundation of the bike share system

86.9% Member Trips
13.1% Casual Trips
  • Strong subscription loyalty provides stable revenue base
  • Consistent usage patterns enable predictable capacity planning
  • Member dominance indicates successful retention strategies

Seasonal Usage Patterns

Clear seasonal variations with extreme casual rider volatility

2,827%

Increase in casual usage from Q1 to Q3

  • Q2-Q3 show peak usage across all rider types
  • Members maintain consistent usage year-round
  • Q1 2020 shows 50% decline due to COVID-19 impact
  • Seasonal swings create targeted engagement opportunities

Behavioral Differences by User Type

Distinct usage patterns reveal different motivations

70.6% Member Weekday Usage
50.5% Casual Weekend Usage
  • Members show distinct rush hour peaks (8 AM and 5 PM)
  • Casual users maintain consistent usage throughout the day
  • Clear commuter vs. leisure usage patterns

Trip Duration Analysis

Consistent differences reveal distinct usage purposes

12-16 Member Trip Minutes
36-95+ Casual Trip Minutes
  • Duration differences support commuter vs. leisure theory
  • Q4 2019 data excluded due to critical anomalies
  • Members show stable, efficient trip patterns
  • Data quality controls needed for operational tracking

Station Usage Patterns

Geographic usage reveals dual system serving different needs

Tourist Stations: Buckingham Fountain, Shedd Aquarium

Commuter Hubs: Burnham Harbor

  • Tourist stations attract more casual users
  • Commuter hubs dominated by members
  • Top 10 stations account for disproportionate share
  • Clear geographic segmentation by user type

Conversion Opportunities

Significant untapped potential for membership growth

140,856

Casual weekday trips showing "member-like" behavior

  • Only 13.1% casual trips indicate enormous growth potential
  • Peak summer engagement creates optimal conversion windows
  • Midday casual usage presents additional opportunities
  • Focus on conversion rather than new customer acquisition

Data Quality & Action Required

Critical operational insights for system integrity

Q4 2019 Anomaly:

53 hours average (casual) | 12.5 hours average (members)

  • Root cause: Operational issues with bike docking systems
  • Industry best practice: Filter trips exceeding 3-4 hours
  • Automated alert systems needed for extended trips
  • Operational review required to prevent future issues

© 2026 Wangari Maina. Created with ❤ using WordPress and Kubio