Loading problem...
5279. Credit Card Utilization Risk Report
00:00
5279. Credit Card Utilization Risk Report
HardSQLITE318 / 1625
Business Problem
You are a Credit Risk Analyst at Capital One. The credit portfolio team needs a utilization risk report for all active credit cards. For each card, you must compute the utilization percentage and classify it into a risk tier, then cross-reference the customer's risk rating to recommend an action.
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to ProRelevant companies
Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Tags
#cte#case-when#join#round#banking#risk
5279. Credit Card Utilization Risk Report
Hard318 / 1625
Business Problem
You are a Credit Risk Analyst at Capital One. The credit portfolio team needs a utilization risk report for all active credit cards. For each card, you must compute the utilization percentage and classify it into a risk tier, then cross-reference the customer's risk rating to recommend an action.
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to ProRelevant companies
Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Tags
#cte#case-when#join#round#banking#risk
Premium Content
This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,625 questions.
Upgrade to Pro