title
Tableau Interview Questions & Answers | Top Tableau Interview Questions For 2022 | FAQ | Simplilearn

description
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=Tableau-Kkg27cnLc1I&utm_medium=Descriptionff&utm_source=youtube 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=Tableau-Kkg27cnLc1I&utm_medium=Descriptionff&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=Tableau-Kkg27cnLc1I&utm_medium=Descriptionff&utm_source=youtube 🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=Tableau-Kkg27cnLc1I&utm_medium=Descriptionff&utm_source=youtube This Tableau interview questions and answersvideo will help you to get prepared for Tableau job interviews. If you’re moving into the field of data analytics or you’re moving up the ladder and need Tableau skills, you’ll probably be interviewing for a job someday soon. We’re here to help, with the key Tableau job interview questions along with their best answers for you to think about ahead of time. Some of the Tableau interview questions discussed in this video are mentioned below. Click on the timestamps to directly jump to that particular question. 1. What are the data types supported in Tableau? ( 00:14 ) - Tableau Interview Experience 2. What do you understand by dimensions and measures? ( 00:54 ) - Tableau Interview Experience 3. What do you understand by Discrete and Continuous in Tableau? ( 01:46 ) - Tableau Interview Experience 4. What are filters? Name the different filters in Tableau. ( 03:49 ) - Tableau Interview Experience 5. There are three customer segments in the Superstore dataset. What per cent of the total profits is associated with the Corporate segment? ( 05:29 ) - Tableau Interview Experience 6. What are the different joins in Tableau? Give example ( 07:06 ) - Tableau Interview Experience 7. What is the difference between Join and Blending? ( 08:48 ) - Tableau Interview Experience 8. What is the difference b/w Live and Extract? ( 10:57 ) - Tableau Interview Experience 9. What is a Calculated Field? How will you create one? ( 12:29 ) - Tableau Interview Experience 10. How can you display the top five and last five sales in the same view? ( 14:58 ) - Tableau Interview Experience 11. Is there any difference between Sets and Groups, in Tableau? ( 17:09 ) - Tableau Interview Experience 12. What is a Parameter in Tableau? Give an example. ( 20:47 ) - Tableau Interview Experience 13. What is the difference between Treemaps and Heat maps? ( 22:32 ) - Tableau Interview Experience 14. What is the difference between .twbx and .twb? ( 26:25 ) - Tableau Interview 15. Explain the difference b/w Tableau worksheet, dashboard, story, and workbook? ( 27:29 ) 16. What do you understand by Blended Axis? ( 29:54 ) 17. What is the use of dual-axis? How do you create one? ( 31:28 ) 18. What will the following function return? - Left(3, “Tableau”) ( 34:04 ) 19. How do you handle Null and other special values? ( 35:11 ) 20. Find the top product subcategories by Sales within each delivery method. Which sub-category is ranked #2 for first-class ship mode? ( 37:32 ) 21. Find the customer with the lowest overall profit. What is his/her profit ratio? ( 39:58 ) 22. What is the Rank function in Tableau? ( 41:30 ) 23. How can you embed a webpage in a dashboard? ( 45:41 ) 24. Design a view to show region wise profit and sales? ( 47:36 ) 25. How can you optimize the performance of a dashboard? ( 49:06 ) 26. Which visualization will be used in the given scenarios: ( 50:17 ) 27. What will you do if some country/province (any geographical entity) is missing and displaying a null when you use map view? ( 53:03 ) 28. What is LOD expression? ( 54:40 ) 🔥 Enrol for FREE Tableau Course & Get your Completion Certificate: https://www.simplilearn.com/skillup-free-online-courses?utm_campaign=Skillup-Tableau&utm_medium=Description&utm_source=youtube You can also go through the Slides here: https://goo.gl/3VUq2u. Watch more videos on Tableau Training: https://www.youtube.com/watch?v=YlSuzn8WvgM&list=PLEiEAq2VkUUJEvrsey26P-Bj4Vk6BLBVC #TableauInterviewExperience #Tableau #TableauTraining #TableauCertification #TableauDeskTop10 #BusinessAnalytics #DataScience #Simplilearn ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. 👉 Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=Tableau-Kkg27cnLc1I&utm_medium=Description&utm_source=youtube

