Connect with me on: - LinkedIn LinkedIn - GitHub GitHub

1 Welcome to my Kaggle Notebook!

Please have a look at the Kaggle Notebook HERE for code and other details. Please feel free to fork or customize this notebook to suit your needs. If you found it helpful, please consider upvoting. Your support helps others to discover this notebook and motivates me to undertake similar projects in the future. Special thanks to the amazing Kagglers whose work inspired this notebook!

2 Introduction

Welcome to the analysis of Cyclistic’s bike-share program in Chicago! It is our mission to contribute valuable insights that will drive the company’s future success. The director of marketing believes that maximizing annual memberships is crucial for growth. To achieve this goal, we aim to understand the distinct behaviors of casual riders (Customers who purchase single-ride or full-day passes are referred to as casual riders) and annual members. By analyzing Cyclistic’s historical bike trip data, we aim to uncover trends that inform a new marketing strategy focused on converting casual riders into loyal annual members. Armed with compelling data insights and professional visualizations, our recommendations will be poised to secure approval from Cyclistic’s detail-oriented executive team. With a majority of users opting for leisure rides and around 30% commuting daily, Cyclistic has become an integral part of Chicago’s urban mobility. With over 5,800 bicycles and various assistive options, Cyclistic’s offerings make bike-share more inclusive, attracting users for both leisure rides and daily commutes. Let’s dive in and discover how data can drive success for Cyclistic!

Photo by Nick Sokolov on Unsplash

3 About

The data can be accessed from Divvy bicycle through this LINK, and is subjected to the license provided HERE. Our data analysis will adhere to the following phases: Ask, Prepare, Process, Analyze, Share and Act, ensuring a structured approach to our analysis.

Company Overview: Cyclistic operates as a bike-sharing service in Chicago, offering a diverse fleet of bicycles for public use throughout the city. Their subscription-based model caters to both casual riders and annual members, with a commitment to providing inclusive and accessible transportation options for all.

Data Scope: Company’s dataset comprises of a year’s worth of trip records sourced from Cyclistic’s archives, shedding light on usage patterns among casual riders and annual members. Key variables include trip start and end times, station details, rideable types, and user classifications.

Problem at Hand (Business Task): The objective is to discern usage disparities between casual riders and annual members, aiming to craft a marketing strategy that encourages casual users to transition into annual membership status. The primary task is to analyze Cyclistic’s historical trip data, identifying distinct usage patterns between casual riders and annual members. These insights will inform the development of a targeted marketing strategy focused on converting casual riders into long-term members.

4 Ask

Guiding questions:

What is the problem you are trying to solve? The main problem we are addressing is understanding the usage disparities between casual riders and annual members of Cyclistic’s bike-sharing service. This understanding will help in formulating a targeted marketing strategy aimed at converting casual users into long-term members.

How can your insights drive business decisions? The insights derived from analyzing Cyclistic’s historical trip data will provide valuable information on how casual riders and annual members utilize the bike-sharing service differently. These insights can drive strategic business decisions by informing the development of a focused marketing campaign tailored to encourage casual users to transition into annual membership status. By understanding the behaviors and preferences of both user segments, Cyclistic can optimize its marketing efforts to increase annual memberships and improve overall business performance.

Key tasks:

Identify the primary business task: Understanding usage disparities between casual riders and annual members to formulate a targeted marketing strategy aimed at converting casual users into long-term members.

Stakeholders:

1. Lily Moreno leads the marketing department, spearheading campaigns to bolster the bike-sharing program’s visibility.
2. The Cyclistic marketing analytics team conducts data collection, analysis, and reporting to inform strategic decisions.
3. Cyclistic’s executive team holds the authority to approve proposed marketing initiatives, ensuring alignment with overarching goals and objectives.

Deliverable:

A clear statement of the business task: Analyze Cyclistic’s historical trip data to discern usage patterns between casual riders and annual members, with the aim of developing a focused marketing campaign to encourage casual users to transition into annual membership status.

5 Prepare

Guiding questions:

Where is your data located? How is the data organized?
Data Location and Organization: The data can be accessed from Divvy bicycle through this LINK. It represents the historical trip data of Cyclistic bikes and is organized into separate CSV files, each covering a month’s worth of rides. The data includes details such as trip duration, start and end times, station information, bike type, and user type (casual or annual member).

