Data analysis with Kusto Query Language

Learning Path
4 Modules

At a glance

Level

Beginner Intermediate Advanced
Skill

 
Product

Azure Data Explorer Azure Monitor Microsoft Sentinel Azure Log Analytics Azure Resource Graph Microsoft Defender Microsoft Configuration Manager Microsoft Fabric Azure
Role

Business Analyst Data Analyst Data Scientist Developer Security Operations Analyst Data Engineer Technology Manager
Subject

Data analytics Data management Data visualization Big data

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

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.

Write your first query with Kusto Query Language

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.

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.

Write multi-table queries by using Kusto Query Language

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.