Data Rules the World

  Transforming Data into Strategy: How I Converted Cyclistic 's Casual Riders into Members. Published on:  18th October, 2025 Tags: #DataAnalytics #CaseStudy #RStudio #Tableau #Cyclistic #MarketingStrategy Introduction: The Business Problem As a Data Analyst for the fictional bike-share company Cyclistic , my core mission was simple: How do annual members and casual riders use Cyclistic bikes differently, and how can we use that insight to convert casual riders into annual members? This project moved through the entire data analysis process—from Ask to Act—culminating in clear, data-backed marketing recommendations for the Director of Marketing. 1. Ask & Prepare: Defining the Challenge The business objective was to drive membership growth. We started with 12 months of Cyclistic trip data (publicly available historical data) and prepared it for analysis. Below are the datasets that are made available for this project:   Initial Challenge: The data was inconsistent, ...

   Welcome to My Data Analytics Portfolio. I am Mr Matthew Ternenge Beeun, an aspiring data analyst with a passion for transforming raw data into actionable insights. This portfolio showcases my work on the Bellabeat case study, where I applied SQL, R, and Tableau to clean, analyze, and visualize user behavior data from smart wellness devices. The goal of this project was to uncover patterns that could inform Bellabeat’s business strategy and marketing decisions. Below, you’ll find my datasets, code files, visualizations, and stakeholder report—all organized for clarity and impact. Table of Contents 1. Project Overview 2. Data Cleaning (SQL) 3. Visualizations. (Tableau) 4. Stakeholder Report (R Markdown) 5. Downloadable Files 6. External Links(Github, Kaggle) 1. Project Overview Bellabeat Case Study This portfolio project explores user behavior data from Bellabeat, a wellness tech company that manufactures smart devices for tracking fitness, activity, sleep, and health metr...