Learn the absolute basics of database normalization with crystal-clear explanations and expert-led tutorials.
In this demo, you’ll learn how to transform a single merged table into a relational data model using Power Query in Excel or Power BI.
Along the way, you’ll learn how to apply data normalization techniques to preserve integrity, eliminate redundancy, and build efficient and scalable models for data analysis or business intelligence reporting.
We’ll talk about:
✔️ What normalization means (in plain English) and why you should care
✔️ How to create star and snowflake schemas by "unmerging" tables
✔️ The difference between 1st, 2nd & 3rd normal form (1NF, 2NF, 3NF)
✔️ When normalization is actually NOT the best approach
…all in less than 20 minutes!
🔗 Helpful links:
👉 Downloadable project file: https://bit.ly/3XRHDAe
👉 Full Power Query, Power Pivot & DAX course:
Maven Analytics: https://bit.ly/3TPU6mO
Udemy: https://bit.ly/4en0eew
👉 10-Week Immersive Programs: https://bit.ly/47ObUo8
👉 Follow us on LinkedIn:
Chris: https://www.linkedin.com/in/csdutton/
Maven Analytics: https://www.linkedin.com/company/maven-analytics
⏱️ Timestamps:
00:00 - Intro
00:13 - What is database normalization?
01:56 - Relational data modeling 101
02:40 - Creating dimension tables with Power Query
08:12 - Creating a star schema in the data model
09:36 - Exploring the model with Power Pivot
10:57 - 2nd Normal Form (2NF)
14:07 - 3rd Normal Form (3NF)
16:38 - Creating a snowflake schema
18:00 - Pros and cons of normalization
Maven Analytics is an award-winning online platform for data professionals to learn new skills, showcase their work, and connect with peers around the world.
We've helped more than 1,000,000 students build job-ready data & AI skills, master tools like Excel, SQL, Power BI, Tableau and Python, and build the foundations for successful careers.
Start learning and build your FREE portfolio at www.MavenAnalytics.io