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 |
|---|---|---|---|---|
| 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 |
| GIFT_COUNT | The total number of individual donations, grants, or contributions received for a specific category or designation. This metric helps understand donor engagement and frequency of giving patterns. | Finance | 5, 23, 157, 8, 42 | Number of Donations, Contribution Count, Gift Frequency, Donor Transactions, Funding Instances |
| 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 |