Uzeyir Ktk

2 years ago ·

Post by Uzeyir
>
Google Capstone Project

Google Capstone Project

🚴 GOOGLE CAPSTONE PROJECT: Uncovering Cyclistic's Rider Insights! 📊

I'm thrilled to share the latest update on my recent project, where I delved into the fascinating world of Cyclistic, Chicago's bike-sharing program. 🌆

Cyclistic, founded in 2016, has grown significantly, boasting a fleet of more than 5,800 bikes and 600 docking stations. What makes Cyclistic unique is its commitment to inclusivity, offering a range of bikes, including reclining bikes, hand tricycles, and cargo bikes, to cater to a diverse group of riders, including those with disabilities. 🌟

For this project, I set out to answer a pivotal business question: "How do annual members and casual riders use Cyclistic bikes differently?" 🤔

My journey began with data analysis, using Python to clean and merge various CSV files into a comprehensive dataset. This formed the backbone of my analysis. 🐍

The real magic, however, happened when I visualized the data using Tableau. The result? A detailed final report that sheds light on the distinctive ways Cyclistic members and casual riders interact with our bikes. 📈

Cyclistic offers flexible pricing plans, including single-ride passes, full-day passes, and annual memberships, each offering a unique experience to riders. 🚀

I'm excited to share my findings, which provide valuable insights into how different rider groups engage with Cyclistic's services. This project has been a fantastic opportunity to explore the world of data analysis and its practical applications. 🚴‍♂️

If you're interested in learning more about this project or the fascinating world of bike-sharing data analysis, feel free to reach out! 🌐

#DataAnalysis #CyclisticProject #UrbanMobility #Tableau #Inclusivity #datavisualization #datainsights #vizoftheday #makeovermonday #Python #Googlecapstoneproject #Googledataanalytics #dataanalytics #datascience

GOOGLE CAPSTONE PROJECT Analysis of Cyclistic customer behavior (member vs. casual riders) Total Rides 42M Average Ride Length 24.6MIN Total Rides by User Type Members had the most amount of rides at 56% of total rides. 18M 23M Rider Type Total Rides Percentage ® casual 1,785,747 43.65% ® Memoer 2,305,609 56.35% Avg. Ride length by User Type Casual Member 37.7MIN 14.4MIN Ride Length by Weekday The weekends had the longest average ride lengths for casual riders while members had a relatively consistent average ride length throughout the weeks. Day Of Week aah 3113 2281 2141 | 2060 son 20% | Sunday Monday Tuesday Wednesday Thursday Friday Saturday Total Rides by Hour Busiest Time Afternoon Busiest Season Summer Busiest Weekday Saturday Total Rides by Bike Type Classic bikes were the most popular bikes among casual users and members. Docked Bike 1.066.926 789.557 749.002 449.16 628% Classic Bike Electric Bike Casual Member Total Rides by Weekday The busiest day of the week was Saturday with 18% of the total rides for both members and casual riders. 11422 613.586 592.023 HAH BBG »21.314 h7h.46 501,460 Sunday Monday Tuesday Wednesday Thursday friday Saturday The afternoon was the busiest ime with 1,902,359 total bike rides, 45% of total rides with members having more rides. 17:00 /SPM was the busiest hour between both casual nders and members 0 1 2 3 4 5 6 7 8 9 10 1" 2 3 woos 16 1” © 19 Total Rides by Month 421.069 20 2 2 2 Night ® Morning ® Afternoon Evening July was the busiest month counting for 630,592 rides or 16% of total rides. Summer was the busiest season counting for 45% of total rides. With members having 49% and casual nders having 51% of rides during Summer LL [er a7 94 60414 497754 asarrm 130.600 7780: pn nn ni ars [ 42.840 January February March April May June July August September October November December ® Winter Spring ® Summer ® Fall Analysis Members had the most rides at 56% of total rides. The average ride length typically mirrored the number of rides, meaning they had similar highs and lows. The average ride length was 24 minutes with Casual riders having the longest average ride length at 27 minutes. Popular Bike CLASSIC The most popular bike type for both was the classic bike but for casual riders Busiest Time AFTERNOON alone it was docked bikes. Busiest Weekday SATURDAY Both members and casual riders rode in the afternoon (12pm - 5 pm) and at 5pm the most with night and 4am being least busy Busiest Season SUMMER Saturday was the most popular weekday for both. Members used the bikes Most Rides by User Type MEMBER equally throughout the week with a slight increase on Wednesdays, while Casual riders rode equally throughout the weekdays but the most on Average Ride Length 24 MIN weekends, Saturdays in particular. Summer (June - August) was the busiest season for both types of riders and they rede the most in July. While the least in Winter months. (December - February) specifically in February.
 
Science and Technology
Comments

You may be interested in these jobs

  • Performance Marketing Specialist

    1 day ago

    Cenit Inc Karachi Division, Sindh

    We are looking for a results-driven Ads Specialist to generate high-quality B2B leads. · Design and execute paid search (Google) and paid social (Meta) campaigns specifically for B2B Lead Generation. · Manage a monthly budget to achieve a target Cost Per Qualified Lead (CPQL). · ...

  • Digital Marketing Specialist

    4 weeks ago

    Manar Al Ilm

    This role involves developing implementing and optimizing digital marketing campaigns with a focus on Google Ads. · ...

  • Performance Marketer

    2 weeks ago

    Digital Auxilius Karachi Division

    Digital Auxilius is seeking a Performance Marketer with proven expertise in running and scaling paid advertising campaigns. · ...