- 7 months ago
21 Must-See Charts for Mastering Data Visualization | Excel, Power BI, Tableau Tips in Hindi
Category
đ
LearningTranscript
00:00When we talk about data analytics, it is a very important role in the world of visualization.
00:06Because the visualization of the decision making is very much help.
00:11When you use Tableau, Power BI, Excel, Python,
00:16what do we need to do with visualization in the form of data?
00:20We need to convert the charts.
00:24In today's video, we will learn how important it is when we visualize the data.
00:34We will start with this video.
00:37We will understand the importance of the charts and the importance of how to create and how to create.
00:54In today's video, we are going to learn 21 types of charts for data analysis.
01:06For data analysis, we will discuss some important charts.
01:12So, first of all, we know that when we create charts,
01:18Why visualization in data analytics?
01:21Because in data analytics, why do we use the charts?
01:26Some of the reasons we use is that data is faster.
01:32This means that data is faster.
01:34By taking the data on the table of data,
01:35We can convert the charts,
01:38We can convert the charts as much faster.
01:40We can remove the data from the data.
01:42We can remove the data from the data.
01:44And we can make the data better analysis.
01:46We can make the data better analysis.
01:48We can make the data better analysis.
01:50We can make it more information.
01:52We can include it more than that.
01:54Faster decision making.
01:56You can easily identify your charts with the data.
01:58You can easily identify relations, trends and patterns.
02:03When we have charts, we can see patterns, variables and relations,
02:10or trends, or trends.
02:13In many places, we can see no need of data science skills.
02:18We can create some particular software.
02:23Now, we are going to discuss the chart.
02:28In the chart, you can see that the chart is in the form of line.
02:32You can see single line and double line.
02:36We have a value in the chart.
02:40We compare two to two.
02:43What is the chart?
02:45A line graph is also known as line graph and line chart.
02:49It is a graph used to visualize the value of something over a specified period of time.
02:54When we talk about period of time,
02:57a particular period,
02:59some years, some months, some days,
03:01some time period,
03:03we want to see our data as well.
03:06What is the trend going on?
03:09What is the trend going on?
03:10What is the trend going on?
03:11What is the trend going on?
03:13What is the trend going on?
03:15When you want to present trends for different categories over same period of time and thus to show comparison.
03:20and then he tells us our trends, our sales are increasing, which product is increasing, which is increasing, which is increasing, which is increasing.
03:29When do you use this? When do you use this? When do you want to display trends?
03:35When do you want to display trends? When do you want to display trends for different categories over the same period of time and thus to show comparison?
03:43When we want to compare two things, like product, category, sub-category, group, we want to compare them to a period of time.
03:56What can we find out inside of that? What can we find inside of that?
04:06Next is the bar chart. You will understand the bar chart.
04:12Like chocolate bar, there are bars.
04:15What is bar chart?
04:18This is the bar chart.
04:20That represents data using bar of different heights.
04:23This is the bar of different heights.
04:26The height is different.
04:28The height is different.
04:29It depends on your values.
04:32The bar chart can easily compare data for each variable.
04:35Each moment and time.
04:37In a particular time,
04:39What are our data?
04:41That is what our conditions are.
04:45Higher the bar, higher the values there.
04:48For example, a bar chart could compare your company sales from this year to last year.
04:52If we compare company sales from this year to last year,
04:56If you compare with the more sales from this year,
04:57If you compare them to this year to this year,
05:00we compare everything.
05:03What do we do for how to compare them to these different categories?
05:05When comparing multiple categories as necessary,
05:09When showing how a big volume of data changes over time,
05:11So, when we compare some categories, we compare some categories, or product, or segments, then we can do that.
05:29Or, years wise, we can see how our sales are going, what's going on in which year.
05:36So, we can present a very good picture to you.
05:43Next is Stack Bar Chart.
05:46Now we have talked about Bar Chart.
05:50Stack Bar Chart means that we can see two or three things together.
05:55We have a category.
05:58So, of friends, we can talk about Stack Bar Chart.
06:02Now we have Stack Bar Chart.
06:04This is also a Bar Chart.
06:06We have a difference here.
06:08We have to give it a lot more.
06:10We have to give it a category.
06:12We have to give it a category.
06:14So, that is basically our Stack Bar Chart.
06:18Now, we have to make sure that the Stack Bar Chart is a Modified Bar Chart.
06:24With each bar divided into smaller bars.
06:26So, what can we say?
06:28What is this?
06:29What is this?
06:30This is a Modified Bar Chart.
06:31We have made a Bar Chart.
06:33There are single things.
06:35There are multiple things.
06:37So, we have a category.
06:39We have to take a category.
06:41We have to take a sub-category.
06:43We have to take a furniture category.
06:45We have to take a chair.
06:47We have to take a table.
06:49We have to take a sub-category.
06:51We have to divide and show you.
06:52So, what do we do?
06:53We have to take a stack bar chart.
06:55We have to take a category.
06:57We have to take a more part.
06:58Like we have to take a state and a state.
07:00So, that is basically a Bar Chart.
07:02So, Stack Bar Chart.
07:04So, Bar Chart is a single category.
07:06We have to take a sub-category.
07:08So, we can see that you can use Stack Bar Chart.
07:11Next, why do we use Stack Bar Chart?
07:14Stack Bar Chart is also known as Stack Graph.
07:17It is a graph that is used to break down and compare
07:20parts of a whole.
07:22If a category is a whole,
07:24then it can also compare parts.
07:26So, the sub-category is the best category.
07:29Which sub-category is doing the best business?
07:32Which area we are getting the more sales?
07:36If a particular state itself is the best city.
07:40That is the way we can use Stack Bar Chart.
07:43Next, we have to ask.
07:44Stack Bar Chart is used for comparing multiple categories and sub-categories
07:48and for seeing how sub-category can contribute to the total.
07:51This means that the total is the total.
07:54So, the sub-category is the best contribution to the total.
07:57So, where do we check the contribution to the total?
08:00Next, we have to check the dual axis chart.
08:03In the dual axis chart.
08:04In the dual axis chart, we have to see where the bar is.
08:06And in the other hand, we have to see where the graph is.
08:10In the dual axis chart also known as combination of chart and combination of combo chart
08:19are a type of visualizing that combines two different charts in single graph.
08:23What do we do?
08:25The graph is that you compare this to a single graph.
08:27We see the graph,
08:28and the axis is,
08:32we're connecting one side.
08:33What do we do?
08:35For the sales and the profits?
08:36We have to see that we're doing the same thing.
08:38Okay, so what are the numbers which we're doing?
08:40By the numbers we're doing the same thing.
08:42We're doing the numbers.
08:43Profit will be the percentage,
08:44and we're doing the same thing.
08:45What do we use for a line?
08:48It's about to see in a line.
08:49This is the use of your Dwell Axis Chart
09:04Next we will talk about Column Chart
09:08Column Chart
09:10We will talk about Column Chart
09:18What do you think?
09:25Column Chart is a very similar style to Bar Chart
09:31You can think of this type of chart as Bar Chart in Groups
09:35What we are explaining to you
09:38What we are thinking about
09:39What we are explaining to you
09:41This belief is that the Bar Chart is a Group
09:44If we are making a Year group
09:47So if you can compare them to 2010 or 2012, you can compare them in the category.
09:54Or you can compare them to your categories and sub-categories.
09:59The difference is that your stack bar chart shows as a one, but it shows as a one.
10:06We compare them to the height and length.
10:12Each group contains color coded bar for each category or item.
10:16Each category makes an appearance for each data point.
10:19Columns for each data point are separated using spacing.
10:22And the same group is in the same way.
10:25The spacing is in the same way.
10:27The gap is also in which group is in the same way.
10:30If you can compare them to USA, Britain, China, Russia,
10:34then the group is in 2018 and 2017.
10:37And the group is in the same way.
10:40The same thing is in the middle of Delhi.
10:42That is basically your column chart.
10:45When should I use a column chart?
10:48You should use column chart.
10:50When a side-by-side comparison of different numbers is needed.
10:54You should compare them to each number.
10:58When highlighting the difference between values.
11:01You should see differences in between between.
11:03When you prefer to focus attention to the total rather than the trends.
11:08the trends. Trends
11:09You can see the total
11:11and see what is the total.
11:14So what can we do?
11:16You can use the column chart.
11:18Next is the pie chart.
11:20Pie chart means that it is a circle.
11:23In the circle, we have some slices
11:25in the form of data.
11:28The pie chart is a circular graph
11:32that uses pie slices to display
11:34relative size of data.
11:36If we use a complete 100,
11:40if the pie is 100,
11:42then the percentage of the pie is 100.
11:44The pie chart is a preferred choice
11:46for visualizing percentage
11:48because it shows each element
11:50as a part of a whole.
11:52If the pie is 100,
11:54the pie is 100,
11:56then the slices are
12:00the percentage of the pie
12:02which is the percentage of the pie
12:04which is the source of the pie chart.
12:10If you want to represent the share that each value has of the whole,
12:24if you want to show how a group is broke down into smaller pieces,
12:32if you want to represent a group in smaller pieces,
12:34then how do you want to break down?
12:38If you want to use the pie chart,
12:42you can use the pie chart.
12:44If you have a grouping of 5, 4, 5,
12:48if you want to use the pie chart,
12:50it will be unorganized.
12:52If you want to compare the pie chart,
12:58then you can use the pie chart.
13:00Next is the scatter plot chart.
13:02What is the scatter plot chart?
13:04Basically, you can compare the two variables.
13:08Variables are two data points.
13:10You can compare the two parties.
13:12X and Y.
13:14Now let's look at this line.
13:18This scatter plot chart is a scatter plot.
13:20It's a scatter plot.
13:22It's a scatter plot.
13:24It's a scatter plot.
13:26If you have two or more variables,
13:28and want to discover the relation between them,
13:30a scatter plot can be a solid choice.
13:32If you have two data points,
13:34and you have some comparison or relation,
13:38then you can choose a scatter plot.
13:40This case,
13:42which is scatter plot?
13:44When you have two different variables,
13:46they are located on X and Y.
13:48This is the X and Y variables.
13:50What do you want to see?
13:52This is a relation.
13:54When in view to observe,
13:56show relation between two numerical variables.
14:00Two numerical variables.
14:02For example,
14:03price and size.
14:05So,
14:06if you have two numerical,
14:07price and size
14:08can be a relation.
14:09If you have a size,
14:10then price can be a size.
14:11If you have a size,
14:12then price can be a size.
14:13If you have a size,
14:14then price can be a size.
14:15If you have a correlation between
14:16two large data sets,
14:17without regard to time.
14:18Now,
14:19time is not constrained.
14:20What is the main?
14:21What is the main value?
14:22There is two values.
14:23We compare them together.
14:25The size,
14:26What is the price ?
14:28It together will compare them.
14:30On the first times,
14:32changing the 20s when we have time left.
14:34And counting the 20s when we have time left.
14:35Now,
14:36we compare the parts to our squareDER.
14:41Areas,
14:42there is the learnings for the area
14:42YanguilØąØ¨.
14:44Actually,
14:44you see kind of line.
14:46Which is you do not with the line?
14:47Turn it into them directly.
14:49That's whatåŗ of myself,
14:51If you need to present data that depicted time-series relation and area chart is a great option.
15:01It is similar to line-chart, area-chart is a type of chart that represents the change in one or more quantities over time.
15:24This is a line-graph.
15:34This is a line-graph.
15:38When you use an area chart, when you want to use multiple lines to make a comparison between groups,
15:44when you want to track not only the whole value but also want to understand a breakdown of total by groups.
15:51If you want to see total, you want to see the group.
15:54In this case, what can we do with line-chart?
15:56What can we do with profit and sales?
15:59If you want to see sales, profit is enough.
16:02Friends, we are talking about bubble-chart.
16:06Why do we use data visualization and how do we use it?
16:11What do we use?
16:16What do we do with bubble-chart?
16:19It is round-bubbles, round-circles, which look like a bubble-chart.
16:24A bubble-chart is like a simple, special kind of graph that uses bubbles of different sizes to show three things at once.
16:31You can make three things.
16:34If you can make three also, then you can also make four.
16:36This is where you want to make four.
16:39Generally, this should be more than two.
16:41If you can make four in the middle, then it will be useful.
16:43Now you can see categories like the group of things you are looking at
16:52Sub-categories, these are smaller groups
16:55Instead each category
16:58In this case, the sub-group is a bubble size
17:03The size is a size
17:04This is a totality
17:06The size of the group is compared to the group
17:16Why do we make this?
17:18This is handy
17:20Because it lets you see a lot of information all at once in a simple picture
17:24You can compare different categories and sub-categories easily
17:36Because the bigger bubbles stand out more
17:38The bigger bubbles stand out more
17:40This is why we make a bubble chart
17:42Next time let's talk about your tree map
17:48What is the tree map?
17:50What is the tree map?
17:52It will show you something like this
17:54In a large size, small size
17:56In a bar, in a rectangular box
18:00In a square form
18:02In your square form
18:04In your bubbles
18:06In your boxes
18:08In your small or small
18:10Why do we make this tree map?
18:12A tree map is a type of data visualizing technique that is used to display hierarchical structures and used nested rectangles
18:20So just to see how big it is
18:21In a small size
18:22How big it is
18:23You can see the group or subgroup
18:24To see data
18:28With that tree map
18:30In a small size
18:31In a small shape
18:32If you know this
18:33So you know where it is
18:34With that
18:35What is the large size
18:36Is it
18:37You can see the large size
18:38That is the large size
18:39And the large size
18:40This is the case of urban, rural and natural, which are three categories of urban, rural, mixed, youth, sorry, mixed and youth, which are four categories of subcategories.
18:53In this case, the subcategories are also shown.
18:56So, what can we do with data? Compare.
19:00This is the comparison of the form and the subcategories.
19:05When do you use premap?
19:13When you want to illustrate a hierarchical and comparative value between categories and subcategories.
19:19This is a hierarchical and comparative value between categories and subcategories.
19:25This chart type is ideal for showing the stages of problems.
19:31When you want to illustrate a hierarchical and comparative value between categories and subcategories.
19:35Categories and subcategories have been comparison.
19:38Next is the funnel chart.
19:41This is the funnel chart.
19:42This is the funnel chart.
19:43This is the funnel chart.
19:44This is the funnel chart.
19:45This chart type is ideal for showing the stages of processing parts.
19:56Stacked on top of each other and visually enhancing them with colors.
20:02So, you know, the processes will produce according to reaching out to the leads.
20:19You also add synthetic points to them.
20:21So, it becomes true.
20:27So that is basically a funnel.
20:30So that is basically a funnel.
20:31So this is a funnel.
20:33We are looking at this case.
20:35100% visited the website.
20:37We have 75% downloaded a trial.
20:41We have some trial,
20:4356 contacts, support contacts,
20:45subscribe,
20:47and then 18% have renewed.
20:49So this is how we can make a funnel.
20:51We can recognize a whole process.
20:53We can make a process.
20:55We can make a process.
20:57So we can recognize that process.
20:59If we can make a process,
21:01we can make a process.
21:03We can make a process in a funnel.
21:05Now, when do you use a funnel?
21:09When you need to represent stages in sales
21:11or other business processes?
21:13If we want to show the amount of revenue for these stages.
21:17And show the amount of revenue for these stages.
21:19And show the amount of revenue for these stages.
21:21And in every stage,
21:23the amount of revenue for these stages.
21:25Now, friends,
21:27we are learning about heat map.
21:29What is heat map?
21:31Heat map and heat map.
21:35It is a graphical representative data
21:37where values are depicted by color.
21:39The values are depicted by color.
21:41The values are depicted by color.
21:43The values are depicted by color.
21:45And when it is Palate like color,
21:47it is aīŋŊīŋŊous color.
21:49The values are represented between color.
21:51It is with colors.
21:53It is compared at all two things.
21:55This is compared to students and subjects.
21:57So we are learning about the students and subjects.
21:59It is like,
22:00In Maths we have a lower marks,
22:02as compared to English,
22:04like we have a higher marks.
22:06So we can compare data explosion, pattern recognition, correlation, analysis, risk, assessment and portfolio analysis.
22:14So what can we do with pattern recognition, correlation, risk assessment, portfolio analysis.
22:26So that thing will be done with the help of this chart.
22:31So what can we do with this chart?
22:36Next is your area map.
22:39You can see the area map.
22:41This is basically our map.
22:45It is a map that visualize location data.
22:50They allow you to see immediately which geographical location are most important to your brand and business.
22:57So we can use our area map.
23:01We can use our area map.
23:03This way we can use our area map.
23:06So what can we do with the waterfall chart?
23:07What can we do with the waterfall chart?
23:08We can see that here in the area map.
23:09We can use our area map.
23:10So basically, higher the sales, higher the bubbles, higher the profits,
23:13or higher the profits.
23:14Or the above which we can see a particular particular category of our map.
23:19Then we can use our area map.
23:21So how can we use our area map?
23:23We can use our area map.
23:24Next, is your area map.
23:25Waterfall chart.
23:26What is waterfall chart?
23:27Next is Waterfall Chart
23:31What is the waterfall chart?
23:33You can see that there are some greens and some reds
23:38So basically, what is this?
23:40In this example, there are some inventories
23:43When inventories are increasing, it is the opening inventory, it is the closing inventory
23:49When this inventory is increasing, it will store green
23:52and when it is less inventory, it will store reds
23:57So, a waterfall chart is a specific type of bar chart that reveals the story behind the net change in something value between two points
24:05In two points, if we go to monthly, like this case, monthly inventory is showing a position
24:14Which month is the inventory, which month is the inventory, which month is the inventory, which month is the inventory
24:19This is comparing it to this
24:21When our inventory increase or when our inventory decrease
24:26If it is 100, then it will be 100, then it will be 100, then it will be 100
24:30Something like this
24:31Here is a chart
24:32Here is a chart
24:34So, you will get to know when it is growing and when it is growing
24:36So, this way, we can use our waterfall chart
24:40Now, this type of chart is useful for understanding the progression of numbers
24:46So, this type of chart is useful for understanding the progression of numbers
24:48How is the progression?
24:49How is the progression?
24:50How is it growing or growing?
24:51How can it increase in any field?
24:52How can it be in any field?
24:53Sales, profit, inventory, what ever type of data or values are there
24:57Where we can use it, but that need to be progressive
25:00So, progressive numbers, we can use it in progressive numbers
25:02Now friends, we are going to understand your radar charts
25:06So, what is radar charts?
25:07What is radar charts?
25:08You see, what are the areas of your values of comparison?
25:20Now, when you see radar charts are also called a spider web
25:24and a polar bar
25:27One is a popular data visualization technique
25:32This is multivariate data
25:34It can compare several items with many matrix of characteristics to be effective and clear the radar chart
25:41What do you do in comparison with this?
25:45We have created a 3 student
25:49What do you do in terms of 3?
25:51What do you do in terms of the chart?
25:53What do you do in terms of the chart?
25:56What do you do in terms of the chart?
26:01Basically, if you want to compare 2 to 6
26:10I have to judge the chart
26:12What do you do in terms of the chart?
26:14What do you do in terms of the chart?
26:16What do you do in terms of the chart?
26:18What do you do in terms of the chart?
26:21Next is Gantt chart
26:25Gantt chart is a progressive chart
26:29How do you do in terms of the chart?
26:32We have seen some of the chart
26:35We have seen some of the chart
26:38How do you do in terms of the chart?
26:40As we have seen some of the chart
26:43We have seen some of the chart
26:45Gantt chart is a project management tool
26:48that illustrates work completed over a period of time
26:51in relation to the time plan for the work
26:54So the plan of the chart is how we do in terms of the chart
26:56How do we do in terms of the chart?
26:57What do we do in terms of the chart?
26:58Then we have seen some of the chart
27:00Basically, we will compare progress to the chart
27:03What progress we have done so far in the project
27:06So what do we do in terms of the chart?
27:08so again chart is bar chart that shows a project schedule and help project manager monitor progress
27:15so what can you do if you can check your project manager
27:19in this case we can use can chart
27:22now friends we can understand your box plot charts
27:26box plot charts are what are they
27:28the box plot is a graph that is used to represent the distribution of numerical data using boxes and lines
27:38lines and boxes we can check the distribution of data
27:42we have three data sets
27:44we can check the data in which way we can check the box plot
27:52how do we check the box plot
27:54we have some values
27:58maximum values are up and minimum values are down
28:02the rest of our data is divided in the quartile
28:06so the third quartile is 25%
28:0975% is the worst quartile
28:11so this way we divide the data
28:15and we can see the data set distributed
28:18maximum value
28:20or outliner
28:22outliner
28:24common data
28:25average data
28:26we have different data
28:27like our value
28:285
28:2910
28:30that is outliner
28:32one
28:33so we can check the data
28:35which is the box plot
28:36for us
28:38that is basically
28:39the outliner
28:40so on this way
28:41we can check the data
28:42spread
28:43which is the data
28:44which is which is the data
28:46so we check the box plot
28:47its coming from the box plot
28:48max
28:51Next is gauze chart.
28:53In gauze chart, this is a clock chart.
28:57Basically, this is our target to achieve.
29:03Gauze chart is also known as dial chart.
29:05It is a speedometer chart used with needles to show information and reading on a dial.
29:09Just like we have a dial in information, this is how it works.
29:14Basically, gauze chart is used to display progressive towards a specific goal or target.
29:20Value such as sales target, campaign objective and customer satisfaction goal.
29:24The main objective is where we reach our goal.
29:29It can be used generally for sales.
29:32Your campaign, your objective, customer satisfaction.
29:38We want to reach our target.
29:41We want to check our target.
29:44We want to make this gauze chart.
29:47Next is progress chart.
29:50Progress chart will show how much progress has been made towards a goal.
30:04If this is our total goal, this is basically a gauze chart.
30:09The representation is a change in which we have achieved and how much more we have achieved.
30:15This can be used as progress chart.
30:19Next is histogram.
30:22Histogram is basically a frequency of data.
30:26We want to make histogram.
30:30The histogram is used in one data set.
30:35You can find the data in the only column.
30:36You can see the range of numbers which are the same number.
30:40We want to make histograms.
30:41The maximum number is zero, with all the numbers.
30:45The same number is equal to 80.
30:47It will be less than 80.
30:49If you have a number of numbers, the number of numbers is minus and plus.
30:55The number of numbers is zero.
30:59The frequency of data is check.
31:01Most of our data is 80.
31:03These are zero from zero.
31:07Some are minus or decimal.
31:11Some are plus.
31:13What is the frequency of data?
31:15It displays the shape as well as the spread of continuous data sample.
31:21Next.
31:23We will talk about Population Pyramid Chart.
31:25What is Population Pyramid Chart?
31:27It compares two age groups in two groups.
31:31If we compare the male and female age group,
31:35we compare the data.
31:37We compare the data to the male and female.
31:39We compare the data to the male and female.
31:41What is Population Pyramid Chart?
31:45We use Population Pyramid Chart.
31:47Displaying and Distribution and Age Group in Population.
31:49What is Population age group distributed?
31:53We use Population Pyramid Chart.
31:55What is Population Pyramid Chart?
31:57What is the main objective?
31:59It shows data as a whole and divides.
32:03If we compare the male and female,
32:05the male and female,
32:07the male and female,
32:09the male
32:36This is a chart where we have a frequency of data and also have other proof
32:43You can compare, cumulative total is represented by line
32:47And the total is shown by line
32:50So this chart is your Pareto chart
32:55Thank you very much and you can subscribe to this channel
Be the first to comment