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 Morera is driven by one passion: taking on the challenge of understanding complex topics and sharing that knowledge with others. He’s currently focused on the transformative fields of AI, machine learning, generative AI, search, and big data. As an entrepreneur, project manager, technical author, and trainer, Xavier brings a diverse set of skills and deep expertise to every project he takes on. He holds multiple certifications with Cloudera, Microsoft, and the Scrum Alliance and has been... more