In this course, Microsoft Azure Data Explorer – Advanced KQL, you will learn functions in the Kusto Query Language (KQL) targeted at advanced analytics and time series analysis, and explore the use of inline python to expand the capabilities of KQL. First, you will discover data analysis using a variety of clustering algorithms. Next, you will learn time series analysis and geospatial analysis. Finally, you will explore how to call Python or R code from KQL. When you are finished with this course, you will know many of the advanced techniques for working with data using Kusto Query Language from within the Azure Data Explorer.
Author Name: Robert Cain
Author Description:
Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years’ experience in the IT industry, working in a variety of fields including manufacturing, insurance, teleco… more

Table of Contents

• Course Overview
  1min
• Introduction
  17mins
• Exploring User Analytics
  43mins
• Executing Geographic Analysis
  28mins
• Performing Diagnostic and Root Cause Analysis
  18mins
• Time Series Analysis 1 – Creation and Core Functions
  23mins
• Time Series Analysis 2 – Anomaly Detection and Forecasting
  15mins
• Extensibility Using Inline Python / R
  19mins
• Summary
  3mins