Data Analysis Expressions (DAX) - Simply Explained

Data Analysis Expressions (DAX) - Simply Explained

If you've spent any time working with Power BI, you've almost certainly heard about DAX. Some people describe it as "Excel formulas for Power BI," while others treat it like a complex programming language that only experts can understand. The truth lies somewhere in between. In this episode of Microsoft Knowledge Nuggets on M365 FM, Mirko Peters explains Data Analysis Expressions (DAX) in plain English, breaking down the concepts that every Power BI user, business analyst, and data professional needs to understand. Whether you're building your first dashboard or looking to improve enterprise reporting, this episode provides a practical introduction to one of Microsoft's most powerful analytical technologies. WHAT IS DAX AND WHY DOES IT MATTER?  DAX, or Data Analysis Expressions, is the calculation engine behind Microsoft Power BI, Excel Power Pivot, and SQL Server Analysis Services. Unlike Excel formulas that work on individual cells, DAX operates across entire tables and data models. Instead of calculating one value at a time, DAX dynamically responds to filters, slicers, and user interactions, allowing reports to update instantly as users explore their data. This makes DAX the foundation of interactive business intelligence and modern self-service analytics.  CALCULATED COLUMNS VS. MEASURES One of the biggest challenges for beginners is understanding the difference between calculated columns and measures. This episode clearly explains why calculated columns are static values created during data refresh, while measures are dynamic calculations that respond instantly to report filters and user selections. Understanding when to use each approach is critical for building efficient Power BI models that remain fast, scalable, and easy to maintain.  UNDERSTANDING FILTER CONTEXT Filter context is the concept that separates beginner DAX users from experienced Power BI professionals. Every visual, slicer, page filter, and report interaction creates a unique filter context that determines which data is visible during a calculation. Rather than rewriting formulas for every scenario, DAX automatically recalculates results based on the active context, allowing a single measure to power hundreds of different report views. Once you understand filter context, DAX becomes significantly easier to master.  MASTERING CALCULATE, ITERATORS, AND TIME INTELLIGENCE The episode explores the most important DAX function—CALCULATE—and explains why it forms the foundation of advanced Power BI development. You'll also learn when to use iterator functions such as SUMX, how row context differs from filter context, and why proper date tables are essential for time intelligence calculations. Practical examples demonstrate running totals, year-over-year comparisons, prior-year sales, growth percentages, and dynamic business metrics that executives rely on every day.  BUILDING HIGH-PERFORMANCE POWER BI MODELS Great Power BI reports depend on more than writing formulas. Mirko explains how clean data models, well-designed relationships, variables, reusable measures, source control, and efficient DAX patterns improve both report performance and long-term maintainability. The episode also highlights common beginner mistakes, including overusing calculated columns, misunderstanding context, ignoring the data model, and writing unnecessarily complex expressions that slow down reports.  KEY TAKEAWAYS DAX is far more than a collection of formulas—it is the analytical engine that powers Microsoft Power BI. By understanding measures, calculated columns, filter context, CALCULATE, iterator functions, and time intelligence, you can transform static reports into interactive dashboards that automatically respond to every user interaction. Mastering a few core DAX concepts will help you build faster, cleaner, and more scalable Power BI solutions while unlocking the full potential of Microsoft's business intelligence platform. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

Graph API - Simply Explained

