Work from my internship at JLL and coursework at MSU Mankato.
JLL Retail Corporate Services · Fall 2024
This was the biggest thing I worked on during the internship. JLL's franchise development team tracks hundreds of sites across the country for clients like restaurant chains — each site moves through stages like site selection, lease negotiation, and build-out. The team needed a way to see where everything stood without digging through a database.
I built a six-dashboard Tableau workbook connected live to JLL's Oneview SQL database. The main overview shows active pipeline with stage-duration stoplight indicators — green if a site is on track against a 60-day target, red if it's stalled. A site selection map lets you draw a radius and see how many potential sites fall within it, alongside comparable lease data from nearby deals. The comp dashboard surfaces negotiated rent per sqft, TI allowances, and site sizes benchmarked against market averages, all filterable by client, state, quarter, and year. I wrote the LOD calculations in Tableau to get the "difference from average" logic working correctly across different filter contexts.
JLL Retail Corporate Services · Fall 2024
JLL's team tracks commercial net lease properties across Texas for market intelligence — clients want to know what cap rates look like, how many listings are hitting the market each quarter, and what the investment grade mix is. This was a two-page Tableau dashboard covering Houston specifically and all of Texas statewide.
Each page shows cap rate trends in both bar and line form so you can see the shape of the market over time, plus remaining lease term distribution, investment grade vs. non-investment grade breakdown, and a QoQ change indicator with a directional arrow that flips color based on whether volume went up or down. I wrote the inclusion logic to filter to prior-year listings and built the percentage change calculations from scratch since Tableau doesn't do that automatically across time periods without table calculations.
MSU Mankato · Spring 2026
Course project built around a supply chain dataset with order, customer, and shipping data. I built a two-page Power BI report — an executive summary and a shipping performance deep-dive — starting from a raw CSV and doing all the data modeling and transformation in Power Query before writing the DAX measures.
The executive page covers total revenue, order volume, average order value, revenue by product category, and a geographic breakdown using Azure Maps. The shipping page is where it got more interesting — I tracked on-time percentage, late shipment count, and average delay days for late shipments only (not all shipments, which would dilute the number). I also compared scheduled vs. actual shipping days at the order level so you could see where the gaps were happening. The whole model is built on a FACT_ORDER_DETAILS table with dimension relationships set up in the model view.
JLL Retail Corporate Services · Fall 2024
One of the more unusual things I built during the internship. Franchisees evaluating commercial real estate need to compare the long-term cost of leasing space against buying it outright, and that math gets complicated fast once you factor in vacancy, depreciation, loan amortization, and capital gains on a future sale.
I built a reusable Excel model with two versions — one that accounts for vacancy and one that doesn't, since not all properties have that exposure. You plug in purchase price, loan terms, rent escalation rate, expense growth, and a discount rate, and it runs a 10-year cash flow projection for both scenarios side by side with NPV and IRR outputs. The goal was something a franchisee could actually use themselves, so I kept the inputs clearly labeled and the outputs in plain language.
MSU Mankato · Spring 2026
Group database project where we designed and built a full university registration system from scratch in MySQL. I handled the schema design, triggers for enforcing enrollment constraints, stored procedures for common queries, and role-based access control separating what students, faculty, and admins could see and do. Probably the most hands-on SQL work I did outside of the internship.