Gain insights from your data by using Kusto Query Language

Module
11 Units

Intermediate

Business Analyst

Data Analyst

Data Scientist

Developer

Security Operations Analyst

Azure Data Explorer

Azure

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.

Learning objectives

By the end of this module, you should be able to:

Use the Kusto Query Language to gain insights from your data by using the aggregation functions count, dcount, countif, sum, min, max, avg, percentiles, and others.
Communicate query results visually using the render operator.
Assign variables by using a let statement.

Prerequisites

An Azure subscription; you can create a free Azure account
Familiarity with database structures like tables, columns, and rows
Familiarity with Kusto Query Language operators such as count, take, project, where, and sort

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.

Introduction min
Group data using aggregate functions min
Exercise - Connect to resources min
Exercise - Count events using the count function min
Exercise - Visualize data with the render operator min
Exercise - Summarize data using aggregate functions min
Exercise - Introduce variables using the let statement min
Challenge min
Solution min
Module assessment min
Summary min