How to Start with Microsoft Azure Data Explorer

By Xavier Morera
Learn how to ingest, query, analyze, and visualize large amounts of data with Azure Data Explorer, Microsoft's interactive Big Data analytics platform.
Register and start for FREE
Course info
Level
Beginner
Updated
Jun 29, 2020
Duration
4h 6m
Table of contents
Course Overview
Course Overview 2m
Getting Started with Azure Data Explorer: Overview and Architecture
ADX Architecture, Components, and Scalability 4m ADX Key Characteristics and Use Cases 4m ADX Security 4m An Azure Data Explorer Demo 6m Takeaway 2m What Is Azure Data Explorer and Why Should I Use It? 9m
Understanding and Creating Azure Data Explorer Infrastructure
ADX Cost: Selecting the SKU for Your Use Case 5m Creating a Cluster 10m Creating a Database 4m Managing Cluster Scaling 5m Managing Database Permissions 5m Takeaway 1m The Azure Data Explorer Web UI 3m Understanding and Creating Azure Data Explorer Infrastructure 2m
Ingesting Data in Azure Data Explorer
Data Ingestion with Azure Data Factory 8m Ingesting Blobs by Subscribing to Event Grid Notifications 6m Ingesting Data Using the .NET Standard SDK 5m Ingesting Data Using the Python SDK 4m Ingesting Data from Event Hubs 7m Ingesting Data from a Folder or Blob Container with LightIngest 7m Ingesting Data in Azure Explorer 7m Ingesting JSON Formatted Data 2m Ingesting Sample Data 4m Loading Data Using One-click Ingestion 5m Takeaway 1m
Querying Data in Azure Data Explorer
Advanced KQL 5m Exporting Data 3m Getting Started with Kusto Control Commands 7m Getting to Know the Kusto Query Language (KQL) 6m More KQL Operators 6m Querying Azure Data Explorer, the Help Cluster, and the Sample Database 2m Querying Data in Azure Data Explorer 3m Querying Data in Azure Monitor and Using the Flow Kusto Connector 2m Querying External Tables 4m Takeaway 2m The Basics of KQL - Most Commonly Used Operators 14m
Visualizing Data in Azure Data Explorer
Data Visualization Using the Azure Data Explorer Dashboard 9m Takeaway 1m Visualizing Data Using Power BI 6m Visualizing Data in Azure Data Explorer 3m Visualizing Data in Grafana 4m Visualizing Data in Kibana with the K2Bridge Open-source Connector 8m Visualizing Data in Redash 3m Visualizing Data in Sisense with the JDBC Connector 4m Visualizing Data in Tableau with the ODBC Connector 4m Visualizing the Results of a Query with the Render Operator 4m
Monitoring in Azure Data Explorer
Adding Diagnostic Logs to Monitor Ingestion 3m Monitoring in Azure Data Explorer 1m Takeaway 2m Troubleshooting 3m Use Resource Health to Monitor Cluster Health 1m Using Metrics to Monitor Cluster Health 8m
Final Takeaway
Final Takeaway 5m
Description
Course info
Level
Beginner
Updated
Jun 29, 2020
Duration
4h 6m
Description

Data gives you insights, helps you predict trends and discover anomalies, and gives you a competitive advantage. In this course, How to Start with Microsoft Azure Data Explorer, you'll learn the foundational knowledge needed to ingest, query, analyze, and visualize large amounts of data with Azure Data Explorer.

First, you'll understand the architecture of Data Explorer. Next, you'll learn how create and scale infrastructure, ingest data, and query using the Kusto Query Language, also known as KQL. Finally, you'll learn how to visualize data from within ADX or integrating with a third-party product like Power BI, Grafana, Redash, Tableau, Sisense, and any other platform that uses ODBC and JDBC.

When you're finished with this course, you'll have the skills and knowledge required to analyze all kinds of data, including log and telemetry data, using Azure Data Explorer - Microsoft's interactive Big Data platform.

About the author
Xavier Morera
About the author

Xavier is very passionate about teaching, helping others understand search and Big Data. He is also an entrepreneur, project manager, technical author, trainer, and holds a few certifications with Cloudera, Microsoft, and the Scrum Alliance, along with being a Microsoft MVP.

More from the author
Getting Started with JSON in C# Using Json.NET
Intermediate
3h 47m
Aug 5, 2020
Computer Vision: Executive Briefing
Beginner
29m
Apr 1, 2020
More courses by Xavier Morera
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Xavier Morera, and welcome to my course, How to Start with Microsoft Azure Data Explorer. I am very passionate about working with data in the cloud, something that I've been doing for quite a few years now. Did you know that Azure Data Explorer, code named Kusto, is what Microsoft themselves have been using for years as their own interactive big data analytics platform for Windows, Skype, Xbox, LinkedIn, Office, Azure Log Analytics, Application Insights, and many more products that generate large amounts of data. And now it is available for you to work with your data. In this course, we're going to learn end to end what we need to know on how to get started with Microsoft Azure Data Explorer. Some of the major topics that we will cover include a high‑level overview and understanding of Data Explorer, how to create and scale Data Explorer infrastructure, how to ingest data into Data Explorer using several different ingestion methods from varied sources. Then, I will give you a crash course on querying using the Kusto query language, or KQL, followed by how to visualize data using different methods, including the render operator, the ADX dashboard, Power BI, Kibana, Grafana, Redash, Tableau, and Sisense, to name a few. By the end of this course, you'll know how to use Azure Data Explorer, Microsoft's interactive big data platform. Before beginning the course, you should be familiar with the basics of Microsoft Azure. I hope you'll join me on this journey to learn how to ingest, query, analyze, and visualize data with the How to Start with Microsoft Azure Data Explorer course, at Pluralsight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT