Primary Key vs Foreign Key Explained in Excel

What is a primary key? What is a foreign key? And how do they help you connect different Excel tables? In this video, I explain these concepts using an HR data model in Excel Power Pivot. I show how EmployeeID can uniquely identify an employee in one table and connect to multiple records in related tables such as attendance, payroll, training and performance. In this video, you’ll learn: What a primary key is What a foreign key is How EmployeeID connects different tables Why a primary key must be unique Why a foreign key can contain repeated values How primary and foreign keys support table relationships How this applies to Excel Power Pivot and Data Modelling ⏱️ Timestamps 00:00 Introduction 01:20 What Is a Primary Key? 04:00 Primary Key Example in Excel 06:30 What Is a Foreign Key? 09:00 Foreign Key Example in Excel 11:30 Primary Key vs Foreign Key 14:00 EmployeeID as the Common Field 16:00 Connecting the HR Tables 18:00 Understanding the One-to-Many Relationship 20:00 Why Keys Matter in Data Modelling 21:20 Key Takeaways 22:00 End #Excel #PowerPivot #DataModeling #PrimaryKey #ForeignKey #ExcelTutorial #HRAnalytics #PeopleAnalytics #DataAnalysis