Analytics Portfolio – Projects & Case Studies

Real analytics projects delivering measurable business outcomes

Customer Segmentation & Marketing Analytics

Customer Segmentation & Marketing Analytics

Built a comprehensive customer segmentation model using Python and machine learning to identify high-value customer groups. Developed targeted marketing strategies that increased campaign ROI by focusing on the most profitable segments.

Technologies

Python
Scikit-learn
Pandas
K-Means Clustering
RFM Analysis

Outcomes

Identified 5 distinct customer segments with clear behavioral patterns, enabling personalized marketing campaigns and improved customer retention strategies.

Customer Behavior Analysis & BI Dashboard

Customer Behavior Analysis & BI Dashboard

Created an interactive Power BI dashboard analyzing customer purchase patterns, lifetime value, and churn risk. Integrated data from multiple sources using SQL to provide a unified view of customer behavior.

Technologies

Python
SQL
Power BI
DAX
Data Modeling

Outcomes

Delivered real-time insights into customer behavior, reducing churn by 18% through early intervention strategies and improving customer lifetime value tracking.

A/B Testing & Statistical Analysis

A/B Testing & Statistical Analysis

Designed and executed A/B tests for marketing campaigns and website optimization. Applied statistical methods to ensure valid results and actionable recommendations for business decisions.

Technologies

Python
SciPy
Statistical Testing
Hypothesis Testing
Data Visualization

Outcomes

Validated campaign improvements with 95% confidence, leading to a 23% increase in conversion rates and data-driven decision making across marketing initiatives.

Marketing Segmentation App — Free & Open Source

Marketing Segmentation App — Free & Open Source

Built a free, privacy-first web app that takes small businesses from a raw customer or sales export to labeled customer segments — entirely on their own computer. Handles data cleaning, feature engineering, exploratory analysis, and automatic segmentation, so non-technical owners can find their VIPs, at-risk, and growth segments without sharing data with anyone.

Technologies

Python
Streamlit
scikit-learn
K-Means Clustering
Pandas

Outcomes

A live, open-source tool that runs 100% locally — no cloud uploads, no tracking, no data harvesting. Sales forecasting is on the roadmap.

Supporting Hamilton's small business community

I'm committed to helping local Hamilton businesses succeed. For qualified small businesses and startups in our community, I'm open to taking on select projects at reduced rates or on a low-commitment basis.

If you're a Hamilton-area business looking to get started with analytics but concerned about cost, let's talk. We can find a way to work together that fits your budget and delivers value. Explore my data analytics services, or see how customer segmentation can reveal your most profitable customers.

Have a project in mind? Let's talk

Ready to start your analytics journey?

Whether you need customer insights, marketing optimization, or a complete analytics infrastructure, I'm here to help.

Book a Free Discovery Call