Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents

What if your team could query complex datasets just by asking questions? See how Microsoft Fabric's AI agents make it possible, no SQL needed.

#1about 2 minutes

Understanding traditional data architecture before Microsoft Fabric

Before Fabric, data analytics required integrating numerous separate services for ingestion, storage, processing, and visualization.

#2about 2 minutes

How Microsoft Fabric unifies data on one platform

Microsoft Fabric consolidates various data services into a single platform, using OneLake as a centralized "OneDrive for data" to simplify management.

#3about 2 minutes

Introducing conversational AI with Fabric Data Agents

Fabric Data Agents enable building conversational AI experiences that allow users to ask natural language questions across data stored in OneLake.

#4about 6 minutes

Ingesting data from ERP, CRM, and warehouse systems

A practical use case demonstrates three data ingestion techniques: database mirroring for SQL, pipelines for CRM data, and real-time intelligence for warehouse inventory.

#5about 2 minutes

Forecasting future demand with integrated ML notebooks

Use integrated machine learning notebooks within Fabric to analyze historical data and create a sales forecast to predict future product demand.

#6about 4 minutes

How to create and configure a data agent

Configure a data agent by providing system instructions for its behavior and adding metadata to help it understand custom database schemas and abbreviations.

#7about 2 minutes

Querying complex data using natural language questions

Ask the data agent simple or complex questions in conversational language to get quick insights, with the agent generating the underlying KQL or SQL query.

#8about 3 minutes

Current limitations and best practices for data agents

Understand the current preview limitations of data agents, such as language support, and follow best practices like creating domain-specific agents for better results.

#9about 2 minutes

A practical guide to getting started with Fabric

Adopt Microsoft Fabric by starting with a single high-value use case, creating a proof of concept, and then onboarding teams to build on that success.