Community Chair

Driving Analytics Journey

In the Panel Session on “Driving Analytics Journey”, the panelists Paul Ablack, Sundeep Kapur, Anne Legg, and Andre Iervolino discuss the data analytics journey and various approaches towards it which can be adopted through the aid of influential case studies and practical examples.

Case Study - The Analytics Journey: Ideal Credit Union by Paul Ablack | Founder and CEO, OnApproach

This is a case study about member loyalty and about keeping members. The idea of the case study is that there are so many choices available to members, but amidst all these choices,  how do we still keep them engaged and loyal. Also at the same time, how do we keep making money as a credit union?

According to Paul,  holding on to your most profitable members is the ROI of analytics. In a credit union, there’s a model that 20% of your members make 80% of your profit. In this case study, he talks about predictive data analytics, descriptive data analytics, integrating the data and working with it.

The Challenge

Ideal Credit union is 692$ million in assets, and they have 52000 members. They are very committed towards delivering quality service to these members and helping them achieve financial and life goals. They used to have MCIF ( Marketing Customer Information File) system for their member rewards program and it was based on products. Eventually, The CEO Questioned his investment returns and wanted proof that he was making money out of these members. So he found out that 8000 members were contributing to 80% of the net income in 2012 and called these members VIP members. He wanted to grow the base of these VIP members and reward them for their behavior. He also needed to determine how these members were using the products and in order to do this, he had to look into the transaction data, which was tied up in data silos.

The Solution

They created three levels of VIP Patronage. So the income which they generated, a part of that would go to pay the dividend to the credit union on different levels. There were 66 criteria for allocation of these members into the three levels. The standards were - VIP Patronage dividend, VIP Loan Rebate Dividend and VIP Deposit Bonus Dividend. These three levels of profit required integration of data. To do the data integration they - a) purchased a CU Enterprise Dataware solution b) Integrated disparate data c) applied 64 distinct business rules at the API level. The algorithm so constructed would enforce these 64 rules to determine how much the member contributed as net income and interest income and so forth.

According to Shari Riley, Manager of Financial Reporting and Risk Management of Ideal -

“From the program support perspective, we see members starting to think about the program...they are thinking about it throughout the year and proactively trying to be sure they will meet the criteria for the upcoming year-end. They became goal oriented.”

As a result of these solutions :

  • The number of members since 2012 almost doubled.
  • As of January 2018, more than $3.1 million has been paid to these VIP members as a result of this program.
  • Although the members were profitable, they were earlier not using the 4 C’s program - Checking, Credit Card, Car, and Casa. So they started directing these products towards the profitable members.
  • There has been a 20% increase since 2014 in the members with at least three products.

According to the CEO, Dennis Bauer, “VIP is the most popular member programs we have ever launched. Now with the additional ability to drive other marketing programs with the VIP information, we are truly leveraging the value of our data.

Selling Starting And Effectively Executing A Big Data Project by |Sundeep Kapur| Educator, Digital Credence

Sundeep started his session with three examples that were related to a Big Data Project of Anonymous Organizations.                             

Example - 1: Anytime, Anywhere

Anytime Anywhere Communications, they power mobile devices and a few years ago they bought one of the largest television entertainment companies in the industry. They said - “Normally in the old days, everybody would get every offer and it would be difficult to understand why their rates were so high.” But they took a very pragmatic systematic approach towards Big Data.

Approach  :

  • Sorted customers based on products and services.
  • Further segmented by channel adoption.
  • Created a multi-channel messaging plan.

Use cases :

  • If a consumer has all products, thank them and offer an extended and discounted renewal.
  • If a consumer is missing a product, make graded offers to him based on convenience, incentive and more.
  • Promote offers systematically across the channel.

Analytics Centre of Expertise

  • This team carried a financial quota and this drove the budget.
  • It was held accountable for promises made.
  • It chartered with continuous improvement.

Results - From the number perspective, the results were spectacular. In 2014, they drove 16  million dollars in return, in 2017 they had 310 million dollars because of what was originally a small data transformation team that has taken things further.

Example - 2: Lead with Payments.