Are there issues with bias or credibility in this data? Does your data ROCCC (reliable, original, comprehensive, current and cited)?
Data Bias and Credibility: While the data is provided by the bike-sharing service company itself, it’s important to recognize potential biases that may arise from operational constraints or data collection methods. However, it meets the criteria of ROCCC (reliable, original, comprehensive, current, and cited) and is considered credible for analysis.

How are you addressing licensing, privacy, security, and accessibility?
Licensing, Privacy, Security, and Accessibility: The data is subjected to the license provided HERE. The data is made available under a specific license that permits its use for analysis. It preserves privacy by excluding personally identifiable information and is stored securely.

How did you verify the data’s integrity?
Data Integrity: The integrity of the data will be verified through exploratory data analysis (EDA) to identify and address any inconsistencies (i.e., missing values, outliers, or duplicate entries). The files exhibit consistent columns and data types across different time periods.

Data Relevance to the Business Question: The dataset provides valuable insights into the usage patterns of Cyclistic bikes by both casual riders and annual members, directly addressing the business question of understanding user behavior differences. Analysis of the data will inform the development of a marketing strategy aimed at converting casual riders into annual members.

Potential Problems: Potential issues with the data may include missing or erroneous entries, as well as bias introduced by the sampling method. Additionally, the dataset might lack certain information, such as demographic details of riders, which could be useful for analysis. Updating information about bike stations and gathering more details about riders could enhance the analysis.

Key tasks

Download the data and store it appropriately: Initially, the data was stored locally for RMarkdown creation and later uploaded to Kaggle before running and publishing the final notebook.

Identify how it’s organized: The data is structured into CSV files. CSV files (12 files) from last one year (2023-01-01 to 2023-12-31) were downloaded into the data folder and merged into one single file. First six rows of the data used for the analysis is shown in the table 5.1. Verify whether the columns are correctly interpreted for their data type. Utilize the str() function for this purpose. If the data is not recognized in the correct format, convert it using functions such as as.character(), as.numeric(), as.Date(), etc.

Table 5.1: First six rows of the data.

ride_id

rideable_type

started_at

ended_at

start_station_name

start_station_id

end_station_name

end_station_id

start_lat

start_lng

end_lat

end_lng

member_casual

F96D5A74A3E41399

electric_bike

2023-01-21 20:05:42

2023-01-21 20:16:33

Lincoln Ave & Fullerton Ave

TA1309000058

Hampden Ct & Diversey Ave

202480.0

41.92

-87.65

41.93

-87.64

member

13CB7EB698CEDB88

classic_bike

2023-01-10 15:37:36

2023-01-10 15:46:05

Kimbark Ave & 53rd St

TA1309000037

Greenwood Ave & 47th St

TA1308000002

41.80

-87.59

41.81

-87.60

member

BD88A2E670661CE5

electric_bike

2023-01-02 07:51:57

2023-01-02 08:05:11

Western Ave & Lunt Ave

RP-005

Valli Produce - Evanston Plaza

599

42.01

-87.69

42.04

-87.70

casual

C90792D034FED968

classic_bike

2023-01-22 10:52:58

2023-01-22 11:01:44

Kimbark Ave & 53rd St

TA1309000037

Greenwood Ave & 47th St

TA1308000002

41.80

-87.59

41.81

-87.60

member

3397017529188E8A

classic_bike

2023-01-12 13:58:01

2023-01-12 14:13:20

Kimbark Ave & 53rd St

TA1309000037

Greenwood Ave & 47th St

TA1308000002

41.80

-87.59

41.81

-87.60

member

58E68156DAE3E311

electric_bike

2023-01-31 07:18:03

2023-01-31 07:21:16

Lakeview Ave & Fullerton Pkwy

TA1309000019

Hampden Ct & Diversey Ave

202480.0

41.93

-87.64

41.93

-87.64

member

Sort and filter the data: Explore the dataset to grasp its structure and the meaning of each column. The table 5.2 contains a description of the dataset columns. Updated missing data for start_station_name, start_station_id, end_station_name, and end_station_id to be labeled as “unknown”. Filtering involves removing data where the start time exceeds the end time and eliminating rows with missing values using drop_na(). Dropping rows with missing values isn’t always advisable; there are alternative methods for handling them. Given the abundance of data in terms of row count, we’re opting to simplify here by removing them in this instance. No duplicates were identified using filtered_data_1 %>% group_by(ride_id) %>% filter(n()>1) on the ride_id column. In case duplicates are present in the data, they can be removed using filtered_data_1 = filtered_data_1[!duplicated(filtered_data_1$ride_id), ].

