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.ELECTRIC_UTILITY_DATA
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
DISTRIBUTOR_NAME INVOICE_DATE QUANTITY_MWH
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
"Build a comprehensive distributor power delivery analysis combining 12 months of historical actuals with 12 months of forward projections. Aggregate QUANTITY_MWH monthly by DISTRIBUTOR_NAME from INVOICE_DATE, apply time series decomposition (trend via linear regression plus seasonal month-over-month patterns) for each distributor's projection, and incorporate a 4% expected demand growth factor for next 12 months. Include all distributors present in the historical dataset, with output structured for visualization as a stacked area chart showing the full 24-month timeline with historical versus projected data clearly segmented. Make the legend interactive with the chart."
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-11
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 "Apply branding colors first and the harmonius colors thereafter"
Layout "Maximize the size of the visual for the available space both vertically and horizontally."
Layout "Add padding around chart for better spacing."
Style "Add linear regression trend line"
▶ Data Dictionary
Column Definition Domain Examples Synonyms
DATA_TYPE A classification field that distinguishes between historical actual power delivery measurements versus projected future estimates. This indicator helps separate real recorded data from forecasted values generated through time series analysis and demand growth modeling for comprehensive power delivery planning. Operations Historical, Projected, Actual, Forecast, Estimated Record Type, Data Category, Value Type, Measurement Type, Data Classification
DISTRIBUTOR_NAME The official business name of the electricity distribution company that purchases power from the utility for redistribution to end customers. These are regulated entities that own and operate the local power grid infrastructure, transforming high-voltage electricity from transmission lines to lower voltages suitable for residential and commercial use. Operations Pacific Power Distribution, Metro Electric Cooperative, Northern Valley Power Co, Coastal Energy Services, Mountain View Utilities Distribution Company, Power Distributor, Electric Distributor, Utility Partner, Distribution Entity
MONTH_DATE The standardized date value representing the first day of the month for which power delivery quantities are measured. This date field enables precise time-based calculations, sorting, and analysis for both historical actuals and future projections in the power delivery dataset. Operations 2024-01-01, 2023-02-01, 2024-03-01, 2023-04-01, 2024-12-01 Period Date, Month Start Date, Reporting Date, Time Dimension, Calendar Month
MONTH_LABEL A human-readable text representation of the month and year for which power delivery data is recorded. This provides an easily interpretable time reference that corresponds to the billing or reporting period for electricity distribution analysis and forecasting purposes. Operations January 2024, Feb 2023, March 2024, Apr 2023, December 2024 Month Name, Period Label, Time Period, Billing Month, Reporting Month
QUANTITY_MWH The amount of electrical energy delivered to a distributor during a specific month, measured in megawatt-hours. One megawatt-hour represents one million watts of power consumed continuously for one hour. This metric captures the total electricity volume transferred from the utility to distribution companies for subsequent delivery to end customers. Operations 45280.50, 78925.25, 156430.75, 92847.00, 203156.80 Energy Quantity, Power Volume, Electricity Delivered, MWh Quantity, Energy Volume