Portfolio · Brian E. Ketchens

All projects

Eleven shipped analyses across operations, quality, and BI — each built to answer a business question, with the source and a live artifact one click away.

← Home
Showing 11 of 11
dbt · Snowflake · Dimensional modeling

Olist Star Schema — dbt + Snowflake

An end-to-end dbt + Snowflake pipeline transforming raw Olist e-commerce CSVs into a tested star schema.

28/28dbt tests passing — every fact row resolves to a real dimension
SnowflakeStar schemadbt
ML & Forecasting

ERCOT Houston Grid Load Forecasting

Weather structure alone predicts grid load — a feature audit exposed that a single autoregressive lag was inflating the baseline by ~65%, so the champion was rebuilt without it.

0.90R² on a weather-only champion model
LightGBMStreamlitTableau
Applied ML · Measurement

High-Probability Opportunity Radar

Does qualification fit actually predict interviews? An instrument that scores postings on two independent axes and logs real outcomes — with a guardrail that refuses to coach embellishment.

Study livemeasurement running, findings pending — reported with sample size
Sentence-transformersLLMHonesty guardrail
People Analytics

Employee Retention — Where the Budget Goes

With a finite retention budget, who do you fund first? Ranking roles by cost and by exit rate produces two different lists — Lab Techs are the only role that tops both.

$20.4Mannual turnover loss analyzed
RTableauCost modeling
Continuous Improvement

CI Defect Reduction — Aim the Next Cycle

One improvement team, one cycle — where do you point it? Screened sixteen candidate factors, rejected twelve as noise, and isolated three controllable drivers.

12/16candidate factors ruled out as noise
DMAICRoot causeTableau
Business Intelligence

Executive Supply Chain & Financial Dashboard

A multi-page executive suite linking fulfillment to profit, with computation pushed upstream to a BigQuery data lake for zero-lag cross-filtering over millions of rows.

2.8Mtransaction rows, sub-100ms cross-filter
Power BIDAXBigQuery
Data Engineering

E-Commerce Fulfillment Bottleneck Audit

Loaded 32.4M Instacart order-product rows into a local PostgreSQL warehouse, then mined reorder timing, product co-occurrence, and purchase-interval signals — with every proxy labeled as one.

32.4Morder-product rows in a local PostgreSQL warehouse
PostgreSQLWindow functionsSelf-joins
Public Health Analytics

Structural Health Inequity During Pandemics

What drives persistent pandemic burden? A county-level mortality analysis identifying structural conditions — not age or race — as the primary predictors.

2,904US counties; negative binomial, p<0.001
RBigQueryleaflet · plotly
Data Engineering

COVID-19 ETL Pipeline — BigQuery SQL

Three public datasets, one clean analytical base table — schema mismatches, type conflicts, and FIPS-key formatting all resolved in production ETL.

386Kweekly county-rows from 3 joined sources
BigQuery SQLCTEsFIPS joins
Healthcare Analytics

Hospital Patient Analysis in R

Length of stay, billing, and predictive modeling across 55,500 records — including a null model result documented honestly rather than quietly dropped.

55.5Kinpatient records; tidymodels workflow
Rtidymodelsflexdashboard
Product Analytics

Bellabeat Case Study — Fitbit Data

Fitbit wellness patterns translated into product strategy — weekend activity peaks point to a weekday-nudge opportunity, backed by simple correlation evidence.

0.59steps↔calories correlation; 33 participants
Rtidyverseggplot2