Table 5.2: Description of columns in the dataset

Column

Details

ride_id

Unique IDs for every ride

rideable_type

Type of bike, electric, classic or docked

started_at

Started ride time

ended_at

Ended ride time

start_station_name

Name of ride starting station

start_station_id

ID of starting station

end_station_name

Name of ride ending station

end_station_id

ID of ending station

start_lat

Starting latitude

start_lng

Starting longitude

end_lat

Ending latitude

end_lng

Ending longitude

member_casual

Membership type

Determine the credibility of the data: The data provided for this work comes from a reputable source, ensuring its credibility. However, it’s essential to consider other factors like ROCCC (reliable, original, comprehensive, current, and cited) when assessing data credibility.

Deliverable

A description of all data sources used: The main data source consists of riding data spanning 12 months, from January to December 2023, provided by Cyclistic company. Filtering has been applied to remove duplicates, rows with missing data, and instances where the start time exceeds the end time.

6 Process

Guiding questions:

What tools are you choosing and why? Tools: I choose R, RMarkdown, and multiple libraries such as tidyverse, and flextable for data analysis. R provides a comprehensive environment for statistical computing and graphics, while RMarkdown allows for seamless integration of code, results, and narrative in a single document. The tidyverse package offers a suite of tools for data manipulation and visualization, streamlining the analysis process. Additionally, flextable provides flexibility in creating and formatting tables, enhancing the presentation of analytical results. These tools collectively enable efficient and reproducible data analysis workflows.

Have you ensured your data’s integrity? Data integrity: This is dealt with before in the previous sections Determine the credibility of the data and Data Bias and Credibility.

What steps have you taken to ensure that your data is clean? Data Cleaning: To ensure that the data is clean, several steps were taken as outlined in the section Sort and filter the data. Firstly, the str() function was used to verify if the data types in the columns are read correctly. Additionally, adjustments were made to the data by adding new columns based on calculations of existing columns. These new columns were designed to facilitate the analysis and derive more insightful conclusions. For example, new columns were added to calculate time differences between rides, determine the day of the week, hour, month, and year of each ride, as well as calculated distances. These steps contribute to enhancing the quality and usability of the dataset for the analysis.

How can you verify that your data is clean and ready to analyze? Data is clean was ensured for analysis by visualizing missing data both before and after removing NAs (See Figure 6.1). Detailed information can be found in the Data Cleaning and Sort and Filter Data sections.

Number of missing values before and after NA removal. **A**. Before removing NA, **B**. After removing NA

Figure 6.1: Number of missing values before and after NA removal. A. Before removing NA, B. After removing NA

Have you documented your cleaning process so you can review and share those results? Data Cleaning Steps:

  1. Verified data types using str().
  2. Updated missing data for start_station_name, start_station_id, end_station_name, and end_station_id to be labeled as unknown
  3. Eliminated rows with missing values using drop_na().
  4. Filtered out rows where the end time is before the start time using filter(ended_at > started_at).
  5. Introduced new columns to:
  1. Filtered rows with trip duration greater than 24 hours
  2. Three rows with end_lat and end_lng as 0 were removed.
  3. since most of the trip duration are less than 100 minutes, rows with trip duration greater than 100 minutes were removed (< 0.86% of the data)
  4. Code used:
# Adding new columns

filtered_data_2 =
  filtered_data_1 %>% 
  mutate(trip_duration_difftime = difftime(filtered_data_1$ended_at, filtered_data_1$started_at, 
                                           units = "mins"), 
         # trip_duration_minutes = 
         #   as.numeric(filtered_data_1$ended_at - filtered_data_1$started_at)/60, 
         starting_hour = strftime(filtered_data_1$ended_at, "%H"), # starting hour
         weekday = strftime(filtered_data_1$ended_at, "%a"), # weekday
         # mutate(weekday = weekdays(filtered_data_1$ended_at))
         month = strftime(filtered_data_1$ended_at, "%b"), # month
         day_of_month = strftime(filtered_data_1$ended_at, "%d")) %>% # day of the month  
  filter(trip_duration_difftime <= 100) %>% #removed trips > 100 minutes 
  filter(end_lat > 40, end_lng < -85) # removed end_lat and end_lng as 0
  1. Newly created variables were tested for integrity by plotting (see Figure 6.2).
