Data Modeling Using Power BI

 Data modeling : It is the visual representation of data elements and the connection between them .

 ER Diagrams : Entity relationship diagram basically it contains different symbols and attributes .

Cardinality:-

• Many To One:- In many to one relationship, The column in one table can have more than one instance of a value, and the other related table, often knows as the lookup table, has only one instance of a value.

• One To One:- In a one to one relationship, the column in one table has only one instance of a particular value, and the other related table has only one instance of a particular value.

• One To Many:- In a one to many relationships, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value.

• Many To Many:- We can establish a many-to-many relationship between composite tables, which removes requirements for unique values in tables.

Step 1 : Click on get data button and load your data as shown below.

Step 2 : Select all names in lodad data and click on load.

Step 3 : click on the last button in left side which visualizes the model 

Step 4 : and Er Diagram is ready.

THANK YOU.....