Cloud Computing

 Azure Data Explorer with Demo

Azure Data Explorer is a fully-managed big data analytics cloud platform and data-exploration service, developed by Microsoft, that ingests structured, semi-structured and unstructured data. The service then stores this data and answers analytic ad hoc queries on it with seconds of latency. Lets Explore

a) Login to Azure Portal and search Azure data Explorer. On Cluster page as below, select resource group and keep other settings as default. Hit Create.

b) Lets add database

3) Copy the cluster URI on overview page and goto https://dataexplorer.azure.com/home

4) Ingest data from various sources

5) once data ingestion is complete, write Kusto Query Language to query the data

Sample Queries: This will also render Bar Chart

StormEvents

| where isnotempty(EndLocation) 

| summarize event_count=count() by EndLocation

| top 10 by event_count

| render columnchart