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.
Play course overview
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 Takeaway 2m An Azure Data Explorer Demo 6m What Is Azure Data Explorer and Why Should I Use It? 9m ADX Key Characteristics and Use Cases 4m ADX Security 4m
Understanding and Creating Azure Data Explorer Infrastructure
Creating a Database 4m Understanding and Creating Azure Data Explorer Infrastructure 2m ADX Cost: Selecting the SKU for Your Use Case 5m Managing Cluster Scaling 5m Takeaway 1m Managing Database Permissions 5m Creating a Cluster 10m The Azure Data Explorer Web UI 3m
Ingesting Data in Azure Data Explorer
Ingesting Data Using the .NET Standard SDK 5m Ingesting Data from a Folder or Blob Container with LightIngest 7m Ingesting Data Using the Python SDK 4m Ingesting Sample Data 4m Ingesting Blobs by Subscribing to Event Grid Notifications 6m Ingesting Data from Event Hubs 7m Ingesting JSON Formatted Data 2m Data Ingestion with Azure Data Factory 8m Takeaway 1m Ingesting Data in Azure Explorer 7m Loading Data Using One-click Ingestion 5m
Querying Data in Azure Data Explorer
Querying Data in Azure Monitor and Using the Flow Kusto Connector 2m Takeaway 2m Getting to Know the Kusto Query Language (KQL) 6m Querying External Tables 4m Querying Azure Data Explorer, the Help Cluster, and the Sample Database 2m The Basics of KQL - Most Commonly Used Operators 14m Advanced KQL 5m Exporting Data 3m Getting Started with Kusto Control Commands 7m More KQL Operators 6m Querying Data in Azure Data Explorer 3m
Visualizing Data in Azure Data Explorer
Visualizing Data in Tableau with the ODBC Connector 4m Visualizing Data in Redash 3m Visualizing Data in Azure Data Explorer 3m Visualizing Data in Grafana 4m Visualizing Data in Kibana with the K2Bridge Open-source Connector 8m Takeaway 1m Visualizing Data Using Power BI 6m Visualizing the Results of a Query with the Render Operator 4m Visualizing Data in Sisense with the JDBC Connector 4m Data Visualization Using the Azure Data Explorer Dashboard 9m
Monitoring in Azure Data Explorer
Monitoring in Azure Data Explorer 1m Takeaway 2m Use Resource Health to Monitor Cluster Health 1m Troubleshooting 3m Adding Diagnostic Logs to Monitor Ingestion 3m 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
Computer Vision: Executive Briefing
Beginner
29m
Apr 1, 2020
Feature Selection and Extraction in Microsoft Azure
Intermediate
1h 27m
Dec 12, 2019
More courses by Xavier Morera
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Oyamada and welcome to my course out. To start with Microsoft Asher, 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 that you know that Asher Data Explorer code named Who Stole It's what Microsoft themselves have been using for years as their own interactive Big Data Analytics platform for Windows, Skype, Xbox lengthen office, Asher Lock 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 discourse. We're going to learn and to end what we need to know on how to get started with Microsoft Basher data Export. Some of the major topics that will cover include ah high level overview and Understanding Off Data Explorer. How to create in Scale Data Explorer infrastructure. How to in just data into Data Explorer, using several different ingestion methods from varied sources. Then I will give you a _____ course on querying using the Cousteau Perry language or Cake UL, followed by how to visualize data using different methods, including the render operator, the 80 x Dashboard Power bi I give Ana Ravana rehash tableau insistence to name a few. By the end of this course, you'll know how to use Asher data. Explore Microsoft's interactive big data platform before beginning the course. You should be familiar with the basics off Microsoft Asher. I hope you'll join me on this journey to learn how to in just where we analyze and visualize data with how to start with Microsoft Basher Data Explorer course at plural site.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT