Convert a Flat File into a Power BI Star Schema (Data Modeling Step-by-Step)

Learn how to convert a flat file into a scalable Power BI data model by separating fact and dimension tables. In this lesson, you'll discover how to extract dimension tables, create primary keys, remove duplicates, merge IDs back into the fact table, and use the Folder connector to automatically combine and append new files as your data grows. This video is part of the Power BI Advanced Course, designed for beginners who want to build a strong foundation in business intelligence and data analytics using Power BI. 📚 Watch the Full Course Playlist:    • Power BI Advanced   Download the exercise files used in the lesson: https://powerbitraining.com.au/power-... 💼 Work With Me: We help businesses and professionals build high-quality Power BI solutions and become data-driven: → Corporate Training (2–5 days, in-person or online) Master Power BI, DAX, data modeling, and report design https://powerbitraining.com.au/ → Consulting Data model audits, performance optimization, and BI strategy https://amzconsulting.com.au/ → Coaching 1-on-1 programs to become a job-ready Power BI analyst https://coaching.amzconsulting.com.au/ ⸻ 🌏 Based in Sydney | Working with clients globally 📧 info@amzconsulting.com.au 🌐 https://amzconsulting.com.au/ 💼 LinkedIn:   / trainernoorani   ⸻ 0:00 Introduction 0:35 Converting a Flat File into a Data Model 0:52 Extracting Dimension Tables 1:17 Choosing Dimension Columns & Removing Duplicates 2:21 Creating Primary Keys with Index Columns 3:13 Creating the Product Dimension 3:56 Identifying the Correct Dimension Columns 4:55 Validating Dimensions with Column Distribution 6:06 Converting the Flat File into a Fact Table 6:22 Adding Dimension IDs with Merge Queries 7:03 Adding Product IDs to the Fact Table 8:40 Building Relationships in the Data Model 9:04 Why Data Models Scale Better Than Flat Files 10:41 Handling New Monthly Data 11:15 Automatically Appending Files from a Folder 12:56 Connecting Power BI to a Folder 13:28 Combining Multiple Files Automatically #PowerBI #DataAnalytics #businessintelligence