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 |
|---|---|---|---|---|
| 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 |