Microsoft Purview: Data Catalog & Data Governance

Name: Microsoft Purview: Data Catalog & Data Governance
Rating: 4.6 (140 reviews)

Build data governance, a reliable data catalog, strong data quality, and a foundation for true data-based decision makin

Created byDr. Florian Detzel | BI Academy

Last updated 8/2026

English

English [Auto],

What you'll learn

Understand how Microsoft Purview supports modern data governance and data-based decision making.
Build a reliable enterprise Data Catalog by scanning and organizing data from Azure SQL, ADLS, Power BI, and Fabric.
Create and maintain a structured Business Glossary to align definitions across the organization.
Apply data quality rules, profiling, and monitoring to ensure trustworthy, high-quality data.
Interpret data quality insights to support informed, strategic business decisions.
Use Purview lineage to trace end-to-end data flows and understand their impact on reports and analytics.
Integrate Purview with Microsoft Fabric to establish unified governance across your analytics ecosystem.

Course content

9 sections • 40 lectures • 4h 46m total length

Welcome and getting to know your lecturer3:31
Florian introduces himself as an experienced business intelligence leader with academic and industry insights, framing the course with theory plus hands-on business intelligence exercises and his professional credentials.
Microsoft Purview Overview9:59
Explore how Microsoft Purview enables data governance with unified catalog, data map, and data quality across sources such as Azure SQL and Azure Data Lake, linking assets to glossary terms.
Requirements: Azure subscription2:08
Acquire an organizational Azure subscription or pay-as-you-go access to Microsoft Purview, set up a domain and Azure tenant, and manage ingestions at about twenty dollars.
Create your Azure Subscription1:17

Creating a resource group in Microsoft Azure4:29
Create a resource group as the central container for all Azure resources in this course, name it Udemy Purview, and choose a region with the unified catalog available.
Why do we need a resource for Microsoft Purview?1:53
Provision an Azure Purview resource to upgrade our tenant from a free Purview account to an enterprise Purview account, unlocking full data catalog and governance features.
Creating the resource for Microsoft Purview8:02
Create and configure a Microsoft Purview account and resource, link to an Azure subscription and resource group, and explore the data map and unified catalog to govern metadata.
Setting up roles & permissions3:26
Explore Purview roles and permissions, using a global administrator to practice access control across tenant and catalog levels, including data governance administrator and data health reader roles for data catalog.

Creating the storage account9:40
Create an Azure Data Lake Storage generation two account, configure a container, and upload csv files to populate your purview environment for data cataloging and governance.
Registering the Azure Data Lake Storage data source in Microsoft Purview2:03
Register the Azure Data Lake Storage Gen2 data source in Purview via the data map's data sources, then complete registration to add it to the data catalog.
Scanning the Azure Data Lake Storage data source in Microsoft Purview14:21
Configure and run a one-time Azure Data Lake Storage Gen2 scan in Microsoft Purview by setting the managed identity, granting storage blob data reader, and defining scope and scan rules.
Exploring data products9:08
Discover how Purview’s unified data catalog enables discovery of data assets from Azure sources, view file metadata, add asset descriptions and column classifications, and certify assets for trusted data products.
Creating and publishing our first data product10:22
Create and publish your first data product in Purview by defining a data governance domain, assembling data assets, configuring access policies, and launching it to the Unified Catalog.
Shopping for data products in Microsoft Purview Data Catalog8:11
Explore the Microsoft Purview data catalog as a data scientist navigates the data product shop, requests access for critical reporting, and reviews approvals in a governance-driven workflow.
Data Product limitations for ADLS & CSV data sources3:07
Explore CSV data source limitations in Microsoft Purview, then set up an Azure SQL database, define data assets and data products, and analyze data quality and data lineage.

Creating the Azure SQL database13:31
Create an Azure SQL database to enable Purview data ingestion, comparing serverless vs provisioned options and highlighting cost-efficiency for a testing scenario.
Adding the Microsoft Purview user to the database3:31
Add database access for the Purview managed identity by granting the owner role on the SQL server through the Azure portal, then upload data from CSV files into the database.
Getting dbeaver database management client for free0:06
Adding sample data into our database10:18
Learn how to add sample data to an Azure SQL database using DBeaver, import CSV files, map to tables, and prepare the Purview data catalog for scanning and quality checks.
Register the Azure SQL database in Microsoft Purview Data & Configure scan11:19
SQL statements used in this video:
create user [biacademy-purview] from external provider;
ALTER ROLE db_datareader ADD MEMBER [biacademy-purview]
Download the sample data0:02
View the Azure SQL database data source scan results9:44
Explore how Microsoft Purview ingested azure sql database data into the unified catalog, revealing data assets, tables, and schemas, with asset descriptions and documentation to support data governance.

Creating new data products in the Microsoft Purview Data Catalog20:22
Create two data products in the Microsoft Purview data catalog for delivery driver analysis and customer analysis, emphasizing separation of concerns within the Fast Bite company data governance domain.
Browsing data products in the Microsoft Purview data catalog9:13
Browse data products in the Purview data catalog and filter by governance domain to view related data assets. Navigate between data products and assets to support documentation and access management.

