Data analysis with Kusto Query Language

In this learning path, students learn how to analyze data in various environments using the Kusto Query Language.

Prerequisites

The following prerequisite should be completed:

  • Familiarity with database structures like tables, columns, and rows

Modules in this learning path

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

Get started by writing simple queries in Kusto Query Language (KQL) to explore and gain insights from your data. Learn how to use the operators take, project, where, count, sort, and others.

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.

Write advanced queries in Kusto Query Language and gain deeper insights by combining data from several tables. Learn how to use the table-level operators lookup, join, union, and materialize, and the new aggregation functions arg_min and arg_max. Also, learn how to communicate these results visually in charts.