Explore the intersection of analytics, data management, and governance in the Microsoft ecosystem. Gain insights into data platforms like Microsoft Fabric and best practices for security and compliance.
Aug. 24, 2025
Fix SharePoint Knowledge Management
SharePoint doesn’t fail—organizations do when they treat it like a dumping ground. The result: duplicate “final” files, broken search, and shadow repositories in Teams, OneDrive, and email. This episode breaks down why SharePoint devolves into chaos (no lifecycle, no ownership, no metadata), the core ingredients of a functional knowledge platform (navigation, lifecycle, metadata), and a practical path to turn SharePoint into a trusted One Point of Truth—kept alive by governance, automation, and ongoing care.
Guest: Mirko Peters
Aug. 22, 2025
Balance Microsoft 365 Zero Trust Security and Usability
“Zero Trust everywhere” and “freedom for everyone” both fail in production. One grinds work to a halt; the other invites disaster. In this workshop we show how top M365 orgs hit the operating sweet spot—where CISO, GDPR officer, and everyday users all win. You’ll learn how small portal changes cascade into big workflow pain, how to write Conditional Access that protects without breakage, and how to use PIM for just-in-time admin without bottlenecks. We’ll leave you with battle-tested guardrails, policy templates, and a 30/60/90 rollout plan so your tenant runs quiet, audits pass, and users stop noticing security—because it just works.
Guest: Mirko Peters
Aug. 21, 2025
Automate Microsoft 365 Compliance Tasks with Power Automate
Compliance fails when it’s static. Checklists freeze rules in time, but regulations keep moving. In this episode, you’ll learn how to turn compliance from a brittle, manual checklist into a self-updating, feedback-driven system using Power Automate + SharePoint/Dataverse + Power BI. We cover recurrence triggers, adaptive workflows, centralized logging, escalation, governance at scale, and future-proofing via metadata and modular flow design — so your compliance process learns and updates itself instead of breaking every time a rule changes. Primary keywords: Power Automate compliance, automated compliance workflows, compliance governance, feedback loops, adaptive automation, SharePoint compliance library, Dataverse audit log, Power BI compliance dashboard, recurring flows, escalation policies, metadata-driven automation.
Guest: Mirko Peters
Aug. 20, 2025
Configure Microsoft 365 DLP Policies in Purview
This episode examines the real return on Copilot by focusing on outcomes rather than features. It argues that the biggest cost in modern organizations isn’t failed projects or bad strategy, but the quiet drain of routine work—emails, meetings, drafts, reports, and administrative tasks that create the appearance of progress without delivering meaningful impact. Copilot’s value comes from collapsing this everyday friction and returning time to people who rarely realize how much they’re losing. The episode explains how small time savings, while unimpressive in isolation, compound dramatically at scale. A few hours reclaimed per person each month becomes significant capacity across large teams. Whether that capacity produces value depends on intent: reclaimed time must be deliberately reinvested into higher-impact work instead of dissolving back into busyness. It also explores where these gains show up most clearly. In sales and marketing, reduced preparation and cleaner focus impro…
Guest: Mirko Peters
Aug. 20, 2025
Monitor Compliance in Microsoft Defender for Cloud
Most teams “pass” audits yet miss real misconfigurations between reviews. Microsoft Defender for Cloud changes that by turning compliance into a live posture: map your estate to frameworks (ISO/NIST/PCI), tailor controls to your own standards, auto-remediate drift, and surface results in Power BI for leadership. This episode shows how to build continuous, system-wide assurance—assessment → automation → evidence—across Azure, AWS, GCP and on-prem (Arc) without drowning in tickets. Keywords: Microsoft Defender for Cloud compliance, continuous compliance, Azure Policy, auto-remediation, regulatory compliance dashboard, Power BI security reporting, multi-cloud compliance, Azure Arc, NIST 800-53, ISO 27001, PCI DSS, governance at scale.
Guest: Mirko Peters
Aug. 18, 2025
Microsoft Purview vs Azure Information Protection
Think Purview and Azure Information Protection are “enterprise-only”? Think again. If you’re already on Microsoft 365 (E3 or Business Premium), you likely have sensitivity labels, baseline DLP, and email encryption ready to use—no extra spend. This episode debunks the biggest myth about data protection and shows a simple, fast path to label → protect → prevent leaks that small teams can deploy in an afternoon and big orgs can scale later.
Guest: Mirko Peters
Aug. 17, 2025
Automate GRC Reports with Power Automate
Manual GRC reporting is a risk multiplier—copy-paste errors, stale data, and missed escalations. With Power Automate, you can stitch together SharePoint, Excel, Dataverse, and ticketing tools into a real-time pipeline that standardizes data, assembles evidence, and publishes audit-ready packs automatically. This episode shows how to design the flow, harden it for scale, and turn “reporting” into continuous, decision-grade governance.
Guest: Mirko Peters
Aug. 17, 2025
Build ETL with Microsoft Fabric Dataflows Gen2
Fabric Dataflows Gen2 redefine how ETL processes are built and managed inside Microsoft Fabric. Unlike legacy Power BI Dataflows, Gen2 introduces scalable, reusable, and Lakehouse-integrated data transformation capabilities designed for enterprise-grade analytics environments. In this guide, we explain how Fabric Dataflows Gen2 work, how they integrate with OneLake and Lakehouse architecture, and when to use them instead of pipelines or notebooks. Whether you're modernizing your ETL strategy or building a new Fabric-based data platform, this breakdown helps you understand the architectural impact and governance considerations of Gen2 Dataflows. If you're building scalable, maintainable ETL inside Microsoft Fabric — this is essential reading.
Guest: Mirko Peters
Aug. 16, 2025
Embed Power BI and Fabric Analytics in Dynamics 365
Stop exporting Dynamics 365 data to Excel. Connect Dataverse to Microsoft Fabric, build an analytics model once, and embed Power BI directly inside Dynamics 365 (CRM/ERP) screens. With live, role-aware metrics (RLS), sales and ops teams act on fresh data without tab-switching, stale snapshots, or version drift. Use Fabric Data Factory/Dataflows Gen2 to shape data, enforce security with Entra ID and sensitivity labels, and place context-specific visuals in forms and dashboards. Result: faster decisions, fewer reconciliations, and a proactive, in-app analytics loop.
Guest: Mirko Peters
Aug. 16, 2025
Audit Microsoft 365 User Activity with Purview
Auditing user activity in Microsoft 365 is no longer optional — it’s essential for security, compliance, and governance. Microsoft Purview provides powerful audit capabilities, but many organizations don’t use them correctly or fail to leverage advanced logging features. In this guide, we walk through how to enable auditing in Microsoft Purview, how to search and analyze audit logs effectively, and how to use audit data for threat detection, compliance investigations, and risk mitigation. Whether you're investigating suspicious behavior, preparing for a compliance review, or strengthening your security posture, this step-by-step breakdown shows you how to turn audit data into actionable insight.
Guest: Mirko Peters
Aug. 16, 2025
Microsoft Fabric Lakehouse Governance and Data Lineage
Stop guessing where your data went. In Microsoft Fabric, automatic lineage, workspace-based permissions, and Purview’s enterprise catalog turn opaque pipelines into auditable, end-to-end flows—from ingestion to transformation to the report. Fabric captures every hop (Data Factory, Lakehouse, notebooks/SQL/Dataflows, semantic models, Power BI), enforces access consistently via workspace inheritance, and records who changed what and when. With Purview cataloging and classifications on top, you can search sensitive fields across workspaces, prove compliance with unified audit logs, and fix broken KPIs fast—without chasing email threads or exporting mystery CSVs.
Guest: Mirko Peters
Aug. 15, 2025
Automate Real-Time Actions with Fabric Data Activator
Stop waiting on dashboards. Fabric Data Activator turns live signals into instant actions—pausing bad pipelines, placing purchase orders, opening D365 work orders, or triggering API calls the moment thresholds hit. Because it’s native to Microsoft Fabric, it listens to streams and models from Power BI, Synapse, and the Lakehouse, then executes pre-approved playbooks with minimal latency. Start small with high-value triggers, design for capacity and downstream SLAs, and wire in guardrails so you get signal—not alert spam. That’s how you move from data-driven to data-activated.
Guest: Mirko Peters
Aug. 14, 2025
Train AI Models with Microsoft Fabric Notebooks
Stop torturing your laptop. Train models where the data lives. With Microsoft Fabric notebooks running on Spark next to your Lakehouse, you skip CSV exports, move terabytes at query speed, and iterate in Python or R without memory crashes. Push transforms to the data, engineer features at scale, monitor long runs in real time, checkpoint models, and evaluate across massive test sets—cutting days of wrangling into hours of results.
Guest: Mirko Peters
Aug. 14, 2025
Design Scalable Dataverse Data Models
Dataverse “slowness” is often schema, not size. Fix table bloat, simplify relationships, and add the right indexes to turn crawling forms and timing-out flows into crisp responses. Design for performance from day one—balance normalization, limit cascades, and index what you filter on.
Guest: Mirko Peters
Aug. 14, 2025
Integrate Viva Topics with Search and SharePoint
Viva Topics can surface gold—or noise. Turn AI guesses into trusted answers by triaging topics in week one, curating only what matters, merging duplicates without losing links, and designing rich, action-first topic cards. With the right governance, SMEs, and analytics, people stop “searching” and start finding.
Guest: Mirko Peters
Aug. 14, 2025
Audit SharePoint Online Permissions at Scale
Manual SharePoint reviews don’t scale. Use PnP PowerShell + Microsoft Graph + Azure Automation to enumerate every site, expand nested/group/inherited permissions, and deliver a clean, daily report. App-only auth, throttling-safe queries, and diff alerts turn a weeks-long audit into an automated, trustworthy pipeline.
Guest: Mirko Peters
Aug. 13, 2025
Customize Microsoft Viva Connections Dashboards
Viva Connections can be more than a pretty SharePoint homepage. Pair a solid foundation (navigation, targeting, permissions, mobile) with SPFx web parts and Adaptive Card Extensions (ACEs) to surface live business data and actions inside Teams. Build tiles that do work—approve, submit, track—then drive adoption with role-based personalization, performance discipline, and a measured change plan.
Guest: Mirko Peters
Aug. 13, 2025
Integrate Dynamics 365 Sales with Microsoft Teams
Stop context-switching. Embed Dynamics 365 Sales directly into Microsoft Teams so reps update opportunities, trigger approvals, and log notes where they already work. Layer Power Automate and Adaptive Cards to turn chats into actions (create/update/approve) and keep CRM as the single source of truth. Result: faster deal cycles, cleaner data, fewer misses.
Guest: Mirko Peters
Aug. 12, 2025
Build Reusable Semantic Models in Microsoft Fabric
Most Power BI environments start fast and stall under copy-paste sprawl: duplicated PBIX files, conflicting measures, and “spreadmart” dashboards that nobody fully trusts. The fix isn’t another naming convention—it’s a model-first architecture. Microsoft Fabric elevates the semantic model to an enterprise asset: one definitional layer reused across reports, workspaces, and teams. Pair that with calculation groups to eliminate endless YTD/QTD/TTM variants and keep time intelligence, KPIs, and business rules centralized and auditable. Add row-level security in the model to deliver true governed self-service—users explore freely while access is enforced automatically by role and region. The result: fewer datasets, consistent metrics, faster updates, and a BI stack that scales without chaos. If you’re tired of DAX drift and number debates, Fabric’s semantic models + calc groups + RLS turn scattered reports into a trustworthy analytics backbone.
Guest: Mirko Peters
Aug. 12, 2025
Optimize Microsoft Fabric Lakehouse Performance
Microsoft Fabric Lakehouse environments enable unified analytics across structured and unstructured data — but performance optimization is critical to ensure scalability, cost control, and reliable reporting. In this guide, we break down how to optimize Lakehouse performance in Microsoft Fabric, including data modeling strategies, partitioning best practices, query tuning, workload management, and storage optimization. Whether you're working with large datasets, real-time analytics, or enterprise reporting, these practical recommendations help you prevent bottlenecks and improve overall system efficiency. If your Fabric Lakehouse feels slow, unpredictable, or expensive — this is where to start.
Guest: Mirko Peters
Aug. 10, 2025
Secure Microsoft Fabric Data Pipelines
Microsoft Fabric pipelines often feel “secure by default,” but silent data exposure usually comes from misconfigured permissions, hardcoded secrets, and overbroad workspace roles. This episode shows how to harden end-to-end pipelines with managed identities (kill passwords), Azure Key Vault (centralize and audit secrets), and precise RBAC (least privilege at workspace, pipeline, and dataset layers). You’ll learn where Fabric inherits risky defaults, how tenant/workspace access quietly widens, and the exact steps to lock down connectors, notebooks, and pipelines—without slowing your teams. Walk away with a practical security playbook, audit-ready logging, and guardrails that let admins, analysts, and engineers move faster with less risk.
Guest: Mirko Peters
Aug. 10, 2025
Automated Testing for Power Apps and Dataverse
Low-code does not mean low risk. Power Apps and Dataverse sit at the center of many business-critical processes, so skipped testing leads to silent data loss, broken approvals, and security leaks. This episode shows how to build a real testing strategy for the Power Platform: automate end-to-end scenarios across roles and environments, validate Dataverse business rules and flows, and wire tests into CI/CD with tools like EasyRepro and the Power Platform CLI. Learn why manual UAT misses dynamic UI, security role differences, environment variables, and connector drift—and how automated tests catch them before production. Walk away with a practical framework, checklists, and KPIs to accelerate delivery while protecting data quality, compliance, and trust.
Guest: Mirko Peters
Aug. 10, 2025
Manage Git Integration for Microsoft Fabric Notebooks
Microsoft Fabric’s Git integration isn’t a backup—it’s the backbone of safe, scalable collaboration on notebooks, pipelines, and models. This guide explains why merge chaos happens, what actually syncs to Git (code/metadata) vs. what doesn’t (Lakehouse data), and the one switch that saves teams: adopt a simple dev→test→prod branching model with pull requests. You’ll get a practical playbook to connect workspaces, resolve conflicts, manage environment configs, and keep data parity—so rollbacks are one click, not a week of rework.
Guest: Mirko Peters
Aug. 9, 2025
Use Fabric Notebooks for Data Transformation and ML
Stop wrestling Power BI with endless clicks. Microsoft Fabric Notebooks let you prep, model, and feature-engineer data end-to-end—in Python or R—right inside your Lakehouse with Spark scale and Git governance. This guide shows a proven workflow: ingest to Bronze, clean and join to Silver, feature-engineer to Gold, and publish to Power BI or ML—all from one notebook. Learn the overlooked switch pros miss: treat notebooks as your single source of truth (code-first, Git-backed, env-parametrized), not as ad-hoc helpers. You’ll get patterns for data lineage, environment configs, access control, and can’t-miss guardrails (snapshots, canary checks, idempotent writes) so rollbacks are painless and dashboards stay accurate.