A repository for my Google Data Anlaytics Certificate Capstone Project.
The purpose of this repository is to consolidate downloaded Divvy data into a single dataframe and then conduct simple analysis to help answer the key question: what ways do members and casual riders use Divvy bikes differently.
This exploratory analysis case study is towards Capstome project requirement for Google Data Analytics Professional Certificate. The case study involves a bikeshare company's data of its customer's trip details over a 12 month period (November 2020 - October 2021). The data has been made available by Motivate International Inc. under this license.
The analysis will follow the 6 phases of the Data Analysis process: Ask, Prepare, Process, Analyze, and Act. A brief explanation of these processes:
- Ask effective questions
- Define the scope of the analysis
- Define what success looks like
- Verify data integrity
- Check data credibility and reliability
- Check data types
- Merge datasets
- Clean, Remove and Transform data
- Document cleaning processes and results
- Identify patterns
- Draw conclusions
- Make predictions
- Create effective visuals
- Create a story for data
- Share insights to stakeholders
- Give recommendations based on insights
- Solve problems
- Create something new