Skip to content

README.md

Latest commit

 

History

History
55 lines (40 loc) · 1.29 KB

README.md

File metadata and controls

55 lines (40 loc) · 1.29 KB
title tags created
Fiction Bank dbt Project
dbt
banking
loans
analytics
2026-01-22

Fiction Bank - Loan Analytics dbt Project

A fictional western-themed bank specializing in small real estate loans and personal lending.

Overview

Fiction Bank focuses on:

  • Primary Mortgages - Residential home loans
  • Home Equity Loans - Home equity lines of credit
  • Personal Loans - Unsecured personal lending

Project Structure

Seeds (Raw Data)

  • loan_types.csv - Reference table for loan product types
  • raw_loans.csv - Loan account information
  • raw_loan_payments.csv - Payment transaction history

Staging Models (models/staging/)

  • stg_loans - Cleaned loan account data
  • stg_loan_payments - Cleaned payment transactions

Marts Models (models/marts/)

  • fct_loan_details - Analytics table joining loans with loan types, includes LTV calculations
  • fct_monthly_loan_summary - Monthly aggregation of originations and payment activity

Key Metrics

The project tracks:

  • Loan originations by month and type
  • Payment collection metrics
  • Loan-to-value (LTV) ratios for real estate loans
  • Average loan sizes and interest rates

Getting Started

# Install dependencies
dbt deps

# Load seed data
dbt seed

# Run all models
dbt run

# Run tests
dbt test