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.BROKERAGE_TRANSACTIONS
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
ACCOUNTOPENDATE ACCOUNTTYPE ACTIVITY_DEPOSITSLASTYEAR ACTIVITY_LASTTRADEDATE ACTIVITY_MONTHLYDEPOSITAVERAGE ACTIVITY_TRADESLASTMONTH ACTIVITY_WITHDRAWALSLASTYEAR AGE ALLOCATION_ALTERNATIVES ALLOCATION_BONDS ALLOCATION_CASH ALLOCATION_STOCKS CLIENTID CLIENTSTATUS GENDER LASTINTERACTIONDATE LOCATION NAME PERF_FIVEYEARRETURN PERF_ONEYEARRETURN PERF_YTDRETURN RISKTOLERANCE TOTALPORTFOLIOVALUE TX_AMOUNT TX_DATE TX_SYMBOL TX_TYPE
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
"I need a robust interactive report with logical filters for metric selection and KPI."
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-09
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 "Default grouping by YEAR_WEEK. Set Expand All as default for grouping display. When group selection changes - change the legend Summary as well. Table headings can wrap to keep table width optimized.. Use branding colors. LAYOUT DESIGN - Use a single full-width table that takes 100% of the viewport height. - Do not allow use of table-layout:fixed to be used anywhere. - The table has exactly TWO rows: 1. First row = controls header (minimal necessary height, auto-adjusting) 2. Second row = main content area (takes the remaining ~85–90% of height) - The first row (header) contains ONE cell that spans the full width. Inside this cell place a horizontal flex container that: - Centers all controls horizontally - Spaces them evenly with consistent gaps - Keeps everything on a single line (no wrapping) - Supports any number of UI controls (dropdowns, radio groups, checkboxes, buttons, date pickers, etc.) - Has minimal padding and optimized height (comfortable but compac) - The second row (content) contains TWO cells side by side: - Left cell: main visualization/chart area – takes 80% of the total width and 100% of the row's height . - Visualization should optimize the size to fit the space and be centered in its parent container. - Right cell: sidebar/legend/details panel – takes the remaining 20% of the total width and 100% of the row's height. - Make the legend scrollable to prevent oversizing the table. - All elements must have styling that prevents them from increasing the width of their parent cell. Add a control for changing the data metrics. Do not add Title to the SVG chart itself. It should be included in the heading. Each of the legend metric labels should include their aggregated numbers."
Function "The aggregated numbers which are percentages should average, other numerical values should sum."
▶ Data Dictionary
Column Definition Domain Examples Synonyms
ACCOUNTOPENDATE The specific date when the client first opened their account with the brokerage firm. This marks the beginning of the client relationship and is used to calculate tenure. Customer 2020-01-15, 2019-03-22, 2021-07-10, 2018-11-05, 2022-02-28 Account Start Date, Relationship Start, Opening Date, Onboarding Date, Account Creation Date
ACCOUNTTYPE The category of investment account that defines the structure, tax treatment, and permitted investments. Different account types have specific rules and benefits for clients. Finance Individual, Joint, IRA, 401k, Trust Account Category, Investment Type, Account Class, Portfolio Type, Account Structure
ACTIVITY_DEPOSITSLASTYEAR The total dollar amount of money deposited into the client's account during the past 12 months. This includes cash deposits, transfers from external accounts, and any other funds added to increase the account balance, excluding investment gains. Finance 25000, 8500, 45000, 12750, 67500 Annual Deposits, Yearly Contributions, 12-Month Inflows, Annual Funding, Yearly Additions
ACTIVITY_LEVEL A measure of how frequently the client engages in trading and account activities. This helps determine service needs and commission revenue potential from the client relationship. Operations High, Medium, Low, Very High, Inactive Trading Activity, Engagement Level, Transaction Frequency, Activity Rating, Usage Level
ACTIVITY_MONTHLYDEPOSITAVERAGE The average amount of money a client deposits into their brokerage account each month, calculated over a specific time period. This metric helps assess client cash flow patterns and their commitment to investing. It provides insights into client behavior and can be used to identify high-value clients or those who may need additional engagement. Customer $1,250.75, $3,480.20, $750.00, $4,125.50, $2,890.35 Monthly Deposit Average, Average Monthly Contributions, Monthly Funding Average, Average Monthly Deposits, Monthly Cash Inflow Average
ACTIVITY_TRADESLASTMONTH The total number of individual trades executed by the client during the most recent completed month. This includes both buy and sell transactions across all securities and provides insight into the client's trading frequency and activity level. Sales 8, 15, 3, 25, 0 Monthly Trade Count, Recent Trading Activity, Last Month Transactions, Monthly Trade Volume, Recent Trade Frequency
ACTIVITY_WITHDRAWALSLASTYEAR The total dollar amount withdrawn from the client's account over the past 12 months. This includes cash withdrawals, transfers to external accounts, and any other funds removed from the account, excluding investment losses or fees. Finance 15000, 3200, 28000, 9500, 41000 Annual Withdrawals, Yearly Distributions, 12-Month Outflows, Annual Redemptions, Yearly Withdrawals
AGE_GROUP A categorized age range that the client falls into, used for demographic analysis and tailoring investment products and services to different life stages and financial needs. Customer 25-34, 35-44, 45-54, 55-64, 65+ Age Range, Age Category, Age Bracket, Life Stage, Age Cohort
ALLOCATION_ALTERNATIVES The percentage of the client's portfolio invested in alternative investments such as real estate investment trusts, commodities, private equity, hedge funds, or other non-traditional assets. These investments often provide diversification benefits and may have different risk-return profiles than stocks and bonds. Finance 15.3, 8.7, 25.1, 0.0, 12.9 Alternative Investments, Non-Traditional Assets, Alt Allocation, Specialty Investments, Alternative Holdings
ALLOCATION_BONDS The percentage of the client's portfolio allocated to fixed-income securities such as government bonds, corporate bonds, and bond funds. This allocation represents the conservative, income-generating portion of the portfolio that typically provides stability and regular interest payments. Finance 30.5, 45.8, 20.3, 55.2, 15.7 Fixed Income Allocation, Bond Percentage, Fixed Income Exposure, Bond Weight, Debt Securities Allocation
ALLOCATION_CASH The percentage of the client's portfolio held in cash equivalents, including money market funds, savings accounts, and short-term liquid instruments. This allocation represents the most liquid and conservative portion of the portfolio, available for immediate use or future investment opportunities. Finance 10.2, 25.6, 5.8, 35.4, 8.9 Cash Position, Liquid Assets Percentage, Cash Weight, Money Market Allocation, Cash Holdings
ALLOCATION_STOCKS The percentage of the client's total portfolio value invested in stock securities, including individual stocks and equity-based funds. This allocation percentage represents the equity exposure within the overall investment mix and indicates the client's risk appetite and growth orientation. Finance 65.0, 45.3, 80.2, 25.7, 55.8 Equity Allocation, Stock Percentage, Equity Exposure, Stock Weight, Equity Holdings Percentage
CLIENTID A unique identifier assigned to each customer who has an account with the brokerage. This code allows the firm to track and distinguish between different clients across all systems and transactions. Customer CLI-789456, CU-001234, BRK-456789, ID-987654, C-112233 Customer ID, Client Number, Account Holder ID, Customer Code, Client Reference
CLIENTSTATUS The current standing of the client's relationship with the brokerage, indicating whether the account is active, inactive, or has other special conditions that affect service delivery. Customer Active, Inactive, Suspended, Closed, Pending Account Status, Customer Status, Relationship Status, Client Standing, Account State
CLIENT_TIER A classification system that segments clients based on factors like account value, trading activity, or relationship depth. Higher tiers typically receive enhanced services and benefits. Customer Platinum, Gold, Silver, Bronze, Premium Service Level, Client Segment, Relationship Tier, Customer Level, Priority Status
DAYS_SINCE_INTERACTION The number of days that have passed since the client last had any form of contact or interaction with the brokerage firm. This includes phone calls, emails, website logins, or any other touchpoint. Negative values may indicate future scheduled interactions or data processing anomalies. Customer 15, 45, 120, 250, 365 Days Since Last Contact, Time Since Engagement, Last Touch Days, Contact Recency, Interaction Gap
DAYS_SINCE_TRADE The number of days elapsed since the client's most recent trading activity or transaction execution. This metric helps identify active versus dormant trading accounts and is crucial for understanding client engagement patterns and potential churn risk. Sales 7, 30, 90, 180, 400 Days Since Last Trade, Trading Recency, Last Transaction Days, Trade Inactivity Period, Time Since Last Order
ENGAGEMENT_SCORE A calculated metric that quantifies the client's overall level of engagement with the brokerage across various touchpoints like trading, communications, and service usage. Higher scores indicate more active clients. Customer 85, 72, 94, 61, 78 Client Engagement Rating, Activity Score, Involvement Index, Participation Score, Interaction Rating
GENDER The gender identity of the client as provided during account opening. This demographic information may be used for diversity reporting and understanding client base composition. Customer Male, Female, Non-binary, Prefer not to say, Other Sex, Gender Identity, Demographic Gender, Client Gender, Personal Gender
LASTINTERACTIONDATE The most recent date when the client had any form of contact or engagement with the brokerage, including trades, calls, emails, or online activity. This indicates client engagement recency. Operations 2023-12-15, 2023-11-28, 2023-10-30, 2023-12-05, 2023-09-20 Last Contact Date, Most Recent Activity, Last Engagement, Final Interaction, Latest Touch Point
LOCATION The geographic location or region where the client resides or is based. This may be used for regulatory compliance, tax purposes, or regional analysis of the client base. Customer New York, California, Texas, Florida, Illinois Region, State, Geography, Residence, Address
NAME The full legal name of the client as registered with the brokerage firm. This is typically the name that appears on official documents and account statements. Customer John Smith, Sarah Johnson, Michael Brown, Lisa Davis, Robert Wilson Client Name, Account Holder Name, Customer Name, Full Name, Legal Name
NET_FLOW_LASTYEAR The net dollar amount of money flow into or out of the client's account over the past 12 months, calculated as total deposits minus total withdrawals. Positive values indicate net money coming in, while negative values show net outflows from the account. Finance 10000, -5500, 32000, -8200, 15750 Annual Net Flow, Yearly Net Movement, Net Cash Flow, 12-Month Net Activity, Annual Net Funding
PERF_FIVEYEARRETURN The annualized percentage return of the client's portfolio over the past five years. This long-term performance metric helps evaluate the sustained success of investment strategies and provides context for assessing portfolio management effectiveness over market cycles. Finance 7.8, 3.2, 11.4, -1.5, 9.6 Five Year Return, 5Y Annualized Return, Long-term Performance, Five Year CAGR, 5-Year Track Record
PERF_ONEYEARRETURN The total percentage return on the client's portfolio over the past 12 months, calculated from the current date backward. This metric provides insight into the portfolio's recent performance and helps assess investment strategy effectiveness over a full year cycle. Finance 12.3, -5.8, 22.1, 4.6, -15.2 One Year Return, 12-Month Return, Annual Return, Trailing Year Performance, 1Y Return
PERF_YTDRETURN The percentage return on the client's portfolio from the beginning of the current calendar year to the present date. This performance metric shows how well the portfolio has performed relative to its starting value at January 1st of the current year. Finance 8.5, -3.2, 15.7, 0.9, -12.4 Year-to-Date Return, YTD Performance, Current Year Return, Annual Return to Date, YTD Gain/Loss
PORTFOLIO_HEALTH An assessment of the overall condition and performance of the client's investment portfolio, considering factors like diversification, risk alignment, and performance relative to benchmarks. Finance Excellent, Good, Fair, Poor, Needs Attention Portfolio Score, Investment Health, Portfolio Rating, Portfolio Quality, Investment Status
RISKTOLERANCE A classification that indicates the client's willingness and ability to accept investment losses in pursuit of potential gains. This guides investment recommendations and portfolio construction. Finance Conservative, Moderate, Aggressive, Very Conservative, Growth Risk Profile, Investment Appetite, Risk Level, Investment Style, Risk Preference
TENURE_YEARS The number of complete years that the client has maintained an active relationship with the brokerage firm, calculated from the account opening date to the current date. Customer 3, 7, 12, 2, 5 Years of Service, Relationship Duration, Account Age, Client Longevity, Membership Years
TOTALPORTFOLIOVALUE The current market value of all securities and cash holdings in a client's investment portfolio. This represents the total worth of their account at a specific point in time, including stocks, bonds, mutual funds, ETFs, and cash positions. It serves as a key indicator of client wealth and account size for segmentation and service delivery purposes. Finance $125,750.50, $845,320.75, $1,250,480.25, $67,890.00, $2,150,675.80 Portfolio Market Value, Total Account Value, Portfolio Worth, Account Balance, Total Holdings Value
TOTAL_BUY_AMOUNT The total dollar value of all securities purchased by a client through buy transactions within a specified period. This represents the aggregate amount spent on acquiring stocks, bonds, ETFs, and other investment instruments. It helps measure client investment activity and purchasing power in the market. Finance $15,750.00, $48,920.50, $7,300.25, $125,680.75, $89,450.00 Total Purchase Amount, Total Buy Value, Aggregate Purchase Volume, Total Investment Purchases, Total Acquisition Amount
TOTAL_SELL_AMOUNT The total dollar value of all securities sold by a client through sell transactions within a specified period. This represents the aggregate amount received from liquidating stocks, bonds, ETFs, and other investment instruments. It indicates client divestment activity and capital realization patterns. Finance $22,450.80, $65,300.00, $12,750.45, $98,620.25, $156,780.90 Total Sale Amount, Total Sell Value, Aggregate Sale Volume, Total Liquidation Amount, Total Divestment Value
TOTAL_TRANSACTIONS The cumulative number of all transactions executed in the client's account since account opening. This comprehensive count includes all buy orders, sell orders, and other trading activities, providing a complete picture of the client's historical trading behavior. Sales 156, 342, 89, 578, 23 Lifetime Trades, Total Trade Count, Cumulative Transactions, All-Time Trading Activity, Historical Transaction Count
TOTAL_TX_AMOUNT The combined total dollar value of all transactions (both buy and sell) executed by a client within a specified period. This comprehensive metric represents the overall trading volume and activity level, providing a complete picture of client engagement with their investment portfolio regardless of transaction direction. Finance $134,750.25, $89,420.80, $245,680.50, $67,320.15, $178,950.75 Total Transaction Value, Aggregate Transaction Amount, Total Trading Volume, Combined Transaction Value, Total Deal Amount
UNIQUE_SYMBOLS_TRADED The count of distinct securities, stocks, funds, or other financial instruments that the client has traded throughout their relationship with the brokerage. This metric indicates portfolio diversification and the breadth of the client's investment interests. Sales 25, 48, 12, 67, 8 Distinct Securities, Different Instruments Traded, Unique Holdings, Security Diversity, Investment Breadth