Question
Knowing that the Divvy Bike Ride data file contains 5,667,717 rows of data, explain if this metric represents the total number of the unique riders
Knowing that the Divvy Bike Ride data file contains 5,667,717 rows of data, explain if this metric represents the total number of the unique riders (i.e., unique users of the bike share system) or the total of the unique bike rides. What will be the answers of these questions with step by analysis process in Tableau? 1. Explain if you can determine whether more riders were subscribers or single riders. 2. Which month had the most rides during it? How many rides were there? Was this what you would expect to see with the data? Why or why not? 3. Which month had the least rides during it? How many rides were completed? Explain whether this seems reasonable. 4. Which month had the longest average rides? What is the average duration (in minutes) of the rides that occurred during the month? Again, explain whether this seems reasonable. 5. Which day of the week had the highest number of total rides during the year? What was the total number of rides on that day? Explain if this is what you would have expected before you started analyzing the data. 6. Which day of the week had the shortest average ride duration during the year? What was the average duration (in minutes)? Provide possible explanations for this observation. 7. Which days during the week had the longest and second-longest average duration? What are the respective durations (in minutes)? Explain whether this appears to be reasonable and provide possible explanations for this finding. 8. What is the average ride duration (in minutes) for customers? And for subscribers? Provide possible explanations for the difference between these two groups. 9. What are the top three stations that riders used to start their trips? How many trips were started at each of the stations? Then, use Google Maps to provide a possible explanation of their popularity. 10. What are the top three stations that riders used to finish their trips? How many trips were finished at each of the stations? Again, use Google Maps to provide a possible explanation for why those stations are so popular.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started