Data analysis in Azure Data Explorer with Kusto Query Language

  • Learning Path
  • 4 Modules

At a glance

In this learning path, students will learn how to analyze data in Azure Data Explorer using the Kusto Query Language.

Prerequisites

The following pre-requisite should be completed:

  • A Microsoft account, a Microsoft Entra user identity to create a free cluster, or an Azure account
  • Familiarity with database structures like tables, columns, and rows

Get started with Azure

Choose the Azure account that's right for you. Pay as you go or try Azure free for up to 30 days. Sign up.

Modules in this learning path

Introduction to Azure Data Explorer

Learn to describe the ingestion, query, visualization, and data management features that Azure Data Explorer provides to help you make sense of the data flowing into your business. Determine the types of data analysis for which Azure Data Explorer is a good data management platform.

Explore the fundamentals of data analysis using Kusto Query Language (KQL)

Learn about the basics of Kusto Query Language (KQL), and the various Microsoft products that use it.

Gain insights from your data by using Kusto Query Language

Write advanced queries in Kusto Query Language to help you gain insights from your data. Use the aggregation functions count, dcount, countif, sum, min, max, avg, percentiles, and others. Communicate these results visually in charts.

Create dashboards in Azure Data Explorer

Create a dashboard from a query in Azure Data Explorer web UI. Add new tiles. Create dashboard parameters, and cross-filters for the parameters.