Introduction to analysis and business intelligence tools

When you use a data platform like BigQuery, analysis and businessintelligence tools are crucial to helping you discover insights from your data.This document presents several Google and third-party tools that complement andintegrate with BigQuery.

Connected Sheets lets youaccess, analyze, visualize, and share billions of rows ofBigQuery data from yourGoogle Sheets spreadsheets. TheConnected Sheets interface simplifies collaboration withnon-technical project stakeholders, requires no additional data exports,streamlines reporting, and provides powerful access control capabilities.

Lookeris Google's enterprise platform for data visualization and businessintelligence. It is useful for advanced data analytics, predictive analysis, andcustom data applications. It can also connect to transactional databases inother public clouds.

Looker Studio is aGoogle tool for data visualization and business intelligence. It connects toBigQuery directly from the Google Cloud console and is usefulfor building simple graphics, reports, and dashboards.

ODBC and JDBC drivers let youcombine the power of BigQuery with your existing tooling andinfrastructure that use popular ODBC or JDBC connections.

Programmatic analysis tools can run codeto analyze data managed in BigQuery. While SQL is a powerfulquery language, Python, Java, or R often provide a more simplified, expressiveway to perform data analysis. Such tools include open source web-basedapplications likeJupyter Notebooks andApache Zeppelin.Vertex AI Workbench is aGoogle tool that offers JupyterLab notebook environments forprogrammatic analysis.

You can also connect to BigQuery using a number of popularthird-party tools such asTableauandMicrosoft Power BI.The BigQuery Ready program offers afull list of validated partner solutions.

What's next

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026-02-19 UTC.