Organiza tus páginas con colecciones
Guarda y categoriza el contenido según tus preferencias.
Introducción a las herramientas de análisis y de inteligencia empresarial
Cuando usas una plataforma de datos como BigQuery, las herramientas de inteligencia empresarial y análisis son fundamentales para ayudarte a descubrir estadísticas de tus datos.
En este documento, se presentan varias herramientas de Google y de terceros que se complementan y se integran con BigQuery.
Hojas conectadas te permite acceder, analizar, visualizar y compartir miles de millones de filas de datos de BigQuery desde tus hojas de cálculo de Google. La interfaz de hojas conectadas simplifica la colaboración con las partes interesadas no técnicas del proyecto, no requiere exportaciones de datos adicionales, optimiza los informes y proporciona capacidades potentes de control de acceso.
Looker es la plataforma empresarial de Google para la inteligencia empresarial y la visualización de datos. Es útil para análisis de datos avanzados, análisis predictivos y aplicaciones de datos personalizados. También se puede conectar a bases de datos transaccionales en otras nubes públicas.
Looker Studio es una herramienta de Google para la inteligencia empresarial y la visualización de datos. Se conecta de forma directa a BigQuery desde la consola de Google Cloud y es útil para compilar gráficos, informes y paneles simples.
Los controladores ODBC y JDBC te permiten combinar la potencia de BigQuery con la infraestructura y las herramientas existentes que usan conexiones ODBC o JDBC populares.
Las herramientas de análisis programático pueden ejecutar código para analizar datos administrados en BigQuery. Si bien SQL es un lenguaje de consulta potente, Python, Java o R a menudo proporcionan una forma más simplificada y expresiva para realizar análisis de datos. Estas herramientas incluyen aplicaciones de código abierto basadas en la Web, como Jupyter Notebooks y Apache Zeppelin, y plataformas de desarrollo de aplicaciones estadísticas, como RStudio.
Vertex AI Workbench es una herramienta de Google que ofrece entornos de notebook de JupyterLab para el análisis programático.
[[["Fácil de comprender","easyToUnderstand","thumb-up"],["Resolvió mi problema","solvedMyProblem","thumb-up"],["Otro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Información o código de muestra incorrectos","incorrectInformationOrSampleCode","thumb-down"],["Faltan la información o los ejemplos que necesito","missingTheInformationSamplesINeed","thumb-down"],["Problema de traducción","translationIssue","thumb-down"],["Otro","otherDown","thumb-down"]],["Última actualización: 2025-04-21 (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)."]]