Number of missing values before and after NA removal. **A**. Distribution of trip_duration, **B**. Distribution of startng_hour, **C**. Distribution of weekday, **D**. Distribution of day_of_month, **E**. Distribution of month, **F**. Percent distribution of Casual users and Members

Figure 6.2: Number of missing values before and after NA removal. A. Distribution of trip_duration, B. Distribution of startng_hour, C. Distribution of weekday, D. Distribution of day_of_month, E. Distribution of month, F. Percent distribution of Casual users and Members

7 Analyze

Guiding questions

How should you organize your data to perform analysis on it? Has your data been properly formatted? To perform analysis on the data, it is important to organize it in a structured and accessible manner. This involves formatting the data appropriately, ensuring consistency across variables, and creating a unified view of the dataset. In this case, the data has been organized into a single CSV file by concatenating all the files from the dataset. Additionally, all columns have been assigned their correct data types, indicating that the data has been properly formatted. Therefore, the data is organized effectively and has been checked to ensure that each column has the proper data type. Any inconsistencies were addressed through appropriate data formatting techniques.

What surprises did you discover in the data? During the descriptive analysis, several surprises emerged from the data, shedding light on unexpected patterns and trends. One notable finding was the distinct differences observed between members and casual riders when analyzing weekday usage. There was a positive correlation (Figure 7.2) between the member_casual and weekday, which requires further analysis of categorizing weekday data into weekday and weekend to understand the difference between members and casual riders. There was also negative correlation between member_casual and rideable_type indicating differences in the preferences between these two groups. Additionally, contrary to expectations, it was surprising to discover that members exhibit less riding time compared to casual riders. These unexpected insights highlight the importance of thorough data analysis in uncovering valuable information that may not be initially apparent.

What trends or relationships did you find in the data? Several trends and relationships within the data were identified. Firstly, members tend to take more rides for a longer trip duration compared to casual bike riders. Additionally, the number of rides by members is higher throughout most hours of the day compared to casual riders, with minimal differences during off-peak hours, potentially due to limited availability of other modes of public transport. On weekends, especially Saturdays, there is a higher number of casual riders compared to the rest of the week. Trends for both member types remain consistent across any day of the month and throughout the year. The dataset contains more members compared to casual riders. Despite being relatively low, membership type exhibits the highest positive correlation with the weekday and the highest negative correlation with the type of bike, indicating some preferential differences between member types that warrant further investigation. Lastly, the persona of the casual rider appears to be more spontaneous, as evidenced by off-peak usage of bikes and increased usage on weekends compared to more regular members, suggesting they may be tourists or individuals seeking leisure activities.

How will these insights help answer your business questions? These insights will significantly contribute to answering our main business question regarding how casual riders and annual members utilize Cyclistic bikes differently. By understanding the distinct trends and behaviors between these two user groups, we can tailor our marketing strategies, service offerings, and operational decisions to better meet their needs. For example, knowing that members tend to take longer rides and utilize bikes more consistently throughout the day can help us optimize bike availability and station placements. Additionally, recognizing the higher demand for casual riders on weekends can guide promotional efforts and pricing strategies aimed at attracting this segment during peak times. Overall, these insights provide valuable guidance for enhancing customer satisfaction, increasing ridership, and maximizing the overall success of Cyclistic.

Key tasks

Aggregate your data for usability and accessibility. The data has been aggregated, organized, and formatted according to the procedures outlined in the previous sections titled Data Cleaning and Organize and format your data. A summary of the aggregated data is provided in tables (Tables 7.1 to 7.4).

Organize and format your data. In the Data Cleaning Steps section, various cleaning and organization steps were described. Specifically, the columns rideable_type, start_station_id, end_station_id, member_casual, starting_hour, weekday, month, and day_of_month were selected to create the correlation matrix (Figure 7.2).

Perform calculations. Several plots were generated to gain insights into the data (Figure 7.1). Plots were created for rideable_type, start_station_id, end_station_id, starting_hour, weekday, month, and day_of_month, plotting membership type member_casual.

Difference between _Casual Riders_ and _Members_ across different veriable. **A**. Distribution of trip_duration, **B**. Distribution of startng_hour, **C**. Distribution of weekday, **D**. Distribution of day_of_month, **E**. Distribution of month, **F**. Type of bike.

Figure 7.1: Difference between Casual Riders and Members across different veriable. A. Distribution of trip_duration, B. Distribution of startng_hour, C. Distribution of weekday, D. Distribution of day_of_month, E. Distribution of month, F. Type of bike.

