Pipeline Case Studies — analyses built to order | MCP Analytics
Pipeline Case Studies

Analyses built to order

Nobody wrote these in advance. Someone described a question in plain language, and our build pipeline designed an analysis for it — chose the method, wrote the R, validated the output, and rendered the report you can open below. Each one became a module its owner can re-run on new data whenever they like.

How these differ from Library Case Studies

These are commissioned. You bring a question we have never seen and get an analysis built for it, which is yours to keep and re-run. Library case studies are the opposite: prebuilt and instant — already written, always available, ready to run. Most people start with the library and commission a build when they need something specific.

Retail & E-commerce

Avocado Price Elasticity Analysis

Estimates price elasticity of demand for avocados using log-log regression of log(total_volume) on log(average_price), controlling for type (conventio

Avocado Price Trends — Deck

Regional avocado price and volume trends across US markets, built as a multi-card deck from a plain-language question.

deck tier

Avocado Price Trends — Snapshot

The same avocado price question answered as an instant snapshot report.

snapshot tier

Avocado Price-Volume Regression

OLS linear regression of weekly avocado average retail price on total sales volume, reporting slope estimate, R-squared, confidence bands, and residua

Customer RFM Segmentation

Segment e-commerce customers into behavioral groups based on purchase recency, frequency, and monetary value using K-Means clustering for targeted mar

Customer RFM Segmentation

Segment ecommerce customers into behavioral groups using Recency, Frequency, and Monetary (RFM) analysis with K-Means clustering. Identify high-value,

Delivery Time vs. Customer Satisfaction

Quantifies how delivery speed affects customer review scores by joining orders and reviews on order_id, computing delivery_days, and running OLS regre

E-Commerce Customer Churn Prediction

Predict which customers are at risk of churning using behavioral engagement, transaction history, satisfaction, and demographic features. Identifies h

E-commerce / SaaS Churn Drivers

Identifies which customer attributes drive churn using logistic regression for interpretable odds ratios and random forest for non-linear importance c

Price Elasticity of Demand Analysis

Estimate price elasticity of demand across product categories and regions using multiple linear regression on historical pricing and volume data. Iden