Data Governance Episodes

Microsoft 365 data rarely stays in one place. An employee might answer email in Outlook, collaborate in Teams, save documents in SharePoint and OneDrive, analyze information in Microsoft Fabric, export a report, change a few numbers in Excel, and send the spreadsheet to several colleagues. Each individual application may be secure, but the information continues moving, being copied, renamed, shared, and sometimes forgotten. In this episode of Microsoft Knowledge Nuggets on M365 FM, we explain ho...

Everyone wants Copilot. Everyone wants AI agents. Everyone wants employees to ask natural-language questions and immediately receive trustworthy answers from enterprise data. But what happens when the underlying data is fragmented, business definitions conflict, governance is weak, and semantic models were never designed for AI? In this episode of M365 FM, Mirko Peters sits down with Walter E. Calcagno, Microsoft MVP in Data Platform, Microsoft Certified Trainer, data architect, author, educator...

Building Enterprise AI plays a vital role in driving business value. However, many organizations struggle to transition from pilot projects to full-scale implementations. Common challenges include inadequate infrastructure, data issues, and a lack of change management. You need to establish clear success metrics to measure progress effectively. Research shows that 72% of enterprises are measuring the ROI of Generative AI, highlighting the importance of focusing on measurable outcomes. Additional...

Quick Answer: Microsoft Fabric Real-Time Intelligence is an important Microsoft topic for teams that need clearer technical decisions, safer implementation, and practical operational value. This episode explains what it does, where it fits in the Microsoft ecosystem, and the key considerations for administrators, architects, and business stakeholders. Real-time intelligence, particularly through Microsoft Fabric Real-Time Intelligence - Simply Explained, revolutionizes project management by pro...

Quick Answer: Microsoft Fabric Data Warehouse is an important Microsoft topic for teams that need clearer technical decisions, safer implementation, and practical operational value. This episode explains what it does, where it fits in the Microsoft ecosystem, and the key considerations for administrators, architects, and business stakeholders. In today’s data-driven world, effective data warehousing plays a crucial role in helping organizations make informed decisions. With a growing adoption r...

Quick answer: Microsoft Fabric Data Factory provides data-integration capabilities for moving, transforming, and orchestrating data within Microsoft Fabric. This episode explains the core concepts, where pipelines fit, and which design, governance, and operational questions teams should answer before putting data workflows into production. In today's data-driven world, organizations face the challenge of integrating and managing vast amounts of data. Microsoft Fabric Data Factory emerges as a s...

Quick answer: Microsoft Fabric brings data engineering, data integration, warehousing, real-time analytics, business intelligence, and governance into one SaaS analytics platform. This episode explains the major workloads, how they connect, and the practical architecture questions teams need to answer before adopting Fabric. Microsoft Fabric - Simply Explained serves as a comprehensive analytics solution designed to streamline your data processes. In today's fast-paced business world, effective...

Enterprise AI is rapidly evolving from simple chatbots to intelligent agents that can automate business processes, reason over enterprise data, and deliver measurable business value. In this episode of M365.fm, Microsoft MVP Shubhangi Goyal joins Mirko Peters to explore how Microsoft AI Foundry helps organizations build secure, scalable, and trustworthy AI solutions that are ready for real-world production—not just impressive demos. The conversation explains why successful AI projects begin with a strong data foundation. Clean, governed, and well-connected enterprise data is essential for creating reliable AI agents that employees and customers can trust. Shubhangi discusses how Microsoft AI Foundry enables organizations to experiment with models, orchestrate intelligent workflows, integrate enterprise knowledge, and manage the full lifecycle of AI applications while maintaining security and compliance. A major focus is the shift from prompt engineering to building complete AI s…