Categorical variables were transformed into factors and then into a matrix before computing the correlation matrix using the following code. A correlation matrix was produced to assess the relationship between these columns and the membership type member_casual (Figure 7.2).

filtered_data_2 %>% 
  select(rideable_type, start_station_id, end_station_id, member_casual,
         starting_hour, weekday, month, day_of_month) %>% 
  mutate_if(is.character,as.factor) %>% 
  mutate(across(everything(), ~dense_rank(.))) %>% 
  cor(use="pairwise.complete.obs") %>% 
  ggcorrplot(show.diag=FALSE, type="lower", lab=TRUE, lab_size=5) +
  theme(panel.grid.major = element_line(size = 0.5, color = "white"),
        panel.grid.minor = element_line(size = 0.5, color = "white"),
        plot.title = element_text(hjust = 0.5),
        axis.line = element_line(size = 0.7, color = "black"),
        text = element_text(size = 18), 
        axis.text = element_text(angle=0, vjust=0.5, size=22, face = "bold"), 
        axis.text.x = element_text(angle = 45, hjust = 1), 
        # panel.background = element_rect(fill = "white",
        #                                 size = 0.5, linetype = "solid"), 
        axis.ticks = element_line(size = 0.5, colour = "black"), 
        # legend.position = "bottom", # c(0.8, 1.0),
        legend.text = element_text(size=rel(0.8)))
Correlation matrix between different variables, to understand the effect of variables on membership type.

Figure 7.2: Correlation matrix between different variables, to understand the effect of variables on membership type.

Identify trends and relationships.

Numerous patterns and connections within the data were uncovered, as outlined below:

  1. Generally, the number of rides for member trip duration exceeds those of casual bike riders (Figure 7.1A).

  2. Members tend to ride more frequently throughout most hours of the day compared to casual riders. However, during off-peak hours (between 02:00 and 04:00), the disparity is minimal, possibly due to limited availability of alternative modes of transportation, prompting more casual riders to utilize bikes (Figure 7.1B and Table 7.1).

Table 7.1: Summary data for hour of the day (starting_hour).

starting_hour

number_of_rides

avg_ride_duration

percentage

member_pct

casual_pct

member_casual_pct_diff

00

156,772

13.48

2.77

56.06

43.94

12.12

01

109,831

13.81

1.94

52.26

47.74

4.52

02

73,598

13.35

1.30

48.45

51.55

-3.10

03

44,895

13.59

0.79

46.22

53.78

-7.55

04

28,110

14.01

0.50

44.13

55.87

-11.74

05

17,054

13.32

0.30

50.57

49.43

1.14

06

21,032

10.25

0.37

65.75

34.25

31.50

07

57,948

8.53

1.02

78.17

21.83

56.33

08

143,329

9.20

2.53

79.54

20.46

59.09

09

245,544

10.12

4.34

79.55

20.45

59.09

10

291,864

10.85

5.15

77.50

22.50

54.99

11

230,661

11.56

4.07

72.13

27.87

44.25

12

229,948

12.63

4.06

66.08

33.92

32.17

13

276,709

13.41

4.89

63.62

36.38

27.23

14

320,265

14.10

5.66

61.64

38.36

23.29

15

331,707

14.62

5.86

60.15

39.85

20.31

16

347,728

14.59

6.14

60.05

39.95

20.11

17

407,231

14.13

7.19

62.04

37.96

24.08

18

500,164

13.72

8.83

64.82

35.18

29.64

19

553,710

13.80

9.78

65.60

34.40

31.20

20

474,727

14.18

8.38

63.41

36.59

26.82

21

352,021

14.33

6.22

62.21

37.79

24.42

22

253,038

14.20

4.47

61.19

38.81

22.39

23

194,489

13.48

3.43

59.83

40.17

19.66

  1. Casual riders demonstrate a higher ride count on weekends (Saturday and Sunday) compared to weekdays, peaking on Saturdays (Figure 7.1C and Table 7.2).
Table 7.2: Summary data for day of the week (weekday).

weekday

number_of_rides

avg_ride_duration

percentage

member_pct

casual_pct

member_casual_pct_diff

Mon

725,128

12.75

12.81

67.98

32.02

35.96

Tue

809,398

12.26

14.29

70.54

29.46

41.08

Wed

826,777

12.01

14.60

70.51

29.49

41.03

Thu

845,250

12.21

14.93

69.01

30.99

38.02

