Data Model in Power Pivot for Excel or Power BI (Table Normalization & Denormalization)

Normalization & Denormalization of Table or Database in Power BI

This topic is not limited to Power BI. if you have worked on relational databases so probably you are familiar with these words. Normalization is nothing but a method or way to keep data in multiple connected tables to remove repetition and vice-versa denormalization. When all information related to a set of data is maintained in a single table then we can say it is a denormalized table See below image for better clarification.

Now observe the second image carefully. now one table is truncated and a new table has existence in the data model. in this form category and subcategory's duplication is removed. it saves lots of memory without losing the data.

Table Normalization is the root of all data models not only for Power BI. Let's Go with me with an upcoming webinar on 14th June 2020 Sunday at 2 PM. and Learn At Home with Me

Click here to Register here with a forthcoming webinar

Download Practice Files From Here

Meeting link will be sent to your registered mailing address. If you have not registered yet so CLICK HERE to Register.