Data Lake vs Lakehouse vs Warehouse - Simply Explained

There is an AI assistant already switched on in every SharePoint site. Welcome to the M365 FM podcast, where we explore the people, ideas, and technologies shaping the future of work.In this episode of Simply Explained you will learn:What SharePoint Agents Actually AreThe Two Kinds of Agents You Will MeetHow an Agent Finds the Right AnswerWhere Agents Earn Their Keep at WorkWhat It Takes to Turn One OnThe Mistakes That Trip People UpThe Honest Limits of the ToolHow This Fits Into Microsoft 365 and AzureWhat to Remember Before You Build OneSimply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

Somewhere in your Microsoft 365 tenant, a Power Platform environment is filling up with apps and flows that nobody planned. Microsoft creates it automatically for every tenant, and it's called the default environment.In this episode of Simply Explained you will learn:What the Power Platform admin center actually isEnvironments are the one idea that makes the rest make senseWho gets in, and why the role matters more than the licenseThe jobs people do inside the portalGuardrails, not handcuffs, and how policies keep data safeKeeping an eye on capacity, licensing, and costWhere beginners get surprised, and the honest limitsHow it fits beside Microsoft 365 and AzureA short recap, and one question for youSimply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

Shop floor apps succeed when operators actually want to use them. In this episode of the iFAKT series, we cover designing Power Platform apps for operators: simplicity, offline use, data capture and integration.You will learn how to build and roll out apps the floor adopts.Who it is for: Citizen developers, manufacturing IT and operations leads.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

Gartner predicted that eighty percent of data lakes would fall short, and the culprit was missing labels and catalogs. That gap is part of why a third option showed up, the data lakehouse, sitting beside the older data warehouse and data lake.In this episode of Simply Explained you will learn:Where all this data comes fromThe data warehouse, the tidy oneThe data lake, the cheap and messy oneHow a lake turns into a swampThe lakehouse, which tries to have bothWhere this lives in Microsoft FabricOneLake and the one copy of dataDirect Lake, Power BI, and the honest limitsThe short version and a questionSimply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

Dataverse doesn't protect your business data with a password or a firewall. It protects that data with a security role, which sounds like a small admin setting until you realize it decides what every person in your company can see, change, and even print.In this episode of Simply Explained you will learn:What protects your data in DataverseWhat Dataverse isA security role is a job description for your dataThe five access levels and how far a permission reachesBusiness units, the departments of DataverseTeams, giving access to groups instead of peopleThe layers you reach for only when you have toWhere beginners get burned, and the honest limitsHow Dataverse fits into Microsoft 365, Azure, and the Power PlatformWhat to take awaySimply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

Static schedules break when reality changes. Adaptive planning responds to it. In this episode of the iFAKT series, we discuss how AI can support production planning: forecasting, constraints and capacity.You will learn what data and process changes planning teams need.Who it is for: Production planners, operations leaders and data teams.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

In September of 2025, Power Apps added something called user defined functions. You write a formula that works, then you need the same logic somewhere else, so you copy it.In this episode of Simply Explained you will learn:The formula you keep writing over and overWhat a user defined function actually isWhy copying and pasting formulas breaks downWhere you write a function and how the syntax readsA simple example you can pictureFunctions that do things, not just calculateWhere this fits in Microsoft 365 and AzureThe honest limits you should knowWhat to remember, and a question for youSimply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

Your time tracking app can save records perfectly, calculate totals correctly, and still lose the people who need to use it every Friday. They don't avoid it because Power Apps failed.In this episode of Simply Explained you will learn:Opening: The UI Choice That Decides AdoptionStart With the Job, Not the ToolPCF: When a Standard Screen Can’t Do the JobCustom Pages: The Default Choice for Most Business AppsGenerative Pages: Prompting a Starting Point, Not Skipping DesignCode Apps: When Power Apps Becomes a Full Product SurfaceThe Decision Framework: Choose the Smallest Tool That Solves the User ProblemConclusion: Make the Next Choice SmallerSimply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

Somewhere in your company right now, an expense report is sitting in an inbox, waiting for someone to say yes. That waiting is exactly what Power Automate Approvals removes.In this episode of Simply Explained you will learn:What an approval in Power Automate actually isHow a flow asks someone for a decisionThe different ways to ask for an approvalWhere the person clicks approveA small example, start to finishHow this fits into Microsoft 365 and AzureThe limits worth knowing before you buildThe mistakes beginners makeHow to start without getting overwhelmedA quick recap and a question for youSimply Explained by M365.FM breaks down Microsoft 365, Azure and modern IT topics in clear, jargon-free language. Hosted by Mirko Peters.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.

A model can find defects, but inspection results depend on lighting, data and process. In this episode of the iFAKT series, we cover what you need beyond the camera: data collection, labeling, deployment and feedback.You will learn how to approach visual inspection projects realistically.Who it is for: Quality engineers, AI engineers and manufacturing IT.Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-fm-microsoft-365-azure-cloud-power-platform-ai--6704921/support.This episode includes AI-generated content.