Fri

829,127

13.06

14.64

63.79

36.21

27.58

Sat

863,007

15.46

15.24

54.39

45.61

8.78

Sun

763,688

15.59

13.49

55.04

44.96

10.08

  1. Trends for both member and casual riders remain consistent throughout any given day of the month (Figure 7.1D and Table 7.3).
Table 7.3: Summary data for day of the month (day_of_month).

day_of_month

number_of_rides

avg_ride_duration

percentage

member_pct

casual_pct

member_casual_pct_diff

31

95,656

12.62

1.69

68.57

31.43

37.14

30

180,396

13.66

3.19

63.31

36.69

26.61

29

167,530

13.98

2.96

61.82

38.18

23.63

28

175,327

12.84

3.10

65.99

34.01

31.98

27

178,649

13.04

3.16

65.84

34.16

31.69

26

164,063

12.67

2.90

66.37

33.63

32.74

25

160,907

12.90

2.84

65.20

34.80

30.39

24

187,993

13.42

3.32

63.85

36.15

27.69

23

188,098

13.88

3.32

62.36

37.64

24.72

22

177,901

13.39

3.14

63.71

36.29

27.42

21

202,140

13.43

3.57

64.11

35.89

28.22

20

201,462

13.19

3.56

64.94

35.06

29.88

19

182,070

13.37

3.22

64.59

35.41

29.19

18

191,209

13.15

3.38

65.73

34.27

31.46

17

177,305

13.02

3.13

65.24

34.76

30.48

16

183,190

13.29

3.24

63.32

36.68

26.63

15

207,297

13.69

3.66

63.24

36.76

26.48

14

176,654

12.46

3.12

67.30

32.70

34.60

13

179,737

12.83

3.17

67.37

32.63

34.75

12

182,094

13.17

3.22

65.69

34.31

31.38

11

178,975

12.89

3.16

66.55

33.45

33.10

10

208,771

13.71

3.69

63.55

36.45

27.10

09

205,600

14.06

3.63

62.55

37.45

25.11

08

187,657

13.17

3.31

64.57

35.43

29.13

07

202,248

13.24

3.57

65.09

34.91

30.18

06

184,636

12.64

3.26

67.10

32.90

34.19

05

177,658

12.91

3.14

65.42

34.58

30.84

04

206,983

14.59

3.66

59.29

40.71

18.58

03

196,834

14.21

3.48

61.14

38.86

22.28

02

178,697

13.40

3.16

64.05

35.95

28.10

01

174,638

13.59

3.08

63.46

36.54

26.91

  1. Similarly, trends remain similar throughout the year for both types of riders (Figure 7.1E and Table 7.4). Both types of users tend to use bike for commute or leisure more during warmer months as compared to during winters.
Table 7.4: Summary data for the month.

month

number_of_rides

avg_ride_duration

percentage

member_pct

casual_pct

member_casual_pct_diff

Jan

189,506

9.70

3.35

79.09

20.91

58.19

Feb

189,281

10.42

3.34

77.61

22.39

55.23

Mar

256,955

10.30

4.54

76.17

23.83

52.35

Apr

422,888

12.85

7.47

65.90

34.10

31.80

May

597,372

14.28

10.55

61.78

38.22

23.56

Jun

710,757

14.51

12.55

58.64

41.36

17.29

Jul

757,811

15.09

13.38

57.39

42.61

14.79

Aug

762,204

14.52

13.46

60.17

39.83

20.35

Sep

658,604

14.12

11.63

61.24

38.76

22.48

Oct

534,005

12.39

9.43

67.36

32.64

34.72

Nov

360,090

11.13

6.36

73.10

26.90

46.19

Dec

222,902

10.46

3.94

77.13

22.87

54.26

  1. The dataset contains a greater number of members compared to casual riders (Figure 6.2F).

  2. Despite being minimal, there is a notable positive correlation between membership type and weekday (0.06), and a negative correlation with the type of bike (rideable_type, -0.06). This suggests some nuanced differences between member types, warranting further investigation Figure (7.2).

  3. The behavior of casual riders appears to be more spontaneous, evident from their off-peak usage of bikes and increased activity on weekends compared to regular members. This behavior could indicate that casual riders are tourists or individuals seeking leisure activities, utilizing bikes for exploration or enjoyment within the city.

Deliverable