detail
{'title': 'Tableau Interview Questions & Answers | Top Tableau Interview Questions For 2022 | FAQ | Simplilearn', 'heatmap': [{'end': 1298.256, 'start': 1242.055, 'weight': 0.912}, {'end': 1892.628, 'start': 1811.611, 'weight': 0.805}, {'end': 2836.893, 'start': 2711.032, 'weight': 0.728}], 'summary': 'Covers tableau interview questions, data analysis basics, filters, data blending, calculated fields, visualizations, file formats, handling null values, customer profit analysis, dashboard design and optimization, map visualization, and level of detail calculations.', 'chapters': [{'end': 229.098, 'segs': [{'end': 51.994, 'src': 'embed', 'start': 25.645, 'weight': 0, 'content': [{'end': 34.508, 'text': "In Tableau you can tell what kind of data type you have so when you're on the data source tab You can see that this is numerical and this is string.", 'start': 25.645, 'duration': 8.863}, {'end': 35.749, 'text': 'Here we have a date.', 'start': 34.828, 'duration': 0.921}, {'end': 37.729, 'text': "We don't have any date times here.", 'start': 35.869, 'duration': 1.86}, {'end': 39.59, 'text': 'That would have the little clock icon.', 'start': 37.749, 'duration': 1.841}, {'end': 41.671, 'text': 'And we also have geographical.', 'start': 39.83, 'duration': 1.841}, {'end': 46.612, 'text': 'These are set by default, and you can change them by clicking on the icon.', 'start': 42.191, 'duration': 4.421}, {'end': 51.994, 'text': "And say we wanted row ID to allow text, so we'll change it to string.", 'start': 47.353, 'duration': 4.641}], 'summary': 'In tableau, you can identify data types and make changes, such as converting row id to string.', 'duration': 26.349, 'max_score': 25.645, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I25645.jpg'}, {'end': 143.906, 'src': 'embed', 'start': 91.881, 'weight': 1, 'content': [{'end': 102.486, 'text': 'Did you know that Tableau automatically assigns each field a data type and a role, and that it automatically aggregates your measures using sum?', 'start': 91.881, 'duration': 10.605}, {'end': 105.828, 'text': 'But you can change what the default aggregation is.', 'start': 102.806, 'duration': 3.022}, {'end': 107.409, 'text': 'Question 3.', 'start': 106.388, 'duration': 1.021}, {'end': 115.252, 'text': 'What do you understand by discrete and continuous in Tableau? So we have discrete values and continuous values.', 'start': 107.409, 'duration': 7.843}, {'end': 119.954, 'text': 'Discrete is represented as blue and continuous is represented as green.', 'start': 115.512, 'duration': 4.442}, {'end': 121.595, 'text': "So let's look in Tableau.", 'start': 120.295, 'duration': 1.3}, {'end': 129.579, 'text': 'When we go to our worksheet, you can see that all of the dimensions are automatically blue and all of the measures are green.', 'start': 121.615, 'duration': 7.964}, {'end': 135.442, 'text': 'However, you can have a continuous dimension and you can have a discrete measure.', 'start': 130.158, 'duration': 5.284}, {'end': 141.043, 'text': 'So we have discrete dimensions, which is a blue dimension, but also continuous dimensions.', 'start': 136.198, 'duration': 4.845}, {'end': 142.685, 'text': 'And date is a good example of that.', 'start': 141.143, 'duration': 1.542}, {'end': 143.906, 'text': "Let's take a look.", 'start': 143.206, 'duration': 0.7}], 'summary': 'Tableau automatically assigns data types and roles to fields, with dimensions in blue and measures in green. discrete and continuous values are represented as blue and green, respectively.', 'duration': 52.025, 'max_score': 91.881, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I91881.jpg'}], 'start': 3.015, 'title': 'Tableau interview questions and data analysis basics', 'summary': 'Covers common tableau interview questions and data analysis basics, including supported data types and practical examples, as well as understanding dimensions, measures, and default aggregation with the ability to change.', 'chapters': [{'end': 46.612, 'start': 3.015, 'title': 'Tableau interview questions', 'summary': 'Covers common interview questions for tableau positions, including supported data types: string, date, date and time, numerical, boolean, and geographical, with practical examples of identifying and changing data types within tableau.', 'duration': 43.597, 'highlights': ["In Tableau you can tell what kind of data type you have so when you're on the data source tab You can see that this is numerical and this is string. Here we have a date. We don't have any date times here. That would have the little clock icon. And we also have geographical. These are set by default, and you can change them by clicking on the icon. (Practical examples of identifying and changing data types within Tableau)"]}, {'end': 229.098, 'start': 47.353, 'title': 'Tableau data analysis basics', 'summary': 'Covers the basics of tableau data analysis, including understanding dimensions and measures, discrete and continuous values, and default aggregation of measures, which can be changed.', 'duration': 181.745, 'highlights': ['Dimensions are qualitative and can be used to categorize data, while measures are quantitative and can be aggregated, for example, by summing sales or calculating average profit. Dimensions are qualitative and can be used for categorizing data, while measures are quantitative and can be aggregated, for example, by summing sales or calculating average profit.', 'Tableau automatically assigns each field a data type and a role, and it automatically aggregates measures using sum, which can be customized to change the default aggregation. Tableau automatically assigns each field a data type and a role, and it automatically aggregates measures using sum, which can be customized to change the default aggregation.', 'Explanation of discrete and continuous values in Tableau, with discrete values represented as blue and continuous values represented as green, and the ability to have a continuous dimension and a discrete measure. Explanation of discrete and continuous values in Tableau, with discrete values represented as blue and continuous values represented as green, and the ability to have a continuous dimension and a discrete measure.']}], 'duration': 226.083, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3015.jpg', 'highlights': ['Practical examples of identifying and changing data types within Tableau', 'Explanation of discrete and continuous values in Tableau, with discrete values represented as blue and continuous values represented as green, and the ability to have a continuous dimension and a discrete measure', 'Tableau automatically assigns each field a data type and a role, and it automatically aggregates measures using sum, which can be customized to change the default aggregation']}, {'end': 624.993, 'segs': [{'end': 297.601, 'src': 'embed', 'start': 253.509, 'weight': 1, 'content': [{'end': 259.273, 'text': "But also if you can remember what order they apply in, that'll get you some definite bonus points in your interview.", 'start': 253.509, 'duration': 5.764}, {'end': 265.898, 'text': 'We have extract filters that filter the data as it extracts, and it will affect how big your extract is.', 'start': 259.733, 'duration': 6.165}, {'end': 271.582, 'text': 'We also have data source filters here, which will filter the data out of the data source.', 'start': 266.178, 'duration': 5.404}, {'end': 274.204, 'text': 'However, the extract will still be the same size.', 'start': 271.682, 'duration': 2.522}, {'end': 277.566, 'text': "So let's take a look at this handy visualization.", 'start': 274.424, 'duration': 3.142}, {'end': 280.268, 'text': 'that Tableau has on their website.', 'start': 278.507, 'duration': 1.761}, {'end': 285.092, 'text': 'We have the order of operations and in blue we have our filters.', 'start': 280.669, 'duration': 4.423}, {'end': 290.376, 'text': "So extracts is first and it filters down your extract to just what you've selected.", 'start': 285.772, 'duration': 4.604}, {'end': 294.499, 'text': 'Then we have data source filters that will apply to the entire data source.', 'start': 290.396, 'duration': 4.103}, {'end': 297.601, 'text': 'So any visualization that uses that data source will have these filters.', 'start': 294.859, 'duration': 2.742}], 'summary': 'Understanding the order of operations in tableau can impact data extraction and filtering, leading to bonus points in interviews.', 'duration': 44.092, 'max_score': 253.509, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I253509.jpg'}, {'end': 390.504, 'src': 'embed', 'start': 364.572, 'weight': 2, 'content': [{'end': 369.656, 'text': "Also, you can comment below on what your answer is and we'll see if we can all get the right thing.", 'start': 364.572, 'duration': 5.084}, {'end': 371.177, 'text': "So let's build this.", 'start': 370.376, 'duration': 0.801}, {'end': 374.538, 'text': 'three customer segments in the Superstore data set.', 'start': 371.917, 'duration': 2.621}, {'end': 378.86, 'text': 'What percent of the total profits, total profits is associated with corporate segment.', 'start': 374.618, 'duration': 4.242}, {'end': 382.861, 'text': "Great So we're going to bring on our segments.", 'start': 379.34, 'duration': 3.521}, {'end': 385.242, 'text': 'And we have consumer, corporate, and home office.', 'start': 383.321, 'duration': 1.921}, {'end': 388.923, 'text': "And let's bring on our total profit.", 'start': 385.682, 'duration': 3.241}, {'end': 390.504, 'text': 'So I just did that by double clicking.', 'start': 388.984, 'duration': 1.52}], 'summary': 'Analyzing superstore data to determine corporate segment profits.', 'duration': 25.932, 'max_score': 364.572, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I364572.jpg'}, {'end': 438.309, 'src': 'embed', 'start': 410.003, 'weight': 0, 'content': [{'end': 418.577, 'text': 'we wanted to know the percent of total profits associated with the corporate segment, And the corporate segment has 32.12% of the total profits.', 'start': 410.003, 'duration': 8.574}, {'end': 423.221, 'text': "And here's our solution with 32.12%.", 'start': 419.258, 'duration': 3.963}, {'end': 425.684, 'text': 'So did you get it right? Comment below if you got that.', 'start': 423.221, 'duration': 2.463}, {'end': 429.467, 'text': 'What are the different joins in Tableau? Give an example.', 'start': 426.224, 'duration': 3.243}, {'end': 433.627, 'text': 'So in Tableau, you can join your data.', 'start': 430.027, 'duration': 3.6}, {'end': 438.309, 'text': 'So if we wanted to look at orders and tie it to people,', 'start': 433.907, 'duration': 4.402}], 'summary': 'The corporate segment accounts for 32.12% of total profits.', 'duration': 28.306, 'max_score': 410.003, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I410003.jpg'}, {'end': 616.029, 'src': 'embed', 'start': 585.418, 'weight': 4, 'content': [{'end': 588.959, 'text': "So the major difference, what you're going to really want to take away from this,", 'start': 585.418, 'duration': 3.541}, {'end': 599.262, 'text': 'is that blending is from two separate tableau data sources and that joining is all within one data source and it ends up just being one data source in the end.', 'start': 588.959, 'duration': 10.303}, {'end': 600.842, 'text': 'In blending,', 'start': 599.582, 'duration': 1.26}, {'end': 608.305, 'text': 'each data source contains its own set of dimensions and measures And when you join it will combine it into one set of dimensions and measures.', 'start': 600.842, 'duration': 7.463}, {'end': 610.226, 'text': "So let's go back to our example here.", 'start': 608.525, 'duration': 1.701}, {'end': 611.567, 'text': "Let's bring on people.", 'start': 610.446, 'duration': 1.121}, {'end': 616.029, 'text': "It is automatically said we're going to join it on region and we're going to do an inner join.", 'start': 612.067, 'duration': 3.962}], 'summary': 'Blending involves separate data sources, joining combines dimensions and measures.', 'duration': 30.611, 'max_score': 585.418, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I585418.jpg'}], 'start': 229.658, 'title': 'Tableau filters and data analysis', 'summary': 'Covers the purpose of filters in tableau, types of filters such as extract, data source, and context filters, their impact on data size and visualization outcomes, and demonstrates calculating the percentage of total profits for the corporate segment and discussing joins and blending in tableau.', 'chapters': [{'end': 321.189, 'start': 229.658, 'title': 'Understanding tableau filters', 'summary': 'Explains the purpose of filters in tableau, the different types of filters including extract filters, data source filters, and context filters, and the order in which they apply, emphasizing the impact on data size and visualization outcomes.', 'duration': 91.531, 'highlights': ['The different types of filters in Tableau include extract filters, data source filters, and context filters, each with specific impacts on data size and visualization outcomes.', 'Remembering the order in which filters apply can provide an advantage in an interview, with extract filters being the first to filter the data, followed by data source filters and context filters.', 'Extract filters affect the size of the extract, while data source filters apply to the entire data source, and context filters apply before some level of details and sets, impacting dimensions and measures differently.', 'Table calculation filters are the last type of filter in Tableau, with dimensions filters applying before measure filters.']}, {'end': 624.993, 'start': 321.189, 'title': 'Tableau data analysis', 'summary': 'Explains how to calculate the percentage of total profits associated with the corporate segment in the superstore dataset using tableau, and also discusses the different joins and blending in tableau.', 'duration': 303.804, 'highlights': ['The corporate segment has 32.12% of the total profits. The percentage of total profits associated with the corporate segment in the Superstore dataset is 32.12%.', 'Different types of joins in Tableau, including inner join, left join, right join, and outer join, are explained. The chapter explains different types of joins in Tableau, such as inner join, left join, right join, and outer join, providing a comprehensive understanding of each type.', 'Blending in Tableau is used when combining data from two separate Tableau data sources, while joining is done within a single data source. The distinction between blending and joining in Tableau is highlighted, emphasizing that blending involves data from two separate Tableau data sources, while joining is performed within a single data source.']}], 'duration': 395.335, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I229658.jpg', 'highlights': ['The corporate segment has 32.12% of the total profits.', 'Different types of filters in Tableau include extract filters, data source filters, and context filters, each with specific impacts on data size and visualization outcomes.', 'The percentage of total profits associated with the corporate segment in the Superstore dataset is 32.12%.', 'Remembering the order in which filters apply can provide an advantage in an interview, with extract filters being the first to filter the data, followed by data source filters and context filters.', 'The distinction between blending and joining in Tableau is highlighted, emphasizing that blending involves data from two separate Tableau data sources, while joining is performed within a single data source.']}, {'end': 886.652, 'segs': [{'end': 688.88, 'src': 'embed', 'start': 646.557, 'weight': 0, 'content': [{'end': 653.301, 'text': "we would be able to pull in from this set some information and we'd pull in from this set some other information.", 'start': 646.557, 'duration': 6.744}, {'end': 657.404, 'text': "So that's a visual difference between blending and joining.", 'start': 653.701, 'duration': 3.703}, {'end': 663.707, 'text': "Question number eight is, what is the difference between a live and an extract? So first we'll talk about live.", 'start': 657.684, 'duration': 6.023}, {'end': 667.79, 'text': "And we'll say that your dashboard is connected live to a database.", 'start': 664.288, 'duration': 3.502}, {'end': 675.914, 'text': 'And so a live connection will query that database every time you open up the dashboard or visualization,', 'start': 669.511, 'duration': 6.403}, {'end': 678.475, 'text': "so that you're getting the most recent information each time.", 'start': 675.914, 'duration': 2.561}, {'end': 683.037, 'text': "And it's useful for if you need information that's a little bit more real time.", 'start': 678.875, 'duration': 4.162}, {'end': 686.739, 'text': 'However, it can be slower, especially if your queries are complicated.', 'start': 683.157, 'duration': 3.582}, {'end': 688.88, 'text': 'With an extract.', 'start': 687.179, 'duration': 1.701}], 'summary': 'Difference between live and extract connections explained for database querying.', 'duration': 42.323, 'max_score': 646.557, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I646557.jpg'}, {'end': 782.893, 'src': 'embed', 'start': 708.891, 'weight': 2, 'content': [{'end': 714.734, 'text': "they won't see that change on your dashboard until the next time the refresh runs for your extract.", 'start': 708.891, 'duration': 5.843}, {'end': 724.638, 'text': 'In Tableau, you can set if you want the connection to be live or extract when you first are making your data source.', 'start': 715.314, 'duration': 9.324}, {'end': 726.759, 'text': 'And this is in Tableau Desktop.', 'start': 725.038, 'duration': 1.721}, {'end': 730.321, 'text': "In Tableau Public, you don't have that option.", 'start': 727.159, 'duration': 3.162}, {'end': 740.065, 'text': "Did you know that the reason that extracts are faster is because Tableau doesn't need to access the database each time it builds the visualization?", 'start': 730.741, 'duration': 9.324}, {'end': 749.03, 'text': "And did you know that you can set up a refresh schedule on Tableau's server in order to be able to see your extracted data update?", 'start': 740.685, 'duration': 8.345}, {'end': 753.794, 'text': 'Question 9, what is a calculated field and how will you create one?', 'start': 749.651, 'duration': 4.143}, {'end': 762.12, 'text': 'So if we look at our data set here, we have the opportunity to see the difference between order date and ship date.', 'start': 754.354, 'duration': 7.766}, {'end': 766.083, 'text': 'So to create a calculated field, you click,', 'start': 762.601, 'duration': 3.482}, {'end': 773.129, 'text': 'create calculated field with this drop down arrow at the top or you can right click in white space create calculated field.', 'start': 766.083, 'duration': 7.046}, {'end': 778.165, 'text': "Then you give it a name and we're going to call it shipping delay.", 'start': 773.919, 'duration': 4.246}, {'end': 782.893, 'text': 'And we are going to do a date diff.', 'start': 778.185, 'duration': 4.708}], 'summary': 'Tableau offers extraction options and calculated fields for data analysis.', 'duration': 74.002, 'max_score': 708.891, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I708891.jpg'}, {'end': 855.26, 'src': 'embed', 'start': 824.701, 'weight': 6, 'content': [{'end': 834.124, 'text': 'And then we can bring a shipping delay here and we can see the number of days that it took between the order date and the ship date.', 'start': 824.701, 'duration': 9.423}, {'end': 838.506, 'text': 'We could also duplicate a calculated field.', 'start': 834.704, 'duration': 3.802}, {'end': 840.328, 'text': 'So now we have shipping delay copy.', 'start': 838.806, 'duration': 1.522}, {'end': 847.133, 'text': "And we're going to call this average shipping delay.", 'start': 843.33, 'duration': 3.803}, {'end': 855.26, 'text': "And we're going to encapsulate it inside an average function.", 'start': 848.254, 'duration': 7.006}], 'summary': 'Analyzing shipping delay by calculating average number of days between order and ship date.', 'duration': 30.559, 'max_score': 824.701, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I824701.jpg'}], 'start': 625.393, 'title': 'Tableau data blending and calculated fields', 'summary': 'Discusses tableau data blending, joining, live and extract connections, as well as the creation of calculated fields. it covers differences between blending and joining, live and extract connections, and includes the process of creating a calculated field to determine shipping delay and finding the average delay.', 'chapters': [{'end': 753.794, 'start': 625.393, 'title': 'Tableau blending, joining, live and extract', 'summary': 'Discusses the differences between blending and joining multiple data sources in tableau, the distinctions between live and extract connections, and the benefits and limitations of each, concluding with an overview of calculated fields creation.', 'duration': 128.401, 'highlights': ['Blending vs joining: Explains the visual difference between blending and joining in Tableau, showcasing the ability to pull information from separate data sets.', 'Live vs extract: Details the differences between live and extract connections in Tableau, highlighting the real-time querying of live connections and the faster access of data in extracts.', "Refresh schedule for extracts: Mentions that Tableau's server allows setting up a refresh schedule for extracted data to keep it updated.", 'Setting connection type in Tableau: States that in Tableau Desktop, users can choose between live and extract connections when creating a data source, while this option is not available in Tableau Public.', "Reason for extract speed: Reveals that Tableau's extracts are faster because they do not need to access the database each time a visualization is built."]}, {'end': 886.652, 'start': 754.354, 'title': 'Creating calculated field for shipping delay', 'summary': 'Explains the process of creating a calculated field called shipping delay to determine the difference in days between order date and ship date, and then averaging it to find the average shipping delay.', 'duration': 132.298, 'highlights': ['The process of creating a calculated field named shipping delay to determine the difference in days between order date and ship date is outlined, providing a method for analyzing shipping delays (e.g., 5 days, 10 days, etc.).', 'Creating a duplicate of the shipping delay field and encapsulating it in an average function allows for the calculation of the average shipping delay, offering a way to quantify the average delay in shipping orders.']}], 'duration': 261.259, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I625393.jpg', 'highlights': ['Blending vs joining: Explains visual difference, ability to pull info from separate data sets', 'Live vs extract: Details differences, real-time querying of live connections, faster access in extracts', "Refresh schedule for extracts: Tableau's server allows setting up a refresh schedule for extracted data", 'Setting connection type in Tableau: In Tableau Desktop, users can choose between live and extract connections', "Reason for extract speed: Tableau's extracts are faster as they do not need to access the database each time", 'Creating calculated field shipping delay: Outlines process to determine difference in days between order date and ship date', 'Calculating average shipping delay: Creating a duplicate of shipping delay field and encapsulating it in an average function']}, {'end': 1581.099, 'segs': [{'end': 1097.001, 'src': 'embed', 'start': 1046.926, 'weight': 0, 'content': [{'end': 1052.712, 'text': 'So you could say sets are more complex and you can use conditions to create the sets,', 'start': 1046.926, 'duration': 5.786}, {'end': 1056.675, 'text': 'and you can also use multiple dimensions and measures to create the sets.', 'start': 1052.712, 'duration': 3.963}, {'end': 1061.156, 'text': 'For example, here we create a group of subcategory.', 'start': 1057.415, 'duration': 3.741}, {'end': 1064.697, 'text': 'So we grab all of these things together and can group it.', 'start': 1061.176, 'duration': 3.521}, {'end': 1071.238, 'text': "And that will be, we'll have copiers and envelopes, and then we'll have one group of all of these together.", 'start': 1065.137, 'duration': 6.101}, {'end': 1078.039, 'text': 'Over here, you could create a set that looks at sales and profits to create a set.', 'start': 1071.878, 'duration': 6.161}, {'end': 1081.84, 'text': 'So the best way I can describe this is by looking at what we did here.', 'start': 1078.439, 'duration': 3.401}, {'end': 1093.418, 'text': "And so we were able to use dynamic filtering here to create our sets and where we'll look at the top five or the bottom five,", 'start': 1082.46, 'duration': 10.958}, {'end': 1097.001, 'text': "and let's do the same thing we did there, but use a group.", 'start': 1093.418, 'duration': 3.583}], 'summary': 'Creating sets with conditions and multiple dimensions and measures for dynamic filtering and grouping.', 'duration': 50.075, 'max_score': 1046.926, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1046925.jpg'}, {'end': 1298.256, 'src': 'heatmap', 'start': 1242.055, 'weight': 0.912, 'content': [{'end': 1246.882, 'text': 'Also, you need to know that groups cannot be used in calculated fields, but sets can.', 'start': 1242.055, 'duration': 4.827}, {'end': 1248.964, 'text': 'Question 12.', 'start': 1247.603, 'duration': 1.361}, {'end': 1251.706, 'text': 'What is a parameter in Tableau? And give an example.', 'start': 1248.964, 'duration': 2.742}, {'end': 1256.57, 'text': 'A parameter is a dynamic value that a customer could select.', 'start': 1252.387, 'duration': 4.183}, {'end': 1262.474, 'text': 'And you can use it to replace constant values in calculations, filters, and reference lines.', 'start': 1257.29, 'duration': 5.184}, {'end': 1269.48, 'text': 'So for example, here we determined we wanted bottom five and top five customers.', 'start': 1262.955, 'duration': 6.525}, {'end': 1271.281, 'text': "But let's give them some options.", 'start': 1269.86, 'duration': 1.421}, {'end': 1272.782, 'text': "So we'll create a parameter.", 'start': 1271.321, 'duration': 1.461}, {'end': 1276.045, 'text': "And we'll call it select.", 'start': 1272.802, 'duration': 3.243}, {'end': 1284.39, 'text': 'number of top bottom customers.', 'start': 1278.348, 'duration': 6.042}, {'end': 1298.256, 'text': "And we're going to let it be a range with a minimum of five and a maximum of 20 and a step size of five.", 'start': 1286.991, 'duration': 11.265}], 'summary': 'Parameters in tableau are dynamic values that can replace constant values in calculations, filters, and reference lines. for example, a parameter can be used to select a range of top and bottom customers, with a minimum of five, maximum of 20, and a step size of five.', 'duration': 56.201, 'max_score': 1242.055, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1242055.jpg'}, {'end': 1284.39, 'src': 'embed', 'start': 1257.29, 'weight': 2, 'content': [{'end': 1262.474, 'text': 'And you can use it to replace constant values in calculations, filters, and reference lines.', 'start': 1257.29, 'duration': 5.184}, {'end': 1269.48, 'text': 'So for example, here we determined we wanted bottom five and top five customers.', 'start': 1262.955, 'duration': 6.525}, {'end': 1271.281, 'text': "But let's give them some options.", 'start': 1269.86, 'duration': 1.421}, {'end': 1272.782, 'text': "So we'll create a parameter.", 'start': 1271.321, 'duration': 1.461}, {'end': 1276.045, 'text': "And we'll call it select.", 'start': 1272.802, 'duration': 3.243}, {'end': 1284.39, 'text': 'number of top bottom customers.', 'start': 1278.348, 'duration': 6.042}], 'summary': 'Create a parameter for selecting top and bottom customers in calculations and filters.', 'duration': 27.1, 'max_score': 1257.29, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1257290.jpg'}, {'end': 1438.504, 'src': 'embed', 'start': 1407.844, 'weight': 3, 'content': [{'end': 1409.765, 'text': 'We can also double click on profit.', 'start': 1407.844, 'duration': 1.921}, {'end': 1412.728, 'text': 'We can also bring profit onto label.', 'start': 1411.107, 'duration': 1.621}, {'end': 1415.63, 'text': "And we'll change this to square.", 'start': 1413.589, 'duration': 2.041}, {'end': 1418.392, 'text': "And now it's marked at what everything is.", 'start': 1415.65, 'duration': 2.742}, {'end': 1425.596, 'text': "So a heat map will use color to draw your eye to the places where there's heat or maybe activity.", 'start': 1418.772, 'duration': 6.824}, {'end': 1428.798, 'text': 'We could also use size in this case.', 'start': 1426.076, 'duration': 2.722}, {'end': 1431.72, 'text': "So it's not just defined by color necessarily.", 'start': 1429.198, 'duration': 2.522}, {'end': 1435.462, 'text': 'maybe we want the size to be defined by sales.', 'start': 1432.18, 'duration': 3.282}, {'end': 1438.504, 'text': "so we get things that are bigger but they're blue,", 'start': 1435.462, 'duration': 3.042}], 'summary': 'Demonstration of using color and size in a data visualization to show profit and sales.', 'duration': 30.66, 'max_score': 1407.844, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1407844.jpg'}, {'end': 1487.517, 'src': 'embed', 'start': 1460.585, 'weight': 4, 'content': [{'end': 1464.067, 'text': 'A tree map is used to represent hierarchical data.', 'start': 1460.585, 'duration': 3.482}, {'end': 1470.251, 'text': "Now hierarchy is the term you need to remember when you're talking about the difference between a tree map and a heat map.", 'start': 1464.127, 'duration': 6.124}, {'end': 1476.288, 'text': 'In the heat map, none of these boxes have to do with the hierarchy with each other.', 'start': 1471.084, 'duration': 5.204}, {'end': 1483.234, 'text': 'Whereas with the tree map, you can see that this box has a thick white line between it and the other ones.', 'start': 1476.588, 'duration': 6.646}, {'end': 1487.517, 'text': 'And that means that that section are all connected.', 'start': 1483.694, 'duration': 3.823}], 'summary': 'A tree map uses hierarchy to represent data visually, unlike a heat map.', 'duration': 26.932, 'max_score': 1460.585, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1460585.jpg'}], 'start': 887.352, 'title': 'Creating visualizations and comparing tree maps vs heat maps', 'summary': 'Demonstrates using sets and groups in tableau to create visualizations, including top and bottom sales, combined sets, and parameters. it also explains the differences between tree maps and heat maps, emphasizing their visual representations and data comparisons.', 'chapters': [{'end': 1346.206, 'start': 887.352, 'title': 'Creating visualizations using sets and groups', 'summary': 'Demonstrates how to use sets to display top and bottom sales in the same visualization, create combined sets, and explains the difference between sets and groups in tableau. additionally, it explores the concept of parameters and how they can be used to replace constant values in calculations, filters, and reference lines.', 'duration': 458.854, 'highlights': ['The chapter demonstrates how to use sets to display top and bottom sales in the same visualization. Using sets, the chapter showcases the creation of top and bottom customer sets based on profit, allowing for dynamic filtering and visualization of both top and bottom sales.', 'The chapter explains the difference between sets and groups in Tableau. It clarifies that sets can have conditions, be based on multiple dimensions and measures, while groups are simpler, using only one dimension to determine the group. Additionally, it emphasizes that groups cannot be used in calculated fields, but sets can.', 'The concept of parameters and how they can be used to replace constant values in calculations, filters, and reference lines is explored. The chapter illustrates the creation of a parameter for selecting the number of top and bottom customers, allowing for dynamic user selection and its integration into sets for dynamic visualization.']}, {'end': 1581.099, 'start': 1346.206, 'title': 'Tree maps vs heat maps', 'summary': 'Explains the differences between tree maps and heat maps, highlighting that heat maps use color and size for comparison, while tree maps represent hierarchical data, with examples and comparisons of their visual representations.', 'duration': 234.893, 'highlights': ['Heat maps use color and size for comparison, allowing users to visualize profit and sales data with different color and size representations. Heat maps compare categories using size and color, allowing visualization of profit and sales data with different color and size representations.', 'Tree maps represent hierarchical data, enabling users to compare categories and subcategories with a hierarchical structure, as well as visualizing profit and sales data. Tree maps are used to represent hierarchical data, enabling users to compare categories and subcategories with a hierarchical structure, as well as visualizing profit and sales data.', 'Tree maps provide a hierarchical structure for comparison, making it easier to compare different categories and subcategories based on profit and sales data. Tree maps provide a hierarchical structure for comparison, making it easier to compare different categories and subcategories based on profit and sales data.']}], 'duration': 693.747, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I887352.jpg', 'highlights': ['The chapter demonstrates using sets to display top and bottom sales in the same visualization, allowing for dynamic filtering and visualization.', 'Sets can have conditions, be based on multiple dimensions and measures, while groups are simpler, using only one dimension to determine the group.', 'The concept of parameters and how they can be used to replace constant values in calculations, filters, and reference lines is explored.', 'Heat maps use color and size for comparison, allowing users to visualize profit and sales data with different color and size representations.', 'Tree maps represent hierarchical data, enabling users to compare categories and subcategories with a hierarchical structure, as well as visualizing profit and sales data.']}, {'end': 2103.241, 'segs': [{'end': 1649.883, 'src': 'embed', 'start': 1606.196, 'weight': 0, 'content': [{'end': 1610.939, 'text': 'However, the TWB just contains instructions about how to interact with the data source.', 'start': 1606.196, 'duration': 4.743}, {'end': 1617.563, 'text': "So, when it's building a visualization, Tableau will look at the data source and then build the visualization.", 'start': 1611.079, 'duration': 6.484}, {'end': 1619.544, 'text': 'With an extract.', 'start': 1618.023, 'duration': 1.521}, {'end': 1622.105, 'text': 'it contains all of the information that you need,', 'start': 1619.544, 'duration': 2.561}, {'end': 1629.529, 'text': "so all the data is wrapped up inside of there and there's no connection that has to be made between Tableau and the data source,", 'start': 1622.105, 'duration': 7.424}, {'end': 1630.77, 'text': "because it's all right inside.", 'start': 1629.529, 'duration': 1.241}, {'end': 1637.334, 'text': "Whereas with the TWB, It has to connect to the data source or else it doesn't have the data to build the visualizations.", 'start': 1630.91, 'duration': 6.424}, {'end': 1641.377, 'text': 'It just knows it has the instructions of what to do with that data.', 'start': 1637.495, 'duration': 3.882}, {'end': 1648.462, 'text': 'So the biggest difference is TWBX has the data inside of it, whereas a TWB only has the instructions.', 'start': 1641.497, 'duration': 6.965}, {'end': 1649.883, 'text': 'Question 15.', 'start': 1648.783, 'duration': 1.1}], 'summary': 'Twbx contains data, twb only contains instructions.', 'duration': 43.687, 'max_score': 1606.196, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1606196.jpg'}, {'end': 1780.069, 'src': 'embed', 'start': 1751.026, 'weight': 4, 'content': [{'end': 1755.447, 'text': 'So the differences are the workbook contains the sheets, and the dashboards are the stories.', 'start': 1751.026, 'duration': 4.421}, {'end': 1761.809, 'text': 'The worksheet is a single view, dashboard is multiple views, and a story is a sequence.', 'start': 1756.167, 'duration': 5.642}, {'end': 1765.67, 'text': "A sequence is a good keyword to remember when you're describing a story.", 'start': 1762.389, 'duration': 3.281}, {'end': 1774.013, 'text': "And did you know that the only place that you can access the dimensions and the measures and custom fields we've made is on a worksheet?", 'start': 1766.231, 'duration': 7.782}, {'end': 1780.069, 'text': "So when you're looking at a dashboard, So on a worksheet, we see dimensions and measures.", 'start': 1774.393, 'duration': 5.676}], 'summary': 'Tableau workbook contains sheets, dashboards are stories, and only worksheets display dimensions and measures.', 'duration': 29.043, 'max_score': 1751.026, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1751026.jpg'}, {'end': 1892.628, 'src': 'heatmap', 'start': 1796.221, 'weight': 5, 'content': [{'end': 1798.382, 'text': 'What do you understand by blended axis?', 'start': 1796.221, 'duration': 2.161}, {'end': 1807.169, 'text': 'With a blended axis, you could use two measures that share an axis, and that means they necessarily have the same scale.', 'start': 1798.963, 'duration': 8.206}, {'end': 1810.23, 'text': "So let's build something with a blended axis.", 'start': 1807.629, 'duration': 2.601}, {'end': 1820.095, 'text': 'So we can make a visualization that looks at sales over time.', 'start': 1811.611, 'duration': 8.484}, {'end': 1822.836, 'text': "We'll bring on order date.", 'start': 1820.695, 'duration': 2.141}, {'end': 1837.554, 'text': "And let's just to order date by month.", 'start': 1831.441, 'duration': 6.113}, {'end': 1838.435, 'text': 'There we go.', 'start': 1838.014, 'duration': 0.421}, {'end': 1840.736, 'text': 'So we can see sales over time.', 'start': 1839.135, 'duration': 1.601}, {'end': 1844.719, 'text': 'And say we wanted to also see profit.', 'start': 1841.237, 'duration': 3.482}, {'end': 1848.722, 'text': 'This is two visualizations that have two different axes.', 'start': 1845.319, 'duration': 3.403}, {'end': 1856.467, 'text': 'But if we wanted them to have the same axes and just the same marks card, you see how I made two different marks cards.', 'start': 1849.262, 'duration': 7.205}, {'end': 1862.772, 'text': "We could bring on measure values and take off all the measures that we don't want.", 'start': 1856.948, 'duration': 5.824}, {'end': 1867.256, 'text': 'we just want.', 'start': 1866.536, 'duration': 0.72}, {'end': 1872.579, 'text': "When we take them off here, it's creating this filter here for measure names.", 'start': 1868.977, 'duration': 3.602}, {'end': 1875.42, 'text': "And let's take off these two extra visualizations.", 'start': 1873.399, 'duration': 2.021}, {'end': 1882.122, 'text': 'And now we have a visualization that has a blended axis for sales over time and profit over time.', 'start': 1875.82, 'duration': 6.302}, {'end': 1886.204, 'text': 'And you can see that they necessarily have the same axis.', 'start': 1882.603, 'duration': 3.601}, {'end': 1887.705, 'text': 'There is no second axis.', 'start': 1886.304, 'duration': 1.401}, {'end': 1892.628, 'text': 'What is the use of a dual axis and how do you create one? Perfect.', 'start': 1888.425, 'duration': 4.203}], 'summary': 'Blended axis allows using two measures with the same scale for visualization, demonstrated by creating a visualization for sales and profit over time.', 'duration': 44.515, 'max_score': 1796.221, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1796221.jpg'}, {'end': 1913.524, 'src': 'embed', 'start': 1873.399, 'weight': 6, 'content': [{'end': 1875.42, 'text': "And let's take off these two extra visualizations.", 'start': 1873.399, 'duration': 2.021}, {'end': 1882.122, 'text': 'And now we have a visualization that has a blended axis for sales over time and profit over time.', 'start': 1875.82, 'duration': 6.302}, {'end': 1886.204, 'text': 'And you can see that they necessarily have the same axis.', 'start': 1882.603, 'duration': 3.601}, {'end': 1887.705, 'text': 'There is no second axis.', 'start': 1886.304, 'duration': 1.401}, {'end': 1892.628, 'text': 'What is the use of a dual axis and how do you create one? Perfect.', 'start': 1888.425, 'duration': 4.203}, {'end': 1897.211, 'text': 'So a dual axis allows you to compare measures and you can have two different scales.', 'start': 1893.028, 'duration': 4.183}, {'end': 1913.524, 'text': "So if we had this same visualization, that same information that we wanted to see with again profit and sales over time, we'll do Great,", 'start': 1897.631, 'duration': 15.893}], 'summary': 'A dual axis visualization allows comparing sales and profit over time with different scales.', 'duration': 40.125, 'max_score': 1873.399, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1873399.jpg'}, {'end': 2103.241, 'src': 'embed', 'start': 2078.609, 'weight': 7, 'content': [{'end': 2084.514, 'text': "That's because the syntax for left is that the string must go first.", 'start': 2078.609, 'duration': 5.905}, {'end': 2088.755, 'text': 'First you say left, then you put the string, and then you put the number.', 'start': 2085.034, 'duration': 3.721}, {'end': 2090.556, 'text': "So let's talk about what left does.", 'start': 2089.056, 'duration': 1.5}, {'end': 2097.859, 'text': 'It returns a specific number of characters from the left, and if you had done it correctly, the left is this side.', 'start': 2090.996, 'duration': 6.863}, {'end': 2103.241, 'text': 'So if you had done the string first and you said you want three, the result would be TAB.', 'start': 2097.939, 'duration': 5.302}], 'summary': "The 'left' function returns characters from the left side of a string. for example, 'left(string, 3)' results in 'tab'.", 'duration': 24.632, 'max_score': 2078.609, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2078609.jpg'}], 'start': 1581.119, 'title': 'Tableau file formats and components', 'summary': "Discusses the differences between twbx and twb file formats, emphasizing the inclusion of data. it also explains tableau worksheet, dashboard, story, and workbook, covering their differences and demonstrating the 'left' function returning an error.", 'chapters': [{'end': 1649.883, 'start': 1581.119, 'title': 'Tableau file formats: twbx vs. twb', 'summary': 'Delves into the differences between twbx and twb file formats in tableau, highlighting that twbx contains all necessary data while twb only includes instructions for visualization, with twbx being a packaged workbook and containing the data within it.', 'duration': 68.764, 'highlights': ['TWBX contains all necessary data while TWB only includes instructions for visualization, making TWBX a packaged workbook and containing the data within it.', 'TWB requires a connection to the data source to build visualizations, while TWBX has the data inside it, eliminating the need for a connection.', 'Tableau will look at the data source and then build the visualization with an extract, which contains all the necessary information wrapped up inside.', 'TWB just contains instructions about how to interact with the data source, whereas TWBX contains all unnecessary information to build a visualization.']}, {'end': 2103.241, 'start': 1649.883, 'title': 'Tableau worksheet, dashboard, story, and workbook', 'summary': "Explains the differences between tableau worksheet, dashboard, story, and workbook, highlighting that a workbook contains sheets, dashboards are multiple views, and a story is a sequence. it also covers blended axis and dual axis, emphasizing the use and creation of each, and concludes with a demonstration of the 'left' function returning an error when the string is not placed first.", 'duration': 453.358, 'highlights': ['The differences between Tableau Worksheet, Dashboard, Story, and Workbook The workbook contains the sheets, dashboards are multiple views, and a story is a sequence.', 'Explanation of blended axis and its use in Tableau Blended axis allows the use of two measures that share an axis with the same scale, demonstrated through a visualization of sales and profit over time.', 'Explanation of dual axis and its use in Tableau Dual axis allows the comparison of measures with two different scales, and by right-clicking on the second pill of the measures and clicking dual axis, the user can achieve this.', "Demonstration of the 'left' function in Tableau The 'left' function returns an error if the syntax is not followed properly, where the string must go first, followed by the number."]}], 'duration': 522.122, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I1581119.jpg', 'highlights': ['TWBX contains all necessary data while TWB only includes instructions for visualization, making TWBX a packaged workbook and containing the data within it.', 'TWB requires a connection to the data source to build visualizations, while TWBX has the data inside it, eliminating the need for a connection.', 'Tableau will look at the data source and then build the visualization with an extract, which contains all the necessary information wrapped up inside.', 'TWB just contains instructions about how to interact with the data source, whereas TWBX contains all unnecessary information to build a visualization.', 'The differences between Tableau Worksheet, Dashboard, Story, and Workbook The workbook contains the sheets, dashboards are multiple views, and a story is a sequence.', 'Explanation of blended axis and its use in Tableau Blended axis allows the use of two measures that share an axis with the same scale, demonstrated through a visualization of sales and profit over time.', 'Explanation of dual axis and its use in Tableau Dual axis allows the comparison of measures with two different scales, and by right-clicking on the second pill of the measures and clicking dual axis, the user can achieve this.', "Demonstration of the 'left' function in Tableau The 'left' function returns an error if the syntax is not followed properly, where the string must go first, followed by the number."]}, {'end': 2400.828, 'segs': [{'end': 2176.46, 'src': 'embed', 'start': 2148.595, 'weight': 3, 'content': [{'end': 2152.436, 'text': 'So you click on your indicator and it will say what do you want to do with these two values.', 'start': 2148.595, 'duration': 3.841}, {'end': 2162.092, 'text': 'If we click filter the data then you can see that it has filtered that blank space and drawn a line connecting those dates in between.', 'start': 2152.496, 'duration': 9.596}, {'end': 2169.776, 'text': 'Even though there is no point for the 29th or the 30th, it goes straight from the 28th to the 31st.', 'start': 2162.652, 'duration': 7.124}, {'end': 2173.519, 'text': "So what's happening on iVisualization is it's adding this filter.", 'start': 2170.177, 'duration': 3.342}, {'end': 2176.46, 'text': 'If we press the back button, we see that filter disappears.', 'start': 2173.959, 'duration': 2.501}], 'summary': 'Demonstrating data filtering and visualization in ivisualization.', 'duration': 27.865, 'max_score': 2148.595, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2148595.jpg'}, {'end': 2305.078, 'src': 'embed', 'start': 2228.596, 'weight': 0, 'content': [{'end': 2231.258, 'text': 'And when you hover, it still shows sales null.', 'start': 2228.596, 'duration': 2.662}, {'end': 2236.482, 'text': 'So when you hover here, you can see the actual amount for sales during that time.', 'start': 2232.978, 'duration': 3.504}, {'end': 2243.11, 'text': 'So if a null in your data means zero, then show at default position is good for you.', 'start': 2237.844, 'duration': 5.266}, {'end': 2252.267, 'text': "And if it doesn't necessarily mean zero, then you can Filter the data, or you can leave it disconnected like this.", 'start': 2243.47, 'duration': 8.797}, {'end': 2254.328, 'text': 'Question 20.', 'start': 2253.007, 'duration': 1.321}, {'end': 2259.49, 'text': 'Find the top product subcategories by sales within each delivery method.', 'start': 2254.328, 'duration': 5.162}, {'end': 2263.031, 'text': 'Which subcategory is ranked number two for first class ship mode?', 'start': 2259.71, 'duration': 3.321}, {'end': 2268.993, 'text': "If you'd like to pause the video and work on this on your own and then see if what you did matches what we did,", 'start': 2263.391, 'duration': 5.602}, {'end': 2270.694, 'text': "then you're welcome to now at this time.", 'start': 2268.993, 'duration': 1.701}, {'end': 2272.634, 'text': 'And comment below what your answer is.', 'start': 2270.994, 'duration': 1.64}, {'end': 2289.173, 'text': 'OK So we want to know by subcategory, And by ship mode, which subcategory ranks the highest for each ship mode? So in sales.', 'start': 2274.255, 'duration': 14.918}, {'end': 2297.015, 'text': "So if we take sales onto the visualization, we can see that by the ship mode, it's already split up.", 'start': 2289.393, 'duration': 7.622}, {'end': 2302.437, 'text': 'And we could see that maybe this one for standard class, it would be chairs.', 'start': 2297.415, 'duration': 5.022}, {'end': 2305.078, 'text': "You can kind of look through and kind of, oh, it's not chairs.", 'start': 2302.497, 'duration': 2.581}], 'summary': 'Analyzing sales data to find top product subcategories by delivery method.', 'duration': 76.482, 'max_score': 2228.596, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2228596.jpg'}], 'start': 2103.661, 'title': 'Handling null values in tableau and sales ranking by ship mode', 'summary': 'Discusses how tableau handles null and special values, including options to filter null values, show data at default position. it also demonstrates how to determine the top product subcategories by sales within each delivery method using table calculation.', 'chapters': [{'end': 2254.328, 'start': 2103.661, 'title': 'Handling null values in tableau', 'summary': 'Discusses how tableau handles null and special values, including options to filter null values, show data at default position, and the impact on visualization.', 'duration': 150.667, 'highlights': ['Tableau is unable to plot null values or zeros or negative values on a logarithmic axis, and it will display an indicator in the lower right corner to indicate this.', 'Filtering the data in Tableau excludes the null values from the visualization and draws a line connecting non-null dates, impacting the visualization.', 'Choosing to show data at the default position in Tableau draws null values at the zero line and allows hovering to view the actual sales amount for null values.', 'Understanding the options to handle null values in Tableau is crucial for accurate data visualization and interpretation.']}, {'end': 2400.828, 'start': 2254.328, 'title': 'Sales ranking by ship mode', 'summary': 'Demonstrates how to determine the top product subcategories by sales within each delivery method, showcasing the process of using table calculation to rank subcategories by sales for different ship modes and identifying the second-ranked subcategory for first class ship mode.', 'duration': 146.5, 'highlights': ['The process involves using table calculation to rank subcategories by sales for different ship modes, enabling the identification of the top product subcategories within each delivery method.', "The demonstration showcases the use of table calculation to identify the second-ranked subcategory, which is 'chairs', for the first class ship mode.", 'The instructor encourages pausing the video to allow viewers to attempt the task independently before comparing their results.', 'The visualization reveals the top-ranking subcategories for each ship mode based on sales, providing a practical understanding of the concept.', 'The chapter emphasizes the importance of understanding how to manipulate table calculations to achieve the desired ranking of subcategories by sales for specific ship modes.']}], 'duration': 297.167, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2103661.jpg', 'highlights': ['Understanding the options to handle null values in Tableau is crucial for accurate data visualization and interpretation.', 'The process involves using table calculation to rank subcategories by sales for different ship modes, enabling the identification of the top product subcategories within each delivery method.', 'The chapter emphasizes the importance of understanding how to manipulate table calculations to achieve the desired ranking of subcategories by sales for specific ship modes.', 'Filtering the data in Tableau excludes the null values from the visualization and draws a line connecting non-null dates, impacting the visualization.']}, {'end': 2732.904, 'segs': [{'end': 2469.58, 'src': 'embed', 'start': 2434.623, 'weight': 0, 'content': [{'end': 2439.827, 'text': 'So Cindy Stewart is the one who has our lowest profit.', 'start': 2434.623, 'duration': 5.204}, {'end': 2446.664, 'text': "And now to figure out her profit ratio, we need to make a calculated field, which I've already made here.", 'start': 2441.092, 'duration': 5.572}, {'end': 2453.466, 'text': 'So in this calculated field, we take the sum of profit and divide it by the sum of sales.', 'start': 2448.342, 'duration': 5.124}, {'end': 2458.711, 'text': 'We do this so that it will sum up all of the profit per row.', 'start': 2453.947, 'duration': 4.764}, {'end': 2469.58, 'text': 'So for Cindy, we want to take all of her profit over all of her transactions and divide it by all of her sales, instead of doing it row by row,', 'start': 2459.531, 'duration': 10.049}], 'summary': 'Cindy stewart has the lowest profit and a calculated field is used to find her profit ratio.', 'duration': 34.957, 'max_score': 2434.623, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2434623.jpg'}, {'end': 2557.688, 'src': 'embed', 'start': 2530.901, 'weight': 2, 'content': [{'end': 2539.667, 'text': "But if you are asked about the rank function in Tableau, it's worth bringing up that there are several different ways to rank,", 'start': 2530.901, 'duration': 8.766}, {'end': 2544.03, 'text': 'and going into a little bit of detail on those different ways will be helpful for you.', 'start': 2539.667, 'duration': 4.363}, {'end': 2549.121, 'text': "Let's build off of this rank example instead.", 'start': 2545.598, 'duration': 3.523}, {'end': 2552.163, 'text': "So we're going to bring on our store.", 'start': 2549.601, 'duration': 2.562}, {'end': 2556.126, 'text': "And we've got store A, B, C, D, and E.", 'start': 2552.704, 'duration': 3.422}, {'end': 2557.688, 'text': "And then we'll bring on our sales.", 'start': 2556.126, 'duration': 1.562}], 'summary': 'Exploring different ways to rank in tableau, using a store sales example.', 'duration': 26.787, 'max_score': 2530.901, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2530901.jpg'}, {'end': 2666.619, 'src': 'embed', 'start': 2637.626, 'weight': 3, 'content': [{'end': 2640.168, 'text': 'So sum of sales, then rank, then rank modified.', 'start': 2637.626, 'duration': 2.542}, {'end': 2646.892, 'text': "Now you can see it's similar to rank first second, but then it skips third and goes to fourth.", 'start': 2640.188, 'duration': 6.704}, {'end': 2648.333, 'text': 'and then fit.', 'start': 2647.813, 'duration': 0.52}, {'end': 2655.395, 'text': 'So over here it gave them higher number when there was a tie, and over here it gave them the lower number when there was a tie.', 'start': 2648.573, 'duration': 6.822}, {'end': 2666.619, 'text': 'So if you could remember that rank gives them the higher number, rank modified gives them the lower number, that will be helpful for your interview.', 'start': 2656.936, 'duration': 9.683}], 'summary': 'The ranking system assigns higher numbers for ties in rank and lower numbers in rank modified, aiding in interview preparation.', 'duration': 28.993, 'max_score': 2637.626, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2637626.jpg'}, {'end': 2732.904, 'src': 'embed', 'start': 2690.284, 'weight': 4, 'content': [{'end': 2699.149, 'text': "And now let's do our last one, which is going to be rank unique.", 'start': 2690.284, 'duration': 8.865}, {'end': 2710.271, 'text': 'OK And with rank unique, it refuses to give 2 the same rank.', 'start': 2704.528, 'duration': 5.743}, {'end': 2721.037, 'text': "And how it determines when there is a tie is it will look at the dimension that's in the visualization and do whichever one comes first in ASCII.", 'start': 2711.032, 'duration': 10.005}, {'end': 2723.859, 'text': 'So it goes 1, 2, and these are a tie.', 'start': 2721.417, 'duration': 2.442}, {'end': 2732.904, 'text': "And since capital B comes before lowercase c, then it's doing b first, then c, then a.", 'start': 2724.219, 'duration': 8.685}], 'summary': 'Rank unique assigns unique ranks, resolving ties using ascii ordering.', 'duration': 42.62, 'max_score': 2690.284, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2690284.jpg'}], 'start': 2400.828, 'title': "Customer profit analysis and tableau's rank functions", 'summary': "Discusses identifying the customer with the lowest overall profit, cindy stewart, and calculating her profit ratio. it also introduces tableau's rank functions and their differences, demonstrated through a visualization based on sales data.", 'chapters': [{'end': 2484.327, 'start': 2400.828, 'title': 'Customer profit analysis', 'summary': 'Discusses identifying the customer with the lowest overall profit, cindy stewart, and calculating her profit ratio by summing up all her profit and dividing it by her sales to obtain a percentage.', 'duration': 83.499, 'highlights': ['Identifying Cindy Stewart as the customer with the lowest profit and then calculating her profit ratio.', "Creating a calculated field to sum up all of Cindy Stewart's profit and dividing it by all of her sales to obtain her profit ratio in percentage."]}, {'end': 2732.904, 'start': 2485.207, 'title': "Understanding tableau's rank functions", 'summary': "Introduces tableau's rank functions, such as rank, rank dense, rank modified, and rank unique, and their differences, demonstrated through a visualization where the rank function assigns positions based on sales data.", 'duration': 247.697, 'highlights': ["Tableau's rank function allows assigning positions based on measures, demonstrated with sales data where the first place had the most sales and the fifth place had the least. Tableau's rank function assigns positions based on measures", 'The demonstration of rank modified and rank dense functions shows how they handle ties differently, giving higher and lower numbers, respectively, in case of a tie in sales data. Demonstration of rank modified and rank dense functions handling ties differently', 'The explanation of rank unique function highlights its approach of not assigning the same rank to two values and determining ties based on ASCII order of dimensions in the visualization. Explanation of rank unique function and its approach to handling ties']}], 'duration': 332.076, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2400828.jpg', 'highlights': ['Identifying Cindy Stewart as the customer with the lowest profit and calculating her profit ratio.', "Creating a calculated field to sum up all of Cindy Stewart's profit and dividing it by all of her sales to obtain her profit ratio in percentage.", "Tableau's rank function assigns positions based on measures, demonstrated with sales data where the first place had the most sales and the fifth place had the least.", 'Demonstration of rank modified and rank dense functions showing how they handle ties differently, giving higher and lower numbers, respectively, in case of a tie in sales data.', 'Explanation of rank unique function and its approach to handling ties by not assigning the same rank to two values and determining ties based on ASCII order of dimensions in the visualization.']}, {'end': 3168.542, 'segs': [{'end': 2870.25, 'src': 'embed', 'start': 2836.913, 'weight': 0, 'content': [{'end': 2840.175, 'text': "When we select Nebraska, it'll change.", 'start': 2836.913, 'duration': 3.262}, {'end': 2848.99, 'text': 'So the major points to know on how to embed a web page is you bring it in from the objects section.', 'start': 2842.182, 'duration': 6.808}, {'end': 2855.698, 'text': 'And then if they ask how to make it dynamic, you use dashboard actions and a URL action.', 'start': 2849.37, 'duration': 6.328}, {'end': 2857.76, 'text': 'Question 24.', 'start': 2856.439, 'duration': 1.321}, {'end': 2860.824, 'text': 'Design a view to show region-wide profit and sales.', 'start': 2857.76, 'duration': 3.064}, {'end': 2870.25, 'text': 'So one way you could do this is by bringing on region and then bringing on profit and sales.', 'start': 2862.625, 'duration': 7.625}], 'summary': 'Embed web page, use dashboard actions for dynamic content. view to display region-wide profit and sales.', 'duration': 33.337, 'max_score': 2836.913, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2836913.jpg'}, {'end': 2965.471, 'src': 'embed', 'start': 2922.675, 'weight': 1, 'content': [{'end': 2928.839, 'text': 'And so that is another view where you could look at profit and sales by region.', 'start': 2922.675, 'duration': 6.164}, {'end': 2934.063, 'text': "And it's a little bit more, takes advantage of some of the mapping capabilities in Tableau.", 'start': 2929.46, 'duration': 4.603}, {'end': 2936.244, 'text': 'It may be what your interviewer is looking for.', 'start': 2934.163, 'duration': 2.081}, {'end': 2939.246, 'text': 'So you could discuss multiple ways to look at it.', 'start': 2936.585, 'duration': 2.661}, {'end': 2941.788, 'text': 'But here is one way that we could recommend it.', 'start': 2939.627, 'duration': 2.161}, {'end': 2949.374, 'text': 'Question 25, how can you optimize the performance of a dashboard? There are multiple ways to optimize the performance of the dashboard.', 'start': 2942.308, 'duration': 7.066}, {'end': 2956.521, 'text': "Some of the things that you might mention is that you could exclude any fields you're not using from your visualization.", 'start': 2949.434, 'duration': 7.087}, {'end': 2965.471, 'text': 'just keep them off, or you can use extract filters and, if you recall, extract filters will remove out rows of data from the extract,', 'start': 2956.521, 'duration': 8.95}], 'summary': 'Optimize dashboard performance by excluding unused fields and using extract filters.', 'duration': 42.796, 'max_score': 2922.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2922675.jpg'}, {'end': 3078.6, 'src': 'embed', 'start': 3053.052, 'weight': 3, 'content': [{'end': 3058.974, 'text': 'So first we want to show aggregated sales totals across a range of product categories and subcategories.', 'start': 3053.052, 'duration': 5.922}, {'end': 3064.876, 'text': 'We want to show the duration of events or activities and we want to show quarter-wise profit growth.', 'start': 3059.294, 'duration': 5.582}, {'end': 3071.618, 'text': 'So to show aggregated sales totals across a range of products, subcategories, and categories, you could use a tree map.', 'start': 3065.496, 'duration': 6.122}, {'end': 3078.6, 'text': 'The reason we bring up a tree map here is that they are known for allowing you to show a visualization using hierarchies.', 'start': 3071.978, 'duration': 6.622}], 'summary': 'Show aggregated sales totals by product categories and subcategories, duration of events, and quarter-wise profit growth using a tree map.', 'duration': 25.548, 'max_score': 3053.052, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3053052.jpg'}], 'start': 2734.079, 'title': 'Tableau dashboard design and optimization', 'summary': 'Delves into embedding a web page in a dashboard, designing a view for region-wide profit and sales, optimizing dashboard performance, and selecting visualizations for specific scenarios in tableau interviews.', 'chapters': [{'end': 3168.542, 'start': 2734.079, 'title': 'Tableau dashboard design and optimization', 'summary': 'Discusses how to embed a web page in a dashboard, design a view to show region-wide profit and sales, optimize dashboard performance, and select visualizations for specific scenarios in tableau interviews.', 'duration': 434.463, 'highlights': ['To embed a web page in a dashboard, grab the web page object from the objects section, put a URL inside it, make the page dynamic based on selection using dashboard actions and a URL action. The process of embedding a web page involves grabbing the web page object, adding a URL, and making it dynamic based on selection using dashboard actions and a URL action.', 'Designing a view to show region-wide profit and sales involves utilizing mapping capabilities in Tableau to visualize states and regions, bringing profit and sales onto the labels, and taking advantage of the mapping capabilities to create a more comprehensive view. Creating a view to show region-wide profit and sales involves utilizing mapping capabilities, visualizing states and regions, and using profit and sales on labels to create a comprehensive view.', 'Optimizing dashboard performance includes excluding unused fields, using extract filters, limiting the number of filters, avoiding complex filters like quick filters, and using min and max instead of average for better processing. Optimizing performance involves excluding unused fields, using extract filters, limiting filters, avoiding complex filters, and using min and max for better processing.', 'For specific scenarios, using a tree map for aggregated sales totals, a Gantt chart for showing duration of events or activities, and a waterfall chart for visualizing profit growth are recommended. Using a tree map for sales totals, a Gantt chart for showing duration, and a waterfall chart for visualizing profit growth are recommended for specific scenarios.']}], 'duration': 434.463, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I2734079.jpg', 'highlights': ['To embed a web page in a dashboard, grab the web page object from the objects section, put a URL inside it, and make the page dynamic based on selection using dashboard actions and a URL action.', 'Designing a view to show region-wide profit and sales involves utilizing mapping capabilities in Tableau to visualize states and regions, bringing profit and sales onto the labels, and taking advantage of the mapping capabilities to create a more comprehensive view.', 'Optimizing dashboard performance includes excluding unused fields, using extract filters, limiting the number of filters, avoiding complex filters like quick filters, and using min and max instead of average for better processing.', 'For specific scenarios, using a tree map for aggregated sales totals, a Gantt chart for showing duration of events or activities, and a waterfall chart for visualizing profit growth are recommended.']}, {'end': 3775.101, 'segs': [{'end': 3208.739, 'src': 'embed', 'start': 3184.909, 'weight': 1, 'content': [{'end': 3192.532, 'text': 'What would you do if some countries or provinces or any geographical entity is missing and displaying a null when you use map view?', 'start': 3184.909, 'duration': 7.623}, {'end': 3196.534, 'text': 'So when you start to map the geographical fields that you have,', 'start': 3192.972, 'duration': 3.562}, {'end': 3205.678, 'text': 'sometimes Tableau is unable to map them because their locations are unknown or ambiguous, meaning a lot of states have a city called Springfield.', 'start': 3196.534, 'duration': 9.144}, {'end': 3208.739, 'text': "and it won't know where to draw that city.", 'start': 3206.158, 'duration': 2.581}], 'summary': 'Tableau may display null for missing geographical entities, due to unknown or ambiguous locations like cities with common names.', 'duration': 23.83, 'max_score': 3184.909, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3184909.jpg'}, {'end': 3304.491, 'src': 'embed', 'start': 3279.141, 'weight': 0, 'content': [{'end': 3290.067, 'text': '28, what is a level of detail expression? A level of detail expression, or an LOD expression, is maybe the way they were presented to you.', 'start': 3279.141, 'duration': 10.926}, {'end': 3292.568, 'text': 'And LOD stands for level of detail.', 'start': 3290.527, 'duration': 2.041}, {'end': 3297.929, 'text': 'So obviously it helps you get to the level of detail that you want in your visualization,', 'start': 3292.788, 'duration': 5.141}, {'end': 3304.491, 'text': 'but it also is used to run complex queries at the data source level instead of all in the Tableau interface.', 'start': 3297.929, 'duration': 6.562}], 'summary': 'Lod expression helps achieve desired visualization detail and run complex queries at data source level.', 'duration': 25.35, 'max_score': 3279.141, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3279141.jpg'}, {'end': 3360.53, 'src': 'embed', 'start': 3331.571, 'weight': 2, 'content': [{'end': 3333.893, 'text': 'and not break it up by the subcategory.', 'start': 3331.571, 'duration': 2.322}, {'end': 3337.975, 'text': 'So if we take off subcategory, then we get the total sales for furniture.', 'start': 3334.173, 'duration': 3.802}, {'end': 3346.321, 'text': 'But if we want a side by side and so that you can see the total sales for furniture and you can see it broken up by subcategory,', 'start': 3338.335, 'duration': 7.986}, {'end': 3348.202, 'text': 'you can use a level of detail calculation.', 'start': 3346.321, 'duration': 1.881}, {'end': 3351.164, 'text': 'This, I already made the field for it.', 'start': 3348.822, 'duration': 2.342}, {'end': 3353.145, 'text': "I've called it exclude subcategory.", 'start': 3351.184, 'duration': 1.961}, {'end': 3353.845, 'text': "So that's right here.", 'start': 3353.205, 'duration': 0.64}, {'end': 3356.367, 'text': 'Right now, it just contains sales.', 'start': 3354.666, 'duration': 1.701}, {'end': 3360.53, 'text': "But we're going to use the level of detail calculation exclude.", 'start': 3357.088, 'duration': 3.442}], 'summary': 'Use level of detail calculation to compare total furniture sales with subcategories.', 'duration': 28.959, 'max_score': 3331.571, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3331571.jpg'}, {'end': 3458.583, 'src': 'embed', 'start': 3430.471, 'weight': 3, 'content': [{'end': 3435.233, 'text': 'So include, exclude are pretty easy to remember and just always remember fixed as well.', 'start': 3430.471, 'duration': 4.762}, {'end': 3437.114, 'text': 'Question 29.', 'start': 3435.753, 'duration': 1.361}, {'end': 3440.555, 'text': 'How do you calculate daily profit measure using level of detail?', 'start': 3437.114, 'duration': 3.441}, {'end': 3448.159, 'text': "Here's another opportunity for you to pause the video and take a look at calculating a daily profit measure using level of detail.", 'start': 3440.875, 'duration': 7.284}, {'end': 3450.079, 'text': 'We are going to get started.', 'start': 3448.579, 'duration': 1.5}, {'end': 3452.32, 'text': 'Profitable level of detail.', 'start': 3451.02, 'duration': 1.3}, {'end': 3458.583, 'text': 'So we want to have a daily profit measure And I already made a place for it, profit per day.', 'start': 3452.42, 'duration': 6.163}], 'summary': 'Calculate daily profit measure using level of detail with profit per day.', 'duration': 28.112, 'max_score': 3430.471, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3430471.jpg'}, {'end': 3752.469, 'src': 'embed', 'start': 3730.977, 'weight': 4, 'content': [{'end': 3740.523, 'text': 'it might be worthwhile bringing up the fact that you only need to schedule a refresh if you are using an extract on your data source,', 'start': 3730.977, 'duration': 9.546}, {'end': 3744.525, 'text': 'and then that will help them know that you know the difference between live and extracts.', 'start': 3740.523, 'duration': 4.002}, {'end': 3752.469, 'text': "if they didn't ever ask that question, today we've learned about 30 different interview questions that might be asked in your next tableau interview.", 'start': 3744.525, 'duration': 7.944}], 'summary': 'Scheduling a refresh is only needed for data extracts, demonstrating knowledge of live vs extracts. 30 potential interview questions learned.', 'duration': 21.492, 'max_score': 3730.977, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3730977.jpg'}], 'start': 3168.542, 'title': 'Tableau map visualization and level of detail calculations', 'summary': 'Discusses handling missing geographical entities in tableau map view, explaining level of detail expression, and explores level of detail calculations in tableau, including examples of excluding dimensions, fixing a daily profit measure, and scheduling a workbook refresh on tableau server.', 'chapters': [{'end': 3304.491, 'start': 3168.542, 'title': 'Tableau map visualization and level of detail', 'summary': 'Discusses handling missing geographical entities in tableau map view by editing locations, filtering data, or showing data at default position, as well as explaining the concept of level of detail expression in tableau.', 'duration': 135.949, 'highlights': ['Handling missing geographical entities in Tableau map view Tableau allows editing locations, filtering data, or showing data at default position to address missing or ambiguous geographical locations, providing flexibility in data visualization.', 'Level of Detail (LOD) expression in Tableau LOD expressions enable users to specify the desired level of detail in visualizations and perform complex queries at the data source level, enhancing data analysis capabilities.']}, {'end': 3775.101, 'start': 3305.251, 'title': 'Level of detail calculations in tableau', 'summary': 'Explores level of detail calculations in tableau, including examples of excluding dimensions from calculated fields, fixing a daily profit measure, and scheduling a workbook refresh on tableau server.', 'duration': 469.85, 'highlights': ['The chapter explains using level of detail calculations to exclude a dimension from a calculated field, resulting in the visualization displaying total sales for furniture and ignoring subcategories, which demonstrates the practical application of level of detail calculations in Tableau. total sales for furniture, excluding subcategories, practical application of level of detail calculations', 'The transcript demonstrates the use of a fixed level of detail calculation to determine the daily profit measure by summing up profits for each day, and then categorizing the results into highly profitable, profitable, and unprofitable, showcasing the flexibility and utility of fixed calculations in Tableau. fixed level of detail calculation, daily profit measure, categorizing results into highly profitable, profitable, and unprofitable', 'The chapter provides insights into scheduling a workbook refresh on Tableau server, emphasizing the need to refresh extracts when using Tableau data sources and highlighting the importance of understanding the difference between live and extract data sources in Tableau. scheduling workbook refresh, importance of refreshing extracts, live vs. extract data sources']}], 'duration': 606.559, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Kkg27cnLc1I/pics/Kkg27cnLc1I3168542.jpg', 'highlights': ['LOD expressions in Tableau enable users to specify the desired level of detail in visualizations and perform complex queries at the data source level.', 'Handling missing geographical entities in Tableau map view provides flexibility in data visualization by allowing editing locations, filtering data, or showing data at default position.', 'The chapter explains using level of detail calculations to exclude a dimension from a calculated field, resulting in the visualization displaying total sales for furniture and ignoring subcategories.', 'The transcript demonstrates the use of a fixed level of detail calculation to determine the daily profit measure by summing up profits for each day and categorizing the results into highly profitable, profitable, and unprofitable.', 'The chapter provides insights into scheduling a workbook refresh on Tableau server, emphasizing the need to refresh extracts when using Tableau data sources and highlighting the importance of understanding the difference between live and extract data sources.']}], 'highlights': ['Understanding the options to handle null values in Tableau is crucial for accurate data visualization and interpretation.', 'LOD expressions in Tableau enable users to specify the desired level of detail in visualizations and perform complex queries at the data source level.', 'The process involves using table calculation to rank subcategories by sales for different ship modes, enabling the identification of the top product subcategories within each delivery method.', 'The chapter explains using level of detail calculations to exclude a dimension from a calculated field, resulting in the visualization displaying total sales for furniture and ignoring subcategories.', 'The corporate segment has 32.12% of the total profits.', "Creating a calculated field to sum up all of Cindy Stewart's profit and dividing it by all of her sales to obtain her profit ratio in percentage.", 'The chapter demonstrates using sets to display top and bottom sales in the same visualization, allowing for dynamic filtering and visualization.', 'To embed a web page in a dashboard, grab the web page object from the objects section, put a URL inside it, and make the page dynamic based on selection using dashboard actions and a URL action.', 'Optimizing dashboard performance includes excluding unused fields, using extract filters, limiting the number of filters, avoiding complex filters like quick filters, and using min and max instead of average for better processing.', 'Different types of filters in Tableau include extract filters, data source filters, and context filters, each with specific impacts on data size and visualization outcomes.']}