Using Azure Workbooks to Visualize Key Metrics for Your Website

Azure Workbooks is a platform that offers a comprehensive solution for data analysis and visualization within the Azure ecosystem. It enables integration and interactive data exploration from a wide range of Azure resources.

Workbooks are highly customizable, allowing users to create tailored reports and dashboards. This feature is particularly useful for monitoring and managing Azure resources, providing insights into performance metrics, usage statistics, and operational health. The flexibility offered by Azure Workbooks in design and content makes it an essential tool for Azure administrators and users who require detailed, custom views of their data.

One of the key features of Azure Workbooks is its interactive nature, which enables users to collaborate. Users can share insights and data visualizations defined in Workbooks, aiding decision-making processes.

In this article, you will learn how to create a workbook to visualize the region of origin for your website's traffic using Azure Monitor Application Insights.

  • Click on the Workbooks tab in an existing Application Insights resource that is collecting telemetry data from your website.
  • Click on the + New button to create a new workbook.
  • Enter the following query in the query editor:
// Top 10 cities by request traffic in the past 24 hours
 | where timestamp > ago(24h) 
 | summarize count() by client_City
 | top 10 by count_ 
 | render piechart

Click on the Run Query button to execute the query. The following screenshot shows the output of the query.

Azure Webbooks​​​​

Click on the Done Editing button to exit the query editor. Then, click on the Save button to save the workbook.

Enter a name for the workbook and click on the Apply button to save the workbook.

New Web books

You can now share the workbook with other users by clicking on the Share button.

To explore the various features of Azure Workbooks, please refer to the official documentation.