Toż to siostra! powiedział mój mąż, gdy jego siostrzyczka urządziła sobie grilla prosto na moich różach! Moja odpowiedź sięgnęła dwóch metrów wysokości
Wyobraźcie sobie tę scenę: dostaliśmy od teściowej w spadku działkę. No, niby działka w cudzysłowie. Stary, pochylony domek, płot z trzech desek i kawałek ziemi porośnięty chwastami po pas. Mój mąż, jak większość facetów, rzucił na to okiem i westchnął: Olać to, lepiej sprzedać.
A ja? Cóż, mam taki charakter uparta jak osioł! Wczepiłam się w ten skrawek ziemi. Już widziałam, jak tu będzie pięknie. Cały rok żyłam tą działką. Włożyłam w nią prawie wszystkie oszczędności i, oczywiście, mnóstwo pracy.
Sama malowałam domek, zatrudniałam robotników do naprawy dachu. Ale najważniejsze założyłam ogród. I nie byle jakie grządki, dziewczyny, tylko prawdziwą małą Anglię! Róże, piwonie, hortensje Dbałam o każdy kwiat jak o własne dziecko.
Mąż z początku się śmiał, ale gdy zobaczył efekt, choćby nabrał szacunku. No, Krysia, ty to masz zacięcie! mówił, patrząc na moje kwitnące rabaty. I szczerze? Byłam szczęśliwa. Miałam swoje miejsce mocy, ucieczkę od świata.
Ale muzyka grała krótko. O naszej posiadłości dowiedziała się siostra męża, moja szwagierka Bożena. Pani wielkomiejska, do ziemi nieprzyzwyczajona, ale odpoczynek na łonie natury o, to co innego! Zwłaszcza gdy tę naturę ktoś już uporządkował.
Pewnej soboty, bez telefonu ani zapowiedzi, pod dom zajechało auto. Wysypała się z niego cała ekipa Bożeny: ona sama, jej mąż i dwoje rozwrzeszczanych dzieci.
Krysiu, cze-ee-ść! Przyjechaliśmy na grilla! wrzasnęła od progu.
Oczywiście, oniemiałam, ale co robić rodzina. Pokazałam im domek, zaproponowałam herbatę. A oni, choćby butów nie ściągając, od razu na świeżo pomalowaną werandę. I zaczęło się
Dziewczyny, to nie był odpoczynek to była barbarzyńska inwazja. Jej mężczyzna post# Case Study: How Does a Bike-Share Navigate Speedy Success?
## About the company
In 2016, Cyclistic launched a successful bike-share offering. Since then, the program has grown to a fleet of 5,824 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.
Until now, Cyclistics marketing strategy relied on building general awareness and appealing to broad consumer segments.
One approach that helped make these things possible was the flexibility of its pricing plans: single-ride passes, full-day passes,
and annual memberships. Customers who purchase single-ride or full-day passes are referred to as casual riders. Customers
who purchase annual memberships are Cyclistic members.
## Business Task
The director of marketing believes the companys future success depends on maximizing the number of annual memberships. Therefore, my
team wants to understand how casual riders and annual members use Cyclistic bikes differently. From these insights, my team will design a new
marketing strategy to convert casual riders into annual members.
## Data Source and Preparation
The data has been made available by Motivate International Inc. under this [license](https://divvybikes.com/data-license-agreement). This is public data that I can use to explore how different customer groups are using Cyclistic bikes. The data used was from the previous 12 months (April 2021 to March 2022). It was downloaded and imported into a spreadsheet for cleaning before transferring to BigQuery for analysis.
## Analysis
For the full code, click [here](https://github.com/abdulwahab95/Cyclistic-case-study/blob/main/cyclistic_bikeshare_analysis.sql)
1. **Data Cleaning**
– Combined all tables into a single one
– Removed duplicate rows
– Created new columns for analysis (day_of_week, month, ride_length)
– Removed rows with null values
– Removed rows with ride length less than a minute or greater than a day
2. **Descriptive Analysis**
– Calculated mean, max and min ride lengths
– Counted number of rides per day of the week and per month
– Calculated average ride length per day of the week and per month for each user type
– Calculated number of rides per bike type for each user type
## Findings
1. **Casual riders had longer average ride lengths while members had more rides overall.**
– The casual riders’ average ride length was **29.29 minutes** while members’ average was **12.80 minutes**.
– Members had **2,880,098 rides** while casual riders had **1,821,867 rides**.
2. **Members use the service more during the weekdays while casual riders use it more on the weekends.**
– **60.55%** of the rides by members were on weekdays (Monday to Friday) while **39.45%** were on weekends (Saturday and Sunday).
– **53.12%** of the rides by casual riders were on weekends (Saturday and Sunday) while **46.88%** were on weekdays (Monday to Friday).
3. **Both user types use the service more during the summer months (June to September).**
– The casual riders’ highest number of rides was **377,137 rides in July** while members’ highest was **386,933 rides in August**.
4. **Casual riders prefer classic bikes while members prefer electric bikes.**
– **53.82%** of the rides by casual riders were on classic bikes while **46.18%** were on electric bikes.
– **53.66%** of the rides by members were on electric bikes while **46.34%** were on classic bikes.
## Recommendations
1. **Offer discounts or incentives for casual riders who frequently use the service during the weekdays.**
– Since members use the service more during the weekdays, incentivizing casual riders to do the same could encourage them to become members.
2. **Promote annual memberships during the summer months when usage is highest.**
– Both user types use the service more in summer. Capitalizing on this peak period with targeted marketing could convert more casual riders into members.
3. **Highlight the benefits of electric bikes in marketing materials.**
– Since members prefer electric bikes, emphasizing their advantages (e.g., speed, ease of use) could appeal to casual riders who are considering membership.
4. **Create weekend-specific promotions for casual riders.**
– Since casual riders use the service more on weekends, offering weekend-exclusive deals could make annual memberships more attractive to them.
## Conclusion
By analyzing the differences in usage patterns between casual riders and annual members, Cyclistic can tailor its marketing strategies to effectively convert casual riders into members. Focusing on peak usage times, preferred bike types, and incentivizing weekday rides are key strategies that can drive this conversion.
