High.
So let's get started with this lecture in this lecture we will learn about They've done more live in
poverty so they don't morally allow you to connect data from various sources and then link them together
or join them together to model your data.
So suppose you have the data from different EBIZ already done from different databases and they have
of common primary which is common in all of their DBAs.
So you can join them just like we did.
We can do them.
We can do that in a sequel we can join them in power gay as well.
So here it is pretty simple to model your data and let's see how you can do that.
So suppose I have this simple data quantity rating and sales data.
So I have these three.
So if I want to create a table suppose taking my product name from here and my sales from here and something
from here.
So as you can see this is not this is not showing the real data.
You can see the sales distributing in everywhere because their data has not been more deadly or that
they have not been joined yet so far.
So first we need to march.
We need to link all the tables together when we need to create a relationship between the tables but
this relationship will be created then we will be able to use these data from various sources or both
together.
So to do that what you have to do is click on this relationship part and you can see the all the tables
from various sources up here.
So you'll see this to this view.
So here are my two tables now.
Important thing here is that there should be one common column one primary column which is common in
all three of them.
So in all of your data I suppose in this quantity be able I have this order number come on which is
my primary key in the ratings as well as well as in the sales that I have my order number coming.
So if I have what's called Common column I can create a good relationship between all of my data.
So to do that all you have to do is simply read here to this point.
So from the column the column you have to drag it just like this.
Now if I have to create a relationship between these two as well I can do that as well.
One thing to note here is I can create a relationship between these two because I have already created
a relationship here.
So this will turn into bash land because they are that it is the relationship cannot be created because
we have created our indirect relationship between them.
So I'll delete this one.
So we have a relationship created here.
You can see that and when with our right now.
Now you can see we have our actual sales and values.
So will be ready when you go after the relationship has been created.
All of my data I can pick from all of my data sources to this is how you have to model your data in
power B-A and easily create relationships.
So once this relationship has been cleared there are certain things which you have to make sure.
So for that you have this option you are managing relationships.
Just click here.
This will show you all the relationship which has been created in your data.
So I have two relationship created as you can see one here another here so it is showing me the relationship.
Now RBI can also automatically order to that relationship once the data has been loaded.
If not you can always create a relationship just like I have created by dragging the line from one column
to another column.
Now one more thing I want to tell you that is the cardinality in cross-validation.
Just like in sequel's So then we can create our relationship one to one many to one or one to many kind
of relationship.
This kind of cardinality can also be created in power be a very clear relationship from many to one
or one to many or just one to one.
OK.
Now we can also have this we also have this option of Crossfield or direction which we're sure as of
now is selected as both we can create single as well.
So what difference does this Crossfield direction make.
Let me tell you.
So I have this one table.
OK.
I will create another table here.
And suppose let me just create our samples table here
the name and the quantity or just two things.
Ok I will.
Let me just make the values much more bigger so you can see in my second table we'll just saw the art
on number and reading
I can use the format painter to change the size of the venue.
So now you can see my two tables have been created.
So now I'm left with what cardinality Hoegaarden.
Now they do work here.
Right now my Cardinality has been said to board.
OK you can see our board for for my on the table and my sis stable and for my reading and quantitative
but also Cardinality has been set to board by board this thing means is if I click on a cell here this
will filter values from the as well.
OK.
And if I play.
Now let me just take it here and if I click any value from here.
Here we are.
Order Number 1 1 0 4 4.
You will see the value of that order only that is it which is showing the classic card order quantity
Order 40 or so.
This is showing Crossfield.
If I click on motorcycles right now this table will show only the values of motorcycles and other will
be filtered out.
So this is Crossfield that in both direction from here to here and from this table to this table.
All right so this was for both.
If if I did make it just a single for my gwon D and rating Dibbell if I said my cardinality single you
will see this option.
This filtered the filter that so that it isn't valid for this relationship.
OK.
You will get this kind of error sometimes that you cannot just cleared up single Gospel edition but
in some cases you will have this feature available of a single direction where if you click on just
one of the table like this one this will fill our bellies from this.
But if you click on this table and then this will not fill the any of these values so that will be because
cardinality of single player only.
Right now it has been said to bode that this is how cardinality works in power b.
So that was on the big things you need to know about modeling and power.
And keep on working will continue in the next lecture.
Thank you.