How to Start with Microsoft Azure Data Explorer
Learn how to ingest, query, analyze, and visualize large amounts of data with Azure Data Explorer, Microsoft's interactive Big Data analytics platform.
What you'll learn
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.
Table of contents
- Ingesting Data in Azure Explorer 7m
- Ingesting Sample Data 4m
- Loading Data Using One-click Ingestion 5m
- Ingesting Data from a Folder or Blob Container with LightIngest 7m
- Data Ingestion with Azure Data Factory 8m
- Ingesting Data from Event Hubs 7m
- 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 JSON Formatted Data 2m
- Takeaway 1m
- Querying Data in Azure Data Explorer 3m
- Getting to Know the Kusto Query Language (KQL) 6m
- Querying Azure Data Explorer, the Help Cluster, and the Sample Database 2m
- Getting Started with Kusto Control Commands 7m
- The Basics of KQL - Most Commonly Used Operators 14m
- More KQL Operators 6m
- Advanced KQL 5m
- Querying External Tables 4m
- Querying Data in Azure Monitor and Using the Flow Kusto Connector 2m
- Exporting Data 3m
- Takeaway 2m
- Visualizing Data in Azure Data Explorer 3m
- Visualizing the Results of a Query with the Render Operator 4m
- Data Visualization Using the Azure Data Explorer Dashboard 9m
- Visualizing Data Using Power BI 6m
- Visualizing Data in Grafana 4m
- Visualizing Data in Redash 3m
- Visualizing Data in Kibana with the K2Bridge Open-source Connector 8m
- Visualizing Data in Tableau with the ODBC Connector 4m
- Visualizing Data in Sisense with the JDBC Connector 4m
- Takeaway 1m
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. He has spent a great deal of his career working on cutting-edge projects with a primary focus on .NET, Solr, and Hadoop among a few other interesting technologies. Throughout multiple projects, he has acquired skills to deal... more