Part 5/11:

• Loan Application Stage: Data begins here, whether submitted online or physically. This data is highly volatile, evolving from 'created' to 'approved' or 'rejected', requiring a dimensional modeling approach for capturing the entire journey.

• Customer Onboarding and Transactions: Once a loan is approved, subsequent activities like EMI payments, missed payments, charges, and collections are mapped as sequential data layers (fact tables), allowing comprehensive analysis of customer behavior over time.