[FAQ] Connecting BigQuery to BI Tools (Looker Studio / Tableau)

[kkh1902]

Course

data-engineering-zoomcamp

Question

How do you connect BigQuery with BI tools like Looker Studio or Tableau?

Answer

BigQuery can be directly connected to popular BI tools such as
Looker Studio (Google Data Studio) and Tableau to build dashboards and reports.

---

Connecting BigQuery to Looker Studio

Steps:

1. Go to Looker Studio (datastudio.google.com)
2. Click Create → Data source → BigQuery
3. Select the project, dataset, and table
4. Click Connect
5. Create charts and dashboards

Best choice for:

• Quick dashboards
• Simple visualizations
• Tight integration with Google Cloud

---

Connecting BigQuery to Tableau

Steps:

1. Open Tableau Desktop
2. Click Connect → To a Server → Google BigQuery
3. Sign in with your Google account
4. Select a project and dataset
5. Choose a table or use Custom SQL

Example (Custom SQL):

SELECT
  DATE(pickup_datetime) AS date,
  COUNT(*) AS trips,
  SUM(total_amount) AS revenue
FROM `project.dataset.trips`
WHERE DATE(pickup_datetime) >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY date;

Checklist

• I have searched existing FAQs and this question is not already answered
• The answer provides accurate, helpful information
• I have included any relevant code examples or links

[github-actions]

✅ FAQ NEW proposal created in PR #74

Please review and approve the changes.