Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Pengantar alat analisis dan business intelligence
Saat Anda menggunakan platform data seperti BigQuery, alat analisis dan business intelligence sangat penting untuk membantu menemukan insight dari data Anda.
Dokumen ini menampilkan beberapa alat Google dan pihak ketiga yang melengkapi dan
terintegrasi dengan BigQuery.
Sheet yang Terhubung memungkinkan Anda
mengakses, menganalisis, memvisualisasikan, dan membagikan miliaran baris
data BigQuery dari
spreadsheet Google Spreadsheet. Antarmuka
Sheet yang Terhubung menyederhanakan kolaborasi dengan
pemangku kepentingan project non-teknis, tidak memerlukan ekspor data tambahan,
mengefisienkan pelaporan, dan memberikan kemampuan kontrol akses yang andal.
Looker adalah platform perusahaan milik Google untuk visualisasi data dan business
intelligence. Platform ini berguna untuk analisis data lanjutan, analisis prediktif, dan
aplikasi data kustom. Platform ini juga dapat terhubung ke database transaksi di
cloud publik lainnya.
Looker Studio adalah
alat Google untuk visualisasi data dan business intelligence. Platform ini terhubung
langsung ke BigQuery dari konsol Google Cloud dan berguna
untuk membuat grafik, laporan, dan dasbor sederhana.
Driver ODBC dan JDBC memungkinkan Anda
menggabungkan kecanggihan BigQuery dengan alat dan
infrastruktur yang ada dan menggunakan koneksi ODBC atau JDBC yang populer.
Alat analisis terprogram dapat menjalankan kode
untuk menganalisis data yang dikelola di BigQuery. Meskipun SQL adalah bahasa kueri yang
andal, Python, Java, atau R sering menyediakan cara yang lebih sederhana dan ekspresif
untuk melakukan analisis data. Alat tersebut mencakup aplikasi berbasis web
open source seperti
Jupyter Notebooks dan
Apache Zeppelin, serta
platform untuk pengembangan aplikasi statistik seperti
RStudio.
Vertex AI Workbench adalah
alat Google yang menawarkan lingkungan notebook JupyterLab untuk
analisis terprogram.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 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)."]]
