From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Database normalization

Database normalization - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Database normalization

“

- [Instructor] All right, this lecture covers an extremely important concept called database normalization, and it's a little bit nuanced, a little bit tricky to wrap your head around at first, so I want you to re-watch this video as many times as it takes until you really feel like it sticks. So the definition of normalization, it's the process of organizing the tables and columns in a relational database in a way that reduces redundancy and preserves data integrity. So a lot of fancy words there. Basically, it's commonly used to do three different things. First, to eliminate redundant data, which decreases table sizes and therefore improves processing speed and efficiency. Second, it helps to minimize errors and anomalies when you're making data modifications, like inserting rows, updating records, or deleting records. And then third, it helps to simplify queries and structure the database in a way that enables easy…

Contents