fdic-branch-analyzer

FDIC Branch Analyzer

AI-powered banking market intelligence platform for analyzing FDIC branch data with comprehensive insights and professional reporting.

🌟 Live Demo

Visit the live application here!

🚀 Quick Start

1. Enter Counties:
   • Single county: Cook County, Illinois
   • Multiple counties: Cook County, Illinois; Los Angeles County, California
2. Enter Years:
   • Specific years: 2020,2021,2022
   • All years: all (2017-2024)

3. Generate Analysis: Click “Generate Analysis” and wait for processing

4. Download Reports: Get a ZIP file containing Excel and PDF reports

📊 What You’ll Get

Excel Report

• Raw branch data with detailed statistics
• Market share calculations
• Year-over-year comparisons
• Bank rankings and analysis

PDF Report

• Executive summary with key findings
• AI-generated insights and analysis
• Professional charts and tables
• Strategic recommendations
• Market dynamics overview

🏗️ Project Structure

fdic-branch-analyzer/
├── web/                    # GitHub Pages static site
│   ├── index.html         # Main interface
│   ├── css/style.css      # Styling
│   ├── js/app.js          # Frontend logic
│   └── _config.yml        # GitHub Pages config
├── src/                   # Core application
│   ├── core/main.py       # Main orchestration
│   ├── utils/             # Utilities
│   ├── analysis/          # AI analysis
│   └── reporting/         # Report generation
├── config/                # Configuration
├── docs/                  # Documentation
│   ├── README.md          # User guide
│   ├── API.md             # API documentation
│   └── DEPLOYMENT.md      # Deployment guide
├── scripts/               # Automation scripts
│   └── deploy/            # Deployment scripts
└── data/                  # Data storage (gitignored)

🛠️ Technical Stack

• Frontend: HTML5, CSS3, JavaScript (ES6+)
• Backend: Python 3.8+, Flask
• Data Source: FDIC Summary of Deposits (SOD) via BigQuery
• AI Engine: Claude 3.5 Sonnet for intelligent analysis
• Analysis Engine: pandas, matplotlib, reportlab
• Deployment: GitHub Pages, Docker, Cloud platforms

🔧 Development Setup

Prerequisites

• Python 3.8+
• BigQuery access
• Claude API key

Installation

git clone https://github.com/jadedlebi/fdic-branch-analyzer.git
cd fdic-branch-analyzer
pip install -r requirements.txt

Environment Setup

Create a .env file with:

# BigQuery Credentials
BQ_TYPE=service_account
BQ_PROJECT_ID=your-project-id
BQ_PRIVATE_KEY=your-private-key
BQ_CLIENT_EMAIL=your-client-email

# AI API Keys
CLAUDE_API_KEY=your-claude-key
OPENAI_API_KEY=your-openai-key

Running Locally

python run_web.py

Then visit http://127.0.0.1:5050

🚀 Deployment

GitHub Pages (Recommended)

./scripts/deploy/deploy.sh

Docker

docker build -t fdic-analyzer .
docker run -p 5000:5000 fdic-analyzer

Cloud Platforms

See docs/DEPLOYMENT.md for detailed deployment guides.

🔒 Security

• All credentials are stored in environment variables
• No sensitive data is committed to the repository
• BigQuery access is restricted to authorized users
• API keys are encrypted and secure

📚 Documentation

• User Guide - How to use the application
• API Documentation - For developers and integrations
• Deployment Guide - Production deployment instructions

🤝 Contributing

1. Fork the repository
2. Create a feature branch
3. Make your changes
4. Add tests if applicable
5. Submit a pull request

📄 License

This project is developed by NCRC (National Community Reinvestment Coalition) for banking market analysis and research purposes.

👥 Authors

• Jad Edlebi - NCRC
• Jason Richardson - NCRC

🔗 Links

• Live Application
• GitHub Repository
• NCRC Website
• Issues & Support

📞 Support

For questions or support:

• Create an issue on GitHub
• Contact the NCRC team
• Check the documentation in the docs/ folder

---

Built with ❤️ by NCRC for better banking market intelligence

This site is open source. Improve this page.