Selected work
What we’ve actually shipped.
A sample of dashboards, ETL pipelines, and desktop apps we’ve built — across rangeland ecology, university research, sports analytics, and small-business operations.
EcoPlot Mobile · Field data-collection app (in development)
Azure Static Web App - Mobile + Offline - Hosted SQL database
A modern, cloud-hosted re-imagining of the VGS vegetation data collection — built as an Azure Static Web App with a managed SQL backend so field crews and office analysts can collect, edit, and review ecological data from any device, with no installer required. Same protocols VGS Desktop supports (point ground cover, line point intercept, frequency frames, etc.), with customization options.
VGS Batch Importer · ETL pipeline for rangeland data
ETL & QA R Shiny SQLite USFS / Agriculture
ETL pipeline (built in R) that ingests historical Excel datasheets into a SQLite database for VGS - Data collection software system used across USFS rangelands. Supports multiple protocols (point ground cover, line intercept, nested frequency) with embedded QA checks that catch corrupt or incomplete rows before they hit the database.
Highlights: USDA species-code validation across all 50 states, USFS shapefile-based site renaming (Region → Forest → Ranger District → Allotment → Pasture), batch-import of dozens of Excel files at once, automated comparison and correlation reports.
VGSLite · Desktop helper app (Electron .exe)
Desktop app Electron + R SQLite
Installable Windows .exe that ships alongside VGS Desktop to clean orphan data links, move events between sites, empty deletion caches, and resolve sync issues. Built in R, packaged with Electron, distributed as a signed installer.
Highlights: offline-first, embedded SQLite, one-click install, used by field crews on remote rangeland projects.
Big-12 Talent Pathways · Sports recruiting dashboard
Dashboard R Shiny Web scraping Sports analytics
Interactive Shiny app that visualizes Big-12 football and basketball recruiting classes — including a map of distance traveled from each recruit’s high school to their college destination, and scatter plots showing distance-traveled trends over time.
Highlights: custom web-scraping pipeline pulling from 247Sports / On3, geocoding for distance calculations, drill-down by team and class year, multi-year class-rating comparisons.
Featured analyses
This box plot examines how far football recruits travel to join Big 12 football programs and whether that distance changed in the most recent recruiting cycle. Each symbol represents the distance a recruit traveled from their high school to their college (indicated by the logos on the left). Circles represent recruits for the 2025 season, while x symbols represent recruits that have been targeted from earlier classes (2016–2024). The plot is ordered from top to bottom by smallest median distance (thick black line in each box plot). Twenty-eight extreme outliers (~1% of data) were excluded for clarity. Texas schools tend to draw recruits from shorter distances and have relatively low medians: Baylor (163 miles), Houston (179 miles) and TCU (221 miles). BYU, Arizona, Arizona State and Utah have higher medians ranging from 350–600 miles, largely driven by recruits from Hawaii. Overall, recruiting distance patterns appear relatively stable over time, with the 2025 class showing similar distance traveled to previous years — the one notable exception being UCF, which had no recruits from California in 2025.
These tables summarize how recruiting talent has changed over time by region and position group. Players were assigned to regions based on the state where they attended high school. Recruits from outside the United States, as well as those who did not fall into selected position groups, were excluded for clarity. Table A uses average player scores to assess how talent has changed over time. All regions showed increases in average scores for both position groups, as seen by the darker colors in the more recent years. The Northeast recorded the highest average score in 2025 (89.3), although this reflects only three rated recruits for that year. Table B uses total counts of rated players to show talent changes in volume over time. The year 2025 was excluded because it does not represent a full three-year grouping. The Southwest and West had the most rated recruits (993 and 750 respectively), followed by the Southeast (616), Midwest (544) and Northeast (98). Overall, the number of rated recruits has declined over time while average ratings have increased — which could be due to more selective recruiting and/or changes in how players have been rated over time.
Small Mammal Tracker · Ecological research dashboard
Dashboard R Shiny NEON open data University research
Shiny app that uses NEON open data to compare small-mammal capture data across sites. Researchers pick a location + date range and see individuals ranked by capture frequency, capture-history timelines, and site-level summaries.
Highlights: integrates a federal open-data API, individual-animal capture-history tracking, reproducible site comparisons, geographic capture mapping.
Water Chemistry Analyte Viewer · NEON dashboard
Dashboard R Shiny Environmental data
Shiny app comparing surface-water analyte concentrations across NEON sites — used by researchers and students to explore water-quality patterns across the U.S. observatory network.
Plants In Movies · Biodiversity visualization
Dashboard R Shiny Data storytelling
A chord-diagram dashboard that compares the flora of U.S. states to the fictional worlds of Dune, Lord of the Rings, and Jurassic Park — a fun demo of how the same dashboarding toolkit can drive both serious research and public engagement.
Want to see something similar built for your data?
The best case study is the one we build for you. Tell us your problem and we’ll scope it.