A summary of your analysis The analysis delved into various facets of the dataset, revealing insightful patterns and relationships. Firstly, trends between member and casual riders were explored, highlighting that members tend to take longer trips compared to casual riders. Additionally, members exhibit higher ride frequencies throughout most hours of the day, with minimal differences observed during off-peak hours. Weekend usage patterns also differed, with casual riders showing increased activity, particularly on Saturdays. Moreover, both member and casual riders displayed consistent trends across days of the month and months of the year. The dataset predominantly comprised members over casual riders. Furthermore, subtle correlations were observed between membership type and variables such as weekday and bike type, indicating potential distinctions between member types. Lastly, the behavior of casual riders appeared more spontaneous, characterized by off-peak usage and heightened weekend activity, suggesting a leisure-oriented approach to bike usage. Overall, these findings offer valuable insights into user behavior and preferences, contributing to a comprehensive understanding of bike usage patterns.

8 Share

Guiding questions

Were you able to answer the question of how annual members and casual riders use Cyclistic bikes differently? Based on the analysis conducted, we were able to uncover significant differences in the usage patterns of annual members and casual riders of Cyclistic bikes. By examining various trends and relationships within the data, we gained valuable insights into how these two user groups interact with the bike-sharing service differently.

What story does your data tell? The data reveals that annual members tend to take longer trips compared to casual riders, indicating a potentially different purpose or usage pattern for each group. Moreover, annual members exhibit higher ride frequencies throughout most hours of the day, suggesting a more structured approach to bike usage. Conversely, casual riders display increased activity during weekends, particularly on Saturdays, indicating a more leisure-oriented approach to bike usage. Additionally, both member and casual riders exhibit similar trends across days of the month and months of the year, indicating consistent usage patterns over time.

How do your findings relate to your original question? Furthermore, the analysis uncovered subtle correlations between membership type and variables such as weekday and bike type. These correlations suggest potential differences in preferences and behaviors between annual members and casual riders, highlighting the need for further investigation.

Overall, our findings provide valuable insights into the differences in bike usage between annual members and casual riders, which directly addresses our primary business question. By understanding these usage patterns and preferences, we can tailor marketing strategies and service offerings more effectively to meet the unique needs of each user group, ultimately driving business growth and improving customer satisfaction.

Who is your audience? What is the best way to communicate with them? Based on the stakeholders identified, our primary audience includes Lily Moreno, who leads the marketing department, the Cyclistic marketing analytics team, and Cyclistic’s executive team. To effectively communicate our findings to them, we should tailor our communication style to be concise, informative, and data-driven. Presenting key insights in a clear and visually appealing manner would be ideal, as it allows for easier comprehension and decision-making.

Can data visualization help you share your findings? Data visualization plays a crucial role in sharing our findings with stakeholders. Visual representations such as charts, graphs, and tables can help convey complex information in a more accessible and understandable format. By using data visualization techniques, we can highlight trends, patterns, and correlations within the data, making it easier for stakeholders to grasp the key takeaways from our analysis.

Is your presentation accessible to your audience? In terms of accessibility, it’s important to ensure that our presentation is easily understandable to all stakeholders, regardless of their level of expertise in data analysis. This can be achieved by providing clear explanations of the data and the methodology used for analysis, as well as offering opportunities for stakeholders to ask questions or seek clarification on any aspects they may find challenging to understand. Additionally, providing supplementary materials such as summaries or executive briefs can further enhance accessibility and facilitate better decision-making.

Key tasks

Determine the best way to share your findings. To effectively share our findings, we will determine the best communication approach based on our audience, which includes Lily Moreno, the Cyclistic marketing analytics team, and Cyclistic’s executive team. Utilizing concise, informative, and data-driven communication styles will be essential.

Create effective data visualizations.In creating effective data visualizations, we will employ charts, graphs, and tables to represent complex information in an accessible format. These visualizations will highlight trends, patterns, and correlations within the data, aiding comprehension and decision-making.

Present your findings During the presentation, we will deliver key insights clearly and concisely, providing explanations of the data and analysis methodology used. We will encourage stakeholder engagement by allowing time for questions and discussions.

Ensure your work is accessible. To ensure accessibility, we will make our work easily understandable to stakeholders of all levels of expertise. Clear explanations and supplementary materials, such as summaries or executive briefs, will be provided to facilitate comprehension and decision-making. Additionally, we will offer opportunities for stakeholders to seek clarification on any aspects they may find challenging to understand.

Deliverable