Microsoft Graph API is one of the most important technologies in the Microsoft ecosystem, yet it's often misunderstood. Is it a database? A service? Or simply another developer tool? In this episode of Microsoft Knowledge Nuggets on M365 FM, Mirko Peters breaks down Microsoft Graph API in plain English using simple real-world analogies that make even complex concepts easy to understand. Whether you're an IT administrator, developer, Power Platform maker, or Microsoft 365 enthusiast, you'll learn why Graph has become the universal gateway to Microsoft's cloud services and why it's now essential for automation, integrations, and AI-powered solutions. FROM DISCONNECTED APIS TO ONE UNIFIED PLATFORM Before Microsoft Graph, every Microsoft service had its own API. Exchange Online, SharePoint, Azure Active Directory (now Microsoft Entra ID), OneDrive, and Microsoft Teams all required separate authentication methods, documentation, and programming models. Automating even simple business processes meant working with multiple technologies simultaneously. Microsoft Graph changed that by introducing one unified API endpoint that connects every major Microsoft 365 service through a consistent interface, dramatically simplifying development and automation. UNDERSTANDING GRAPH THROUGH SIMPLE ANALOGIES Rather than diving into technical documentation, this episode explains Microsoft Graph using relatable examples. Imagine Microsoft 365 as a modern office building where every service represents a different department. Instead of visiting each room individually, Microsoft Graph acts as the central reception desk that coordinates everything behind the scenes. This simple analogy makes it easy to understand how Graph connects users, files, calendars, mailboxes, Teams, SharePoint sites, and security information into one interconnected platform. HOW AUTHENTICATION, PERMISSIONS, AND SECURITY WORK Every Graph request starts with authentication through Microsoft Entra ID before authorization determines exactly which resources an application can access. The episode explains delegated permissions, app-only permissions, OAuth tokens, consent, scopes, and Microsoft's least-privilege security model without unnecessary technical complexity. You'll also understand why Graph is considered one of the most secure ways to access Microsoft 365 data and how administrators maintain complete control over application permissions. AUTOMATING MICROSOFT 365 WITH GRAPH API Microsoft Graph enables organizations to automate virtually every aspect of Microsoft 365. From creating users and assigning licenses to managing Teams, SharePoint documents, Outlook mailboxes, OneDrive files, calendars, Microsoft Defender alerts, and security operations, Graph provides a single interface for enterprise automation. The episode also demonstrates how developers, administrators, and IT professionals can build powerful workflows while reducing complexity compared to legacy Microsoft APIs. GRAPH API FOR POWER PLATFORM AND LOW-CODE USERS You don't have to be a professional developer to benefit from Microsoft Graph. Power Automate, Power Apps, Microsoft Copilot, and Graph Explorer make Graph accessible to citizen developers and business users through low-code experiences. Even advanced Graph endpoints can be integrated using custom HTTP actions, allowing organizations to build sophisticated automations without writing large amounts of code. This opens enterprise-grade automation capabilities to a much wider audience. WHY GRAPH API IS THE FUTURE OF MICROSOFT 365 Microsoft continues to retire older technologies while investing heavily in Graph API. Legacy APIs such as Exchange Web Services are reaching end of life, while new Microsoft 365 capabilities increasingly become available only through Graph. Understanding Graph today prepares organizations for future AI experiences, Microsoft Copilot integrations, intelligent agents, Power Platform automation, and enterprise cloud development. KEY TAKEAWAYS Microsoft Graph API is the universal gateway to Microsoft 365. One endpoint provides secure access to users, mail, files, Teams, SharePoint, calendars, devices, security data, and much more. Whether you're building applications, automating business processes, integrating Microsoft services, or preparing for the AI era, Graph API forms the foundation of the modern Microsoft cloud. Understanding how it works is one of the most valuable skills for anyone working with Microsoft technologies today. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

Microsoft Agent Builder — Simply Explained