Microsoft Fabric OneLake is the unified data lake at the heart of Microsoft Fabric, providing a single, centralized location for all your organization's analytics data. Instead of storing copies of data across multiple systems, OneLake enables every Fabric workload—from Power BI and Data Engineering to Data Science and Data Warehouse—to access the same data, reducing duplication and breaking down data silos. In this episode of Microsoft Knowledge Nuggets, Mirko Peters explains Microsoft Fabric OneLake in simple terms and shows why it's often described as the "OneDrive for data." You'll learn how OneLake simplifies data management by providing a single source of truth for analytics, AI, and business intelligence across your organization. The episode covers key concepts including lakehouses, Delta tables, shortcuts, zero-copy data access, governance, security, and workspace organization. It also explains how OneLake integrates with Power BI, Data Factory, Data Engineering, Data Sc…

Vector databases are one of the key technologies powering modern AI applications, yet most people never interact with them directly. Unlike traditional databases that search for exact words or values, vector databases search by meaning, enabling AI to understand context instead of just matching keywords. In this episode of Microsoft Knowledge Nuggets, we explain vector databases in plain English and show why they're essential for enterprise AI, Microsoft Copilot, and Retrieval-Augmented Generation (RAG). You'll learn what vectors and embeddings are, how AI converts text, images, and other content into numerical representations, and why similar concepts are stored close together in vector space. We explain key concepts such as embeddings, semantic search, similarity search, vector indexes, chunking, and hybrid search, making it easy to understand how AI retrieves the right information even when users don't use the exact same words. The episode also explores real-world use cases i…

Azure AI Foundry is Microsoft's enterprise platform for building, deploying, and managing AI applications and intelligent agents at scale. Instead of stitching together multiple AI services, developers get a unified environment for working with foundation models, prompt engineering, agent orchestration, evaluation, monitoring, and security. In this episode of Microsoft Knowledge Nuggets, we explain Azure AI Foundry in plain English and show why it's becoming the central platform for enterprise AI development. You'll learn how Azure AI Foundry simplifies the entire AI development lifecycle—from choosing and comparing models to deploying production-ready AI applications. We cover core concepts including the model catalog, AI agents, prompt flows, Retrieval-Augmented Generation (RAG), fine-tuning, evaluations, observability, and responsible AI. You'll also discover how developers can work with models from OpenAI, Meta, Anthropic, Mistral, and many others within a single platform. T…

Azure Open Datasets gives you instant access to curated public datasets hosted by Microsoft in Azure, so you can spend less time searching for and cleaning data and more time building AI, analytics, and machine learning solutions. Instead of downloading files from dozens of websites, Azure Open Datasets provides trusted, regularly updated data that is ready to use with Azure Machine Learning, Azure Databricks, Power BI, Azure Data Factory, and other Azure services. Think of Azure Open Datasets as a public library where all the books are already organized, indexed, and sitting next to your workspace. You don't waste hours finding information or converting file formats—you simply choose the data you need and start working. Microsoft keeps many of these datasets synchronized with their original sources, helping ensure you always have current information without maintaining your own copies. The platform includes datasets covering weather, transportation, public holidays, demographic…

Data Analysis Expressions, better known as DAX, is the calculation language that powers Microsoft Power BI, Excel Power Pivot, and SQL Server Analysis Services. In this episode of the M365 FM Podcast, Mirko Peters explains DAX in plain English and shows why it is much more than simply using Excel formulas inside Power BI. The episode explores how DAX works across complete tables and data models rather than individual spreadsheet cells. You’ll learn the important difference between calculated columns and measures: calculated columns are created during data refresh and remain static, while measures recalculate dynamically whenever users apply filters, select slicers, or interact with a report. Another central topic is filter context, which determines which data is included in every calculation. The episode explains how one DAX measure can automatically display the correct result across different regions, products, dates, and report visuals. It also introduces essential concepts an…

