5 ways to utilize ADX Free Cluster
Creating your own?free cluster?(aka.ms/kustofree) is a fun way to explore some of the incredible capabilities of Azure Data Explorer, which is a fast and highly scalable data exploration service for log and telemetry data. If you have a Microsoft account or an Azure Active Directory user identity, you can create your own free Azure Data Explorer cluster without needing an Azure subscription or a credit card.
The cluster's trial period is for a year and may automatically be extended. At any time, you can upgrade the cluster to a full Azure Data Explorer cluster.
One of the best ways to learn Kusto Query Language (query language used by Azure Data Explorer) is through Kusto Detective Agency It's a fun unguided way to experience ADX. The 2022 season comes with a total of 5 cases and lots of badges and prizes to be won. If you have already attempted KDA, you must have spun your free cluster too. If not, I would strongly suggest you try out KDA first.
Below are some of the ways you can use the same free cluster and continue your ADX learning journey:
1. Unlock achievements with Microsoft Learn Training modules(5) for ADX
Learn to describe the ingestion, query, visualization, and data management features that Azure Data Explorer provides to help you make sense of the data flowing into your business. Determine the types of data analysis for which Azure Data Explorer is a good data management platform.
Get started by writing simple queries in Kusto Query Language (KQL) to explore and gain insights from your data. Learn how to use the operators?take,?project,?where,?count,?sort, and others.
Write advanced queries in Kusto Query Language to help you gain insights from your data. Use the aggregation functions?count,?dcount,?countif,?sum,?min,?max,?avg,?percentiles, and others. Communicate these results visually in charts.
Characterize the schema, range, and completeness of a dataset using Azure Data Explorer. Use queries to visualize data trends, and then share these queries and results with others.
Create a dashboard from a query in Azure Data Explorer web UI. Add new tiles. Create dashboard parameters and cross-filters for the parameters.
2. Deep-dive into ADX by taking Pluralsight courses(3) for free
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. You'll learn how to 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 integrate with a third-party product like Power BI, Grafana, Redash, Tableau, Sisense, and any other platform that uses ODBC and JDBC.?
领英推荐
In this course, Kusto Query Language (KQL) from Scratch, you will learn foundational knowledge to query a variety of Azure services. First, you will learn the basics of KQL, the Kusto Query Language. Next, you will progress to advanced KQL abilities such as machine learning and time series analysis. Finally, you will explore how to export the results of your KQL queries to CSV files and PowerBI. When you're finished with this course, you will have the skills and knowledge of the Kusto Query Language needed to gain valuable insights into your Azure services.
In this course, Microsoft Azure Data Explorer - Advanced KQL, you will learn functions in the Kusto Query Language (KQL) targeted at advanced analytics and time series analysis, and explore the use of inline python to expand the capabilities of KQL. First, you will discover data analysis using a variety of clustering algorithms. Next, you will learn time series analysis and geospatial analysis. Finally, you will explore how to call Python or R code from KQL. When you are finished with this course, you will know many of the advanced techniques for working with data using Kusto Query Language from within Azure Data Explorer.
Don't forget to click on the "Redeem this benefit" button to get the free access
3. Turn yourself from Detective to a scientist by deploying Kusto Labs
These are self-contained, hands-on-labs with detailed and step-by-step instructions, and associated collateral (data, code, etc) on trying out various features and integration points of Azure Data Explorer (Kusto)
Multiple labs?that cover stand-alone and distributed modes of Kafka, Azure Event Hub as the streaming source, end-to-end integration of Cosmos DB, ingestion, processing, and analytics of data leveraging Databricks.
4. Refresh your skills with ADX in a Day (Preview) micro hack
ADX in a Day is a challenge based, discover by doing experience divided into 2 labs of 4 Hours each, a total of 8 hours.
Lab 1: Cluster Creation, Data Ingestion, and Exploration?This Lab will focus on enabling the participants to Create a free ADX cluster and ingest data into the cluster - One click ingestion of historic data, update policy to perform ETL, and write some KQL queries.
Lab 2: Advanced KQL, Policies, and Visualization?This Lab will focus on enabling the participants to write Kusto query to explore and analyze the data stored in the clusters. Participants will also create cool visualizations. It is recommended to complete Lab 1 before beginning with Lab 2.
Please note that ADX in a Day is currently under preview and badges are alloted only for proctored workshops.
5. Analyse your smart device data in ADX via Home Assistant
Do you have smart home devices from popular manufacturers like?Phillips, TPLink, Amazon,?etc. and you are wondering how you can analyze the data at a commonplace? If you want to predict a failure, identify an anomaly in consumption, or find seasonality in your smart device usage by using ADX free cluster, connect your smart devices through Home Assistant.
What will you do with your ADX free cluster? Let us know in the comments.
Product Manager II - Cloud Ecosystem Security (CxE) at Microsoft
1 年Ricardo Lessa