--- title: "Features" canonical: "https://www.owox.com/features" updated: "2026-09-23" --- # Features 10 pages ## Pages [AI InsightsRecurring analysis eats analyst time, and a dashboard waits for someone to open it. AI Insights delivers scheduled narrative reports to Slack, Teams, Google Chat or email, with every figure computed by named SQL queries rather than the model — the data team stays in control while the business gets answers on schedule.](/features/ai-insights) [Data Mart ManagementWhen every report carries its own copy of the logic, numbers drift between teams and tools. A Data Mart is that logic defined once by the analyst — SQL, Table, View, Pattern, Connector or Joinable — with an output schema that says what each field means. Every report built on a mart shows the SQL behind its numbers, re-runnable in your own warehouse. Nothing reaches a spreadsheet, a dashboard or an AI assistant until the analyst publishes the mart. Start from a query, table, view or pattern you already have; the AI helper drafts field names and descriptions.](/features/data-mart-management) [Data StoragesEnable BigQuery, Snowflake, Databricks, Redshift, or Athena as your OWOX Data Marts warehouse — no migration, no proprietary storage, full control.](/features/data-storages) [Google Sheets ExportBusiness users live in spreadsheets, but pasted data goes stale and loses its logic. OWOX delivers governed Data Marts into Google Sheets and Excel — on a schedule or pulled on demand from inside the sheet — with joinable columns and non-destructive refreshes, no SQL needed.](/features/spreadsheet-reporting) [Looker Studio ConnectorRebuilding the same metrics inside every dashboard tool is how numbers start to disagree. The Data Studio Connector publishes a governed Data Mart to Data Studio with the same logic that powers your Sheets reports, joinable columns included.](/features/data-studio-connector) [Metadata AutofillA business user or an AI assistant can only use a Data Mart it understands, and metadata typed by hand is the task every analyst defers. Metadata Autofill drafts it for the analyst to approve. Every draft is written from the schema and a sample of up to 30 real rows, so it describes what the data actually contains. Autofill drafts, the analyst edits and saves — the descriptions an AI answer is grounded in stay the analyst's. One click fills aliases and descriptions for every field and the Data Mart's own title and description; field descriptions reach the spreadsheet's column picker and header-cell notes.](/features/metadata-autofill) [Orchestration (Scheduling)A report opened before its data refreshes shows yesterday's numbers. Schedules fire connector runs and report deliveries, so Sheets, dashboards and AI briefings open with current data — no manual runs, no stale reports.](/features/orchestration) [OWOX MCPA general-purpose AI chat invents numbers when it has no governed data to read. OWOX MCP lets Claude or ChatGPT query your published Data Marts: the assistant narrates, analyst-approved SQL computes — so every number traces back to SQL and none is invented.](/features/mcp) [Pivots & ChartsTurning report rows into something readable means building pivots and charts by hand. OWOX auto-generates pivot tables, charts and cohort analyses from Data Mart results inside Google Sheets — one click, zero setup.](/features/pivots-charts) [Semantic Layer (Metrics Definitions)Blending Ads, CRM and product data usually waits on SQL or a months-long semantic layer project. Declare join keys between Data Marts once, and business users combine them on their own — no SQL, and no semantic-layer project first.](/features/joinable-data-marts) ## References Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [AI InsightsRecurring analysis eats analyst time, and a dashboard waits for someone to open it. AI…](https://www.owox.com/features/ai-insights) — /features/ai-insights.md - [Data Mart ManagementWhen every report carries its own copy of the logic, numbers drift between teams…](https://www.owox.com/features/data-mart-management) — /features/data-mart-management.md - [Data StoragesEnable BigQuery, Snowflake, Databricks, Redshift, or Athena as your OWOX Data Marts…](https://www.owox.com/features/data-storages) — /features/data-storages.md - [Google Sheets ExportBusiness users live in spreadsheets, but pasted data goes stale and loses its…](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md - [Looker Studio ConnectorRebuilding the same metrics inside every dashboard tool is how numbers start…](https://www.owox.com/features/data-studio-connector) — /features/data-studio-connector.md - [Metadata AutofillA business user or an AI assistant can only use a Data Mart it understands, and…](https://www.owox.com/features/metadata-autofill) — /features/metadata-autofill.md - [Orchestration (Scheduling)A report opened before its data refreshes shows yesterday's numbers.…](https://www.owox.com/features/orchestration) — /features/orchestration.md - [OWOX MCPA general-purpose AI chat invents numbers when it has no governed data to read. OWOX MCP…](https://www.owox.com/features/mcp) — /features/mcp.md - [Pivots & ChartsTurning report rows into something readable means building pivots and charts by hand.…](https://www.owox.com/features/pivots-charts) — /features/pivots-charts.md - [Semantic Layer (Metrics Definitions)Blending Ads, CRM and product data usually waits on SQL or a…](https://www.owox.com/features/joinable-data-marts) — /features/joinable-data-marts.md