 Hey guys welcome to SSUNitech, so see on this side and this is continuation of Power BI tutorial. So today we are going to start with the visualization and this is the first video on the visualization. So let's start with the visualization, go to on the Power BI desktop and here we will try to create the visualization. So here as I have told you we have three views, first is the report view, then we have data view, after that we have model view. So we have successfully get the data from the source, after that we have cleaned that data inside the query editor and after that we have successfully loaded that data into Power BI desktop. After that we have also created the relationship inside the model view. So here you can see we have the country sales final table, then three dimension tables, first is address, then customer, then product. And we have also created the relationship between these tables. So go to on the report view and here we will try to create the visualization. So before going to start with the visualization, here in the bottom you can see page two. So either we can add one more page and we can also add n number of pages as per our requirement and if we want to delete any page then we can go to on that page and in the right top you can see a cancel button. So we can click on that and it will ask, now we can delete it. So this will be deleted and we can delete the other pages as well. So now we can see we have only one page. So I hope you have understand how we can add the page and how we can delete the page. Now we want to rename this page, so we can totally click on that and here let me call this as first visualization. So we can rename like this. After that here let's start with the column chart. So the first visualization that I am going to take in the clustered column chart. So we can click on that. Now we can left click on the mouse and we can place anywhere in the screen where we want. So I want to make it on the left top then we can click and we can make it bigger as much as we want. After that here we can see in the visualization below on that we can see the fields then we can see the format and the third option that is analytics. So I am going to start with the fields. So in the fields we can see we have access, then listen, then value, then tool gives. So in the access it indicates the x-axis, what value we will specify over here will be appear over on the x-axis. After that the listen it will be work on the visualization and will be split at the values on the columns according to that listen. Then the value in the value it will be aggregated the value by which we want to do the aggregation. So let's start in the access. I want to use the country-wise data. So go to on the address table and here we have the country details. So this is the country name. So we can drag and drop in the access. So here we cannot see anything. So why we are not seeing anything? Because in the values we have not defined anything. So go to on the country sales final table. Here I want to calculate the total due amount. So here we can see we should have the due amount that is total due. So we can drag this and drop in the values. Here we can see this down arrow. So we can click on that. Here we can see we have the options for the aggregations like either we can sum or average the minimum maximum count distinct count any one of these we can choose. So here we can see the visualization that looks good. Here the first is the United States. So here we can see the total due amount is 18513073.09. After that the Canada then France then UK then Germany then Australia. So we have all these values. Now the next thing I want to split this data in the columns by due dates. So we can see we have the due date in the country sales final table. So let me drag this due date in the listen and we will see. So here we can see we are having all these values but it doesn't seems good. Because in Australia we can see it is very low values and here in the Canada we can see only one year we have the values is very high other values are very less. Why we are getting values like this because in the listen in the due day we have used the due date that the exact date and time values. Now let me select the date hierarchy over here. So it will be added according to the year wise data. So here we can see if we will go on this then we can see it is year 2013 and if we move down then 23rd then we move down and here we can see 2011 and here 2014. So we have data like this. This is for US and Australia, Canada after that France Germany and UK. So we are having all these values. So here we have understand the basics of the visualization and how we can create the first visualization using the cluster to column chart and here we have discussed about the axis then we have discussed about the listen and then we have discussed about the values and in the values how we can change the aggregate option. So we can use the some average according to our requirement and in the listen we can select the exact date or we can use the date hierarchy. So we have used the date hierarchy as here. So we are having this data like this. Next thing we don't want to use this listen and in the tool tip we will see the data. So how we can use the tool tip we will see in the next video. 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.