title
Tableau Training for Beginners Part 2 | Tableau Tutorial for Beginners Part 2 | Edureka

description
***** Tableau Certification Training : https://www.edureka.co/tableau-certification-training ***** This Edureka Tableau Tutorial video (Tableau Tutorial Blog: https://goo.gl/DaqKvp) will help you learn data visualization techniques and tableau dashboards. This Tableau training video is ideal for beginners to learn the various visualizations, tableau dashbaord with examples. Check our complete Tableau playlist here: https://goo.gl/NTpehs This Edureka Tableau Tutorial provides knowledge on how to create various types of graphs in Tableau such as Tableau Dashboard. This Tableau tutorial also gives multiple sample use cases using various data sets to create Scatter Plots, Histograms, Bar Graphs, Box Plots, Pie Chart and Line Graphs. Subscribe to our channel to get video updates. Hit the subscribe button above. #Tableau #TableauDemo #TableauDashboard #TableauTraining #TableauTutorial #TableauCertification How it Works? This is a 5 Week Instructor led Online Course, 25 hours of assignment and 20 hours of project work We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. At the end of the training you will be working on a real time project for which we will provide you a Grade and a Verifiable Certificate! - - - - - - - - - - - - - - - - - About the Course Edureka's Tableau Certification training is designed to help you become a top Tableau Professional. During this course, our expert Tableau instructors will help you: Understand the need for visualization Make advance insightful visuals Perform scripting Create comprehensive dashboards Connect with multiple sources Integrate Tableau with R - - - - - - - - - - - - - - - - - - - Who should go for this course? The following professionals can go for this course : Data Scientists Business Analysts Statisticians and Analysts Project Managers - - - - - - - - - - - - - - - - Why learn Tableau? Tableau is a leader in Gartner's magic quadrant in BI & Data analytic field. Being used in various leading domains like Business Intelligence, Marketing, Big Data Hadoop, etc., Tableau is one skill set most professional wish to carry ahead in their career . As per Indeed.com, the mean salary of Tableau professional is $ 100,000.

