Search
Generic filters
Exact matches only
Search
Generic filters
Exact matches only
Course Content
Onboarding
Welcome to the Program
0/4
Welcome to the Program
Your Commitment
Download Live Sessions Calendar
About Reliance Infosystems
Get to Know Microsoft Fabric
Start Your Journey into Microsoft Fabric by learning directly from Microsoft Experts
0/17
Introduction to end-to-end analytics using Microsoft Fabric
Ingest Data with Dataflows Gen2 in Microsoft Fabric
Ingest data with Spark and Microsoft Fabric notebooks
Use Data Factory pipelines in Microsoft Fabric
Get started with lakehouses in Microsoft Fabric
Organize a Fabric lakehouse using medallion architecture design
Use Apache Spark in Microsoft Fabric
Work with Delta Lake tables in Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
Load data into a Microsoft Fabric data warehouse
Query a data warehouse in Microsoft Fabric
Monitor a Microsoft Fabric data warehouse
Understand scalability in Power BI
Create Power BI model relationships
Use tools to optimize Power BI performance
Enforce Power BI model security
Administer Microsoft Fabric
Live Sessions with Professionals
Time to glean from the experience of professionals and solidify what you just learnt about Microsoft Fabric
Let’s Build on this Knowledge
Now, it's time to build on this knowledge
0/1
Validate Your Completion of the Learning Track
Microsoft Fabric Lab Activities
In this section, you will find all Microsoft Fabric Activities. You are advised to go through the Labs and replicate them.
0/25
Get started with lakehouses in Microsoft Fabric
Use Apache Spark to work with files in a lakehouse
Work with Delta Lake tables in Microsoft Fabric
Organize a Fabric lakehouse using medallion architecture design
Use Data Factory pipelines in Microsoft Fabric
Ingest Data with Dataflows Gen2 in Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
Load data into a warehouse in Microsoft Fabric
Query a data warehouse in Microsoft Fabric
Monitor a data warehouse in Microsoft Fabric
Get started with Real-Time Intelligence in Microsoft Fabric
Get started with data science in Microsoft Fabric
Explore data for data science with notebooks in Microsoft Fabric
Preprocess data with Data Wrangler in Microsoft Fabric
Train and track machine learning models with MLflow in Microsoft Fabric
Generate batch predictions using a deployed model in Microsoft Fabric
Get started with Eventstream in Microsoft Fabric
Ingest data with Spark and Microsoft Fabric notebooks
Get started with Data Activator in Microsoft Fabric
Query data from a Kusto Query database in Microsoft Fabric
Get Started with Real-Time Dashboards in Microsoft Fabric
Understand scalability in Power BI
Design and build tabular models – Work with model relationships
Optimize enterprise-scale tabular models
Design and build tabular models – Enforce semantic model security
Applied Skills – Build Confidence in Your Skill
You are now skillful. You might not know how good you are until you tackle these challenges.
0/4
Implement Lakehouse in Microsoft Fabric
Implement a data warehouse in Microsoft Fabric
Implement a data science and machine learning solution with Microsoft Fabric
Implement a Real-Time Intelligence Solution with Microsoft Fabric
Prepare for Certification
Would you like to take your learning further? time to prepare for Certification
0/10
Get started with end-to-end analytics and lakehouses in Microsoft Fabric
Use Apache Spark in Microsoft Fabric
Work with Delta Lake tables in Microsoft Fabric
Use Data Factory pipelines in Microsoft Fabric
Ingest Data with Dataflows Gen2 in Microsoft Fabric
Get started with data warehouses in Microsoft Fabric
Organize a Fabric Lakehouse Using Medallion Architecture Design
Ingest data with Spark and Microsoft Fabric notebooks
Administer Microsoft Fabric
How to pass Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric
Certification Voucher
Get all the information needed to claim certification voucher
0/1
Certification Voucher Qualification Checks
Fabric Analytics Engineer Track
About Lesson

Click here to start the Lab Activities

Get started with querying a Kusto database in Microsoft Fabric

A KQL Queryset is a tool that allows you to execute queries, modify, and display query results from a KQL database. You can link each tab in the KQL Queryset to a different KQL database, and save your queries for future use or share them with others for data analysis. You can also switch the KQL database for any tab, so you can compare the query results from different data sources.

In this exercise, you’ll perform the role of an analyst who’s tasked with querying a sample dataset of raw metrics NYC taxicab rides that you pull summary statistics (profiling) the data from the Fabric environment. You use KQL to query this data and gather information to gain informational insights about the data.

The KQL Queryset uses the Kusto Query language, which is compatible with many SQL functions, to create queries. To learn more about the kusto query (KQL)language.

This lab takes approximately 25 minutes to complete.

Previous
Next
wpChatIcon
wpChatIcon