Hi, I'm Jake 👋
Data analyst completing a Master's in Computer Information Systems at West Texas A&M University. I build regression models, forecast time series, and turn messy datasets into business decisions.
Tools I work in: Python, SQL, Power BI, and advanced Excel.
Featured
-
Reducing Voluntary Turnover: A Data-Driven Analysis of Attrition Risk
An analysis of 1,470 employee records identifying which job roles, compensation patterns, and overtime conditions drive voluntary attrition — and where HR leadership has the highest-leverage interventions.
-
F1 Performance Data Visualization Pipeline
A Python pipeline using FastF1 to extract and visualize Formula 1 telemetry, with a focus on quantifying the 2026 regulation change impact on lap times and top speeds.
-
Red River Ski Area Climate Forecast
A 37-year time series analysis of Red River, New Mexico temperatures, quantifying a 2.24°F warming trend and its operational impact on ski area snowmaking.
Recent Posts
-
Building a Self-Hosted NWS Weather Alert Dashboard
How I built a real-time severe weather dashboard on my homelab using the NWS public API, PostgreSQL with PostGIS, Python, and Grafana — and what I learned about spatial SQL along the way.
-
Has Tornado Alley Shifted East? (And What I Actually Found)
A 75-year, 71,813-tornado analysis that started as a geographic question and ended somewhere more interesting — including a lesson about how single events distort rate comparisons.
-
Walmart Retail Sales Regression Analysis
Multiple regression analysis of 421,574 weekly sales records across 45 stores, improving predictive R² from 0.69 to 0.75 and quantifying the drivers of store performance.
-
Retail Store Performance Dashboard
Excel dashboard analyzing 4,266 transactions across three regional markets, surfacing a margin-versus-revenue insight that reframed the promotional strategy question.
-
Telecom Customer Churn Analysis
Diagnostic analysis of 3,335 telecom customer records revealing that churn is driven by usage intensity and service friction, not geographic clustering.
-
CMMC Level 1 Compliance Audit
A systematic security audit against CMMC Level 1 controls, producing structured assessment reports with findings, risk ratings, and remediation recommendations.