{"id":309,"date":"2013-08-25T21:14:04","date_gmt":"2013-08-25T15:44:04","guid":{"rendered":"http:\/\/ucanalytics.com\/blogs\/?p=309"},"modified":"2016-09-12T14:13:49","modified_gmt":"2016-09-12T08:43:49","slug":"seven-advanced-analytics1-0-solutions-loan-portfolios","status":"publish","type":"post","link":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/","title":{"rendered":"7 Advanced-Analytics Solutions for Loan Portfolios"},"content":{"rendered":"<hr \/>\n<h2><span style=\"color: #3366ff;\">Year-One of Analytics &#8211; A Crucial Juncture<\/span><\/h2>\n<div id=\"attachment_314\" style=\"width: 213px\" class=\"wp-caption alignright\"><a href=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg\"><img aria-describedby=\"caption-attachment-314\" data-attachment-id=\"314\" data-permalink=\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/1-batman\/\" data-orig-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?fit=1536%2C2048&amp;ssl=1\" data-orig-size=\"1536,2048\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"1 Batman\" data-image-description=\"&lt;p&gt;The Dark Knight &#8211; by Roopam&lt;\/p&gt;\n\" data-image-caption=\"&lt;p&gt;The Dark Knight &#8211; by Roopam&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?fit=225%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?fit=640%2C853&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\" wp-image-314 \" src=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?resize=203%2C270\" alt=\"The Dark Knight - by Roopam\" width=\"203\" height=\"270\" srcset=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?resize=225%2C300&amp;ssl=1 225w, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?resize=768%2C1024&amp;ssl=1 768w, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?w=1536&amp;ssl=1 1536w, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Batman.jpg?w=1280 1280w\" sizes=\"(max-width: 203px) 100vw, 203px\" data-recalc-dims=\"1\" \/><\/a><p id=\"caption-attachment-314\" class=\"wp-caption-text\">The Dark Knight &#8211; by Roopam<\/p><\/div>\n<p>I am a big fan of the graphic novel \u2013 Batman: the Dark Knight Returns \u2013 by Frank Miller. I almost lost my faith in Batman after watching the utterly ridiculous television series from the 60s \u2013 based on camp aesthetic. Batman was more of a joker in that TV series. I must thank Frank Miller for bringing darkness back to Batman and reinstating my faith in the caped crusader. Recently, I read another Batman masterpiece by Frank Miller caller \u2018Year One\u2019. The book captures the beginning of Bruce Wayne\u2019s successful career as Batman. The year one is about performing several things right for a lasting and rewarding journey as the superhero.<\/p>\n<p>This has made me think about the year one of advanced analytics journey for an organization. I have been lucky in my career to be part of a few such initiatives, including designing and setting up advanced analytics center-of-excellence. The year one is of particular importance since it paves the way for an exciting and rewarding analytics journey for an organization. The primary purpose of Analytics is to positively influence the key-performance-indicators (KPIs) of the organization through intellectual rigor. Eventually, analytics results need to monetize to measure the impact on the financials of the organization.<\/p>\n<h2><span style=\"color: #3366ff;\">Advanced-Analytics-1.0 Solutions for loan portfolios<\/span><\/h2>\n<div id=\"attachment_323\" style=\"width: 179px\" class=\"wp-caption alignright\"><a href=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Shylock.jpg\"><img aria-describedby=\"caption-attachment-323\" data-attachment-id=\"323\" data-permalink=\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/1-shylock\/\" data-orig-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Shylock.jpg?fit=958%2C1017&amp;ssl=1\" data-orig-size=\"958,1017\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"1 Shylock\" data-image-description=\"&lt;p&gt;Shylock &#8211; a Jewish moneylender &#8211; from Shakespeare&#8217;s The Merchant of Venice &#8211; by Roopam&lt;\/p&gt;\n\" data-image-caption=\"&lt;p&gt;Shylock &#8211; a Jewish moneylender &#8211; from Shakespeare&#8217;s The Merchant of Venice &#8211; by Roopam&lt;\/p&gt;\n\" data-medium-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Shylock.jpg?fit=282%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Shylock.jpg?fit=640%2C679&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\" wp-image-323 \" src=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Shylock.jpg?resize=169%2C180\" alt=\"1 Shylock\" width=\"169\" height=\"180\" srcset=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Shylock.jpg?resize=282%2C300&amp;ssl=1 282w, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-Shylock.jpg?w=958&amp;ssl=1 958w\" sizes=\"(max-width: 169px) 100vw, 169px\" data-recalc-dims=\"1\" \/><\/a><p id=\"caption-attachment-323\" class=\"wp-caption-text\">Shylock &#8211; a Jewish moneylender &#8211; from Shakespeare&#8217;s The Merchant of Venice &#8211; by Roopam<\/p><\/div>\n<p>A few months ago while having a cup of coffee in a restaurant I eavesdropped on a conversation between a boy and a girl. Both the kids were not more than 10 years old. There was a delicate negotiation of chocolates taking place between them. The girl with a handful of chocolates was ready to offer a chocolate to the boy with the condition that he will return three chocolates to her the next day. The boy was adamant about returning just two and no more. I could not wait there longer to learn the outcome of the negotiation. However, I could understand the reason why lending is referred to as the second oldest profession after prostitution. The concept of lending and earning some interest out of the principal in the near future is something kids could decipher.<\/p>\n<p>In this article, I have compiled a list of seven advanced analytics solutions for lending firms to initiate an advanced analytics journey. I am referring to these Analytics solutions version-1.0 to emphasize that there lie exciting times, strategic thinking and analytical rigor in the subsequent years to follow the year-one.<\/p>\n<h4><span style=\"color: #3366ff;\">A simple Cash-Flow Model for Loan Portfolios<\/span><\/h4>\n<p>Before discussing the analytics solutions in some detail, let us create a simplistic cash-flow model for a lending firm. There are a couple of reasons for creating this cash flow model, firstly, to understand the primary functioning of a lending firm. Moreover, we would like to link our solutions and their impact on the overall monetary engine of the institution. A very simplistic model for a loan will have the following components:<\/p>\n<div id=\"attachment_332\" style=\"width: 310px\" class=\"wp-caption alignright\"><a href=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow.jpg\"><img aria-describedby=\"caption-attachment-332\" data-attachment-id=\"332\" data-permalink=\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/1-cash-flow\/\" data-orig-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&amp;ssl=1\" data-orig-size=\"180,164\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"1 cash flow\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=300%2C272&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&amp;ssl=1\" decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-332 \" src=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow.jpg?resize=300%2C272\" alt=\"1 cash flow\" width=\"300\" height=\"272\" data-recalc-dims=\"1\" \/><\/a><p id=\"caption-attachment-332\" class=\"wp-caption-text\">Schematic of cash flow for loan portfolios<\/p><\/div>\n<p><strong>1. Cost of Acquisition:<\/strong>\u00a0the cost incurred by the financial institution to procure a customer<br \/>\n<strong>2. Fee Income:<\/strong> the fees that the institution charges to the customer to process her loan application<br \/>\n<strong>3. Operational Cost\u00a0(application):<\/strong> the operational cost incurred by the institution while processing an application form. The cost of acquisition and operational cost is covered to some extent by the processing fees.<br \/>\n<strong>4. Interest Income:<\/strong> income that the institution earns through monthly installments (EMIs)<br \/>\n<strong>5. The cost of Fund (interest expense):<\/strong> the money that the institution has lent out to the borrowers is received from the equity holders and debtors. The predominant sum usually comes from the debtors. The premium expected on the fund by the investors is the cost of fund.<br \/>\n<strong>6. The probability of Loss \/ Default:<\/strong> the primary source of risk in the lending business is borrowers&#8217; inability or unwillingness to repay the loans. This risk is also known as credit risk.<br \/>\n<strong>7. The probability of Prepayment:<\/strong> another risk that affects a loan portfolio is the prepayment risk, which creates a mismatch in cash flow. This is common for home loans because of their long tenure. The primary reason for this risk is principal&#8217;s balance transfer (BT) to other lenders.<\/p>\n<h2><span style=\"color: #3366ff;\">7 Advanced-Analytics-1.0 Solutions for loan portfolios<\/span><\/h2>\n<p>I would propose the following solutions,\u00a0as a part of Analytics 1.0, for lending firms in the year-one of the analytics journey.<\/p>\n<p>1. Customer Segmentation<br \/>\n2.\u00a0Cross \/ up sell (Customer onboarding)<br \/>\n3. Application \/ credit scorecard<br \/>\n4. Behavioral Scorecard<br \/>\n5. Loan-loss-provisioning model<br \/>\n6. Prepayment \/ customer churn model<br \/>\n7. Customer\/ portfolio value<\/p>\n<p>We will explore these solutions in some details in the subsequent articles of this series. See you soon!<\/p>\n<h4><span style=\"color: #3366ff;\">Sign-off Remark<\/span><\/h4>\n<p>I wish your year-one of analytics results in a glorious and lasting journey as it did for the legendary dark knight. Trust me they all have tremendous potential!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Year-One of Analytics &#8211; A Crucial Juncture I am a big fan of the graphic novel \u2013 Batman: the Dark Knight Returns \u2013 by Frank Miller. I almost lost my faith in Batman after watching the utterly ridiculous television series from the 60s \u2013 based on camp aesthetic. Batman was more of a joker in<\/p>\n<p><a class=\"excerpt-more blog-excerpt\" href=\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/\">Read More&#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":332,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_newsletter_tier_id":0,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[64,66],"tags":[8,7,6,10],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>7 Advanced-Analytics Solutions for Loan Portfolios &ndash; YOU CANalytics |<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"7 Advanced-Analytics Solutions for Loan Portfolios &ndash; YOU CANalytics |\" \/>\n<meta property=\"og:description\" content=\"Year-One of Analytics &#8211; A Crucial Juncture I am a big fan of the graphic novel \u2013 Batman: the Dark Knight Returns \u2013 by Frank Miller. I almost lost my faith in Batman after watching the utterly ridiculous television series from the 60s \u2013 based on camp aesthetic. Batman was more of a joker inRead More...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/\" \/>\n<meta property=\"og:site_name\" content=\"YOU CANalytics |\" \/>\n<meta property=\"article:author\" content=\"roopam\" \/>\n<meta property=\"article:published_time\" content=\"2013-08-25T15:44:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-09-12T08:43:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&#038;ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"180\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Roopam Upadhyay\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\",\"name\":\"YOU CANalytics\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#logo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120\",\"contentUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120\",\"width\":607,\"height\":120,\"caption\":\"YOU CANalytics\"},\"image\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#website\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/\",\"name\":\"YOU CANalytics |\",\"description\":\"Explore the Power of Data Science\",\"publisher\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ucanalytics.com\/blogs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1\",\"width\":180,\"height\":164},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#webpage\",\"url\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/\",\"name\":\"7 Advanced-Analytics Solutions for Loan Portfolios &ndash; YOU CANalytics |\",\"isPartOf\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#primaryimage\"},\"datePublished\":\"2013-08-25T15:44:04+00:00\",\"dateModified\":\"2016-09-12T08:43:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ucanalytics.com\/blogs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"7 Advanced-Analytics Solutions for Loan Portfolios\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#webpage\"},\"author\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6\"},\"headline\":\"7 Advanced-Analytics Solutions for Loan Portfolios\",\"datePublished\":\"2013-08-25T15:44:04+00:00\",\"dateModified\":\"2016-09-12T08:43:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#webpage\"},\"wordCount\":829,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#organization\"},\"image\":{\"@id\":\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1\",\"keywords\":[\"Banking and Insurance Analytics\",\"Business Analytics\",\"Predictive Analytics\",\"Roopam Upadhyay\"],\"articleSection\":[\"Analytics Graffiti\",\"Banking Models\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#respond\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6\",\"name\":\"Roopam Upadhyay\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ucanalytics.com\/blogs\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g\",\"caption\":\"Roopam Upadhyay\"},\"description\":\"This blog contains my personal views and thoughts on predictive Analytics and big data. - Roopam Upadhyay\",\"sameAs\":[\"roopam\"],\"url\":\"https:\/\/ucanalytics.com\/blogs\/author\/roopam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"7 Advanced-Analytics Solutions for Loan Portfolios &ndash; YOU CANalytics |","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/","og_locale":"en_US","og_type":"article","og_title":"7 Advanced-Analytics Solutions for Loan Portfolios &ndash; YOU CANalytics |","og_description":"Year-One of Analytics &#8211; A Crucial Juncture I am a big fan of the graphic novel \u2013 Batman: the Dark Knight Returns \u2013 by Frank Miller. I almost lost my faith in Batman after watching the utterly ridiculous television series from the 60s \u2013 based on camp aesthetic. Batman was more of a joker inRead More...","og_url":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/","og_site_name":"YOU CANalytics |","article_author":"roopam","article_published_time":"2013-08-25T15:44:04+00:00","article_modified_time":"2016-09-12T08:43:49+00:00","og_image":[{"width":180,"height":164,"url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1","type":"image\/jpeg"}],"twitter_misc":{"Written by":"Roopam Upadhyay","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/ucanalytics.com\/blogs\/#organization","name":"YOU CANalytics","url":"https:\/\/ucanalytics.com\/blogs\/","sameAs":[],"logo":{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/#logo","inLanguage":"en-US","url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120","contentUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/11\/YOU-CANalytics-Logo.jpg?fit=607%2C120","width":607,"height":120,"caption":"YOU CANalytics"},"image":{"@id":"https:\/\/ucanalytics.com\/blogs\/#logo"}},{"@type":"WebSite","@id":"https:\/\/ucanalytics.com\/blogs\/#website","url":"https:\/\/ucanalytics.com\/blogs\/","name":"YOU CANalytics |","description":"Explore the Power of Data Science","publisher":{"@id":"https:\/\/ucanalytics.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ucanalytics.com\/blogs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#primaryimage","inLanguage":"en-US","url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1","width":180,"height":164},{"@type":"WebPage","@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#webpage","url":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/","name":"7 Advanced-Analytics Solutions for Loan Portfolios &ndash; YOU CANalytics |","isPartOf":{"@id":"https:\/\/ucanalytics.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#primaryimage"},"datePublished":"2013-08-25T15:44:04+00:00","dateModified":"2016-09-12T08:43:49+00:00","breadcrumb":{"@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ucanalytics.com\/blogs\/"},{"@type":"ListItem","position":2,"name":"7 Advanced-Analytics Solutions for Loan Portfolios"}]},{"@type":"Article","@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#article","isPartOf":{"@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#webpage"},"author":{"@id":"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6"},"headline":"7 Advanced-Analytics Solutions for Loan Portfolios","datePublished":"2013-08-25T15:44:04+00:00","dateModified":"2016-09-12T08:43:49+00:00","mainEntityOfPage":{"@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#webpage"},"wordCount":829,"commentCount":1,"publisher":{"@id":"https:\/\/ucanalytics.com\/blogs\/#organization"},"image":{"@id":"https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1","keywords":["Banking and Insurance Analytics","Business Analytics","Predictive Analytics","Roopam Upadhyay"],"articleSection":["Analytics Graffiti","Banking Models"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ucanalytics.com\/blogs\/seven-advanced-analytics1-0-solutions-loan-portfolios\/#respond"]}]},{"@type":"Person","@id":"https:\/\/ucanalytics.com\/blogs\/#\/schema\/person\/55961a1cea272ecdf290cb387be069b6","name":"Roopam Upadhyay","image":{"@type":"ImageObject","@id":"https:\/\/ucanalytics.com\/blogs\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/dd1aa0b0e813f7639800bcfad6a554f1?s=96&d=mm&r=g","caption":"Roopam Upadhyay"},"description":"This blog contains my personal views and thoughts on predictive Analytics and big data. - Roopam Upadhyay","sameAs":["roopam"],"url":"https:\/\/ucanalytics.com\/blogs\/author\/roopam\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/08\/1-cash-flow-e1377534190655.jpg?fit=180%2C164&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3L0jT-4Z","jetpack-related-posts":[{"id":11933,"url":"https:\/\/ucanalytics.com\/blogs\/how-data-science-will-shape-post-covid-banking-video-discussion\/","url_meta":{"origin":309,"position":0},"title":"How data science will shape post-COVID banking? &#8211; Video Discussion","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"How data science will shape post-COVID banking? had a thought-provoking discussion with\u00a0FrankBanker: https:\/\/www.youtube.com\/watch?v=o-3uPgjSFSY&feature=youtu.be 02:01 (Part 1) Impact on variables in Credit Models05:33 (Part 2) Are we going back to Judgemental Lending?07:50 (Part 3) Evaluating analytics readiness of Banks12:20 (Part 4) Is \u2018IT\u2019 the right place for Data Analytics?14:15 (Part 5)\u2026","rel":"","context":"In &quot;Marketing Analytics&quot;","block_context":{"text":"Marketing Analytics","link":"https:\/\/ucanalytics.com\/blogs\/category\/marketing-analytics\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2020\/07\/Data-Analytics-for-Banking-FB.jpg?fit=788%2C444&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2020\/07\/Data-Analytics-for-Banking-FB.jpg?fit=788%2C444&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2020\/07\/Data-Analytics-for-Banking-FB.jpg?fit=788%2C444&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2020\/07\/Data-Analytics-for-Banking-FB.jpg?fit=788%2C444&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2783,"url":"https:\/\/ucanalytics.com\/blogs\/in-conversation-with-eric-siegel-author-predictive-analytics\/","url_meta":{"origin":309,"position":1},"title":"In Conversation with Eric Siegel: Author &#8216;Predictive Analytics&#8217;","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"In Conversation with.. Today we are starting a new series on YOU CANalytics called 'in conversation with'. In this series we will talk to the leaders and experts of predictive analytics and big data to gain deeper insight into the field. Dr. Eric Siegel Our first guest for the series\u2026","rel":"","context":"In &quot;Events &amp; Interviews&quot;","block_context":{"text":"Events &amp; Interviews","link":"https:\/\/ucanalytics.com\/blogs\/category\/events-and-interviews\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/12\/Slide15.jpg?fit=290%2C210&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":281,"url":"https:\/\/ucanalytics.com\/blogs\/credit-scorecards-predictive-analytics-part-7\/","url_meta":{"origin":309,"position":2},"title":"Credit Scorecards &#8211;  Business Integration of Predictive Analytics (part 7 of 7)","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Columbus - A lesson in Leadership Christopher Columbus \u2013 I have adored this man for various reasons at various stages of my life. At seven, I adored him because his mistakes were applauded and became part of history \u2013 Columbus mistook Native Americans for Indians because he thought he had\u2026","rel":"","context":"In &quot;Credit Risk Analytics Series&quot;","block_context":{"text":"Credit Risk Analytics Series","link":"https:\/\/ucanalytics.com\/blogs\/category\/risk-analytics\/credit-risk-analytics-series\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/7-Leader-225x300.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":8,"url":"https:\/\/ucanalytics.com\/blogs\/credit-scorecards-part-1\/","url_meta":{"origin":309,"position":3},"title":"Credit Scorecards &#8211; Introduction (part 1 of 7)","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Credit Scorecards in the Age of Credit Crisis This incident took place at a friend\u2019s party circa 2009, in the backdrop of the worst financial crisis the planet has seen for a long time. The average Joe on the street was aware of terms such as mortgaged-backed securities (MBS), sub-prime\u2026","rel":"","context":"In &quot;Credit Risk Analytics Series&quot;","block_context":{"text":"Credit Risk Analytics Series","link":"https:\/\/ucanalytics.com\/blogs\/category\/risk-analytics\/credit-risk-analytics-series\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/12\/Slide7.jpg?fit=290%2C210&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":6402,"url":"https:\/\/ucanalytics.com\/blogs\/r-vs-python-comparison-and-awsome-books-free-pdfs-to-learn-them\/","url_meta":{"origin":309,"position":4},"title":"R vs Python &#8211; a Comparison, and Awesome Free Books to Learn these Languages","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Please read the disclaimer about the Free PDF Books in this article at the bottom The one thing they love more than a hero is to see a hero fail, fall, die trying. In spite of everything you've done for them, eventually, they will hate you [Spider-Man]. - Green Goblin\u2026","rel":"","context":"In &quot;Analytics Book Club&quot;","block_context":{"text":"Analytics Book Club","link":"https:\/\/ucanalytics.com\/blogs\/category\/analytics-book-club\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/10\/Superman-V-Batman.jpg?fit=640%2C468&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/10\/Superman-V-Batman.jpg?fit=640%2C468&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2015\/10\/Superman-V-Batman.jpg?fit=640%2C468&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":55,"url":"https:\/\/ucanalytics.com\/blogs\/credit-scorecards-advanced-analytics-part-4\/","url_meta":{"origin":309,"position":5},"title":"Credit Scorecards &#8211; Advanced Analytics (part 4 of 7)","author":"Roopam Upadhyay","date":false,"format":false,"excerpt":"Modeling in Advanced Analytics The room, full of Analysts, erupts with a loud round of laughter when a young business analyst narrates to us an incident from his recent trip back home. A distant aunt inquired about his new profession. His response \u2013 I am into modeling. She got all\u2026","rel":"","context":"In &quot;Credit Risk Analytics Series&quot;","block_context":{"text":"Credit Risk Analytics Series","link":"https:\/\/ucanalytics.com\/blogs\/category\/risk-analytics\/credit-risk-analytics-series\/"},"img":{"alt_text":"4. Scorecard Simple","src":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/ucanalytics.com\/blogs\/wp-content\/uploads\/2013\/07\/4.-Scorecard-Simple1.jpg?resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts\/309"}],"collection":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/comments?post=309"}],"version-history":[{"count":0,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/posts\/309\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/media\/332"}],"wp:attachment":[{"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/media?parent=309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/categories?post=309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ucanalytics.com\/blogs\/wp-json\/wp\/v2\/tags?post=309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}