Data visualization with Azure Data Explorer

Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data that is used to build complex analytics solutions for vast amounts of data. Azure Data Explorer integrates with various visualization tools, so you can visualize your data and share the results across your organization. This data can be transformed into actionable insights to make an impact on your business.

Data visualization and reporting is a critical step in the data analytics process. Azure Data Explorer supports many BI services so you can use the one that best fits your scenario and budget.

Kusto query language visualizations

The Kusto query language render operator offers various visualizations such as tables, pie charts, and bar charts to depict query results. Query visualizations are helpful in anomaly detection and forecasting, machine learning, and more.

Power BI

Azure Data Explorer provides the capability to connect to Power BI using various methods:

Microsoft Excel

Azure Data Explorer provides the capability to connect to Microsoft Excel using the built-in native Excel connector, or import a query from Azure Data Explorer into Excel.

Grafana

Grafana provides an Azure Data Explorer plugin that enables you to visualize data from Azure Data Explorer. You set up Azure Data Explorer as a data source for Grafana, and then visualize the data.

Kibana

Azure Data Explorer provides the capability to connect to Kibana (the Discover page) using K2Bridge, an open source connector. You set up Azure Data Explorer as a data source for Kibana, and then visualize the data.

ODBC connector

Azure Data Explorer provides an Open Database Connectivity (ODBC) connector so any application that supports ODBC can connect to Azure Data Explorer.

Tableau

Azure Data Explorer provides the capability to connect to Tableau using the ODBC connector and then visualize the data in Tableau.

Qlik

Azure Data Explorer provides the capability to connect to Qlik using the ODBC connector and then create Qlik Sense dashboards and visualize the data. Using the following video, you can learn to visualize Azure Data Explorer data with Qlik.

Sisense

Azure Data Explorer provides the capability to connect to Sisense using the JDBC connector. You set up Azure Data Explorer as a data source for Sisense, and then visualize the data.

Redash

You can use Redash to build dashboards and visualize data. Set up Azure Data Explorer as a data source for Redash, and then visualize the data.