Vendor

Overview

This is a follow up to Big Data Strategy & Roadmap - Our Data Journey blog and the focus is on different use cases that Treselle System's engineering team identified to demonstrate the basic power of Machine Learning (ML) and predictive analytics that Credit Unions can apply on their Member's data. The models are kept simple but insightful on purpose so that it is easy to understand for different CU stakeholders.

Please note that this is a mock data which was bit altered so that it is suitable for ML purpose.

Use Case 1: Member Segmentation by Product

Description:

  • The objective is to understand how members are associated with different products (Checking, Savings, Auto, Home, Personal, Credit) and apply clustering to identify patterns on how members are distributed and find certain clusters for targeted marketing.
  • K-means clustering algorithm was applied and identified 6 clusters based on member attributes such as products currently associated and the balance amount.
  • For each cluster, the product probability is calculated based number of product count.
  • Members in cluster 4 and 5 have high percentage of Savings and Checking product types but very few Loan product types. This cluster can be used for promoting loan products.
  • Members in cluster 6 are strong in Savings account and can be targeted for Home Loans
  • Members in cluster 1 have higher loan products but less Savings account compared to other clusters. Its important to keep an eye on this cluster for any defaults or delinquencies
  • Click here for Demo URL

Use Case 2: Member Segmentation by Lifetime Value (LTV)

Description:

  • Member Life Time Value is calculated on the dataset by using Acquisition cost per member, Savings account interest, Loan interest and sum of yearly transaction & other service charges.
  • Categorized the members based on age group as (0-39) Generation Millennials, (39-53) Generation Xers, (53-72) Baby Boomers, (72-92) Silent Generation.
  • K-means clustering algorithm was applied and identified 4 different clusters. Some clusters have members from multiple generations and few clusters have members from single generation.
  • Observation:
    • 1st cluster members have high income and average CLV.
    • 2nd cluster members have high income and high CLV.
    • 3rd cluster members have less income and average CLV.
    • 4th cluster members have high income and less CLV.
    • Members in the cluster 1 & 4 are good segments to target and increase the profit
  • Click here for Demo URL

Use Case 3: Advanced Targeting: Propensity Scoring of Auto Loans

Description:

  • The objective of this use case is to filter all the members who have Auto Loan and train the machine learning model and apply this model on the members who don’t have Auto Loan to predict which members will opt for Auto Loan.
  • Logistic regression machine learning model was used to train the data.
  • Once the model was trained, the non auto loan members are used as test data and propensity scores are calculated for each members by using the trained classification model. This propensity score will give weight for each member that decides the probability of taking auto loans.
  • Observation: Members who have personal loans have high propensity to opt for Auto Loans.
  • Click here for Demo URL

Use Case 4: Model Comparison for Loan Eligibility

Description:

  • The objective of this use case is to use DTI (Debt-to-Income ratio) and Credit Score features and compare with multiple ML models to identify the good fit model.
  • 8 different machine learning models are applied on the dataset by splitting 70% & 30% to train and test the models and compared the accuracy. 
  • Once the model was trained, the test data was used to perform the prediction and finally compared the accuracy based on the confusion matrix output.
  • Among all models, Logistic Regression and Decision Tree was producing an accuracy of 88%.
  • Click here for Demo URL

E-mail me when people leave their comments –

You need to be a member of CULytics Community to add comments!

Join CULytics Community

