Google Capstone Project
This is a detailed article explaining the steps I took and the conclusions I came to for this capstone project. Scenario For this project, I'm a junior data analyst for a fictional company called "Cyclistic", a bike-share company in Chicago. I've been given the task of figuring out how annual members and casual riders use Cyclistic bikes differently and design a new marketing strategy to convert casual riders into annual members. Ask In this step, I asked myself the question “How do annual members and casual riders use Cyclistic bikes differently?” It’s believed that annual members are more profitable than casual riders. My task was to analyze the data to find the difference between casual riders and members and then provide recommendations to convert casual riders into annual riders. Prepare To prepare I downloaded the data for this case study. I downloaded the trip data from Q2-Q4 of 2019 and Q1 of 2020 from here . Process For this step, I combined and uploaded...