Unlocking Consumer Patterns for CredPal’s Credit Ecosystem

Project Overview

This project leverages Predictive Analytics and descriptive data analysis to explore global consumer patterns, specifically tailored for CredPal’s credit-driven retail expansion. By analyzing the relationship between income, expenditure, and savings across various regions, this study identifies high-potential markets where on-demand consumer credit can thrive.

The analysis was performed using Tableau to visualize key financial metrics and consumer behavior across seven global regions.

---

Key Business Questions

• Which regions demonstrate the strongest earning potential and repayment capacity?

• What are the dominant spending categories that should drive credit product offerings?

• How do savings rates correlate with income levels to signal financial discipline?

---

Data Insights & Findings

1. Regional Financial Performance

• Sub-Saharan Africa & Europe are the leading markets, recording the highest average monthly incomes ($34.7M and $34.3M respectively)

• These regions also exhibit the highest savings rates (Sub-Saharan Africa at 26.10% and Europe at 25.86%), indicating strong financial discipline and repayment capacity.

• North America shows the lowest scalability for credit, with a low savings rate of 2.17%.

2. Consumer Expenditure & Preferences

• Necessity-Driven Consumption: Office Supplies ($5.7M) and Household Products ($5.4M) dominate regional budgets, particularly in Sub-Saharan Africa.

• High Engagement Categories: Personal Care, Clothes, and Cosmetics show the highest consumer preference counts, particularly in Africa and Europe, each exceeding 10,700 counts.

• Low Priority Markets: Categories like Fruits and Beverages record minimal spending, suggesting they are underdeveloped for credit intervention.

3. Financial Correlation

A strong positive relationship exists between income and expenditure; as income increases, spending rises. However, the analysis highlights that regions with higher income levels also maintain higher savings, reinforcing their status as "low-risk, high-growth" markets.

---

Recommendations for CredPal

1. Prioritize Expansion: Focus on Sub-Saharan Africa and Europe due to their vibrant retail ecosystems and high purchasing power.

2. Tailored Credit Products: Align credit offerings with essential, recurring spending categories like Office Supplies, Household Products, and Meat.

3. Segmented Strategies:

• Africa/Europe: Offer flexible credit lines with loyalty incentives.

• Asia/MENA: Implement educational campaigns to boost financial literacy alongside credit.

• North America/Australia: Utilize stricter repayment models like BNPL (Buy Now, Pay Later).

4. Risk Optimization: Integrate regional income-expenditure-savings correlations into risk scoring algorithms to reduce default rates.

---

Tools Used

• Tableau: For data visualization and dashboard creation.
• Predictive Analytics: To identify consumer trends and creditworthiness.
• Dataset https://1drv.ms/x/c/67cd417fc93d9a3a/IQDTBqQYs12CS7tWcXZeERB1AYJdBm9w_BSlLgluo83c6IQ?e=Kpkqtr
• LinkedIn Post https://www.linkedin.com/posts/kumo-pascaline-bb3925226_tech4dev-wtf2025-datascience-activity-7391124294778556417-IGL2?utm_source=share&utm_medium=member_desktop&rcm=ACoAADi71ncBezJji_8qNGvux-JQxA2wzxtQ6sU

---

Technical Setup: How to Run

To interact with the visualizations and replicate the findings:

• Software Requirements: You will need Tableau Desktop (v2023.1 or later) or a Tableau Public account.
• Opening the Workbook:

1. Download the .twbx file from this repository.
2. Open the file in Tableau to view the Overall Dashboard.

• Data Source: The analysis is based on regional consumer financial data covering income, expenditure, savings rates, and product preferences.

Conclusion

The analysis demonstrates that CredPal's model is primed for growth, specifically in regions where consumer demand and saving discipline align. By leveraging these insights, CredPal can potentially drive merchant sales growth beyond its current 23% average.