From raw data to a certified, interactive data product — six governed steps, no code required.
Browse the role-filtered Data Catalog and select the source table. Row counts, descriptions, and sensitivity flags are visible before any query is written.
Select exactly which columns the AI will work with. Only schema metadata is used — no raw data is ever sent to the AI.
Describe what you need in plain English. The AI validates the request for clarity and SQL suitability.
The AI produces a validated SELECT query tailored to the use case. The query is tested against live data before proceeding — only SELECT statements are permitted.
Query results are previewed before any visualization is created. A named approver signs off on data quality — this gate is required and tracked.
The AI recommends the best visualization type and generates the raw program code required for an interactive rendering. Each refinement is a natural language instruction — no code editing required. Every iteration is stored and reusable.
| Column | Definition | Domain | Examples | Synonyms |
|---|---|---|---|---|
| ADDRESS | The geographic location associated with fundraising activities, typically representing donor locations, campaign regions, or organizational addresses. This field enables geographic analysis of donation patterns and helps identify regional fundraising performance and donor distribution across different areas. | Operations | New York, NY, Los Angeles, CA, Chicago, IL, Houston, TX, Phoenix, AZ | Location, Geographic Region, Donor Location, Regional Address, Geographic Area |
| AVG_AMOUNT | The average monetary value per individual gift or contribution within a specific category or designation. This is calculated by dividing the total amount by the gift count to show typical giving levels. | Finance | 5000.00, 15000.00, 2500.00, 75000.00, 12000.00 | Average Gift Size, Mean Contribution, Typical Donation, Average Giving Level, Per-Gift Average |
| CATEGORY | The broad classification or type of funding received by the university. This groups donations, grants, and other financial contributions into major categories to help analyze funding patterns and compare with peer institutions. | Finance | Academic Programs, Student Services, Research Initiatives, Campus Infrastructure, Athletics | Funding Type, Contribution Category, Gift Classification, Revenue Stream, Donation Category |
| DESIGNATION | The specific purpose, fund name, or detailed description of how the funding is intended to be used within the university. This provides more granular detail than the broader category classification. | Finance | Engineering Scholarship Fund, Library Renovation Project, Graduate Research Fellowship, Student Emergency Aid, Alumni Center Construction | Fund Purpose, Allocation Description, Specific Use, Fund Designation, Purpose Code |
| DONATIONS | The total number of individual donation transactions received during the specified period or campaign. This count includes all separate giving instances, regardless of amount, and provides insight into donor engagement levels and fundraising activity volume. Each donation represents a single act of giving by a contributor. | Finance | 45, 127, 89, 203, 156 | Gift Count, Contribution Count, Transaction Count, Donation Transactions, Number of Gifts |
| PERIOD_OR_NAME | The time period covered by the fundraising analysis or the specific name of a fundraising campaign or initiative. This field can represent either a date range (like quarters or fiscal years) or the title of a particular fundraising effort, allowing for both temporal and campaign-specific reporting views. | Finance | Q4 2024, Annual Gala 2025, Spring Campaign, FY 2024-2025, Emergency Relief Fund | Time Period, Campaign Name, Reporting Period, Initiative Title, Date Range |
| REPORT_TYPE | The category or classification of fundraising report being generated. This field identifies the specific type of analysis or summary being presented, such as donor demographics, campaign performance, or financial summaries. It helps organize and categorize different analytical views of fundraising data for management and stakeholder review. | Finance | Annual Summary, Campaign Analysis, Donor Demographics, Monthly Performance, Regional Breakdown | Report Category, Analysis Type, Report Classification, Summary Type, Report Format |
| TOTAL_AMOUNT | The combined monetary value of all gifts and contributions received for a specific category or designation. This represents the aggregate financial impact and total funding secured. | Finance | 25000, 150000, 750000, 45000, 320000 | Total Funding, Aggregate Amount, Sum of Gifts, Combined Value, Total Contributions |
| UNIQUE_DONORS | The count of distinct individual donors who made contributions during the specified period or campaign. This metric eliminates duplicate counting when the same person makes multiple donations, providing a true measure of donor base size and reach. It helps assess fundraising effectiveness in attracting and engaging supporters. | Finance | 38, 95, 72, 164, 123 | Distinct Donors, Individual Contributors, Unique Contributors, Donor Count, Supporter Count |