# Introduction to analysis and business intelligence tools

You can integrate analysis and business intelligence (BI) tools with
BigQuery to discover actionable insights from your data
warehouse. Several tools complement BigQuery, letting you build
interactive dashboards, create custom data applications, or perform
programmatic analysis without moving your datasets.

## Connected Sheets

[Connected Sheets](https://docs.cloud.google.com/bigquery/docs/connected-sheets) lets you
access, analyze, visualize, and share billions of rows of
BigQuery data from your
[Google Sheets spreadsheets](https://www.google.com/sheets/about/). The
Connected Sheets interface simplifies collaboration with
non-technical project stakeholders, requires no additional data exports,
streamlines reporting, and provides powerful access control capabilities.

## Looker

[Looker](https://docs.cloud.google.com/bigquery/docs/looker)
is Google's enterprise platform for data visualization and business
intelligence. It is useful for advanced data analytics, predictive analysis, and
custom data applications. It can also connect to transactional databases in
other public clouds.

## Data Studio

[Data Studio](https://docs.cloud.google.com/bigquery/docs/visualize-looker-studio) is a
Google tool for data visualization and business intelligence. It connects to
BigQuery directly from the Google Cloud console and is useful
for building simple graphics, reports, and dashboards.

## ODBC and JDBC drivers

[ODBC and JDBC drivers](https://docs.cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers) let you
combine the power of BigQuery with your existing tooling and
infrastructure that use popular ODBC or JDBC connections.

## Programmatic analysis tools

[Programmatic analysis tools](https://docs.cloud.google.com/bigquery/docs/programmatic-analysis) can run code
to analyze data managed in BigQuery. While SQL is a powerful
query language, Python, Java, or R often provide a more simplified, expressive
way to perform data analysis. Such tools include open source web-based
applications like
Jupyter Notebooks and Apache Zeppelin.
[Vertex AI Workbench](https://docs.cloud.google.com/gemini-enterprise-agent-platform/notebooks/workbench/introduction) is a
Google tool that offers JupyterLab notebook environments for
programmatic analysis.

## Third-party tools

You can also connect to BigQuery using a number of popular
third-party tools such as
[Tableau](https://help.tableau.com/current/pro/desktop/en-us/examples_googlebigquery.htm)
and [Microsoft Power BI](https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery).
The BigQuery Ready program offers a
[full list of validated partner solutions](https://docs.cloud.google.com/bigquery/docs/bigquery-ready-partners).

## What's next

- Learn to [use Connected Sheets](https://docs.cloud.google.com/bigquery/docs/connected-sheets).
- [Visualize data in Data Studio](https://docs.cloud.google.com/bigquery/docs/visualize-looker-studio).
- Learn to [use Looker](https://docs.cloud.google.com/bigquery/docs/looker).
- Learn to [use ODBC and JDBC drivers](https://docs.cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers).
- Learn to [use programmatic analysis tools](https://docs.cloud.google.com/bigquery/docs/programmatic-analysis).
- [Use third-party tools](https://docs.cloud.google.com/bigquery/docs/third-party-integration).