Skip to content

Rajesh-Sanikommu/Google_Data_Analytics_Capstone_Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 
 
 
 
 

Repository files navigation

Google_Data_Analytics_Capstone_Project

I analyzed a dataset using R for a company, Cyclistic, a bike sharing company in Chicago. Created an interactive dashboard showing how annual members and casual riders use Cyclistic bikes differently. I also provided marketing strategies to convert casual riders to annual members.

Process

I first analyzed the data separately (each month) in Excel, then used R to analyze the data as a whole (one year). Finally I created a dashboard in Tableau and used Figma to support the design elements.

🚲 Background

Cyclistic is a fictional bike sharing program which features more than 5,800 bikes and 600 docking stations. It offers reclining bikes, hand tricycles, and cargo bikes, making it more inclusive to people with disabilities and riders who can't use a standard two-wheeled bike. It was founded in 2016 and has grown tremendously into a fleet of bicycles that are geotracked and locked into a network of 692 stations across Chicago. The bikes can be unlocked from one station and returned to any other station in the system anytime.

🔗 Links

📁 Files

  • FinalAnalysis.R - analyzed the data set from case study 1 in the Google Data Analytics Course using R. I did not do any data visualization in R.
  • FinalAnalysisTableau.R - create a specific data frame to use in Tableau. Deleted unncessary columns to make the code run quicker in Tableau.

Releases

No releases published

Packages

No packages published

Languages