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
Eleven shipped deliverables across interactive tools, dashboards, SQL analysis, 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 →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 →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 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
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.