1
Data Catalog
Select the Data Source

Browse the role-filtered Data Catalog and select the source table. Row counts, descriptions, and sensitivity flags are visible before any query is written.

Actual Data Source Selected
DATAWAREHOUSE.KINETIQ_INSIGHTS.DEVELOPMENT
2
Columns
Choose the Columns in Scope

Select exactly which columns the AI will work with. Only schema metadata is used — no raw data is ever sent to the AI.

Actual Columns Selected
ADDRESS AMOUNT CATEGORY DATE DESIGNATION LATITUDE LONGITUDE NAME
3
Use Case
Define the Business Question

Describe what you need in plain English. The AI validates the request for clarity and SQL suitability.

Actual use case entered
"We need a comprehensive annual report that provides analysis on all metadata and metrics for the fund raising efforts for 2025"
4
SQL Generation
AI Generates & Tests the Query

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.

5
Data Quality ✓ Approved
Validate & Approve the Data

Query results are previewed before any visualization is created. A named approver signs off on data quality — this gate is required and tracked.

Actual Approval Recorded
✓ Approved by Ben Marchbanks  ·  2026-03-06
6
Refine & Release
AI Generates the Visualization — Then You Refine It

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.

Actual Refinements Applied
Layout "use a landscape page format to maximize page width"
Function "Make visualizations interactive."
Style "Use font-awesome for icons"
Layout "Maximize to the size of each chart so it fills the available space of its parent container."
★ Rated Dashboard with Multiple Small Multiples — Layout ★   Function ★   Style ★
Rating makes this visualization available as a reusable Template for other data products.
▶ Data Dictionary
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