Comments

  • CU Employee CULytics Founder

    Thanks Raghavan for this awesome post. All the use-cases mentioned above are directly relevant to CUs.

    Can you talk more about the operationalization and expected ROI that you have seen with these models?

    • Vendor

      Naveen,

      Note: Long reply.

      The tedious part is of course the data preparation and normalization. Below are our experiences running these sort of models on capital market industry:

      1. Energy Well Performance Projection: This is similar to Member Lifetime Value but for Energy drilling wells to perform the Estimated Ultimate Recovery (EUR) by applying multiple models such as Random Forest and Decision Trees to analyze individual oil and gas wells production data and predict production of individual and group of wells.

      ROI: This has become one of the main IP (Intellectual Property) of the platform and became an add-on feature which Portfolio Managers need to subscribe for this analytics outcome. This is the only platform in the industry to do such analysis on more than half a million drilling wells.


      Operational Details: The frequency of this data from multiple US states are from weekly to monthly and so to keep the cost low, we launch Hadoop + Spark ecosystem (4 node cluster) on-demand (AWS) bi-weekly and run this for half a million drilling wells that takes about few hours for data sanity check and preparation and 6 to 8 hours for running the models and shut them down later.

      2. Anamoly Detection of Stock Prices: This is similar to identifying outliers or anomalies or sort of frauds with respect to Banks & CUs which involves classification models such as Naive Bayes and Logistic Regression that identifies the anomalies or outliers from the source (S & P CapIQ dataset).

      ROI: Our Client's customers (Portfolio Managers) are subscribed to listen to these anomalies everyday and the system will trigger necessary events such as email to alert about the outliers. This is one of the interesting features of the platform that attracts many Portfolio Managers because its very hard to identify these outliers when they are monitoring 50 to 100 stocks of large volumes (several thousand dollars to millions).

      Operational Details: This is unlike the previous scenario where the model needs to run daily once the dataset arrives and are deployed on Reserved Hadoop & Spark ecosystem (8 node cluster) as it needs to process 8000 tickers and the computations are intensive due to backtesting capabilities.

      Finally, we do run other models just using R & Python on single node instances that are not very compute intensive. These perform clustering and recommendation machine learning algorithms.

      Off Topic: We are also in talks with couple of telecom clients and perform CDR (Call Detail Record) analysis as a PoC which gave a different perspective to these prospects of how to leverage their historical data.

      https://www.linkedin.com/pulse/deep-insights-call-detail-record-cdr...

      Hope this helps.

      Thanks,
      Raghu

    • CU Employee CULytics Founder

      Thanks for sharing.

This reply was deleted.

 

advantedge
altair
ibi
arka
trellance
coopfs
dfa
wherescape
alkami
prismacampaigns
marquis
aiq
totex
cnet
datava
aun
cinch
know

Related Post

 

Ad Unit Settings






Ad Url Settings

 

