Unlocking Growth: Data-Driven Insights for BcBank's Success

Executive Summary

This exploratory data analysis (EDA) delves into the transaction data of BcBank, a microfinance institution, to inform decision-making processes by examining customer transactions, account activity, loan eligibility, and performing an RFM analysis to segment customers in line with the recency of their transactions, the frequency of their transactions and the monetary value of their transactions. Key findings from this analysis reveal opportunities for growth, customer engagement, and operational enhancements.

Data Overview

BcBank's transaction data is housed in a database comprising nine tables, meticulously designed to maintain referential integrity and define table relationships. The analysis primarily focuses on data retrieved from the AccountTypes, Customer, Transaction, and Loan tables.

Customer Account Activity

The initial queries reveal a customer base of 581 accounts, showcasing a mix of active, inactive, and dormant accounts. Subsequent analysis shows that 80% of these customers are active, 15% are inactive and 5% are dormant. Notably, 368 customers which is 63% of the total customers base do not have ATM cards, indicating an opportunity to improve accessibility and service offerings.

---

---

---

Transaction Analysis

Transaction details are explored, separating inflows, outflows and account balances. This investigation shows that there are some customers with negative balances, this could be as a result of customers overdrawing their accounts which could be an operational issue if these accounts are not eligible for overdraft and have not repaid the OD within the specified time.

---

---

Loan Eligibility and Opportunities

Two loan tables facilitate the assessment of customer loan eligibility and the available loan types for each customer. This analysis Identifies 121 customers eligible for loan,  this presents an opportunity for targeted loan product marketing and upselling.

---

---

RFM Analysis

RFM analysis sheds light on customer behavior, highlighting trends in transaction recency, frequency, and monetary value. Notably, high-value customers exhibit prolonged inactivity, suggesting the need for tailored retention strategies.

---

---

Conclusion

The analysis underscores pertinent issues, including inactive accounts, ATM card adoption, negative balances, and untapped loan opportunities. While indicating growth potential, it also signals operational challenges necessitating proactive interventions.

Recommendations

• Increase Customer Base: Launch a campaign aimed at acquiring new customers to expand BcBank's reach.

• Reactivation Campaign: Launch a targeted reactivation campaign to revive dormant accounts, leveraging personalized communication channels and feedback mechanisms.

• Negative Balance Remediation: Conduct a thorough investigation into negative balances, engaging affected customers to rectify discrepancies and improve financial health.

• Loan Product Promotion: Initiate a campaign to promote available loan products to eligible customers, emphasizing benefits and tailored solutions.

• ATM Card Acquisition Drive: Implement initiatives to increase ATM card issuance and usage among customers, enhancing convenience and service accessibility.

• Loyalty Program Enhancement: Refine the proposed loyalty campaign for top customers, integrating personalized rewards and incentives to foster long-term loyalty and advocacy.

By implementing these recommendations, BcBank can capitalize on growth opportunities, enhance customer engagement, and fortify its position in the microfinance sector.

The SQL queries for this analysis can be found here: https://bit.ly/4d98jU4