The goal of my analysis was to identify patterns and trends that are unique to casual users of the rideshare. These insights would be useful to inform a marketing strategy aimed at converting casual users to annual members.
The images above summarize the visualizations created in Tableau to summarize the data.
The horizontal bar chart shows the top 10 most frequently used stations by casual riders.
The heatmap shows the duration of rides for casual users by day of week. The darker the tile, the longer the rides lasted. The size of the tile is proportional to the number of rides.
The vertical bar chart shows the difference in number of rides by member type. The color of the bars represents the duration of the rides. Casual users had fewer total rides but longer durations, with the most active months being May to October.
The textboxes on the right show the average length of the rides in minutes for casual riders, and for all riders combined.
Watch the presentation to executives as a video below.
The R code file, Tableau workbook and all relevant documentation can be found on GitHub here. You can also read about it on my blog on Medium.
6-step analysis process: Ask, Prepare, Process, Analyze, Share, Act
RStudio
Microsoft Excel
Tableau
PowerPoint
RMarkdown
Microsoft Word
GitHub
Google Sites