22-25 April 2026

From Metadata to Momentum: Accelerating Self-Service Analytics with Microsoft Fabric and Purview

Proposed session for SQLBits 2026

TL; DR

Discover how Microsoft Fabric and Microsoft Purview work together to enable trusted, self-service analytics. Learn how Data Products, lineage, and metadata help users find, understand, and confidently reuse datasets, accelerating insights while maintaining governance at scale.

Session Details

Modern analytics platforms like Microsoft Fabric provide business users and analysts with powerful tools to query, model, and visualise data. However, without clear governance, self-service analytics can be confusing, slow, or risky — users may struggle to find the right datasets, understand their meaning, or trust their quality.

In this session, we explore how Microsoft Purview enables confident, governed self-service analytics on top of Microsoft Fabric and Azure SQL Database. Using Purview’s metadata, lineage, and business context features, we demonstrate how organizations can turn raw technical assets into discoverable, trusted, and reusable Data Products.

Attendees will see how to:

Map technical assets like Fabric Lakehouses, Warehouses, and Azure SQL tables to business-friendly concepts

Establish ownership, certification, and intended use through Purview Data Products

Use metadata and lineage to guide analysts and data scientists to the right datasets

We’ll also highlight how self-service analytics becomes a scalable, repeatable process, enabling teams to innovate faster, reduce duplication, and trust their data without accessing Purview itself - because Purview governs metadata, not the data.

By the end of this session, attendees will understand how to combine Fabric and Purview to accelerate analytics adoption, ensure data trust, and deliver business-aligned insights confidently.

3 things you'll get out of this session

How to turn Fabric and Azure SQL data assets into discoverable, trusted Data Products using Microsoft Purview How metadata, lineage, and business context enable confident self-service analytics without Purview holding the data Practical understanding of governed, scalable analytics practices that accelerate insight delivery and improve data trust across the organization

Speakers

Manish Kumar

Manish Kumar's previous sessions

Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
Dive into the heart of database optimization with our 20-minute session on Intelligent Query Processing (IQP) in SQL Server and Azure SQL. In this power-packed talk, we will demystify IQP, the driving force behind accelerated query performance. We'll begin with a quick overview, highlighting the pivotal role of IQP in query optimization and database efficiency. Then, we'll dive into key IQP features focusing on their impacts in real-world.
 
Managed Instance Link - Seamless migration to Azure
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
 
The Power of Polybase with SQL - True data Virtualisation
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.
 
Performance Tuning of Azure SQL DB
Manish Kumar from Microsoft will take you through various performance tuning measures you should take before increasing service tier of your database. The session will be packed with tons of information, steps and demos.
 

Haider Raza

Haider Raza's previous sessions

Empowering SQL: Mastering Intelligent Query Processing in 20 Minutes
Dive into the heart of database optimization with our 20-minute session on Intelligent Query Processing (IQP) in SQL Server and Azure SQL. In this power-packed talk, we will demystify IQP, the driving force behind accelerated query performance. We'll begin with a quick overview, highlighting the pivotal role of IQP in query optimization and database efficiency. Then, we'll dive into key IQP features focusing on their impacts in real-world.
 
Managed Instance Link - Seamless migration to Azure
We, the cloud solutions architects from Microsoft, will be talking around SQL migration journey from on-prem to Azure SQL in general, taking you through all available Microsoft's migration tools like DMA, DMS, Azure Migrate, ADS, etc, and then focus on migration to Managed Instance using SQL MI Link. You should take away with you the understanding of when to use which tool and how the newly available Azure SQL Managed Instance Link can help you to achieve a minimum downtime migration of on-prem SQL Server to Azure SQL Managed Instance.
 
The Power of Polybase with SQL - True data Virtualisation
Customers would be able to understand what exactly Polybase is, why it's useful, what are the use cases and finally how to use this feature of SQL Server. Polybase have been around for quite some time, since SQL Server 2016, however, the awareness and the way it virtualises the data may not have been understood well for some customers.