The Frugal Analyst AI Analytics Demo
HMDA Grouped 2022-2025 Prepared aggregate data Read only

Turn your data into an analytics and LLM-ready environment.

Nationwide Mortgage Lending Analytics

Explore prepared Home Mortgage Disclosure Act (HMDA) data covering 2022-2025. Ask aggregate questions about mortgage applications, approvals, denials, loan purpose, applicant income, and lender activity.

Explore the annual source data in the FFIEC Data Browser.

Read-only aggregate dataset

How The Chatbot Works

User Browser

You ask an aggregate question about the prepared 2022-2025 HMDA dataset.

Semantic Planning

Trusted metric rules and Terra planning translate the question into an allowed aggregate plan.

Validated Query

The server validates the plan, compiles read-only SQL, and queries the prepared MotherDuck table.

Analytics Output

The chatbot returns a grounded answer, comparison chart, aggregate table, and executed SQL.

Example: "What is the approval rate by year?"

Example: "Show the denial rate by year."

Example: "Which loan purposes have the highest application volume?"

Data assistant

Ask the HMDA Analyst

Explore applications, approvals, funding, loan purpose, lender activity, and market trends.

GPT-5.6 Terra Aggregate only
Suggested analysis
HMDA Analyst

Welcome. Ask a question about the 2022-2025 HMDA dataset and I will return a grounded answer, chart, and the underlying aggregate results. Terra is always enabled, so you can then ask a follow-up using the recent conversation in this browser tab.

Press Enter to send

Continuous improvement

How real questions make the chatbot better

Questions the chatbot cannot answer well become signals for what to improve next. Each update is reviewed and tested before it reaches customers.

Customers ask questions

Real questions reveal the metrics, comparisons, and explanations people need.

The chatbot spots a gap

A new, unclear, or unsupported question shows where the experience falls short.

The signals are reviewed

Unanswered questions and feedback are grouped to find useful, repeated patterns.

Knowledge and rules improve

Metric definitions, planning rules, prompts, and chart choices are refined.

Changes are tested and shipped

Updates are checked for accuracy, safety, and clarity before they go live.

Answers get better over time

Clearer answers build trust and create the next round of useful questions.

Unanswered questionsShow missing capabilities and definitions.
Unclear answersReveal where explanations need work.
Repeated requestsHelp prioritize the most useful additions.