This repo's analysis is based on NYC Citi Bikes public dataset. This dataset has been accessed through GCP's BigQuery, where the following business questions were answered through SQL:
You’ve been told by customer support that customers frequently complain about bike stations being empty. You need to analyze the data in your data set to understand this problem and make suggestions about how to address it.
- Can you find any traces of empty stations?
- If yes, how big is this problem?
- What are the most popular stations in the network?
- When does their usage peak?
- What are the most popular trips in the network?
- Are there differences in the types of rides that people take?
- Is there a pattern in the types of stations that are empty?
- Data-Driven insights & Recommendations: This document contains data-driven two insights about the complaints of empty bike stations. Finally, an actionable recommendation is given based on these insights.
- Queries for the Analysis: This file contains all the queries where the insights and recommendations are based on.