Business Leadership · Data
The Data branch of Business Leadership — the analytical work you use and look at. Business analysis, veteran employment data, process optimization, and KPI frameworks, built with real federal data, a structured methodology, and a focus on measurable outcomes.
Portfolio
Thirteen shipped deliverables across interactive tools, dashboards, SQL analysis, scenario modeling, model documentation, and process improvement. Each entry links to the live artifact.
Interactive Tool · County Map
An interactive map of every U.S. county showing veteran population, median income, employment, cost of living, VA benefits purchasing power, and a composite livability score. Six metric overlays, click-to-drill state-to-county navigation, built-in VA disability rate calculator, eighteen fields per county. Data from Census ACS, BEA, BLS, and VA — all federal public domain.
Open the Tool → Full-Screen →Interactive Tool · Tract Map
A five-domain weekly household basket cost (gas, pantry, plate, restaurant, composite) across all 50 states and 3,142 counties, with tract resolution inside fifteen mega-counties (~17,500 tracts) and 262 NYC Neighborhood Tabulation Areas. Built from EIA Weekly Retail Gasoline, BLS APU and CPI, USDA Thrifty Food Plan, and Census ACS5 — all federal public domain. Every value carries a provenance flag.
Read Case Study → Full-Screen →Interactive Tool · County Map
The fixed monthly shelter and family-cost nut at the county grain across all 3,222 U.S. counties plus Puerto Rico. Rent, mortgage, homeowner and renter insurance, childcare. ZIP search across 33,791 mapped ZIPs and a side-by-side two-county comparator. Data from Census ACS5, DOL National Database of Childcare Prices, and NAIC HO-3/HO-4 tables.
Read Case Study → Full-Screen →SQL · Python · SQLite
Federal contract spending analysis across FY2022–2024 measuring whether veteran-owned small businesses are winning their share of contract dollars. Five structured SQL queries against a USASpending.gov dataset: agency rankings via CTEs and RANK(), geographic running totals, industry opportunity gap with NTILE() quartiles, and year-over-year LAG() trend analysis.
Read Case Study → View on GitHub →SQL · Data Warehouse
A normalized SQLite warehouse built from this site’s two cost-of-living indexes — 3,222 counties of monthly shelter costs joined against 3,133 counties of weekly basket costs. Six analytical queries spanning multi-table joins, CTEs, and window functions (DENSE_RANK, LAG, NTILE), each answering a concrete affordability question with the full results shown.
Read Case Study →Model Card
Technical documentation for the weighted Binomial GLM trained on the Workforce Stability cohort. Covers cohort and universe, 47 features, 70/15/15 stratified split, held-out metrics, PWGTP-weighted calibration deciles, leading signals, and explicit out-of-scope uses.
Read Model Card →Case Study
A consulting-grade disaggregation of the 2.8% BLS veteran-unemployment headline. Six findings across era, disability status, age, industry, and recovery speed — with five evidence-based employer recommendations. Ships with an Excel workbook and twelve-slide deck.
Read Case Study →Live Dashboard
Interactive browser dashboard pulling live Bureau of Labor Statistics data through a server-side proxy. Tracks veteran versus overall unemployment from 2023 through 2026, with KPI tiles and month-over-month deltas.
Open the Dashboard →Exploratory Dashboard
The exploratory HTML dashboard that preceded the case study. Full table views and raw BLS figures across unemployment rates, industry distribution, and education impact. Retained for research-trail transparency.
View Dashboard →Process Improvement
A real-world After Action Review and Six Sigma DMAIC analysis of the web publishing pipeline. Covers 5 Whys root-cause analysis, Pareto defect analysis, a reusable process checklist with verification gates, and a KPI framework for continuous improvement.
View Analysis → The DMAIC Framework →Excel Workbook
An Excel workbook for tracking process improvement metrics over time. Process log, KPI dashboard with six live-formula metrics, improvement log, and a step-by-step process checklist with time estimates and verification gates.
Download Workbook →Excel Workbook · Scenario Model
An advanced-Excel scenario planner built on the TSCI county dataset. Pick any of 3,222 counties, toggle renter or owner, set children in care and take-home income — dependent dropdowns, INDEX/MATCH lookups, named ranges, and conditional formatting compute the monthly cost nut, the cost-to-income ratio, a two-county comparison, and an income-sensitivity sweep with charts. Over 9,700 live formulas, zero pasted values.
Download Workbook →Excel Dashboard
Interactive Excel dashboard tracking monthly veteran unemployment data from 2023 through 2026. Hero KPIs, 37 months of data across four worksheet tabs, and trend analysis using verified BLS figures.
Download Dashboard →This is the Data branch — the analytical output. The Projects branch shows how that work was led: the program hub, four program sub-pages, and the downloadable PM artifacts — charter, executive deck, risk register, after-action review. The Workforce Stability and VRSI case studies sit there, as the analytical depth behind those programs.
Tools & Stack
Every skill claimed here links to the artifact that proves it. No receipts, no row.
| Skill | Proof on this site | Tooling |
|---|---|---|
| SQL | Cost-of-Living SQL Warehouse · VOSB Contracts Analysis | SQLite · CTEs · window functions · indexing |
| Python | Retention Logit Model Card · TSCI data pipeline | pandas · scikit-learn · requests |
| Excel | Household Cost Scenario Model · KPI Tracker · BLS Dashboard | INDEX/MATCH · scenario & what-if analysis · conditional formatting |
| Dashboards & Visualization | BLS Live Dashboard · VLI · TCBI · TSCI interactive maps | Custom JS components · live federal APIs · Tableau Public (in progress) |
| Statistical Modeling | Retention Logit Model Card · Workforce Stability case study | Logistic regression · calibration · model cards |
| Process Improvement | AAR + DMAIC case study · DMAIC framework · KPI Tracker | Six Sigma Black Belt · DMAIC · AAR · Pareto · 5 Whys |
| API Integration | BLS server-side proxy · Census ACS refresh pipeline (TSCI) | REST · PHP proxies · key management |
| Version Control | VOSB analysis on GitHub · SQL warehouse repo (publish pending) | Git · GitHub |
Approach
Every project in this branch follows a structured methodology grounded in real-world practice.
Work Together
These projects reflect how I approach analysis — structured, evidence-based, and built to last. If you're looking for a BA/DA who brings that discipline to your team, let's talk.