Exploring Data in Microsoft Azure Using Kusto Query Language and Azure Data Explorer from Pluralsight

You will learn in detail about the data exploration service from Azure and how it integrates with other services to perform end-to-end data analytics. This course will provide you with the necessary skills and confidence as a data scientist.

Businesses around the world are making huge investments in data analytics to be able to make critical decisions for steering growth and remain competitive. Data science is the ability to capture and process raw data, and then analyze, visualize, and communicate the processed information as insights to the stakeholders that brings in the value by enabling businesses in making critical decisions. In this course, Exploring Data in Microsoft Azure Using Kusto Query Language and Azure Data Explorer, you will use Azure Data Explorer to perform data exploration services. First, you will familiarize yourself with data exploration service in Azure. Next, you will learn how to build the Azure Data Explorer environment from Azure Portal as well as using PowerShell and CLI. Then, you will discover how to use the Kusto Query Language to perform time series analysis, followed by how data ingestion is performed using EventHubs and EventGrids. Finally, you will explore how to manage Data Explorer cluster performance and database permissions. When you’re finished with this course, you will have all the necessary skills and confidence to take your organization to the next level as a data scientist.

What's inside

Syllabus

Course Overview

Azure Data Explorer (ADX) Overview

Building the ADX Environment

Using the Kusto Query Language (KQL)

Data Ingestion for ADX

Managing Azure Data Explorer

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Emphasizes data exploration in Microsoft Azure, suitable for data scientists and those interested in data analytics

Taught by Neeraj Kumar, an experienced instructor in the field

Provides hands-on practice through labs and interactive materials

Covers key aspects of data exploration, including time series analysis and data ingestion

Requires familiarity with Azure services and the Kusto Query Language

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Exploring Data in Microsoft Azure Using Kusto Query Language and Azure Data Explorer with these activities:

Review Course Syllabus and Materials

Show steps

Compile notes, review previous work, and organize materials to better prepare for the data analytics course.

Show steps

Gather syllabus and course materials
Review syllabus for course overview, schedule, and assessment details
Organize materials by topic or module
Review any prerequisite materials

Explore Data Analytics Concepts

Show steps

Refresh understanding of core data analytics concepts to strengthen foundation for the course.

Browse courses on Data Analysis

Show steps

Review basic statistical and mathematical concepts
Explore data visualization techniques and tools
Practice data cleaning and transformation techniques
Review data mining and machine learning algorithms
Complete practice exercises and quizzes

Develop Azure Data Explorer Environment

Show steps

Build a solid foundation in Azure Data Explorer by following guided tutorials to set up the environment.

Browse courses on Azure Data Explorer

Show steps

Access Azure Portal and create a new Azure Data Explorer cluster
Follow tutorials to set up Azure Data Explorer using PowerShell and CLI
Configure data sources and ingestion pipelines
Create and manage databases within Azure Data Explorer
Complete hands-on exercises to reinforce learning

Four other activities

Expand to see all activities and additional details

Show all seven activities

Master Kusto Query Language (KQL)

Show steps

Gain proficiency in KQL by completing repetitive exercises and drills to enhance understanding and problem-solving skills.

Browse courses on Kusto Query Language

Show steps

Practice writing basic KQL queries for data exploration
Explore advanced KQL functions for data manipulation and analysis
Work through code challenges and puzzles to refine KQL skills
Build a portfolio of KQL queries for real-world scenarios
Participate in online forums or discussion groups for KQL support

Develop Data Visualization Dashboard

Show steps

Apply skills in data visualization to create an interactive dashboard that showcases insights and trends derived from the data.

Browse courses on Data Visualization

Show steps

Identify key metrics and insights to be visualized
Select appropriate visualization techniques and tools
Design and develop an interactive dashboard using Azure Data Explorer
Integrate data from multiple sources into the dashboard
Present and share the dashboard with stakeholders

Implement Data Analytics Solution

Show steps

Synthesize knowledge and skills acquired throughout the course to design and implement a data analytics solution for a real-world problem.

Show steps

Define the business problem and objectives
Gather and analyze relevant data
Develop and implement a data analytics model
Evaluate and refine the solution based on results
Document and present the findings and recommendations