Building AI agents used to require developers, code, and complex AI platforms. Microsoft Agent Builder changes that completely. Built directly into Microsoft 365 Copilot, Agent Builder allows anyone to create an AI assistant simply by describing what they want in plain English. Instead of writing code, you describe the purpose of the agent, connect your company knowledge, and let Copilot generate everything else. In just a few minutes, you can build an internal AI assistant that helps answer questions, find information, and support everyday business processes. NO-CODE AI AGENTS Agent Builder lives directly inside the Microsoft 365 Copilot interface. Creating an agent starts with two simple tabs: Describe and Configure. In the Describe tab, you explain what the agent should do, such as helping employees onboard new hires or answering HR questions. Copilot automatically generates the agent's name, description, instructions, and suggested prompts. The Configure tab allows you to refine everything manually, including the agent's behavior, appearance, instructions, and connected knowledge sources. KNOWLEDGE MAKES THE AGENT SMART An agent is only as good as the information it can access. Agent Builder allows you to connect SharePoint sites, OneDrive documents, uploaded files, public websites, Teams conversations, and Outlook emails. These become the knowledge base the agent uses when answering questions. For organizations concerned about accuracy, the "Only use specified sources" option limits responses exclusively to approved content, helping reduce hallucinations while ensuring answers remain grounded in company documentation.  BUILDING YOUR FIRST AGENT Creating an agent requires only a few simple steps. Start by describing the business problem you want to solve. Copilot generates the initial agent automatically. Next, connect the appropriate knowledge sources, customize the instructions if needed, add suggested prompts, and publish the agent. Within minutes, your AI assistant appears alongside Microsoft 365 Copilot, ready to answer questions based on your organization's knowledge.  START FASTER WITH TEMPLATES Microsoft provides several ready-made templates to accelerate development. Templates such as Career Coach, Researcher, and Analyst provide prebuilt structures for common business scenarios. Rather than starting with a blank page, users simply customize the template by replacing the knowledge sources and adjusting the instructions to match their organization's requirements. Templates significantly reduce setup time while providing proven conversational structures.  AGENT BUILDER VS. COPILOT STUDIO Microsoft offers multiple ways to build AI agents, each targeting different audiences. Agent Builder is designed for business users who need internal knowledge assistants without writing code. Copilot Studio adds low-code workflows, external connectors, automation, and multi-step business processes suitable for enterprise solutions. AI Foundry sits at the highest level, giving developers full control over models, orchestration, and advanced AI applications. For most organizations beginning their AI journey, Agent Builder provides the fastest path to delivering business value.  UNDERSTANDING THE LIMITATIONS Agent Builder is intentionally designed to remain simple. It creates internal Microsoft 365 agents only. It cannot publish chatbots to public websites, connect directly to external systems like Salesforce or ServiceNow, execute complex workflows, or automate business processes. Organizations needing external-facing agents, advanced automation, or enterprise integrations should move to Copilot Studio instead.  SECURITY AND GOVERNANCE Security is built into Agent Builder from the beginning. Agents automatically inherit existing Microsoft 365 permissions, meaning users can only receive information they already have permission to access. SharePoint permissions, Teams access, and document security continue to apply without requiring additional configuration. Combined with grounded knowledge sources and Microsoft's existing security model, Agent Builder allows organizations to introduce AI safely without creating new permission risks.  WHY MICROSOFT AGENT BUILDER MATTERS Microsoft Agent Builder dramatically lowers the barrier to creating useful AI assistants. Business users no longer need developers or AI specialists to build internal knowledge assistants. Instead, they can describe their requirements, connect company information, and deploy an intelligent assistant within minutes. For organizations beginning their AI adoption journey, Agent Builder offers one of the fastest and simplest ways to bring conversational AI into everyday work while providing a clear upgrade path to Copilot Studio and AI Foundry as business requirements grow. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

Copilot for Dynamics 365 Finance and Operations - Simply Explained