api-lead-approach
the-amazon-lending-experience
executing-advanced-analytics-do-s-and-don-t
lending-transformation-old-vs-new
data-journey-building-strong-analytical-practices
4-step-iterative-process-building-a-relevant-analytics-practice
significant-measures-towards-new-normal
building-a-strong-analytics-practice-recipe-for-success
data-warehouse-evaluation-and-implementation
explainable-ai-trust-and-transparency
forecasting
top-50-members-using-transactional-website-jun-2020
top-50-cus-with-highest-and-lowest-efficiency-june-2020
importance-of-financial-risk-management
secret-sauce-for-long-term-sustainable-business-intelligence-succ
top-pfm-technologies
secret-sauce-for-long-term-sustainable-business-intelligence-succ
top-pfm-technologies
data-warehouse-and-bi-technologies-opportunities-challenges
top-chatbot-technologies
keys-to-building-an-effective-branch-or-atm-network
top-50-credit-unions-with-highest-and-lowest-accounts-per-member
lowest-and-highest-net-income-per-branch
marketing-holy-grail
top-50-most-and-least-delinquent-credit-unions
modern-marketing-technologies
incremental-low-cost-data-driven-wins
power-of-storytelling
the-cost-of-not-investing-in-data-governance
questions-you-should-ask-before-investing-in-data-warehouse
learnings-from-new-data-based-on-auto-loan-pricing
5-questions-you-need-to-ask-before-investing-in-data-governance
digital-marketing-maturity-models-for-credit-unions
marketing-expense-per-member
top-2-reasons-that-are-holding-credit-unions-back-when-they-are-i
using-data-analytics-to-manage-lending-complexity-while-driving-h
5-reasons-your-credit-union-should-invest-in-data-and-digital-now
top-50-most-and-least-efficient-credit-unions
retail-financial-services-outlook-during-covid-19
use-of-operational-analytics-to-mitigate-the-impact-of-covid-19
top-50-credit-unions-based-on-asset-size
cu-peer-comparison-dashboard
cu-peer-benchmark
all-about-machine-learning-engineering
top-web-design-trends
most-important-social-media-marketing-trends
state-of-digital-marketing-maturing-in-credit-unions
top-kpis-for-email-marketing
data-cloud-and-the-digital-transformation-imperative
digital-trinity-and-you
phases-of-financial-industry
analytics-roundtable-workshop
invitation-to-join-digital-transformation-hub
analytics-in-the-credit-union-business
value-of-member-centricity-and-analytics-in-the-growth-of-cus
all-about-membership-analytics
top-fraud-management-technologies
getting-started-with-your-data-analytics-journey
explore-vizualization-for-credit-unions
investment-in-website-personalization-technologies
data-analytics-supporting-cu-s-first-member-philosophy
loyalty-rewards-and-retention-technologies
member-experience-analytics
channel-analytics-and-its-importance
project-portfolio-management-technologies
investment-in-self-service-data-preparation-technologies
self-service-data-preparation-technologies
new-frontier-in-customer-experience-management
role-of-marketing-analytics-in-credit-unions
important-aspects-of-consumer-lending-analytics
kpis-on-website-analytics
journey-towards-bank-less-banking
investment-in-crm-technologies
top-omni-channel-vendors
conversational-banking-solutions
/top-kpis-for-chief-information-officer
mistakes-to-avoid-when-implementing-a-omnichannel-member
top-things-to-consider-when-building-dashboards
making-digital-marketing-more-agile-through-tag-managers
cecl-solution-providers
mistakes-to-avoid-while-implementing-marketing-automation
p2p-payment-integrated-solutions
kpis-for-social-media-tracking
kpis-for-human-resources-management
investment-in-fintechs-should-or-should-not
top-kpis-for-online-banking
investment-in-marketing-automation-technologies
investment-in-e-signature-technologies-should-or-should-not
tips-and-tricks-to-a-successful-bi-program
kpis-for-credit-card-business
kpis-for-digital-marketing
kpis-for-consumer-lending
hot-topics-for-credit-union-data-leaders
kpis-for-debt-collections
kpis-for-finance
website-personalization-tools
data-integration-technologies
robotic-process-automation-tools
why-data-analytics-initiatives-fail
electronic-signature-softwares
data-governance-tools-for-credit-unions
digital-and-mobile-banking-technologies
report-inconsistencies-are-frustrating
is-your-culture-ready-for-data-analytics
three-big-data-myths
turning-transaction-data-into-a-goldmine-a-becu-case-study
call-for-presentation-for-2019-credit-union-analytics-summit-is-n
top-10-keys-to-successful-data-analytics-practice
credit-union-chooses-accountscore-for-open-banking-transaction-da
how-much-do-you-spend-to-serve-a-customer
marketing-automation-technologies-for-credit-union
alexa-ask-first-abilene-fcu-for-my-balance
dataweb-content-management-technologies-for-credit-unions
efficiency-ratio
web-analytics-technologies
data-warehousing-software-for-banks
customer-experience-software
the-best-kept-secret-for-credit-union-data-analytics
mark-sievewright-on-technology-trends
naveen-jain-on-credit-union-analytics-summit-2018
why-analytics-doesn-t-make-a-difference-by-gary-angel
cuas2018-harnessing-the-right-data
build-a-financial-phone-assistant-for-your-credit-union-in-3-step
2018-culytics-analytics-challenge-winner
update-from-naveen
error-resolution
benefits-of-conversational-apps
who-are-your-most-valuable-members-part-1
how-alexa-can-help-your-credit-union
top-10-kpis-for-measuring-retail-channel-performance
how-much-is-too-much-personalization
top-10-kpis-for-measuring-contact-center-efficiency
pressure-on-margins-for-auto-loans-indirect-auto-loans-declining
best-business-intelligence-technologies-for-credit-unions
establishing-a-thriving-data-analytics-practice-is-a-journey
educational-presentations-from-the-2017-axfi-conference
modelling-alternatives-for-cecl-a-deep-future-analytics-study
data-analytics-use-cases-for-credit-unions-infographic
data-analytics-opportunities-in-credit-union-business
loan-application-analytics-with-cufx
machine-learning-delivers-great-consumer-experiences
deep-insights-of-credit-union-members-data-with-machine-learning
web-analytics-reporting-tips-for-credit-unions
big-data-strategy-roadmap-our-data-journey
webinar-framework-for-member-focused-decision-making
too-many-regulations-hurt-credit-union-members
digital-marketing-automation-solutions
online-banking-boom
transformation-transactions-to-relationships
top-dispute-management-technologies
2020-retail-trends
future-of-artificial-intelligence
2020-culytics-summit-attendee-dashboard
repositioning-the-role-of-marketing
marketing-automation-a-step-towards-marketing-transformation
strategic-agility
using-data-to-navigate-through-the-new-normal
digital-transformation-bcu
highest-and-lowest-new-loan-balances-per-branch-as-of-jun-2020
-new-members-ratio-as-of-june-2020
cus-with-highest-and-lowest-loan-grants-per-member-june-2020
self-service-data-preparation-technologies
highest-and-lowest-marketing-expense-per-member-june-2020
the-amazon-lending-experience
api-lead-approach
4-step-iterative-process-building-a-relevant-analytics-practice
data-journey-building-strong-analytical-practices
post-election-the-cu-outlook
most-and-least-delinquent-credit-unions-sept-2020
leveraging-ach-data-to-produce-real-outcomes
member-engagement-scores-benefits
member-engagement-key-to-serve-the-best
story-of-james-an-intelligence-transformation
executive-kpis-the-pulse-of-the-organization
untangling-member-journey
onboarding-strategy-to-deliver-success
the-importance-of-digital-technologies
top-interactive-financial-calculators
using-artificial-intelligence-to-improve-your-productivity
organizational-transformation-to-drive-growth
multi-year-journey-through-data-transformation
top-50-cus-with-the-highest-and-lowest-member-per-branch
digital-transformation-lessons-through-the-eyes-of-a-ceo
organizational-readiness-for-digital-transformation
ruthless-prioritization-to-do-more-to-learn-more-and-to-earn-more
performance-measures-for-digital-services
analytical-maturity-journey-towards-growth
less-is-more-the-necessity-of-focus-for-strategic-success
solving-the-crm-mrm-puzzle
insights-driven-messaging-member-and-product-onboarding
performance-measures-for-marketing
data-insights-that-drive-member-product-innovation
solving-the-crm-mrm-puzzle
the-agility-flywheel-a-strategy-that-never-goes-out-of-the-way
artificial-intelligence-as-a-playing-field-for-credit-unions
performance-measures-for-call-centers
top-automl-technologies
performance-measures-for-lending
building-business-case-for-data-analytics
driving-innovation-and-change
data-analyze-decide-and-create
digital-readiness-important-steps-to-achieve
digital-readiness-important-steps-to-achieve
enabling-credit-unions-with-ai
culytics-virtual-summit-2022-a-resounding-success
culytics-virtual-summit-2022-day-1
digital-banking-roundtable
digital-marketing-roundtable
transformative-lessons-from-a-chief-digital-officer
data-analytics-roundtable-mar-11
rewind-2022-culytics-day-key-highlights
data-analytics-team-roles
data-warehouse-development
data-analytics-team-size
is-your-data-analytics-program-not-delivering-results
active-deposit-management-for-profitable-growth
data-modeling
maximize-your-success-with-2023-CULytics-summit
biggest-opportunities-for-credit-unions
should-ceos-attend-the-culytics-summit
the-cost-of-a-wrong-decision
biggest-roadblocks-in-becoming-data-driven
a-journey-for-all-organizational-maturity-levels
maximize-your-data-analytics-checkup
navigating-the-data-analytics-landscape
improving-data-literacy
why-credit-union-leaders-should-invest-in-their-teams
why-credit-unions-should-not-invest-in-building-predictive-models
why-should-measure-the-success-of-data-analytics-program
cost-of-choosing-the-wrong-data-analytics-technology-stack
why-data-analytics-strategy-focus-on-supply-and-demand-side
kpis-to-measure-the-success-of-data-analytics-program
data-analytics-for-credit-union-branch-heads
data-organizing-principles
top-data-warehouse-storage-technologies
discover-the-hidden-truth-behind-watermelon-kpis
unveiling-the-hidden-dangers-of-cobra-effect-on-kpis
are-you-accurately-interpreting-your-kpi
unmasking-biases-a-guide-to-data-analysis-and-kpi-definition
uncover-the-power-of-proxy-kpis
unraveling-the-hidden-impact-of-sampling-bias-in-credit-unions
bi-department-structure
hidden-impact-of-confirmation-bias-in-credit-unions
getting-executive-attention-for-your-data-analytics-program
uncovering-biases-in-data-preprocessing
navigating-missing-data-in-credit-unions
navigating-sampling-bias-in-cu
unleash-the-power-of-real-time-data-use-cases
how-confirmation-bias-impacts-cus
breaking-down-selection-bias-in-credit-unions
unmasking-reporting-bias
elevate-your-cu-with-data-analytics-expertise
understanding-and-tackling-volunteer-bias-in-credit-unions
time-period-bias-in-credit-union
overcoming-biases-in-credit-unions
embracing-the-future-fast-future-fundamentals-program-equips-cred
unlock-growth-and-efficiency-credit-unions-guide-to-generative-ai