Introduction to Data Quality in Microsoft Purview2:34
Explore data quality in Microsoft Purview's unified catalog, learn why connections are required for data quality checks, and follow steps using secrets and key vault to configure access.
Configuring connection for data quality scan2:42
Configure and reuse an Azure SQL database connection for data quality scans within the governance domain, enabling seamless data quality checks and data profile creation.
Starting the data profiling in Microsoft Purview5:20
Start data profiling in Microsoft Purview by selecting a data asset shared across data products. Profile all columns and run scans in parallel to view distributions and formats.
Data Profiling results9:59
Review data profiling results for the order items and courier tables, including value distributions and pattern matching to reveal data quality issues. Set up data quality rules for governance.
Defining Data Quality rules and start the quality scan in Microsoft Purview12:41
Define data quality rules in Microsoft Purview and run a data quality scan on the order items table to check for duplicates, empty fields, and item price greater than zero.
Viewing the data quality results6:15
The data quality scan shows a 100% score for the order items table, and explains that scans must run per data product due to rules and cost considerations.
SQL statement for our dirty data0:17
Adding data to our database to violate data quality rules7:22
Explore how inserting bad data violates data quality rules, lowers the data quality score, and triggers a data quality scan that highlights unhealthy controls and per-column quality insights.
Glossary import download0:01
Glossary & business terms definitions in Microsoft Purview Data Catalog18:21
Link business glossaries to data assets in Microsoft Purview data catalog, define terms and relationships, and use CSV imports to connect governance concepts.

Getting the basics ready in Microsoft Fabric12:20
Set up a Microsoft Fabric workspace, create a report from an Azure SQL data source, and define a semantic model with relationships to enable Purview data lineage.
Registering the Microsoft Fabric data source & configuring the scan20:50
Register a Fabric data source in Purview, scan to ingest workspace objects including reports and the semantic model into the data catalog, and enable data lineage with Fabric API permissions.
Starting Microsoft Purview scan of Microsoft Fabric3:19
Learn to start a Microsoft Purview scan of Microsoft Fabric, exclude personal workspaces, scope to a specific Fabric workspace, and run a one-time scan to view results and data lineage.
Data Lineage in Microsoft Purview with Microsoft Fabric assets10:40
Explore data lineage in Microsoft Purview with Fabric assets, tracing a Power BI report to its dataset and the underlying Azure SQL databases for impact analysis.

Requirements

Access to an organizational Azure subscription or a personal pay as you go subscription is helpful if you want to work hands-on

Description

Modern businesses rely on data to make better decisions, yet many struggle with unclear definitions, scattered metadata, and inconsistent data quality. Microsoft Purview solves these challenges by bringing governance, cataloging, quality, and lineage together — and this course shows you how to use it not only to organize your data, but to unlock it for strategic, data-based decision making across your organization.

You will learn how to build a powerful Data Catalog that makes your data assets transparent, well-documented, and easy to discover. As we scan Azure SQL, ADLS, Power BI, and Microsoft Fabric workspaces, you’ll understand how to gather and interpret the data your teams rely on. By enriching assets with context and classifications, you create the foundation that enables analysts and decision-makers to trust and act on their insights.

A consistent business language is essential for good decisions. That’s why you’ll also build a clear, practical Business Glossary that aligns definitions across departments and connects directly to your datasets. This shared understanding reduces confusion, speeds up analysis, and improves the quality of insights that guide strategic decisions.

Data quality and lineage play a critical role in making reliable, business-driven choices. In this course, you’ll learn how to apply rules, profile datasets, and trace data flows end-to-end — ensuring that the information behind your dashboards and reports is accurate, complete, and trustworthy. With clear visibility into how data moves and transforms, leaders can make decisions with confidence instead of assumptions.

Finally, you’ll explore how Purview integrates with Microsoft Fabric, governing Microsoft Power BI Reports and datasets. This gives organizations a unified view of their analytical ecosystem, allowing them to embed governance directly into their decision-making processes and adopt truly data-driven strategies.

This course is perfect for data engineers, BI developers, analysts, architects, and governance professionals who want real-world skills they can apply immediately. No prior Purview experience is required.

If you want to establish trust in your data, improve the quality of insights, and support smarter business decisions, enroll now and take your data governance capabilities to the next level with Microsoft Purview.

Who this course is for:

Data Engineers, BI Developers, and Analysts who need trusted, well-governed data for analytics and reporting.
Data Architects building scalable data platforms on Azure and Microsoft Fabric.
Data Governance, Compliance, and Metadata Management professionals.
Business users and decision-makers who rely on high-quality data for strategic, data-based decisions.

Microsoft Purview: Data Catalog & Data Governance

What you'll learn

Explore related topics

Course content

Module 1: Introduction4 lectures • 17min

Module 2: Setting up Azure and Microsoft Purview Resource4 lectures • 18min

Module 3: Microsoft Purview & Azure Data Lake Storage7 lectures • 57min

Module 4: Microsoft Purview & Azure SQL Database7 lectures • 49min

Module 5: Data Products in Microsoft Purview2 lectures • 30min

Module 6: Data Quality & Glossary in Microsoft Purview10 lectures • 1hr 6min

Module 7: Connecting Microsoft Purview and Microsoft Fabric & Data Lineage4 lectures • 47min

Module 9: Conclusion1 lecture • 3min

Bonus Lecture1 lecture • 1min

Requirements

Description

Who this course is for: