Advanced Data Modeling for Performance

Describe a time you utilized advanced data modeling techniques to solve a specific business performance issue at Citi.

For this hands-on version, use the supplied Citi performance tables to calculate monthly actuals against targets and identify performance gaps.

Output

1. Return one row per business unit for January 2025.
2. Include unit_name, actual_value, target_value, variance, performance_status, and shortfall_rank.
3. Include business units without actual activity or a target, sort by largest shortfall first, and place units without targets last. Break ties alphabetically by unit_name.