Bismillahirrahmanirrahim asalamualaikum warahmatullahi wabarakatuh Hello great kids meet me again Ana Aulia som on the great student channel today we will study the material on Informatics class 8 data visualization, namely recognizing and making various charts or diagrams in the data analysis elements of the Merdeka curriculum What is data visualization and how to make various charts or diagrams to visualize data keep watching this video until it's finished So that you understand, don't forget to like subscribe and ring the bell Why because on this great learning channel you will get lots of learning videos and also practice questions about Informatics phase D class 7 8 and class 9 junior high school so make sure Don't miss it, go straight to the concept map that we will learn after yesterday in this data analysis element you learned about data search look up and also reference today we will learn about data visualization What is data visualization data arranged in table form can be displayed in graph or chart form This is what is called data visualization data visualization makes it easier to understand the meaning of existing data, usually this activity is called data analysis data visualization can also be used to make predictions about data values, namely estimating data values ​​at a time The upcoming paint that can be used to help predict data is Line or column for data prediction on the x-axis must be data that shows time for example month or year each type of chart has a different use from other charts in data visualization in Microsoft Excel there are several types of charts for data visualization What are the types of char and also their uses okay let's just learn the first type of charge is the column chart or column graph its appearance is like this yes its use is to compare the values ​​of several groups of data using vertical bars or bars second there is a line chart or line graph its appearance is like this its use is to display data trends in a time interval use a line chart if it has a date text label or numeric label on the horizontal axis third there is a pie chart or pie graph example of its appearance is like this its use is to display the contribution of each value or Slice to the overall value or p pie chart can only be used for one group of data then fourth there is a bar chart or bar graph example of its appearance is like this yes bar chart is a horizontal version of the column chart use a bar chart if the data has a wide text label and finally there is an area chart example of its appearance is like this area chart is a line chart with the area under the line filled with color use stack area Chart to display the contribution of each value to the total value in a time interval, there are several types and also the uses of charts or diagrams then next How do you make various forms of good charts or diagrams before we make various forms of charts or diagrams there are several things to pay attention to the first is Determine the right type of chart according to your needs two pay attention Is the chart only for one group of data or for several groups of data if for several groups of data you need to write a legend or Legend for each group of data The legend must be meaningful according to the data and the third Kapi chart with graphs or titles x-axis labels and y-axis labels or meaningful labels okay let's just practice how to make various diagrams here Mother has opened the Microsoft Excel worksheet and here there is already a table where here the table is the data on the number of tourists from several ASEAN countries to Indonesia here in 2017 because here the data is single data Okay Let's just go straight to the first, namely we block the table first after we block the table we click Insert then we select the first is a chart or bar chart first yes the first chart here just click Well here there are several options there are two dimensions and also there are three dimensions yes we choose the easiest one first, namely the two-dimensional one, first we click on it and it will appear like this, yes This is the appearance of the two- dimensional chart or bar graph Well here, yes, after we take the diagram or chart, we can change its shape by clicking more, yes, here we have a lot of choices, yes, you just have to choose which diagram you want, yes, there are a lot of choices Later, you just have to choose what kind of diagram you want, yes, later, it's up to you, ma'am, I just want this one, this is an example of making a bar chart for single data and if you want to add a label, yes, the label data, if we want to add it, we just click on the bar or the stem, then we Right Click, yes, Add data label, later the label data will appear in Malaysia 2,121,888, the same, yes, the label data will appear, that's how to make a diagram or bar chart Okay, let's go straight to the second, we will make a P diagram, okay, the method is the same, namely, we block the label first, yes, we block the table first, then click Insert, then here there is a pie chart, yes, we just click on the p diagram, yes, here it's the same, there are several choices, there are two dimensions, there are three dimensions and there is also a dog note, we choose the two-dimensional one first Yes, click on the two-dimensional one, just like the bar chart here, you can change the appearance of the pie chart. Just select it here. There are many forms of pie chart displays. You just have to choose it. Okay, which one do you want? Okay, I want the same one, black too. Then, I want to add label data, okay, just do that. Right click again, just click on the pie, then right click, then add label data. This is it. Enter it one by one. You can enter it directly, like the first one. Try it, here, enter it one by one. That's how to enter label data for a pie chart and finally, I will try to make a line chart for single data, the same as we block the table first, then we click Insert, then select Line here. Insert Line is selected, there are two dimensions, there are three dimensions, I choose two dimensions, okay, the same as this bar table, shrink it first so it fits for several diagrams. Okay, this is the last line, I put it here, okay, this line chart, you can also change it by clicking here. There are many displays of line charts, I just want this one. blue and to add the data label just right click add data label then all the label data will appear here this is for single data yes how to make a diagram for single data Then how to make a diagram for double data Okay Let's go straight to how to make a diagram or chart for double data is the same as how to make a diagram on single data the first thing we have to do is we block the table that we will make a diagram then select Insert yes then select the bar chart first we will try to make a bar chart Well here there are two dimensions and there are three dimensions we choose the two dimensions well this is how it looks and if we pay attention the appearance is not appropriate Don't worry we can Reset yes how to do it is we you click the chart filter yes then here you select select data okay here the series in the Legend entries we remove all of them first yes we take the data from the beginning okay the first we add or click add then we take the country of Malaysia then select the data for Malaysia data then we Add again for Singapore data Okay we select the data Okay we Add again for the Philippines data we take the data for Philippines and the last we take the data for Thailand okay Okay we take the data Well here you can see yes for the blue data for Malaysia orange for Singapore then gray for Philippines and Thailand the color is yellow but here it is still 1 2 3 for the horizontal category so we have to edit this 1 2 3 yes we edit then we take here 1 2 3 is the year that will be used as the horizontal data okay click okay now this data is in accordance with the table yes we can see here for Malaysia from 2017 yes we add eh the label data Right Click add data label Well for Malaysia in 2017 it was 2,100 21,0888 in 2018 it rose to 2,503,344 and 2019 it rose again to 2,834,744 is correct for data visualization diagram using the bar chart Well here also if the data is correct you can choose as before in single data you can choose ee which chart style you want to use Well here eh there are lots of choices Okay ma'am which one do you want to use Okay just use the black one so it looks This is how to make a diagram bar with double data Okay let's try again if we want to make a line chart with double data just like in the bar chart, we block it first then select Insert then select the line chart Okay we choose the two-dimensional one here also the data still looks messy yes no need to worry yes you can Click the right side then select select data yes we delete all the series first we take the data again as it was in e making the bar chart first we add Malaysia first then we take the value continue Second we take Singapore data then we take Val we Add again add the Philippines again then we take the value and finally we add Thailand in the series value we take after that for the horizontal data it's the same yes we edit from 2017 to 2019 we just Okay this is the ee data for the double data line chart the number of tourists from several ASEAN countries to Indonesia if the data is correct you can change the chart style which one you want to choose yes we look for the appropriate chart style which one you want yes okay okay This is how to make a chart or diagram for double data and for double data we cannot use e pie diagram or pie chart because pie charts are only used for single diagrams but for other diagrams it can used to create multiple charts or diagrams, okay, that's how to create various diagrams or charts, I hope you understand and can practice them at home well. There is still a lot of material about data analysis that I will discuss in the next video, so make sure you subscribe and ring the bell for video updates every week. That's all from me, keep up the spirit. Let's be successful together. Wassalamualaikum warahmatullahi wabarakatuh