Analyze and activate data with Looker Enterprise
This repository contains financial data related to outstanding loans, including total amounts, top customers, percentage breakdowns, and loan counts. Below is a summary of the data as captured in the provided screenshot (Screenshot 2025-02-10 175933.png).
- Total Outstanding Loans: $3.08 billion.
- Top State by Loan Count: California with 25,730 loans.
- Top Customer Annual Income: $110,000 (Customer from Texas).
| Customer ID | Annual Income | State | Interest Rate |
|---|---|---|---|
| ANALD-ADMINISTERIAL | $15,000 | TX | 12.95% |
| AMBENTOIRISATIONL | $16,000 | NU | 6.83% |
| ALABENTOIRISATIONL | $20,000 | ON | 8.11% |
| ADMINISTERIESHIP | $30,000 | NF | 11.98% |
| ALLEGRATIVITY | $40,000 | UT | 12.44% |
| AUTHORITATEUTILIZED | $250,000 | TX | 14.74% |
| ABSTRACTIONALIZE | $15,000 | NF | 15.24% |
| ABSTRACTIONEUTIC | $45,000 | NU | 19.79% |
| ADMINISTERIESHIP | $25,000 | AK | 7.02% |
Notes:
- Customer IDs may contain typos (e.g., "ADMINISTERIAL" vs. "ADMINISTERIESHIP").
- "Address Sales" likely refers to the customer's state.
- Current: 27.5%
- Charged (2019-07): [Unspecified value]
- Days (2019-12-03): [Unclear context]
- 12.7%
- 18.6% (in Euro 50.0%): [Partial/incomplete data]
- Under 10.9% (days): [Unclear context]
- 0.42%
- Fueled: 0.01%
- Fury Price: 0.00%
Note: Some entries lack context or appear truncated.
| Categories (Abbreviated) | Loan Counts by Range ($) |
|---|---|
| C.A., T.X., Y.Y., M.T.H., E.M., J.P., O.N.R.A., G.N., MC | 2,500 – 23,000 |
Notes:
- Categories are abbreviated and may represent regions or loan types.
- Loan counts are distributed across incremental ranges.
This data is for demonstration purposes only. Accuracy, completeness, and context may vary. Verify details before use.
- Clone the Repository: git clone https://github.com/your-repo-name/loan-insights-dashboard.git cd loan-insights-dashboard
- Setup Looker: This dashboard was built using Looker. Ensure you have access to Looker and the necessary datasets to replicate the visualization.
- Import Visualization: Use the Looker UI to import the visualizations and connect to your database.
Last Updated: 2025-02-10