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
TENANT.kinetiq_group.healthplan_claims_3
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
CLAIM_AMOUNT CLAIM_ID DATE_OF_SERVICE DATE_PROCESSED DATE_SUBMITTED DENIAL_REASON DIAGNOSIS_CODE MEMBER_AGE MEMBER_GENDER MEMBER_ID MEMBER_ZIP PAID_AMOUNT PROCEDURE_CODE PROVIDER_ID PROVIDER_TYPE PROVIDER_ZIP SERVICE_TYPE STATUS
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
"Comprehensive monthly operational performance analysis for Claims leadership spanning all available time periods, grouped by month from DATE_OF_SERVICE. Calculate the following metrics per month: total claim count (CLAIM_ID), sum of CLAIM_AMOUNT, sum of PAID_AMOUNT, payment ratio (total PAID_AMOUNT / total CLAIM_AMOUNT), average claim processing days (DATE_PROCESSED minus DATE_SUBMITTED), denial rate (count of STATUS='Denied' divided by total claims as percentage), and month-over-month percentage change in claim volume. Include breakdown by STATUS to show Approved, Denied, and Pending claim counts per month. Present as a detailed monthly trend table enabling identification of processing bottlenecks, payment efficiency patterns, and denial rate fluctuations for strategic operational decision-making."
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-10
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
Style "Show data points in the chart."
Style "Use branding guideline colors - do not use red."
Style "Add a line chart component to the chart for denial rate for each month - make sure the y-axis labels are clear, not overlapping and legend is right side justified."
Layout "Give the chart enough padding at the bottom so x-axis labels are not cutoff."
Other "Add a line chart component to the chart for denial rate for each month - make sure the y-axis labels are clear, not overlapping and legend is right side justified."
▶ Data Dictionary
Column Definition Domain Examples Synonyms
approved_count The number of healthcare claims that have been reviewed and approved for payment during the reporting month. These claims have met all coverage requirements and policy criteria for reimbursement. Operations 1,089, 1,145, 967, 1,234, 1,098 approved_claims, paid_claims, accepted_count, processed_approvals, authorized_claims
avg_processing_days The average number of calendar days between when healthcare claims were submitted and when they received a final processing decision (approved or denied). This metric measures the efficiency of the claims review workflow. Operations 12.3, 14.7, 11.8, 13.2, 15.1 turnaround_time, processing_time, cycle_time, review_duration, decision_time
denial_rate_pct The percentage of submitted healthcare claims that were denied during the month, calculated by dividing denied claims by total claims. This metric indicates claims quality and adherence to coverage policies. Operations 7.0%, 8.9%, 13.5%, 6.9%, 10.3% rejection_rate, decline_rate, denial_percentage, refusal_rate, disapproval_rate
denied_count The number of healthcare claims that have been rejected and will not be paid during the reporting month. These claims failed to meet coverage requirements, policy criteria, or contained errors requiring correction. Operations 87, 123, 156, 98, 134 rejected_claims, declined_count, denied_claims, rejected_count, disapproved_claims
mom_volume_change_pct The month-over-month percentage change in total claim volume compared to the previous month. Positive values indicate increased claim submissions while negative values show decreased activity, helping identify trends and seasonality patterns. Operations 11.4%, -16.8%, 23.1%, -8.8%, 5.7% volume_growth, monthly_variance, claim_trend, volume_change, submission_growth
month The calendar month and year when healthcare services were provided to patients, used as the primary grouping period for analyzing claims performance trends. This represents the service date month rather than when the claim was submitted or processed. Operations 2024-01, 2024-02, 2024-03, 2024-04, 2024-05 service_month, reporting_period, analysis_period, service_date_month, performance_month
payment_ratio_pct The percentage representing how much of the total requested claim amount was actually paid out. Calculated by dividing total paid amount by total claim amount, this metric indicates payment efficiency and cost management effectiveness. Finance 86.9%, 90.8%, 88.1%, 87.2%, 87.1% payout_ratio, payment_rate, reimbursement_ratio, pay_through_rate, settlement_ratio
pending_count The number of healthcare claims that are still under review and have not yet received a final approval or denial decision by the end of the reporting month. These claims are in various stages of the review process. Operations 71, 121, 33, 91, 66 under_review, in_process, pending_review, outstanding_claims, unresolved_claims
total_claim_amount The sum of all dollar amounts requested across all healthcare claims submitted during the month. This represents the total value of medical services for which reimbursement was requested, before any payment decisions were made. Finance $2,456,789, $2,187,432, $2,789,123, $2,634,567, $2,398,234 billed_amount, requested_amount, claim_value, submitted_amount, gross_claim_value
total_claims The complete count of all healthcare claims received during a specific month, regardless of their current processing status. This includes all claims whether they have been approved, denied, or are still pending review. Operations 1,247, 1,389, 1,156, 1,423, 1,298 claim_count, total_submissions, claim_volume, monthly_claims, submitted_claims
total_paid_amount The sum of all dollar amounts actually paid out for approved healthcare claims during the month. This represents the total financial liability incurred by the health plan for covered medical services. Finance $2,134,567, $1,987,234, $2,456,890, $2,298,123, $2,089,456 reimbursed_amount, paid_out, settlement_amount, disbursed_amount, actual_payments