My Data analysis work on data sets so far

Data Analysis - 01

Summary statement: In this case study, I used bike share company data to evaluate patterns based on different types of customers. I was then able to propose a action plan to increase subscription of annual memberships.

Business task: Developing marketing strategies to increase the number of annual members by analyzing their pattern of using services of Bike-share company.

This analysis was performed for a capstone project in the Google Data Analytics professional certificate course.

In this case study, I performed data analysis for a fictional bike-share company in order to help them design marketing strategies aimed at converting casual riders into annual members. I analyzed how they behave differently. Along the way, I performed numerous real-world tasks of a junior data analyst by following the steps of the data analysis process: Ask, Prepare, Process, Analyze, Share, and Act.

Source of the Data: The data has been made available by Motivate International Inc. under this license (https://www.divvybikes.com/data-license-agreement.)This data was provided in the Google certificate as a part of the capstone project.

Business task:

Developing marketing strategies to increase the number of annual members by analyzing their pattern of using services of Bike-share company.

Cleaning of data set:

Tools used: Excel & SQL

  1. Deleted cells with negative and zero ride length.

  2. Format of DateTime column made uniform.

  3. Deleted Null cells from the data.

Preparation and Analyzation:

Tools used: SQL & R

  1. Extracted time from TimeDate columns.

  2. Created Ride length column.

  3. Sorted data customer-wise and rideable type-wise.

  4. Joined data in a single file using inners joins.

A summary of analysis:

A few key metrics of the past 12 months:

  1. Count of total rides observed a dip Q4-2020 and Q1-2021.

  2. Weekends observed more bookings than weekdays, especially for casual members.

  3. The ride count of annual members is more than casual members.

  4. The docked bike has a maximum ride count but observed a drop in popularity in the last two quarters.

  5. The average ride length of casual members is almost three times that of annual members.

Supporting visualizations and key findings:

Tools used: Tableau and R

*Please refer presentation attached below for visualizations of insights generated.

Top three recommendations based on analysis:

  1. Provide offers to annual members in the last and first quarters to enhance sales and increase the number of subscriptions of annual members.

  2. Casual members prefer long rides, a special discount on long rides can attract more annual subscriptions.

  3. Casual members prefer more rides on weekends, special discounted rides on weekends can be helpful in signing more subscriptions.