 Hey guys, welcome to SSUD Tech. So, see this side and this is continuation of Power BI projects. So, this is part 2 of Power BI project and today we are going to see the word GDP in US dollars. So, our source is again web source. So, I am going to use the IMF website to get the data. And after that we will create this beautiful visualization. Let me explain about this. So, here we are having two slicers. First is year and second is country. And in the right side we are having this card. So, this is our current date. After that, in the bottom of this word GDP in US dollar, we can see the first visualization that is our tree map chart and it is having the value for top 7 countries by GDP. In the right side, we can see the overall summary and it is year wise. So, we can see the country is India. By default, I have selected and here we can see the data for year wise. Like it is 2020, then 2019, 2018, then 2017 and it is in decreasing order. In the bottom, we can see this table. So, in this table, we are having the country in the first column. After that we are having the years and the value for that particular year. If we will move forward in this table, then we can see it will be gone up to 2020. So, it will start from 1980 and we will move forward for 2020. So, this is what we have in this visualization. So, here let me explain about these filters. So, if we will change the year filter, then the tree map chart will only be affected and other will remain same. For example, let me select for 2020 instead of 2019. So, we can see the only change in the top 7 countries by GDP. So, this is in year 2020 and if we will change the country, then it will only impact the overall summary by year. So, let me change this India to for example, Afghanistan. So, here we can see the data. So, we will see it will start from 2002 to 2020. So, it is having data like this. So, we will create this beautiful visualization in this video. So, if you are new in my channel, so, I would request to you all please subscribe my channel and press the bell icon and first of all just press the like button on this video. So, it always motivate me to record more and more videos on the Power BI. So, let's get started. First of all, let me open the new Power BI. So, this is the Power BI desktop. Now, go to on the our web browser. So, I want to use the Google Chrome. So, I am here. Here we can search this IMF. What economic outlook database. Here we can see December 2k 19 but here we are having the data up to October 2k 19 only. So, just click on this and we need to wait. Here we can see by country. So, we can click on this after that here all countries after that continue. Here we can see the option for gross domestic product current prices US dollars. So, just select this and continue. So, I want to data from 1980 to 2020. So, let me select that and here 2020. After that, it will be a report. It will take few seconds and we will get the data. Now, go to on the Power BI desktop. So, here it is opened. So, let me cancel this from here. So, we are in the Power BI desktop. Just cancel it. So, here cancel it as well. And here we need to get the data. So, we can go on this get data after that. Here we can select the option for web and we need to wait few seconds. So, here we need to use the URL. So, go to on the website and let me copy this URL. And I will also paste this URL in the description of this video. So, if you want then you can copy it. Now paste it here. Now click on okay. It will take few seconds. We need to wait. It is connecting. Now, here we can go on the web view. So, here as we cancel the table one. So, we are required to use only table one. So, we can select it. And after that here we can see two options. First is load and second is transform data. So, let me click on this transform data. So, it will move to query editor. So, we are in query editor. Now, we need to clean up our data. So, here we will start our project. So, don't go anywhere. Just watch all these steps. And you will learn a lot of things from here because I am going to explain this project from starting to end. So, let me start. So, here as we can see the first row. So, this is not the correct one. So, we need to remove that row. So, how we can do that? So, here we can see the remove rows. So, we can click on this remove top rows. So, how many rows we want to remove? So, we want to remove the first row. So, we can specify one row and click on okay. So, here we need to wait. Now, it is the removed. Now, we can see the first row. So, this is the header row. And column 1, column 2, column 3 is not the correct header. So, how we can put our first row as header. So, we are having the option in Power BI. So, here we can use first row as header. So, just click on this. So, first row is our header now. After that, here we can see we are having all these data like 1980, 1981, 1982. But here we can see the value like NA. So, this NA is not the correct value. So, we just want to replace this NA by 0. So, how we can do that? Let me select all these columns first. After that, we will try to remove. So, let me select all these columns and after that we will remove these NA's. So, here is our last column. So, after that, go to on the transform ribbon and here we can see the replace value. Just click on this. What we want to replace? So, we want to replace NA by which? So, we want to replace by 0. Now, click on okay. It will take few seconds. Now, all NA should be removed. So, let me check. So, here we can see now we are having 0 instead of NA. So, all values has been replaced. As we can see the last column which is not the good one. So, we just want to remove that column. So, here remove column. So, this column is gone. Now, what next we want to do? We just want to create a column for here and next column for the values. We don't want to get these values as here in the columns. So, how we can do that? So, let me select all these columns after that. We will try to do that. So, let me select all these columns and here 1985, 81, 18. So, what we want to do? We just want to unpivot this data and all these columns would move in a single column and all values will move to another column. So, how we can do that? So, this is very simple in Power BI. Go to the transform. Here we can see unpivot columns. So, just click on this. Now, we can see the attribute and value. So, in the value that is 0 for some of the countries and in attribute this is the year. So, let me rename this as year. Now it looks good. So, I guess we have made a great progress in our project and we have cleaned up our data and we made the data as we want. Here we can see the country series specific nodes that is not required to us. So, we can remove this column as well. So, go to the home ribbon and here we can see the remove column. Just click on this. So, now it looks good and we are having all the required information. Now, we just want to load this into our Power BI desktop. So, we can go and close and apply. So, we need to wait few seconds and it will be loaded in our Power BI desktop. Now, we can see it is loaded and inside this field we are having this table 1 and it is containing the country, then scale, then subject description, unit and value and years. Now, it looks good. So, the first thing what we need to do first thing as we can see the header which is what GDP in US dollars and the background for that. So, how we can do that? So, here we can see we are having an option for text box. So, we can select that one. Just minimize this filter and here let me drag it on the right side and make it bigger and smaller from the bottom. Here what we need to write? We want to write the word GDP in US dollars. Now, we can select this and we can increase the size. So, let me use a 36 it is bigger. So, let me use the 28 and here we can set it as white color. Now, let me select one more time and try to replace it as white and font. So, now font is white after that here we can select the area. So, now it looks good. Next thing what we need to do? We need to use the background color for this. So, go to other which direction and here we can see the background. Background is white at yet. Let me use that green. So, this is not the good one. So, we can use the darker. So, little bit like this. So, now it looks good. Next thing we need to add two slicers first for the country and second for the year. So, go to on the digestion and let me select the slicer and here go to on the year. Just drag it and drop inside the print. So, it will have the values but we just want to get these values in the drop down not in the list. So, just click on this and here select the drop down. Now, we can put this as smaller as we can and make it smaller from the bottom and drag it and drop inside the text box. Now, what we need to do? We need to format this year. So, go to existing one here we can see the year then 2020. So, this is the format that we need to make. So, go to on our project and here go to on the format and here first thing go to on the title and use this title and slicer header. We just want to call this slicer header and in the title here we want to write the year and scroll down. Here we can use the font and here we can change the background color. So, let me change it and this is not the good one. So, let me select this one. Yep, this is the nice one and alignments would be center and we want to change the font then we can also do that. So, I guess this is good. Now, we need to change our background. So, here go to on bottom and search out for background and let me use the background as gray that is good. Next thing what we need to do go to on the items and here as I can see the background let me use that white. Now, it looks good and next thing we need to use the border. So, go to on the format one more time and borders will be on. Now, it looks good. Next thing just copy it and paste and just drag it on the right side and try to make it bigger little bit and make it bigger for here as well. In the year here we need to use the country. So, just delete this field and try to drag in and drop the country inside this field. That looks good and we are having the countries over here but we need to change the title for this. So, go to on the title and let me change this for the country. So, let me use the country. Now, it looks good. Next thing here as we can see the font size. So, this is not the good. So, if we want then we can also increase the font size. So, how we can do that? Go to on the format and here put on the items and scroll and we can increase it. I guess this is good and we can also use it and go to on the format center and try to use in the second one. So, that is also bigger. Now, we can see now it looks good and in the country it is also good. Next thing what we need to do? We need to use the three-map chart. So, how we can do that? Go to on the visualization and here we can see the three-map. So, we can click on this. Make it smaller from the right side and bigger on the top side and bigger on the bottom as well. So, what we need to do over here? We need to use the country in the group and after that use the value inside the values. But here as we can see we are getting this count and if we can use the sum then we don't see the option for sum. Why we are not getting the sum over here? Because the data type of this value is not the correct. So, we need to change the data type of this value. So, how we can do that? Go to on the query editor, click on this and here we can change the data type. So, we scroll on the right side and data type of this year it should be integer. So, whole number and the value it should be decimal. So, we can select the decimal for this. Now it looks good. Now we need to close and apply. This will take few seconds. So, we need to wait. After that here as we can see the count of values just click on this and now we can see the option for sum. So, now it looks good to me. After that here we can see we are having all the countries but we are expecting only top 7 countries. So, how we can do that? Go to on the filter and here on the countries here we can see the basic filtering and advanced filtering and top n. So, I am very happy to use top n, top 7 countries we want. What is the value by which we want to apply this filter? So, we just want to apply filter on the value. Now, apply this filter. So, it will take few seconds and now we can see we are having US, Japan, China, Germany, after that UK, France and Italy. So, this is the overall and we just want to select the year and it will be changed. So, let me select for 2019 and it will have data for 2019 only. So, that looks good. Next thing what I want to do? I want to use the data label over here. As of now we cannot see the data labels. So, go to on the format and go to on the data labels just on it and we can see the values in the thousands. So, that looks good. The only things we need to update the header of this that is value by countries on the correct title. So, we need to use the correct title. So, go to on the title and here we can use the top seven countries by GDP. So, now it looks good. So, we have done our first one. Now, move to second one. The second is the column chart. So, let me select this column chart and after that just drag it on the right side of this. So, here just I want to use this year in the access and value in the values. So, that looks good and we can see only the value for 2019 because we have selected 2019 in the year and let me change the country and select Afghanistan. So, as we can see these two filters are working for these two equations. As I told you we don't want to change this. If we will select the country then it will only affect the value by year and if we select the year then it will only affect the top seven countries by GDP. It will not want to affect our second digitization. So, how we can do that? Just select this year and go to on the format and here we can see edit interactions. In the edit interactions we can see we don't want to change this. So, we can select this as none. So, now we can see all these values and let me select for country and we don't want to change our left digitization. So, just nine. Now, we can see it looks good and here just click on this and try to format this. So, go to on the formatting, go to on the x axis. Here in the x axis we can see we are having year. So, we don't want to display this year and in the y axis we can see the value. So, we don't want to see this value over here. So, just scroll down and we should have an option for title. So, in the title just off it and do the same for y axis. So, open the y axis and scroll down in the title just off it. So, now it looks good and we have made a great progress. After that here we cannot see the country. So, we just want to see the country for which we are getting the data. So, in the lesion we should use the country. So, just drag the country and drop inside the lesion. Now it looks good and in the title we can see the value by year and country. So, that is not the correct one. So, go to on the format just scroll down and go to on the title. Here let me change this title. Let me call this as overall summary by year. Now it looks good. After that we can see we are having this bottom chart which is our matrix. So, go to on the matrix and let me select this and try to make it bigger and put it on bottom and try to make it bigger from top as well. So, now what we need to do here we just want to display the country in the rows. So, we can drag the country and drop it here and in the columns what we want to do in the columns we want to see the year. So, we can drag the year and drop it here. After that go to on the values just drag this value and drop inside this values and we can check this. So, it is sum by default. So, that is good. But here as we can see we are having Afghanistan only because we have selected the country of Afghanistan and we have selected the year. So, we are having this year only. So, we do not want to filter this by using these two slices. So, just select one of these and go to on this matrix and none. So, now it looks good but it is filtering for year as well. So, select the year and go to on this and put it as none. So, now it looks good. Next thing what we need to do we need to select it and go to on the format and try to format it. Go to on the style and here so we just want to change the format. So, in this style we can select the border header C rows. So, that is the same. Now, we just want to increase the size of this values on the grid. So, how we can do that? So, go to on the format again. So, here we can see the grid and just scroll down. Here we can see the text size. So, we can increase this. So, that is good. So, I guess we have made a great progress in our project and almost we have done it. So, just do one thing. Just select it and go to on the format and go to on the background colors and here open it. Go to on the background. Let me select this and in the transparency let me put it as 75%. Now, it looks good. Just try to put it as right side and make it bigger. We can do one thing. Just click on this edit interactions and now we can make it bigger. Now, it is called down. Do the same for this tree map chart. Make it bigger. Now, in the matrix just try to make it bigger as well. After that, we can see we are happy with it and let me off this and here as we can see in the overall summary we are getting the data from 1980 to 2020. But if we will click on more options, but here we can see the option for sorting by which we want to sort like we just want to get this 2020 first and 2019 then 2018 then 17 in decreasing orders. So, here we can not sort it. Why we are getting these options? Because we have changed the data type of the year. So, go to on the edit query time and here we need to wait few seconds and here it is called on the right side. Here we can see the year data type that is 1980. That is why by default it is in sorting order. So, let me change it to text and add a new step that is good. Now close and apply. It will take few seconds after that it may be work. So, here we can see the 2020, 2019, 80, 17 after that we can see that 2008. So, that is also not in the correct order. So, just click on the more option put on the sort. Here we can see it is sorting on the values. We just want to sort on the year. So, we can click on the year and now we need to wait. I guess in the sorting order 2020, 18, 15, 13 then it is in decreasing order as we are expecting. So, let me change the country and try to get the data for India. So, here let me select for India and we need to wait few seconds. Just try to make it bigger from the top and it is also good and let me put it on the bottom. Now try to make it bigger one more time on the right side as well. Now it looks good to me. So, here I guess we have done this project. Now try to compare with our existing ones. So, go to on the existing one. So, here we are selecting for 2019 and so the data for the US is 21,439.45 billion dollars because this data is in billions. Now go to on our existing one and here let me try to get this. So, 21,439.45 billion dollars. So, this is the same data. The only difference that I can see here we are having this date by which we are running this report and here that is missing. So, how we can add that one. So, go to on the fields and here let me select this table and put on the modeling. After that click on new measure. So, here I just want to create a measure that will be having the data for today's date. So, let me call this as today's date and how we can get this from DAX. So, we can call this as today's function. So, now it looks good. Now we can commit it and it will take few seconds. So, finally we have done it. Now we need to add a card. So, go to on the visualization and add this card. Just close it and put this on the right side of the country. Make it smaller, make it bigger from the bottom. Now go to on the visualization and drag and drop in the values. So, here we can see we are having data like this but we are not expecting like this. So, how we can change it? Just select this measure, go to on the format inside the modeling ribbon and here go to the date time. So, these all are the options available by which we want change it. So, what we are expecting? Let me select this March 14 option and we wait few seconds and here we can see April 14. So, you can change as you want to change it and if you want to format it just select this card, go to on the format and here we can see the categories just off it and we can see all these and so I hope you have understand how we can format this and how we can create this visualization rather than all the data which we are having in our existing that is same and I have explained step by step. So, guys I hope you have understand how we can create this beautiful visualization from scratch to our end project. So, thank you so much guys for watching this video. If you really like this video please subscribe my channel to get many more videos and don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much guys see you in the next video.