Shareds

Understanding How Casual Riders Differ from Annual Members in Their Usage of Cyclistic Bikes Executive Summary Cyclistic, a Chicago-based bike-share program, seeks to increase its annual memberships by understanding how casual riders differ from members in their usage of the service. Through an extensive analysis of historical bike trip data, key insights have emerged that can inform targeted marketing strategies. Casual riders exhibit significantly longer ride durations — 96% longer on average — compared to annual members. Peak usage times differ: Casual riders primarily ride late at night and in the afternoon, while members ride during commuting hours. Casual riders heavily favor electric scooters and high-traffic tourist locations, such as Shedd Aquarium and Buckingham Fountain. Key Recommendations ...

Hi, I’m Randall Sturgis 👋 I’m a dedicated and versatile analyst with over 10 years of experience in data analytics, report writing, SQL, marketing operations, and customer service. Proven ability to analyze and solve complex problems while effectively coordinating with internal and external partners to achieve strategic objectives. 🛠️ Skills & Technologies Software: Excel, MS Report Builder/SSRS, Power BI/Power BI Report Server Languages: Python, Perl, Bash, VBA, C#, T-SQL Technical: Data analysis, implementation, report generation, CRM/ERP administration/reporting, Power Platform development Soft Skills: Customer service, de-escalation, business process change management 💼 Case Studies & Projects Cyclistic Case Study - Cyclistic, a Chicago-based bike-share program, seeks to increase its annual memberships by understanding how casual riders differ from members in their usage of the service. Through an extensive analysis of historical bike trip data, key insights have emerged that can inform targeted marketing strategies. 📜 Certifications Google Data Analytics Professional Certificate 📬 Get in Touch GitHub LinkedIn