Supporting visualizations and key findings Our supporting visualizations and key findings offer a comprehensive overview of the differences in bike usage patterns between annual members and casual riders at Cyclistic. Through clear and insightful visualizations, we highlight significant trends, such as trip duration, ride frequency, and usage patterns across different days and times. Key findings include the observation that annual members tend to take longer trips and exhibit higher ride frequencies during weekdays, suggesting a more structured usage pattern. In contrast, casual riders show increased activity on weekends, particularly on Saturdays, indicating a more leisure-oriented approach. Additionally, our analysis uncovers subtle correlations between membership type and variables such as weekday and bike type, providing valuable insights for strategic decision-making. These visualizations and findings serve as a foundation for tailoring marketing strategies and service offerings to meet the unique needs of each user group, ultimately driving business growth and enhancing customer satisfaction.

9 Act

Guiding questions

What is your final conclusion based on your analysis? Based on our analysis, the final conclusion is that there are significant differences in bike usage patterns between annual members and casual riders at Cyclistic. Annual members tend to take longer trips and exhibit higher ride frequencies during weekdays, while casual riders show increased activity on weekends. Subtle correlations between membership type and variables such as weekday and bike type were also uncovered, indicating potential differences in preferences and behaviors between the two user groups.

How could your team and business apply your insights? Our team and business could apply these insights by tailoring marketing strategies and service offerings to better meet the unique needs of each user group. For example, we could develop targeted promotions or incentives to encourage weekday usage among annual members, while focusing on weekend promotions to attract casual riders. Additionally, understanding the preferences of each user group could inform decisions about bike availability, station locations, and fleet management to optimize the user experience.

What next steps would you or your stakeholders take based on your findings? Based on our findings, the next steps for our team and stakeholders would involve further analysis to explore the underlying factors driving the observed differences in bike usage patterns. This could include conducting surveys or interviews with users to gain deeper insights into their motivations and preferences. Additionally, ongoing monitoring and analysis of user behavior could help identify emerging trends and inform continuous improvement efforts to enhance the Cyclistic bike-sharing service.

Is there additional data you could use to expand on your findings? There is potential to use additional data to expand on our findings. For example, incorporating demographic information about Cyclistic users, such as age, gender, and location, could provide further insights into the preferences and behaviors of different user segments. Additionally, collecting data on user feedback, satisfaction levels, and reasons for bike usage could offer valuable qualitative insights to complement our quantitative analysis. Furthermore, integrating external data sources such as weather data, local events, or transportation infrastructure data could help identify external factors influencing bike usage patterns and inform more robust predictive models. By leveraging these additional data sources, we can enhance the depth and accuracy of our analysis and derive more actionable insights to drive business decisions at Cyclistic.

Key tasks

Deliverable

Your top three recommendations based on your analysis Based on the analysis conducted, my top three recommendations are as follows:

  1. Tailor Marketing Strategies: Develop targeted marketing campaigns and promotions that align with the usage patterns and preferences of annual members and casual riders. For instance, focus on promoting longer-term memberships to casual riders who exhibit frequent weekend usage patterns.

  2. Enhance Service Offerings: Adjust service offerings and amenities based on the differing needs and behaviors of annual members and casual riders. For example, consider expanding docked bike availability in areas frequented by annual members who prefer structured schedules.

  3. Improve User Experience: Implement user experience enhancements, such as intuitive app features or personalized recommendations, to cater to the diverse preferences of Cyclistic bike users. For instance, provide tailored route suggestions or incentives to encourage longer rides for annual members seeking extended leisure experiences.

By implementing these recommendations, Cyclistic can better meet the needs of its diverse user base, drive customer engagement, and ultimately increase user satisfaction and retention.

10 Additional Comments

The dataset currently lacks information on potential customers who could potentially become either casual or regular members. Expanding the dataset to include such information would be beneficial. The marketing team could initiate brand awareness campaigns to expand the customer base. Given that there are already more regular members than casual riders, the company should aim to convert casual riders into regular members while also attracting new customers, both casual and regular. However, it’s important to acknowledge that converting all casual riders into regular members may not always be feasible. Launching targeted campaigns during holidays, summer months, and in areas with high tourist traffic could help attract new customers. Offering special discounts aimed at non-users and casual riders would not only increase brand awareness but also expand the customer base.

11 Thank you

Thank you for taking the time to review this report. Your feedback and suggestions for improving the analysis are highly appreciated. If you found the notebook helpful and informative, please consider upvoting. Your support is invaluable.