Quantitative Finance Analyst Portfolio | Quantitative Analysis

R & R Studio projects

Population data analysis by income, education level, gender, and employment formality using ENOE data from INEGI, Mexico.

Dashboard on Microsoft Excel | Example 1

I built this dashboard to track hiring performance across different warehouse locations.
It brings together the key numbers I cared about, total hires, placements, releases, and turnover rate, all in one view, so you can get the full picture at a glance.
I also added a comparison against a benchmark location to see which warehouses were over- or under-performing, a breakdown of hires by role, and a turnover trend over six months.
The area and warehouse filters make it easy to drill down into specific segments, and I used conditional formatting (red/green) to make it obvious right away where performance is above or below the national average.

Note: all data shown here is fictional — this was a practice exercise to work on my dashboard design skills in Excel.

Dashboard on Microsoft Excel | Example 2

I put this dashboard together to compare different salary adjustment plans for a company, looking at cost impact from a few angles. It shows the current total payroll cost alongside the cost of implementing two different plans, so it's easy to see the percentage increase each option would mean. I also broke down current costs by performance rating and by department, and added filters for area and salary band to let you drill into specific slices of the data.

Note: all data shown here is fictional — this was a practice exercise to work on my dashboard design skills in Excel.

Dashboard on Microsoft Excel | Example 3

This one was built to track budget vs. actual spend on a monthly basis, with a bridge analysis explaining the gap between what was budgeted and what was actually spent. It breaks the variance down by department and by project, highlighting the biggest cost drivers behind each difference (like renewal delays or unmet vendor agreements). I also added a monthly cost trend chart and filters by project and subcategory to make it easy to explore specific areas in more detail.