Data analysis with Kusto Query Language

  • Learning Path
  • 4 Modules
Beginner
Intermediate
Advanced
Business Analyst
Data Analyst
Data Scientist
Developer
Security Operations Analyst
Data Engineer
Technology Manager
Azure Data Explorer
Azure Monitor
Microsoft Sentinel
Azure Log Analytics
Azure Resource Graph
Microsoft Defender
Microsoft Configuration Manager
Microsoft Fabric
Azure

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 to 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.