Capstone google data analytics certificate
Capstone google data analytics certificate
Embedded Files
an analysis of a fictional bike sharing ride company called Cyclistic
an analysis of a fictional bike sharing ride company called Cyclistic
Three questions which guided this analysis:
1. How do annual members and casual riders use Cyclistic bikes differently?
2. Why would casual riders buy Cyclistic annual memberships?
3. How can Cyclistic use digital media to influence casual riders to become members?
The weekly usage between annual and casual members. Divided by top 5 stations from each category. as well as the overall weekly usage.
The weekly usage between annual and casual members. Divided by top 5 stations from each category. as well as the overall weekly usage.
a view of annual member vs causal member
a view of annual member vs causal member
Divided by men & women
top 10 age groups
top 10 age groups
Divided by Men & Women
Recommendations:
Recommendations:
To increase the number of women using our service, we propose the following strategies:
Launch a marketing campaign led by women and women influencers to promote our service and create a relatable message that resonates with women.
Invest in resources to identify the underlying reasons why men are more likely to use our service than women, and use the insights gained to create targeted solutions that address the barriers women face.
Test the hypothesis that comfort is an issue for women by examining factors such as clothing attire around office buildings, and explore ways to address these issues to make riding more comfortable and accessible for women.
The service is currently most popular among millennials, specifically those in their late 20s and mid-30s. In order to expand our user base, we should focus on reaching out to younger generations, such as Gen Z, by creating marketing campaigns centered around climate change and the benefits of using our services. Additionally, we should explore partnerships with companies that have sustainable practices to become a negative carbon producer and further promote our commitment to environmental responsibility.
We have noticed that usage of our service peaks at the start of each season and the beginning of the year. Specifically, we see a significant increase in usage at the start of Spring, Summer, Fall, and on January 1st. This could be attributed to the changing weather or new year's resolutions. We suggest taking advantage of these periods to promote annual memberships to our casual customers through targeted marketing campaigns.
You can find, SQL scripts, Raw Data and Clean data files as well a road-map, etc.. on my GitHub.
You can find, SQL scripts, Raw Data and Clean data files as well a road-map, etc.. on my GitHub.
Page updated
Google Sites
Report abuse