Finance teams have never struggled with a lack of data—they struggle with the time it takes to find, organize, analyze, and act on that information. Traditional ERP workflows often require switching between customer records, reports, Excel spreadsheets, Outlook, and multiple ERP screens before a single decision can be made. Copilot for Dynamics 365 Finance & Operations changes that experience. Instead of searching for information manually, Copilot brings insights directly into your workflow, helping finance professionals summarize customer accounts, draft emails, analyze financial performance, forecast cash flow, and automate repetitive tasks without leaving the applications they already use. SOLVING THE DAILY FINANCE WORKFLOW Most finance professionals spend more time gathering information than analyzing it. Whether it's reviewing overdue invoices, preparing month-end reports, reconciling accounts, or responding to customer payment inquiries, much of the work involves navigating multiple screens and manually assembling information. Copilot reduces this friction by presenting relevant data, recommendations, and AI-generated summaries directly inside Dynamics 365 Finance & Operations, Outlook, Excel, and Microsoft Teams.  COLLECTIONS AND ACCOUNTS RECEIVABLE One of Copilot's most valuable capabilities is improving collections management. Within the Collections Coordinator workspace, Copilot automatically summarizes overdue invoices, outstanding balances, payment history, disputes, and customer risk. Instead of reviewing multiple screens, collectors receive a complete overview the moment they open a customer record. Copilot can also draft personalized collection emails based on customer history and communication preferences. Through the Copilot for Finance Outlook add-in, finance teams can access customer information, generate responses, and synchronize activities back into Dynamics 365 without leaving their inbox.  MONTH-END CLOSE AND FINANCIAL REPORTING Financial close remains one of the busiest periods for every finance department. Copilot assists before, during, and after month-end by identifying missing transactions, suggesting journal entries, highlighting reconciliation issues, and automatically explaining financial variances. Instead of manually investigating why operating expenses increased, finance professionals can simply ask Copilot for a variance explanation and receive a natural-language summary highlighting the biggest contributors. Rather than replacing financial expertise, Copilot removes much of the repetitive investigation work, allowing accountants to focus on analysis and decision-making.  CASH FLOW FORECASTING Cash flow forecasting traditionally depends on spreadsheets, manual assumptions, and historical analysis. Copilot continuously analyzes open transactions, payment behavior, seasonal trends, and historical patterns to generate more dynamic cash flow forecasts. It can identify payment delays, unusual spending patterns, and potential cash flow risks while allowing finance teams to model different business scenarios before making important financial decisions.  EXPENSE MANAGEMENT AND ACCOUNTS PAYABLE Copilot also streamlines expense processing and accounts payable. Using Optical Character Recognition (OCR), receipts are automatically scanned, key information extracted, and expense reports prepared with minimal manual input. Company policies are checked automatically, helping identify potential compliance issues before submission. For vendor invoices, Copilot assists with invoice processing, general ledger suggestions, purchase order updates, and approval workflows, reducing manual data entry while minimizing errors.  GETTING STARTED Organizations need several prerequisites before using Copilot. Dynamics 365 Finance & Operations should be running version 10.0.38 or later. Power Platform and Dataverse integration must be enabled, supported Copilot features activated through Feature Management, and Microsoft 365 Copilot licensing assigned alongside the existing Dynamics 365 licenses. Because Copilot is cloud-based, on-premises deployments are not supported.  DRIVING USER ADOPTION Technology alone doesn't guarantee success. Organizations that achieve the highest adoption typically begin with targeted pilot projects focused on high-value processes such as collections, month-end close, or expense management. Training users around real business scenarios rather than individual product features helps finance teams quickly understand where Copilot delivers measurable value. Successful adoption depends on improving existing business processes first and then using Copilot to accelerate those workflows rather than expecting AI to fix inefficient processes automatically.  WHY COPILOT FOR D365 F&O MATTERS Copilot transforms Dynamics 365 Finance & Operations from a traditional ERP into an intelligent finance workspace. Instead of replacing accountants, controllers, or finance managers, it automates repetitive work such as data gathering, summarization, drafting communications, and preparing reports. This allows finance professionals to spend more time interpreting financial results, improving customer relationships, managing cash flow, and making strategic business decisions. Ultimately, Copilot helps finance teams shift from asking "What happened?" to focusing on the more valuable question: "What should we do next?" Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].

AI Under Attack: Building Zero Trust Security with Microsoft Copilot, Azure & Microsoft 365 - Mourtaza Fazlehoussen [MVP]

