In this case study, I performed many real-world tasks as a junior data analyst. I worked for Cyclistic Company, which is a bike-share company located in Chicago. The director of marketing believed the company’s future success depends on maximizing the number of annual memberships. Therefore, I studied how casual riders and annual members use Cyclistic bikes differently. From these insights, I predicted and designed a new marketing strategy to convert casual riders into annual members.
After organizing, cleaning, transforming and analyzing the data I could understand how annual and casual riders use Cyclistic bikes differently. For what I concluded the following results from my data:
Recommendations:
Develop a digital media project to improve the Company’s marketing. Making emphasis in pros and cons between member riders and casual riders with a focus point in cost.
Reinforce marketing strategies during afternoons, Monday through Saturdays, and Sundays 24 hours, since these are the period of times where clients tend to make use of Cyclistic’ services.
Create seasonal offers for casual riders that encourage them to buy a membership instead of using the Company’ services as a guest.
Summarizing
In conclusion, annual members tend to use Cyclistic Company more often than casual members. Nevertheless, casual riders tend to make use of the Company services in a longer period of time than member riders.
Share of Americans not having Sex
Tableau Link: https://public.tableau.com/views/AmericansStrugglingwithhavingsex/Dashboard1?:language=en-US&:display_count=n&:origin=viz_share_link
School Project