Learn Azure Synapse Data Explorer

6

Data Analysis and Exploration with KQL and Python

Now that you’ve learned how to ingest data into Data Explorer pools, let’s look at ways to analyze this data to extract the insights you need to support a decision-making process. Part of the data analysis process is to explore your data, see its shape, and adjust it to make it more useful for you and other consumers of this data. There’s no unique way to analyze data, so in this chapter, you will explore different means to achieve this task.

The chapter starts with an overview of data analysis using Kusto Query Language (KQL). You will look at examples to help retrieve data, summarize it, visualize it in simple charts, and make sense of the data by looking at its distribution. Before you move ...