Data analysis in Azure Data Explorer with Kusto Query Language 

Introduction

What is Azure Data Explorer?

How Azure Data Explorer works

When to use Azure Data Explorer

Knowledge check

Summary

Introduction

Understand the basic structure of a Kusto query

Exercise - Connect to resources

Exercise - Return a specific number of rows by using the take operator

Exercise - Select columns to return by using the project operator

Exercise - Filter data by using the where operator

Exercise - Reorder returned data by using the sort operator

Challenge

Solution

Knowledge check

Summary

Introduction

Group data using aggregate functions

Exercise - Connect to resources

Exercise - Count events using the count function

Exercise - Visualize data with the render operator

Exercise - Summarize data using aggregate functions

Exercise - Introduce variables using the let statement

Challenge

Solution

Knowledge check

Summary

Introduction

Combine and optimize data

Exercise - Connect to resources

Exercise - Combine table results using the join operator

Exercise - Combine table results using the lookup operator

Exercise - Combine table results using the union operator

Exercise - Optimize queries by using the materialize function

Knowledge check

Summary

Introduction

Exercise: Connect to resources

Characterize data with Azure Data Explorer

Exercise: Take a first look at your data

Explore the data structure using queries

Exercise: Use queries to explore your data

Exercise: Use queries to explore trends

Exercise: Share queries with others

Knowledge check

Summary

Introduction

Exercise: Connect to resources

Dashboards in Azure Data Explorer

Exercise: Create a dashboard from a query

Exercise: Add a new tile

Dashboard parameters

Exercise: Create a dashboard parameter

Exercise: Create a cross-filter

Share dashboards

Knowledge check

Summary