detail
{'title': 'Tableau Training for Beginners Part 2 | Tableau Tutorial for Beginners Part 2 | Edureka', 'heatmap': [{'end': 1456.329, 'start': 1357.319, 'weight': 0.724}, {'end': 2426.98, 'start': 2324.006, 'weight': 1}, {'end': 4566.208, 'start': 4461.942, 'weight': 0.735}], 'summary': 'This tableau tutorial covers data visualization, scatter plot analysis, histogram and bar graph creation, car price visualization, box plot interpretation, data representation using pie charts, line chart creation, and gender birth rate analysis, providing practical guidance and insights for effective data analysis.', 'chapters': [{'end': 922.788, 'segs': [{'end': 92.615, 'src': 'embed', 'start': 68.023, 'weight': 0, 'content': [{'end': 80.688, 'text': "We learned some job trends about Tableau and we saw that Tableau is sort of The demand for Tableau is getting higher and higher and it's leading the path when it comes to different BI tools.", 'start': 68.023, 'duration': 12.665}, {'end': 84.851, 'text': "So it's one of the leaders when it comes to career opportunities and industry adoption.", 'start': 80.708, 'duration': 4.143}, {'end': 92.615, 'text': 'Then we had an introduction of Tableau and we compared different products which are available from this company.', 'start': 85.691, 'duration': 6.924}], 'summary': "Tableau's demand is rising, leading in bi tools and career opportunities.", 'duration': 24.592, 'max_score': 68.023, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc68023.jpg'}, {'end': 235.236, 'src': 'embed', 'start': 209.094, 'weight': 1, 'content': [{'end': 214.598, 'text': 'relationship and data which is otherwise very difficult to find just by looking at tabular data or raw data.', 'start': 209.094, 'duration': 5.504}, {'end': 220.282, 'text': 'So if we chart that data, if we create graphs from the data, the trends, patterns,', 'start': 215.038, 'duration': 5.244}, {'end': 227.807, 'text': 'relationship and data gets highlighted and it gets easier for us to find insight from the huge volume of data.', 'start': 220.282, 'duration': 7.525}, {'end': 235.236, 'text': 'Specially useful and helpful if we are dealing with extremely large amount of data or a complex data set.', 'start': 229.008, 'duration': 6.228}], 'summary': 'Data visualization reveals insights in complex, large datasets.', 'duration': 26.142, 'max_score': 209.094, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc209094.jpg'}, {'end': 332.973, 'src': 'embed', 'start': 303.594, 'weight': 2, 'content': [{'end': 316.339, 'text': 'So talking from a perspective of categorizing any kind of data, there are three broad categories in which you can put data into.', 'start': 303.594, 'duration': 12.745}, {'end': 318.408, 'text': "So let's say you have a column of data.", 'start': 316.687, 'duration': 1.721}, {'end': 321.809, 'text': "Let's say you're working on a data set and it has 10 different columns.", 'start': 318.628, 'duration': 3.181}, {'end': 326.551, 'text': 'So each of the column of data may fall under three different categories.', 'start': 322.389, 'duration': 4.162}, {'end': 332.973, 'text': 'Nominal, ordinal, and ratio.', 'start': 327.391, 'duration': 5.582}], 'summary': 'Data can be categorized into three broad categories: nominal, ordinal, and ratio.', 'duration': 29.379, 'max_score': 303.594, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc303594.jpg'}, {'end': 612.304, 'src': 'embed', 'start': 583.767, 'weight': 4, 'content': [{'end': 586.709, 'text': 'So this is nominal, ordinal, and ratio data.', 'start': 583.767, 'duration': 2.942}, {'end': 588.27, 'text': 'I hope you understood that.', 'start': 587.249, 'duration': 1.021}, {'end': 590.652, 'text': 'Now could you please ping me your answer.', 'start': 588.73, 'duration': 1.922}, {'end': 595.856, 'text': "I'm going to present to you certain column names, some data.", 'start': 590.672, 'duration': 5.184}, {'end': 599.779, 'text': 'Could you categorize them as nominal, ordinal or ratio?', 'start': 596.616, 'duration': 3.163}, {'end': 607.26, 'text': "Just ping me if the data which I'm going to present to you is that nominal, ordinal or ratio.", 'start': 600.459, 'duration': 6.801}, {'end': 612.304, 'text': 'Students in a classroom, they have been ranked.', 'start': 607.881, 'duration': 4.423}], 'summary': 'Categorize data as nominal, ordinal, or ratio.', 'duration': 28.537, 'max_score': 583.767, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc583767.jpg'}, {'end': 773.441, 'src': 'embed', 'start': 741.395, 'weight': 3, 'content': [{'end': 747.317, 'text': "If you want to investigate if there's a relationship between two set of data, then we use scatterplot.", 'start': 741.395, 'duration': 5.922}, {'end': 753.745, 'text': 'But what are these two sets of data we are talking about? These two set of data are ratio data.', 'start': 747.637, 'duration': 6.108}, {'end': 760.951, 'text': "If we have two ratio columns and we want to investigate the relationship between them, if there's a relationship between them or not,", 'start': 753.765, 'duration': 7.186}, {'end': 762.632, 'text': 'then we create a scatter plot.', 'start': 760.951, 'duration': 1.681}, {'end': 764.674, 'text': "Let's consider this example.", 'start': 763.353, 'duration': 1.321}, {'end': 773.441, 'text': "So there is an ice cream seller and he's selling ice cream and he has a feeling that, based on temperature on a given day,", 'start': 765.294, 'duration': 8.147}], 'summary': 'Use scatterplot to investigate relationship between two ratio data sets.', 'duration': 32.046, 'max_score': 741.395, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc741395.jpg'}], 'start': 0.37, 'title': 'Data visualization and understanding data types', 'summary': 'Covers data visualization using tableau, including basic design, business intelligence tools, visual analytics, and categorization of nominal, ordinal, and ratio data, with an emphasis on scatterplot visualization.', 'chapters': [{'end': 55.578, 'start': 0.37, 'title': 'Data visualization with tableau', 'summary': "Introduces the second session on data visualization using tableau, focusing on basic visualization design and recapping the previous session's learnings.", 'duration': 55.208, 'highlights': ["The session introduces the second session on data visualization using Tableau, emphasizing basic visualization design and recapping the previous session's learnings.", 'The instructor requests confirmation from the audience regarding the visibility of the shared screen and audio clarity.', 'The discussion will cover basic visualization design and the concepts behind creating specific visualizations.', 'The instructor mentions addressing a question from Shilpa during the session.', "The chapter emphasizes the importance of recapping the previous session's learnings before delving into the current discussion."]}, {'end': 582.486, 'start': 55.859, 'title': 'Tableau: bi tools and visual analytics', 'summary': 'Covers the importance of tableau in the business intelligence domain, its job trends, product comparison, and the introduction of visual analytics. it also discusses the benefits of visual analytics, different types of data categorization, and the use of scatterplot for data visualization.', 'duration': 526.627, 'highlights': ["Tableau's demand is increasing, leading in career opportunities and industry adoption. The demand for Tableau is getting higher and higher, making it a leading BI tool in terms of career opportunities and industry adoption.", 'Introduction of Tableau products: Tableau Desktop, Tableau Server, and Tableau Public. Tableau offers paid products like Tableau Desktop and Tableau Server, along with a free learning tool, Tableau Public, and a sharing tool, Tableau Reader.', 'Visual analytics helps in identifying trends, patterns, and relationships in complex and large datasets. Visual analytics aids in identifying trends, patterns, and relationships in complex and large datasets, especially useful for big data analysis and data mining.', 'Explanation of different types of data categorization: nominal, ordinal, and ratio. The chapter explains the categorization of data into nominal, ordinal, and ratio types, providing examples and characteristics of each type.', 'Introduction to scatterplot and its relevance in visual analytics for data visualization. The chapter introduces scatterplot and its relevance in visual analytics for data visualization, providing an understanding of different types of data categorization.']}, {'end': 922.788, 'start': 583.767, 'title': 'Understanding nominal, ordinal, and ratio data', 'summary': 'Discusses the differences between nominal, ordinal, and ratio data, and how to categorize data types based on specific examples, such as student ranks, department names, and sales data, while emphasizing the use of scatterplots to visualize relationships between ratio data sets.', 'duration': 339.021, 'highlights': ['Scatterplot is used to visualize the relationship between two ratio data sets, and it is employed when investigating the correlation between these data types. Scatterplot is utilized when exploring the relationship between two ratio data sets, such as temperature and ice cream sales, to determine the correlation and visualize the impact.', 'The examples provided demonstrate the distinction between nominal, ordinal, and ratio data, including student ranks, department names, and sales data. Clear examples are presented to illustrate the differences between nominal, ordinal, and ratio data, including student ranks, department names, and sales data.', 'The positive relationship between temperature and ice cream sales is showcased as a key concept, demonstrating the impact of temperature on sales through a scatter plot. The positive correlation between temperature and ice cream sales is highlighted, showcasing the influence of temperature on sales through a visual representation using a scatter plot.']}], 'duration': 922.418, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc370.jpg', 'highlights': ["Tableau's demand is increasing, leading in career opportunities and industry adoption.", 'Visual analytics aids in identifying trends, patterns, and relationships in complex and large datasets.', 'The chapter explains the categorization of data into nominal, ordinal, and ratio types, providing examples and characteristics of each type.', 'Scatterplot is utilized when exploring the relationship between two ratio data sets, such as temperature and ice cream sales, to determine the correlation and visualize the impact.', 'Clear examples are presented to illustrate the differences between nominal, ordinal, and ratio data, including student ranks, department names, and sales data.']}, {'end': 1828.305, 'segs': [{'end': 1001.254, 'src': 'embed', 'start': 927.009, 'weight': 0, 'content': [{'end': 929.63, 'text': 'This file contains data for different cars.', 'start': 927.009, 'duration': 2.621}, {'end': 932.611, 'text': 'So this is our first car.', 'start': 930.71, 'duration': 1.901}, {'end': 940.173, 'text': 'The make is Alfa Romeo, some of the cars are Audi, some of the cars have been BMW, Chevrolet.', 'start': 933.591, 'duration': 6.582}, {'end': 943.614, 'text': 'What is the fuel type, what is the aspiration?', 'start': 940.773, 'duration': 2.841}, {'end': 945.154, 'text': 'how many doors the car has?', 'start': 943.614, 'duration': 1.54}, {'end': 946.295, 'text': 'what is the body style?', 'start': 945.154, 'duration': 1.141}, {'end': 950.867, 'text': 'and there are several other features of the car which we have recorded in this data set.', 'start': 946.295, 'duration': 4.572}, {'end': 955.528, 'text': 'How many cars we have this data for? We have this data for 195 different cars.', 'start': 951.067, 'duration': 4.461}, {'end': 965.33, 'text': "What we want to investigate is, let's say, if we have, if we want to buy a powerful car.", 'start': 957.268, 'duration': 8.062}, {'end': 966.83, 'text': 'I want to buy a powerful car.', 'start': 965.33, 'duration': 1.5}, {'end': 969.77, 'text': 'power of the car is determined by horsepower.', 'start': 966.83, 'duration': 2.94}, {'end': 974.171, 'text': 'So if the car is having more horsepower, it means the car is more powerful.', 'start': 970.491, 'duration': 3.68}, {'end': 976.652, 'text': 'It will be able to run at a higher speed.', 'start': 974.731, 'duration': 1.921}, {'end': 978.063, 'text': 'more pickup.', 'start': 977.543, 'duration': 0.52}, {'end': 986.067, 'text': "I'm no expert in automobile technicalities, but from a layman's perspective, that's what I'm telling.", 'start': 978.523, 'duration': 7.544}, {'end': 989.909, 'text': 'So more the horsepower, the more powerful the car is.', 'start': 986.467, 'duration': 3.442}, {'end': 997.032, 'text': "So you want to buy a powerful car, but you're also very cognizant, very careful about the pricing of the car.", 'start': 990.049, 'duration': 6.983}, {'end': 1001.254, 'text': 'So you have a feeling that horsepower influences the price.', 'start': 997.433, 'duration': 3.821}], 'summary': "Dataset contains 195 cars' data including make, features, and horsepower's influence on pricing.", 'duration': 74.245, 'max_score': 927.009, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc927009.jpg'}, {'end': 1057.833, 'src': 'embed', 'start': 1025.438, 'weight': 4, 'content': [{'end': 1030.482, 'text': 'Positive relationship is when both the variables move in the same direction.', 'start': 1025.438, 'duration': 5.044}, {'end': 1033.304, 'text': 'If one increases, the other also increases.', 'start': 1030.561, 'duration': 2.743}, {'end': 1036.843, 'text': 'If one decreases, the other also decreases.', 'start': 1034.541, 'duration': 2.302}, {'end': 1040.385, 'text': 'If that is happening, then we say there is a positive relationship.', 'start': 1036.923, 'duration': 3.462}, {'end': 1045.867, 'text': 'Negative relationship is when one variable increases, the other decreases.', 'start': 1042.126, 'duration': 3.741}, {'end': 1049.969, 'text': 'So let me show you this one here.', 'start': 1047.328, 'duration': 2.641}, {'end': 1051.29, 'text': "I'm sorry.", 'start': 1050.89, 'duration': 0.4}, {'end': 1057.833, 'text': 'This is a positive relationship.', 'start': 1055.812, 'duration': 2.021}], 'summary': 'Positive relationship is when both variables move in the same direction, resulting in increases or decreases together.', 'duration': 32.395, 'max_score': 1025.438, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1025438.jpg'}, {'end': 1364.501, 'src': 'embed', 'start': 1340.272, 'weight': 3, 'content': [{'end': 1346.534, 'text': "So you will probably connect to a database or, let's say, if you have access to a data mart,", 'start': 1340.272, 'duration': 6.262}, {'end': 1353.037, 'text': 'you can export the data in CSV format from any of the data marts or a database and then you can import that within Tableau.', 'start': 1346.534, 'duration': 6.503}, {'end': 1356.738, 'text': 'You can also make live connections, something which we are going to discuss later on.', 'start': 1353.057, 'duration': 3.681}, {'end': 1364.501, 'text': 'Does that make sense, Anand? Was I able to answer your question? So based on your role, you will provide access to the data.', 'start': 1357.319, 'duration': 7.182}], 'summary': 'Connect to database or data mart, import csv data into tableau, and provide data access based on role.', 'duration': 24.229, 'max_score': 1340.272, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1340272.jpg'}, {'end': 1460.67, 'src': 'heatmap', 'start': 1357.319, 'weight': 5, 'content': [{'end': 1364.501, 'text': 'Does that make sense, Anand? Was I able to answer your question? So based on your role, you will provide access to the data.', 'start': 1357.319, 'duration': 7.182}, {'end': 1375.766, 'text': 'So now we are on a work canvas and we are going to create a scatter plot which will show us the relationship between horsepower and price.', 'start': 1367.222, 'duration': 8.544}, {'end': 1378.508, 'text': 'So the steps are as follows.', 'start': 1376.307, 'duration': 2.201}, {'end': 1383.51, 'text': 'On a scatter plot, look at all the components we have.', 'start': 1379.849, 'duration': 3.661}, {'end': 1391.615, 'text': 'We have HP, we have price, so of course we need these two columns, but we have one circle for each car.', 'start': 1384.211, 'duration': 7.404}, {'end': 1393.936, 'text': 'See, we have so many different circles.', 'start': 1392.435, 'duration': 1.501}, {'end': 1400.992, 'text': "So we'd also need the car identifier, so these three things we are going to require.", 'start': 1394.356, 'duration': 6.636}, {'end': 1409.218, 'text': "So of course we need miles per gallon, I'm sorry, price and HP.", 'start': 1402.433, 'duration': 6.785}, {'end': 1412.46, 'text': "So let's take price, let's take HP.", 'start': 1409.558, 'duration': 2.902}, {'end': 1417.984, 'text': "If we consider only these two variables and we go ahead and create a scatter plot, let's say.", 'start': 1413.24, 'duration': 4.744}, {'end': 1422.367, 'text': "Let's say we create a scatter plot just by taking these two variables.", 'start': 1418.764, 'duration': 3.603}, {'end': 1425.349, 'text': 'Then we will get just one circle here.', 'start': 1422.907, 'duration': 2.442}, {'end': 1435.315, 'text': "Why?? Because Tableau is going to sum up the price for each of the car and sum up the horsepower, and eventually we'll have one sum of price,", 'start': 1426.269, 'duration': 9.046}, {'end': 1439.478, 'text': 'one sum of power, and wherever they are intersecting, Tableau is going to draw a circle there.', 'start': 1435.315, 'duration': 4.163}, {'end': 1441.239, 'text': 'This is not what we wanted.', 'start': 1439.978, 'duration': 1.261}, {'end': 1445.322, 'text': 'We wanted to investigate relationship between price and horsepower.', 'start': 1441.599, 'duration': 3.723}, {'end': 1449.605, 'text': 'So we need one circle for each of the car.', 'start': 1446.302, 'duration': 3.303}, {'end': 1452.887, 'text': 'So car is identified by the car ID.', 'start': 1450.025, 'duration': 2.862}, {'end': 1454.368, 'text': 'So drag car ID.', 'start': 1453.467, 'duration': 0.901}, {'end': 1456.329, 'text': 'throw it in the detail section.', 'start': 1455.049, 'duration': 1.28}, {'end': 1457.129, 'text': 'That is one way.', 'start': 1456.369, 'duration': 0.76}, {'end': 1460.67, 'text': 'There are several different ways of creating a scatter plot.', 'start': 1458.19, 'duration': 2.48}], 'summary': 'Create scatter plot to analyze relationship between price and horsepower using car id', 'duration': 103.351, 'max_score': 1357.319, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1357319.jpg'}, {'end': 1549.351, 'src': 'embed', 'start': 1519.313, 'weight': 6, 'content': [{'end': 1524.254, 'text': "Very, very small visualizations I'm going to create and then you have to replicate them in form of quizzes.", 'start': 1519.313, 'duration': 4.941}, {'end': 1527.155, 'text': 'Okay, so you have created the scatter plot, nice.', 'start': 1524.774, 'duration': 2.381}, {'end': 1538.977, 'text': 'Now, you see, the scatter plot which I have created, here, in this case, HP is lying on X axis and price is lying on Y axis.', 'start': 1527.615, 'duration': 11.362}, {'end': 1549.351, 'text': 'If you want to flip the axis, okay, If you want to achieve that effect, see here price is lying on X axis and horsepower is lying on Y axis.', 'start': 1540.137, 'duration': 9.214}], 'summary': 'Create small visualizations, replicate as quizzes. demonstrated scatter plot with hp and price axis.', 'duration': 30.038, 'max_score': 1519.313, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1519313.jpg'}, {'end': 1802.413, 'src': 'embed', 'start': 1766.582, 'weight': 7, 'content': [{'end': 1780.013, 'text': 'If I am planning to buy a car with power of more than 170 HP so 170 HP will be around here, somewhere around here which car should I choose?', 'start': 1766.582, 'duration': 13.431}, {'end': 1781.655, 'text': 'Which car should I ignore?', 'start': 1780.374, 'duration': 1.281}, {'end': 1788.04, 'text': 'Considering that I also give equal preference to pricing of the car, I do not want to go for an expensive car.', 'start': 1782.315, 'duration': 5.725}, {'end': 1802.413, 'text': "So I'd say I can go for this car, car ID 99, or I can go for this car, which is car ID 69, either of these cars.", 'start': 1792.924, 'duration': 9.489}], 'summary': 'Seeking car with over 170 hp, preferring lower cost. considering car id 99 or car id 69.', 'duration': 35.831, 'max_score': 1766.582, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1766582.jpg'}], 'start': 927.009, 'title': 'Car data analysis and scatter plot', 'summary': 'Discusses a dataset of 195 cars, focusing on investigating the impact of horsepower on car power and pricing. it also introduces scatter plot analysis, explaining relationships between variables and practical guidance on creating scatter plots in tableau for analyzing horsepower and price.', 'chapters': [{'end': 1001.254, 'start': 927.009, 'title': 'Car data analysis', 'summary': 'Discusses a dataset containing information for 195 different cars, focusing on investigating the impact of horsepower on car power and pricing.', 'duration': 74.245, 'highlights': ['The dataset includes information for 195 different cars, covering details such as make, fuel type, aspiration, doors, body style, and other features.', "Horsepower is considered as a determinant of a car's power, with higher horsepower indicating greater power and ability to run at higher speeds.", 'The chapter emphasizes the importance of considering horsepower in relation to car pricing, indicating a conscious awareness of its influence.']}, {'end': 1356.738, 'start': 1002.755, 'title': 'Scatter plot and relationship analysis', 'summary': 'Introduces scatter plot and explains the nature of relationship between variables, such as positive and negative relationships, using examples and practical guidance on importing data into tableau for analysis.', 'duration': 353.983, 'highlights': ['The nature of relationship between variables is explained, such as positive and negative relationships, using practical examples and guidance. (Relevance: 5)', 'The process of importing data into Tableau for analysis using a CSV file is detailed, including practical steps and troubleshooting guidance. (Relevance: 4)', 'The concept of positive relationship is illustrated with examples of horsepower and price, demonstrating that as horsepower increases, price also increases, indicating a positive relationship. (Relevance: 3)', 'The concept of negative relationship is illustrated with examples of horsepower and mileage, demonstrating that as horsepower increases, mileage decreases, indicating a negative relationship. (Relevance: 2)', 'Explanation is provided on real-time data access for Tableau-based projects, including obtaining data from databases or data marts and making live connections. (Relevance: 1)']}, {'end': 1828.305, 'start': 1357.319, 'title': 'Creating scatter plot in tableau', 'summary': 'Discusses the process of creating a scatter plot in tableau to analyze the relationship between horsepower and price, demonstrating multiple methods and explaining the significance of swapping axes, with a focus on identifying cars with over 170 hp and reasonable pricing.', 'duration': 470.986, 'highlights': ['The process of creating a scatter plot in Tableau to analyze the relationship between horsepower and price is explained, emphasizing the need for car ID, horsepower, and price as essential components. Emphasizes the essential components for creating a scatter plot in Tableau: car ID, horsepower, and price.', 'The significance of swapping the axes in a scatter plot is discussed, demonstrating the process and its impact on the visualization. Demonstrates the process of swapping axes in a scatter plot in Tableau and explains its significance in visualizing data.', 'Identifying cars with over 170 HP and reasonable pricing is demonstrated, with a focus on car ID 99 and car ID 69 as suitable options based on the given criteria. Identifies car ID 99 and car ID 69 as suitable options for cars with over 170 HP and reasonable pricing, explaining the decision-making process.']}], 'duration': 901.296, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc927009.jpg', 'highlights': ['The dataset includes information for 195 different cars, covering details such as make, fuel type, aspiration, doors, body style, and other features.', "Horsepower is considered as a determinant of a car's power, with higher horsepower indicating greater power and ability to run at higher speeds.", 'The chapter emphasizes the importance of considering horsepower in relation to car pricing, indicating a conscious awareness of its influence.', 'The process of importing data into Tableau for analysis using a CSV file is detailed, including practical steps and troubleshooting guidance.', 'The nature of relationship between variables is explained, such as positive and negative relationships, using practical examples and guidance.', 'The process of creating a scatter plot in Tableau to analyze the relationship between horsepower and price is explained, emphasizing the need for car ID, horsepower, and price as essential components.', 'The significance of swapping the axes in a scatter plot is discussed, demonstrating the process and its impact on the visualization.', 'Identifying cars with over 170 HP and reasonable pricing is demonstrated, with a focus on car ID 99 and car ID 69 as suitable options based on the given criteria.']}, {'end': 2527.303, 'segs': [{'end': 1859.581, 'src': 'embed', 'start': 1828.625, 'weight': 1, 'content': [{'end': 1838.27, 'text': 'They have very little advantage when it comes to increase in power, but the price is significantly higher.', 'start': 1828.625, 'duration': 9.645}, {'end': 1841.951, 'text': 'So these two cars can be a perfect choice for me.', 'start': 1839.23, 'duration': 2.721}, {'end': 1847.494, 'text': 'Okay, now could you try to answer the following quiz?', 'start': 1843.832, 'duration': 3.662}, {'end': 1853.157, 'text': 'Can you create a scatter plot which will show the relationship between mileage and horsepower?', 'start': 1847.734, 'duration': 5.423}, {'end': 1859.581, 'text': 'Same data set.', 'start': 1858.14, 'duration': 1.441}], 'summary': 'Two cars have little power advantage but higher price. request for scatter plot on mileage vs horsepower.', 'duration': 30.956, 'max_score': 1828.625, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1828625.jpg'}, {'end': 1977.441, 'src': 'embed', 'start': 1925.031, 'weight': 0, 'content': [{'end': 1930.732, 'text': "If you click on this dropdown on the toolbar, if you see it says standard, if you choose this one, entire view, let's say.", 'start': 1925.031, 'duration': 5.701}, {'end': 1935.053, 'text': 'So the chart will become bigger, entire view.', 'start': 1931.232, 'duration': 3.821}, {'end': 1940.514, 'text': 'If you choose to fit height or fit width, then accordingly, the chart will change.', 'start': 1935.513, 'duration': 5.001}, {'end': 1949.254, 'text': 'So, Anand, please try to create this scatterplot.', 'start': 1945.735, 'duration': 3.519}, {'end': 1951.415, 'text': "if it doesn't work, just let me know.", 'start': 1949.254, 'duration': 2.161}, {'end': 1953.196, 'text': 'I can help you out with that, okay?', 'start': 1951.415, 'duration': 1.781}, {'end': 1958.598, 'text': "So let's move on to the next category of chart in between and Anand,", 'start': 1954.957, 'duration': 3.641}, {'end': 1962.74, 'text': 'please feel free to stop me at any point of time if you need any help with the scatterplot.', 'start': 1958.598, 'duration': 4.142}, {'end': 1968.042, 'text': 'So moving on to the next category of visualization, we are going to discuss now about histogram.', 'start': 1963.32, 'duration': 4.722}, {'end': 1977.441, 'text': "Yeah Navin, I'm going to answer that question, but not today, maybe in one of our future sessions.", 'start': 1972.564, 'duration': 4.877}], 'summary': 'Tutorial on adjusting chart views and creating scatterplot, transitioning to discussing histograms.', 'duration': 52.41, 'max_score': 1925.031, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1925031.jpg'}, {'end': 2076.891, 'src': 'embed', 'start': 2038.767, 'weight': 4, 'content': [{'end': 2045.41, 'text': 'But you have your mouse and Tableau will tell you the name of a particular visualization, a histogram, box and whisker plot.', 'start': 2038.767, 'duration': 6.643}, {'end': 2056.235, 'text': 'So if you can just, you can look at the name of the chart right here, Gantt chart, bullet graph, line, film, area map, all these details.', 'start': 2046.831, 'duration': 9.404}, {'end': 2076.891, 'text': 'Is that what you were asking for? So Naveen, let me do this.', 'start': 2056.614, 'duration': 20.277}], 'summary': 'Tableau provides various visualizations like histogram, box and whisker plot, gantt chart, bullet graph, and more.', 'duration': 38.124, 'max_score': 2038.767, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2038767.jpg'}, {'end': 2135.464, 'src': 'embed', 'start': 2107.4, 'weight': 2, 'content': [{'end': 2110.963, 'text': 'And then you can go to design mode of that chart and you can figure out.', 'start': 2107.4, 'duration': 3.563}, {'end': 2114.145, 'text': "We'll talk about that when we are going to discuss about dashboard.", 'start': 2111.163, 'duration': 2.982}, {'end': 2116.247, 'text': 'So that will be in our third week.', 'start': 2114.566, 'duration': 1.681}, {'end': 2121.852, 'text': "So, in our third week we're gonna talk about dashboards, and that's when you can figure out.", 'start': 2116.868, 'duration': 4.984}, {'end': 2125.034, 'text': 'after learning about dashboards, you can figure out what chart has been used.', 'start': 2121.852, 'duration': 3.182}, {'end': 2132.12, 'text': 'Fair enough? Okay.', 'start': 2126.475, 'duration': 5.645}, {'end': 2135.464, 'text': "So let's learn about histogram.", 'start': 2133.723, 'duration': 1.741}], 'summary': 'The discussion will cover dashboards in the third week, including chart design and histogram learning.', 'duration': 28.064, 'max_score': 2107.4, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2107400.jpg'}, {'end': 2189.135, 'src': 'embed', 'start': 2161.54, 'weight': 5, 'content': [{'end': 2167.698, 'text': 'If you have a ratio data, we can use histogram to check its spread.', 'start': 2161.54, 'duration': 6.158}, {'end': 2171.04, 'text': 'So spread of data can be determined using histogram.', 'start': 2167.958, 'duration': 3.082}, {'end': 2178.223, 'text': 'So like, for example, height, weight, currency, salary, age, all these kind of values if you have.', 'start': 2171.4, 'duration': 6.823}, {'end': 2180.804, 'text': 'if you want to check their spread, we use a histogram.', 'start': 2178.223, 'duration': 2.581}, {'end': 2182.565, 'text': "So let's look into this example.", 'start': 2181.164, 'duration': 1.401}, {'end': 2189.135, 'text': 'Histogram is something which we have actually learned in our high school, and some of us might be using that also,', 'start': 2183.351, 'duration': 5.784}], 'summary': 'Histogram can determine spread of ratio data like height, weight, currency, salary, age.', 'duration': 27.595, 'max_score': 2161.54, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2161540.jpg'}, {'end': 2232.481, 'src': 'embed', 'start': 2201.224, 'weight': 6, 'content': [{'end': 2207.428, 'text': 'Probably newer version of Excel, there might be some easier way, but in Tableau, creating a histogram is very, very easy.', 'start': 2201.224, 'duration': 6.204}, {'end': 2211.591, 'text': "So what is actually a histogram? Let's consider this particular example.", 'start': 2207.769, 'duration': 3.822}, {'end': 2217.67, 'text': 'we have an orchard and we have different trees which we have grown in that orchard.', 'start': 2212.867, 'duration': 4.803}, {'end': 2223.094, 'text': 'We want to understand the height distribution of trees in that orchard.', 'start': 2218.031, 'duration': 5.063}, {'end': 2232.481, 'text': 'Do we have taller trees? Do we have shorter trees? Or do we have trees somewhere in between? Neither very tall nor very short in our orchard.', 'start': 2223.374, 'duration': 9.107}], 'summary': 'Creating a histogram in tableau is very easy and useful for understanding tree height distribution in an orchard.', 'duration': 31.257, 'max_score': 2201.224, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2201224.jpg'}, {'end': 2426.98, 'src': 'heatmap', 'start': 2324.006, 'weight': 1, 'content': [{'end': 2333.152, 'text': 'So we create this histogram and then we saw, we can see that We have very few cars which are extremely short in length and extremely long in length.', 'start': 2324.006, 'duration': 9.146}, {'end': 2336.214, 'text': 'Most of the cars are somewhere in between.', 'start': 2333.592, 'duration': 2.622}, {'end': 2339.857, 'text': 'So this is how histogram helps us.', 'start': 2336.234, 'duration': 3.623}, {'end': 2343.48, 'text': "So let's create this histogram.", 'start': 2341.759, 'duration': 1.721}, {'end': 2346.823, 'text': 'To create a histogram, very few steps are required actually.', 'start': 2343.84, 'duration': 2.983}, {'end': 2349.825, 'text': 'I want to look at length distribution of cars.', 'start': 2347.363, 'duration': 2.462}, {'end': 2363.239, 'text': "So I'm going to select length and then I will go to show me, and here is a choice to display the histogram.", 'start': 2351.967, 'duration': 11.272}, {'end': 2367.342, 'text': "So I'm just going to click here, histogram.", 'start': 2363.259, 'duration': 4.083}, {'end': 2371.224, 'text': 'And Tableau is going to draw this histogram on screen.', 'start': 2368.122, 'duration': 3.102}, {'end': 2376.708, 'text': 'So Tableau has automatically determined the bin size to be five.', 'start': 2371.865, 'duration': 4.843}, {'end': 2380.851, 'text': 'So number of cars between 140 to 145, number of cars between the length of 145 to 150, and so on so forth.', 'start': 2377.149, 'duration': 3.702}, {'end': 2393.483, 'text': 'okay?. Now, if we want to change that bin, here is our option.', 'start': 2380.851, 'duration': 12.632}, {'end': 2400.046, 'text': 'So when we create a histogram, Tableau is automatically going to create a new variable for us, which is a bin variable.', 'start': 2393.823, 'duration': 6.223}, {'end': 2402.707, 'text': 'So we can right click and edit this.', 'start': 2400.446, 'duration': 2.261}, {'end': 2407.089, 'text': "Please follow the screen which I'm sharing, otherwise you're going to miss out on how to edit the bin.", 'start': 2402.767, 'duration': 4.322}, {'end': 2412.292, 'text': 'So when we create a histogram, Tableau is automatically going to create a bin.', 'start': 2408.25, 'duration': 4.042}, {'end': 2416.813, 'text': 'So we can edit that bin size and make it more customized.', 'start': 2413.171, 'duration': 3.642}, {'end': 2420.395, 'text': "So let's say I want the bin size to be 10.", 'start': 2417.133, 'duration': 3.262}, {'end': 2424.218, 'text': 'So I enter that bin size and my histogram will change accordingly.', 'start': 2420.395, 'duration': 3.823}, {'end': 2426.98, 'text': 'So here is my new histogram.', 'start': 2424.638, 'duration': 2.342}], 'summary': 'Histogram shows car length distribution, most cars are in the middle, with tableau automatically determining the bin size to be five.', 'duration': 102.974, 'max_score': 2324.006, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2324006.jpg'}, {'end': 2438.146, 'src': 'embed', 'start': 2408.25, 'weight': 7, 'content': [{'end': 2412.292, 'text': 'So when we create a histogram, Tableau is automatically going to create a bin.', 'start': 2408.25, 'duration': 4.042}, {'end': 2416.813, 'text': 'So we can edit that bin size and make it more customized.', 'start': 2413.171, 'duration': 3.642}, {'end': 2420.395, 'text': "So let's say I want the bin size to be 10.", 'start': 2417.133, 'duration': 3.262}, {'end': 2424.218, 'text': 'So I enter that bin size and my histogram will change accordingly.', 'start': 2420.395, 'duration': 3.823}, {'end': 2426.98, 'text': 'So here is my new histogram.', 'start': 2424.638, 'duration': 2.342}, {'end': 2438.146, 'text': 'It shows that we have extremely few cars in the extremely long and extremely short category and most of the cars are lying somewhere in between.', 'start': 2429.141, 'duration': 9.005}], 'summary': 'Customize bin size in tableau histogram to visualize car distribution.', 'duration': 29.896, 'max_score': 2408.25, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2408250.jpg'}], 'start': 1828.625, 'title': 'Tableau visualization basics and understanding histograms', 'summary': 'Covers tableau visualization basics such as creating scatter plots and understanding chart categories, and explains histograms for analyzing continuous ratio data in tableau, with practical examples like tree height and car length distribution.', 'chapters': [{'end': 2132.12, 'start': 1828.625, 'title': 'Tableau visualization basics', 'summary': 'Covers the basics of tableau visualization, including creating scatter plots and understanding different chart categories, with a mention of future sessions on advanced visualization and dashboards.', 'duration': 303.495, 'highlights': ['The chapter covers the basics of Tableau visualization, including creating scatter plots and understanding different chart categories, with a mention of future sessions on advanced visualization and dashboards.', 'Scatter plot: Investigating the relationship between mileage and horsepower to determine the impact on mileage when buying a powerful car.', 'Understanding chart categories: Learning to identify different chart types through Tableau and a mention of advanced visualization in future sessions.', 'Zooming charts: Explaining the process of increasing the size of a chart in Tableau using different options like entire view, fit height, and fit width.', 'Identifying chart types: Using Tableau to hover over a chart to determine its category, with an indication of discussing the process in detail during the dashboard session.']}, {'end': 2527.303, 'start': 2133.723, 'title': 'Understanding histograms', 'summary': 'Explains histograms as a graphical display of data for understanding the distribution and spread of continuous ratio data, especially in tableau, with examples like tree height distribution and car length distribution.', 'duration': 393.58, 'highlights': ['Histograms are used to figure out the distribution of continuous ratio data, such as height, weight, currency, salary, and age. Histograms help in understanding the spread of continuous ratio data like height, weight, currency, salary, and age.', 'Creating histograms in Tableau is very easy, especially compared to older versions of Excel. Tableau makes it significantly easier to create histograms compared to older versions of Excel.', "The process of creating a histogram in Tableau involves selecting the variable, choosing 'histogram' in the 'show me' option, and customizing bin sizes for more specific analysis. Creating a histogram in Tableau involves selecting the variable, choosing 'histogram' in the 'show me' option, and customizing bin sizes for more specific analysis."]}], 'duration': 698.678, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc1828625.jpg', 'highlights': ['Creating scatter plots and understanding chart categories in Tableau, with future sessions on advanced visualization and dashboards.', 'Investigating the relationship between mileage and horsepower to determine the impact on mileage when buying a powerful car.', 'Learning to identify different chart types through Tableau and a mention of advanced visualization in future sessions.', 'Explaining the process of increasing the size of a chart in Tableau using different options like entire view, fit height, and fit width.', 'Using Tableau to hover over a chart to determine its category, with an indication of discussing the process in detail during the dashboard session.', 'Histograms are used to figure out the distribution of continuous ratio data, such as height, weight, currency, salary, and age.', 'Creating histograms in Tableau is very easy, especially compared to older versions of Excel.', "The process of creating a histogram in Tableau involves selecting the variable, choosing 'histogram' in the 'show me' option, and customizing bin sizes for more specific analysis."]}, {'end': 3394.483, 'segs': [{'end': 2569.957, 'src': 'embed', 'start': 2529.755, 'weight': 0, 'content': [{'end': 2537.038, 'text': 'So histogram does give us some insight of the data and helps us understand our data better.', 'start': 2529.755, 'duration': 7.283}, {'end': 2552.944, 'text': "So please try to create this histogram, edit the bin size as I've shown in the figure, and also try to show the labels on top of the bar.", 'start': 2543.32, 'duration': 9.624}, {'end': 2557.186, 'text': 'Okay, so Dinesh, here is the thing.', 'start': 2554.505, 'duration': 2.681}, {'end': 2569.957, 'text': 'The height of the bar is determined by, excuse me, is determined by count of cars.', 'start': 2559.232, 'duration': 10.725}], 'summary': 'Histogram provides insight into data, adjust bin size, show labels, bar height determined by car count.', 'duration': 40.202, 'max_score': 2529.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2529755.jpg'}, {'end': 2637.657, 'src': 'embed', 'start': 2608.212, 'weight': 1, 'content': [{'end': 2613.455, 'text': 'Whenever you are going to import any kind of data in Tableau, this field will be generated.', 'start': 2608.212, 'duration': 5.243}, {'end': 2617.477, 'text': 'Number of record will tell you how many rows we are talking about.', 'start': 2613.915, 'duration': 3.562}, {'end': 2625.553, 'text': 'Now, in this histogram, the center point, which has the maximum height, this has most number of records.', 'start': 2618.331, 'duration': 7.222}, {'end': 2627.954, 'text': 'Hence, a taller bar.', 'start': 2626.153, 'duration': 1.801}, {'end': 2631.395, 'text': 'If you take number of records and throw it in the color,', 'start': 2628.814, 'duration': 2.581}, {'end': 2637.657, 'text': 'you will see those bars which have relatively less number of cars falling into them are lighter in shade.', 'start': 2631.395, 'duration': 6.262}], 'summary': 'In tableau, the number of records determines the height of the histogram bars, with lighter bars representing fewer records.', 'duration': 29.445, 'max_score': 2608.212, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2608212.jpg'}, {'end': 2689.557, 'src': 'embed', 'start': 2662.945, 'weight': 3, 'content': [{'end': 2672.668, 'text': "So with Tableau, I've already told you, it always is making some consistent changes, upgrades in its visualization.", 'start': 2662.945, 'duration': 9.723}, {'end': 2682.915, 'text': "So in older version of Tableau, if you're using version 9.3 or some, other version, you will be able to see chart which looks like this.", 'start': 2673.349, 'duration': 9.566}, {'end': 2685.476, 'text': "So there'll be a number right beneath the chart.", 'start': 2683.316, 'duration': 2.16}, {'end': 2689.557, 'text': "And also, there'll be some gap between the bars.", 'start': 2686.156, 'duration': 3.401}], 'summary': 'Tableau consistently updates visualizations, with older versions displaying charts with numbers beneath and gaps between bars.', 'duration': 26.612, 'max_score': 2662.945, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2662945.jpg'}, {'end': 3023.145, 'src': 'embed', 'start': 2996.682, 'weight': 5, 'content': [{'end': 3002.463, 'text': 'It is, again, use bar-like representation to display data and bars can be of different height.', 'start': 2996.682, 'duration': 5.781}, {'end': 3005.864, 'text': 'Bar graph is used when we have categorical data.', 'start': 3002.563, 'duration': 3.301}, {'end': 3008.858, 'text': 'and we want to compare two categories together.', 'start': 3006.417, 'duration': 2.441}, {'end': 3012.5, 'text': "So let's say, let's consider this following example.", 'start': 3009.238, 'duration': 3.262}, {'end': 3018.063, 'text': "Let's say we are going to survey different people.", 'start': 3015.661, 'duration': 2.402}, {'end': 3023.145, 'text': 'We are going to survey 145 different people and we are going to ask them what is their favorite fruit.', 'start': 3018.083, 'duration': 5.062}], 'summary': "Bar graph displays categorical data, used to compare 145 people's favorite fruits.", 'duration': 26.463, 'max_score': 2996.682, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2996682.jpg'}, {'end': 3128.597, 'src': 'embed', 'start': 3101.497, 'weight': 4, 'content': [{'end': 3106.8, 'text': 'When you want to check the distribution of a continuous data, a ratio data, we use a histogram.', 'start': 3101.497, 'duration': 5.303}, {'end': 3108.781, 'text': 'I hope that difference is clear.', 'start': 3107.58, 'duration': 1.201}, {'end': 3114.144, 'text': 'And in histogram, the bars tend to stick to one another.', 'start': 3110.382, 'duration': 3.762}, {'end': 3119.155, 'text': 'So if you look at this histogram, which table you draw for us, These bars are sticking to one another.', 'start': 3114.164, 'duration': 4.991}, {'end': 3124.136, 'text': 'In a normal bar graph, the bars have some space in between.', 'start': 3119.775, 'duration': 4.361}, {'end': 3128.597, 'text': 'So that way, we can demarcate between histogram and a bar graph.', 'start': 3124.156, 'duration': 4.441}], 'summary': 'Histograms display continuous data distribution; bars stick together, unlike in bar graphs.', 'duration': 27.1, 'max_score': 3101.497, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc3101497.jpg'}], 'start': 2529.755, 'title': 'Understanding histograms and bar graphs in tableau', 'summary': 'Covers how to create and interpret histograms in tableau, focusing on bin size, labels, color encoding, and visualizing data distribution. it also explains the upgrades from tableau version 9.3 to version 10, including changes in visualization and the usage of bar graphs for data analysis.', 'chapters': [{'end': 2660.444, 'start': 2529.755, 'title': 'Understanding histograms in tableau', 'summary': 'Explains how to create and interpret histograms in tableau, emphasizing the use of bin size, labels, and color encoding to visualize the distribution of data and understand the frequency of records, with a focus on the number of cars in different categories.', 'duration': 130.689, 'highlights': ["The center point of the histogram corresponds to the category with the most number of records, resulting in a taller bar, while using the 'number of records' field to colorize the bars enables visualization of varying shades based on the frequency of cars, providing insights into the distribution.", 'Number of records, an auto-generated field in Tableau, indicates the total number of rows in the dataset, influencing the height and shading of the bars in the histogram, offering a quantitative understanding of data distribution.', 'Utilizing bin size and label placement in histograms enhances the visualization and comprehension of data distribution in Tableau, allowing for a more insightful analysis of the frequency of cars in different categories.']}, {'end': 3394.483, 'start': 2662.945, 'title': 'Tableau version 10 upgrades and usage of bar graphs', 'summary': 'Discusses the upgrades from tableau version 9.3 to version 10, including changes in visualization and the usage of bar graphs and histograms to analyze data distribution and categorical data. it also explains the key differences between bar graphs and histograms and provides a step-by-step guide to create a bar graph in tableau.', 'duration': 731.538, 'highlights': ['Changes from Tableau Version 9.3 to Version 10 Tableau has made significant upgrades from version 9.3 to version 10, with changes in visualization, such as sticking the bars together in the newer version, as opposed to having a gap between the bars in the older version.', 'Usage and Importance of Histograms The chapter emphasizes the usage of histograms to visualize the distribution of continuous data, providing examples of normal distribution, skewed data, and its relevance in Six Sigma and statistics.', "Understanding Bar Graphs It explains the usage of bar graphs for categorical data comparison, providing a practical example of surveying people's favorite fruits and using a bar graph to display the results."]}], 'duration': 864.728, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc2529755.jpg', 'highlights': ['Utilizing bin size and label placement in histograms enhances the visualization and comprehension of data distribution in Tableau, allowing for a more insightful analysis of the frequency of cars in different categories.', 'Number of records, an auto-generated field in Tableau, indicates the total number of rows in the dataset, influencing the height and shading of the bars in the histogram, offering a quantitative understanding of data distribution.', "The center point of the histogram corresponds to the category with the most number of records, resulting in a taller bar, while using the 'number of records' field to colorize the bars enables visualization of varying shades based on the frequency of cars, providing insights into the distribution.", 'Changes from Tableau Version 9.3 to Version 10 Tableau has made significant upgrades from version 9.3 to version 10, with changes in visualization, such as sticking the bars together in the newer version, as opposed to having a gap between the bars in the older version.', 'Usage and Importance of Histograms The chapter emphasizes the usage of histograms to visualize the distribution of continuous data, providing examples of normal distribution, skewed data, and its relevance in Six Sigma and statistics.', "Understanding Bar Graphs It explains the usage of bar graphs for categorical data comparison, providing a practical example of surveying people's favorite fruits and using a bar graph to display the results."]}, {'end': 4004.871, 'segs': [{'end': 3510.184, 'src': 'embed', 'start': 3455.192, 'weight': 0, 'content': [{'end': 3463.717, 'text': 'Why are we interested to compare average price, why not total price? Because total price can be influenced by number of records.', 'start': 3455.192, 'duration': 8.525}, {'end': 3472.063, 'text': "So if we have let's say more number of cars which fall in the sedan category, then obviously the bar size for sedan is going to be higher.", 'start': 3464.198, 'duration': 7.865}, {'end': 3477.29, 'text': 'Not because sedan is more expensive, but because we have more number of cars in sedan category.', 'start': 3472.523, 'duration': 4.767}, {'end': 3480.433, 'text': "So it's better to compare the average value.", 'start': 3477.691, 'duration': 2.742}, {'end': 3489.68, 'text': 'So if we compare the average price of all these different cars, we can see that convertible and hard tops, they are more expensive.', 'start': 3481.393, 'duration': 8.287}, {'end': 3500.228, 'text': 'If you want to display the labels on screen, you take price and throw that on label.', 'start': 3490.441, 'duration': 9.787}, {'end': 3505.842, 'text': "This way we'll be able to see Labels on top of screen.", 'start': 3501.809, 'duration': 4.033}, {'end': 3507.723, 'text': 'but what are these labels see?', 'start': 3505.842, 'duration': 1.881}, {'end': 3510.184, 'text': 'the label for sedan is very high.', 'start': 3507.723, 'duration': 2.461}], 'summary': 'Comparing average prices eliminates influence of record count. convertibles and hard tops are most expensive.', 'duration': 54.992, 'max_score': 3455.192, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc3455192.jpg'}, {'end': 3693.318, 'src': 'embed', 'start': 3663.948, 'weight': 2, 'content': [{'end': 3666.308, 'text': "We shouldn't do it this way as much as possible.", 'start': 3663.948, 'duration': 2.36}, {'end': 3670.37, 'text': 'We should take price, throw it in the label section.', 'start': 3666.728, 'duration': 3.642}, {'end': 3672.87, 'text': 'This will give us sum of price.', 'start': 3671.45, 'duration': 1.42}, {'end': 3680.449, 'text': 'By default, Tableau takes sum every time we use it, any particular number, so we need to convert the labels also.', 'start': 3673.03, 'duration': 7.419}, {'end': 3685.192, 'text': 'We need to make sure labels are also being displayed in average format.', 'start': 3681.27, 'duration': 3.922}, {'end': 3691.437, 'text': 'And then we right click and change the format of this average price.', 'start': 3685.793, 'duration': 5.644}, {'end': 3693.318, 'text': 'Right click and choose this format option.', 'start': 3691.577, 'duration': 1.741}], 'summary': 'Use label section to display sum and average price in tableau.', 'duration': 29.37, 'max_score': 3663.948, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc3663948.jpg'}, {'end': 3777.242, 'src': 'embed', 'start': 3745.608, 'weight': 4, 'content': [{'end': 3747.888, 'text': 'Is there anyone who needs my help to answer the following quiz?', 'start': 3745.608, 'duration': 2.28}, {'end': 3750.649, 'text': 'Or was everyone able to do it themselves??', 'start': 3748.088, 'duration': 2.561}, {'end': 3754.31, 'text': "So here there's one thing which we need to take care of.", 'start': 3751.629, 'duration': 2.681}, {'end': 3756.05, 'text': 'We need to use number of records.', 'start': 3754.37, 'duration': 1.68}, {'end': 3761.471, 'text': 'So apart from drive wheels, we need to use number of records to create this bar chart.', 'start': 3756.67, 'duration': 4.801}, {'end': 3764.012, 'text': 'And then we can simply display the labels.', 'start': 3762.312, 'duration': 1.7}, {'end': 3768.915, 'text': 'Awesome, so everyone was able to create all the visualizations.', 'start': 3765.091, 'duration': 3.824}, {'end': 3771.937, 'text': "So let's move ahead and let's discuss about box plot.", 'start': 3768.955, 'duration': 2.982}, {'end': 3777.242, 'text': "Now, this one is a bit complex to understand, but I'll try my best to explain it as much as possible,", 'start': 3771.977, 'duration': 5.265}], 'summary': 'Discussion on creating visualizations and using number of records for a bar chart, followed by a complex explanation of box plot.', 'duration': 31.634, 'max_score': 3745.608, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc3745608.jpg'}, {'end': 3846.416, 'src': 'embed', 'start': 3820.008, 'weight': 5, 'content': [{'end': 3824.85, 'text': 'but tools like Tableau provide ability for general users also to create a box plot.', 'start': 3820.008, 'duration': 4.842}, {'end': 3829.851, 'text': 'So what is a box plot? Box plot is also called as a box and whisker plot.', 'start': 3824.87, 'duration': 4.981}, {'end': 3833.172, 'text': 'Now this is very similar to a histogram.', 'start': 3830.651, 'duration': 2.521}, {'end': 3836.933, 'text': 'The usage of a box plot is very similar to a histogram.', 'start': 3833.392, 'duration': 3.541}, {'end': 3846.416, 'text': 'Histogram, what is the use of histogram? To see the distribution of data, the distribution of a ratio variable, a ratio data.', 'start': 3837.413, 'duration': 9.003}], 'summary': 'Tableau enables general users to create box plots, a visualization for analyzing data distribution.', 'duration': 26.408, 'max_score': 3820.008, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc3820008.jpg'}, {'end': 3893.898, 'src': 'embed', 'start': 3867.748, 'weight': 3, 'content': [{'end': 3871.99, 'text': 'Why to use a boxplot? Boxplot serves the following two uses.', 'start': 3867.748, 'duration': 4.242}, {'end': 3877.168, 'text': 'First of all, it is a very useful tool to identify outliers.', 'start': 3872.665, 'duration': 4.503}, {'end': 3880.77, 'text': 'For outlier detection, Boxplot is an ideal tool.', 'start': 3877.368, 'duration': 3.402}, {'end': 3885.032, 'text': 'And then it is also used for significance test.', 'start': 3881.55, 'duration': 3.482}, {'end': 3891.596, 'text': 'Now what is an outlier and what is significance test? And also this is a very common interview question.', 'start': 3885.353, 'duration': 6.243}, {'end': 3893.898, 'text': 'So just a hint for you all.', 'start': 3892.016, 'duration': 1.882}], 'summary': 'Boxplot is useful for identifying outliers and for significance tests in data analysis.', 'duration': 26.15, 'max_score': 3867.748, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc3867748.jpg'}], 'start': 3394.604, 'title': 'Visualizing car prices and creating visualizations with tableau', 'summary': 'Demonstrated how to visualize and format labels to compare average car prices by body style, highlighting the importance of using average price over total price. it also discusses creating bar graphs and box plots using tableau, emphasizing color coding, label display, and outlier identification.', 'chapters': [{'end': 3590.202, 'start': 3394.604, 'title': 'Visualizing car prices', 'summary': 'Demonstrated how to visualize and format labels to compare average car prices by body style, highlighting the importance of using average price over total price to avoid skewing due to the number of records.', 'duration': 195.598, 'highlights': ['The importance of comparing average price over total price was emphasized, as total price can be influenced by the number of records, potentially skewing the comparison.', 'It was demonstrated that convertible and hard tops were more expensive compared to other body styles when comparing average prices, with a difference of approximately 1.3 million dollars for sedan and relatively less for hard tops.', 'Instructions were provided on formatting the labels to show average price in dollar format and syncing them with the bar size to accurately represent the data.']}, {'end': 4004.871, 'start': 3591.38, 'title': 'Creating visualizations with tableau', 'summary': 'Discusses the process of creating bar graphs and box plots using tableau, emphasizing color coding, label display, and outlier identification using box plots. it also highlights the significance of box plots in identifying outliers and for significance testing.', 'duration': 413.491, 'highlights': ['Boxplot serves the following two uses. First of all, it is a very useful tool to identify outliers. For outlier detection, Boxplot is an ideal tool. And then it is also used for significance test. Boxplot is a useful tool for identifying outliers and for significance testing, providing practical applications in data analysis.', 'We need to use number of records. So apart from drive wheels, we need to use number of records to create this bar chart. The process of creating a bar chart involves utilizing the number of records in addition to drive wheels to represent the data effectively.', 'Tableau provides ability for general users also to create a box plot. So what is a box plot? Box plot is also called as a box and whisker plot. Tableau enables general users to create box plots, also known as box and whisker plots, expanding its usability to a wider audience.']}], 'duration': 610.267, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc3394604.jpg', 'highlights': ['Demonstrated importance of comparing average price over total price to avoid skewing comparison.', 'Convertible and hard tops were more expensive compared to other body styles, with a difference of approximately 1.3 million dollars for sedan.', 'Instructions provided on formatting labels to show average price in dollar format and syncing them with bar size.', 'Boxplot is a useful tool for identifying outliers and for significance testing, providing practical applications in data analysis.', 'The process of creating a bar chart involves utilizing the number of records in addition to drive wheels to represent the data effectively.', 'Tableau enables general users to create box plots, also known as box and whisker plots, expanding its usability to a wider audience.']}, {'end': 4871.312, 'segs': [{'end': 4057.316, 'src': 'embed', 'start': 4005.431, 'weight': 0, 'content': [{'end': 4015.234, 'text': "Okay, so that is if you are, let's say, want to identify such people like, if we have clear outliers, you are visualizing salary,", 'start': 4005.431, 'duration': 9.803}, {'end': 4020.816, 'text': 'then if you use a box plot, box plot is going to point out that CEO person to you.', 'start': 4015.234, 'duration': 5.582}, {'end': 4027.065, 'text': 'that person who is earning exceptionally more salary as compared to other people.', 'start': 4021.243, 'duration': 5.822}, {'end': 4031.026, 'text': 'Also, a box plot is used for significance test.', 'start': 4028.205, 'duration': 2.821}, {'end': 4033.147, 'text': "So let's see how a box plot looks like.", 'start': 4031.126, 'duration': 2.021}, {'end': 4034.567, 'text': 'A box plot looks like following.', 'start': 4033.267, 'duration': 1.3}, {'end': 4042.37, 'text': "Let's say we are comparing average weight of male and female employees working in a particular organization.", 'start': 4034.588, 'duration': 7.782}, {'end': 4055.135, 'text': 'So generally, from our general knowledge, we know males have more weight, so in general, the box, this is the box for a particular category.', 'start': 4043.27, 'duration': 11.865}, {'end': 4057.316, 'text': 'The box will be shifted upwards.', 'start': 4055.455, 'duration': 1.861}], 'summary': "Box plot identifies outliers, visually highlights ceo's salary, and compares weight of male and female employees.", 'duration': 51.885, 'max_score': 4005.431, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4005431.jpg'}, {'end': 4133.731, 'src': 'embed', 'start': 4104.048, 'weight': 2, 'content': [{'end': 4110.41, 'text': 'But there are some male employees which are not very heavy and there are some male employees which are extremely heavy.', 'start': 4104.048, 'duration': 6.362}, {'end': 4115.292, 'text': 'But in general, female group is lower than male group.', 'start': 4111.691, 'duration': 3.601}, {'end': 4119.353, 'text': 'So females tend to have less weight as compared to males.', 'start': 4115.392, 'duration': 3.961}, {'end': 4121.953, 'text': 'This is what this box plot is showing us.', 'start': 4120.013, 'duration': 1.94}, {'end': 4127.636, 'text': 'How to interpret a box plot? This is how a typical box plot looks like.', 'start': 4123.694, 'duration': 3.942}, {'end': 4133.731, 'text': "So there'll be a box and there'll be a line somewhere in the box.", 'start': 4128.076, 'duration': 5.655}], 'summary': 'Female employees generally have lower weight than male employees.', 'duration': 29.683, 'max_score': 4104.048, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4104048.jpg'}, {'end': 4264.245, 'src': 'embed', 'start': 4234.024, 'weight': 3, 'content': [{'end': 4235.225, 'text': 'this is the heaviest one.', 'start': 4234.024, 'duration': 1.201}, {'end': 4237.205, 'text': 'Similar is the case for males.', 'start': 4235.885, 'duration': 1.32}, {'end': 4240.466, 'text': 'This is how we interpret a box plot.', 'start': 4237.825, 'duration': 2.641}, {'end': 4245.232, 'text': 'So medians and first quartile, second quartile are not really important in a box plot.', 'start': 4241.089, 'duration': 4.143}, {'end': 4255.619, 'text': 'What is more important is is there an outlier and is one particular box very, very low as compared to other,', 'start': 4245.972, 'duration': 9.647}, {'end': 4258.06, 'text': 'or are they sticking very close to each other??', 'start': 4255.619, 'duration': 2.441}, {'end': 4264.245, 'text': "Okay, so let's actually create a box plot.", 'start': 4258.08, 'duration': 6.165}], 'summary': 'Interpreting a box plot: focus on outliers and variations in the data distribution.', 'duration': 30.221, 'max_score': 4234.024, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4234024.jpg'}, {'end': 4585.571, 'src': 'heatmap', 'start': 4461.942, 'weight': 4, 'content': [{'end': 4468.643, 'text': "It's better to create actually a box plot step by step so it's better to start off with city mileage and later on we are going to bring in fuel type.", 'start': 4461.942, 'duration': 6.701}, {'end': 4470.424, 'text': "So let's start with city mileage.", 'start': 4469.004, 'duration': 1.42}, {'end': 4477.025, 'text': 'For creating a box plot we need each individual circle, you see here.', 'start': 4471.744, 'duration': 5.281}, {'end': 4480.168, 'text': 'Each circle is actually representing one car.', 'start': 4477.566, 'duration': 2.602}, {'end': 4485.511, 'text': 'So car ID is the identifier, car identifier.', 'start': 4480.988, 'duration': 4.523}, {'end': 4493.815, 'text': 'So you take car ID, you take city mileage, go to show me and choose this box and whisker plot.', 'start': 4485.531, 'duration': 8.284}, {'end': 4500.119, 'text': 'So your box and whisker plot will be ready.', 'start': 4498.078, 'duration': 2.041}, {'end': 4505.102, 'text': 'This is all cars collectively together irrespective of their fuel type.', 'start': 4500.139, 'duration': 4.963}, {'end': 4508.217, 'text': 'what is the kind of mileage they are giving, all cars.', 'start': 4505.615, 'duration': 2.602}, {'end': 4515.563, 'text': "So please create the following box plot and let me know once you've created this.", 'start': 4512.36, 'duration': 3.203}, {'end': 4532.937, 'text': 'So a box plot of city mileage of all the cars.', 'start': 4529.654, 'duration': 3.283}, {'end': 4544.739, 'text': 'Done, okay, now we just take this fuel type, we just take this one and drop it in the column section.', 'start': 4536.496, 'duration': 8.243}, {'end': 4552.863, 'text': 'So essentially what are we telling Tableau? Show us two different columns, one for each fuel type, or maybe n number of columns.', 'start': 4544.879, 'duration': 7.984}, {'end': 4557.945, 'text': "If we have 10 different fuel types, it'll show 10 different columns, one for each of the fuel type.", 'start': 4552.923, 'duration': 5.022}, {'end': 4566.208, 'text': "So I drop it here, we have two fuel types, diesel and gas, so Tableau's showing us two separate box plot, one for diesel, one for gasoline.", 'start': 4558.545, 'duration': 7.663}, {'end': 4571.087, 'text': 'And we can see the box for diesel is a bit upwards.', 'start': 4568.106, 'duration': 2.981}, {'end': 4576.769, 'text': 'If we compare it with gasoline-based cars, see, the median is a bit upwards.', 'start': 4571.407, 'duration': 5.362}, {'end': 4585.571, 'text': 'And on top of that, Tableau has also helped you identify the outliers.', 'start': 4580.69, 'duration': 4.881}], 'summary': 'Create box plot for city mileage, then add fuel type for comparison. identify outliers.', 'duration': 27.026, 'max_score': 4461.942, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4461942.jpg'}, {'end': 4772.878, 'src': 'embed', 'start': 4735.734, 'weight': 5, 'content': [{'end': 4742.457, 'text': 'So, whether the car is four wheel drive or forward wheel drive or rear wheel drive, how much money am I going to incur?', 'start': 4735.734, 'duration': 6.723}, {'end': 4745.199, 'text': "Let's say I'm planning to purchase a car.", 'start': 4742.718, 'duration': 2.481}, {'end': 4747.959, 'text': 'and I do not want to buy a very expensive car.', 'start': 4745.697, 'duration': 2.262}, {'end': 4757.766, 'text': 'So which kind of drive wheel should I opt for? So let me share with you the steps required to create this box plot.', 'start': 4749.44, 'duration': 8.326}, {'end': 4758.947, 'text': "It's rather simple.", 'start': 4758.207, 'duration': 0.74}, {'end': 4772.878, 'text': "You take the drive wheel, which is, I'm sorry, where exactly that is? Drive wheel, okay? So here it is, drive wheel.", 'start': 4761.029, 'duration': 11.849}], 'summary': 'Analyzing cost implications of different drive wheel types for car purchase.', 'duration': 37.144, 'max_score': 4735.734, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4735734.jpg'}], 'start': 4005.431, 'title': 'Box plot interpretation', 'summary': 'Covers the use of box plots in identifying outliers in salary visualization, comparing categories, and interpreting weight differences, revealing insights into salary distribution and emphasizing the importance of outliers in data analysis.', 'chapters': [{'end': 4127.636, 'start': 4005.431, 'title': 'Understanding box plots', 'summary': 'Discusses the use of box plots for identifying outliers in salary visualization, comparing two categories, and interpreting weight differences between male and female employees within an organization, revealing insights into the distribution of salaries and weight discrepancies.', 'duration': 122.205, 'highlights': ['Box plot identifies outliers in salary visualization, such as a CEO earning exceptionally more than others. Box plot is used to identify outliers in salary visualization, pointing out individuals earning exceptionally more than others, such as a CEO.', 'Box plot is used for significance test and comparing categories, such as average weight of male and female employees. Box plot is used for significance tests and comparing categories, exemplified by comparing the average weight of male and female employees in an organization.', 'Visual interpretation of box plot reveals weight discrepancies between male and female employees, indicating that females tend to have less weight compared to males. Box plot visually demonstrates weight differences between male and female employees, showing that females tend to have less weight than males within the organization.']}, {'end': 4871.312, 'start': 4128.076, 'title': 'Interpreting box plots and comparing data', 'summary': 'Explains the concept of box plots, percentiles, and outliers, and demonstrates how to create and interpret box plots to compare data, emphasizing the importance of outliers in data analysis.', 'duration': 743.236, 'highlights': ['The chapter explains the concept of box plots, percentiles, and outliers, emphasizing their importance in data analysis.', 'It demonstrates the step-by-step procedure to create a box plot to compare the mileage of diesel and gasoline cars, highlighting the significance of outliers and the visual representation of data distribution.', 'The chapter also illustrates the use of box plots to compare the pricing of cars based on their drive wheel, emphasizing the consistency of pricing for forward wheel drive cars and the scattered pricing for rear wheel drive cars.']}], 'duration': 865.881, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4005431.jpg', 'highlights': ['Box plot identifies outliers in salary visualization, such as a CEO earning exceptionally more than others.', 'Box plot is used for significance tests and comparing categories, exemplified by comparing the average weight of male and female employees in an organization.', 'Visual interpretation of box plot reveals weight discrepancies between male and female employees, indicating that females tend to have less weight compared to males.', 'The chapter explains the concept of box plots, percentiles, and outliers, emphasizing their importance in data analysis.', 'It demonstrates the step-by-step procedure to create a box plot to compare the mileage of diesel and gasoline cars, highlighting the significance of outliers and the visual representation of data distribution.', 'The chapter also illustrates the use of box plots to compare the pricing of cars based on their drive wheel, emphasizing the consistency of pricing for forward wheel drive cars and the scattered pricing for rear wheel drive cars.']}, {'end': 6054.008, 'segs': [{'end': 4899.131, 'src': 'embed', 'start': 4872.073, 'weight': 1, 'content': [{'end': 4878.498, 'text': 'So spread of data is also something which we should look at, not only the average value.', 'start': 4872.073, 'duration': 6.425}, {'end': 4882.982, 'text': 'So spread of data is also a very, very important factor to consider.', 'start': 4879.739, 'duration': 3.243}, {'end': 4886.284, 'text': "If the data has a lot of spread, that's a bad thing.", 'start': 4883.302, 'duration': 2.982}, {'end': 4893.47, 'text': 'And spread of the data is checked by factors like standard deviation, and range of the data, interquartile range.', 'start': 4887.185, 'duration': 6.285}, {'end': 4899.131, 'text': "So all these details you are going to get through the article which I'm going to upload on the share folder.", 'start': 4893.77, 'duration': 5.361}], 'summary': 'Spread of data, measured by standard deviation, range, and interquartile range, is crucial to consider, as high spread can be detrimental.', 'duration': 27.058, 'max_score': 4872.073, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4872073.jpg'}, {'end': 4997.224, 'src': 'embed', 'start': 4962.656, 'weight': 0, 'content': [{'end': 4977.782, 'text': 'So descriptive statistics involves measures like mean, median, mode, standard deviation, range, interquartile range, all these kind of things.', 'start': 4962.656, 'duration': 15.126}, {'end': 4988.397, 'text': 'And inferential statistics deals with t-test, ANOVA, regression, these kind of topics.', 'start': 4978.542, 'duration': 9.855}, {'end': 4990.979, 'text': 'They are advanced analysis topics.', 'start': 4988.797, 'duration': 2.182}, {'end': 4997.224, 'text': 'So this particular article will tell you about descriptive statistics.', 'start': 4992.58, 'duration': 4.644}], 'summary': 'Descriptive statistics includes mean, median, mode, standard deviation, while inferential statistics involves t-test, anova, and regression.', 'duration': 34.568, 'max_score': 4962.656, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4962656.jpg'}, {'end': 5094.193, 'src': 'embed', 'start': 5067.5, 'weight': 3, 'content': [{'end': 5078.165, 'text': 'Pie chart is used to show the breakup of your entire population or the whole 100% group into its contributing components or categories.', 'start': 5067.5, 'duration': 10.665}, {'end': 5084.768, 'text': 'And a pie chart should be created only when you have four or less categories.', 'start': 5079.046, 'duration': 5.722}, {'end': 5087.07, 'text': "It's just a thumb rule, it's a recommendation.", 'start': 5084.909, 'duration': 2.161}, {'end': 5090.751, 'text': "It's not something really which you need to follow as such.", 'start': 5087.45, 'duration': 3.301}, {'end': 5094.193, 'text': "So I'm going to create the following pie chart.", 'start': 5091.492, 'duration': 2.701}], 'summary': 'Pie chart breaks down population into 4 or less categories. recommended for 100% group.', 'duration': 26.693, 'max_score': 5067.5, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc5067500.jpg'}, {'end': 5193.372, 'src': 'embed', 'start': 5162.89, 'weight': 4, 'content': [{'end': 5171.657, 'text': 'So we take number of doors, we hold down the Control key, we select number of records, we go to Show Me, and we choose this pie chart.', 'start': 5162.89, 'duration': 8.767}, {'end': 5179.708, 'text': 'So Tableau is taking some time.', 'start': 5178.308, 'duration': 1.4}, {'end': 5182.209, 'text': 'It has drawn the pie chart on screen.', 'start': 5180.089, 'duration': 2.12}, {'end': 5184.39, 'text': 'This pie chart is like really, really small.', 'start': 5182.509, 'duration': 1.881}, {'end': 5186.79, 'text': 'So you can bump up the size if you want to.', 'start': 5184.89, 'duration': 1.9}, {'end': 5193.372, 'text': 'Go to the size section, click once, and you can use the slider to make your pie chart bigger in size.', 'start': 5187.291, 'duration': 6.081}], 'summary': 'Using tableau, we created a pie chart from a selected number of records and adjusted its size for better visibility.', 'duration': 30.482, 'max_score': 5162.89, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc5162890.jpg'}, {'end': 5547.278, 'src': 'embed', 'start': 5498.314, 'weight': 6, 'content': [{'end': 5504.517, 'text': "See this triangular symbol? See this one? Whenever I'm bringing my mouse, the symbol is just fading away.", 'start': 5498.314, 'duration': 6.203}, {'end': 5507.998, 'text': 'But this triangular symbol, it is referring to this field.', 'start': 5505.097, 'duration': 2.901}, {'end': 5513.701, 'text': 'It is pointing out that this particular field is actually based on a calculation.', 'start': 5508.038, 'duration': 5.663}, {'end': 5515.302, 'text': 'A calculation has been performed here.', 'start': 5513.801, 'duration': 1.501}, {'end': 5520.304, 'text': 'So we were able to identify that this component by comparing the icon.', 'start': 5516.162, 'duration': 4.142}, {'end': 5527.727, 'text': 'this component is responsible for the percentage value, and this is what we need to format and reduce the number of decimal places.', 'start': 5520.643, 'duration': 7.084}, {'end': 5538.373, 'text': 'So we right click and format, go to number, choose percentage and reduce number of decimal places, maybe make it zero.', 'start': 5528.347, 'duration': 10.026}, {'end': 5547.278, 'text': 'So go to the percentage section, not custom numbers, not any other place but percentage and reduce the number of decimal places to zero.', 'start': 5539.013, 'duration': 8.265}], 'summary': 'Identified field with calculation symbol, formatted as percentage with zero decimal places', 'duration': 48.964, 'max_score': 5498.314, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc5498314.jpg'}, {'end': 5939.512, 'src': 'embed', 'start': 5891.46, 'weight': 5, 'content': [{'end': 5893.801, 'text': 'And then I want to show the labels here.', 'start': 5891.46, 'duration': 2.341}, {'end': 5898.345, 'text': 'I do not want to refer to this size legend and this color legend.', 'start': 5894.662, 'duration': 3.683}, {'end': 5899.826, 'text': 'I do not want to hover my mouse.', 'start': 5898.385, 'duration': 1.441}, {'end': 5901.127, 'text': 'I want to print this pie chart.', 'start': 5899.866, 'duration': 1.261}, {'end': 5902.708, 'text': 'So I want to show labels here.', 'start': 5901.607, 'duration': 1.101}, {'end': 5906.111, 'text': "So let's take number of doors.", 'start': 5903.689, 'duration': 2.422}, {'end': 5908.204, 'text': 'drop it in the label section.', 'start': 5906.863, 'duration': 1.341}, {'end': 5913.366, 'text': 'Now Tableau is telling us this section of the pie is for four doors, this section of the pie is for two doors.', 'start': 5908.764, 'duration': 4.602}, {'end': 5917.088, 'text': 'Take number of records, throw it in the label section.', 'start': 5914.707, 'duration': 2.381}, {'end': 5919.949, 'text': 'Tableau will tell us we have 81 such cars here.', 'start': 5917.268, 'duration': 2.681}, {'end': 5922.61, 'text': 'We have 114 such cars in the blue section.', 'start': 5920.109, 'duration': 2.501}, {'end': 5925.751, 'text': 'We want to convert this into percentage value.', 'start': 5923.31, 'duration': 2.441}, {'end': 5930.654, 'text': 'Right click on this label which is responsible for this number.', 'start': 5926.852, 'duration': 3.802}, {'end': 5933.155, 'text': 'This is the label, some number of records.', 'start': 5931.154, 'duration': 2.001}, {'end': 5939.512, 'text': 'Right click, go to Quick Table Calculation, Choose percentage of total.', 'start': 5933.235, 'duration': 6.277}], 'summary': 'Using tableau, labels were added to a pie chart showing car data, including 81 cars with four doors and 114 cars in the blue section, converted to percentage values.', 'duration': 48.052, 'max_score': 5891.46, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc5891460.jpg'}], 'start': 4872.073, 'title': 'Data visualization and percentage formatting in tableau', 'summary': 'Covers the importance of descriptive statistics, visualization techniques like histogram and box plot, and using pie charts for data representation. it also details creating and enhancing pie charts in tableau, emphasizing label adjustments and percentage values, and formatting percentage values in tableau, including rounding off decimal places and customizing labels for accurate data representation.', 'chapters': [{'end': 5161.969, 'start': 4872.073, 'title': 'Descriptive statistics & visualization', 'summary': 'Discusses the importance of spread of data, basic measures of descriptive statistics, and the use of visualizations like histogram and box plot, as well as the application of pie charts for data representation.', 'duration': 289.896, 'highlights': ['The spread of data is checked by factors like standard deviation, range of the data, and interquartile range, which are important to consider. The spread of data is checked by factors like standard deviation, range of the data, and interquartile range, which are important to consider.', 'Descriptive statistics involves measures like mean, median, mode, standard deviation, range, and interquartile range. Descriptive statistics involves measures like mean, median, mode, standard deviation, range, and interquartile range.', 'Inferential statistics deals with t-test, ANOVA, and regression, while descriptive statistics focuses on basic measures and visualizations like histogram and box plot. Inferential statistics deals with t-test, ANOVA, and regression, while descriptive statistics focuses on basic measures and visualizations like histogram and box plot.', 'Pie charts are used to show the breakup of the entire population into its contributing components or categories, and should be created only when there are four or less categories. Pie charts are used to show the breakup of the entire population into its contributing components or categories, and should be created only when there are four or less categories.']}, {'end': 5478.162, 'start': 5162.89, 'title': 'Creating pie chart and enhancing labels', 'summary': 'Explains how to create a pie chart in tableau, adjust its size, add labels, and convert them to percentage values, emphasizing the importance of maintaining a standard size for the chart, and achieving the desired percentage values.', 'duration': 315.272, 'highlights': ["The chapter emphasizes the importance of maintaining a standard size for the pie chart in Tableau to avoid odd outcomes and mentions that it's a problem associated with version 10, with the older versions being relatively easier to increase the chart size.", "The instructor demonstrates how to add labels to the pie chart in Tableau by using the 'number of records' and 'number of doors' and also shows how to enhance the labels by converting them into percentage values using the 'percentage of total' quick table calculation option.", "The instructor explains the process of creating a pie chart in Tableau by selecting the number of doors and records, using the 'Show Me' option, and choosing the pie chart, while also highlighting the new features introduced in Tableau 10 and the need to adjust the canvas size to center the chart on the screen.", "The instructor asks the learners to create a pie chart with two sections, one for cars with four doors and one for cars with two doors, and then proceeds to teach how to show the numbers on the chart itself by adding labels and using the 'show mark label' option.", "The instructor discusses the importance of converting the label numbers into percentage values and explains the process of doing so in Tableau by right-clicking on the label, selecting 'quick table calculation,' and choosing the 'percentage of total' option, cautioning against mistakenly choosing 'percentage difference' to avoid wrong results."]}, {'end': 6054.008, 'start': 5478.823, 'title': 'Formatting percentage values in tableau', 'summary': 'Discusses formatting percentage values in tableau, including rounding off decimal places, identifying calculation components, and customizing labels to display percentage and absolute values, ensuring accurate representation of data.', 'duration': 575.185, 'highlights': ['Identifying Calculation Components The triangular symbol in Tableau indicates fields based on a calculation, used to identify components responsible for percentage values and format them accordingly.', 'Customizing Labels for Percentage and Absolute Values Tableau allows customization of labels to display percentage values, absolute numbers, and identifiers, providing a comprehensive view of data representation.', 'Formatting Percentage Values The process involves right-clicking on labels, choosing percentage of total, and formatting them to display rounded percentage values with zero decimal places for accurate data representation.']}], 'duration': 1181.935, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc4872073.jpg', 'highlights': ['Descriptive statistics involves measures like mean, median, mode, standard deviation, range, and interquartile range.', 'The spread of data is checked by factors like standard deviation, range of the data, and interquartile range, which are important to consider.', 'Inferential statistics deals with t-test, ANOVA, and regression, while descriptive statistics focuses on basic measures and visualizations like histogram and box plot.', 'Pie charts are used to show the breakup of the entire population into its contributing components or categories, and should be created only when there are four or less categories.', "The instructor explains the process of creating a pie chart in Tableau by selecting the number of doors and records, using the 'Show Me' option, and choosing the pie chart, while also highlighting the new features introduced in Tableau 10 and the need to adjust the canvas size to center the chart on the screen.", "The instructor demonstrates how to add labels to the pie chart in Tableau by using the 'number of records' and 'number of doors' and also shows how to enhance the labels by converting them into percentage values using the 'percentage of total' quick table calculation option.", 'Formatting Percentage Values The process involves right-clicking on labels, choosing percentage of total, and formatting them to display rounded percentage values with zero decimal places for accurate data representation.', 'Customizing Labels for Percentage and Absolute Values Tableau allows customization of labels to display percentage values, absolute numbers, and identifiers, providing a comprehensive view of data representation.', 'Identifying Calculation Components The triangular symbol in Tableau indicates fields based on a calculation, used to identify components responsible for percentage values and format them accordingly.']}, {'end': 7378.63, 'segs': [{'end': 6347.411, 'src': 'embed', 'start': 6294.134, 'weight': 1, 'content': [{'end': 6297.696, 'text': "So let's open up Tableau and let's import this data within Tableau.", 'start': 6294.134, 'duration': 3.562}, {'end': 6321.882, 'text': "So step number one, I've initiated and now I'm looking at start screen.", 'start': 6317.199, 'duration': 4.683}, {'end': 6324.104, 'text': 'I connect to this Excel file.', 'start': 6322.683, 'duration': 1.421}, {'end': 6331.569, 'text': 'TS underscore wide male female birth rate.', 'start': 6324.124, 'duration': 7.445}, {'end': 6332.39, 'text': 'I hit open.', 'start': 6331.729, 'duration': 0.661}, {'end': 6345.799, 'text': 'I preview the data a little bit on the start screen.', 'start': 6343.097, 'duration': 2.702}, {'end': 6347.411, 'text': 'this data screen.', 'start': 6346.65, 'duration': 0.761}], 'summary': 'Using tableau to import and analyze excel data for gender birth rates.', 'duration': 53.277, 'max_score': 6294.134, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc6294134.jpg'}, {'end': 6465.116, 'src': 'embed', 'start': 6425.864, 'weight': 2, 'content': [{'end': 6430.167, 'text': 'We go to sheet one, and now we are ready to create our line chart.', 'start': 6425.864, 'duration': 4.303}, {'end': 6443.377, 'text': 'Now based on your operating system settings, your Tableau installation, your Tableau instance may import this data wrongly.', 'start': 6435.472, 'duration': 7.905}, {'end': 6450.821, 'text': 'At times what happens is if you have, like a, your operating system settings is as per India,', 'start': 6443.397, 'duration': 7.424}, {'end': 6459.907, 'text': 'in that case Tableau may sort of think of this particular column this date.', 'start': 6450.821, 'duration': 9.086}, {'end': 6465.116, 'text': 'column as in month.', 'start': 6459.907, 'duration': 5.209}], 'summary': 'Transcript: preparing to create a line chart in tableau, but data import issues may arise based on os settings.', 'duration': 39.252, 'max_score': 6425.864, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc6425864.jpg'}, {'end': 6605.767, 'src': 'embed', 'start': 6565.566, 'weight': 0, 'content': [{'end': 6567.167, 'text': "So we'll have now two charts.", 'start': 6565.566, 'duration': 1.601}, {'end': 6571.491, 'text': 'The first chart is showing male birth, the second chart is showing female birth.', 'start': 6567.547, 'duration': 3.944}, {'end': 6576.715, 'text': 'As you can see from the axis, male birth and, excuse me, male birth and female birth.', 'start': 6571.731, 'duration': 4.984}, {'end': 6583.552, 'text': 'Simple step, all you have to do is drag female birth and drop it next to male birth.', 'start': 6579.969, 'duration': 3.583}, {'end': 6587.374, 'text': 'So essentially, what are we telling Tableau by doing this? Create two rows.', 'start': 6583.712, 'duration': 3.662}, {'end': 6589.756, 'text': 'In the first row, show male birth.', 'start': 6588.195, 'duration': 1.561}, {'end': 6591.737, 'text': 'In the second row, show female birth.', 'start': 6589.936, 'duration': 1.801}, {'end': 6605.767, 'text': 'Now, by default, what happens is when you create a line chart not a line chart exactly, but when you use a date field in Tableau visualization.', 'start': 6595.06, 'duration': 10.707}], 'summary': 'The charts display male and female birth data, with instructions to create two rows and use a date field for visualization.', 'duration': 40.201, 'max_score': 6565.566, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc6565566.jpg'}, {'end': 6888.997, 'src': 'embed', 'start': 6855.932, 'weight': 4, 'content': [{'end': 6863.336, 'text': "Okay, so on the share folder, I'm going to paste this in a CSV format.", 'start': 6855.932, 'duration': 7.404}, {'end': 6865.807, 'text': 'Here we go.', 'start': 6865.387, 'duration': 0.42}, {'end': 6868.548, 'text': 'So Anand, just pick up the CSV file.', 'start': 6866.467, 'duration': 2.081}, {'end': 6874.051, 'text': 'It contains the same data and try to create your line chart using the CSV file.', 'start': 6868.988, 'duration': 5.063}, {'end': 6881.354, 'text': 'So we are going to discuss about discrete versus continuous.', 'start': 6876.572, 'duration': 4.782}, {'end': 6883.614, 'text': 'One difference I showed to you already.', 'start': 6882.054, 'duration': 1.56}, {'end': 6888.997, 'text': 'The difference is basically if you go for this one.', 'start': 6885.355, 'duration': 3.642}], 'summary': 'Anand to create a line chart using csv file for discrete vs. continuous data.', 'duration': 33.065, 'max_score': 6855.932, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc6855932.jpg'}], 'start': 6055.649, 'title': 'Tableau data visualization', 'summary': 'Covers line charts, data trend analysis, and tableau data import, focusing on creating line charts in tableau and visualization techniques. it includes examples of male and female birth rates, data import process, and visualization techniques in tableau for trend analysis.', 'chapters': [{'end': 6293.113, 'start': 6055.649, 'title': 'Line charts and data trend analysis', 'summary': 'Covers customizing labels, creating pie charts to analyze car engine types, and understanding line charts to identify trends in data, particularly with time-related data, illustrated with an example of male and female birth rates over time.', 'duration': 237.464, 'highlights': ['Line charts are used to identify trends in data, especially with time-related data, and can also be used in other situations, such as tracking improvements over time, as demonstrated with the example of guessing facts about dogs over days.', 'The provided dataset contains time series data on male and female birth rates, which will be used to create line charts for trend analysis in an upcoming session.', 'Customizing labels and creating pie charts to analyze car engine types were also discussed as part of the session.']}, {'end': 6488.653, 'start': 6294.134, 'title': 'Tableau data import', 'summary': 'Explains the process of importing data into tableau, covering data types, common issues, and the importance of rectifying operating system settings for accurate data interpretation.', 'duration': 194.519, 'highlights': ['Tableau data import process The chapter explains the step-by-step process of importing data into Tableau, including connecting to an Excel file, previewing the data, and creating visualizations.', 'Common data types in Tableau The speaker discusses common data types in Tableau, including string, numeric, date, geospatial, and Boolean variables, while also addressing potential additional data types.', 'Import issue related to operating system settings The importance of rectifying operating system settings for accurate data interpretation in Tableau is highlighted, particularly when dealing with date formats that may be misinterpreted based on the operating system settings.']}, {'end': 6725.346, 'start': 6490.646, 'title': 'Creating line chart in tableau', 'summary': 'Explains the process of creating a line chart in tableau to visualize the trend of male and female birth over time, allowing for year-on-year and month-on-month analysis.', 'duration': 234.7, 'highlights': ['The process of creating a line chart in Tableau to visualize the trend of male and female birth over time is explained, enabling year-on-year and month-on-month analysis.', 'The default aggregation of information at an yearly level in Tableau is described, along with the option to change the time aggregation to month-on-month or quarter-on-quarter.', 'The distinction between discrete and continuous time fields in Tableau is highlighted, with a clear explanation of how selecting continuous month allows for month-on-month trend analysis.', 'The step-by-step process of adding female birth information to the line chart, creating two separate charts for male and female birth, is detailed for visualization purposes.']}, {'end': 7378.63, 'start': 6725.346, 'title': 'Tableau data visualization techniques', 'summary': 'Discusses converting files to csv format, using discrete versus continuous chart options in tableau, and creating dual axis charts for male and female birth trends, offering step-by-step guidance to participants.', 'duration': 653.284, 'highlights': ['The chapter discusses converting files to CSV format The speaker explains how to convert files to CSV format and suggests using LibreOffice as a free alternative to MS Office.', 'Using discrete versus continuous chart options in Tableau The speaker explains the difference between discrete and continuous chart options in Tableau, highlighting the importance of using the continuous option for trend analysis.', 'Creating dual axis charts for male and female birth trends The speaker guides participants in creating dual axis charts for male and female birth trends, providing step-by-step instructions and offering assistance to a participant.']}], 'duration': 1322.981, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc6055649.jpg', 'highlights': ['Creating line charts in Tableau for trend analysis with male and female birth rates.', 'Explaining the process of importing data into Tableau and addressing common data types.', 'Highlighting the importance of rectifying operating system settings for accurate data interpretation in Tableau.', 'Demonstrating the step-by-step process of visualizing the trend of male and female birth over time in Tableau.', 'Discussing the conversion of files to CSV format and the use of discrete versus continuous chart options in Tableau.', 'Guiding participants in creating dual axis charts for male and female birth trends in Tableau.']}, {'end': 9677.03, 'segs': [{'end': 7644.596, 'src': 'embed', 'start': 7613.935, 'weight': 1, 'content': [{'end': 7621.2, 'text': 'If we synchronize the axis, now both the axis will be equal to each other and our interpretation will change drastically.', 'start': 7613.935, 'duration': 7.265}, {'end': 7627.524, 'text': 'So our initial interpretation that male birth rate was higher than female birth rate, that was accurate.', 'start': 7621.78, 'duration': 5.744}, {'end': 7632.988, 'text': 'But our second interpretation, both birth rates are equal now, that was wrong.', 'start': 7628.445, 'duration': 4.543}, {'end': 7635.93, 'text': 'Male birth rate has surpassed male birth rate.', 'start': 7633.748, 'duration': 2.182}, {'end': 7644.596, 'text': 'in around 1955, female birth rate actually took over male birth rate and now we have more number of female children being born.', 'start': 7636.795, 'duration': 7.801}], 'summary': 'Initially, male birth rate was higher, but in 1955, female birth rate surpassed male birth rate.', 'duration': 30.661, 'max_score': 7613.935, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc7613935.jpg'}, {'end': 8012.129, 'src': 'embed', 'start': 7986.728, 'weight': 0, 'content': [{'end': 7991.431, 'text': 'It plays such a vital part in Tableau analysis and which people constantly undermine.', 'start': 7986.728, 'duration': 4.703}, {'end': 7998.296, 'text': 'Here we actually did a lot of hard work in getting to this point.', 'start': 7991.451, 'duration': 6.845}, {'end': 8000.384, 'text': "there's an easier data structure.", 'start': 7998.823, 'duration': 1.561}, {'end': 8008.267, 'text': 'If you just structure your data a bit differently, you will be able to generate all of these charts, which I showed you, all of these charts.', 'start': 8000.404, 'duration': 7.863}, {'end': 8012.129, 'text': "You'll be able to create them much more easily, much more easily.", 'start': 8008.507, 'duration': 3.622}], 'summary': 'Restructuring data can simplify tableau analysis and generate charts more easily.', 'duration': 25.401, 'max_score': 7986.728, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc7986728.jpg'}, {'end': 8377.003, 'src': 'embed', 'start': 8349.564, 'weight': 2, 'content': [{'end': 8357.591, 'text': 'But in general, for Tableau-based visualization, long format generally, in 90% of cases, long format is better.', 'start': 8349.564, 'duration': 8.027}, {'end': 8361.735, 'text': 'It will save you a lot of calculation steps, a lot of manual work.', 'start': 8358.412, 'duration': 3.323}, {'end': 8366.079, 'text': 'So it really is up to you, and it comes with experience.', 'start': 8363.156, 'duration': 2.923}, {'end': 8369.781, 'text': "Once you start working with Tableau, you'll realize what kind of format do you want.", 'start': 8366.179, 'duration': 3.602}, {'end': 8377.003, 'text': 'Data restructuring, major formatting in data, major restructuring of data has to be done outside of Tableau.', 'start': 8370.202, 'duration': 6.801}], 'summary': 'Long format is better for tableau-based visualization in 90% of cases, saving calculation steps and manual work.', 'duration': 27.439, 'max_score': 8349.564, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc8349564.jpg'}, {'end': 8564.011, 'src': 'embed', 'start': 8536.077, 'weight': 3, 'content': [{'end': 8540.519, 'text': "So I want to find the relationship between number of sales staff and the total sales I've generated.", 'start': 8536.077, 'duration': 4.442}, {'end': 8545.02, 'text': 'Which chart should I use? And the sales staff can be anything.', 'start': 8540.559, 'duration': 4.461}, {'end': 8550.703, 'text': 'It can be 12, 14, 19, 25, 39, It can be anything.', 'start': 8545.401, 'duration': 5.302}, {'end': 8552.004, 'text': 'Sales can be anything as well.', 'start': 8550.743, 'duration': 1.261}, {'end': 8555.546, 'text': 'So both of them are ratio values.', 'start': 8552.645, 'duration': 2.901}, {'end': 8557.587, 'text': 'So we need a scatter plot.', 'start': 8556.307, 'duration': 1.28}, {'end': 8564.011, 'text': 'Are you getting the picture? Yep, scatter plot is what we need.', 'start': 8559.949, 'duration': 4.062}], 'summary': 'Find relationship between sales staff & total sales using scatter plot.', 'duration': 27.934, 'max_score': 8536.077, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc8536077.jpg'}, {'end': 8941.894, 'src': 'embed', 'start': 8908.278, 'weight': 4, 'content': [{'end': 8911.74, 'text': 'Anyone else who has any questions can please feel free to ping me.', 'start': 8908.278, 'duration': 3.462}, {'end': 8916.241, 'text': 'Okay, so Dinesh, let me show you how we can create multiple line charts.', 'start': 8912.38, 'duration': 3.861}, {'end': 8925.385, 'text': 'Are you talking about the long data format or the wide data format here, Dinesh? Okay, the long data format.', 'start': 8916.721, 'duration': 8.664}, {'end': 8941.894, 'text': 'So with the long data format, If you want to look at the overall birth rate, select month and birth, go to show me, create a line graph.', 'start': 8925.945, 'duration': 15.949}], 'summary': 'Demonstrated creating multiple line charts using long data format.', 'duration': 33.616, 'max_score': 8908.278, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc8908278.jpg'}], 'start': 7378.63, 'title': 'Data analysis in tableau', 'summary': 'Covers topics such as interpreting line charts, gender birth rate analysis, data restructuring, visualizations in tableau, sales staff vs total sales relationship, and tableau line charts, csv file troubleshooting, emphasizing key steps and insights for effective data analysis.', 'chapters': [{'end': 7529.462, 'start': 7378.63, 'title': 'Interpreting line chart in tableau', 'summary': 'Discussed changing color and interpreting line charts in tableau, including steps on converting to dual axis and addressing issues with csv data formatting.', 'duration': 150.832, 'highlights': ['The presenter demonstrated changing the color and interpreting line charts in Tableau, including converting to dual axis and addressing CSV data formatting issues.', 'The presenter offered to assist Anand one-on-one after the session to resolve issues with CSV data formatting.', 'The presenter mentioned the steps for creating and interpreting line charts in Tableau, suggesting Anand to follow along and work on a quiz offline.']}, {'end': 8012.129, 'start': 7529.902, 'title': 'Gender birth rate analysis', 'summary': 'Discusses the trend analysis of gender birth rates, highlighting the initial higher male birth rate, the eventual equality of male and female birth rates, and the shift in trend with female birth rate surpassing male birth rate around 1955, emphasizing the importance of accurate data interpretation and cumulative growth calculation.', 'duration': 482.227, 'highlights': ['The initial higher male birth rate eventually equalized with the female birth rate, but later saw a shift with female birth rate surpassing male birth rate around 1955, emphasizing the importance of accurate data interpretation. (relevance: 5)', 'The chapter emphasizes the significance of accurate data interpretation, highlighting the need to synchronize axes for a correct trend analysis. (relevance: 4)', 'The discussion underscores the importance of cumulative growth calculation, demonstrating the use of quick table calculations to obtain running totals for both male and female birth rates. (relevance: 3)', 'Annotating historical data points is highlighted, showing how to mark and highlight significant trend changes, such as the shift in female birth rate around 1955, and the ability to format and customize annotations. (relevance: 2)', 'The importance of data structure in Tableau analysis is emphasized, indicating that a well-structured data can significantly ease the process of creating various charts. (relevance: 1)']}, {'end': 8507.277, 'start': 8013.25, 'title': 'Data restructuring and visualization in tableau', 'summary': 'Discusses the benefits of long data format over wide format for visual analysis in tableau, emphasizing the ease of creating different visualizations and the limitations of tableau in converting wide to long format.', 'duration': 494.027, 'highlights': ['The benefits of using long data format in Tableau for visual analysis, including ease of creating different visualizations and saving time in manual work, with long format being generally better for Tableau-based visualization (relevance score: 5)', "The limitations of Tableau in converting wide to long format, requiring data restructuring to be done outside of Tableau and potential future improvements in Tableau's capability for data restructuring (relevance score: 4)", 'The recommendation to use long data format for Tableau-based visualization in 90% of cases, highlighting the potential time savings and reduced manual work involved (relevance score: 3)', 'The importance of understanding the type of data format needed based on the visualization requirements and the potential use of ETL tools, Excel, or R for data restructuring outside of Tableau (relevance score: 2)', 'The relevance of wide format for specific statistical analysis, such as creating scatter plots, despite the general preference for long format in Tableau-based visualization (relevance score: 1)']}, {'end': 8908.178, 'start': 8508.257, 'title': 'Sales staff vs total sales relationship in india', 'summary': 'Discusses the relationship between the number of sales staff and the total sales generated in different regions of india and suggests the use of scatter plots, histograms, box and whisker plots, pie charts, and bar charts for visualizing the data.', 'duration': 399.921, 'highlights': ['The chapter explains the need to find the relationship between the number of sales staff and the total sales generated in different regions of India, and recommends using scatter plots for this analysis.', 'It also discusses the need for visualizing the speed distribution on highways and city roads, suggesting the use of histograms for this purpose.', 'The chapter further emphasizes the comparison of the distribution of speed across city roads and highways, recommending the use of box and whisker plots for this comparison.', 'It provides insights into visualizing the sales contribution of soaps and toothpaste, suggesting the use of pie charts for percentage comparisons and bar charts for absolute dollar value comparisons.', 'The chapter also highlights the importance of using appropriate visualization techniques for different types of data, such as scatter plots for ratio data, histograms for distribution, bar graphs for categorical data, and box plots for spread and outliers.']}, {'end': 9677.03, 'start': 8908.278, 'title': 'Tableau line charts and csv file troubleshooting', 'summary': 'Covers creating multiple line charts in tableau, troubleshooting csv file issues, and the relevance of sql in tableau development, with an emphasis on the importance of basic sql knowledge and the possibility of encountering questions on tableau and sql during job interviews.', 'duration': 768.752, 'highlights': ['Creating multiple line charts in Tableau Instructions on creating multiple line charts in Tableau by selecting long data format, using Quick Table calculation for cumulative total calculation, and different options for displaying male and female birth rates.', 'Troubleshooting CSV file issues Step-by-step troubleshooting of CSV file issues in Tableau, including identifying date field problems, suggesting the use of LibreOffice, and discussing the possibility of using Google Docs for file management in Tableau Public.', 'Relevance of SQL in Tableau development Discussion on the relevance of SQL in Tableau development, including the need for basic SQL knowledge, live connections to databases, and the potential use of SQL code generation tools like Toad in Tableau.']}], 'duration': 2298.4, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/XpCByF7Q4tc/pics/XpCByF7Q4tc7378630.jpg', 'highlights': ['The presenter demonstrated changing the color and interpreting line charts in Tableau, including converting to dual axis and addressing CSV data formatting issues.', 'The initial higher male birth rate eventually equalized with the female birth rate, but later saw a shift with female birth rate surpassing male birth rate around 1955, emphasizing the importance of accurate data interpretation.', 'The benefits of using long data format in Tableau for visual analysis, including ease of creating different visualizations and saving time in manual work, with long format being generally better for Tableau-based visualization.', 'The chapter explains the need to find the relationship between the number of sales staff and the total sales generated in different regions of India, and recommends using scatter plots for this analysis.', 'Creating multiple line charts in Tableau Instructions on creating multiple line charts in Tableau by selecting long data format, using Quick Table calculation for cumulative total calculation, and different options for displaying male and female birth rates.']}], 'highlights': ["Tableau's demand is increasing, leading in career opportunities and industry adoption.", 'Visual analytics aids in identifying trends, patterns, and relationships in complex and large datasets.', 'The chapter explains the categorization of data into nominal, ordinal, and ratio types, providing examples and characteristics of each type.', 'Scatterplot is utilized when exploring the relationship between two ratio data sets, such as temperature and ice cream sales, to determine the correlation and visualize the impact.', 'The dataset includes information for 195 different cars, covering details such as make, fuel type, aspiration, doors, body style, and other features.', "Horsepower is considered as a determinant of a car's power, with higher horsepower indicating greater power and ability to run at higher speeds.", 'The process of importing data into Tableau for analysis using a CSV file is detailed, including practical steps and troubleshooting guidance.', 'Creating scatter plots and understanding chart categories in Tableau, with future sessions on advanced visualization and dashboards.', 'Histograms are used to figure out the distribution of continuous ratio data, such as height, weight, currency, salary, and age.', 'Utilizing bin size and label placement in histograms enhances the visualization and comprehension of data distribution in Tableau, allowing for a more insightful analysis of the frequency of cars in different categories.', 'Boxplot is a useful tool for identifying outliers and for significance testing, providing practical applications in data analysis.', 'Descriptive statistics involves measures like mean, median, mode, standard deviation, range, and interquartile range.', 'Pie charts are used to show the breakup of the entire population into its contributing components or categories, and should be created only when there are four or less categories.', 'Creating line charts in Tableau for trend analysis with male and female birth rates.', 'The presenter demonstrated changing the color and interpreting line charts in Tableau, including converting to dual axis and addressing CSV data formatting issues.', 'The initial higher male birth rate eventually equalized with the female birth rate, but later saw a shift with female birth rate surpassing male birth rate around 1955, emphasizing the importance of accurate data interpretation.']}