Divvy Case Study

Andrew Luyt
Last updated: Friday August 13, 2021

Background

Divvy is a bike-sharing service in Chicago. The dataset is real-world, supplied by Motivate International Inc. which operates the bicycle sharing service. The data has been made available under this licence.

This analysis is an exercise, a capstone project to Google’s Data Analytics Certificate. I don’t represent Motivate International Inc. or Divvy.

Business Tasks

1. How do annual members and casual riders differ in their use of the system?
2. What are some major system use patterns?

Deliverables

Produce a report with the following deliverables:

• A clear statement of the business task
• A list of all data sources used
• Detailed descriptions of data cleaning and manipulation performed
• A summary of your analysis
• Supporting visualizations and key findings

Data source

https://divvy-tripdata.s3.amazonaws.com/index.html

Data checklist

• Reliable: This is internal data
• Original: Yes, internal data.
• ? Comprehensive: The data has 13 features: trip times, stations involved, geographical coordinates, and membership information. It might be difficult to infer how the bikes are being used.
• Current: The newest data is approximately one month old, and extends back to 2013.
  • Some of this information may be too old to be relevant. We will limit to data no older than one year.
• Cited: Yes