 Welcome to SSUnitech, Sushil this side and this is continuation of Power BI tutorial. So today we will see about the duplicate and reference queries. So what is duplicate and reference queries? So in the last video we have seen about the star schema. So we just want to make more precise our data model for our project. So we will implement the star schema in our project. So for that duplicate and reference queries are very important. So go to Power BI desktop and we will see in the practical. So this is the Power BI desktop. So as we can see we are having this country sales fact table. So we just want to create a duplicate first after that we will see the reference. So for that we can right click on that query and here we can see we are having an option with the duplicate and we are having an option with the reference. So just click on duplicate and we will see. So if we have created the duplicate then it is creating a copy of the country sales and all the applied steps are available over here. So as we can see in our main query we are having these steps and in the country sales 2 which is our duplicate query are having the same steps and we can see inside the applied steps. Now let me try to create a reference and we will see what are the difference between duplicate and reference. So here we can create a reference. So in the reference as we can see it is referring our main table and here we don't see any applied steps. So in the applied step we are having only this source. So this source is referring our main query. So this is the main query if we create the duplicate then all the applied steps will also go to the duplicate query and if we will create any reference then applied steps will be gone and this query will refer to our main query. So this is the difference between duplicate and reference query. So I am going to use the reference so let me right click on this and delete this duplicate query and click on delete. As we seen in the star schema first we can see we are having this address and this address table is our dim address and it is containing the address ID address 1 city state something like this. So go to our power by desktop and here let me rename this with address. So this is our dimension table. So let me call this dim that is dimension and this is address. Now here we just want only those columns which is related to address. So just remove other columns. So how we can do this choose columns and in the choose columns we want only address related columns. So in address related columns we can see address ID address ID 1 city postal code and our country name. So these are columns to address related so we can click on OK. So now we are having only these columns. Second we just want to remove the duplicate values because it will have the duplicate in the query. So how we can remove the duplicate as I told you in the starting videos here we can go to on home ribbon after that go to on this remove rows and here we are having an option to remove duplicate. So we can remove duplicate rows. Now we are having the distinct values in the dim address table and here we can see it is having address ID address line 1 city postal code and country. So that looks good. So in the next video we will see how we can create the dim customer and dim item and dim date. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.