DFW Tuition & Scholarship Study

Data Analyst Intern · 2026

A ten-year look at tuition across 35+ Dallas–Fort Worth universities, built to answer a question a scholarship board had never put numbers to: what is an award actually worth now?

  • Pulled and reconciled a decade of tuition data across 35+ institutions using Excel, pivot tables, and API data dumps.
  • Adjusted award sizing for purchasing power rather than headline tuition.
  • Presented the methodology and recommendation to the executive board and defended it in Q&A.
  • The resulting budget recommendation contributed to a 60% increase in both the scholarship budget and the size of each award, for every year going forward.
  • Excel
  • PivotTables
  • Purchasing power
  • Board presentation

Want the detail behind any of it?

Happy to walk through the methodology, the data, or what I’d do differently now.

Get in touch