Credit Unions are a financial institution and they need to take things forward from there. This example is of a 500 million dollar credit union which supported colleges. They had two types of ACH ( Automated Clearing House) payments - Payments going out to American Express ( people interested in the brand),  and payments going to Discover card ( which gave you cash back).

Approach

  • Analyze ACH transactions.
  • Create multiple segments.
  • Unique graded offers.

What consumers want when they use a card

  • Convenience
  • Security.
  • Incentives

What credit unions want when customers use a card

  • Top of wallet card.
  • Reduced fraud.
  • Different source of revenue.

The concept of the golden triangle in financial services

The usual approach of banks and credit unions is to reduce the costs of deposits, maximize interests through loans and work on payments. But what FinTech did was to lead with payments, because they were taking a little bit of each transaction at the time. The approach is to lead with payments, connect with the consumer and then bringing them to do loans and deposits.

Results

  • 78% card and mobile adoption.
  • 60+ transactions a month.
  • Chartered with continuous improvement.

Example - 3: First impressions

You do not get a second chance to make a first impression. Think from an onboarding perspective, this credit union was sending out 14 messages over a 90 day period to connect and communicate with those they served. There were three categories of boarding - onboarding, loan boarding and deboarding.

The messages included the following

  • Welcome package (information that was promised).
  • Relevant testimonials based on product or service you have purchased.
  • Did you know? Inform about more products and services.
  • How did we treat you?

After any of these stages, they brought them in for a financial checkup to understand challenges and provide solutions, opening a lot of possibilities. Secondly, they adopted a mobile environment approach and made messaging and emails adaptable to mobile infographics.

Results

  • 70% engagement, 21% conversion on three touch transactions.
  • Inbound and outbound strategy for real-time communication.
  • Conversations with customers.

The Strategic Impact Of Big Data

Here are the 5 key sectors in which Big Data contributes.

  • Increase Revenue
  • Reduce Operational Costs.
  • Enhance Engagement.
  • Be More Efficient.
  • Be Legally Compliant.

Common objections or excuses from executives :

  • “ I’ll have to pay 150k to hire a programmer.”
  • “ I have outsourced my data.”
  • “I do not want to disrupt anything. I am close to retiring.”

You should be able to define your purpose.

  • How much money can you afford to give a prospect to become a member or for a member to stay?
  • We have to make analytics a repeatable process that drives revenue.
  • What is big data? Deciding on the best possible option based on an efficient scientific method that can be proven.

Ways To Ensure Step By Step Continued Learning

  •     Management education and picking projects by joint business and technology focused decision delivery workshops.
  •     Conducting an analytics strategy and assessment to gauge organizational readiness, and highlight maximum impact projects.
  •     Implement prioritized big data journeys by applying business and technology to drive results.
  •     Evaluating success with a renewed focus on continuous improvement.
  •     Instilling Analytics Expertise within the organization.

Drowning in Data and Striving For Insight? How To Fuel Your Credit Union Growth by Anne Legg | Director of Client Strategy | AdvantEdge Analytics

If you walk to the member first, you are going to solve your credit union problems. To drive a successful strategy, your two questions should be

  1. What is the business problem I’m going to solve?
  2. What is the member problem I’m going to solve?

Common Credit Union Friction

  • Harness data to improve member experience and operations.
  • View member information as a single enhanced source of truth.
  • Access real-time reporting dashboards with visualizations, insights, and analytics.
  • Create a one-click member experience anytime, anywhere.
  • Automate and streamline internal processes to be better and faster anywhere.

Approach to executing analytics opportunities: Build a roadmap

  1. Source of value - Defined by business need.
  2. Data Ecosystem- Appending key external Data, data integration from internal systems.
  3. Modeling Insights - Predictive modeling, apply linear and non-linear modeling to drive insights.
  4. Workflow integration- Integration of insights into day to day workflow, drive tech enablement.
  5. Adoption- Build frontline capabilities, Proactive Change Management and tracking of adoption with performance indicators.

If you just focus on solving the member problems, you will be able to solve lot of other problems on the way.

Data Transformation Example - Zero UI ( User Interface)

