Relationships in Power BI

Question

HI there,&nbsp;&nbsp;Does anyone have a good tutorial on setting up data in Power BI?&nbsp;&nbsp;I have three sets of data that contain some unique information and some information that is common across all the data sets.&nbsp;&nbsp;For example in set 1 I have types of cars, in set 2 I have types of motorbikes, and in set 3 I have types of bicycles.&nbsp;So all have a price - and I would like my dashboard to be able to compare them, but they also have characteristics that are non-comparable, for example bicycles might have the type of chainset.&nbsp;&nbsp;Would it be best to dump all of these in one table and just have a column for cars/motorbikes/bicycles? Or would it be best to have 3 tables? Or maybe 4 tables with a single table somehow linking them?&nbsp;&nbsp;I realise this is a very broad question - which is why I ask for perhaps a tutorial that might help me understand data in PowerBI a bit better. Most tutorials seem to focus on the visuals.&nbsp;

mlsx4 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;You should look for tutorials regarding data modelling (which is related to the way we understand databases structure). In your case, I will create a database with common data (parent): ID vehicle, type (motorbike, bike, car), price, etc.And now, auxiliary data related to each kind of vehicle (children).&nbsp;I don't know any specific tutorial, but I'll give you some keywords that could guide your search: star schema, snowflake schema, data modelling in power bi.&nbsp;P.S. I have searched for some explanation about your case and found this:&nbsp;https://vertabelo.com/blog/inheritance-in-database/

Forum Discussion

Relationships in Power BI

2 Replies

Related content

Relationship

Power Bi Relationship

Relationships

Relationship Issue

Creating relationships