Power BI Copilot brings generative AI directly into Microsoft's business intelligence platform, making it easier for users to analyze data, build reports, and uncover insights using natural language. Instead of manually creating complex visualizations or writing DAX queries from scratch, users can ask questions in plain English and let Copilot generate charts, summaries, measures, and report suggestions. This episode explains how Power BI Copilot works, where it delivers the most value, and why successful AI-powered analytics depend on far more than simply enabling a feature. You'll learn how clean data, well-designed semantic models, governance, and Microsoft Fabric create the foundation that allows Copilot to deliver accurate and trustworthy business insights. The discussion also explores the current limitations of Power BI Copilot, including its reliance on high-quality data, the need for human validation, and scenarios where traditional BI expertise remains essential. Whethe…

Microsoft Graph is often seen as a reporting and management API—but what if it could become one of your most powerful security tools? In this episode, we explore how Microsoft Graph can be leveraged to uncover hidden risks, automate governance, and continuously improve the security posture of an entire Microsoft 365 tenant. Rather than relying solely on traditional security dashboards, Graph provides direct access to identities, permissions, groups, applications, devices, and collaboration data, enabling organizations to detect problems before they become incidents. You'll learn how to use Microsoft Graph to identify excessive permissions, orphaned resources, inactive accounts, risky application consents, external sharing, and configuration drift across Microsoft 365. The episode explains why security is ultimately a data problem and how Graph serves as the unified interface that makes tenant-wide visibility and automation possible. We also discuss practical automation scenarios…

Microsoft Graph is far more than a REST API—it acts as the enterprise nervous system that connects people, identities, files, conversations, meetings, permissions, and business processes across Microsoft 365. In this episode, we explore why understanding these relationships is the key to building truly intelligent applications, automations, and AI experiences rather than isolated point solutions. You'll learn how Microsoft Graph creates a unified layer across services like Teams, SharePoint, Outlook, OneDrive, and Entra ID, allowing developers and architects to retrieve context instead of disconnected data. The episode explains why modern AI solutions such as Microsoft Copilot depend on Graph to understand not just where information is stored, but how users, content, and business activities are connected in real time. We also examine the shift from traditional, static data models toward relationship-driven architectures that enable smarter search, automation, security, and enter…

Automation is essential for digital transformation, but many organizations unintentionally create fragile, difficult-to-manage environments by relying on hundreds of disconnected PowerShell scripts and individual Power Automate flows. While each script may solve a specific problem, together they introduce technical debt, undocumented dependencies, and operational risk that become increasingly difficult to maintain as the business grows. This episode explains why modern enterprises are moving away from script-centric automation toward platform-based architectures built on Microsoft Graph, Azure Logic Apps, Azure Functions, Managed Identities, and governance-first design. Microsoft Graph serves as the central orchestration layer, providing a consistent interface across Microsoft 365 services such as Teams, SharePoint, Exchange, OneDrive, and Entra ID. Event-driven technologies like Graph Subscriptions and Delta Queries enable scalable, resilient automation that reacts in real time wh…

Microsoft Graph is much more than a REST API—it is the hidden logic that connects Microsoft 365. Instead of treating Outlook, Teams, SharePoint, OneDrive, Entra ID, and other services as isolated products, Microsoft Graph exposes the relationships between people, files, meetings, messages, devices, and permissions through a single, unified platform. This episode explains that the real value of Microsoft Graph lies in its ability to understand context. A user is connected to colleagues, documents, calendars, chats, and business processes, allowing applications and AI to retrieve meaningful information instead of disconnected data. This relationship model powers experiences such as Microsoft Copilot, intelligent search, automation, and personalized insights. The discussion also explores how developers and IT professionals can use Microsoft Graph to simplify integrations, automate administrative tasks, and build applications that work consistently across the Microsoft ecosystem. To…

Microsoft Graph is far more than just another API—it is the operational backbone of Microsoft 365. This episode explains why relying solely on admin portals limits scalability, visibility, and automation, while Microsoft Graph provides a unified interface for managing identities, users, groups, Teams, SharePoint, security, compliance, and business data across the entire Microsoft ecosystem. The discussion explores how Microsoft Graph PowerShell enables administrators to automate repetitive tasks, manage large environments consistently, and build governance processes that simply cannot be achieved through manual portal administration. Understanding authentication, OAuth, delegated and application permissions, service principals, and least-privilege access is presented as essential for building secure enterprise automation. The episode also highlights Microsoft's AI strategy, explaining that services such as Microsoft Copilot, Copilot Studio, AI agents, and future intelligent work…