Participate in Data Analytics Challenges

Show steps

Engage in data analytics challenges to test and refine skills, learn from others, and showcase expertise.

Browse courses on Kaggle

Show steps

Identify and register for relevant data analytics competitions
Explore the challenge dataset and problem statement
Develop and refine data analytics models
Submit solutions and track progress on the leaderboard
Analyze and learn from the winning solutions

Career center

Learners who complete Exploring Data in Microsoft Azure Using Kusto Query Language and Azure Data Explorer will develop knowledge and skills that may be useful to these careers:

Data Scientist

A data scientist is responsible for developing and implementing data-driven solutions to business problems. This course will provide you with the skills and knowledge you need to perform data exploration and analysis using Azure Data Explorer and the Kusto Query Language. These skills are essential for a data scientist, and this course will help you to build a strong foundation in data science.

See salaries and explore the career path for Data Scientist

Data Analyst

The data analyst is responsible for collecting, cleaning, and analyzing data to identify trends and patterns. With the skills you will gain from this course, you will be able to use Azure Data Explorer and the Kusto Query Language to perform data exploration and analysis, which are essential skills for a data analyst. This course will provide you with the knowledge and skills you need to succeed in this role.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

The business intelligence analyst is responsible for analyzing data to identify trends and patterns that can be used to improve business decisions. This course will provide you with the skills and knowledge you need to perform data exploration and analysis using Azure Data Explorer and the Kusto Query Language. These skills are essential for a business intelligence analyst, and this course will help you to build a strong foundation in business intelligence.

See salaries and explore the career path for Business Intelligence Analyst

Data Engineer

The data engineer is responsible for designing, building, and maintaining data pipelines. This course will provide you with the skills and knowledge you need to use Azure Data Explorer and the Kusto Query Language to ingest and process data. These skills are essential for a data engineer, and this course will help you to build a strong foundation in data engineering.

See salaries and explore the career path for Data Engineer

Database Administrator

The database administrator is responsible for managing and maintaining databases. This course will provide you with the skills and knowledge you need to use Azure Data Explorer to manage and maintain data. These skills are essential for a database administrator, and this course will help you to build a strong foundation in database administration.

See salaries and explore the career path for Database Administrator

Data Architect

The data architect is responsible for designing and implementing data solutions. This course will provide you with the skills and knowledge you need to use Azure Data Explorer to design and implement data solutions. These skills are essential for a data architect, and this course will help you to build a strong foundation in data architecture.

See salaries and explore the career path for Data Architect

Software Engineer

The software engineer is responsible for developing and maintaining software applications. This course will provide you with the skills and knowledge you need to use Azure Data Explorer and the Kusto Query Language to develop and maintain software applications. These skills are essential for a software engineer, and this course will help you to build a strong foundation in software engineering.

See salaries and explore the career path for Software Engineer

Cloud Engineer

The cloud engineer is responsible for designing, building, and maintaining cloud-based solutions. This course will provide you with the skills and knowledge you need to use Azure Data Explorer to design, build, and maintain cloud-based solutions. These skills are essential for a cloud engineer, and this course will help you to build a strong foundation in cloud engineering.

See salaries and explore the career path for Cloud Engineer

Data Visualization Engineer

The data visualization engineer is responsible for designing and developing data visualizations. This course will provide you with the skills and knowledge you need to use Azure Data Explorer and the Kusto Query Language to design and develop data visualizations. These skills are essential for a data visualization engineer, and this course will help you to build a strong foundation in data visualization.

See salaries and explore the career path for Data Visualization Engineer

Machine Learning Engineer

The machine learning engineer is responsible for developing and implementing machine learning models. This course will provide you with the skills and knowledge you need to use Azure Data Explorer and the Kusto Query Language to develop and implement machine learning models. These skills are essential for a machine learning engineer, and this course will help you to build a strong foundation in machine learning.

See salaries and explore the career path for Machine Learning Engineer

Data Modeler

The data modeler is responsible for designing and developing data models. This course will provide you with the skills and knowledge you need to use Azure Data Explorer and the Kusto Query Language to design and develop data models. These skills are essential for a data modeler, and this course will help you to build a strong foundation in data modeling.

See salaries and explore the career path for Data Modeler