Advanced Data Modeling for Performance | Dataford Interview Questions

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

Return one row per business unit for January 2025.
Include unit_name, actual_value, target_value, variance, performance_status, and shortfall_rank.
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.

business_units

Column	Type	Description
unit_idPK	INT	Unique business-unit identifier
unit_name	VARCHAR(100)	Business-unit name
business_line	VARCHAR(80)	Citi business line

performance_results

Column	Type	Description
result_idPK	INT	Unique performance result identifier
unit_id	INT	Business unit associated with the result
performance_month	DATE	First day of the reporting month
metric_name	VARCHAR(80)	Performance metric name
actual_value	NUMERIC(12,2)	Observed performance value

performance_targets

Column	Type	Description
target_idPK	INT	Unique target identifier
unit_id	INT	Business unit associated with the target
performance_month	DATE	First day of the target month
target_value	NUMERIC(12,2)	Target performance value

Your question is Advanced Data Modeling for Performance. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.