As AI evolves from Microsoft Copilot to autonomous agents and, eventually, quantum computing, traditional governance models are no longer enough. This episode explores why organizations must move beyond simple allow-or-block security policies and adopt dynamic, context-aware governance that can adapt to increasingly intelligent systems. The discussion explains how Copilot, AI agents, and future quantum technologies introduce new challenges around identity, trust, data access, compliance, and decision-making. Rather than governing individual tools, organizations need governance frameworks that span the entire AI lifecycle—from user interactions with Copilot to autonomous agent orchestration and future quantum-powered workloads. A key theme is that governance should become an architectural capability rather than a collection of isolated policies. Identity, observability, continuous risk assessment, and automated policy enforcement must work together to provide secure, scalable AI …

In this episode of M365.FM, we explore why traditional data entry is rapidly disappearing and how AI agents are transforming business applications. Instead of asking employees to manually enter information into forms and systems, organizations are moving toward conversational interfaces where users simply describe what they want to achieve while AI agents translate intent into business actions. The discussion explains that the real shift is not replacing forms with chat, but relocating business logic from user interfaces into intelligent, governed agent workflows. Rather than embedding complex validation rules, approvals, and automation inside individual applications, these capabilities become reusable services that agents can orchestrate across multiple systems. A major theme is the importance of separating reasoning from execution. AI agents interpret user intent, while trusted business workflows execute actions in a secure, auditable, and deterministic way. This architecture …

AI agents are often managed like traditional service accounts—but that mindset creates serious security and governance risks. This episode explains why AI agents should be treated as autonomous digital identities with their own lifecycle, permissions, and accountability instead of static technical accounts. The discussion highlights that agents don't just authenticate to services—they make decisions, access business data, trigger workflows, and interact with multiple systems. Because of this, identity becomes the primary security boundary. Organizations should assign every agent its own identity, apply least-privilege access, enforce Zero Trust principles, and continuously monitor behavior rather than relying on broad, long-lived permissions. The episode also covers the importance of lifecycle management for non-human identities. Just like employees, AI agents require onboarding, role assignments, permission reviews, auditing, and secure decommissioning. Without proper governanc…

Custom integrations have long been one of the biggest bottlenecks in enterprise applications, but Dataverse MCP is changing that. In this episode of the M365.fm podcast, Mirko Peters is joined by Microsoft MVP Nathan Rose to explore how the Model Context Protocol (MCP) and Dataverse are transforming the way AI agents connect with business data. The discussion explains why traditional APIs, custom connectors, and one-off integrations struggle to scale in an AI-first world. Instead, Dataverse MCP introduces a standardized, secure, and context-aware approach that allows Microsoft Copilot Studio and AI agents to access enterprise data with far less custom development. Nathan shares practical insights into MCP architecture, governance, security, and how organizations can build reusable integrations instead of maintaining complex point-to-point connections. The conversation also covers the future of agentic AI, Microsoft's vision for interoperable AI systems, and what developers, arch…

In this episode of M365.fm, we explore why the future of cybersecurity is no longer centered around dashboards, alerts, and manual investigations—but around autonomous security agents working together as a coordinated Security Agent Fabric. As modern enterprises generate billions of security signals across cloud platforms, identities, endpoints, and applications, traditional Security Operations Centers (SOCs) are reaching their limits. Human analysts simply cannot keep pace with the volume, speed, and complexity of today's threat landscape. The episode introduces the concept of Agentic Defense: a new security architecture where specialized AI agents continuously monitor, validate, investigate, and respond to threats while remaining governed by human oversight. Instead of relying on a single security copilot, organizations will deploy networks of collaborating agents that handle identity protection, threat hunting, incident triage, compliance validation, vulnerability management,…