Where the member interacts with a personal assistant using zero user interface, zero UI is an interaction where an individual’s movement, voice, and even thought can all cause a system, such as financial assistance to respond to a person through their environment.

Features - Automated Loans, deposit and bill payments, predictive and prescriptive interaction.

Predictive Models

CU’s want to anticipate consumer’s next best product and make better decisions. As Credit unions, we should be able to leverage predictive analytics to customize member experience and improve operational efficiencies. Credit unions have a huge opportunity to leverage data analytics to create value across the value chain and provide members with better products and services.  If you are looking for a model, the three categories you should aim for are - commercial effectiveness, risk control, and operational efficiency.

To have a predictive HR management, you should be focusing on KPIs such as Churn Rate, to understand where the members are going and what they are up to.

Use Case - Identify triggers for account closure, dormancy to re-engage members with personalized offers and retention marketing.

Typical impact: 20-25% churn rate reduction.

Conversion of 1-2%accounts to active.

Most effective: end to end approach focused on business value.

  1. Source of value- What are you doing to make the member’s life better?
  2. Data ecosystem - Having the right toolset.
  3. Modeling insights - Predictive modeling.
  4. Workflow integration- Integrating data into the workflow.
  5. Adoption- Productive change management.
  6. Iterate throughout

Big Data, Small Data: What About The Right Data -  by Andre Iervolino | VP of Business Intelligence and Strategic Performance | Cabrillo Credit Union

Credit  Unions tend to look at data and use it for creating projects in silos.

But their practice was to create a BI strategic plan, incorporated into the corporate plan. Because of this, they were able to design a pyramid where they designed the vision, the mission, the strategy under the BI plan, services provided, the types of data, the tools that were needed to be used and operationalizing the overall strategic plan.

Data vision and mission :

Vision: To become a prescriptive enterprise driven by a democratized data culture - From hindsight to foresight.

Mission: As a provider of data related services, generate actionable business intelligence through Descriptive, Diagnostic, Predictive, and Prescriptive Analytics.

Data Strategy: Going through six different key result areas.

  1. Revenue - Whatever was done, had to generate revenue.
  2. Efficiencies - Save money for the credit union.
  3. Data Governance - Develop principles and strategies for business governance.
  4. Compliance - Enhance current business compliance,
  5. Implementing the right BI tools.
  6. Ensuring retention, acquisition, and development for a strong BI team.

Divided services into categories - Enterprise data management services and Strategic data services .

When you look at the data available to you, you can look into the following four categories, ( and it is possible to squeeze any kind of data into these categories).

  1. Competitors
  2. Macro and Micro economic data
  3. Member data.
  4. Market data.

Identify the problems you want to solve and what will help you generate the money. Then identify the data type. Having uncomplicated and easy to use tools is important.

Data Operationalization and Results

  Designed 8 different integrated programs to leverage the power of business intelligence and the right data.

  1. BI Tools
  2. Data Warehousing.
  3. Target Marketing.
  4. Data Sources, Data Governance , Data Compliance.
  5. Data Science.
  6. Consumer Insights, Market Insights, Research, and Data Reporting.
  7. Strategic Performance
  8. BI Team

Results -

  1. Migrated 17% of our indirect households to a retail status by using a CRM that was built from the ground up and took three weeks to build.
  2. Generated 65 million dollars in CD balances.
  3. Member engagement index drove by 8 variables through BI indices.
  4. Through the attrition model, increase in 12% member retention.
  5. Through market analysis, placement in 7 different branches.

Three things to take away

  • The size of the credit union doesn’t matter.
  • Do not start with silos projects, start with vision, mission, strategy and so on.
  • You do not always need to partner with external vendors to apply algorithms to the data.

From this panel, it is best to conclude that what is best for the members should be done first. While making crucial decisions about what is the best product, to ask what is member’s next is the best guide. It is only possible to answer this question if our data is relevant and right. If you can solve the member’s problem with whatever you are offering, they will trust you. And for a credit union, a member’s trust is the most crucial element.

WATCH FULL PANEL SESSION HERE

E-mail me when people leave their comments –

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

Join CULytics Community

 

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