How do I approach Analytics & Experimentation interview questions?

Analytics & Experimentation questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master analytics & experimentation interviews.

What difficulty level is this interview question?

This is a medium difficulty Analytics & Experimentation question, commonly asked during Technical Screen rounds at Citibank.

What role is this question designed for?

This question is commonly asked for Data Scientist candidates at Citibank during technical interviews.

Design Excel visuals for risk results

Last updated: Mar 29, 2026

Quick Overview

This question evaluates proficiency in Excel-based data visualization, credit risk analytics, and dashboard design for communicating expected loss (EL), risk-weighted assets (RWA), and concentration risk from loan-level datasets.

Citibank

Jul 26, 2025, 12:00 AM

Data Scientist

Technical Screen

Analytics & Experimentation

Excel Dashboard Design: Communicating EL, RWA, and Concentration Risk

Context

You are preparing an Excel dashboard for a credit portfolio review that must clearly communicate:

Expected Loss (EL)
Risk-Weighted Assets (RWA)
Concentration risks across obligors, sectors, regions, and ratings

Assume you have a loan-level dataset with at least these fields: Date, Obligor_ID, Obligor_Name, Sector, Region, Rating, PD, LGD, EAD, EL (or PD/LGD/EAD from which EL can be computed), RWA, Collateral_Type, and Portfolio/Book.

Task

Design a set of Excel visuals (PivotTables, charts, heatmaps) to communicate the portfolio's EL, RWA, and concentration risks. For each visual, specify:

The PivotTable layout (Rows, Columns, Values, Filters) and any slicers.
Measures/calculations used (with formulas if needed).
The chart/formatting applied.
Why this view aids decision-making.

Provide a concise, actionable plan suitable for a technical screen.

Solution

Show

Comments (0)

Loading comments...

Browse More Questions

More Analytics & Experimentation•More Citibank•More Data Scientist•Citibank Data Scientist•Citibank Analytics & Experimentation•Data Scientist Analytics & Experimentation