Business Intelligence, Data Warehouse and Data Lake

SQW08 Data Exploration with Synapse and KQL

11/16/2022

4:00pm - 5:15pm

Level: Introductory

Kevin Feasel

Proprietor

Catallaxy Services, LLC

With Data Explorer pools, Azure Synapse Analytics now supports the Kusto Query Language (KQL). Originally designed for log analysis, KQL is also a great fit for time series analysis. If you're familiar with T-SQL but have not looked at KQL, let's come together and see how the language works. We will learn how to ingest data into a Data Explorer database and then query and visualize this data using Power BI.

You will learn:

  • Where Data Explorer pools fit into the Synapse ecosystem
  • See how Data Explorer pools are useful for more than log analysis
  • The basics of the Kusto Query Language (KQL)