Enable business reporting from your Google BigQuery data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for Microsoft Excel.
Google BigQueryConnected
Microsoft ExcelDaily 09:00Finance wants Google BigQuery numbers in Excel, so someone runs a query and pastes the CSV every month.
Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts and pulls one into your workbook with the Microsoft Excel add-in.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/google-bigquery-connector-to-microsoft-excel.md. The task: pull a Data Mart on Google BigQuery into my Microsoft Excel workbook with the add-in, so the monthly finance figures refresh from the same SQL instead of a pasted CSV. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Start from your Google BigQuery data
Connect your BigQuery project and pick the dataset that holds the data your workbooks need.
- Nothing to move or copy.
Google BigQueryYour data warehouseDatasetBuild a reporting library in Google BigQuery
Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the model.
- Business users browse reports, not tables.
Pull Google BigQuery data into Microsoft Excel with the add-in
Sign in, pick a published Data Mart, set columns and filters, then Create & Run binds the report to the worksheet.
- Your own columns and formulas stay when you refresh.
Microsoft ExcelYour columns staycostInUsdclicksimpressionsKeep Microsoft Excel connected to the same data
Ask in Claude, export to a sheet, share with the boss.
- One source, every tool.
ClaudeAsk in chat
Google SheetsExport to a sheet
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.43.0The Sheet link of a Google Sheets source opens the imported tab, not the first one
- 0.43.0Parallel reads of a SQL Data Mart on Google BigQuery no longer fail with a rate limit error
- 0.43.0Connect a Google Sheets plan with one Google sign-in
- 0.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
Why OWOX for Google BigQuery reporting
Finance and operations teams keep working in the workbook, and every number is a Data Mart your analysts defined on BigQuery.
- You own the data. It lives in your own BigQuery project, not inside an ad platform or a CRM.
- Pull, on your terms. The add-in asks OWOX for the data when you refresh the report, so there is no schedule to manage inside Excel.
- Same email as OWOX. The Microsoft account in Excel must use the same email as your OWOX profile.
- Access follows OWOX. What a person can load into the workbook depends on their OWOX access.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.