Artificial intelligence is transforming cybersecurity faster than any technology before it. But while AI helps defenders automate investigations and respond to incidents faster, it also gives cybercriminals powerful new capabilities. In this episode of the M365 Show, Microsoft MVP, CISO, technology evangelist, and international speaker Mourtaza Fazlehoussen joins Mirko Peters to discuss how organizations can embrace AI without increasing their security risks. FROM CLASSIC CYBERSECURITY TO AI-POWERED DEFENSE Mourtaza shares his journey from programming on MS-DOS systems and Microsoft technologies to leading enterprise security initiatives around the world. Drawing from decades of experience across Europe, Africa, and Asia, he explains how the cybersecurity landscape has evolved from protecting networks to defending identities, cloud platforms, AI workloads, and intelligent agents. The discussion highlights why security today requires continuous adaptation as attackers become increasingly sophisticated with AI-powered techniques. WHY BUYING MORE SECURITY TOOLS DOESN'T MAKE YOU MORE SECURE Many organizations continue investing heavily in cybersecurity products but still struggle to improve their overall security posture. Mourtaza explains why technology alone is never enough. Successful security depends on adoption, governance, integration, operational processes, executive support, and continuous monitoring. Without these elements, even the most advanced security platforms remain underutilized while employees create new risks through Shadow IT and Shadow AI. AI HAS CHANGED THE ATTACKER'S PLAYBOOK The conversation explores how generative AI has fundamentally changed phishing attacks, social engineering, and identity-based threats. Modern attackers no longer send emails filled with grammar mistakes. Instead, they use AI to create highly personalized campaigns based on publicly available information from platforms like LinkedIn. Mourtaza shares a fascinating real-world example of attackers compromising an organization through a malicious restaurant menu PDF after researching employee behavior. MICROSOFT SECURITY COPILOT EXPLAINED What exactly is Microsoft Security Copilot, and how does it differ from Microsoft 365 Copilot? Mourtaza explains that Microsoft Security Copilot is designed specifically for Security Operations Centers (SOC) and security analysts. Rather than replacing security professionals, it acts as an intelligent assistant capable of: * Prioritizing security alerts * Correlating incidents across Microsoft Defender, Sentinel, and Intune * Generating investigation summaries * Accelerating threat hunting * Helping junior analysts perform at a much higher level Unlike Microsoft 365 Copilot, which focuses on productivity, Security Copilot is built to improve incident response and security operations. BUILDING AI GOVERNANCE BEFORE DEPLOYING AI One of the central themes of this episode is AI Governance. Organizations cannot simply deploy AI assistants and hope everything remains secure. They need governance frameworks covering data classification, approved AI services, access control, responsible prompting, compliance requirements, and continuous monitoring. Mourtaza explains how Microsoft Purview, Azure AI Foundry, Microsoft Defender, Microsoft Entra ID, and Microsoft Security Copilot work together to establish responsible AI governance while supporting regulations such as the EU AI Act, GDPR, DORA, CRA, and NIS2. ZERO TRUST IN THE AGE OF AI Zero Trust remains one of Microsoft's core security principles—but AI expands its importance. The discussion covers why organizations must: * Verify every identity * Apply least privilege access * Assume breach * Secure AI agents like human identities * Monitor prompts, data access, and AI behavior continuously As AI systems gain access to business-critical information, identity becomes the new security perimeter. INSIDE A RANSOMWARE INCIDENT Mourtaza walks through the critical first hour after discovering a ransomware attack. He explains the importance of rapid detection, containment, investigation, executive communication, evidence preservation, business continuity planning, and disaster recovery. Microsoft Security Copilot can significantly reduce investigation time by automatically correlating events and generating incident summaries, allowing security teams to focus on response rather than manual analysis. KEY TAKEAWAYS AI is changing cybersecurity for both defenders and attackers. Organizations must combine modern security technology with strong governance, identity protection, Zero Trust principles, and continuous monitoring. Microsoft Security Copilot is an incredibly powerful assistant—but it complements security professionals rather than replacing them. As Mourtaza concludes, governance is the foundation that enables organizations to innovate with AI while maintaining trust, compliance, and resilience. Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support [https://www.spreaker.com/podcast/m365-fm-modern-work-security-and-productivity-with-microsoft-365--6704921/support?utm_source=rss&utm_medium=rss&utm_campaign=rss].