As a part of Google Analytics Certification, A capstone project was proposed. So, I planned to analyze cyclist dataset from case proposed from the certification which is of public domain. The data base contained previous 12 months of cyclist data our objective is to propose new marketing strategy to convert casual riders into annual members based on our analysis

Objective of the analysis

• How do annual members and casual riders use Cyclistic bikes differently?
• Why would casual riders buy Cyclistic annual memberships?
• How can Cyclistic use digital media to influence casual riders to become members?

These are the objective of the analysis provided by the marketing head of the company Lily Moreno

Data History

• The data was precleaned before using in R Using Excel and R

Changelog in Excel

• Replaced Empty rows of start_station_name and end_station_name with "Unknown_start_station_name" and "Unknown_end_station_name"
• Replaced Empty rows start_station_id and end_station_id with zero- "0"
• Replaced Empty rows of latitude and longitude with "UK"
• Sorted By Column- started_at and member_casual Ascendingly
• Calculated column- Ride_length with formula = (ended_at-started_at)
• Replaced Negative values in the column Ride_length with "NA"
• Combined the data using R