Tutorial: Self-Service-Datenaufbereitung in Microsoft Fabric: Data Flow Gen2 ohne IT

Does this sound familiar? You need a key performance indicator (KPI), you involve two departments – and you still end up waiting three weeks. Meanwhile, the data is already there. In this video, we'll show you how to prepare your data yourself using Data Flow Gen2 in Microsoft Fabric, without any coding knowledge – quickly, transparently, and without having to wait for the IT department. You'll learn, among other things: 🔹 How to identify and remove duplicate data 🔹 How to create conditional columns (e.g., Customer vs. Colleague) 🔹 How to filter and clean data 🔹 How to create new columns using AI-powered sample recognition 🔹 How to adjust data types and rename columns 🔹 How to save the completed data flow and reuse it for future analyses Best of all: Once created, you can simply run the same data flow again for every subsequent webinar – without any duplication of effort. You'll learn, among other things: How to: Identify and remove duplicate data 🔹 Create new columns using AI-powered sample recognition 🔹 Adjust data types and rename columns 🔹 How to save the completed data flow and reuse it for future analyses The best part: Once created, you can easily run the same data flow again for every subsequent webinar – without duplicating any work. 🔹 📌 Chapters: 00:00 The Problem: Long Waiting Times for Data 00:18 Our Example: Webinar Participation 00:23 Raw Data from Lake House 00:51 Getting Started: New Data Flow Gen2 01:32 Selecting a Data Source & Loading Tables 02:05 Removing Duplicates 02:27 Viewing History & Previous Steps 02:48 Conditional Column: Customer or Colleague? 04:06 Filtering by Email Domain 04:49 Creating a New Column Using an Example (AI-Powered) 06:10 Overview of Applied Steps 06:26 Deleting Steps & Adjusting Data Types 07:18 Renaming Columns & Setting the Target 07:52 Saving, Running & Reusing 👉 Find more tutorials about Microsoft Fabric, Power BI, and modern data platforms here on this channel. #MicrosoftFabric #DataFlowGen2 #PowerBI #SelfService #DataEngineering #Lakehouse #Tutorial #German