DATA ANALYSTICS

Cyclistic Rider Behavior & Membership Conversion Analysis
A full‑stack data analytics project using Excel, Google Sheets, SQL (BigQuery), Tableau, Python, and R
Cyclistic (Fictional name) is one of Chicago’s largest bike‑share programs, serving millions of riders across the city through a network of docking stations (Downloaded from https://divvy-tripdata.s3.amazonaws.com/index.html under this license https://www.divvybikes.com/data-license-agreement). The company offers single‑ride passes, day passes, and annual memberships—each appealing to different types of riders. As part of the marketing analytics team, my role was to uncover how casual riders and annual members use Cyclistic bikes differently, and to translate those behavioral insights into a data‑driven membership‑growth strategy.
This project demonstrates my ability to work end‑to‑end across the analytics pipeline:
data cleaning → transformation → exploration → visualization → storytelling → strategic recommendations.