Posts

Google Data Analysis Capstone Project Cyclistic RideShare (SQL and Tableau)

Image
Google Data Analysis Capstone Project Cyclistic RideShare Case Study (SQL and Tableau) Daniel Morgan Case Summary: Cyclistic is a bike share company with a fleet of bicycles that are geotracked and locked into a network of stations across Chicago. Cyclistic has three pricing plans: single-ride passes, full-day passes, and annual memberships. Customers who purchase single-ride or full-day passes are referred to as casual riders. Customers who purchase annual memberships are annual members.  The main focus of this case is to explore ride data in the hopes of discovering differences in the way annual members and casual riders use Cyclistic’s bikes. These insights will then be used to design marketing strategies aimed at converting casual riders into much more profitable annual members.   Findings:  (Please continue reading for detailed analysis process and documentation) The data suggests that Cyclistic users fall into two categories: Chicago locals who use the bikeshare mainly for daily