Rehema Kemunto

Analytics | Machine Learning | Business Intelligence | Automation

Connect on LinkedIn

About Me

I specialize in transforming messy data into actionable insights that drive business decisions. With expertise in statistics and machine learning, I've built customer churn prediction models with 85%+ accuracy, forecasted sales trends using time series analysis, and automated data workflows that save hours of manual work. I work across the full data stack—from SQL queries and Python scripts to Power BI dashboards and workflow automation. Whether it's predictive modeling, statistical analysis, or building automated pipelines, I deliver solutions that create measurable impact.

View My Work

Technical Skills

Python
R
SQL
Tableau
Power BI
Excel
SPSS
Stata
PSPP
Machine Learning
Automation

🌟 Featured Projects

My top 5 projects showcasing business impact and technical depth

Retail Operations & Finance Optimization

MIS - End-to-End Workflow

Comprehensive MIS project tracking $66.31M revenue. Built Power BI dashboard, automated invoice alerts with Google Apps Script, and identified root cause warehouses reducing fulfillment delays.

SQL Power BI Google Apps Script Automation

Polo Shirt Product Performance Analysis

Root Cause Analysis

Analyzed 5,000+ transactions to diagnose 48% return rate. Identified Black variant quality issue and delivered strategic recommendations projected to increase profit margin by 23%.

SQL Power BI Root Cause Analysis Excel

Customer Churn Prediction System

Machine Learning - Classification

End-to-end ML pipeline predicting telecom customer churn with 85%+ accuracy using SMOTE and ensemble models. Delivers churn probabilities and actionable retention insights.

Python XGBoost Random Forest SMOTE

Social Media Ad Performance Dashboard

Marketing Analytics

Power BI dashboard analyzing campaigns across Facebook and Instagram. Tracked 340K impressions and $101K revenue with 333% ROI. Identified optimal ad scheduling times.

Power BI DAX Marketing Analytics

E-Commerce Superstore BI Dashboard

Business Intelligence

Full-cycle BI analysis from Power Query to strategic recommendations. Advanced DAX measures for Net Sales and Profit Margin. Delivered Q4 campaign and regional optimization strategies.

Power BI DAX Power Query

📂 Complete Project Archive

All projects organized by category - showing my journey and progression

Sales Forecasting with Prophet

Machine Learning - Time Series

365-day sales forecasting pipeline using Facebook Prophet with inventory and price regressors. Improved forecast accuracy by 30%.

Python Prophet Time Series

Customer Segmentation Dashboard

Business Intelligence

Tableau dashboard using behavioral data to create distinct customer segments enabling targeted marketing campaigns and retention strategies.

Tableau Customer Segmentation

AI Chat Data Analysis Workflow

Automation & AI

Intelligent n8n workflow automating data analysis through conversational AI. System processes queries and returns insights automatically.

n8n AI Integration

Coffee Shop Survey Analysis

Statistical Analysis

Comprehensive statistical analysis using chi-square tests, ANOVA, and logistic regression to model customer satisfaction and loyalty drivers.

R Logistic Regression ANOVA

API Data Analysis Workflow

Process Automation

Automated n8n workflow fetching data from APIs and performing analysis. Eliminates manual collection ensuring real-time insights.

n8n API Integration

Cluster Analysis on Health Data

Machine Learning - Clustering

Applied k-means and hierarchical clustering to segment health data patterns revealing distinct customer segments for targeting.

R K-Means

Online Sales Analysis

Data Analysis

Deep-dive SQL and Excel analysis uncovering regional trends and seasonal patterns. Delivered insights on revenue drivers.

SQL Excel

Café Sales Dashboard

Business Intelligence

Power BI dashboard analyzing 10K transactions revealing product performance and payment trends supporting pricing decisions.

Power BI DAX

Customer Retention Dashboard

Business Intelligence

Interactive dashboard identifying churn signals and high-value customer segments through satisfaction scores and behavioral metrics.

Power BI Customer Analytics

Certifications

J.P. Morgan - Quantitative Research

Forage

October 2025

BCG - Data for Decision Makers

Forage

November 2025

Deloitte - Data Analytics

Forage

August 2025

Accenture - Data Analytics & Visualization

Forage

May 2025

Data Manipulation with Pandas

DataCamp

September 2025

Understanding Machine Learning

DataCamp

February 2025

View all certifications on LinkedIn

Let's Connect

I'm always open to discussing new projects, creative ideas, or opportunities to bring data-driven solutions to life. Feel free to reach out via LinkedIn or GitHub!