Build Data Studio dashboards from Bank of Canada data
Load the Bank of Canada exchange rates into your data warehouse first, join them to visits and revenue by date and currency, then feed Data Studio dashboards from the Data Mart.
Bank of CanadaConnectedExchange Rates
Data StudioDateLabelRateDaily 09:00A Data Studio dashboard on Bank of Canada rates draws a rate chart, but cannot restate your revenue in Canadian dollars.
Paste this into your AI assistant. It loads Bank of Canada rates into your data warehouse with OWOX Data Marts, joins them to your visits and revenue by date and currency, and feeds Data Studio from that Data Mart.
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/bank-of-canada-connector-to-data-studio.md. The task: load Bank of Canada exchange rates into my data warehouse, join them to my visits and revenue by date and currency, and build a Data Studio dashboard of revenue in Canadian dollars by month. 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
Bank of Canada Endpoints
1 Bank of Canada endpoints you can import. Each lands in its own table in your data warehouse.
Why Bank of Canada does not go straight to Data Studio
The Bank of Canada publishes official daily rates, and a dashboard pointed straight at them can draw a rate chart and nothing more. It does not restate your revenue in Canadian dollars, because the visits, currencies and dates it needs live in your own systems. A dashboard is not built to join them reliably, at scale or business-ready, so the join happens in a warehouse first.
- Official rates say what a dollar was worth on a date, not what a visit earned
- The data analyst joins rates to each visit's date and currency by SQL keys and controls the result
- Dashboard viewers read revenue in one currency from a table with one definition
Bank of CanadaOfficial FX ratesData Studio
Data warehouseJoined by idStep 1: Load Bank of Canada into your data warehouse first
Create a Data Mart with Bank of Canada as the source and choose where the data lands. It works with any popular data warehouse.
- One endpoint, Exchange Rates, with three fields: date, label and rate
- The source needs no credentials
- Open the Bank of Canada connector for your data warehouse below
Bank of Can…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksbank_of_canada.exchange_ratesStep 2: Link Bank of Canada rates to visits
In your data warehouse your data analyst joins the official rate table to each visit's date and currency, so local revenue can be restated in Canadian dollars. The model supplies the visits and the measures.
- The rate table sits beside Visits
- They join on visit date and currency plus CAD, so a USD visit matches USDCAD; CAD visits take a rate of 1
- Measures such as revenue_per_visit are defined once, on the stored USD amount
Bank of CanadaExchange RatesStep 3: Feed Data Studio dashboards with Bank of Canada rates
Add Data Studio as a destination of the Bank of Canada Data Mart and build the on it. The charts read date, label and rate from your data warehouse, already joined to your visits.
- Turn on Available in Data Studio for the published Bank of Canada Data Mart, then add the OWOX connector in Data Studio
- A rate chart and revenue in Canadian dollars come from the same table
Data StudioExchange Rates
Google SheetsSame Data Mart
ClaudeSame Data MartStep 4: Use the same Bank of Canada Data Mart in a sheet or an assistant
The Data Mart you built for the dashboard is not locked to it. Open the same rates in a spreadsheet or ask about them in an AI assistant, and the restated revenue matches the dashboard.
- Finance opens the rate table in a spreadsheet without a second export
- An assistant answers from the same Data Mart, so one date gives one rate
Data StudioDashboardGoogle SheetsSame Data MartClaudeSame Data MartStep 5: Reuse Bank of Canada inside OWOX MCP
The same Data Mart works in OWOX MCP, your assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.
- Ask for revenue in Canadian dollars by month in plain words
- The rate-to-visit join is defined once and every report reads it
Google SheetsOpen
ExcelOpen
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.36.0Start a connector run without expanding the Input Source card
- 0.35.0Resume an interrupted manual backfill from the last fully loaded date
- 0.35.0Limit manual backfill to 31 days per run
Why OWOX for Bank of Canada in Data Studio
A dashboard on the Bank of Canada site shows rates. OWOX keeps the official rates in your data warehouse, joined to your revenue, so Data Studio shows the business.
- You own the data. It lands in your own data warehouse, in tables you control.
- Rates tied to revenue. Daily rates are joined to each visit by date and currency, so restated revenue comes from SQL, not from a lookup in the chart.
- No account to maintain. Bank of Canada rates need no key, so the dashboard has no credentials to rotate.
- Maintained for you. No scripts to fix when the Bank of Canada changes its API.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.