Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Introdução à análise e às ferramentas de Business Intelligence
Quando você usa uma plataforma de dados, como o BigQuery, as ferramentas de análise e de Business Intelligence são cruciais para ajudar a descobrir insights dos seus dados.
Este documento apresenta várias ferramentas do Google e de terceiros que complementam e se integram ao BigQuery.
As páginas conectadas permitem
acessar, analisar, visualizar e compartilhar bilhões de linhas de
dados do BigQuery das suas
planilhas do Planilhas Google. A interface do "páginas conectadas" simplifica a colaboração com partes interessadas não técnicas do projeto, não requer exportações de dados adicionais, simplifica a geração de relatórios e oferece recursos avançados de controle de acesso.
O Looker
é a plataforma corporativa do Google para visualização de dados e Business Intelligence. Ele é útil para análises avançadas de dados, análises preditivas e
aplicativos de dados personalizados. Ele também se conecta a bancos de dados transacionais em
outras nuvens públicas.
O Looker Studio é uma ferramenta do Google para visualização de dados e Business Intelligence. Ele se conecta
ao BigQuery diretamente do console Google Cloud e é útil
para criar gráficos, relatórios e painéis simples.
Os drivers ODBC e JDBC permitem combinar a capacidade do BigQuery com suas ferramentas e infraestrutura atuais que usam conexões ODBC ou JDBC conhecidas.
As ferramentas de análise programática podem executar código
para analisar dados gerenciados no BigQuery. Embora o SQL seja uma linguagem de consulta
eficaz, Python, Java ou R geralmente oferecem uma maneira mais simplificada e expressiva
de realizar análise de dados. Essas ferramentas incluem aplicativos de código aberto baseados
na Web, como
Jupyter Notebooks e
Apache Zeppelin, assim como
plataformas para desenvolvimento de aplicativos estatísticos como o
RStudio.
O Vertex AI Workbench é uma ferramenta do Google que oferece ambientes de notebook do JupyterLab para análise programática.
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 2025-09-04 UTC."],[[["\u003cp\u003eAnalysis and business intelligence tools are essential for extracting insights from data within platforms like BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eGoogle offers several tools, including Connected Sheets, Looker, and Looker Studio, for data analysis, visualization, and collaboration with BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eODBC and JDBC drivers enable the integration of BigQuery with existing systems that use these connection methods.\u003c/p\u003e\n"],["\u003cp\u003eProgrammatic analysis tools like Jupyter Notebooks, Apache Zeppelin, and RStudio, along with Google's Vertex AI Workbench, provide coding environments for in-depth data analysis within BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eVarious third-party tools, such as Tableau and Microsoft Power BI, can also connect to BigQuery for data analysis and visualization.\u003c/p\u003e\n"]]],[],null,["# Introduction to analysis and business intelligence tools\n========================================================\n\nWhen you use a data platform like BigQuery, analysis and business\nintelligence tools are crucial to helping you discover insights from your data.\nThis document presents several Google and third-party tools that complement and\nintegrate with BigQuery.\n\n[Connected Sheets](/bigquery/docs/connected-sheets) lets you\naccess, analyze, visualize, and share billions of rows of\nBigQuery data from your\n[Google Sheets spreadsheets](https://www.google.com/sheets/about/). The\nConnected Sheets interface simplifies collaboration with\nnon-technical project stakeholders, requires no additional data exports,\nstreamlines reporting, and provides powerful access control capabilities.\n\n[Looker](/bigquery/docs/looker)\nis Google's enterprise platform for data visualization and business\nintelligence. It is useful for advanced data analytics, predictive analysis, and\ncustom data applications. It can also connect to transactional databases in\nother public clouds.\n\n[Looker Studio](/bigquery/docs/visualize-looker-studio) is a\nGoogle tool for data visualization and business intelligence. It connects to\nBigQuery directly from the Google Cloud console and is useful\nfor building simple graphics, reports, and dashboards.\n\n[ODBC and JDBC drivers](/bigquery/docs/reference/odbc-jdbc-drivers) let you\ncombine the power of BigQuery with your existing tooling and\ninfrastructure that use popular ODBC or JDBC connections.\n\n[Programmatic analysis tools](/bigquery/docs/programmatic-analysis) can run code\nto analyze data managed in BigQuery. While SQL is a powerful\nquery language, Python, Java, or R often provide a more simplified, expressive\nway to perform data analysis. Such tools include open source web-based\napplications like\n[Jupyter Notebooks](/bigquery/docs/programmatic-analysis#jupyter_notebooks) and\n[Apache Zeppelin](/bigquery/docs/programmatic-analysis#apache_zeppelin), as well\nas platforms for statistical application development like\n[RStudio](/bigquery/docs/programmatic-analysis#rstudio).\n[Vertex AI Workbench](/vertex-ai/docs/workbench/introduction) is a\nGoogle tool that offers JupyterLab notebook environments for\nprogrammatic analysis.\n\nYou can also connect to BigQuery using a number of popular\nthird-party tools such as\n[Tableau](https://help.tableau.com/current/pro/desktop/en-us/examples_googlebigquery.htm)\nand [Microsoft Power BI](https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery).\nThe BigQuery Ready program offers a\n[full list of validated partner solutions](/bigquery/docs/bigquery-ready-partners).\n\nWhat's next\n-----------\n\n- Learn to [use Connected Sheets](/bigquery/docs/connected-sheets).\n- [Visualize data in Looker Studio](/bigquery/docs/visualize-looker-studio).\n- Learn to [use Looker](/bigquery/docs/looker).\n- Learn to [use ODBC and JDBC drivers](/bigquery/docs/reference/odbc-jdbc-drivers).\n- Learn to [use programmatic analysis tools](/bigquery/docs/programmatic-analysis).\n- [Use third-party tools](/bigquery/docs/third-party-integration)."]]
