title
Tableau Tutorial For Beginners | Part 1 | Tableau Tutorial Part - 1 | Tableau Training | Simplilearn

description
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=Tableau-fO7g0pnWaRA&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-fO7g0pnWaRA&utm_medium=DescriptionFF&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=Tableau-fO7g0pnWaRA&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-fO7g0pnWaRA&utm_medium=DescriptionFF&utm_source=youtube This Tableau Tutorial For Beginners video will help you understand what is business intelligence why we need business intelligence, what are the various business intelligence tools, what is Tableau, why Tableau, how to install Tableau, and along with that you will also see how to get started with Tableau and it features such as worksheets, dashboards, hierarchy, calculated fields, parameters, sets, and charts. Tableau Training For Beginners Part 2: https://www.youtube.com/watch?v=bI7CcCnrR-k Below topics are explained in this Tableau training for beginners video: 00:00 Introduction to Tableau Tutorial For Beginners 1. Business intelligence ( 00:53 ) Tableau Tutorial For Beginners - Why BI? ( 01:04 ) - BI tools ( 01:37 ) 2. Tableau ( 01:53 ) Tableau Tutorial For Beginners - Why Tableau? ( 01:57 ) - Tableau installation 05:54 3. Getting started 06:55 Tableau Tutorial For Beginners - Connecting to data 06:58 - Tableau workspace 09:06 4. Worksheets & dashboards 10:10 Tableau Tutorial For Beginners - Asking questions using visualizations 11:20 - Hierarchy & drill down 31:04 - Calculated fields 40:13 - Parameters & sets 49:50 - Donut chart & 2-d pie chart 01:01:22 🔥Explore our FREE Courses: https://www.simplilearn.com/skillup-free-online-courses?utm_campaign=Tableau&utm_medium=Description&utm_source=youtube Dataset Link - https://drive.google.com/drive/folders/1FWRXs0QvuyF75PolDNqgH0e5UigpdArw ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the Data Analytics tutorial videos: https://www.youtube.com/playlist?list=PLEiEAq2VkUUKgEFXH1tBbHwq38oWYDScU #tableaututorial #tableaucertification #tableaudataanalysis #tableauvisualization #tableau #tableautraining #tableaututorial #simplilearn #tableauTutorialForBeginners What is Tableau? Tableau is an interactive data visualization tool focused on business intelligence. It helps in simplifying the job of representing the raw data in the form of easily understandable and interactive graphs and charts. Tableau enables connectivity with a wide range of data sources like cloud, CSV files, databases, and much more. Why learn Tableau? Everything we do is increasingly contributing to huge amounts of data which can be leveraged by organizations to increase their business. Organizations across the world make use of Tableau to analyze this huge amount of data and derive actionable insights from it. Tableau can help you to create complex and beautiful data visualizations. With its intuitive and user-friendly approach to data visualization, Tableau is today, a popular choice for big and small organizations. ➡️ 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. ✅ Key Features - Post Graduate Program certificate and Alumni Association membership - Exclusive hackathons and Ask me Anything sessions by IBM - 8X higher live interaction in live online classes by industry experts - Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc. - Master Classes delivered by Purdue faculty and IBM experts - Simplilearn's JobAssist helps you get noticed by top hiring companies - Resume preparation and LinkedIn profile building - 1:1 mock interview - Career accelerator webinars ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analysis Python and R - Data Visualization Tableau and Power BI - Linear and logistic regression modules - Clustering using kmeans - Supervised Learning 👉 Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=Tableau-fO7g0pnWaRA&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'Tableau Tutorial For Beginners | Part 1 | Tableau Tutorial Part - 1 | Tableau Training | Simplilearn', 'heatmap': [{'end': 331.372, 'start': 234.538, 'weight': 0.781}, {'end': 572.075, 'start': 488.502, 'weight': 0.887}, {'end': 903.653, 'start': 813.74, 'weight': 0.734}, {'end': 1963.027, 'start': 1874.232, 'weight': 0.835}, {'end': 2447.687, 'start': 2278.866, 'weight': 0.711}, {'end': 2937.782, 'start': 2851.335, 'weight': 0.712}, {'end': 3345.73, 'start': 3173.563, 'weight': 0.802}, {'end': 3506.777, 'start': 3417.932, 'weight': 0.79}, {'end': 3913.936, 'start': 3664.732, 'weight': 0.793}], 'summary': "This tableau tutorial for beginners covers business intelligence, data connection, visualization techniques, creating interactive dashboards with filters, and tableau's leadership in gartner magic quadrant, providing a comprehensive introduction to tableau and its functionalities for actionable insights and effective data analysis.", 'chapters': [{'end': 87.981, 'segs': [{'end': 46.707, 'src': 'embed', 'start': 3.063, 'weight': 0, 'content': [{'end': 5.604, 'text': 'Hello and welcome to Tableau training for beginners.', 'start': 3.063, 'duration': 2.541}, {'end': 8.626, 'text': "My name is Michelle Covine and I'm with the Simply Learn team.", 'start': 6.005, 'duration': 2.621}, {'end': 13.569, 'text': "Today we'll be talking about all the things you need to know to get started with Tableau.", 'start': 9.246, 'duration': 4.323}, {'end': 15.61, 'text': "So here's our agenda.", 'start': 14.289, 'duration': 1.321}, {'end': 21.433, 'text': "We'll be talking about business intelligence and why it's important and some BI tools.", 'start': 15.77, 'duration': 5.663}, {'end': 26.056, 'text': "Then we'll talk about Tableau and why we use Tableau for business intelligence.", 'start': 21.753, 'duration': 4.303}, {'end': 29.338, 'text': 'and do a quick overview of Tableau installation.', 'start': 26.696, 'duration': 2.642}, {'end': 35.501, 'text': "Then we'll show you how you can get started by connecting to data, and we'll do an overview of the Tableau workspace.", 'start': 29.818, 'duration': 5.683}, {'end': 43.625, 'text': "We'll go a little bit deeper into the Tableau workspace as we look at worksheets and dashboards and we show you how you can ask questions using visualizations.", 'start': 35.941, 'duration': 7.684}, {'end': 46.707, 'text': "We'll look at hierarchy and drill down, calculated fields.", 'start': 43.846, 'duration': 2.861}], 'summary': 'Tableau training covers bi tools, installation, data connection, workspace, visualizations, hierarchy, and drill down.', 'duration': 43.644, 'max_score': 3.063, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3063.jpg'}], 'start': 3.063, 'title': 'Tableau training for beginners', 'summary': 'Provides a comprehensive introduction to tableau, covering business intelligence, tableau usage, data connection, workspace overview, and visualization techniques for actionable insights.', 'chapters': [{'end': 87.981, 'start': 3.063, 'title': 'Tableau training for beginners', 'summary': 'Provides a comprehensive introduction to tableau, covering topics such as business intelligence, tableau usage, data connection, workspace overview, and visualization techniques for actionable insights.', 'duration': 84.918, 'highlights': ['Business intelligence technologies help companies collect, analyze, and present data to create actionable information, aiding in answering questions about customer satisfaction and product/service awareness.', 'The agenda includes an overview of Tableau, its installation, workspace exploration, visualization techniques such as donut and 2D pie chart, and the importance of business intelligence and BI tools.', 'Michelle Covine from Simply Learn team leads the Tableau training for beginners, covering the essentials of Tableau, data connection, workspace overview, and visualization techniques for actionable insights.', 'The chapter discusses the importance of business intelligence for gaining insights about customers, products, and services, helping businesses answer questions about customer satisfaction, customer retention, and product/service awareness.']}], 'duration': 84.918, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3063.jpg', 'highlights': ['Business intelligence technologies aid in answering questions about customer satisfaction and product/service awareness.', 'Michelle Covine leads Tableau training for beginners, covering essentials of Tableau, data connection, workspace overview, and visualization techniques.', 'The chapter emphasizes the importance of business intelligence for gaining insights about customers, products, and services.']}, {'end': 1094.913, 'segs': [{'end': 217.264, 'src': 'embed', 'start': 188.39, 'weight': 2, 'content': [{'end': 196.154, 'text': "There's also Tableau Online, which is a cloud hosted version of Tableau Server, a place where you can publish your dashboards,", 'start': 188.39, 'duration': 7.764}, {'end': 198.975, 'text': 'and it enables you to share your dashboards in a secure way.', 'start': 196.154, 'duration': 2.821}, {'end': 201.996, 'text': 'Tableau Server has an option to be on premises.', 'start': 199.495, 'duration': 2.501}, {'end': 209.44, 'text': "So let's just do a quick comparison between building a visualization in Excel and building one in Tableau.", 'start': 202.637, 'duration': 6.803}, {'end': 217.264, 'text': 'Okay, so here we have an Excel file full of data that we will soon connect to and use for some of our demonstration purposes.', 'start': 210.12, 'duration': 7.144}], 'summary': 'Tableau online enables secure dashboard sharing, with an option for on-premises deployment. it offers advantages over excel for visualization.', 'duration': 28.874, 'max_score': 188.39, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA188390.jpg'}, {'end': 331.372, 'src': 'heatmap', 'start': 234.538, 'weight': 0.781, 'content': [{'end': 248.525, 'text': "we'll make it in a new worksheet and here we have the beginnings of a pivot chart and we can grab region and pull it into our columns and then we'll grab sales and put it into values.", 'start': 234.538, 'duration': 13.987}, {'end': 253.228, 'text': 'And then we also want to look at quantity and put that into values.', 'start': 249.846, 'duration': 3.382}, {'end': 259.873, 'text': "And it's automatically summing up sales and quantity but you can choose if you want it to be sum or not.", 'start': 253.629, 'duration': 6.244}, {'end': 267.298, 'text': "And then we'll take our values and put it on rows so that we can see sales and quantity one on top of the other.", 'start': 260.313, 'duration': 6.985}, {'end': 269.94, 'text': "And that's the basics of a pivot chart.", 'start': 267.318, 'duration': 2.622}, {'end': 272.342, 'text': "Now let's do a similar thing in Tableau.", 'start': 269.98, 'duration': 2.362}, {'end': 280.54, 'text': 'Okay, so we have our connection to the data, and Tableau automatically splits out the dimensions from the measures.', 'start': 273.612, 'duration': 6.928}, {'end': 282.482, 'text': "We'll go into more depth on that later.", 'start': 280.66, 'duration': 1.822}, {'end': 289.991, 'text': 'But we can come and grab region and put it onto columns, and we get a similar thing, maybe a little nicer formatted.', 'start': 283.063, 'duration': 6.928}, {'end': 293.855, 'text': 'And then we can come and put quantity there.', 'start': 290.431, 'duration': 3.424}, {'end': 300.867, 'text': "If we want to add sales to it, we can double click on sales and we'll have quantity and sales one on top of the other.", 'start': 295.143, 'duration': 5.724}, {'end': 305.651, 'text': 'We can put sales on top by dragging quantity down in that box.', 'start': 300.887, 'duration': 4.764}, {'end': 308.593, 'text': 'We also have this show me dialog box,', 'start': 306.151, 'duration': 2.442}, {'end': 316.999, 'text': "which allows you to see what visualizations you could build using what's already on the screen or the things that you have selected.", 'start': 308.593, 'duration': 8.406}, {'end': 323.704, 'text': 'So right now we could quickly switch it to bar charts and now we can see quantity and sales across our region.', 'start': 317.519, 'duration': 6.185}, {'end': 331.372, 'text': 'with bar charts or we could switch it to stacked bars and we can see our quantity across the regions.', 'start': 324.184, 'duration': 7.188}], 'summary': 'Creating pivot chart and tableau visualization with region, sales, and quantity data.', 'duration': 96.834, 'max_score': 234.538, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA234538.jpg'}, {'end': 572.075, 'src': 'heatmap', 'start': 488.502, 'weight': 0.887, 'content': [{'end': 490.324, 'text': 'And this is our data source page.', 'start': 488.502, 'duration': 1.822}, {'end': 497.47, 'text': 'This shows you the sheets on the Excel file and allows you to drag them in so that you can see the data show up.', 'start': 490.784, 'duration': 6.686}, {'end': 500.272, 'text': 'This gives you a preview of what your data will look like.', 'start': 497.81, 'duration': 2.462}, {'end': 510.397, 'text': "You can see that Tableau is starting to classify our fields, so anything that has ABC on it shows that that's a column that has strings in it.", 'start': 501.013, 'duration': 9.384}, {'end': 516.46, 'text': 'We also have a globe, which is where Tableau has recognized these values to be geographical.', 'start': 510.757, 'duration': 5.703}, {'end': 521.542, 'text': "So we have state, and it's recognized that it contains states.", 'start': 517.299, 'duration': 4.243}, {'end': 527.405, 'text': "It bases it on the keywords that it stores to identify if it's geographical.", 'start': 521.922, 'duration': 5.483}, {'end': 531.949, 'text': "And so it takes a look and you've named it city and it knows that city is geographical.", 'start': 528.086, 'duration': 3.863}, {'end': 536.693, 'text': "We also have the calendar symbol where it's recognized that it's a date field.", 'start': 532.409, 'duration': 4.284}, {'end': 542.758, 'text': "And we also have row ID that shows up with the hashtag and it recognizes it's a number.", 'start': 536.953, 'duration': 5.805}, {'end': 550.223, 'text': 'So now that we have our data source pulled in, we can come here and hit sheet, which is where you start to build your visualization.', 'start': 543.038, 'duration': 7.185}, {'end': 554.327, 'text': "Let's take a look at all the different pieces of this before we go any further.", 'start': 550.764, 'duration': 3.563}, {'end': 557.408, 'text': "We have the data that we're connected to up here.", 'start': 554.767, 'duration': 2.641}, {'end': 561.41, 'text': "It's our orders sheet from the Sample Superstore Excel sheet.", 'start': 557.428, 'duration': 3.982}, {'end': 564.832, 'text': 'We have dimensions on top and measures on bottom.', 'start': 561.71, 'duration': 3.122}, {'end': 567.973, 'text': "These are where we're going to get the fields to drag and drop.", 'start': 565.372, 'duration': 2.601}, {'end': 569.414, 'text': 'Here we have our cards.', 'start': 568.213, 'duration': 1.201}, {'end': 572.075, 'text': "We'll look more in depth at our cards in a moment.", 'start': 569.574, 'duration': 2.501}], 'summary': 'Tableau classifies fields: abc for strings, globe for geographical, calendar for date, row id for number. data source connected to sample superstore excel sheet for visualization.', 'duration': 83.573, 'max_score': 488.502, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA488502.jpg'}, {'end': 780.315, 'src': 'embed', 'start': 751.064, 'weight': 5, 'content': [{'end': 756.689, 'text': 'So Tableau is smart enough that when it sees ID, it knows that it belongs up in the dimensions.', 'start': 751.064, 'duration': 5.625}, {'end': 758.631, 'text': 'Now you can switch.', 'start': 757.229, 'duration': 1.402}, {'end': 767.738, 'text': 'So if row ID was actually something you would want to aggregate for some reason, you can drag it down to the measures and add it down there.', 'start': 758.991, 'duration': 8.747}, {'end': 773.111, 'text': "But in our case, row ID isn't something that you want to sum or average.", 'start': 768.789, 'duration': 4.322}, {'end': 780.315, 'text': 'Can you think of any other numbers that might not show up as a measure that should be a dimension? Comment below with your answers.', 'start': 773.351, 'duration': 6.964}], 'summary': 'Tableau automatically categorizes id as a dimension, allowing for easy aggregation.', 'duration': 29.251, 'max_score': 751.064, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA751064.jpg'}, {'end': 950.192, 'src': 'heatmap', 'start': 813.74, 'weight': 0, 'content': [{'end': 817.681, 'text': "But you can see even when it's a dimension you can choose continuous or discrete.", 'start': 813.74, 'duration': 3.941}, {'end': 819.862, 'text': "So right now it's a dimension but it's green.", 'start': 817.901, 'duration': 1.961}, {'end': 822.222, 'text': "It's a little bit different than what you might expect.", 'start': 819.882, 'duration': 2.34}, {'end': 823.623, 'text': "And then we'll do sales.", 'start': 822.342, 'duration': 1.281}, {'end': 828.324, 'text': 'So now we can see over the different quantities what our sales was.', 'start': 823.903, 'duration': 4.421}, {'end': 831.865, 'text': "It has been for this period of time that we're looking at.", 'start': 828.664, 'duration': 3.201}, {'end': 833.025, 'text': "I believe it's four years.", 'start': 831.985, 'duration': 1.04}, {'end': 839.808, 'text': 'So for when people bought three items, the total sales was that number.', 'start': 833.385, 'duration': 6.423}, {'end': 841.788, 'text': 'And you can see that this is an axis.', 'start': 839.988, 'duration': 1.8}, {'end': 844.29, 'text': "So it's from one to 15.", 'start': 842.109, 'duration': 2.181}, {'end': 850.212, 'text': 'Now, if we change it from continuous to discrete, you can see that one is a label,', 'start': 844.29, 'duration': 5.922}, {'end': 856.655, 'text': "two is a label and it's not an axis ranging from one to it doesn't even have 15, because there are no values under 15..", 'start': 850.212, 'duration': 6.443}, {'end': 858.495, 'text': 'These are just individual labels.', 'start': 856.655, 'duration': 1.84}, {'end': 862.417, 'text': "So we go back, it's green again, and you can see that it's an axis.", 'start': 858.815, 'duration': 3.602}, {'end': 865.478, 'text': 'So we have two greens on here, so we have two axes.', 'start': 862.557, 'duration': 2.921}, {'end': 867.479, 'text': 'And change it back to discrete.', 'start': 865.979, 'duration': 1.5}, {'end': 872.222, 'text': 'And now we have one axis and one set of individual labels.', 'start': 867.76, 'duration': 4.462}, {'end': 875.323, 'text': "So let's go back to our sheet three.", 'start': 872.722, 'duration': 2.601}, {'end': 883.126, 'text': 'We have all of these different sales by the different quantity numbers and up.', 'start': 875.843, 'duration': 7.283}, {'end': 884.967, 'text': 'here we have our sorting.', 'start': 883.126, 'duration': 1.841}, {'end': 887.648, 'text': 'when you hover, it tells you what kind of sorting is going to happen.', 'start': 884.967, 'duration': 2.681}, {'end': 890.689, 'text': 'so we could sort quantity descending by sales.', 'start': 887.648, 'duration': 3.041}, {'end': 895.691, 'text': 'so we can see that when they buy three things, we have the highest sales.', 'start': 890.689, 'duration': 5.002}, {'end': 903.653, 'text': "you can do the opposite where it's the lowest, to the highest number of sales.", 'start': 895.691, 'duration': 7.962}, {'end': 910.874, 'text': 'you can also do sorting more in depth by clicking on the quantity and right clicking sort.', 'start': 903.653, 'duration': 7.221}, {'end': 921.978, 'text': 'So we could just sort by descending or ascending or by sales or alphabetic, which is not what we want.', 'start': 911.374, 'duration': 10.604}, {'end': 926.24, 'text': 'You can choose the field or you can manually change your sorting here.', 'start': 922.638, 'duration': 3.602}, {'end': 929.666, 'text': "And now we're back to what we had at the beginning.", 'start': 927.585, 'duration': 2.081}, {'end': 935.648, 'text': "Now that we've had an overview of how Tableau works, let's go into a little more detail.", 'start': 930.166, 'duration': 5.482}, {'end': 940.129, 'text': 'Tableau is very much built on the premise of drag and drop.', 'start': 936.208, 'duration': 3.921}, {'end': 950.192, 'text': "So let's build a simple visualization and talk about what each of these shells and marks cards specifically do.", 'start': 940.829, 'duration': 9.363}], 'summary': 'The transcript discusses using tableau for data visualization, including options for continuous or discrete dimensions and sorting by sales and quantity numbers.', 'duration': 84.213, 'max_score': 813.74, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA813740.jpg'}], 'start': 87.981, 'title': 'Tableau for business intelligence and visualization', 'summary': 'Covers the benefits of using tableau for business intelligence, including its ability to connect to 40 data sources, build interactive dashboards, provide simple analytics, and its leadership in the gartner magic quadrant. it also discusses pivot tables in excel and compares them to tableau visualizations, emphasizing the quick flexibility and ease of use in tableau. furthermore, it provides an overview of tableau functionality, explaining the categorization of data into dimensions and measures.', 'chapters': [{'end': 209.44, 'start': 87.981, 'title': 'Tableau for business intelligence', 'summary': 'Discusses the benefits of using tableau as a business intelligence tool, including its ability to connect to 40 different data sources, build interactive dashboards, provide simple analytics, and its leadership in the gartner magic quadrant for the last six years.', 'duration': 121.459, 'highlights': ['Tableau can be connected to 40 different data sources, providing direct access to data.', 'It can build interactive dashboards with just a few clicks, allowing quick understanding of data and visualization of outliers.', 'Tableau has been a leader in the Gartner Magic quadrant for the last six years, including 2018, showcasing its consistent performance in the industry.', 'Tableau Desktop is the primary development tool, while Tableau Public is a free version with limitations, and Tableau Prep allows visual data preparation before building reports.', 'Tableau Online and Tableau Server provide cloud-hosted and on-premises options for publishing and sharing dashboards in a secure manner.']}, {'end': 531.949, 'start': 210.12, 'title': 'Pivot tables vs tableau visualizations', 'summary': 'Discusses the creation of pivot tables in excel to analyze quantity sold and sum of sales by region, followed by a comparison to similar visualizations created in tableau, with a focus on the quick flexibility and ease of use in tableau. additionally, it provides guidance for installing tableau public and demonstrates the initial steps to connect to a data source in tableau public.', 'duration': 321.829, 'highlights': ['The chapter discusses the creation of pivot tables in Excel to analyze quantity sold and sum of sales by region Demonstrates the process of creating a pivot table in Excel to analyze quantity sold and sum of sales by region, providing insights into data manipulation and analysis.', 'Comparison to similar visualizations created in Tableau, with a focus on the quick flexibility and ease of use in Tableau Provides a comparison between pivot tables in Excel and similar visualizations created in Tableau, highlighting the quick flexibility and ease of use of Tableau for creating visualizations.', 'Guidance for installing Tableau Public and demonstrates the initial steps to connect to a data source in Tableau Public Offers guidance for installing Tableau Public, including system requirements and steps to download and install the application, followed by a demonstration of connecting to a data source in Tableau Public.']}, {'end': 1094.913, 'start': 532.409, 'title': 'Understanding tableau basics', 'summary': 'Provides an overview of tableau functionality, explaining the categorization of data into dimensions and measures, the role of dimensions in revealing qualitative details, the role of measures in providing quantitative values, and the distinction between dimensions and measures based on their role and aggregation potential.', 'duration': 562.504, 'highlights': ['Tableau categorizes data into dimensions and measures, with dimensions containing qualitative details and measures containing quantitative values. Dimensions contain descriptive values such as names, dates, and geographical data, while measures contain numeric quantitative values that can be aggregated.', 'The role of dimensions is to reveal qualitative details in the data, while measures provide quantitative values that can be aggregated, with Tableau automatically applying aggregation (sum by default) to measures when added to the view. Dimensions are used to reveal details in the data that are qualitative, while measures can be aggregated and Tableau applies an aggregation, such as sum by default, when measures are added to the view.', 'Tableau distinguishes between dimensions and measures based on their potential for calculations and aggregation, categorizing numbers like row ID as dimensions if they are not intended for aggregation or calculations. Tableau categorizes numbers like row ID as dimensions if they are not intended for aggregation or calculations, based on whether the data may require calculations or aggregation in the future.', 'Tableau uses color to represent data, with distinct colors for dimensions and a continuous color scale for measures, allowing for effective visualization of quantitative and qualitative data. Tableau uses distinct colors to represent dimensions and a continuous color scale for measures, enabling effective visualization of both quantitative and qualitative data.']}], 'duration': 1006.932, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA87981.jpg', 'highlights': ['Tableau can be connected to 40 different data sources, providing direct access to data.', 'Tableau has been a leader in the Gartner Magic quadrant for the last six years, including 2018, showcasing its consistent performance in the industry.', 'Tableau can build interactive dashboards with just a few clicks, allowing quick understanding of data and visualization of outliers.', 'Tableau Desktop is the primary development tool, while Tableau Public is a free version with limitations, and Tableau Prep allows visual data preparation before building reports.', 'Tableau Online and Tableau Server provide cloud-hosted and on-premises options for publishing and sharing dashboards in a secure manner.', 'Comparison to similar visualizations created in Tableau, with a focus on the quick flexibility and ease of use in Tableau.', 'Tableau categorizes data into dimensions and measures, with dimensions containing qualitative details and measures containing quantitative values.', 'Tableau distinguishes between dimensions and measures based on their potential for calculations and aggregation, categorizing numbers like row ID as dimensions if they are not intended for aggregation or calculations.', 'Tableau uses color to represent data, with distinct colors for dimensions and a continuous color scale for measures, allowing for effective visualization of quantitative and qualitative data.']}, {'end': 2119.832, 'segs': [{'end': 1256.309, 'src': 'embed', 'start': 1230.4, 'weight': 2, 'content': [{'end': 1240.919, 'text': 'The label has some interesting options, like you can format this and we could say maybe we want it to be all of them to be blue,', 'start': 1230.4, 'duration': 10.519}, {'end': 1243.581, 'text': 'and that happens right there.', 'start': 1240.919, 'duration': 2.662}, {'end': 1248.844, 'text': 'you can also choose to only show the minimum and the maximum.', 'start': 1243.581, 'duration': 5.263}, {'end': 1256.309, 'text': "this becomes handy on a line chart where you don't want all marks labeled, because it gets very messy,", 'start': 1248.844, 'duration': 7.465}], 'summary': 'Options for label formatting include color selection and displaying min and max values, useful for decluttering line charts.', 'duration': 25.909, 'max_score': 1230.4, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA1230400.jpg'}, {'end': 1443.088, 'src': 'embed', 'start': 1410.423, 'weight': 1, 'content': [{'end': 1414.846, 'text': 'that represents all of our data with the sum of sales and the sum of discount.', 'start': 1410.423, 'duration': 4.423}, {'end': 1421.831, 'text': "And if we wanted to see this per order, we'll take order ID and put it onto detail.", 'start': 1415.646, 'duration': 6.185}, {'end': 1428.156, 'text': 'Now what detail does is it determines the level that we are building our visualization at.', 'start': 1422.231, 'duration': 5.925}, {'end': 1433.36, 'text': 'So grabbing order ID and putting onto detail gives us all of these little points.', 'start': 1428.716, 'duration': 4.644}, {'end': 1443.088, 'text': 'So for each order, what was our sales and what was our discount? So we have out here some outliers that you can find very quickly.', 'start': 1433.64, 'duration': 9.448}], 'summary': 'Visualize sales and discount per order, identifying outliers.', 'duration': 32.665, 'max_score': 1410.423, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA1410423.jpg'}, {'end': 1708.122, 'src': 'embed', 'start': 1682.667, 'weight': 0, 'content': [{'end': 1688.25, 'text': 'We end up with furniture, furniture, furniture, furniture spread out across our visualization.', 'start': 1682.667, 'duration': 5.583}, {'end': 1690.851, 'text': "So again, let's put category to the front.", 'start': 1688.79, 'duration': 2.061}, {'end': 1696.572, 'text': 'And now we have our profit by category by subcategory.', 'start': 1692.168, 'duration': 4.404}, {'end': 1701.736, 'text': 'And we can click sort subcategory descending by profit.', 'start': 1697.252, 'duration': 4.484}, {'end': 1708.122, 'text': 'And now what it does is within the highest group within each group.', 'start': 1702.437, 'duration': 5.685}], 'summary': 'Visualize furniture profit by category and subcategory.', 'duration': 25.455, 'max_score': 1682.667, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA1682667.jpg'}, {'end': 1872.087, 'src': 'embed', 'start': 1845.112, 'weight': 3, 'content': [{'end': 1853.557, 'text': 'Also, as we are building these visualizations, if you want to have access to this data set so that you can build along with me,', 'start': 1845.112, 'duration': 8.445}, {'end': 1859.32, 'text': 'just make a comment in the comments below, and the Simply Learn team will send you this data set.', 'start': 1853.557, 'duration': 5.763}, {'end': 1863.182, 'text': "Now we're going to take a look at creating a hierarchy in Tableau.", 'start': 1859.72, 'duration': 3.462}, {'end': 1872.087, 'text': "So we'll make a new tab and we're going to make a sheet called Sales by Product.", 'start': 1864.403, 'duration': 7.684}], 'summary': 'Instruction on creating hierarchy in tableau, offering dataset access via comments.', 'duration': 26.975, 'max_score': 1845.112, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA1845112.jpg'}, {'end': 1963.027, 'src': 'heatmap', 'start': 1874.232, 'weight': 0.835, 'content': [{'end': 1883.299, 'text': "And so we will be looking at sales as a number and let's bring on product name.", 'start': 1874.232, 'duration': 9.067}, {'end': 1891.076, 'text': "Now there are a lot of product names so it's going to make sure that you really want to do this.", 'start': 1884.813, 'duration': 6.263}, {'end': 1898.26, 'text': 'Then I click add all members and now we can see all of our products and their sales over all time.', 'start': 1891.096, 'duration': 7.164}, {'end': 1907.764, 'text': 'So, if we sort this, we can see our highest selling item, which we discovered earlier, as the advanced copier, and we scroll down to the bottom,', 'start': 1898.92, 'duration': 8.844}, {'end': 1909.145, 'text': 'our lowest selling items.', 'start': 1907.764, 'duration': 1.381}, {'end': 1916.585, 'text': 'So we have our products and we can group that by subcategory.', 'start': 1911.178, 'duration': 5.407}, {'end': 1919.609, 'text': 'And you can see I need to put it in the front again.', 'start': 1916.605, 'duration': 3.004}, {'end': 1922.873, 'text': 'And by category.', 'start': 1919.629, 'duration': 3.244}, {'end': 1930.942, 'text': "All right, I'm going to take product name back off, and we're going to talk about hierarchies.", 'start': 1926.061, 'duration': 4.881}, {'end': 1935.823, 'text': 'So a product rolls up into a subcategory, which rolls up into a category.', 'start': 1931.302, 'duration': 4.521}, {'end': 1943.665, 'text': "You can create a hierarchy by, let's start with subcategory and dragging it onto category, and it's going to create a hierarchy.", 'start': 1936.123, 'duration': 7.542}, {'end': 1947.366, 'text': "We'll call it our product hierarchy.", 'start': 1944.005, 'duration': 3.361}, {'end': 1955.282, 'text': 'And now it knows that category is the parent to subcategory.', 'start': 1949.798, 'duration': 5.484}, {'end': 1963.027, 'text': "Let's do the same thing by grabbing the product name and putting it underneath subcategory.", 'start': 1955.902, 'duration': 7.125}], 'summary': 'Analyzing sales data to identify highest and lowest selling products, creating product hierarchy.', 'duration': 88.795, 'max_score': 1874.232, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA1874232.jpg'}], 'start': 1095.509, 'title': 'Tableau visualization techniques', 'summary': 'Explains sorting, labeling, and filters for precise visualization impacting sales and profit, creating visualizations like bar charts, line charts, scatter plots in tableau, and visualizing profit by subcategory and sales hierarchies for improved user experience.', 'chapters': [{'end': 1347.399, 'start': 1095.509, 'title': 'Visual data sorting and labeling', 'summary': 'Explains how to sort data based on measures, adjust label and tooltip settings, and utilize filters for a more precise visualization, illustrating the impact on sales and profit.', 'duration': 251.89, 'highlights': ['The south region has the highest average of sales after sorting by average, contrary to the sum of sales. After sorting the data by average instead of sum, it reveals that the south region has the highest average of sales, indicating a shift in the data interpretation.', 'Demonstrating the process of adjusting labels to display average sales instead of sum of sales. Illustrating the process of changing the label to display average sales instead of sum of sales, showcasing the flexibility in presenting data in different formats.', 'Utilizing filters to selectively display data, such as filtering by region or category. Explaining the use of filters to selectively display data, with examples including filtering by region or category, showcasing the ability to customize the visualization for specific data subsets.', 'Using tooltips to provide additional information when hovering over data elements. Detailing the functionality of tooltips to provide additional information when hovering over data elements, enhancing the user experience and data comprehension.', 'Illustrating the process of adjusting the size of visual elements based on specific measures, such as sales or profit. Demonstrating the process of adjusting the size of visual elements based on specific measures, such as sales or profit, highlighting the dynamic nature of visual data representation.']}, {'end': 1582.098, 'start': 1347.679, 'title': 'Tableau visualization techniques', 'summary': 'Demonstrates how to create various visualizations in tableau, such as bar charts, line charts, scatter plots, and utilizing features like detail, shape, and highlight to analyze sales data and product categories.', 'duration': 234.419, 'highlights': ['Creating scatter plots to analyze sales and discount relationship The scatter plot visualizes the relationship between sales and discount, revealing a trend that high sales products have low discounts and vice versa.', 'Using highlight feature to analyze product categories Utilizing the highlight feature to analyze product categories and their corresponding patterns in the visualization, revealing insights like high discounted items being predominantly office supplies and identifying the product with the highest sales.', 'Utilizing detail and shape cards for visualization Explaining the use of detail and shape cards to determine the level of visualization and represent categories, and using it to identify outliers and analyze sales and discounts at a granular level.']}, {'end': 1844.131, 'start': 1584.637, 'title': 'Visualizing profit by subcategory', 'summary': 'Demonstrates how to visualize profit by subcategory in tableau, highlighting the process of sorting and formatting the visualization to identify the most profitable and unprofitable categories, and making improvements for better clarity and presentation.', 'duration': 259.494, 'highlights': ['By visualizing profit by subcategory in Tableau, users can quickly identify the most profitable and unprofitable categories, aiding in decision-making (e.g., not selling unprofitable items such as tables) (3 counts).', 'The process of sorting subcategories in descending order by profit within each category ensures that the visualization effectively presents the profitability of each subcategory within its respective category (2 counts).', 'Formatting tips for improving the visualization include rotating labels for better readability, renaming the sheet for a clearer title, formatting profit as currency, and hiding unnecessary field labels for columns (4 counts).', 'Tableau offers multiple options for color and formatting customization, allowing users to enhance the visual representation of data for clearer insights and presentation (2 counts).']}, {'end': 2119.832, 'start': 1845.112, 'title': 'Tableau sales visualization', 'summary': 'Covers creating hierarchies in tableau to visualize sales data by product, subcategory, and category, improving user experience and efficiency by providing detailed information without changing the visualization.', 'duration': 274.72, 'highlights': ['Creating hierarchies allows for efficient visualization of sales data by product, subcategory, and category. The chapter explains how to create a hierarchy in Tableau by organizing sales data into product, subcategory, and category, enabling efficient visualization and analysis.', 'Utilizing hierarchies improves user experience by providing detailed information without changing the visualization. Hierarchies in Tableau allow users to drill down into specific details without altering the visualization, enhancing user experience and efficiency in data analysis.', 'Coloring data points based on sales improves visibility and quick understanding of sales distribution. The use of color to represent sales data in Tableau enhances visibility and quick understanding of sales distribution, enabling users to identify the highest sales regions and products at a glance.']}], 'duration': 1024.323, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA1095509.jpg', 'highlights': ['By visualizing profit by subcategory in Tableau, users can quickly identify the most profitable and unprofitable categories, aiding in decision-making (3 counts).', 'Formatting tips for improving the visualization include rotating labels for better readability, renaming the sheet for a clearer title, formatting profit as currency, and hiding unnecessary field labels for columns (4 counts).', 'Utilizing filters to selectively display data, such as filtering by region or category. Explaining the use of filters to selectively display data, with examples including filtering by region or category, showcasing the ability to customize the visualization for specific data subsets.', 'Creating hierarchies allows for efficient visualization of sales data by product, subcategory, and category. The chapter explains how to create a hierarchy in Tableau by organizing sales data into product, subcategory, and category, enabling efficient visualization and analysis.', 'Utilizing hierarchies improves user experience by providing detailed information without changing the visualization. Hierarchies in Tableau allow users to drill down into specific details without altering the visualization, enhancing user experience and efficiency in data analysis.']}, {'end': 2662.677, 'segs': [{'end': 2278.866, 'src': 'embed', 'start': 2248.892, 'weight': 0, 'content': [{'end': 2252.795, 'text': "So we've got year, but we also have year here, quarter and quarter.", 'start': 2248.892, 'duration': 3.903}, {'end': 2262.261, 'text': 'Now the top ones are all discrete, and when I change it to a bottom, one year, same thing, same year it changes it to be green,', 'start': 2252.995, 'duration': 9.266}, {'end': 2263.641, 'text': "and now it's continuous.", 'start': 2262.261, 'duration': 1.38}, {'end': 2270.043, 'text': "So now instead of this being a header for 2013 and a header for 2014, it's an axis.", 'start': 2264.662, 'duration': 5.381}, {'end': 2278.866, 'text': 'So the difference here is when I press the plus and it changes it to quarter instead of adding quarter to year.', 'start': 2270.524, 'duration': 8.342}], 'summary': 'The data can be displayed as discrete or continuous, with the change affecting the axis and the addition of quarter to year.', 'duration': 29.974, 'max_score': 2248.892, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2248892.jpg'}, {'end': 2447.687, 'src': 'heatmap', 'start': 2278.866, 'weight': 0.711, 'content': [{'end': 2284.067, 'text': "now it's doing quarter for each year and making one continuous line.", 'start': 2278.866, 'duration': 5.201}, {'end': 2287.388, 'text': 'And we can keep going and drill down to month.', 'start': 2284.467, 'duration': 2.921}, {'end': 2290.498, 'text': 'you can go pretty far.', 'start': 2289.417, 'duration': 1.081}, {'end': 2299.349, 'text': 'Now, when we add category as color, we get our three lines for the three categories, and we also have highlighting turned on here.', 'start': 2291.279, 'duration': 8.07}, {'end': 2304.114, 'text': 'still so, when we click on technology, we can highlight technology with the others in the background,', 'start': 2299.349, 'duration': 4.765}, {'end': 2306.958, 'text': "so we don't lose the context of the other categories.", 'start': 2304.114, 'duration': 2.844}, {'end': 2309.481, 'text': "Let's take that back off.", 'start': 2308.259, 'duration': 1.222}, {'end': 2312.957, 'text': 'Next let us talk about calculated fields.', 'start': 2310.194, 'duration': 2.763}, {'end': 2317.081, 'text': "So we'll make a new sheet and we're going to create our first calculated field.", 'start': 2313.457, 'duration': 3.624}, {'end': 2324.849, 'text': 'We can create a calculated field by clicking this arrow, which gives us some options, and clicking create calculated field,', 'start': 2317.221, 'duration': 7.628}, {'end': 2332.677, 'text': 'or we can come and click in the white space below dimensions or below measures and we right click and click create calculated field.', 'start': 2324.849, 'duration': 7.828}, {'end': 2336.493, 'text': "Let's name it profit ratio.", 'start': 2333.017, 'duration': 3.476}, {'end': 2343.861, 'text': "So this is for if we wanted to create a visualization that showed the profit ratio but we don't have that measure readily available to us.", 'start': 2336.833, 'duration': 7.028}, {'end': 2349.707, 'text': 'To bring in fields for our calculation you can do it in one of two ways.', 'start': 2344.221, 'duration': 5.486}, {'end': 2351.329, 'text': 'One is to start typing it.', 'start': 2350.027, 'duration': 1.302}, {'end': 2362.414, 'text': 'and it will start auto-prompting you for the different measures or for different calculations or values you can use, or you can come and drag it in.', 'start': 2352.765, 'duration': 9.649}, {'end': 2374.746, 'text': 'So if we want profit and we want sales, and if we do profit divided by sales, that is a profit ratio unaggregated.', 'start': 2362.915, 'duration': 11.831}, {'end': 2378.207, 'text': "Okay, and let's make a second calculated field.", 'start': 2375.785, 'duration': 2.422}, {'end': 2383.793, 'text': 'We could come here and click Duplicate, and that will duplicate our field.', 'start': 2378.328, 'duration': 5.465}, {'end': 2393.182, 'text': "But I just want to start over again, so I'll click Create Calculated Field, and I will call it Profit Ratio Aggregated.", 'start': 2384.033, 'duration': 9.149}, {'end': 2398.227, 'text': "And in this one, we're going to do Sum Click of Profit.", 'start': 2393.202, 'duration': 5.025}, {'end': 2404.022, 'text': 'click divided by sum of sales.', 'start': 2399.42, 'duration': 4.602}, {'end': 2411.685, 'text': "okay, so now what's the difference between profit ratio aggregated and profit ratio unaggregated?", 'start': 2404.022, 'duration': 7.663}, {'end': 2414.946, 'text': 'how will those behave differently in tableau?', 'start': 2411.685, 'duration': 3.261}, {'end': 2419.968, 'text': "let's look at this by looking at a single order.", 'start': 2414.946, 'duration': 5.022}, {'end': 2425.362, 'text': "so first let's bring on all the orders and all the products under that order.", 'start': 2419.968, 'duration': 5.394}, {'end': 2427.865, 'text': "And let's look at this order.", 'start': 2425.782, 'duration': 2.083}, {'end': 2432.573, 'text': 'So I want to filter this whole dashboard to only this order.', 'start': 2428.486, 'duration': 4.087}, {'end': 2435.317, 'text': 'So I can right click on it and click keep only.', 'start': 2432.813, 'duration': 2.504}, {'end': 2437.42, 'text': 'That creates a filter up here.', 'start': 2435.898, 'duration': 1.522}, {'end': 2440.942, 'text': 'that only has that box checked.', 'start': 2438.7, 'duration': 2.242}, {'end': 2447.687, 'text': 'And if I want to get rid of this later, I can just pull it right off of filters and everything will come back.', 'start': 2441.823, 'duration': 5.864}], 'summary': 'The transcript covers creating calculated fields and visualizing data in tableau, demonstrating how to drill down to month and utilize highlighting for context.', 'duration': 168.821, 'max_score': 2278.866, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2278866.jpg'}, {'end': 2362.414, 'src': 'embed', 'start': 2336.833, 'weight': 3, 'content': [{'end': 2343.861, 'text': "So this is for if we wanted to create a visualization that showed the profit ratio but we don't have that measure readily available to us.", 'start': 2336.833, 'duration': 7.028}, {'end': 2349.707, 'text': 'To bring in fields for our calculation you can do it in one of two ways.', 'start': 2344.221, 'duration': 5.486}, {'end': 2351.329, 'text': 'One is to start typing it.', 'start': 2350.027, 'duration': 1.302}, {'end': 2362.414, 'text': 'and it will start auto-prompting you for the different measures or for different calculations or values you can use, or you can come and drag it in.', 'start': 2352.765, 'duration': 9.649}], 'summary': 'Explaining two methods to calculate profit ratio for visualization.', 'duration': 25.581, 'max_score': 2336.833, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2336833.jpg'}, {'end': 2488.691, 'src': 'embed', 'start': 2456.895, 'weight': 1, 'content': [{'end': 2458.996, 'text': 'I double clicked on it and I added it here.', 'start': 2456.895, 'duration': 2.101}, {'end': 2461.258, 'text': 'And profit ratio unaggregated.', 'start': 2459.657, 'duration': 1.601}, {'end': 2463.92, 'text': "Again, double clicking and now they're side by side.", 'start': 2461.538, 'duration': 2.382}, {'end': 2466.482, 'text': "Let's give us a little bit more room.", 'start': 2464.08, 'duration': 2.402}, {'end': 2472.565, 'text': 'So when I dragged that out, it gave us more room so we could see them side by side in the entire titles.', 'start': 2467.543, 'duration': 5.022}, {'end': 2482.588, 'text': 'Okay, so I chose to look at one order and these product names because the combination of order and product name is unique, one per row.', 'start': 2472.885, 'duration': 9.703}, {'end': 2488.691, 'text': 'We know that Tableau will aggregate the data up to the lowest level in the visualization,', 'start': 2482.769, 'duration': 5.922}], 'summary': 'Demonstrating data manipulation in tableau for side-by-side comparison and unique product-order combinations.', 'duration': 31.796, 'max_score': 2456.895, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2456895.jpg'}], 'start': 2119.832, 'title': 'Tableau date hierarchies and calculated fields', 'summary': 'Covers the use of hierarchies in tableau dates for visual comparison of profit over time and category impact, as well as the creation and distinction of profit ratio aggregated and unaggregated calculated fields, emphasizing the importance of understanding aggregation before calculation.', 'chapters': [{'end': 2299.349, 'start': 2119.832, 'title': 'Tableau date hierarchies', 'summary': 'Discusses the use of hierarchies in tableau dates, allowing for quick visual comparison of profit over time, analysis of category impact on trends, and the distinction between discrete and continuous dates.', 'duration': 179.517, 'highlights': ['Dates in Tableau allow for quick visual comparison of profit over time for different years and quarters. The chapter demonstrates how Tableau allows for quick comparison of profit over time for different years and quarters, aiding in visual analysis.', 'Analysis of category impact on trends, showcasing the responsibility of a drop in technology for a decline in quarter two of 2016. The chapter illustrates how the analysis of category impact on trends reveals the responsibility of a drop in technology for a decline in quarter two of 2016.', 'Distinction between discrete and continuous dates, and the impact on visual representations and drill-down capabilities. The chapter explains the distinction between discrete and continuous dates, highlighting their impact on visual representations and drill-down capabilities in Tableau.']}, {'end': 2662.677, 'start': 2299.349, 'title': 'Tableau calculated fields', 'summary': 'Explains how to create and differentiate between profit ratio aggregated and unaggregated calculated fields in tableau, demonstrating their behavior with an example and emphasizing the importance of understanding aggregation before calculation.', 'duration': 363.328, 'highlights': ['The chapter explains the process of creating calculated fields in Tableau, specifically focusing on creating the profit ratio aggregated and unaggregated fields. It details the steps to create calculated fields, emphasizing the creation of profit ratio aggregated and unaggregated fields in Tableau.', 'The importance of understanding aggregation before calculation is highlighted, as it demonstrates the behavior and difference between profit ratio aggregated and unaggregated fields with a specific example. It emphasizes the significance of comprehending aggregation before calculation by demonstrating the behavior and distinction between profit ratio aggregated and unaggregated fields using a specific example.', 'The difference in behavior between profit ratio aggregated and unaggregated calculated fields is demonstrated through an example, showcasing how they aggregate and calculate differently at the lowest level of data. It demonstrates the variance in behavior between profit ratio aggregated and unaggregated calculated fields by showcasing how they aggregate and calculate differently at the lowest level of data.']}], 'duration': 542.845, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2119832.jpg', 'highlights': ['Dates in Tableau allow for quick visual comparison of profit over time for different years and quarters, aiding in visual analysis.', 'The chapter illustrates how the analysis of category impact on trends reveals the responsibility of a drop in technology for a decline in quarter two of 2016.', 'The chapter explains the distinction between discrete and continuous dates, highlighting their impact on visual representations and drill-down capabilities in Tableau.', 'It details the steps to create calculated fields, emphasizing the creation of profit ratio aggregated and unaggregated fields in Tableau.', 'It emphasizes the significance of comprehending aggregation before calculation by demonstrating the behavior and distinction between profit ratio aggregated and unaggregated fields using a specific example.', 'It demonstrates the variance in behavior between profit ratio aggregated and unaggregated calculated fields by showcasing how they aggregate and calculate differently at the lowest level of data.']}, {'end': 3392.765, 'segs': [{'end': 2741.209, 'src': 'embed', 'start': 2713.938, 'weight': 6, 'content': [{'end': 2717.283, 'text': 'And so we have customer name and customer ID.', 'start': 2713.938, 'duration': 3.345}, {'end': 2726.014, 'text': "Let's do count distinct of customer ID and that gives us the total number of customers.", 'start': 2717.663, 'duration': 8.351}, {'end': 2734.782, 'text': 'so right now we could take total number of customers and see which categories have the highest number of customers.', 'start': 2727.595, 'duration': 7.187}, {'end': 2737.205, 'text': "perfect, that's just one part of our calculation.", 'start': 2734.782, 'duration': 2.423}, {'end': 2741.209, 'text': 'we want to see total sales divided by total number of customers.', 'start': 2737.205, 'duration': 4.004}], 'summary': 'Analyzing customer data to identify categories with highest number of customers and calculate sales per customer.', 'duration': 27.271, 'max_score': 2713.938, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2713938.jpg'}, {'end': 2937.782, 'src': 'heatmap', 'start': 2851.335, 'weight': 0.712, 'content': [{'end': 2856.437, 'text': "But let's go to advanced and make the center number zero.", 'start': 2851.335, 'duration': 5.102}, {'end': 2862.139, 'text': "This means that it will never be red unless it's less than zero.", 'start': 2857.097, 'duration': 5.042}, {'end': 2863.1, 'text': "So let's hit apply.", 'start': 2862.159, 'duration': 0.941}, {'end': 2867.562, 'text': "So it's all blue, and if anything ever goes negative, then it will be red.", 'start': 2863.46, 'duration': 4.102}, {'end': 2874.105, 'text': "Okay, let's call this sheet sales profit by region.", 'start': 2867.582, 'duration': 6.523}, {'end': 2883.136, 'text': "Perfect Now we're going to start using our geographical fields.", 'start': 2877.295, 'duration': 5.841}, {'end': 2887.017, 'text': 'So we have state, city, country, and postal code.', 'start': 2883.456, 'duration': 3.561}, {'end': 2889.417, 'text': "Let's double click on state and see what happens.", 'start': 2887.237, 'duration': 2.18}, {'end': 2893.718, 'text': 'Awesome So it has generated these two fields.', 'start': 2890.157, 'duration': 3.561}, {'end': 2896.879, 'text': 'Tableau has generated longitude and latitude for us.', 'start': 2893.778, 'duration': 3.101}, {'end': 2904.54, 'text': "And it's been able to recognize the states in the United States and where they're located and given it a longitude and latitude.", 'start': 2897.539, 'duration': 7.001}, {'end': 2916.403, 'text': "So next we will look at sales by state by double clicking on sales and what it's done was change the size of the dot based on sales.", 'start': 2905.2, 'duration': 11.203}, {'end': 2925.906, 'text': "Now I think I'm going to move sales from size to color and it has automatically changed it to a filled map instead of dots on a map.", 'start': 2916.603, 'duration': 9.303}, {'end': 2929.067, 'text': 'Perfect So now we can see the states.', 'start': 2926.546, 'duration': 2.521}, {'end': 2932.997, 'text': 'with the biggest amount of sails.', 'start': 2930.034, 'duration': 2.963}, {'end': 2937.782, 'text': "Let's put it back onto size, and we have our circles again.", 'start': 2933.577, 'duration': 4.205}], 'summary': 'In tableau, setting center number to zero makes it blue, red if negative. geographical fields generate longitude and latitude. sales visualized by state with dots and filled map.', 'duration': 86.447, 'max_score': 2851.335, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2851335.jpg'}, {'end': 3000.236, 'src': 'embed', 'start': 2969.01, 'weight': 0, 'content': [{'end': 2978.498, 'text': 'So you can see anything that is more profitable is darker, and anything that is less profitable, or less than zero in this case, is orange.', 'start': 2969.01, 'duration': 9.488}, {'end': 2980.699, 'text': "Let's do what we did with color before.", 'start': 2978.758, 'duration': 1.941}, {'end': 2987.908, 'text': 'change it to red blue diverging and set our center point to zero.', 'start': 2981.724, 'duration': 6.184}, {'end': 2993.912, 'text': 'Okay, so now we know that if anything is red it was negative in profit.', 'start': 2987.928, 'duration': 5.984}, {'end': 3000.236, 'text': "Perfect, let's name this sheet sales profit by state.", 'start': 2994.372, 'duration': 5.864}], 'summary': 'Visualized sales profit by state using color-coded representation.', 'duration': 31.226, 'max_score': 2969.01, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2969010.jpg'}, {'end': 3134.118, 'src': 'embed', 'start': 3101.531, 'weight': 4, 'content': [{'end': 3104.153, 'text': 'And we can see our sales versus our profit.', 'start': 3101.531, 'duration': 2.622}, {'end': 3109.056, 'text': "At least they're not the same amount of dollars, obviously.", 'start': 3104.633, 'duration': 4.423}, {'end': 3112.658, 'text': 'But we can see a higher sales and a higher profit.', 'start': 3109.176, 'duration': 3.482}, {'end': 3115.38, 'text': 'We also have medium sales and a medium profit.', 'start': 3112.778, 'duration': 2.602}, {'end': 3118.602, 'text': 'We have a medium sales but a really low profit.', 'start': 3115.42, 'duration': 3.182}, {'end': 3120.584, 'text': "And it's interesting to see that contrast.", 'start': 3118.682, 'duration': 1.902}, {'end': 3122.025, 'text': "So let's rename this sheet.", 'start': 3120.804, 'duration': 1.221}, {'end': 3128.893, 'text': 'as sales profit by category.', 'start': 3123.065, 'duration': 5.828}, {'end': 3134.118, 'text': "And finally, we're going to make our details sheet.", 'start': 3130.715, 'duration': 3.403}], 'summary': 'Sales and profit vary, with higher sales leading to higher profit, and medium sales resulting in medium profit, while medium sales with low profit show an interesting contrast.', 'duration': 32.587, 'max_score': 3101.531, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3101531.jpg'}, {'end': 3345.73, 'src': 'heatmap', 'start': 3173.563, 'weight': 0.802, 'content': [{'end': 3179.686, 'text': "We actually don't have to do that for sales because sales will never be negative, but it's pretty important for profit.", 'start': 3173.563, 'duration': 6.123}, {'end': 3185.909, 'text': "So we'll go to the profit marks card and take profit onto color and do the same thing there.", 'start': 3179.946, 'duration': 5.963}, {'end': 3191.692, 'text': 'We have red, blue diverging, advanced, center is zero.', 'start': 3186.509, 'duration': 5.183}, {'end': 3195.954, 'text': "Great So now if it's negative, it will be there.", 'start': 3192.132, 'duration': 3.822}, {'end': 3197.095, 'text': "So let's sort this.", 'start': 3196.194, 'duration': 0.901}, {'end': 3198.635, 'text': 'by profit.', 'start': 3198.015, 'duration': 0.62}, {'end': 3202.337, 'text': 'And so both of them have sorted with profit in mind.', 'start': 3199.176, 'duration': 3.161}, {'end': 3206.999, 'text': 'And we can easily see our subcategories that have a negative profit.', 'start': 3202.577, 'duration': 4.422}, {'end': 3210.8, 'text': "Rename this, and we'll call it our details sheet.", 'start': 3207.859, 'duration': 2.941}, {'end': 3216.923, 'text': 'So now we have these four visualizations that all have to do with similar information.', 'start': 3211.441, 'duration': 5.482}, {'end': 3220.216, 'text': 'I think I want these bigger on the states.', 'start': 3217.935, 'duration': 2.281}, {'end': 3221.997, 'text': "So we'll just keep making that bigger.", 'start': 3220.576, 'duration': 1.421}, {'end': 3225.738, 'text': "Perfect Now we're going to make our first dashboard.", 'start': 3222.297, 'duration': 3.441}, {'end': 3232.961, 'text': 'So for our dashboard we have information over here that shows you what sheets you can bring on.', 'start': 3226.158, 'duration': 6.803}, {'end': 3238.583, 'text': "These get a little bit more complex so they'll be covered in more in-depth type of videos.", 'start': 3233.161, 'duration': 5.422}, {'end': 3241.164, 'text': 'And then we have our size.', 'start': 3238.983, 'duration': 2.181}, {'end': 3244.165, 'text': 'So we could make a range of sizes.', 'start': 3241.364, 'duration': 2.801}, {'end': 3256.609, 'text': "based on, maybe, what you're viewing this on, but we're just going to change it to a fixed size and we're going to make it 1400 by 1000,", 'start': 3244.645, 'duration': 11.964}, {'end': 3261.071, 'text': 'and this is our dashboard size.', 'start': 3256.609, 'duration': 4.462}, {'end': 3266.173, 'text': "so let's bring on sales, profit by region, sales and profit by state.", 'start': 3261.071, 'duration': 5.102}, {'end': 3272.497, 'text': 'Now a map needs a little bit more horizontal space than region does.', 'start': 3267.333, 'duration': 5.164}, {'end': 3279.201, 'text': "Let's bring sales and profit by category underneath the region and the detail underneath the state.", 'start': 3272.917, 'duration': 6.284}, {'end': 3281.243, 'text': 'Give our map more space again.', 'start': 3279.702, 'duration': 1.541}, {'end': 3287.589, 'text': 'Perfect Now Tableau has this neat feature called uses filter.', 'start': 3281.803, 'duration': 5.786}, {'end': 3296.217, 'text': 'So you can click uses filter here and now if I click on any of these it will filter the other dashboards based on these features.', 'start': 3287.969, 'duration': 8.248}, {'end': 3302.083, 'text': 'So if I just want to look at the south and I click on south it zooms in to all my south states.', 'start': 3296.557, 'duration': 5.526}, {'end': 3304.245, 'text': 'Now my categories have updated.', 'start': 3302.363, 'duration': 1.882}, {'end': 3309.147, 'text': 'to be just the south ones, and my details have updated as well.', 'start': 3304.685, 'duration': 4.462}, {'end': 3318.17, 'text': 'so we could see that central has pretty big sales, you know bigger than the south, but the profit is lower than the south.', 'start': 3309.147, 'duration': 9.023}, {'end': 3321.692, 'text': 'so we can click on central and focus on central.', 'start': 3318.17, 'duration': 3.522}, {'end': 3322.992, 'text': "let's use.", 'start': 3321.692, 'duration': 1.3}, {'end': 3329.399, 'text': 'that uses filter on all three of these dashboards that lead us up to the detail.', 'start': 3322.992, 'duration': 6.407}, {'end': 3338.265, 'text': "So building a quick dashboard like this let's make this taller would allow you to do some sort of analysis such as let's take a look at Central,", 'start': 3329.7, 'duration': 8.565}, {'end': 3341.207, 'text': 'because they have relatively high profits but low sales.', 'start': 3338.265, 'duration': 2.942}, {'end': 3345.73, 'text': 'So we click on Central and then we see, oh man, Texas is having a really hard time.', 'start': 3341.347, 'duration': 4.383}], 'summary': 'Creating a dashboard in tableau for sales and profit analysis, utilizing filters for in-depth visualization and analysis.', 'duration': 172.167, 'max_score': 3173.563, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3173563.jpg'}, {'end': 3238.583, 'src': 'embed', 'start': 3207.859, 'weight': 1, 'content': [{'end': 3210.8, 'text': "Rename this, and we'll call it our details sheet.", 'start': 3207.859, 'duration': 2.941}, {'end': 3216.923, 'text': 'So now we have these four visualizations that all have to do with similar information.', 'start': 3211.441, 'duration': 5.482}, {'end': 3220.216, 'text': 'I think I want these bigger on the states.', 'start': 3217.935, 'duration': 2.281}, {'end': 3221.997, 'text': "So we'll just keep making that bigger.", 'start': 3220.576, 'duration': 1.421}, {'end': 3225.738, 'text': "Perfect Now we're going to make our first dashboard.", 'start': 3222.297, 'duration': 3.441}, {'end': 3232.961, 'text': 'So for our dashboard we have information over here that shows you what sheets you can bring on.', 'start': 3226.158, 'duration': 6.803}, {'end': 3238.583, 'text': "These get a little bit more complex so they'll be covered in more in-depth type of videos.", 'start': 3233.161, 'duration': 5.422}], 'summary': 'Creating a dashboard with four visualizations, focusing on state data.', 'duration': 30.724, 'max_score': 3207.859, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3207859.jpg'}, {'end': 3404.933, 'src': 'embed', 'start': 3369.925, 'weight': 8, 'content': [{'end': 3375.488, 'text': 'And we can see all the products by subcategory that are really just killing us.', 'start': 3369.925, 'duration': 5.563}, {'end': 3379.344, 'text': 'and are maybe not worthwhile to make anymore.', 'start': 3376.659, 'duration': 2.685}, {'end': 3385.375, 'text': "So we're gonna have to reconsider making the 3.6 cubic foot counter height office refrigerator.", 'start': 3379.645, 'duration': 5.73}, {'end': 3387.9, 'text': "At least for Texas, it's not very helpful there.", 'start': 3385.575, 'duration': 2.325}, {'end': 3392.765, 'text': 'And then, when you back out of that subcategory section,', 'start': 3388.362, 'duration': 4.403}, {'end': 3404.933, 'text': 'you can also click somewhere neutral in the dashboard or click on each thing that you had selected to unselect it and go back to the main part of your visualization and start it all over again.', 'start': 3392.765, 'duration': 12.168}], 'summary': "Consider discontinuing 3.6 cubic foot office refrigerator for texas, as it's not very helpful there.", 'duration': 35.008, 'max_score': 3369.925, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3369925.jpg'}], 'start': 2662.978, 'title': 'Tableau visualizations and dashboards', 'summary': 'Demonstrates creating visualizations including bar charts, calculated fields, geographical mapping, and interactive dashboards with filters for data-driven decisions.', 'chapters': [{'end': 3206.999, 'start': 2662.978, 'title': 'Creating visualizations in tableau', 'summary': 'Demonstrates the process of creating various visualizations in tableau, including building bar charts, calculated fields for sales per customer, using geographical fields for mapping sales, and creating bar charts for sales and profit by category and subcategory.', 'duration': 544.021, 'highlights': ['Creating bar charts for sales and profit by category and subcategory The transcript describes the process of creating bar charts for sales and profit by category and subcategory, allowing the comparison of sales and profit for different product categories and subcategories.', 'Using geographical fields for mapping sales The chapter demonstrates the use of geographical fields for mapping sales data, including the generation of longitude and latitude for states in the United States and visualizing sales on a filled map based on the size of the dot.', 'Building bar charts and calculated fields for sales per customer The process of building bar charts and calculated fields for sales per customer is explained, including the creation of calculated fields for the count of customers and sales per customer ratio.']}, {'end': 3392.765, 'start': 3207.859, 'title': 'Creating interactive dashboards in tableau', 'summary': 'Details the process of creating interactive dashboards in tableau, including resizing visualizations, utilizing filters for interactive analysis, and making data-driven decisions based on the insights obtained, leading to potential product reconsideration.', 'duration': 184.906, 'highlights': ['The process of creating interactive dashboards in Tableau, including resizing visualizations, utilizing filters for interactive analysis, and making data-driven decisions based on the insights obtained.', "Demonstrating the use of 'uses filter' feature in Tableau to interactively filter data across multiple dashboards based on user selections.", 'Analyzing sales and profit data by region and state, allowing for the identification of areas with high profits but low sales, leading to potential product reconsideration.', 'Utilizing Tableau to identify specific products and subcategories that are not performing well in certain regions, leading to potential product reconsideration.', 'Detailing the process of reconsidering the viability of specific products, such as the 3.6 cubic foot counter height office refrigerator, based on the analysis of sales and profit data in Tableau.']}], 'duration': 729.787, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA2662978.jpg', 'highlights': ['Demonstrates creating visualizations including bar charts, calculated fields, geographical mapping, and interactive dashboards with filters for data-driven decisions.', 'Creating bar charts for sales and profit by category and subcategory, allowing the comparison of sales and profit for different product categories and subcategories.', 'Using geographical fields for mapping sales data, including the generation of longitude and latitude for states in the United States and visualizing sales on a filled map based on the size of the dot.', 'Building bar charts and calculated fields for sales per customer, including the creation of calculated fields for the count of customers and sales per customer ratio.', 'The process of creating interactive dashboards in Tableau, including resizing visualizations, utilizing filters for interactive analysis, and making data-driven decisions based on the insights obtained.', "Demonstrating the use of 'uses filter' feature in Tableau to interactively filter data across multiple dashboards based on user selections.", 'Analyzing sales and profit data by region and state, allowing for the identification of areas with high profits but low sales, leading to potential product reconsideration.', 'Utilizing Tableau to identify specific products and subcategories that are not performing well in certain regions, leading to potential product reconsideration.', 'Detailing the process of reconsidering the viability of specific products, such as the 3.6 cubic foot counter height office refrigerator, based on the analysis of sales and profit data in Tableau.']}, {'end': 4778.35, 'segs': [{'end': 3506.777, 'src': 'heatmap', 'start': 3417.932, 'weight': 0.79, 'content': [{'end': 3425.699, 'text': "So let's take a look at all of our customers by their sales and let's sort customer name descending by sales.", 'start': 3417.932, 'duration': 7.767}, {'end': 3434.446, 'text': "Great. So now we're going to make a parameter that will allow the user of the dashboard to choose how many customers they want to see,", 'start': 3426.039, 'duration': 8.407}, {'end': 3437.008, 'text': 'how many of our top customers that they want to see.', 'start': 3434.446, 'duration': 2.562}, {'end': 3446.316, 'text': "So let's click this down arrow and click create parameter and we will name it top end customers.", 'start': 3437.789, 'duration': 8.527}, {'end': 3456.615, 'text': "Great We're going to make it an integer and we're going to give them the option to choose the number of customers within a range.", 'start': 3448.885, 'duration': 7.73}, {'end': 3464.011, 'text': "Our low is going to be 5, so we'll let them see 5 or up to 20.", 'start': 3457.135, 'duration': 6.876}, {'end': 3467.795, 'text': "and we're going to let them skip with step size of 5.", 'start': 3464.011, 'duration': 3.784}, {'end': 3472.359, 'text': "Let's start their current value right in the middle with 10.", 'start': 3467.795, 'duration': 4.564}, {'end': 3476.884, 'text': 'Okay, so now if you want to see how this parameter looks, you can come down to parameters.', 'start': 3472.359, 'duration': 4.525}, {'end': 3482.55, 'text': 'Before we only had dimensions and measures on the left side of our Tableau workspace,', 'start': 3477.364, 'duration': 5.186}, {'end': 3485.693, 'text': "but now we have parameters that it's appeared once we create a parameter.", 'start': 3482.55, 'duration': 3.143}, {'end': 3491.315, 'text': 'We can right-click on that parameter and click Show Parameter Control, and we can see our top-end customers.', 'start': 3485.973, 'duration': 5.342}, {'end': 3496.197, 'text': "Right now, our parameter control isn't built into any of our visualizations, but you can see how it works.", 'start': 3491.575, 'duration': 4.622}, {'end': 3497.938, 'text': 'We allow them to go down to five.', 'start': 3496.397, 'duration': 1.541}, {'end': 3503.675, 'text': 'and up to 20 with steps of five.', 'start': 3499.413, 'duration': 4.262}, {'end': 3506.777, 'text': "Great Now we're going to create a set.", 'start': 3504.316, 'duration': 2.461}], 'summary': "Create a parameter 'top end customers' with range 5-20, step size 5, default value 10, and set up parameter control in tableau workspace.", 'duration': 88.845, 'max_score': 3417.932, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3417932.jpg'}, {'end': 3472.359, 'src': 'embed', 'start': 3448.885, 'weight': 3, 'content': [{'end': 3456.615, 'text': "Great We're going to make it an integer and we're going to give them the option to choose the number of customers within a range.", 'start': 3448.885, 'duration': 7.73}, {'end': 3464.011, 'text': "Our low is going to be 5, so we'll let them see 5 or up to 20.", 'start': 3457.135, 'duration': 6.876}, {'end': 3467.795, 'text': "and we're going to let them skip with step size of 5.", 'start': 3464.011, 'duration': 3.784}, {'end': 3472.359, 'text': "Let's start their current value right in the middle with 10.", 'start': 3467.795, 'duration': 4.564}], 'summary': 'Creating an integer customer range from 5 to 20, with a step size of 5, starting from 10.', 'duration': 23.474, 'max_score': 3448.885, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3448885.jpg'}, {'end': 3913.936, 'src': 'heatmap', 'start': 3664.732, 'weight': 0.793, 'content': [{'end': 3671.276, 'text': "So let's start by building a pie chart, which in Tableau is pretty easy, especially if you use Show Me.", 'start': 3664.732, 'duration': 6.544}, {'end': 3675.999, 'text': "So let's create a pie chart for each category.", 'start': 3671.577, 'duration': 4.422}, {'end': 3678.001, 'text': 'by sales.', 'start': 3676.9, 'duration': 1.101}, {'end': 3680.962, 'text': "so we're going to click category and then we're going to control.", 'start': 3678.001, 'duration': 2.961}, {'end': 3681.682, 'text': 'click sales.', 'start': 3680.962, 'duration': 0.72}, {'end': 3683.083, 'text': 'so we have them both selected.', 'start': 3681.682, 'duration': 1.401}, {'end': 3688.986, 'text': "we'll come over to show me and click pie, and there we have our pie chart.", 'start': 3683.083, 'duration': 5.903}, {'end': 3689.566, 'text': "we'll close.", 'start': 3688.986, 'duration': 0.58}, {'end': 3690.106, 'text': 'show me.', 'start': 3689.566, 'duration': 0.54}, {'end': 3693.768, 'text': "let's come up here and click entire view.", 'start': 3690.106, 'duration': 3.662}, {'end': 3696.329, 'text': 'so we see our pie very clearly here.', 'start': 3693.768, 'duration': 2.561}, {'end': 3703.353, 'text': 'if we wanted to have one pie for each region, we can take region and drag that onto columns.', 'start': 3696.329, 'duration': 7.024}, {'end': 3707.915, 'text': 'So we have one column for each region and then one pi for each of them.', 'start': 3704.033, 'duration': 3.882}, {'end': 3714.237, 'text': 'You can see that the pi varies in size based on sales as well as the angle is for sales.', 'start': 3708.235, 'duration': 6.002}, {'end': 3718.379, 'text': 'So East has more sales in general than South.', 'start': 3714.617, 'duration': 3.762}, {'end': 3725.422, 'text': 'And this helps you to see that technology has smaller sales in the south than it does in the east.', 'start': 3719.119, 'duration': 6.303}, {'end': 3734.425, 'text': "So I recommend keeping if you're going to make pie charts, allowing the size of the pie chart to be affected as well as the angle,", 'start': 3725.902, 'duration': 8.523}, {'end': 3736.426, 'text': "by whatever measure you're using.", 'start': 3734.425, 'duration': 2.001}, {'end': 3740.568, 'text': "But for our purposes for donut charts, we're going to want them to all be the same size.", 'start': 3736.766, 'duration': 3.802}, {'end': 3746.33, 'text': 'So we took sales off of size and now we have all of our pie charts the same size.', 'start': 3740.988, 'duration': 5.342}, {'end': 3753.777, 'text': "Now we're going to make what's called a dual axis chart and to make a dual axis chart we have to have two axes.", 'start': 3746.57, 'duration': 7.207}, {'end': 3763.285, 'text': "So let's grab number of records and we'll grab it and drag it to rows and we will change it from sum to minimum.", 'start': 3754.037, 'duration': 9.248}, {'end': 3771.853, 'text': "and that's because every record will have a minimum number of rows of one, and then they all end up on the same axis.", 'start': 3763.285, 'duration': 8.568}, {'end': 3776.316, 'text': "And now we're going to make a second number of records by minimum.", 'start': 3772.173, 'duration': 4.143}, {'end': 3782.78, 'text': 'And we can do that by doing those steps again by dragging number of records up here and changing it to minimum again.', 'start': 3776.616, 'duration': 6.164}, {'end': 3790.686, 'text': 'Or a quick trick that I can show you is if you want to duplicate anything you have on the chart here,', 'start': 3783.501, 'duration': 7.185}, {'end': 3795.189, 'text': 'you can just hit control and then click and drag it and it will duplicate it.', 'start': 3790.686, 'duration': 4.503}, {'end': 3804.134, 'text': 'So if you wanted your number of records to also be down here onto your details or on your labels, You can control click it and then leave it there.', 'start': 3795.569, 'duration': 8.565}, {'end': 3813.319, 'text': 'Great, so now we have our two axes and we have our two marks cards that each affect their own set of visualizations.', 'start': 3804.395, 'duration': 8.924}, {'end': 3817.221, 'text': "So let's go to this top one affects these.", 'start': 3813.539, 'duration': 3.682}, {'end': 3819.623, 'text': "So let's show that by changing the size.", 'start': 3817.662, 'duration': 1.961}, {'end': 3822.102, 'text': "And it's made these bigger.", 'start': 3821.161, 'duration': 0.941}, {'end': 3824.563, 'text': 'And this bottom one affects these.', 'start': 3822.122, 'duration': 2.441}, {'end': 3827.445, 'text': "And we'll do that by changing it to circle.", 'start': 3824.964, 'duration': 2.481}, {'end': 3829.527, 'text': 'So now each of these are a circle.', 'start': 3827.986, 'duration': 1.541}, {'end': 3831.829, 'text': "Let's take category off of color.", 'start': 3829.967, 'duration': 1.862}, {'end': 3834.611, 'text': 'And we can take sum of sales off of detail.', 'start': 3832.129, 'duration': 2.482}, {'end': 3836.792, 'text': "And let's change the color to white.", 'start': 3834.631, 'duration': 2.161}, {'end': 3842.416, 'text': "And now we're going to put this white circle on top of our pie chart by clicking here on our second measure.", 'start': 3837.553, 'duration': 4.863}, {'end': 3844.357, 'text': 'And clicking dual axis.', 'start': 3843.097, 'duration': 1.26}, {'end': 3847.28, 'text': "And now it's got them lined up one on top of the other.", 'start': 3844.958, 'duration': 2.322}, {'end': 3848.781, 'text': 'And we have our donut chart.', 'start': 3847.3, 'duration': 1.481}, {'end': 3850.042, 'text': 'So if we want our donut..', 'start': 3849.061, 'duration': 0.981}, {'end': 3852.78, 'text': 'slices to be a little thinner.', 'start': 3850.993, 'duration': 1.787}, {'end': 3855.851, 'text': 'We can change the size of our inner circle and make it bigger.', 'start': 3852.961, 'duration': 2.89}, {'end': 3863.022, 'text': 'Perfect And so now we have one pie chart for each region, one donut chart for each region.', 'start': 3857.039, 'duration': 5.983}, {'end': 3874.367, 'text': 'And if we wanted to take this header and put it inside of our pie chart, what we can do is take region and put it on the label for the circle.', 'start': 3863.402, 'duration': 10.965}, {'end': 3875.928, 'text': "And it's putting it down here.", 'start': 3874.748, 'duration': 1.18}, {'end': 3880.691, 'text': 'You can come and edit that by clicking on label and changing its alignment.', 'start': 3876.488, 'duration': 4.203}, {'end': 3882.872, 'text': "So let's put it in the middle.", 'start': 3881.211, 'duration': 1.661}, {'end': 3888.256, 'text': "Perfect, so now we can see our header here, so we don't need it down here anymore.", 'start': 3883.912, 'duration': 4.344}, {'end': 3892.66, 'text': 'You can right click and click show header, and it hides that header.', 'start': 3888.637, 'duration': 4.023}, {'end': 3900.127, 'text': "We also don't want to see our labels for our axes, so we right click and click show header there, and now we just see our pies.", 'start': 3892.74, 'duration': 7.387}, {'end': 3913.936, 'text': "So to get how the number of sales here for each of them, let's go to remember our pie marks card and let's take our sales and add it to label.", 'start': 3900.808, 'duration': 13.128}], 'summary': 'Creating pie and donut charts in tableau with sales data and region comparison.', 'duration': 249.204, 'max_score': 3664.732, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3664732.jpg'}, {'end': 4042.553, 'src': 'embed', 'start': 4013.135, 'weight': 1, 'content': [{'end': 4018.779, 'text': "Perfect Now we'll use a similar technique to create the two-dimensional pie chart.", 'start': 4013.135, 'duration': 5.644}, {'end': 4026.704, 'text': 'A two-dimensional pie chart can be used so that you can show two pie charts at the same time,', 'start': 4021.061, 'duration': 5.643}, {'end': 4030.406, 'text': "or a pie chart that's kind of split up by different categories.", 'start': 4026.704, 'duration': 3.702}, {'end': 4034.588, 'text': 'This has been available in some other tools and Tableau can do it too.', 'start': 4030.506, 'duration': 4.082}, {'end': 4036.329, 'text': "So let's just demonstrate that.", 'start': 4034.788, 'duration': 1.541}, {'end': 4042.553, 'text': "We're going to start again by creating our generic category by sales.", 'start': 4036.549, 'duration': 6.004}], 'summary': 'Using a similar technique, create a two-dimensional pie chart to display two pie charts simultaneously or split up by different categories.', 'duration': 29.418, 'max_score': 4013.135, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA4013135.jpg'}, {'end': 4350.12, 'src': 'embed', 'start': 4317.14, 'weight': 0, 'content': [{'end': 4321.945, 'text': 'and so I recommend going through this tutorial with the dataset and following along.', 'start': 4317.14, 'duration': 4.805}, {'end': 4326.49, 'text': 'If you want access to the dataset, just comment below and the Simply Learn team will get back to you.', 'start': 4322.125, 'duration': 4.365}, {'end': 4328.952, 'text': 'Also, comment below with any questions you have.', 'start': 4326.79, 'duration': 2.162}, {'end': 4334.079, 'text': "at this point in the presentation we're going to put together some dashboards.", 'start': 4329.853, 'duration': 4.226}, {'end': 4337.404, 'text': "so first let's build our worksheets for this dashboard.", 'start': 4334.079, 'duration': 3.325}, {'end': 4350.12, 'text': "we're going to build a worksheet called sales by year, which adds the name up here, and we're going to take our order date and drag it on the columns.", 'start': 4337.404, 'duration': 12.716}], 'summary': 'Recommend following tutorial with dataset, build sales by year worksheet for dashboard.', 'duration': 32.98, 'max_score': 4317.14, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA4317140.jpg'}, {'end': 4718.466, 'src': 'embed', 'start': 4688.44, 'weight': 2, 'content': [{'end': 4697.607, 'text': "Let's go to overall, let's come here, filters, category, and now we have a filter that affects both worksheets.", 'start': 4688.44, 'duration': 9.167}, {'end': 4701.542, 'text': 'There we go.', 'start': 4700.882, 'duration': 0.66}, {'end': 4703.723, 'text': "Let's format this filter a little bit.", 'start': 4701.862, 'duration': 1.861}, {'end': 4711.725, 'text': "We'll come to more options, and we're going to select, we want them to be able to select multiple values still, but let's do it in a drop down.", 'start': 4703.943, 'duration': 7.782}, {'end': 4718.466, 'text': 'So now, you still have those options, but it is a little bit more compact.', 'start': 4712.605, 'duration': 5.861}], 'summary': 'Configured a filter to affect multiple worksheets in a more compact format.', 'duration': 30.026, 'max_score': 4688.44, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA4688440.jpg'}], 'start': 3392.765, 'title': 'Tableau visualization techniques', 'summary': 'Covers creating parameters and sets in tableau, controlling data visualization, building donut charts, and creating interactive dashboards with filters. it demonstrates creating two-dimensional pie and donut charts, allowing users to choose top customers to display, and applying filters for sales and profit by year.', 'chapters': [{'end': 3472.359, 'start': 3392.765, 'title': 'Creating parameters and sets in tableau', 'summary': 'Focuses on creating parameters and sets in tableau, allowing users to choose the number of top customers to display, ranging from 5 to 20 with a step size of 5, starting at a default value of 10.', 'duration': 79.594, 'highlights': ["A parameter named 'top end customers' is created to allow users to choose the number of customers they want to see, with a range from 5 to 20 and a step size of 5, starting at a default value of 10.", 'Users can unselect items in the visualization to go back to the main part of the visualization and start the process again.', 'A quick visualization is created to apply the parameters and sets, focusing on sorting customer names by sales in descending order.']}, {'end': 3753.777, 'start': 3472.359, 'title': 'Tableau parameters, sets, and donut chart', 'summary': 'Covers the creation of parameters to control data visualization, the creation of a set to define a subset of data, and the process of building a donut chart based on a pie chart in tableau.', 'duration': 281.418, 'highlights': ['Creating a set based on customer name to define a subset of data The process of creating a set based on customer name to define a subset of data is explained, allowing the selection of top customers by sales.', 'Demonstrating the use of parameters to control visualizations and allowing selection of top customers by sales The demonstration of using parameters to control visualizations and enabling the selection of top customers by sales, with the parameter allowing a range from 5 to 20 with steps of five, is described.', 'Building a donut chart based on a pie chart and utilizing dual axis chart for visualization The process of building a donut chart based on a pie chart, including the use of dual axis chart for visualization, is detailed.']}, {'end': 4501.554, 'start': 3754.037, 'title': 'Creating two-dimensional pie and donut charts', 'summary': 'Demonstrates how to create two-dimensional pie and donut charts in tableau, using techniques such as dual axes, size manipulation, color assignment, and label formatting to visualize sales and profit data by region and year.', 'duration': 747.517, 'highlights': ['The chapter explains how to create dual axes to make a two-dimensional pie chart, using the number of records and sales data, with the same minimum value, and manipulating the size and color to differentiate the segments by region. The technique of creating a two-dimensional pie chart using dual axes, manipulating the size and color to differentiate segments by region.', 'It demonstrates the process of duplicating a chart, replacing the data with profit, and ensuring consistency in labels for sales and profit by year. Demonstrating the process of duplicating a chart, replacing the data with profit, and ensuring consistency in labels for sales and profit by year.', 'The tutorial covers the formatting of labels, default properties, and tooltip customization for enhanced visualization clarity and user experience. Covering the formatting of labels, default properties, and tooltip customization for enhanced visualization clarity and user experience.']}, {'end': 4778.35, 'start': 4502.075, 'title': 'Creating interactive dashboard with filters', 'summary': 'Illustrates the process of creating an interactive dashboard with filters for sales and profit by year, demonstrating how to apply filters to affect multiple worksheets, enable multi-value selection, and use continuous field filters.', 'duration': 276.275, 'highlights': ['Demonstrating the process of applying filters to affect multiple worksheets The chapter illustrates the process of applying filters on sales by year and profit by year worksheets to ensure that a single filter affects both worksheets, allowing for synchronized filtering across the dashboard.', 'Enabling multi-value selection for filters The tutorial explains how to enable multi-value selection for filters, allowing users to select multiple values for categories and regions, enhancing the flexibility and customization of the dashboard.', 'Explaining the implementation of continuous field filters The chapter discusses the differences in implementing filters for continuous fields, emphasizing the creation of a range for continuous fields rather than a list, providing insights into the unique aspects of continuous field filtering.']}], 'duration': 1385.585, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA3392765.jpg', 'highlights': ["Creating a parameter named 'top end customers' to allow users to choose the number of customers they want to see, with a range from 5 to 20 and a step size of 5, starting at a default value of 10.", 'Demonstrating the process of applying filters to affect multiple worksheets, ensuring that a single filter affects both worksheets, allowing for synchronized filtering across the dashboard.', 'Building a donut chart based on a pie chart and utilizing dual axis chart for visualization.', 'The tutorial covers the formatting of labels, default properties, and tooltip customization for enhanced visualization clarity and user experience.']}, {'end': 5955.271, 'segs': [{'end': 4804.425, 'src': 'embed', 'start': 4778.35, 'weight': 7, 'content': [{'end': 4786.474, 'text': "so we've already defined that we want it to be continuous year, and if I come over here and click on right click order date and click show filter,", 'start': 4778.35, 'duration': 8.124}, {'end': 4788.555, 'text': "it's doing discrete year by default.", 'start': 4786.474, 'duration': 2.081}, {'end': 4791.216, 'text': 'So remove filter.', 'start': 4789.315, 'duration': 1.901}, {'end': 4798.001, 'text': 'If you drag order date onto filters, it lets you pick what you want it to look at.', 'start': 4791.677, 'duration': 6.324}, {'end': 4804.425, 'text': "Let's come up here to year, that's already marked as continuous, and click show filter.", 'start': 4799.021, 'duration': 5.404}], 'summary': 'The goal is to display continuous year data by utilizing filters in the order date field.', 'duration': 26.075, 'max_score': 4778.35, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA4778350.jpg'}, {'end': 4908.192, 'src': 'embed', 'start': 4877.406, 'weight': 0, 'content': [{'end': 4879.107, 'text': 'so go to sheet.', 'start': 4877.406, 'duration': 1.701}, {'end': 4886.411, 'text': "now we're going to do a dual access chart again, like we showed earlier, and i'm going to control, click and drag.", 'start': 4879.107, 'duration': 7.304}, {'end': 4889.833, 'text': 'so now we have sum of sales twice.', 'start': 4886.411, 'duration': 3.422}, {'end': 4892.534, 'text': 'this marks card affects the top one.', 'start': 4889.833, 'duration': 2.701}, {'end': 4898.577, 'text': 'so we can see that by if i change the opacity, how it changes the color.', 'start': 4892.534, 'duration': 6.043}, {'end': 4903.731, 'text': 'right here this is the top one And this marks card is the bottom one.', 'start': 4898.577, 'duration': 5.154}, {'end': 4908.192, 'text': "And we're going to remove region off of color.", 'start': 4904.131, 'duration': 4.061}], 'summary': 'Demonstrating dual access chart with sum of sales, and adjusting opacity for color change.', 'duration': 30.786, 'max_score': 4877.406, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA4877406.jpg'}, {'end': 4956.898, 'src': 'embed', 'start': 4931.38, 'weight': 9, 'content': [{'end': 4935.921, 'text': "Region is missing because we don't have it with the color by region anymore.", 'start': 4931.38, 'duration': 4.541}, {'end': 4940.543, 'text': "So we'll erase that and put, oh, we don't want it to be orange.", 'start': 4935.941, 'duration': 4.602}, {'end': 4941.483, 'text': "Let's make it black.", 'start': 4940.723, 'duration': 0.76}, {'end': 4944.152, 'text': 'overall sales.', 'start': 4943.251, 'duration': 0.901}, {'end': 4949.714, 'text': 'Okay, so when you hover here it says overall sales so we can see the difference easily.', 'start': 4944.552, 'duration': 5.162}, {'end': 4956.898, 'text': "Let's make it a little bit more of a color that'll stand out, just a little darker than the others perhaps.", 'start': 4950.155, 'duration': 6.743}], 'summary': 'Adjusting visual elements for better data visibility and differentiation in overall sales.', 'duration': 25.518, 'max_score': 4931.38, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA4931380.jpg'}, {'end': 5055.755, 'src': 'embed', 'start': 5024.525, 'weight': 2, 'content': [{'end': 5029.587, 'text': 'And over here, profit by region.', 'start': 5024.525, 'duration': 5.062}, {'end': 5033.488, 'text': "Just so that it's clear which axis goes to which one.", 'start': 5030.667, 'duration': 2.821}, {'end': 5037.169, 'text': 'Or you can come here and click synchronize axis.', 'start': 5034.408, 'duration': 2.761}, {'end': 5041.51, 'text': "So it's very clear that this is much bigger than these.", 'start': 5037.749, 'duration': 3.761}, {'end': 5046.732, 'text': "And if you synchronize the axis, let's go back before we named him.", 'start': 5042.43, 'duration': 4.302}, {'end': 5055.755, 'text': "okay, synchronize the axis, then we don't need both of these headers, so we can come here and click show header and we just have the one.", 'start': 5047.572, 'duration': 8.183}], 'summary': 'Demonstrating synchronization of axes to show clear and concise data visualization.', 'duration': 31.23, 'max_score': 5024.525, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA5024525.jpg'}, {'end': 5359.511, 'src': 'embed', 'start': 5330.562, 'weight': 3, 'content': [{'end': 5333.623, 'text': "We can choose one of these different palettes if we'd like.", 'start': 5330.562, 'duration': 3.061}, {'end': 5334.863, 'text': "Let's try this one.", 'start': 5333.643, 'duration': 1.22}, {'end': 5344.359, 'text': 'blue teal or we could do green so that darker green means more money Great.', 'start': 5337.188, 'duration': 7.171}, {'end': 5348.182, 'text': 'So now we have all of our states colored by sales.', 'start': 5344.86, 'duration': 3.322}, {'end': 5351.565, 'text': "Let's also control and drag sales onto label.", 'start': 5348.382, 'duration': 3.183}, {'end': 5356.849, 'text': 'And you can see we have the dollar sign and the money formatting that we made earlier.', 'start': 5352.245, 'duration': 4.604}, {'end': 5359.511, 'text': "And let's control and drag state onto label.", 'start': 5357.329, 'duration': 2.182}], 'summary': 'Using tableau, states are colored by sales, with dollar sign and money formatting applied, offering visual representation of sales data.', 'duration': 28.949, 'max_score': 5330.562, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA5330562.jpg'}], 'start': 4778.35, 'title': 'Tableau dashboard tips and sales analysis', 'summary': 'Covers creating a continuous year filter, dual axis charts for total sales and profit, sales analysis dashboard with pie chart and map, and dashboard layout in tableau for effective data analysis and presentation.', 'chapters': [{'end': 5132.271, 'start': 4778.35, 'title': 'Tableau dashboard tips', 'summary': 'Discusses creating a continuous year filter, applying dual axis charts for total sales and profit by region, synchronizing axes, and understanding the impact of filters on the overall visualization.', 'duration': 353.921, 'highlights': ['Creating a continuous year filter The chapter explains how to set a continuous year filter in Tableau, allowing for a range-based slider and visualization adjustments.', 'Applying dual axis charts for total sales and profit by region It details the process of creating dual axis charts for total sales and profit by region, including controlling opacity and tooltip customization.', "Synchronizing axes and understanding the impact of filters on the overall visualization It emphasizes the importance of synchronizing axes and understanding how filters affect the overall visualization, clarifying potential discrepancies in the 'overall' label."]}, {'end': 5409.783, 'start': 5135.252, 'title': 'Sales analysis dashboard', 'summary': 'Demonstrates creating a sales analysis dashboard with pie chart showing sales by region as percentages and a map showing sales by state colored by sales amount, with the ability to control label display and filter by region.', 'duration': 274.531, 'highlights': ['Create a pie chart showing sales by region as percentages using quick table calculation, with west region representing 31% of the total sales. Demonstrates the process of creating a pie chart to display sales by region as percentages using a quick table calculation, with the west region representing 31% of the total sales.', 'Utilize a filled map to display sales by state, allowing customization of color palettes and labels, and managing label overlap. Illustrates the use of a filled map to display sales by state, with options to customize color palettes and labels, as well as managing label overlap on the map.', 'Demonstrate the method of adding a filter for region and ensuring it is added to all sheets in the dashboard. Explains the process of adding a filter for region and ensuring it is applied to all sheets in the dashboard for consistent data filtering.']}, {'end': 5955.271, 'start': 5409.783, 'title': 'Tableau dashboard visualization', 'summary': 'Demonstrates creating filters, visualizations, and dashboard layout in tableau, showcasing the process of filtering data by sales, creating visualizations based on sales by state and subcategory, and adjusting dashboard layout and filters for effective data analysis and presentation.', 'duration': 545.488, 'highlights': ['Creating filters for sales data by state and subcategory, adjusting the filter criteria, and removing filters. The lowest amount for a state is $920 for sales for this time period, and filters can be applied to display only specific states or subcategories.', 'Creating visualizations for sales by state and subcategory, utilizing color coding for distinction and comparison. Visualizations are created to display sales by state and subcategory, with the option to color code by subcategory or category for clear distinction and comparison.', 'Adjusting dashboard layout, rearranging legends and filters, and applying filters to specific worksheets. The process of adjusting dashboard layout involves rearranging legends and filters, and applying filters to specific worksheets to control the visualization based on user preferences.', 'Utilizing filters to analyze data by region, adjusting scale for visualizations, and using filters to maintain context across multiple dashboards. Filters are used to analyze data by region, with the scale of visualizations adjusting based on the filtered data, and maintaining context across multiple dashboards using filters.']}], 'duration': 1176.921, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA4778350.jpg', 'highlights': ['Creating a continuous year filter in Tableau for range-based slider and visualization adjustments', 'Applying dual axis charts for total sales and profit by region, including opacity control and tooltip customization', 'Synchronizing axes and understanding the impact of filters on overall visualization for clarity', 'Creating a pie chart to display sales by region as percentages using quick table calculation', 'Utilizing a filled map to display sales by state with color palettes and label management', 'Adding a filter for region and ensuring it is applied to all sheets in the dashboard', 'Creating filters for sales data by state and subcategory, adjusting the filter criteria, and removing filters', 'Creating visualizations for sales by state and subcategory, utilizing color coding for distinction and comparison', 'Adjusting dashboard layout, rearranging legends and filters, and applying filters to specific worksheets', 'Utilizing filters to analyze data by region, adjusting scale for visualizations, and maintaining context across multiple dashboards']}, {'end': 6943.858, 'segs': [{'end': 5980.404, 'src': 'embed', 'start': 5955.271, 'weight': 0, 'content': [{'end': 5967.194, 'text': 'this updates to just central this, updates to just Texas down here and unselect by clicking on maybe another state.', 'start': 5955.271, 'duration': 11.923}, {'end': 5972.038, 'text': 'or when you click on the state again, it should unselect and we can do the same thing here.', 'start': 5967.194, 'duration': 4.844}, {'end': 5977.742, 'text': 'or if we just want to look at one subcategory and say let me scroll down a bit storage.', 'start': 5972.038, 'duration': 5.704}, {'end': 5979.363, 'text': 'now everything updates to just storage.', 'start': 5977.742, 'duration': 1.621}, {'end': 5980.404, 'text': "it's interesting.", 'start': 5979.363, 'duration': 1.041}], 'summary': 'Updates allow selection of central/texas, unselecting states, and focusing on subcategories like storage.', 'duration': 25.133, 'max_score': 5955.271, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA5955271.jpg'}, {'end': 6106.278, 'src': 'embed', 'start': 6076.554, 'weight': 5, 'content': [{'end': 6081.076, 'text': "Now when I dragged it on, it didn't do the percent of total anymore.", 'start': 6076.554, 'duration': 4.522}, {'end': 6090.042, 'text': "So let's change that to the quick table calculation of percent of total for there and for the label.", 'start': 6081.297, 'duration': 8.745}, {'end': 6093.014, 'text': 'percent of total.', 'start': 6091.854, 'duration': 1.16}, {'end': 6093.575, 'text': 'there we go.', 'start': 6093.014, 'duration': 0.561}, {'end': 6098.156, 'text': 'now we have our percent total, again by region, region.', 'start': 6093.575, 'duration': 4.581}, {'end': 6099.936, 'text': "ok, here's another thing.", 'start': 6098.156, 'duration': 1.78}, {'end': 6106.278, 'text': "since we duplicated that filter, it's going to be using that exact same filter.", 'start': 6099.936, 'duration': 6.342}], 'summary': 'Modified table calculation to show percent of total by region.', 'duration': 29.724, 'max_score': 6076.554, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA6076554.jpg'}, {'end': 6165.55, 'src': 'embed', 'start': 6137.509, 'weight': 6, 'content': [{'end': 6140.151, 'text': "And let's add back in a region filter.", 'start': 6137.509, 'duration': 2.642}, {'end': 6145.994, 'text': 'And this one no longer has the icon that shows you that it affects multiple sheets.', 'start': 6140.731, 'duration': 5.263}, {'end': 6147.515, 'text': 'which is what we want for now.', 'start': 6146.454, 'duration': 1.061}, {'end': 6150.077, 'text': 'So you might want.', 'start': 6148.115, 'duration': 1.962}, {'end': 6157.804, 'text': 'perhaps there would be a situation where you would have two dashboards and you would want these filters that you put on here to affect both dashboards.', 'start': 6150.077, 'duration': 7.727}, {'end': 6160.226, 'text': "And in this case, that's not what I want.", 'start': 6158.224, 'duration': 2.002}, {'end': 6165.55, 'text': 'Great So another one we can use the basics for is sales by subcategory.', 'start': 6160.466, 'duration': 5.084}], 'summary': 'Discussing the removal of a filter icon and its impact on affecting multiple sheets in a dashboard.', 'duration': 28.041, 'max_score': 6137.509, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA6137509.jpg'}, {'end': 6287.099, 'src': 'embed', 'start': 6254.476, 'weight': 1, 'content': [{'end': 6259.498, 'text': "so we'll change that to profit and we have some negative profits there.", 'start': 6254.476, 'duration': 5.022}, {'end': 6267.721, 'text': "we'll keep the colors the same for consistency between the two dashboards and let's bring on category as a filter.", 'start': 6259.498, 'duration': 8.223}, {'end': 6269.916, 'text': 'okay, Show filter.', 'start': 6267.721, 'duration': 2.195}, {'end': 6270.577, 'text': 'There we are.', 'start': 6270.096, 'duration': 0.481}, {'end': 6274.142, 'text': "And let's do our order date filter right now.", 'start': 6271.298, 'duration': 2.844}, {'end': 6275.143, 'text': 'Order date.', 'start': 6274.542, 'duration': 0.601}, {'end': 6276.625, 'text': "We'll do years.", 'start': 6275.664, 'duration': 0.961}, {'end': 6278.948, 'text': 'OK All the years.', 'start': 6276.645, 'duration': 2.303}, {'end': 6287.099, 'text': "So it gives you this option here because it assumes that you're making a filter because you want this dashboard to just be filtered to your selection.", 'start': 6279.349, 'duration': 7.75}], 'summary': 'Modifying dashboard to show profit, adding category and order date filters.', 'duration': 32.623, 'max_score': 6254.476, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA6254476.jpg'}, {'end': 6446.7, 'src': 'embed', 'start': 6415.575, 'weight': 3, 'content': [{'end': 6420.096, 'text': "We're going to do this for the comparison between a pie chart and an area chart.", 'start': 6415.575, 'duration': 4.521}, {'end': 6423.498, 'text': "So it's going to be profit by category.", 'start': 6420.677, 'duration': 2.821}, {'end': 6426.598, 'text': 'But not over time.', 'start': 6425.738, 'duration': 0.86}, {'end': 6430.46, 'text': "So right now it's profit by region.", 'start': 6427.139, 'duration': 3.321}, {'end': 6434.761, 'text': "Let's drag category right on top of colors there.", 'start': 6430.94, 'duration': 3.821}, {'end': 6437.402, 'text': "And now it's split up.", 'start': 6436.362, 'duration': 1.04}, {'end': 6446.7, 'text': "It's having some trouble because it's splitting it by category, but because we brought region onto text, it's also splitting it by region.", 'start': 6439.815, 'duration': 6.885}], 'summary': 'Comparing pie chart and area chart for profit by category, with some issues in splitting by region.', 'duration': 31.125, 'max_score': 6415.575, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA6415575.jpg'}, {'end': 6561.077, 'src': 'embed', 'start': 6533.663, 'weight': 2, 'content': [{'end': 6538.565, 'text': 'The level of detail for the whole chart is a big factor as well on how many slices you get.', 'start': 6533.663, 'duration': 4.902}, {'end': 6546.129, 'text': 'Great Profit by region, profit by category, by subcategory, and by profit over time.', 'start': 6538.866, 'duration': 7.263}, {'end': 6548.87, 'text': 'And we have our category filter.', 'start': 6546.489, 'duration': 2.381}, {'end': 6550.891, 'text': "We don't have our subcategory filter yet.", 'start': 6548.93, 'duration': 1.961}, {'end': 6554.933, 'text': "We grabbed category, but let's right click on subcategory and click show filter.", 'start': 6550.951, 'duration': 3.982}, {'end': 6555.873, 'text': 'There we go.', 'start': 6555.393, 'duration': 0.48}, {'end': 6558.595, 'text': 'Now we have a filter for category and subcategory.', 'start': 6556.214, 'duration': 2.381}, {'end': 6561.077, 'text': "Here's our region one.", 'start': 6559.576, 'duration': 1.501}], 'summary': 'Detail level affects the number of chart slices. added profit filters by region, category, subcategory, and time.', 'duration': 27.414, 'max_score': 6533.663, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA6533663.jpg'}], 'start': 5955.271, 'title': 'Creating interactive dashboards in tableau', 'summary': 'Covers creating interactive dashboards in tableau, emphasizing careful visualization reuse and filter management for accurate profit analysis, and demonstrates the process of creating a profit dashboard, designing an interactive dashboard, and building a dashboard layout with multiple visualizations.', 'chapters': [{'end': 6160.226, 'start': 5955.271, 'title': 'Dashboard visualization and profit analysis', 'summary': 'Demonstrates how to create interactive dashboards in tableau, including filtering and duplicating visualizations, and emphasizes the importance of careful visualization reuse and filter management for accurate profit analysis.', 'duration': 204.955, 'highlights': ['The chapter demonstrates how to create interactive dashboards It provides practical insights into creating interactive and visually appealing dashboards in Tableau.', 'Emphasizes the importance of careful visualization reuse and filter management for accurate profit analysis It stresses the significance of meticulous visualization reuse and filter management in ensuring accurate profit analysis in Tableau.', 'Shows the process of duplicating visualizations to create a profit version of the dashboard It explains the process of duplicating visualizations to create a profit version of the dashboard, highlighting the step-by-step approach to achieve this.', 'Explains the process of filtering data and managing filters in Tableau It provides a comprehensive explanation of the process of filtering data and managing filters in Tableau, essential for accurate data analysis.']}, {'end': 6633.824, 'start': 6160.466, 'title': 'Tableau sales dashboard creation', 'summary': 'Demonstrates the process of creating a profit dashboard using tableau, including duplicating worksheets, managing filters, creating area charts, and building a dashboard layout with multiple visualizations.', 'duration': 473.358, 'highlights': ['The process of creating a profit dashboard using Tableau. The transcript walks through the steps of creating a profit dashboard, including duplicating worksheets, managing filters, and building a dashboard layout with multiple visualizations.', 'The importance of managing worksheet names in Tableau. Tableau does not allow duplicate worksheet names, and using slight variations such as adding an extra space can cause confusion and issues in dashboard creation.', 'Creating area charts for profit over time by category. The process involves bringing order date into columns, profit onto rows, and changing the line chart to an area chart to visualize profit distribution over time by category.', 'Managing filters and visualization layout in Tableau. The chapter covers the steps to add and manage filters for category and subcategory, as well as arranging visualizations within a dashboard layout.']}, {'end': 6943.858, 'start': 6634.104, 'title': 'Dashboard design and interactivity', 'summary': 'Demonstrates the process of designing an interactive dashboard, including setting default number formatting, rearranging visualizations, applying filters, and creating dashboard actions to link between different dashboards.', 'duration': 309.754, 'highlights': ['The chapter emphasizes the importance of setting default number formatting at the beginning of visualizations to save time and ensure consistency, which definitely saved us some time. Setting default number formatting at the beginning of visualizations saves time and ensures consistency.', 'The process of rearranging the order of visualizations is explained, with a recommendation to arrange the date at the top and category above subcategory for logical sense. The recommendation to arrange the date at the top and category above subcategory for logical sense is provided.', 'The importance of double-checking that filters work before publishing a dashboard is emphasized, ensuring that the visualizations remain useful when filtered to one year or multiple years. Emphasis on double-checking that filters work to ensure the usefulness of visualizations when filtered to one year or multiple years.', 'The process of creating dashboard actions to link between different dashboards is demonstrated, including the use of filter actions, highlight actions, and go to URL actions for additional functionalities. Demonstration of creating dashboard actions to link between different dashboards, including the use of filter actions, highlight actions, and go to URL actions.']}], 'duration': 988.587, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA5955271.jpg', 'highlights': ['The chapter demonstrates how to create interactive dashboards in Tableau.', 'Emphasizes the importance of careful visualization reuse and filter management for accurate profit analysis.', 'The process of creating a profit dashboard using Tableau.', 'The importance of managing worksheet names in Tableau.', 'Creating area charts for profit over time by category.', 'The chapter emphasizes the importance of setting default number formatting at the beginning of visualizations to save time and ensure consistency.', 'The process of rearranging the order of visualizations is explained, with a recommendation to arrange the date at the top and category above subcategory for logical sense.', 'The importance of double-checking that filters work before publishing a dashboard is emphasized.', 'The process of creating dashboard actions to link between different dashboards is demonstrated.']}, {'end': 8147.846, 'segs': [{'end': 7143.177, 'src': 'embed', 'start': 7115.204, 'weight': 0, 'content': [{'end': 7121.085, 'text': "We're going to edit our go to sales dashboard and we're going to select what fields it'll filter on.", 'start': 7115.204, 'duration': 5.881}, {'end': 7131.633, 'text': 'We will filter on our order date year and let me go back to that.', 'start': 7122.731, 'duration': 8.902}, {'end': 7136.355, 'text': 'We click the order date year and it goes to the target data source.', 'start': 7132.414, 'duration': 3.941}, {'end': 7143.177, 'text': 'Sometimes your target data source will be a different data source than the one that you are using for your source data source.', 'start': 7136.515, 'duration': 6.662}], 'summary': 'Editing sales dashboard to filter on order date year.', 'duration': 27.973, 'max_score': 7115.204, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA7115204.jpg'}, {'end': 7192.764, 'src': 'embed', 'start': 7162.003, 'weight': 3, 'content': [{'end': 7169.705, 'text': "Okay, if one dashboard has region in it and the other dashboard doesn't have region in it or doesn't allow you to filter by region,", 'start': 7162.003, 'duration': 7.702}, {'end': 7174.927, 'text': "then sometimes you'll get an error here that will say it's missing out of your target dashboards.", 'start': 7169.705, 'duration': 5.222}, {'end': 7178.768, 'text': "So we don't have any errors, so let's see what happens.", 'start': 7176.528, 'duration': 2.24}, {'end': 7180.629, 'text': 'So we go to click here.', 'start': 7179.709, 'duration': 0.92}, {'end': 7183.258, 'text': 'Go to sales dashboard.', 'start': 7181.857, 'duration': 1.401}, {'end': 7192.764, 'text': "What if we take out region? Remove region, and we're just doing it based on year.", 'start': 7183.758, 'duration': 9.006}], 'summary': 'Comparing dashboards with and without region filter to avoid errors and optimize sales analysis.', 'duration': 30.761, 'max_score': 7162.003, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA7162003.jpg'}, {'end': 7458.483, 'src': 'embed', 'start': 7423.248, 'weight': 4, 'content': [{'end': 7427.656, 'text': "so we're going to do sales And it's going to make these bar charts.", 'start': 7423.248, 'duration': 4.408}, {'end': 7432.478, 'text': 'So we can see for technology, by consumer, by corporate, by home office.', 'start': 7428.156, 'duration': 4.322}, {'end': 7434.959, 'text': 'And that is a matrix of bar charts.', 'start': 7432.998, 'duration': 1.961}, {'end': 7436.86, 'text': 'But we also want to be able to see profit.', 'start': 7435.079, 'duration': 1.781}, {'end': 7440.601, 'text': "And right now, it's making two sets of visualizations.", 'start': 7437.86, 'duration': 2.741}, {'end': 7442.442, 'text': 'But we want just one.', 'start': 7441.122, 'duration': 1.32}, {'end': 7443.783, 'text': "So let's dual axis.", 'start': 7442.482, 'duration': 1.301}, {'end': 7447.355, 'text': "and it's automatically changed it to circles.", 'start': 7444.893, 'duration': 2.462}, {'end': 7458.483, 'text': 'also, it is not synchronizing the axis now, because profit is blue and these profit is not anywhere near the same amount of sales, which makes sense.', 'start': 7447.355, 'duration': 11.128}], 'summary': 'Sales data visualized through bar charts, with a focus on technology, consumer, corporate, and home office segments, and a need to synchronize profit visualization with sales.', 'duration': 35.235, 'max_score': 7423.248, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA7423248.jpg'}, {'end': 7646.886, 'src': 'embed', 'start': 7616.825, 'weight': 2, 'content': [{'end': 7620.485, 'text': "And this is where we're going to use our parameter where we made our top end customers.", 'start': 7616.825, 'duration': 3.66}, {'end': 7624.346, 'text': "So let's bring in our sum of sales.", 'start': 7620.845, 'duration': 3.501}, {'end': 7625.886, 'text': 'Make a bar chart for that.', 'start': 7624.806, 'duration': 1.08}, {'end': 7629.207, 'text': "And then we're also going to, we're bringing in our set.", 'start': 7626.226, 'duration': 2.981}, {'end': 7631.087, 'text': 'So we have our in and our out.', 'start': 7629.627, 'duration': 1.46}, {'end': 7636.889, 'text': "We're going to break up our set by our segment as it's part of our segment analysis.", 'start': 7631.347, 'duration': 5.542}, {'end': 7638.949, 'text': "And we'll bring in our customer names.", 'start': 7637.369, 'duration': 1.58}, {'end': 7640.763, 'text': "And let's sort it.", 'start': 7640.123, 'duration': 0.64}, {'end': 7646.886, 'text': "Excellent Now you can see that when we sorted it, it didn't take this big guy and put it all the way at the top.", 'start': 7641.124, 'duration': 5.762}], 'summary': 'Using parameters, created bar chart for sum of sales, segmented analysis by customer names.', 'duration': 30.061, 'max_score': 7616.825, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA7616825.jpg'}, {'end': 7715.389, 'src': 'embed', 'start': 7689.244, 'weight': 1, 'content': [{'end': 7693.985, 'text': "We're going to do a string, so it's going to be top and then we want to use the number.", 'start': 7689.244, 'duration': 4.741}, {'end': 7695.105, 'text': "that's in our parameter.", 'start': 7693.985, 'duration': 1.12}, {'end': 7700.586, 'text': 'So we have to convert it from a number to a string, and we have to concatenate them together.', 'start': 7695.185, 'duration': 5.401}, {'end': 7702.767, 'text': 'In Tableau, you can use a plus sign.', 'start': 7701.086, 'duration': 1.681}, {'end': 7707.907, 'text': "Top, and always make sure you have a space between what you're concatenating together.", 'start': 7703.027, 'duration': 4.88}, {'end': 7709.488, 'text': "That's something that I tend to forget.", 'start': 7707.987, 'duration': 1.501}, {'end': 7711.788, 'text': 'Top space customers.', 'start': 7710.128, 'duration': 1.66}, {'end': 7715.389, 'text': "So if they pick 20, it'll say top 20 customers.", 'start': 7712.328, 'duration': 3.061}], 'summary': "Demonstrating how to concatenate strings and numbers in tableau using a plus sign with a space between, resulting in 'top 20 customers'.", 'duration': 26.145, 'max_score': 7689.244, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA7689244.jpg'}], 'start': 6944.478, 'title': 'Creating interactive tableau dashboards', 'summary': 'Covers creating filter actions, dashboard filtering and linking, profit and sales dashboard creation, tableau visualization design, and the impact of parameters on tableau dashboards, enhancing the interactive visualization experience.', 'chapters': [{'end': 7087.421, 'start': 6944.478, 'title': 'Filter actions in dashboards', 'summary': 'Explains the process of creating filter actions in dashboards, allowing users to link to other dashboards and apply specific filters, resulting in a more interactive visualization experience.', 'duration': 142.943, 'highlights': ['Filter actions allow users to link from one dashboard to another, and users can define specific actions to occur on hover, select, or on menu, enhancing dashboard interactivity.', 'Filter actions can be set to apply specific filters when triggered, providing a more customized data visualization experience for users.', 'Actions can be configured to show only relevant values for selected filters, improving the filtering precision and providing a more focused view of the data.']}, {'end': 7245.733, 'start': 7088.201, 'title': 'Dashboard filter and linking', 'summary': 'Discusses the process of dashboard filtering and linking, emphasizing the significance of correctly setting up filters and the potential errors that may arise from incorrect configurations, while demonstrating the process through a practical example.', 'duration': 157.532, 'highlights': ['Incorrect region information causes a blank dashboard, emphasizing the importance of setting up filters correctly.', 'Selecting fields to filter on, such as order date year and region, is crucial for proper dashboard functionality.', 'Errors can occur when linking dashboards with different data sources, highlighting the potential complications in dashboard configurations.', 'Demonstrates the impact of removing region filter on dashboard functionality, showcasing the significance of correctly configuring filters for desired outcomes.']}, {'end': 7534.88, 'start': 7246.459, 'title': 'Creating profit and sales dashboard', 'summary': 'Demonstrates how to link between dashboards, utilize parameters, and create a profit and sales dashboard with multiple visualizations and dual axis synchronization.', 'duration': 288.421, 'highlights': ['The chapter demonstrates how to link between dashboards, utilize parameters, and create a profit and sales dashboard with multiple visualizations and dual axis synchronization. It provides a comprehensive understanding of linking between dashboards, utilizing parameters, and creating a profit and sales dashboard with multiple visualizations and dual axis synchronization.', 'The process of linking between dashboards and selecting multiple years is explained, allowing for a comprehensive insight into dashboard interactivity. Details the process of linking between dashboards and selecting multiple years, enhancing dashboard interactivity and user experience.', 'Demonstrates the process of creating a matrix of bar charts for sales and profit, along with dual axis synchronization and axis customization. Illustrates the creation of a matrix of bar charts for sales and profit, including dual axis synchronization and axis customization for enhanced visualization.']}, {'end': 7930.726, 'start': 7535.08, 'title': 'Tableau dashboard design', 'summary': 'Demonstrates creating visualizations in tableau, including setting color palettes, creating user-friendly labels, utilizing calculated fields, and incorporating filters and parameters for interactive dashboard design.', 'duration': 395.646, 'highlights': ['Creating visualizations with Tableau, including setting color palettes and adjusting opacity for transparency. Demonstrates the process of setting color palettes and adjusting opacity for transparency in Tableau visualizations.', 'Utilizing parameters for dynamic user interaction and creating user-friendly labels using calculated fields. Shows how to use parameters for dynamic user interaction and create user-friendly labels using calculated fields in Tableau.', 'Incorporating filters and parameters for interactive dashboard design, discussing the pros and cons of automatic resizing. Demonstrates the incorporation of filters and parameters for interactive dashboard design in Tableau and discusses the pros and cons of automatic resizing.']}, {'end': 8147.846, 'start': 7930.906, 'title': 'Tableau dashboard parameters', 'summary': 'Discusses the impact of parameters on tableau dashboards, emphasizing their workbook-wide effect and their ability to affect all sheets, with examples of changing parameters and their impact on visualizations.', 'duration': 216.94, 'highlights': ['Parameters have a workbook-wide effect, affecting all sheets in the dashboard, as demonstrated by changing the parameter value and observing its impact on multiple visualizations. Parameters in Tableau affect all sheets in the dashboard, as evidenced by changing the parameter value and observing its impact on multiple visualizations.', "The chapter emphasizes the importance of naming sheets due to the parameter's impact on any sheet it is on, illustrated by the example of changing a parameter and its effect on a specific sheet. The importance of naming sheets is highlighted due to the parameter's impact on any sheet it is on, as demonstrated by the example of changing a parameter and its effect on a specific sheet.", 'The use of floating legends in Tableau dashboards is discussed, with a caution about their limitations in automatic dashboards and the importance of ensuring they do not obstruct visualizations. The discussion of floating legends in Tableau dashboards includes a caution about their limitations in automatic dashboards and the importance of ensuring they do not obstruct visualizations.', 'The chapter provides an overview of the topics covered in the video, including business intelligence, Tableau installation, connecting to data sources, creating calculated fields, making sets and parameters, creating donut charts and dashboards, adding filters, and connecting between dashboards. An overview of the topics covered in the video includes business intelligence, Tableau installation, connecting to data sources, creating calculated fields, making sets and parameters, creating donut charts and dashboards, adding filters, and connecting between dashboards.']}], 'duration': 1203.368, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/fO7g0pnWaRA/pics/fO7g0pnWaRA6944478.jpg', 'highlights': ['Filter actions allow users to link from one dashboard to another, enhancing dashboard interactivity.', 'Demonstrates the impact of removing region filter on dashboard functionality, showcasing the significance of correctly configuring filters.', 'The chapter demonstrates how to link between dashboards, utilize parameters, and create a profit and sales dashboard with multiple visualizations and dual axis synchronization.', 'Incorporating filters and parameters for interactive dashboard design, discussing the pros and cons of automatic resizing.', 'Parameters have a workbook-wide effect, affecting all sheets in the dashboard, as demonstrated by changing the parameter value and observing its impact on multiple visualizations.']}], 'highlights': ['Tableau can be connected to 40 different data sources, providing direct access to data.', 'Tableau has been a leader in the Gartner Magic quadrant for the last six years, including 2018, showcasing its consistent performance in the industry.', 'Creating visualizations including bar charts, calculated fields, geographical mapping, and interactive dashboards with filters for data-driven decisions.', 'Utilizing Tableau to identify specific products and subcategories that are not performing well in certain regions, leading to potential product reconsideration.', "Creating a parameter named 'top end customers' to allow users to choose the number of customers they want to see, with a range from 5 to 20 and a step size of 5, starting at a default value of 10.", 'Creating a continuous year filter in Tableau for range-based slider and visualization adjustments', 'The chapter demonstrates how to create interactive dashboards in Tableau.', 'Emphasizes the importance of careful visualization reuse and filter management for accurate profit analysis.', 'The process of creating a profit dashboard using Tableau.', 'Filter actions allow users to link from one dashboard to another, enhancing dashboard interactivity.']}