title
Tableau Training For Beginners 2021 | Tableau Tutorial For Beginners | Tableau Course | Simplilearn

description
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=Tableau-xwj2p4LSD1k&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-xwj2p4LSD1k&utm_medium=DescriptionFF&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=Tableau-xwj2p4LSD1k&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-xwj2p4LSD1k&utm_medium=DescriptionFF&utm_source=youtube This video on Tableau training for beginners video will help you understand what business intelligence is, why we need business intelligence, and the various business intelligence tools. You will learn the basics of Tableau, understand the interface, and explore its features. You will understand the concepts of joins, unions, various rank functions, URL actions, reference lines. Finally, you will create interactive dashboards. This Tableau Training for beginners video will cover the following concepts 00:00:00 Introduction to Tableau Training for Beginners 2021 00:00:50 What is Business Intelligence 00:01:00 Why is Business Intelligence important? (Tableau Training For Beginners) 00:01:50 What is Tableau and why do we need Tableau? 00:05:50 Tableau Installation (Tableau Training For Beginners) 00:06:54 Getting Started with Tableau 00:06:57 Connecting Data in Tableau (Tableau Training For Beginners) 00:08:05 Tableau Workplace 00:09:00 Worksheets and Dashboards in Tableau (Tableau Training For Beginners) 00:10:40 Asking questions using visualizations in Tableau 00:15:30 Hierarchy and Drilldown in Tableau (Tableau Training For Beginners) 02:23:23 Calculated fields in Tableau 02:02:12 Parameters in Tableau (Tableau Training For Beginners) 01:00:52 Donut and 2-D pie charts in Tableau 🔥 Enroll for FREE Tableau Course & Get your Completion Certificate: https://bit.ly/3nWEwXr ✅Subscribe to our channel for more Tableau videos: https://bit.ly/3ncDLcx ⏩Watch more Expert Tutorials on Tableau: https://bit.ly/2XJUDNw ⏩To access the slides, click here: https://bit.ly/3tvfPC7 Dataset Link - https://drive.google.com/drive/folders/1FWRXs0QvuyF75PolDNqgH0e5UigpdArw #TableauTrainingForBeginners #TableauTutorial #TableauTutorialForBeginners #LearnTableau #TableauCourse #SimplilearnTableau #simplilearn ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. ✅ 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 🔥Free Python Course: https://www.simplilearn.com/learn-python-basics-free-course-skillup?utm_campaign=PythonTutorialForBeginnersOct10&utm_medium=Description&utm_source=youtube Learn more at: https://bit.ly/2SD4VZl 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'Tableau Training For Beginners 2021 | Tableau Tutorial For Beginners | Tableau Course | Simplilearn', 'heatmap': [{'end': 573.115, 'start': 456.34, 'weight': 0.772}, {'end': 2296.664, 'start': 2168.207, 'weight': 0.782}, {'end': 3773.638, 'start': 3542.412, 'weight': 0.719}, {'end': 6858.158, 'start': 6740.81, 'weight': 1}], 'summary': 'This tableau training for beginners covers business intelligence, data visualization, and dashboard creation, emphasizing practical applications and essential skills. it includes creating different visualizations, building user-friendly dashboards, and comprehensive insights for effective data analysis and visualization, with practical examples and ranking options.', 'chapters': [{'end': 85.309, 'segs': [{'end': 85.309, 'src': 'embed', 'start': 24.037, 'weight': 0, 'content': [{'end': 26.679, 'text': 'and do a quick overview of Tableau installation.', 'start': 24.037, 'duration': 2.642}, {'end': 32.822, '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': 27.139, 'duration': 5.683}, {'end': 40.966, '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': 33.282, 'duration': 7.684}, {'end': 44.028, 'text': "We'll look at hierarchy and drill down, calculated fields.", 'start': 41.187, 'duration': 2.841}, {'end': 46.149, 'text': "We'll look at parameters and sets.", 'start': 44.488, 'duration': 1.661}, {'end': 50.212, 'text': "And finally, we'll show you how to build a donut chart and a 2D pie chart.", 'start': 46.429, 'duration': 3.783}, {'end': 52.233, 'text': 'So what is business intelligence??', 'start': 50.532, 'duration': 1.701}, {'end': 60.739, 'text': 'Companies use business intelligence technologies to collect, analyze and present data in order to create actionable information.', 'start': 52.913, 'duration': 7.826}, {'end': 66.283, 'text': "Today's businesses are always seeking insights about their customers, products, and services.", 'start': 61.38, 'duration': 4.903}, {'end': 73.769, 'text': 'So businesses are faced with many questions, such as how do I know my customers are happy? What would make my customers stay?', 'start': 66.924, 'duration': 6.845}, {'end': 76.992, 'text': 'And how can I increase awareness of my products and services?', 'start': 73.929, 'duration': 3.063}, {'end': 80.762, 'text': 'Business intelligence can help you answer those questions.', 'start': 78.018, 'duration': 2.744}, {'end': 85.309, 'text': 'When you have a question about what your customers are feeling, what your customers are doing,', 'start': 81.143, 'duration': 4.166}], 'summary': 'Tableau installation, workspace, visualizations, bi insights for businesses.', 'duration': 61.272, 'max_score': 24.037, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k24037.jpg'}], 'start': 0.369, 'title': 'Tableau training for beginners', 'summary': 'Introduces tableau training, covering business intelligence, tableau usage, and practical applications, aiming to equip learners with essential data visualization and analysis skills.', 'chapters': [{'end': 85.309, 'start': 0.369, 'title': 'Tableau training for beginners', 'summary': 'Introduces tableau training for beginners, covering topics such as business intelligence, tableau usage, and practical applications, aiming to equip learners with essential skills for data visualization and analysis.', 'duration': 84.94, 'highlights': ['Business intelligence technologies are used by companies to collect, analyze and present data to create actionable information, helping businesses gain insights about their customers, products, and services.', 'The agenda includes an overview of Tableau and its installation, connecting to data, exploring the Tableau workspace, visualizations, hierarchy, drill down, calculated fields, parameters, sets, and creating donut and 2D pie charts.', 'Companies are seeking insights about customer satisfaction, retention strategies, and increasing awareness of products and services, and business intelligence can help answer these questions.']}], 'duration': 84.94, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k369.jpg', 'highlights': ['Business intelligence technologies help companies collect, analyze, and present data for actionable insights.', 'The agenda covers Tableau overview, installation, data connection, workspace exploration, visualizations, and chart creation.', 'Companies use business intelligence to gain insights on customer satisfaction, retention strategies, and product awareness.']}, {'end': 1344.719, 'segs': [{'end': 149.383, 'src': 'embed', 'start': 106.09, 'weight': 0, 'content': [{'end': 108.652, 'text': 'We also have Qlik and SAP and Oracle.', 'start': 106.09, 'duration': 2.562}, {'end': 109.953, 'text': 'You may have heard of some of these.', 'start': 108.772, 'duration': 1.181}, {'end': 114.697, 'text': "Let's take a look at some of the benefits of Tableau as your business intelligence tool.", 'start': 110.493, 'duration': 4.204}, {'end': 119.602, 'text': 'So why would we use Tableau? It can be connected to 40 different data sources.', 'start': 115.098, 'duration': 4.504}, {'end': 125.527, 'text': 'The more data sources it can connect to, it means that you are more likely to get direct access to your data.', 'start': 119.782, 'duration': 5.745}, {'end': 134.015, 'text': 'It can build interactive dashboards with just a few clicks, which can help you quickly understand your data, and it lets you see your outliers.', 'start': 126.148, 'duration': 7.867}, {'end': 142.059, 'text': "There's also simple analytics built right into Tableau, such as trends and forecasting, that can help you understand your data on a deeper level.", 'start': 134.656, 'duration': 7.403}, {'end': 149.383, 'text': 'Tableau has been a leader in the Gartner Magic Quadrant for the last six years, and that includes 2018.', 'start': 142.62, 'duration': 6.763}], 'summary': 'Tableau can connect to 40 data sources, build interactive dashboards, and has been a leader in gartner magic quadrant for 6 years.', 'duration': 43.293, 'max_score': 106.09, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k106090.jpg'}, {'end': 199.34, 'src': 'embed', 'start': 168.755, 'weight': 2, 'content': [{'end': 171.037, 'text': 'and it can only support up to a million rows of data.', 'start': 168.755, 'duration': 2.282}, {'end': 177.663, 'text': "Also, any data published here is made public, so you can't use this for private company information.", 'start': 171.518, 'duration': 6.145}, {'end': 185.231, 'text': "Then there's a new tool called Tableau Prep, where you can prepare your data by seeing it visually before you connect and build reports.", 'start': 177.944, 'duration': 7.287}, {'end': 193.496, 'text': "There's also Tableau Online, which is a cloud-hosted version of Tableau Server, a place where you can publish your dashboards,", 'start': 185.711, 'duration': 7.785}, {'end': 196.298, 'text': 'and it enables you to share your dashboards in a secure way.', 'start': 193.496, 'duration': 2.802}, {'end': 199.34, 'text': 'Tableau Server has an option to be on-premises.', 'start': 196.839, 'duration': 2.501}], 'summary': 'Tableau offers tableau prep and tableau online for data preparation and secure dashboard sharing, supporting up to a million rows of data.', 'duration': 30.585, 'max_score': 168.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k168755.jpg'}, {'end': 374.813, 'src': 'embed', 'start': 329.231, 'weight': 3, 'content': [{'end': 334.156, 'text': 'If you close that we can see our legend over here and then our sales across the region.', 'start': 329.231, 'duration': 4.925}, {'end': 341.544, 'text': 'So in Tableau we have a lot of really quick flexibility to turn just text into a visualization.', 'start': 335.017, 'duration': 6.527}, {'end': 351.033, 'text': 'So in summary, we can see a side-by-side of what we made using pivot tables in Excel and what we made in a similar amount of time in Tableau.', 'start': 342.245, 'duration': 8.788}, {'end': 353.716, 'text': "Let's get started with the Tableau installation.", 'start': 351.554, 'duration': 2.162}, {'end': 359.461, 'text': 'As for requirements, you need Windows 7 or later, or you need your Mac operating system to be 10.11 or later.', 'start': 354.316, 'duration': 5.145}, {'end': 364.245, 'text': 'Here are some of the browsers you can use to install Tableau.', 'start': 361.102, 'duration': 3.143}, {'end': 366.667, 'text': 'We will be installing Tableau Public today.', 'start': 364.705, 'duration': 1.962}, {'end': 371.991, 'text': 'And to do that, you just Google Tableau Public download and click on that first link.', 'start': 367.247, 'duration': 4.744}, {'end': 374.813, 'text': 'And then you put in your email address and click download the app.', 'start': 372.171, 'duration': 2.642}], 'summary': 'Tableau allows quick visualization, same data in excel vs tableau.', 'duration': 45.582, 'max_score': 329.231, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k329231.jpg'}, {'end': 573.115, 'src': 'heatmap', 'start': 456.34, 'weight': 0.772, 'content': [{'end': 457.281, 'text': 'Try publishing first.', 'start': 456.34, 'duration': 0.941}, {'end': 461.444, 'text': "This is where you'll see all of your published Tableau Public dashboards.", 'start': 457.421, 'duration': 4.023}, {'end': 468.469, 'text': 'Over here we have Discover and it has some how-to videos, visualization of the day,', 'start': 462.004, 'duration': 6.465}, {'end': 474.033, 'text': 'which is where people who have made Tableau Public visualizations get recognized for their skill,', 'start': 468.469, 'duration': 5.564}, {'end': 476.055, 'text': 'and you get some pretty cool ideas when you look there.', 'start': 474.033, 'duration': 2.022}, {'end': 480.418, 'text': "So let's get started by connecting to a data source.", 'start': 476.855, 'duration': 3.563}, {'end': 485.201, 'text': "We'll click Microsoft Excel and we'll choose our Excel file and open it up.", 'start': 480.718, 'duration': 4.483}, {'end': 487.643, 'text': 'And this is our data source page.', 'start': 485.822, 'duration': 1.821}, {'end': 494.788, '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': 488.103, 'duration': 6.685}, {'end': 497.591, 'text': 'This gives you a preview of what your data will look like.', 'start': 495.149, 'duration': 2.442}, {'end': 507.736, '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': 498.331, 'duration': 9.405}, {'end': 513.799, 'text': 'We also have a globe, which is where Tableau has recognized these values to be geographical.', 'start': 508.077, 'duration': 5.722}, {'end': 518.883, 'text': "So we have state, and it's recognized that it contains states.", 'start': 514.64, 'duration': 4.243}, {'end': 524.746, 'text': "It bases it on the keywords that it stores to identify if it's geographical.", 'start': 519.243, 'duration': 5.503}, {'end': 529.268, 'text': "And so it takes a look and you've named it city and it knows that city is geographical.", 'start': 525.424, 'duration': 3.844}, {'end': 534.012, 'text': "We also have the calendar symbol where it's recognized that it's a date field.", 'start': 529.728, 'duration': 4.284}, {'end': 540.097, 'text': "And we also have row ID that shows up with the hashtag and it recognizes it's a number.", 'start': 534.272, 'duration': 5.825}, {'end': 547.564, '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': 540.358, 'duration': 7.206}, {'end': 551.668, 'text': "Let's take a look at all the different pieces of this before we go any further.", 'start': 548.104, 'duration': 3.564}, {'end': 554.729, 'text': "We have the data that we're connected to up here.", 'start': 552.088, 'duration': 2.641}, {'end': 558.73, 'text': "It's our orders sheet from the Sample Superstore Excel sheet.", 'start': 554.749, 'duration': 3.981}, {'end': 562.151, 'text': 'We have dimensions on top and measures on bottom.', 'start': 559.03, 'duration': 3.121}, {'end': 565.292, 'text': "These are where we're going to get the fields to drag and drop.", 'start': 562.711, 'duration': 2.581}, {'end': 566.753, 'text': 'Here we have our cards.', 'start': 565.552, 'duration': 1.201}, {'end': 569.414, 'text': "We'll look more in depth at our cards in a moment.", 'start': 566.893, 'duration': 2.521}, {'end': 573.115, 'text': 'And these are our shelves, the column shelf and the row shelf.', 'start': 569.634, 'duration': 3.481}], 'summary': "Tableau public allows users to connect to data sources, visualize data, and recognize skilled visualizations through 'visualization of the day'.", 'duration': 116.775, 'max_score': 456.34, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k456340.jpg'}, {'end': 678.773, 'src': 'embed', 'start': 648.512, 'weight': 5, 'content': [{'end': 651.555, 'text': 'So we have dimensions on top and measures on bottom.', 'start': 648.512, 'duration': 3.043}, {'end': 657.501, 'text': 'Dimensions contain descriptive values such as names, dates, and geographical data.', 'start': 652.336, 'duration': 5.165}, {'end': 662.606, 'text': 'You can use dimensions to reveal details in your data that is qualitative details.', 'start': 658.061, 'duration': 4.545}, {'end': 667.948, 'text': 'We also have measures which contain numeric quantitative values that you can measure.', 'start': 663.126, 'duration': 4.822}, {'end': 673.791, 'text': 'Measures can be aggregated and when you drag a measure onto the view, Tableau will apply an aggregation to that measure.', 'start': 668.268, 'duration': 5.523}, {'end': 675.191, 'text': "It's sum by default.", 'start': 674.031, 'duration': 1.16}, {'end': 678.773, 'text': "So let's show this by building what we built before.", 'start': 675.952, 'duration': 2.821}], 'summary': 'Dimensions hold qualitative data, measures hold quantitative data and are aggregated in tableau.', 'duration': 30.261, 'max_score': 648.512, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k648512.jpg'}, {'end': 806.677, 'src': 'embed', 'start': 778.214, 'weight': 7, 'content': [{'end': 781.936, 'text': 'As we discussed before, dimensions are on top, measures are on bottom.', 'start': 778.214, 'duration': 3.722}, {'end': 787.198, 'text': 'And you can see that blue is associated with dimensions and green is associated with measures.', 'start': 782.076, 'duration': 5.122}, {'end': 789.459, 'text': "But it's a little bit more complicated than that.", 'start': 787.318, 'duration': 2.141}, {'end': 794.884, 'text': 'So dimensions are qualitative and measures are quantitative,', 'start': 789.659, 'duration': 5.225}, {'end': 802.032, 'text': 'but blue means we want our label to be discrete and green means we want our label to be continuous.', 'start': 794.884, 'duration': 7.148}, {'end': 806.677, 'text': "Let's make a new sheet and make a visualization to kind of show this.", 'start': 802.172, 'duration': 4.505}], 'summary': 'Dimensions are qualitative, blue for discrete labels, measures are quantitative, green for continuous labels.', 'duration': 28.463, 'max_score': 778.214, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k778214.jpg'}, {'end': 900.463, 'src': 'embed', 'start': 870.067, 'weight': 8, 'content': [{'end': 872.649, 'text': "So let's go back to our sheet three.", 'start': 870.067, 'duration': 2.582}, {'end': 879.035, 'text': 'We have all of these different sales by the different quantity numbers.', 'start': 873.19, 'duration': 5.845}, {'end': 881.897, 'text': 'And up here we have our sorting.', 'start': 879.735, 'duration': 2.162}, {'end': 884.94, 'text': 'When you hover it tells you what kind of sorting is going to happen.', 'start': 882.298, 'duration': 2.642}, {'end': 885.841, 'text': 'So we could sort.', 'start': 885, 'duration': 0.841}, {'end': 887.941, 'text': 'quantity descending by sales.', 'start': 886.301, 'duration': 1.64}, {'end': 892.162, 'text': 'So we can see that when they buy three things, we have the highest sales.', 'start': 888.001, 'duration': 4.161}, {'end': 900.463, 'text': "You can do the opposite where it's the lowest to the highest number of sales.", 'start': 893.022, 'duration': 7.441}], 'summary': 'Analyzing sales data to identify highest and lowest sales for different quantities.', 'duration': 30.396, 'max_score': 870.067, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k870067.jpg'}, {'end': 961.023, 'src': 'embed', 'start': 927.486, 'weight': 6, 'content': [{'end': 932.989, 'text': "Now that we've had an overview of how Tableau works, let's go into a little more detail.", 'start': 927.486, 'duration': 5.503}, {'end': 937.45, 'text': 'Tableau is very much built on the premise of drag and drop.', 'start': 933.529, 'duration': 3.921}, {'end': 947.515, 'text': "So let's build a simple visualization and talk about what each of these shells and marks cards specifically do.", 'start': 938.151, 'duration': 9.364}, {'end': 952.517, 'text': "So we're going to make a simple chart, which is average sales by region.", 'start': 948.135, 'duration': 4.382}, {'end': 958.741, 'text': 'so we know we want sales on.', 'start': 953.217, 'duration': 5.524}, {'end': 961.023, 'text': "let's do sales on rows.", 'start': 958.741, 'duration': 2.282}], 'summary': 'Tableau emphasizes drag and drop functionality for visualizations, enabling simple chart creation like average sales by region.', 'duration': 33.537, 'max_score': 927.486, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k927486.jpg'}], 'start': 85.309, 'title': 'Tableau business intelligence and data visualization', 'summary': "Provides an overview of tableau's benefits, including its connectivity to 40 data sources, leadership in the gartner magic quadrant for six years, and demonstrates its flexibility and ease in comparison to excel. it also explains tableau's data visualization process, field categorization, and features for sorting and visualization.", 'chapters': [{'end': 206.765, 'start': 85.309, 'title': 'Tableau business intelligence overview', '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 six years, including 2018.', 'duration': 121.456, 'highlights': ['Tableau can connect 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 industry recognition and reliability.', 'Tableau Prep is a new tool that visually allows data preparation before connecting and building reports, enhancing data visualization and report creation process.']}, {'end': 529.268, 'start': 207.446, 'title': 'Data visualization tools comparison', 'summary': 'Demonstrates creating pivot tables in excel and visualizations in tableau, showcasing the flexibility and ease of tableau in comparison to excel, and provides installation guidance for tableau public.', 'duration': 321.822, 'highlights': ["Tableau offers quick flexibility in creating visualizations compared to Excel's pivot tables Tableau allows for quick and flexible creation of visualizations, such as bar charts and stacked bars, providing a side-by-side comparison with pivot tables in Excel.", 'Tableau provides installation guidance for Tableau Public, including system requirements and download instructions The transcript provides detailed installation guidance for Tableau Public, including system requirements (Windows 7 or later, Mac OS 10.11 or later) and download instructions, highlighting the process of signing in, creating an account, and downloading the app.', "Tableau's interface and data connection capabilities are explained, showcasing limited options in Tableau Public compared to Tableau Desktop The transcript explains Tableau Public's limited connectivity options compared to Tableau Desktop, demonstrating the interface, data connection process, and the classification of fields within Tableau."]}, {'end': 869.567, 'start': 529.728, 'title': 'Tableau data visualization', 'summary': 'Explains how tableau categorizes fields into dimensions and measures, demonstrating the process of building visualizations and distinguishing between qualitative and quantitative data.', 'duration': 339.839, 'highlights': ['Tableau categorizes fields into dimensions and measures, with dimensions containing descriptive qualitative values and measures containing numeric quantitative values. Dimensions contain names, dates, and geographical data while measures contain numeric quantitative values that can be aggregated.', 'The process of building visualizations in Tableau involves dragging and dropping fields into shelves, utilizing the Show Me feature to explore different visualization options, and creating sheets, dashboards, and stories to present visualizations. Users can drag and drop fields into shelves to make changes in the visualization, explore various visualization options using the Show Me feature, and create sheets, dashboards, and stories to present visualizations.', 'Tableau distinguishes between discrete and continuous labels, with blue representing discrete labels for dimensions and green representing continuous labels for measures. In Tableau, blue labels indicate discrete labels for dimensions, while green labels indicate continuous labels for measures, and users can choose between continuous or discrete labels for dimensions.']}, {'end': 1344.719, 'start': 870.067, 'title': 'Tableau sorting and visualization', 'summary': 'Covers tableau features such as sorting by quantity and sales, building a simple visualization, adjusting color, size, labels, and using filters to manipulate data for better insights.', 'duration': 474.652, 'highlights': ['Tableau sorting allows arranging data by quantity and sales, revealing the highest sales when buying three items, and provides options to sort by descending or ascending order. Highest sales observed when buying three items.', 'Tableau visualization involves drag and drop functionality, creating a simple chart for average sales by region, and manipulating dimensions and measures to customize the visualization. Ability to customize visualizations by dragging dimensions and measures onto rows, columns, color, and size.', "Tableau's features include adjusting the color and size of bars based on different measures such as sales and profit, displaying labels for sales, and utilizing filters to manipulate data subsets for visualization. Ability to adjust color and size based on measures, display labels for sales, and use filters to manipulate data subsets."]}], 'duration': 1259.41, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k85309.jpg', 'highlights': ['Tableau can connect 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, showcasing its industry recognition and reliability.', 'Tableau Prep is a new tool that visually allows data preparation before connecting and building reports, enhancing data visualization and report creation process.', "Tableau offers quick flexibility in creating visualizations compared to Excel's pivot tables Tableau allows for quick and flexible creation of visualizations, such as bar charts and stacked bars, providing a side-by-side comparison with pivot tables in Excel.", 'Tableau provides installation guidance for Tableau Public, including system requirements and download instructions The transcript provides detailed installation guidance for Tableau Public, including system requirements (Windows 7 or later, Mac OS 10.11 or later) and download instructions, highlighting the process of signing in, creating an account, and downloading the app.', 'Tableau categorizes fields into dimensions and measures, with dimensions containing descriptive qualitative values and measures containing numeric quantitative values. Dimensions contain names, dates, and geographical data while measures contain numeric quantitative values that can be aggregated.', 'The process of building visualizations in Tableau involves dragging and dropping fields into shelves, utilizing the Show Me feature to explore different visualization options, and creating sheets, dashboards, and stories to present visualizations. Users can drag and drop fields into shelves to make changes in the visualization, explore various visualization options using the Show Me feature, and create sheets, dashboards, and stories to present visualizations.', 'Tableau distinguishes between discrete and continuous labels, with blue representing discrete labels for dimensions and green representing continuous labels for measures. In Tableau, blue labels indicate discrete labels for dimensions, while green labels indicate continuous labels for measures, and users can choose between continuous or discrete labels for dimensions.', 'Tableau sorting allows arranging data by quantity and sales, revealing the highest sales when buying three items, and provides options to sort by descending or ascending order.', 'Tableau visualization involves drag and drop functionality, creating a simple chart for average sales by region, and manipulating dimensions and measures to customize the visualization. Ability to customize visualizations by dragging dimensions and measures onto rows, columns, color, and size.', "Tableau's features include adjusting the color and size of bars based on different measures such as sales and profit, displaying labels for sales, and utilizing filters to manipulate data subsets for visualization. Ability to adjust color and size based on measures, display labels for sales, and use filters to manipulate data subsets."]}, {'end': 2659.997, 'segs': [{'end': 1705.446, 'src': 'embed', 'start': 1679.988, 'weight': 1, 'content': [{'end': 1685.571, 'text': 'We end up with furniture, furniture, furniture, furniture spread out across our visualization.', 'start': 1679.988, 'duration': 5.583}, {'end': 1688.172, 'text': "So again, let's put category to the front.", 'start': 1686.131, 'duration': 2.041}, {'end': 1699.059, 'text': 'And now we have our profit by category by subcategory and we can click sort subcategory descending by profit.', 'start': 1689.488, 'duration': 9.571}, {'end': 1705.446, 'text': 'And now what it does is within the highest group within each group.', 'start': 1699.78, 'duration': 5.666}], 'summary': 'Visualize furniture profit by category and subcategory.', 'duration': 25.458, 'max_score': 1679.988, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k1679988.jpg'}, {'end': 1869.411, 'src': 'embed', 'start': 1842.43, 'weight': 0, 'content': [{'end': 1850.877, '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': 1842.43, 'duration': 8.447}, {'end': 1856.641, 'text': 'just make a comment in the comments below, and the Simply Learn team will send you this data set.', 'start': 1850.877, 'duration': 5.764}, {'end': 1860.504, 'text': "Now we're going to take a look at creating a hierarchy in Tableau.", 'start': 1857.042, 'duration': 3.462}, {'end': 1869.411, 'text': "So we'll make a new tab and we're going to make a sheet called Sales by Product.", 'start': 1861.725, 'duration': 7.686}], 'summary': 'Building visualizations and offering access to data set for audience engagement in tableau training.', 'duration': 26.981, 'max_score': 1842.43, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k1842430.jpg'}, {'end': 2144.246, 'src': 'embed', 'start': 2117.17, 'weight': 2, 'content': [{'end': 2125.494, 'text': 'it keeps that coloring and we can see more in depth and quicker that Phones has the highest across most of them.', 'start': 2117.17, 'duration': 8.324}, {'end': 2130.196, 'text': "It's not quite the highest in the West because Chairs is the highest in the West.", 'start': 2126.014, 'duration': 4.182}, {'end': 2137.261, 'text': "There's one place in Tableau where hierarchies are built in, and that's in dates.", 'start': 2130.856, 'duration': 6.405}, {'end': 2144.246, 'text': 'So dates in Tableau can be very complex because they allow very complex visualizations.', 'start': 2137.281, 'duration': 6.965}], 'summary': 'Phones has the highest across most categories, except in the west where chairs is highest. tableau allows for complex visualizations with date hierarchies.', 'duration': 27.076, 'max_score': 2117.17, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k2117170.jpg'}, {'end': 2296.664, 'src': 'heatmap', 'start': 2168.207, 'weight': 0.782, 'content': [{'end': 2172.632, 'text': 'So now we can see our profit over time for each of these years.', 'start': 2168.207, 'duration': 4.425}, {'end': 2178.127, 'text': 'And Tableau has some hierarchies built into dates already.', 'start': 2174.304, 'duration': 3.823}, {'end': 2183.592, 'text': "So when I click this plus on columns, it'll split it out into quarters.", 'start': 2178.428, 'duration': 5.164}, {'end': 2193.841, 'text': 'So this is a header and these are all subheaders underneath that header because it is distinct and discrete right now instead of continuous.', 'start': 2184.172, 'duration': 9.669}, {'end': 2199.409, 'text': "So it's split out year, year, year, year, and quarters, quarters, quarters, quarters.", 'start': 2194.301, 'duration': 5.108}, {'end': 2206.941, 'text': 'This allows you to quickly compare quarter one across all of the years and quarter two across all of the years,', 'start': 2199.509, 'duration': 7.432}, {'end': 2208.623, 'text': 'and quarter four across all of the years.', 'start': 2206.941, 'duration': 1.682}, {'end': 2216.624, 'text': 'Another way you could add some more detail to this is by taking maybe category and pulling it onto color.', 'start': 2209.719, 'duration': 6.905}, {'end': 2229.674, 'text': 'And now we have one line for each category and we can see that a drop in technology is a big part of the responsibility for that drop we were seeing in quarter two of 2016..', 'start': 2216.644, 'duration': 13.03}, {'end': 2233.417, 'text': "So let's take that back off and let's take quarter back off.", 'start': 2229.674, 'duration': 3.743}, {'end': 2237.244, 'text': "And let's explore continuous dates.", 'start': 2234.983, 'duration': 2.261}, {'end': 2245.969, 'text': 'So here in dates, we have our top section of dates, and then you see it repeats, and we have the bottom section of dates.', 'start': 2237.825, 'duration': 8.144}, {'end': 2250.131, 'text': "So we've got year, but we also have year here, quarter and quarter.", 'start': 2246.209, 'duration': 3.922}, {'end': 2259.576, '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': 2250.311, 'duration': 9.265}, {'end': 2260.977, 'text': "and now it's continuous.", 'start': 2259.576, 'duration': 1.401}, {'end': 2267.36, 'text': "So now instead of this being a header for 2013 and a header for 2014, it's an axis.", 'start': 2261.997, 'duration': 5.363}, {'end': 2276.186, 'text': 'So the difference here is when I press the plus and it changes it to quarter instead of adding quarter to year.', 'start': 2267.841, 'duration': 8.345}, {'end': 2281.409, 'text': "now it's doing quarter for each year and making one continuous line.", 'start': 2276.186, 'duration': 5.223}, {'end': 2284.711, 'text': 'And we can keep going and drill down to month.', 'start': 2281.809, 'duration': 2.902}, {'end': 2287.836, 'text': 'you can go pretty far.', 'start': 2286.735, 'duration': 1.101}, {'end': 2296.664, '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': 2288.597, 'duration': 8.067}], 'summary': "Analyzing profit over time by year, quarter, and category, with a focus on technology's impact on the drop in revenue in 2016 q2.", 'duration': 128.457, 'max_score': 2168.207, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k2168207.jpg'}, {'end': 2390.495, 'src': 'embed', 'start': 2360.249, 'weight': 3, 'content': [{'end': 2372.072, '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': 2360.249, 'duration': 11.823}, {'end': 2375.525, 'text': "Okay, and let's make a second calculated field.", 'start': 2373.103, 'duration': 2.422}, {'end': 2381.369, 'text': 'We could come here and click Duplicate and that will duplicate our field.', 'start': 2375.645, 'duration': 5.724}, {'end': 2382.99, 'text': 'but I just wanna start over again.', 'start': 2381.369, 'duration': 1.621}, {'end': 2390.495, 'text': "so I'll click Create Calculated Field and I will call it Profit Ratio Aggregated.", 'start': 2382.99, 'duration': 7.505}], 'summary': 'Calculate profit ratio unaggregated and create new field for aggregated profit ratio.', 'duration': 30.246, 'max_score': 2360.249, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k2360249.jpg'}], 'start': 1344.999, 'title': 'Tableau data visualization', 'summary': 'Demonstrates creating different visualizations such as bar charts, line charts, scatter plots in tableau to analyze sales data, focuses on visualizing profit by subcategory, creating hierarchies for sales analysis, and understanding aggregated and unaggregated calculations for profit ratios.', 'chapters': [{'end': 1579.419, 'start': 1344.999, 'title': 'Tableau data visualization', 'summary': 'Demonstrates creating different visualizations such as bar charts, line charts, scatter plots, and using features like detail, shape, color, and highlighting in tableau to analyze sales data and product performance.', 'duration': 234.42, 'highlights': ['Creating different visualizations (bar charts, line charts, scatter plots) in Tableau to analyze sales data and product performance Demonstrates creating various types of visualizations and using different measures and axes to analyze sales and product performance.', 'Using detail to determine the level of visualization and finding outliers in scatter plots Explains how the detail feature determines the level of visualization, and how it helps in finding outliers in scatter plots.', 'Utilizing shape and color to categorize and highlight data points in Tableau visualizations Illustrates how shape and color are used to categorize and highlight data points, providing insights into product categories and sales performance.', 'Using the highlight feature to focus on specific dimensions and understand patterns in the data Showcases the usage of the highlight feature to focus on specific dimensions, enabling the understanding of patterns and trends in the data.']}, {'end': 2117.17, 'start': 1581.975, 'title': 'Tableau visualization tips', 'summary': 'Focuses on using tableau to visualize profit by subcategory, creating hierarchies for sales analysis, and enhancing visualizations with color and filters.', 'duration': 535.195, 'highlights': ['Tableau Visualization Tips The tutorial provides various tips for visualizing data in Tableau, including formatting profit by subcategory and creating hierarchies for sales analysis.', 'Visualizing Profit by Subcategory The process involves organizing data by category and subcategory, sorting subcategories by profit, and identifying the least profitable category (tables).', 'Creating Hierarchies for Sales Analysis The tutorial demonstrates how to create a hierarchy by organizing product names under subcategories and categories, enabling users to drill down into detailed sales information.', 'Enhancing Visualizations with Color and Filters The tutorial showcases the use of color to represent sales data visually, allowing for easier identification of sales trends across different regions.']}, {'end': 2659.997, 'start': 2117.17, 'title': 'Tableau data visualization', 'summary': 'Discusses the visualization of data in tableau, highlighting the use of hierarchies in dates, creating calculated fields for profit ratios, and understanding the difference between aggregated and unaggregated calculations for profit ratios.', 'duration': 542.827, 'highlights': ['Understanding hierarchies in dates Tableau allows for complex visualizations using hierarchies in dates, enabling quick comparison of data across different time periods and categories.', 'Creating calculated fields for profit ratios The process of creating calculated fields for profit ratios is demonstrated, showing the use of both aggregated and unaggregated calculations to determine the difference in behavior and results.', "Clearing the visualization board Tableau's feature to clear the visualization board is highlighted as a quick trick to start over with a clean sheet for new visualizations."]}], 'duration': 1314.998, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k1344999.jpg', 'highlights': ['Creating different visualizations (bar charts, line charts, scatter plots) in Tableau to analyze sales data and product performance Demonstrates creating various types of visualizations and using different measures and axes to analyze sales and product performance.', 'Visualizing Profit by Subcategory The process involves organizing data by category and subcategory, sorting subcategories by profit, and identifying the least profitable category (tables).', 'Understanding hierarchies in dates Tableau allows for complex visualizations using hierarchies in dates, enabling quick comparison of data across different time periods and categories.', 'Creating calculated fields for profit ratios The process of creating calculated fields for profit ratios is demonstrated, showing the use of both aggregated and unaggregated calculations to determine the difference in behavior and results.']}, {'end': 3390.115, 'segs': [{'end': 2708.704, 'src': 'embed', 'start': 2660.297, 'weight': 0, 'content': [{'end': 2665.18, 'text': "And that really helps when you've dragged a bunch of things on and really made a mess when you're trying things out.", 'start': 2660.297, 'duration': 4.883}, {'end': 2670.464, 'text': "Okay, so we're going to build a visualization, and we're going to look at.", 'start': 2665.601, 'duration': 4.863}, {'end': 2674.668, 'text': "region, and we're going to look at it by profit ratio.", 'start': 2671.424, 'duration': 3.244}, {'end': 2677.692, 'text': 'And so now we have this bar chart by profit ratio.', 'start': 2675.209, 'duration': 2.483}, {'end': 2680.055, 'text': "Let's color this by region.", 'start': 2677.993, 'duration': 2.062}, {'end': 2688.225, 'text': 'We can also pull on profit and sales, and we can see all three of them side by side, split out by region.', 'start': 2680.656, 'duration': 7.569}, {'end': 2695.499, 'text': "Now let's say we also wanted to see each region by sales per customer.", 'start': 2689.016, 'duration': 6.483}, {'end': 2699.1, 'text': "So let's create some calculated fields that will help us do that.", 'start': 2695.959, 'duration': 3.141}, {'end': 2704.362, 'text': "Let's create our first calculated field that's going to get us a count of customers.", 'start': 2699.3, 'duration': 5.062}, {'end': 2708.704, 'text': "Let's call it total number of customers.", 'start': 2705.183, 'duration': 3.521}], 'summary': 'Building visualization by region and profit ratio, adding calculated fields for customer count.', 'duration': 48.407, 'max_score': 2660.297, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k2660297.jpg'}, {'end': 2923.261, 'src': 'embed', 'start': 2887.497, 'weight': 1, 'content': [{'end': 2891.038, 'text': 'Awesome So it has generated these two fields.', 'start': 2887.497, 'duration': 3.541}, {'end': 2894.219, 'text': 'Tableau has generated longitude and latitude for us.', 'start': 2891.098, 'duration': 3.121}, {'end': 2901.861, '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': 2894.859, 'duration': 7.002}, {'end': 2913.752, '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': 2902.541, 'duration': 11.211}, {'end': 2923.261, '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': 2913.932, 'duration': 9.329}], 'summary': 'Tableau generated longitude and latitude for us states, mapped sales by state, and automatically changed dot size and map display.', 'duration': 35.764, 'max_score': 2887.497, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k2887497.jpg'}, {'end': 2997.557, 'src': 'embed', 'start': 2966.321, 'weight': 5, 'content': [{'end': 2975.805, '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': 2966.321, 'duration': 9.484}, {'end': 2978.006, 'text': "Let's do what we did with color before.", 'start': 2976.065, 'duration': 1.941}, {'end': 2985.229, 'text': 'Change it to red blue diverging and set our center point to zero.', 'start': 2979.045, 'duration': 6.184}, {'end': 2991.233, 'text': 'Okay, so now we know that if anything is red, it was negative in profit.', 'start': 2985.249, 'duration': 5.984}, {'end': 2997.557, 'text': "Perfect, let's name this sheet sales profit by state.", 'start': 2991.693, 'duration': 5.864}], 'summary': 'Visualizing profitability: darker for more profit, red for loss, in sales profit by state.', 'duration': 31.236, 'max_score': 2966.321, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k2966321.jpg'}, {'end': 3293.54, 'src': 'embed', 'start': 3264.651, 'weight': 2, 'content': [{'end': 3269.836, 'text': 'Now a map needs a little bit more horizontal space than region does.', 'start': 3264.651, 'duration': 5.185}, {'end': 3276.522, 'text': "Let's bring sales and profit by category underneath the region and the detail underneath the state.", 'start': 3270.256, 'duration': 6.266}, {'end': 3278.563, 'text': 'Give our map more space again.', 'start': 3277.042, 'duration': 1.521}, {'end': 3284.91, 'text': 'Perfect Now Tableau has this neat feature called uses filter.', 'start': 3279.124, 'duration': 5.786}, {'end': 3293.54, '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': 3285.291, 'duration': 8.249}], 'summary': 'Tableau uses filter to interact with dashboards, enabling efficient data visualization.', 'duration': 28.889, 'max_score': 3264.651, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k3264651.jpg'}], 'start': 2660.297, 'title': 'Tableau visualizations and calculated fields', 'summary': 'Covers building visualizations in tableau, such as bar charts and geographical analysis, and creating calculated fields for sales per customer. it also delves into color-coding for profitability and interactive dashboard creation for sales and profit analysis by various categories.', 'chapters': [{'end': 2941.447, 'start': 2660.297, 'title': 'Building visualizations and calculated fields', 'summary': 'Discusses building visualizations using tableau, including creating bar charts, calculated fields for sales per customer, and using geographical fields to analyze sales by state and region.', 'duration': 281.15, 'highlights': ['Creating bar charts and applying calculated fields for sales per customer The chapter describes building a bar chart by profit ratio and color-coding it by region, along with creating calculated fields for total number of customers and sales per customer.', 'Utilizing geographical fields for analyzing sales by state The transcript explains how to use geographical fields such as state, city, country, and postal code to generate longitude and latitude for visualizing sales by state.', "Using Tableau's 'show me' feature to generate visualizations The chapter demonstrates using Tableau's 'show me' feature to create visualizations, such as a tree map showing sales by region and modifying the color to represent profit."]}, {'end': 3390.115, 'start': 2941.467, 'title': 'Tableau data visualization', 'summary': 'Discusses creating visualizations in tableau, including color-coding for profitability and building interactive dashboards for analyzing sales and profit data by region, state, category, and subcategory.', 'duration': 448.648, 'highlights': ['The chapter explains the use of color to represent profitability, with darker shades indicating higher profitability and orange for negative profits. Color is used to represent profitability, with darker shades indicating higher profitability and orange for negative profits.', 'The process of creating visualizations for sales and profit data by region, state, category, and subcategory is detailed, including the use of bar charts and interactive features for analysis. The process of creating visualizations for sales and profit data by region, state, category, and subcategory is detailed, including the use of bar charts and interactive features for analysis.', 'The use of interactive dashboards and filter features to analyze sales and profit data by region, category, and subcategory, allowing for in-depth analysis and identification of problematic products. The use of interactive dashboards and filter features to analyze sales and profit data by region, category, and subcategory, allowing for in-depth analysis and identification of problematic products.']}], 'duration': 729.818, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k2660297.jpg', 'highlights': ['Creating bar charts and applying calculated fields for sales per customer', 'Utilizing geographical fields for analyzing sales by state', "Using Tableau's 'show me' feature to generate visualizations", 'The process of creating visualizations for sales and profit data by region, state, category, and subcategory is detailed, including the use of bar charts and interactive features for analysis', 'The use of interactive dashboards and filter features to analyze sales and profit data by region, category, and subcategory, allowing for in-depth analysis and identification of problematic products', 'The chapter explains the use of color to represent profitability, with darker shades indicating higher profitability and orange for negative profits']}, {'end': 4334.438, 'segs': [{'end': 3443.637, 'src': 'embed', 'start': 3390.115, 'weight': 1, 'content': [{'end': 3402.252, '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': 3390.115, 'duration': 12.137}, {'end': 3406.395, 'text': "Now let's move on and take a look on how to create parameters and sets.", 'start': 3402.592, 'duration': 3.803}, {'end': 3413.761, 'text': "So new sheet and let's make a quick visualization that will apply our parameters and our sets too.", 'start': 3406.915, 'duration': 6.846}, {'end': 3423.02, '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': 3415.253, 'duration': 7.767}, {'end': 3431.767, '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': 3423.36, 'duration': 8.407}, {'end': 3434.329, 'text': 'how many of our top customers that they want to see.', 'start': 3431.767, 'duration': 2.562}, {'end': 3443.637, 'text': "So let's click this down arrow and click create parameter and we will name it top and customers.", 'start': 3435.11, 'duration': 8.527}], 'summary': 'Tutorial on creating parameters and sets for visualization, including creating a parameter to select top customers.', 'duration': 53.522, 'max_score': 3390.115, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k3390115.jpg'}, {'end': 3773.638, 'src': 'heatmap', 'start': 3542.412, 'weight': 0.719, 'content': [{'end': 3549.371, 'text': "let's name it top n customers by sales.", 'start': 3542.412, 'duration': 6.959}, {'end': 3556.535, 'text': "So we're going to allow them to select the top end customers and have that select our top customers by sales.", 'start': 3549.871, 'duration': 6.664}, {'end': 3565.296, 'text': 'So we want this set to include anything that is in the top however many they define by the parameter buy sales.', 'start': 3557.075, 'duration': 8.221}, {'end': 3569.861, 'text': 'So you can come over here to top and change it to buy field.', 'start': 3565.676, 'duration': 4.185}, {'end': 3573.385, 'text': 'We want it to be top, but not just top static 10.', 'start': 3570.302, 'duration': 3.083}, {'end': 3576.549, 'text': "We're going to click here and our parameter shows up.", 'start': 3573.385, 'duration': 3.164}, {'end': 3579.112, 'text': "So it's going to be top, top end customers.", 'start': 3576.83, 'duration': 2.282}, {'end': 3586.211, 'text': "And then you can choose another field here for it to be defined by and it's sales.", 'start': 3580.165, 'duration': 6.046}, {'end': 3588.353, 'text': 'And we want it to be by sum of sales.', 'start': 3586.692, 'duration': 1.661}, {'end': 3595.761, 'text': 'If we wanted it to be by the average profit, we can come here and click profit and change this to average.', 'start': 3589.034, 'duration': 6.727}, {'end': 3599.925, 'text': 'And now we would see our top end customers by average profit.', 'start': 3595.841, 'duration': 4.084}, {'end': 3602.728, 'text': 'But we want sales and sum.', 'start': 3600.706, 'duration': 2.022}, {'end': 3608.332, 'text': "Okay, so we've created our set, and we can drag it onto rows to see how it works.", 'start': 3603.628, 'duration': 4.704}, {'end': 3613.676, 'text': 'And we can see these are our top 10 customers by their sales.', 'start': 3609.032, 'duration': 4.644}, {'end': 3618.62, 'text': "And we have this in slash out that's generated by our set.", 'start': 3614.276, 'duration': 4.344}, {'end': 3625.205, 'text': "So if we take our set, first let's see how this line moves when we change our number here.", 'start': 3618.9, 'duration': 6.305}, {'end': 3626.766, 'text': "So right now it's 10.", 'start': 3625.345, 'duration': 1.421}, {'end': 3631.246, 'text': 'When we move it up, we see our line moves down to include the top 15.', 'start': 3626.766, 'duration': 4.48}, {'end': 3633.468, 'text': 'And now we can quickly see our top 20.', 'start': 3631.246, 'duration': 2.222}, {'end': 3638.433, 'text': "We'll go back to 10 and let's grab the set and drag it onto our filters.", 'start': 3633.468, 'duration': 4.965}, {'end': 3642.637, 'text': 'So now we have filtered the data down to our top 10.', 'start': 3638.953, 'duration': 3.684}, {'end': 3644.499, 'text': 'If this were applied to a dashboard,', 'start': 3642.637, 'duration': 1.862}, {'end': 3652.066, 'text': "this would allow the end user to see the top 10 quickly and then maybe expand it out to the top 20 if they're interested in that information.", 'start': 3644.499, 'duration': 7.567}, {'end': 3655.408, 'text': "Now let's move on to creating a donut chart.", 'start': 3652.466, 'duration': 2.942}, {'end': 3661.793, 'text': 'So a donut chart is basically a pie chart with a white center.', 'start': 3655.968, 'duration': 5.825}, {'end': 3668.617, 'text': "So let's start by building a pie chart, which in Tableau is pretty easy, especially if you use Show Me.", 'start': 3662.053, 'duration': 6.564}, {'end': 3673.32, 'text': "So let's create a pie chart for each category.", 'start': 3668.897, 'duration': 4.423}, {'end': 3675.341, 'text': 'by sales.', 'start': 3674.221, 'duration': 1.12}, {'end': 3678.283, 'text': "so we're going to click category and then we're going to control.", 'start': 3675.341, 'duration': 2.942}, {'end': 3679.003, 'text': 'click sales.', 'start': 3678.283, 'duration': 0.72}, {'end': 3680.403, 'text': 'so we have them both selected.', 'start': 3679.003, 'duration': 1.4}, {'end': 3686.305, 'text': "we'll come over to show me and click pie, and there we have our pie chart.", 'start': 3680.403, 'duration': 5.902}, {'end': 3686.886, 'text': "we'll close.", 'start': 3686.305, 'duration': 0.581}, {'end': 3687.426, 'text': 'show me.', 'start': 3686.886, 'duration': 0.54}, {'end': 3691.087, 'text': "let's come up here and click entire view.", 'start': 3687.426, 'duration': 3.661}, {'end': 3693.668, 'text': 'so we see our pie very clearly here.', 'start': 3691.087, 'duration': 2.581}, {'end': 3700.671, 'text': 'if we wanted to have one pie for each region, we can take region and drag that onto columns.', 'start': 3693.668, 'duration': 7.003}, {'end': 3705.233, 'text': 'So we have one column for each region and then one pi for each of them.', 'start': 3701.351, 'duration': 3.882}, {'end': 3711.577, 'text': 'You can see that the pi varies in size based on sales as well as the angle is for sales.', 'start': 3705.574, 'duration': 6.003}, {'end': 3715.7, 'text': 'So East has more sales in general than South.', 'start': 3711.957, 'duration': 3.743}, {'end': 3722.761, 'text': 'And this helps you to see that technology has smaller sales in the south than it does in the east.', 'start': 3716.44, 'duration': 6.321}, {'end': 3731.743, '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': 3723.221, 'duration': 8.522}, {'end': 3733.763, 'text': "by whatever measure you're using.", 'start': 3731.743, 'duration': 2.02}, {'end': 3737.904, 'text': "But for our purposes for donut charts, we're going to want them to all be the same size.", 'start': 3734.103, 'duration': 3.801}, {'end': 3743.665, 'text': 'So we took sales off of size and now we have all of our pie charts the same size.', 'start': 3738.304, 'duration': 5.361}, {'end': 3751.088, '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': 3743.885, 'duration': 7.203}, {'end': 3760.591, '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': 3751.368, 'duration': 9.223}, {'end': 3769.174, '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': 3760.591, 'duration': 8.583}, {'end': 3773.638, 'text': "And now we're going to make a second number of records by minimum.", 'start': 3769.774, 'duration': 3.864}], 'summary': 'Creating top n customers by sales set and a donut chart in tableau.', 'duration': 231.226, 'max_score': 3542.412, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k3542412.jpg'}, {'end': 3680.403, 'src': 'embed', 'start': 3655.968, 'weight': 0, 'content': [{'end': 3661.793, 'text': 'So a donut chart is basically a pie chart with a white center.', 'start': 3655.968, 'duration': 5.825}, {'end': 3668.617, 'text': "So let's start by building a pie chart, which in Tableau is pretty easy, especially if you use Show Me.", 'start': 3662.053, 'duration': 6.564}, {'end': 3673.32, 'text': "So let's create a pie chart for each category.", 'start': 3668.897, 'duration': 4.423}, {'end': 3675.341, 'text': 'by sales.', 'start': 3674.221, 'duration': 1.12}, {'end': 3678.283, 'text': "so we're going to click category and then we're going to control.", 'start': 3675.341, 'duration': 2.942}, {'end': 3679.003, 'text': 'click sales.', 'start': 3678.283, 'duration': 0.72}, {'end': 3680.403, 'text': 'so we have them both selected.', 'start': 3679.003, 'duration': 1.4}], 'summary': 'Creating a pie chart in tableau for categories and sales data.', 'duration': 24.435, 'max_score': 3655.968, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k3655968.jpg'}], 'start': 3390.115, 'title': 'Tableau data visualization', 'summary': 'Covers creating parameters, sets, and various charts in tableau, allowing users to control visualization elements, analyze top customers and sales data. it demonstrates creating parameters and sets with specific ranges and step sizes, and creating donut charts for sales by category and region. additionally, it provides a comprehensive guide for creating two-dimensional pie and donut charts, enabling users to visualize sales data with dual axes and custom color palettes.', 'chapters': [{'end': 3469.676, 'start': 3390.115, 'title': 'Creating parameters and sets in tableau', 'summary': 'Demonstrates how to create parameters and sets in tableau, allowing users to select the number of top customers they want to see, with a range from 5 to 20 and a step size of five.', 'duration': 79.561, 'highlights': ['A parameter is created to allow users to choose the number of top customers they want to see, with a range from 5 to 20 and a step size of five.', 'The parameter is set as an integer and the initial value is placed in the middle of the range at 10.', 'The visualization is sorted by customer name in descending order by sales to display all customers and apply the parameters.']}, {'end': 3751.088, 'start': 3469.676, 'title': 'Tableau parameters, sets, and donut charts', 'summary': 'Covers creating parameters, sets, and donut charts in tableau, allowing users to control visualization elements and analyze top customers and sales data, with a demonstration of creating a donut chart for sales by category and region.', 'duration': 281.412, 'highlights': ["Creating a set based on customer name to define a subset of top customers by sales The set named 'top n customers by sales' is created to allow selection of top customers by defining the number through a parameter, and it includes data based on the sum of sales, providing flexibility in analyzing top customers and their sales.", 'Demonstrating the use of parameters to control visualization elements and filter data The parameter is utilized to control the number of top customers to be displayed, allowing for dynamic filtering of data and enabling end users to quickly switch between viewing top 10 and top 20 customers based on their interest.', 'Creating a donut chart for sales by category and region A pie chart is initially created for each category by sales, and then the demonstration progresses to show how to create a donut chart by utilizing dual axis charts to maintain consistent size across all the pie charts, facilitating clear visualization of sales data by category and region.']}, {'end': 4334.438, 'start': 3751.368, 'title': 'Creating two-dimensional pie and donut charts', 'summary': 'Demonstrates creating two-dimensional pie and donut charts in tableau by manipulating axes, marks cards, and labels, allowing users to visualize sales data with dual axes and custom color palettes, providing a comprehensive guide for more complex visualizations.', 'duration': 583.07, 'highlights': ['The chapter demonstrates creating two-dimensional pie and donut charts in Tableau. The chapter provides a comprehensive guide for generating two-dimensional pie and donut charts, showcasing advanced visualization techniques in Tableau.', 'The tutorial emphasizes manipulating axes, marks cards, and labels to visualize sales data with dual axes and custom color palettes. The tutorial highlights the process of manipulating axes, marks cards, and labels to visualize sales data with dual axes and custom color palettes, offering a detailed guide for advanced chart customization.', 'Users are encouraged to follow along with the dataset for a hands-on learning experience. The tutorial recommends users to follow along with the provided dataset for a practical learning experience, ensuring a better understanding of the demonstrated techniques.']}], 'duration': 944.323, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k3390115.jpg', 'highlights': ['Creating a donut chart for sales by category and region using dual axis charts for clear visualization.', 'Demonstrating the use of parameters to control visualization elements and filter data for dynamic filtering.', 'A parameter is created to allow users to choose the number of top customers they want to see, with a range from 5 to 20 and a step size of five.']}, {'end': 5952.46, 'segs': [{'end': 4701.045, 'src': 'embed', 'start': 4677.923, 'weight': 2, 'content': [{'end': 4685.371, 'text': 'okay, so when we go to the profit by year sheet, you can see that it now has category on there.', 'start': 4677.923, 'duration': 7.448}, {'end': 4694.948, 'text': "Let's go to overall, let's come here, filters, category, and now we have a filter that affects both worksheets.", 'start': 4685.772, 'duration': 9.176}, {'end': 4698.864, 'text': 'There we go.', 'start': 4698.203, 'duration': 0.661}, {'end': 4701.045, 'text': "Let's format this filter a little bit.", 'start': 4699.184, 'duration': 1.861}], 'summary': 'Profit by year sheet now includes category filter, affecting both worksheets.', 'duration': 23.122, 'max_score': 4677.923, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k4677923.jpg'}, {'end': 4766.888, 'src': 'embed', 'start': 4729.463, 'weight': 4, 'content': [{'end': 4732.265, 'text': 'Apply to worksheets, selected worksheets.', 'start': 4729.463, 'duration': 2.802}, {'end': 4736.268, 'text': 'Both of these, okay.', 'start': 4734.267, 'duration': 2.001}, {'end': 4741.853, 'text': 'Dashboard, filters, and by region.', 'start': 4737.049, 'duration': 4.804}, {'end': 4751.797, 'text': "multiple values drop down and let's let them change their time selection.", 'start': 4743.49, 'duration': 8.307}, {'end': 4758.463, 'text': "so this one's a little bit different, since we've already determined that we wanted year and we wanted it to be continuous.", 'start': 4751.797, 'duration': 6.666}, {'end': 4766.888, 'text': 'filters for continuous fields are a little bit different than filters for these discrete fields,', 'start': 4758.463, 'duration': 8.425}], 'summary': 'Dashboard allows selection of multiple values in continuous and discrete fields for filters by region.', 'duration': 37.425, 'max_score': 4729.463, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k4729463.jpg'}, {'end': 4895.918, 'src': 'embed', 'start': 4868.679, 'weight': 0, 'content': [{'end': 4876.424, 'text': "or here in the event that you want to go to a sheet but you don't want to scroll back and forth to find where it is, so go to sheet.", 'start': 4868.679, 'duration': 7.745}, {'end': 4883.729, 'text': "now we're going to do a dual axis chart again, like we showed earlier, and I'm going to control, click and drag.", 'start': 4876.424, 'duration': 7.305}, {'end': 4887.172, 'text': 'so now we have sum of sales twice.', 'start': 4883.729, 'duration': 3.443}, {'end': 4889.874, 'text': 'this marks card affects the top one.', 'start': 4887.172, 'duration': 2.702}, {'end': 4895.918, 'text': 'so we can see that by if I change the opacity, how it changes the color.', 'start': 4889.874, 'duration': 6.044}], 'summary': 'Demonstrating dual axis chart manipulation for sales data visualization.', 'duration': 27.239, 'max_score': 4868.679, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k4868679.jpg'}, {'end': 5164.885, 'src': 'embed', 'start': 5132.59, 'weight': 1, 'content': [{'end': 5139.332, 'text': "Let's continue on and make a dashboard that digs a little bit more into sales specifically.", 'start': 5132.59, 'duration': 6.742}, {'end': 5141.433, 'text': "Great So we'll make our first sheet.", 'start': 5139.612, 'duration': 1.821}, {'end': 5149.375, 'text': "We'll call it sales by region and we're going to make another pie chart.", 'start': 5141.493, 'duration': 7.882}, {'end': 5152.196, 'text': "So let's do it using show me.", 'start': 5149.535, 'duration': 2.661}, {'end': 5154.257, 'text': "We'll click on region.", 'start': 5152.556, 'duration': 1.701}, {'end': 5156.781, 'text': 'and then we will control.', 'start': 5155.58, 'duration': 1.201}, {'end': 5159.042, 'text': 'click on sales, open up.', 'start': 5156.781, 'duration': 2.261}, {'end': 5160.923, 'text': 'show me click pie.', 'start': 5159.042, 'duration': 1.881}, {'end': 5162.504, 'text': 'close it again, great.', 'start': 5160.923, 'duration': 1.581}, {'end': 5164.885, 'text': 'so now we have the sales by region pie.', 'start': 5162.504, 'duration': 2.381}], 'summary': 'Creating a sales by region pie chart for dashboard analysis.', 'duration': 32.295, 'max_score': 5132.59, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k5132590.jpg'}, {'end': 5519.907, 'src': 'embed', 'start': 5491.126, 'weight': 3, 'content': [{'end': 5495.568, 'text': "Now we have subcategory and category and let's bring on sales.", 'start': 5491.126, 'duration': 4.442}, {'end': 5499.13, 'text': "It's defaulting to this bar chart, which is perfect.", 'start': 5496.029, 'duration': 3.101}, {'end': 5499.791, 'text': "That's what I want.", 'start': 5499.171, 'duration': 0.62}, {'end': 5514.763, 'text': 'and now we could color it by subcategory and this is a discrete coloring we could also color it by sales And this is a continuous coloring.', 'start': 5500.211, 'duration': 14.552}, {'end': 5518.406, 'text': 'So the darkest corresponds with the height.', 'start': 5514.863, 'duration': 3.543}, {'end': 5519.907, 'text': "Now we don't need to do this.", 'start': 5518.626, 'duration': 1.281}], 'summary': 'Visualizing sales data using bar chart with color-coded subcategories and sales for analysis.', 'duration': 28.781, 'max_score': 5491.126, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k5491126.jpg'}], 'start': 4334.739, 'title': 'Tableau dashboard creation', 'summary': 'Covers creating sales and profit worksheets, building a dashboard with filters and highlights, dual axis dashboard visualization, and a tableau dashboard for sales analysis, emphasizing steps, features, and visualizations for effective data analysis and visualization.', 'chapters': [{'end': 4498.875, 'start': 4334.739, 'title': 'Creating sales and profit worksheets', 'summary': "Covers creating 'sales by year' and 'profit by year' worksheets in tableau, including steps for adding data, customizing axis, labels, and formatting numbers, with an emphasis on consistency and default properties.", 'duration': 164.136, 'highlights': ["We build a 'Sales by Year' worksheet in Tableau by adding order date to columns, setting it to a continuous year axis, and analyzing sales by year.", "We create a 'Profit by Year' worksheet by duplicating the 'Sales by Year' sheet, renaming it, replacing sales with profit, ensuring consistency in labels, and formatting numbers to currency custom.", 'In Tableau, we can define default properties for numbers, such as currency format and decimal places, to ensure consistency across multiple sheets.']}, {'end': 4815.282, 'start': 4499.396, 'title': 'Building a dashboard with filters and highlights', 'summary': 'Demonstrates building an overall dashboard with sales and profit by year, adding filters for category and region, and configuring continuous field filters, aiming to provide a user-friendly interface and insight into data visualization.', 'duration': 315.886, 'highlights': ['Creating an overall dashboard with sales and profit by year and enabling highlighting for user interaction. The dashboard is built to display sales and profit by year with enabled highlighting for user interaction.', 'Adding category filters to both charts and ensuring that one filter affects both worksheets. The process involves adding category filters to both charts and configuring them to affect both worksheets for consistency.', 'Configuring filters for region and continuous field filters for year to provide a user-friendly interface and insight into data visualization. The demonstration includes configuring filters for region and continuous field filters for year to enhance user interaction and provide insight into data visualization.']}, {'end': 5129.589, 'start': 4815.702, 'title': 'Dual axis dashboard visualization', 'summary': 'Explains how to create a dual axis chart in tableau, synchronize the axis, and use tooltips to differentiate between overall and region-specific data, enhancing dashboard visualization and understanding.', 'duration': 313.887, 'highlights': ['Explanation of creating a dual axis chart in Tableau The chapter provides a detailed walkthrough of creating a dual axis chart in Tableau by control-clicking and dragging measures, and adjusting the marks card to visualize data effectively.', 'Synchronizing axes and using tooltips for differentiation It emphasizes the importance of synchronizing axes and using tooltips to differentiate between overall and region-specific data, ensuring clear visualization and understanding of the dashboard.', 'Impact of filters on dual axis visualization The chapter explains the impact of filters on dual axis visualization, highlighting that filters apply to the entire dashboard and can affect the representation of overall and region-specific data.']}, {'end': 5952.46, 'start': 5132.59, 'title': 'Tableau dashboard for sales analysis', 'summary': 'Demonstrates creating a tableau dashboard for sales analysis, including visualizations for sales by region, sales by state, and sales by subcategory, with a focus on using pie charts, maps, and filters to analyze sales data.', 'duration': 819.87, 'highlights': ['Created a sales by region pie chart with percentage of total sales using quick table calculation, and added labels for regions. The pie chart was created to display sales by region, with the addition of percentage of total sales using quick table calculation, resulting in the west region accounting for 31% of total sales.', 'Generated a filled map based on state for visualizing sales, adjusted label placement, and added filters for state and sales. A filled map was created to visualize sales by state, with adjustments made to label placement for clarity, and filters added for state and sales to facilitate data analysis.', 'Developed a bar chart for analyzing sales by subcategory, utilized discrete and continuous coloring, and incorporated filters for category and date. A bar chart was developed to analyze sales by subcategory, with the use of discrete and continuous coloring to represent sales data, and the addition of filters for category and date to refine the analysis.']}], 'duration': 1617.721, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k4334739.jpg', 'highlights': ['Explanation of creating a dual axis chart in Tableau by control-clicking and dragging measures, and adjusting the marks card to visualize data effectively.', 'Created a sales by region pie chart with percentage of total sales using quick table calculation, and added labels for regions.', 'Adding category filters to both charts and ensuring that one filter affects both worksheets.', 'Developed a bar chart for analyzing sales by subcategory, utilized discrete and continuous coloring, and incorporated filters for category and date.', 'Configuring filters for region and continuous field filters for year to provide a user-friendly interface and insight into data visualization.']}, {'end': 6941.174, 'segs': [{'end': 6005.58, 'src': 'embed', 'start': 5977.935, 'weight': 0, 'content': [{'end': 5982.337, 'text': "I wouldn't have known very quickly that there are some states that didn't have any storage sales.", 'start': 5977.935, 'duration': 4.402}, {'end': 5986.318, 'text': 'but now, when we click on storage, we can tell I showed you before that you can control,', 'start': 5982.337, 'duration': 3.981}, {'end': 5990.342, 'text': 'click and and look at binders and storage and it puts those two together.', 'start': 5986.318, 'duration': 4.024}, {'end': 5996.329, 'text': 'Also in Tableau you can drag and we could select all of these.', 'start': 5990.703, 'duration': 5.626}, {'end': 6000.694, 'text': 'So we have art, binders, envelopes, fasteners, labels, paper, and storage.', 'start': 5996.61, 'duration': 4.084}, {'end': 6003.077, 'text': 'And none of those are getting sold here.', 'start': 6001.195, 'duration': 1.882}, {'end': 6005.58, 'text': "I don't know what's up with Wyoming.", 'start': 6003.097, 'duration': 2.483}], 'summary': 'Some states have no storage sales; wyoming has 0 sales for various items like art, binders, envelopes, fasteners, labels, paper, and storage.', 'duration': 27.645, 'max_score': 5977.935, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k5977935.jpg'}, {'end': 6232.659, 'src': 'embed', 'start': 6209.704, 'weight': 2, 'content': [{'end': 6217.589, 'text': "The nice thing is when you're dragging things onto your dashboard, when you hover, you should get a little picture here of what dashboard,", 'start': 6209.704, 'duration': 7.885}, {'end': 6219.05, 'text': "what visualization you're looking at.", 'start': 6217.589, 'duration': 1.461}, {'end': 6223.013, 'text': 'It really helps you to make your decisions and not just have to do it by name.', 'start': 6219.27, 'duration': 3.743}, {'end': 6230.418, 'text': "If you're a little bit disorganized and you have all of these called Sheet 5, Sheet 7, you won't know exactly what that is right away.", 'start': 6223.173, 'duration': 7.245}, {'end': 6232.659, 'text': 'So that little preview is very helpful.', 'start': 6230.598, 'duration': 2.061}], 'summary': 'Dashboard drag-and-drop feature provides visual previews for better organization and decision-making.', 'duration': 22.955, 'max_score': 6209.704, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k6209704.jpg'}, {'end': 6376.625, 'src': 'embed', 'start': 6349.239, 'weight': 1, 'content': [{'end': 6355.825, 'text': 'An area chart is nice because when you split it up by category, by dragging category onto color,', 'start': 6349.239, 'duration': 6.586}, {'end': 6362.131, 'text': 'you can now see what category is responsible for how much profit, like you do with a line chart.', 'start': 6355.825, 'duration': 6.306}, {'end': 6368.557, 'text': 'However, its area is what defines that, so you can see that area over time and do comparisons.', 'start': 6362.251, 'duration': 6.306}, {'end': 6376.625, 'text': 'Also, it stacks them on top of each other so that you can tell that for 2013 our profit was around $50, 000 really quickly.', 'start': 6369.037, 'duration': 7.588}], 'summary': 'Area chart allows quick comparison of profit by category over time, indicating a profit of around $50,000 in 2013.', 'duration': 27.386, 'max_score': 6349.239, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k6349239.jpg'}, {'end': 6858.158, 'src': 'heatmap', 'start': 6740.81, 'weight': 1, 'content': [{'end': 6744.134, 'text': 'There we go.', 'start': 6740.81, 'duration': 3.324}, {'end': 6747.539, 'text': 'So we could have that title, we could not have that title.', 'start': 6745.256, 'duration': 2.283}, {'end': 6750.249, 'text': "that's up to you, excellent.", 'start': 6748.208, 'duration': 2.041}, {'end': 6755.291, 'text': 'so at this point we have our overall dashboard that looks at sales and profit.', 'start': 6750.249, 'duration': 5.042}, {'end': 6759.272, 'text': 'we have our sales dashboard and we have our profit dashboard.', 'start': 6755.291, 'duration': 3.981}, {'end': 6767.835, 'text': "our profit dashboard isn't 100% complete because I forgot to make sure all of these filters apply to all of these worksheets.", 'start': 6759.272, 'duration': 8.563}, {'end': 6769.356, 'text': "so let's go ahead and do that right now.", 'start': 6767.835, 'duration': 1.521}, {'end': 6781.919, 'text': 'applied worksheets, selected worksheets all on dashboard.', 'start': 6778.43, 'duration': 3.489}, {'end': 6793.07, 'text': 'one thing that is nice from this view.', 'start': 6790.828, 'duration': 2.242}, {'end': 6797.032, 'text': "it's really nice to click on dashboard and you only see the ones on the dashboard.", 'start': 6793.07, 'duration': 3.962}, {'end': 6802.316, 'text': 'but you can click here and say show all worksheets in workbook and you can see the rest here.', 'start': 6797.032, 'duration': 5.284}, {'end': 6810.641, 'text': 'so if you wanted all on the dashboard and you wanted this one or something like that, then you have the option to see them all.', 'start': 6802.316, 'duration': 8.325}, {'end': 6812.002, 'text': 'great, perfect.', 'start': 6810.641, 'duration': 1.361}, {'end': 6816.085, 'text': "so before you ever publish a dashboard, it's always good to double check that your filters work.", 'start': 6812.002, 'duration': 4.083}, {'end': 6825.536, 'text': 'When you filter to just one year, this area chart becomes a lot less useful.', 'start': 6819.793, 'duration': 5.743}, {'end': 6830.519, 'text': "But if you're looking at two or more, you start to see the shape of it.", 'start': 6825.956, 'duration': 4.563}, {'end': 6841.865, 'text': "Great Now we're going to take a look at linking from our overall dashboard to our sales dashboard.", 'start': 6832.78, 'duration': 9.085}, {'end': 6848.386, 'text': "Great, so we'll go to our overall dashboard and we'll be creating what's called an action.", 'start': 6843.1, 'duration': 5.286}, {'end': 6852.471, 'text': 'So you can make an action on a worksheet.', 'start': 6848.987, 'duration': 3.484}, {'end': 6858.158, 'text': 'You can see right here, actions, or on a dashboard, actions.', 'start': 6853.472, 'duration': 4.686}], 'summary': 'Creating and linking dashboards, ensuring filters work, and using actions for navigation.', 'duration': 117.348, 'max_score': 6740.81, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k6740810.jpg'}, {'end': 6918.982, 'src': 'embed', 'start': 6889.91, 'weight': 3, 'content': [{'end': 6894.675, 'text': 'Or when we look on our sales dashboard, we clicked on this uses filter button.', 'start': 6889.91, 'duration': 4.765}, {'end': 6898.739, 'text': 'So we should have several actions here that were all generated.', 'start': 6895.015, 'duration': 3.724}, {'end': 6903.964, 'text': 'We have a couple different kinds of actions when you go to make an action.', 'start': 6900, 'duration': 3.964}, {'end': 6908.774, 'text': "There's a filter action that we see when we click use as filter,", 'start': 6905.131, 'duration': 3.643}, {'end': 6914.939, 'text': "a highlight action that we can see from here in region and a go to URL action that we haven't used.", 'start': 6908.774, 'duration': 6.165}, {'end': 6918.982, 'text': 'If you have any questions about go to URL, please post them in the comments below.', 'start': 6915.439, 'duration': 3.543}], 'summary': 'Sales dashboard shows filter, highlight, and go to url actions with go to url action not being used.', 'duration': 29.072, 'max_score': 6889.91, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k6889910.jpg'}], 'start': 5952.6, 'title': 'Tableau dashboard creation', 'summary': 'Covers creating dashboards in tableau, including updating selections, duplicating visualizations, managing filters, and emphasizing the importance of organization and attention to detail. it also demonstrates the benefits of utilizing different chart types for profit analysis and category segmentation within the data.', 'chapters': [{'end': 6157.546, 'start': 5952.6, 'title': 'Tableau dashboard and visualization', 'summary': 'Demonstrates creating dashboards in tableau, including updating selections, duplicating visualizations, and managing filters, with a focus on sales and profit visualizations by region.', 'duration': 204.946, 'highlights': ['The chapter demonstrates updating selections and filtering options in Tableau, enabling users to visualize sales data by region and identify states with no storage sales.', 'It shows the process of duplicating visualizations to create new dashboards for different metrics such as profit, including replacing sales data with profit data and managing the sequence of visualizations within a dashboard.', 'The chapter highlights the management of filters and action filters in Tableau, emphasizing the importance of clearing filters, adding back filters, and controlling the scope of filter effects across multiple dashboards.']}, {'end': 6631.127, 'start': 6157.786, 'title': 'Tableau dashboard creation', 'summary': 'Covers the process of creating a tableau dashboard, including renaming worksheets, using filters, and selecting the appropriate visualization types to effectively display data, while emphasizing the importance of organization and attention to detail. it also demonstrates the benefits of utilizing different chart types, such as area charts and pie charts, to provide comprehensive insights into profit analysis and category segmentation within the data.', 'duration': 473.341, 'highlights': ['The importance of organization and attention to detail in creating Tableau dashboards is emphasized, such as avoiding duplicate worksheet names and utilizing preview images to aid decision-making. Importance of organization and attention to detail, avoiding duplicate worksheet names, utilizing preview images', 'Demonstrates the benefits of utilizing different chart types, such as area charts and pie charts, to provide comprehensive insights into profit analysis and category segmentation within the data. Benefits of different chart types, comprehensive insights into profit analysis and category segmentation', 'Explanation on the process of creating a Tableau dashboard, including renaming worksheets, using filters, and selecting the appropriate visualization types to effectively display data. Process of creating a Tableau dashboard, including renaming worksheets, using filters, selecting appropriate visualization types']}, {'end': 6941.174, 'start': 6631.447, 'title': 'Dashboard design and interaction', 'summary': 'Demonstrates the design and interaction techniques for creating a dashboard, including setting default number formatting, rearranging the order of elements, applying filters, and creating dashboard actions to link between different dashboards.', 'duration': 309.727, 'highlights': ['Setting Default Number Formatting Setting default number formatting at the beginning of visualization can save time and ensure consistency across charts.', 'Rearranging Dashboard Elements Rearranging the order of elements like placing date at the top, category above subcategory, and utilizing floating objects for title allows for logical sense and customization.', 'Applying Filters and Checking Functionality Double checking that filters work as intended and ensuring they apply to all worksheets on the dashboard is crucial before publishing to maintain functionality and user experience.', 'Creating Dashboard Actions Creating dashboard actions like using filter, highlight, and go to URL actions can enhance dashboard interaction and provide seamless navigation between different dashboards.']}], 'duration': 988.574, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k5952600.jpg', 'highlights': ['The chapter demonstrates updating selections and filtering options in Tableau, enabling users to visualize sales data by region and identify states with no storage sales.', 'Demonstrates the benefits of utilizing different chart types, such as area charts and pie charts, to provide comprehensive insights into profit analysis and category segmentation within the data.', 'The importance of organization and attention to detail in creating Tableau dashboards is emphasized, such as avoiding duplicate worksheet names and utilizing preview images to aid decision-making.', 'Creating Dashboard Actions Creating dashboard actions like using filter, highlight, and go to URL actions can enhance dashboard interaction and provide seamless navigation between different dashboards.']}, {'end': 8089.817, 'segs': [{'end': 6973.742, 'src': 'embed', 'start': 6941.794, 'weight': 0, 'content': [{'end': 6942.774, 'text': 'It can get pretty cool.', 'start': 6941.794, 'duration': 0.98}, {'end': 6950.236, 'text': 'Okay, but we want to link from this dashboard to one of our other dashboards and you actually do that using a filter action.', 'start': 6943.194, 'duration': 7.042}, {'end': 6956.337, 'text': "So we're going to name that action, go to sales dashboard.", 'start': 6950.756, 'duration': 5.581}, {'end': 6960.733, 'text': 'and we want it to happen when we click on our sales sheet.', 'start': 6957.19, 'duration': 3.543}, {'end': 6964.915, 'text': 'so you see right here it shows us the two sheets that are on this dashboard.', 'start': 6960.733, 'duration': 4.182}, {'end': 6967.837, 'text': "when we click on the profits dashboard, we don't want this action to occur.", 'start': 6964.915, 'duration': 2.922}, {'end': 6969.519, 'text': 'this is our go to sales dashboard.', 'start': 6967.837, 'duration': 1.682}, {'end': 6973.742, 'text': 'now you can have an action occur on hover or select.', 'start': 6969.519, 'duration': 4.223}], 'summary': 'Link dashboards using filter action, on click, not hover.', 'duration': 31.948, 'max_score': 6941.794, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k6941794.jpg'}, {'end': 7333.254, 'src': 'embed', 'start': 7297.544, 'weight': 1, 'content': [{'end': 7299.988, 'text': "And now we've got 2015 and 2016.", 'start': 7297.544, 'duration': 2.444}, {'end': 7303.334, 'text': "So that's how you do linking between the two dashboards.", 'start': 7299.988, 'duration': 3.346}, {'end': 7315.102, 'text': "If you wanted to be able to include region as well, you could put a note in the tooltip for this that this doesn't work for region.", 'start': 7303.795, 'duration': 11.307}, {'end': 7317.143, 'text': "linking from this area doesn't work.", 'start': 7315.102, 'duration': 2.041}, {'end': 7323.087, 'text': 'or perhaps you could not have this total line on the same visualization.', 'start': 7317.143, 'duration': 5.944}, {'end': 7333.254, 'text': 'you could have a separate visualization that shows the total or an area chart instead and that will let you not have this problem of go to sales dashboard not linking appropriately.', 'start': 7323.087, 'duration': 10.167}], 'summary': 'Linking between 2015 and 2016 dashboards, note limitations for region linking, consider separate visualization for total to avoid linking issues.', 'duration': 35.71, 'max_score': 7297.544, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k7297544.jpg'}, {'end': 7928.069, 'src': 'embed', 'start': 7898.153, 'weight': 2, 'content': [{'end': 7905.955, 'text': 'However, some visualizations, like this visualization for example, if it gets too squished you stop being able to read things very well.', 'start': 7898.153, 'duration': 7.802}, {'end': 7909.256, 'text': 'So automatic has its definite pros and cons.', 'start': 7906.015, 'duration': 3.241}, {'end': 7917.743, 'text': "So we're going to bring on our profit and sales by segment.", 'start': 7914.921, 'duration': 2.822}, {'end': 7923.987, 'text': 'And it already pops up with its legend and total customers by sale.', 'start': 7918.223, 'duration': 5.764}, {'end': 7928.069, 'text': 'And it pops up with its legends and filters and it pops up with its parameter.', 'start': 7924.327, 'duration': 3.742}], 'summary': 'Visualization quality affects readability. automatic features come with pros and cons.', 'duration': 29.916, 'max_score': 7898.153, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k7898153.jpg'}], 'start': 6941.794, 'title': 'Creating user-friendly dashboards', 'summary': 'Elaborates on creating user-friendly dashboards with parameters in tableau, focusing on filter actions for sales and profit, linking dashboards, and customizing visualizations to effectively represent profit and sales data.', 'chapters': [{'end': 7243.071, 'start': 6941.794, 'title': 'Dashboard filter actions for sales and profit', 'summary': 'Explains how to create filter actions to navigate between dashboards, specifying the action triggers and targeted sheets, and defining filter criteria, with a focus on linking sales and profit dashboards and resolving region filter issues.', 'duration': 301.277, 'highlights': ['Filter actions allow for navigation between dashboards, defining triggers and targets, with an emphasis on linking sales and profit dashboards.', 'Defining filter criteria specifies the data to be filtered, enabling selection of specific values like 2013 and region, demonstrating the application and limitations of filter actions.', 'Resolving region filter issues involves editing actions to select and filter on relevant fields, addressing errors and ensuring accurate filtering between dashboards.']}, {'end': 7606.974, 'start': 7243.78, 'title': 'Creating profit and sales dashboard', 'summary': 'Explains linking between two dashboards, creating a final segment dashboard, and customizing visualizations in tableau, including using parameters and dual axes, to represent profit and sales data effectively.', 'duration': 363.194, 'highlights': ['The chapter explains the process of linking between two dashboards and selecting multiple years for visualization, providing practical insight for data analysis and visualization in Tableau. multiple years (2015 and 2016)', 'It demonstrates the creation of a final segment dashboard with customizable names and parameters, showcasing the flexibility and organization capabilities of Tableau. flexible naming and parameter usage', 'The detailed explanation of customizing visualizations, including dual axes and color palette selection, provides practical guidance for effectively representing profit and sales data in Tableau. dual axes, color palette selection']}, {'end': 8089.817, 'start': 7607.275, 'title': 'Creating user-friendly dashboard with parameters', 'summary': 'Discusses creating user-friendly dashboards with parameters in tableau, including creating a more user-friendly title for top customers by sales, utilizing parameters to control changes, and visualizing profit and sales by segment.', 'duration': 482.542, 'highlights': ['Utilizing parameters to create a more user-friendly title for top customers by sales, allowing users to control changes and filters, and visualizing profit and sales by segment with legends and filters.', 'Using a calculated field to create a more user-friendly title for top customers by sales, incorporating the parameter to display the number of top customers, and visualizing profit and sales by segment with color and center adjustments.', 'Understanding the impact of parameters on multiple sheets within the workbook, utilizing legends and filters to enhance user experience, and formatting options for creating user-friendly dashboard elements.']}], 'duration': 1148.023, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k6941794.jpg', 'highlights': ['Filter actions enable navigation between dashboards, emphasizing linking sales and profit dashboards.', 'Demonstrates the process of linking between two dashboards and selecting multiple years for visualization.', 'Utilizing parameters to create a more user-friendly title for top customers by sales and visualizing profit and sales by segment with legends and filters.']}, {'end': 9067.777, 'segs': [{'end': 8118.037, 'src': 'embed', 'start': 8090.818, 'weight': 0, 'content': [{'end': 8095.76, 'text': 'Today in this video, we learned about an overview of business intelligence and Tableau.', 'start': 8090.818, 'duration': 4.942}, {'end': 8100.363, 'text': 'We talked about how to install Tableau Public and how to connect to a data source.', 'start': 8096.14, 'duration': 4.223}, {'end': 8105.025, 'text': 'We also talked about creating calculated fields like this one.', 'start': 8101.203, 'duration': 3.822}, {'end': 8108.587, 'text': 'We talked about making sets and parameters.', 'start': 8105.885, 'duration': 2.702}, {'end': 8112.829, 'text': 'We learned how to make a donut chart and a 2D donut chart.', 'start': 8109.147, 'duration': 3.682}, {'end': 8118.037, 'text': 'We learned about making dashboards and adding filters to those dashboards.', 'start': 8113.309, 'duration': 4.728}], 'summary': 'Learned about business intelligence and tableau, including installing tableau public, connecting to data sources, creating calculated fields, making sets and parameters, creating donut and 2d donut charts, making dashboards, and adding filters.', 'duration': 27.219, 'max_score': 8090.818, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8090818.jpg'}, {'end': 8162.028, 'src': 'embed', 'start': 8134.111, 'weight': 1, 'content': [{'end': 8140.797, 'text': 'And a live connection is where the data will update based on when the source of the data updates.', 'start': 8134.111, 'duration': 6.686}, {'end': 8149.262, 'text': "So if you're connected to a database and something in the database changes, then you'll pick up those changes when you open the report,", 'start': 8140.957, 'duration': 8.305}, {'end': 8153.304, 'text': 'as it will query that database when the report is opened.', 'start': 8149.262, 'duration': 4.042}, {'end': 8162.028, 'text': 'Whereas an extract connection is extracted into, creates a subset of the data that improves performance.', 'start': 8153.764, 'duration': 8.264}], 'summary': 'Live connection updates data in real-time based on source changes, while extract connection creates a performance-improving subset of data.', 'duration': 27.917, 'max_score': 8134.111, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8134111.jpg'}, {'end': 8309.616, 'src': 'embed', 'start': 8283.834, 'weight': 2, 'content': [{'end': 8289.437, 'text': 'So we would have to come in and select out of the order side and the people side.', 'start': 8283.834, 'duration': 5.603}, {'end': 8291.208, 'text': "what we'd like to join on.", 'start': 8290.147, 'duration': 1.061}, {'end': 8297.071, 'text': 'And then we have the options to do an inner join, a left join, a right join, and a full outer join.', 'start': 8291.648, 'duration': 5.423}, {'end': 8299.332, 'text': "Let's review quickly what these look like.", 'start': 8297.471, 'duration': 1.861}, {'end': 8302.653, 'text': 'So say we had two tables that we wanted to join together.', 'start': 8299.712, 'duration': 2.941}, {'end': 8309.616, 'text': 'One of them was the student table that had the student names and the key to their grade,', 'start': 8303.153, 'duration': 6.463}], 'summary': 'The options for joining tables include inner, left, right, and full outer joins.', 'duration': 25.782, 'max_score': 8283.834, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8283834.jpg'}, {'end': 8531.388, 'src': 'embed', 'start': 8500.902, 'weight': 4, 'content': [{'end': 8503.626, 'text': "For our purposes, we'll do an inner join.", 'start': 8500.902, 'duration': 2.724}, {'end': 8523.845, 'text': "Now let's say we had a second Excel sheet here that had more orders and you can do a union which is just adding more orders by dragging that second orders table right underneath the original orders table.", 'start': 8504.287, 'duration': 19.558}, {'end': 8526.686, 'text': 'You can see it says there, drag table to union.', 'start': 8524.285, 'duration': 2.401}, {'end': 8531.388, 'text': "And that's helpful for if you have an Excel sheet for maybe different years.", 'start': 8527.226, 'duration': 4.162}], 'summary': 'Using inner join and union to combine orders from multiple excel sheets for different years.', 'duration': 30.486, 'max_score': 8500.902, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8500902.jpg'}, {'end': 8658.432, 'src': 'embed', 'start': 8580.126, 'weight': 5, 'content': [{'end': 8587.91, 'text': "Now we're going to take a look at calculations and which ones are calculated on the database side versus which are calculated on the table side.", 'start': 8580.126, 'duration': 7.784}, {'end': 8596.115, 'text': 'So here we have percentage of total sales split up by subcategory and category.', 'start': 8589.631, 'duration': 6.484}, {'end': 8601.438, 'text': 'We also have percentage of total sales along table down.', 'start': 8596.795, 'duration': 4.643}, {'end': 8609.541, 'text': 'So the difference between these two things are one of them is made using calculated field,', 'start': 8601.918, 'duration': 7.623}, {'end': 8614.613, 'text': 'which is where we do the sum of sales divided by the sum of fixed sum of sales.', 'start': 8609.541, 'duration': 5.072}, {'end': 8617.661, 'text': 'This part is called a level of detail calculation.', 'start': 8615.155, 'duration': 2.506}, {'end': 8630.156, 'text': 'And this calculation the sum of sales and the sum of the level of detail of sales, which basically makes the database find the total sum of sales.', 'start': 8619.492, 'duration': 10.664}, {'end': 8633.397, 'text': 'regardless of these dimensions, we pulled on.', 'start': 8630.156, 'duration': 3.241}, {'end': 8635.538, 'text': 'So it gives us our total number.', 'start': 8634.018, 'duration': 1.52}, {'end': 8640.24, 'text': 'So this will be sum of sales for bookcases and this will be sum of sales for everything.', 'start': 8635.738, 'duration': 4.502}, {'end': 8651.287, 'text': "This calculation is done on the database side, whereas this one, percentage of total sales along table down, is what's called a table calculation.", 'start': 8640.78, 'duration': 10.507}, {'end': 8658.432, 'text': "It's a quick table calculation of percent of total, and it is done in Tableau.", 'start': 8652.665, 'duration': 5.767}], 'summary': 'Comparison of database-side and table-side calculations for sales percentages.', 'duration': 78.306, 'max_score': 8580.126, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8580126.jpg'}, {'end': 8771.375, 'src': 'embed', 'start': 8743.666, 'weight': 8, 'content': [{'end': 8747.089, 'text': "And that's because it does take into account the filter of category.", 'start': 8743.666, 'duration': 3.423}, {'end': 8749.35, 'text': "So let's pull the filter of category off.", 'start': 8747.469, 'duration': 1.881}, {'end': 8752.172, 'text': "And we can see that they're both out of 100% now.", 'start': 8749.83, 'duration': 2.342}, {'end': 8758.177, 'text': 'And each of these take into account the same amount of data since we have no filters here.', 'start': 8752.633, 'duration': 5.544}, {'end': 8765.469, 'text': 'So if you want it to take into account the filters on the table, then you need to use a table calculation.', 'start': 8759.184, 'duration': 6.285}, {'end': 8771.375, 'text': 'However, when you push the information back to the database to do the calculation,', 'start': 8765.89, 'duration': 5.485}], 'summary': 'Data analysis shows 100% unfiltered, use table calculation for filtered data.', 'duration': 27.709, 'max_score': 8743.666, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8743666.jpg'}, {'end': 8852.621, 'src': 'embed', 'start': 8823.567, 'weight': 9, 'content': [{'end': 8833.613, 'text': "Great. so now we have here's all of our stores and here are our sales, and if we wanted to rank them based on who had the highest sales to the lowest sales,", 'start': 8823.567, 'duration': 10.046}, {'end': 8839.217, 'text': 'we could create a calculated field called rank by sales.', 'start': 8833.613, 'duration': 5.604}, {'end': 8846.998, 'text': "and we're going to use our rank function and we're going to put it in sales.", 'start': 8842.475, 'duration': 4.523}, {'end': 8851.74, 'text': 'Now we receive this error here so when we hover we see what that arrow says.', 'start': 8847.438, 'duration': 4.302}, {'end': 8852.621, 'text': 'Oh, you can click.', 'start': 8851.76, 'duration': 0.861}], 'summary': "Creating a calculated field 'rank by sales' to rank stores based on sales data, encountered an error.", 'duration': 29.054, 'max_score': 8823.567, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8823567.jpg'}], 'start': 8090.818, 'title': 'Tableau & bi fundamentals, joins, unions, and calculations', 'summary': 'Provides an overview of tableau & bi, covering installation, data connection, table joins, unions, calculated fields, and table calculations with practical examples, discussing live vs. extract connection, and exploring ranking methods, providing comprehensive insights for effective data analysis and visualization.', 'chapters': [{'end': 8302.653, 'start': 8090.818, 'title': 'Tableau bi overview & data connections', 'summary': 'Provides an overview of tableau and business intelligence, covering installation, data connection, creating calculated fields, making dashboards, and discussing live connection vs. extract connection, including their functionalities and differences.', 'duration': 211.835, 'highlights': ['The chapter covers the process of creating calculated fields, making sets and parameters, and creating a donut chart and a 2D donut chart. This demonstrates the practical application of Tableau in creating visualizations and manipulating data, enhancing the understanding of data visualization techniques.', 'The difference between a live connection and an extract connection is explained, emphasizing the automatic data update in a live connection and the need for manual refreshing in an extract connection. This provides a clear understanding of the functionalities and implications of different data connections in Tableau, enhancing the comprehension of data management and real-time data updates.', 'The process of joining data in Tableau is detailed, including the automatic selection of join columns and the options for inner join, left join, right join, and full outer join. This highlights the practical steps involved in integrating and manipulating data from different sources, enhancing the understanding of data integration techniques and their applications.']}, {'end': 8579.11, 'start': 8303.153, 'title': 'Table joins and unions', 'summary': 'Explains the concept of table joins and unions, demonstrating the effects of inner join, left join, right join, and full outer join with examples and also discusses the utility of union for combining data from different sources in tableau.', 'duration': 275.957, 'highlights': ['The chapter discusses the effects of inner join, left join, right join, and full outer join with examples. It explains the impact of each type of join on the resulting data set using specific examples such as the inclusion or exclusion of certain data based on the join type.', "The chapter demonstrates the utility of union for combining data from different sources in Tableau. It provides an example of using union to add more orders from a second Excel sheet, explaining how it can be helpful for combining data from different sources, such as different years' orders.", 'The chapter explains the concept of table joins and unions. It provides an overview of the concept of table joins and unions, demonstrating how they can be used to combine and manipulate data from different tables or sources.']}, {'end': 9067.777, 'start': 8580.126, 'title': 'Table calculations and ranking in tableau', 'summary': 'Explores the differences between database side and table side calculations in tableau, highlighting the use of calculated fields and table calculations to analyze percentage of total sales, and delves into the concept of ranking in tableau using different methods, providing insights on their functionality and applications.', 'duration': 487.651, 'highlights': ['The chapter explains the difference between database side and table side calculations in Tableau, emphasizing the use of calculated fields and table calculations to analyze percentage of total sales. It provides insights into the distinction between database side and table side calculations in Tableau, focusing on the use of calculated fields and table calculations to analyze percentage of total sales, showcasing the differences in processing and functionality.', 'The transcript details the use of calculated fields for level of detail calculations, wherein the sum of sales and the sum of the level of detail of sales are calculated on the database side to find the total sum of sales regardless of the dimensions pulled. It elaborates on the use of calculated fields for level of detail calculations, revealing how the sum of sales and the sum of the level of detail of sales are computed on the database side to ascertain the total sum of sales, irrespective of the dimensions involved.', "The discussion highlights the concept of table calculations in Tableau, specifically focusing on the quick table calculation of 'percent of total' which is processed locally after aggregations have occurred. It emphasizes the concept of table calculations in Tableau, particularly spotlighting the quick table calculation of 'percent of total', elucidating its local processing after aggregations have taken place and its implications on data analysis.", 'The transcript provides insights into the pros and cons of using table calculations, particularly in the context of considering filters and their impact on the calculation results. It offers insights into the advantages and disadvantages of employing table calculations, particularly in the context of evaluating the influence of filters on the calculation outcomes, providing a comprehensive understanding of their practical implications.', "The chapter delves into the concept of ranking in Tableau, demonstrating the creation of a calculated field for ranking based on sales and exploring the functionality of the 'rank' table calculation. It explores the concept of ranking in Tableau, showcasing the creation of a calculated field for ranking based on sales and elucidating the functionality of the 'rank' table calculation, offering a comprehensive understanding of its application in data analysis."]}], 'duration': 976.959, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k8090818.jpg', 'highlights': ['The chapter covers the process of creating calculated fields, making sets and parameters, and creating visualizations, enhancing the understanding of data visualization techniques.', 'The difference between a live connection and an extract connection is explained, emphasizing the automatic data update in a live connection and the need for manual refreshing in an extract connection, enhancing the comprehension of data management and real-time data updates.', 'The process of joining data in Tableau is detailed, including the automatic selection of join columns and the options for inner join, left join, right join, and full outer join, enhancing the understanding of data integration techniques and their applications.', 'The chapter discusses the effects of inner join, left join, right join, and full outer join with examples, explaining the impact of each type of join on the resulting data set using specific examples.', 'The chapter demonstrates the utility of union for combining data from different sources in Tableau, providing an example of using union to add more orders from a second Excel sheet, explaining how it can be helpful for combining data from different sources.', 'The chapter explains the difference between database side and table side calculations in Tableau, emphasizing the use of calculated fields and table calculations to analyze percentage of total sales, showcasing the differences in processing and functionality.', 'The transcript details the use of calculated fields for level of detail calculations, elaborating on the use of calculated fields for level of detail calculations, revealing how the sum of sales and the sum of the level of detail of sales are computed on the database side to ascertain the total sum of sales, irrespective of the dimensions involved.', "The discussion highlights the concept of table calculations in Tableau, particularly spotlighting the quick table calculation of 'percent of total', elucidating its local processing after aggregations have taken place and its implications on data analysis.", 'The transcript provides insights into the pros and cons of using table calculations, particularly in the context of evaluating the influence of filters on the calculation outcomes, providing a comprehensive understanding of their practical implications.', "The chapter delves into the concept of ranking in Tableau, showcasing the creation of a calculated field for ranking based on sales and elucidating the functionality of the 'rank' table calculation, offering a comprehensive understanding of its application in data analysis."]}, {'end': 9846.473, 'segs': [{'end': 9109.936, 'src': 'embed', 'start': 9067.777, 'weight': 0, 'content': [{'end': 9074.962, 'text': 'then they both receive the same rank here, but they receive the higher of the two options, whereas this one receives the lower of the two options.', 'start': 9067.777, 'duration': 7.185}, {'end': 9077.044, 'text': "And let's do one more.", 'start': 9076.003, 'duration': 1.041}, {'end': 9083.088, 'text': 'Duplicate Edit.', 'start': 9078.165, 'duration': 4.923}, {'end': 9085.05, 'text': 'Erase copy.', 'start': 9084.469, 'duration': 0.581}, {'end': 9102.269, 'text': "and we're going to do rank unique, and let's change the name to rank unique, perfect.", 'start': 9087.777, 'duration': 14.492}, {'end': 9109.055, 'text': 'and now this is going to give it a unique ranking, even when they share the same number.', 'start': 9102.269, 'duration': 6.786}, {'end': 9109.936, 'text': "so we'll hit, apply.", 'start': 9109.055, 'duration': 0.881}], 'summary': 'Demonstrating ranking options with unique and duplicate edit functions.', 'duration': 42.159, 'max_score': 9067.777, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9067777.jpg'}, {'end': 9177.379, 'src': 'embed', 'start': 9144.344, 'weight': 1, 'content': [{'end': 9148.507, 'text': "So it defaults to descending and it's saying the biggest is the best.", 'start': 9144.344, 'duration': 4.163}, {'end': 9152.17, 'text': "So for sales that's accurate.", 'start': 9149.408, 'duration': 2.762}, {'end': 9154.072, 'text': "So what it's doing is biggest down.", 'start': 9152.21, 'duration': 1.862}, {'end': 9158.655, 'text': 'Now here it has to decide which one to give three and which one to do four.', 'start': 9154.612, 'duration': 4.043}, {'end': 9165.18, 'text': "And it's doing that based on the ASCII values of the store.", 'start': 9158.675, 'duration': 6.505}, {'end': 9168.493, 'text': "So it's looking at more information on the row.", 'start': 9166.092, 'duration': 2.401}, {'end': 9177.379, 'text': 'And since uppercase B comes before lowercase c, uppercase B is getting the 3, even though they both have 20 for sales.', 'start': 9168.994, 'duration': 8.385}], 'summary': 'Data sorted in descending order based on ascii values for sales allocation.', 'duration': 33.035, 'max_score': 9144.344, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9144344.jpg'}, {'end': 9224.823, 'src': 'embed', 'start': 9196.488, 'weight': 2, 'content': [{'end': 9203.193, 'text': 'Also, if you want to follow along with our data sets, you can comment below and ask and the Simply Learn team will get you that data set.', 'start': 9196.488, 'duration': 6.705}, {'end': 9209.006, 'text': "So let's make a chart where we're going to look at category.", 'start': 9204.221, 'duration': 4.785}, {'end': 9214.412, 'text': "So we'll drag category onto columns and then we're going to look at sales.", 'start': 9209.206, 'duration': 5.206}, {'end': 9218.336, 'text': "So we'll drag sales onto rows and it will create three bar charts for us.", 'start': 9214.592, 'duration': 3.744}, {'end': 9224.823, 'text': "And we're going to call this sales by category.", 'start': 9219.197, 'duration': 5.626}], 'summary': 'Demonstrating data visualization by creating a chart with sales data by category.', 'duration': 28.335, 'max_score': 9196.488, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9196488.jpg'}, {'end': 9293.884, 'src': 'embed', 'start': 9261.528, 'weight': 3, 'content': [{'end': 9276.392, 'text': "here you can make a worksheet action where we're going to move from the sales by category sheet to the sales by subcategory sheet and also filter down that sheet to only the category we want to see.", 'start': 9261.528, 'duration': 14.864}, {'end': 9282.654, 'text': 'so click filter and we can name this filter.', 'start': 9276.392, 'duration': 6.262}, {'end': 9289.938, 'text': "go to subcategory and we're going to do this filter on select.", 'start': 9282.654, 'duration': 7.284}, {'end': 9293.884, 'text': "so this name won't be seen except for in our actions list.", 'start': 9289.938, 'duration': 3.946}], 'summary': 'Create a worksheet action to move from sales by category to sales by subcategory, filtering to the desired category.', 'duration': 32.356, 'max_score': 9261.528, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9261528.jpg'}, {'end': 9504.385, 'src': 'embed', 'start': 9473.943, 'weight': 4, 'content': [{'end': 9484.958, 'text': "So let's take sales by subcategory and look at it over top of our sales by category stacked over top of sales by subcategory.", 'start': 9473.943, 'duration': 11.015}, {'end': 9485.998, 'text': 'So we want both of those.', 'start': 9485.018, 'duration': 0.98}, {'end': 9493.921, 'text': "Let's make our dashboard automatic for testing purposes and we'll go to dashboard.", 'start': 9486.558, 'duration': 7.363}, {'end': 9495.862, 'text': "We'll click create actions.", 'start': 9493.941, 'duration': 1.921}, {'end': 9497.562, 'text': "So we're going to add an action.", 'start': 9496.442, 'duration': 1.12}, {'end': 9499.463, 'text': "It's going to be a highlight action.", 'start': 9497.582, 'duration': 1.881}, {'end': 9504.385, 'text': 'Highlight sales by subcategory.', 'start': 9501.384, 'duration': 3.001}], 'summary': 'Analyze sales data by subcategory and category, and create an automatic dashboard for testing purposes.', 'duration': 30.442, 'max_score': 9473.943, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9473943.jpg'}, {'end': 9708.632, 'src': 'embed', 'start': 9679.378, 'weight': 5, 'content': [{'end': 9681.399, 'text': "that action won't transfer over.", 'start': 9679.378, 'duration': 2.021}, {'end': 9683, 'text': "you'll need to make a dashboard action.", 'start': 9681.399, 'duration': 1.601}, {'end': 9686.687, 'text': "So we're going to make a go to URL action.", 'start': 9684.482, 'duration': 2.205}, {'end': 9688.09, 'text': "We're going to have it on menu.", 'start': 9686.707, 'duration': 1.383}, {'end': 9690.435, 'text': "We're going to call it Wiki.", 'start': 9688.13, 'duration': 2.305}, {'end': 9697.702, 'text': "And it's going to only affect our new sheet, sheet 6, which we should rename.", 'start': 9692.157, 'duration': 5.545}, {'end': 9701.185, 'text': "And we're going to add a URL in here.", 'start': 9698.383, 'duration': 2.802}, {'end': 9702.787, 'text': 'So this will take us to Wikipedia.', 'start': 9701.305, 'duration': 1.482}, {'end': 9708.632, 'text': 'And then whatever you put at the end of the Wikipedia link, it will take you to that page on Wikipedia.', 'start': 9702.807, 'duration': 5.825}], 'summary': 'Creating a dashboard action to go to a specific wikipedia page on a new sheet, sheet 6.', 'duration': 29.254, 'max_score': 9679.378, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9679378.jpg'}], 'start': 9067.777, 'title': 'Ranking options and tableau actions', 'summary': 'Discusses ranking data, ascending/descending order, and tableau actions. it includes unique ranking, ascii values, sales by category and subcategory, highlight and url actions, data filtering, and linking to external sources.', 'chapters': [{'end': 9168.493, 'start': 9067.777, 'title': 'Ranking options and ascending/descending order', 'summary': 'Explains the options for ranking data and the concept of ascending and descending order, demonstrating the use of unique ranking and the basis for deciding ranks based on ascii values.', 'duration': 100.716, 'highlights': ['The chapter discusses the options for ranking data, including the higher and lower of two options and unique ranking, providing practical examples of their application.', 'It explains the concept of ascending and descending order, illustrating how to define the ranking based on sales and the use of ASCII values to determine ranks.']}, {'end': 9846.473, 'start': 9168.994, 'title': 'Tableau actions and charts', 'summary': 'Explains the use of actions in tableau, including creating charts such as sales by category and sales by subcategory, and utilizing highlight and url actions for interactive visualization and navigation, with insights on data filtering and linking to external sources.', 'duration': 677.479, 'highlights': ['Explaining the process of creating charts such as sales by category and sales by subcategory in Tableau. The process of creating charts like sales by category and sales by subcategory is explained, including dragging category and sales onto columns and rows to create bar charts.', 'Demonstrating the use of worksheet actions to filter data and navigate to lower levels in Tableau. The demonstration of using worksheet actions to filter data and navigate to lower levels in Tableau, with examples of filtering down to specific categories such as furniture and office supplies.', 'Illustrating the application of highlight actions in creating interactive visualizations in Tableau. The application of highlight actions in creating interactive visualizations in Tableau, allowing users to highlight specific data points by selecting or dragging, providing a more dynamic and engaging user experience.', 'Exploring the implementation of URL actions for linking to external sources and integrating web pages within Tableau. Exploring the implementation of URL actions for linking to external sources and integrating web pages within Tableau, enabling users to access additional information or external resources directly from the visualization.']}], 'duration': 778.696, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9067777.jpg', 'highlights': ['The chapter discusses the options for ranking data, including the higher and lower of two options and unique ranking, providing practical examples of their application.', 'It explains the concept of ascending and descending order, illustrating how to define the ranking based on sales and the use of ASCII values to determine ranks.', 'Explaining the process of creating charts such as sales by category and sales by subcategory in Tableau.', 'Demonstrating the use of worksheet actions to filter data and navigate to lower levels in Tableau.', 'Illustrating the application of highlight actions in creating interactive visualizations in Tableau.', 'Exploring the implementation of URL actions for linking to external sources and integrating web pages within Tableau.']}, {'end': 11424.845, 'segs': [{'end': 9895.819, 'src': 'embed', 'start': 9847.213, 'weight': 0, 'content': [{'end': 9851.736, 'text': "Let's put in our Wikipedia page and it'll take us to state.", 'start': 9847.213, 'duration': 4.523}, {'end': 9853.137, 'text': "So we'll hit OK.", 'start': 9852.296, 'duration': 0.841}, {'end': 9857.419, 'text': "OK And now when we click on Oklahoma, it'll open up a page for Oklahoma.", 'start': 9853.277, 'duration': 4.142}, {'end': 9861.148, 'text': "But let's unselect Oklahoma.", 'start': 9859.386, 'duration': 1.762}, {'end': 9868.554, 'text': "If we drag on web page from the objects here, you don't even have to enter anything for your URL.", 'start': 9861.728, 'duration': 6.826}, {'end': 9869.275, 'text': 'You just hit OK.', 'start': 9868.574, 'duration': 0.701}, {'end': 9872.358, 'text': 'And now we have the bottom half of the screen is a web page.', 'start': 9869.775, 'duration': 2.583}, {'end': 9880.885, 'text': "And when we click on Oklahoma, instead of taking us to Oklahoma in a separate thing, it'll take us to Oklahoma right here in the visualization.", 'start': 9872.498, 'duration': 8.387}, {'end': 9882.447, 'text': "So we'll change it to Texas.", 'start': 9881.286, 'duration': 1.161}, {'end': 9883.668, 'text': 'And this will change to Texas.', 'start': 9882.547, 'duration': 1.121}, {'end': 9891.058, 'text': 'If you unselect, it leaves the page there based on the one that you had just selected.', 'start': 9886.277, 'duration': 4.781}, {'end': 9895.819, 'text': "Next we're going to take a look at reference bands and lines.", 'start': 9893.079, 'duration': 2.74}], 'summary': 'Demonstration of linking wikipedia page to visualization and using reference bands and lines.', 'duration': 48.606, 'max_score': 9847.213, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9847213.jpg'}, {'end': 9963.133, 'src': 'embed', 'start': 9931.602, 'weight': 3, 'content': [{'end': 9935.244, 'text': "So let's do sales onto rows, and we have our bar charts.", 'start': 9931.602, 'duration': 3.642}, {'end': 9941.348, 'text': "And we'll talk about the difference between a cell, a pane, and the table.", 'start': 9936.545, 'duration': 4.803}, {'end': 9951.248, 'text': 'So when we go to analytics and we code to drag our reference line onto our visualization, it says you can add the reference line for the whole table,', 'start': 9941.708, 'duration': 9.54}, {'end': 9952.869, 'text': 'for a pane or for a cell.', 'start': 9951.248, 'duration': 1.621}, {'end': 9963.133, 'text': "So, if we take our subcategory and drag it onto color, Since the subcategory is our lowest level, it's going to define our cell.", 'start': 9953.589, 'duration': 9.544}], 'summary': 'Analyzing sales data using bar charts and reference lines for different levels of visualization.', 'duration': 31.531, 'max_score': 9931.602, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9931602.jpg'}, {'end': 10233.269, 'src': 'embed', 'start': 10206.644, 'weight': 5, 'content': [{'end': 10211.906, 'text': 'we had with reference lines where you can have it be for the whole table, per pane or per cell.', 'start': 10206.644, 'duration': 5.262}, {'end': 10214.367, 'text': "so let's do a reference band for the whole table.", 'start': 10211.906, 'duration': 2.461}, {'end': 10219.828, 'text': "so it's doing entire table and it's taking from the minimum to the maximum.", 'start': 10214.367, 'duration': 5.461}, {'end': 10225.39, 'text': 'now we could change the minimum to be the average to the maximum, and now that will highlight the whole table.', 'start': 10219.828, 'duration': 5.562}, {'end': 10233.269, 'text': "everything that's above the average becomes highlighted, And if you wanted to change it, you could do the minimum to the average.", 'start': 10225.39, 'duration': 7.879}], 'summary': 'Reference bands can be added to highlight data above or below average in a table.', 'duration': 26.625, 'max_score': 10206.644, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k10206644.jpg'}, {'end': 10424.684, 'src': 'embed', 'start': 10383.478, 'weight': 6, 'content': [{'end': 10386.4, 'text': "So if it's less than two, then they're going to call it an early shipment.", 'start': 10383.478, 'duration': 2.922}, {'end': 10398.986, 'text': 'Else. if average days to ship is greater than or equal to five, then shipment late.', 'start': 10387.701, 'duration': 11.285}, {'end': 10420.221, 'text': "and else, if let's get the rest of them and average days to ship is not less than two, greater than two and less than five, then on time.", 'start': 10398.986, 'duration': 21.235}, {'end': 10424.684, 'text': 'two words on time, and now you can see we have an error here.', 'start': 10420.221, 'duration': 4.463}], 'summary': 'Shipment labeled early if <2 days, late if >=5 days, else on time.', 'duration': 41.206, 'max_score': 10383.478, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k10383478.jpg'}, {'end': 10520.273, 'src': 'embed', 'start': 10490.18, 'weight': 9, 'content': [{'end': 10494.521, 'text': 'If we click Edit Axis, you can choose if you want that to be the case.', 'start': 10490.18, 'duration': 4.341}, {'end': 10500.303, 'text': "So it's like right now all of them use uniform axis range for all rows and columns, and that's really nice,", 'start': 10494.661, 'duration': 5.642}, {'end': 10504.044, 'text': "because it's easy to compare Colorado to Colorado to Colorado.", 'start': 10500.303, 'duration': 3.741}, {'end': 10513.87, 'text': 'If you change it to independent axis for each rows, you can see now this one only goes from 0 to not even 1, whereas this one goes from 0 to 6.', 'start': 10504.645, 'duration': 9.225}, {'end': 10520.273, 'text': 'And you can compare it with color, but you can no longer compare it with size across all of these different categories.', 'start': 10513.87, 'duration': 6.403}], 'summary': 'Edit axis allows choosing uniform or independent axis ranges for comparison in data visualization.', 'duration': 30.093, 'max_score': 10490.18, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k10490180.jpg'}, {'end': 10569.886, 'src': 'embed', 'start': 10543.175, 'weight': 7, 'content': [{'end': 10548.037, 'text': "And we'll take a look at what a waterfall looks like at the end and talk about how it works.", 'start': 10543.175, 'duration': 4.862}, {'end': 10553.639, 'text': "So after we build it, we'll talk about some of the benefits of having a waterfall chart.", 'start': 10548.697, 'duration': 4.942}, {'end': 10556.02, 'text': "So what we're going to do is build it over time.", 'start': 10554, 'duration': 2.02}, {'end': 10560.422, 'text': "For this visualization, we're just going to look at the year of 2014.", 'start': 10556.581, 'duration': 3.841}, {'end': 10565.764, 'text': "So I'm going to filter it to the order dates for 2014.", 'start': 10560.422, 'duration': 5.342}, {'end': 10569.886, 'text': "And then we're going to take our order date and bring it onto columns.", 'start': 10565.764, 'duration': 4.122}], 'summary': 'Analyzing a waterfall chart for 2014 data.', 'duration': 26.711, 'max_score': 10543.175, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k10543175.jpg'}, {'end': 10820.784, 'src': 'embed', 'start': 10787.255, 'weight': 8, 'content': [{'end': 10799.741, 'text': "So let's sort it and we can see one person has 17 orders and we have one, two, three, four, five, six, seven people have 13 orders.", 'start': 10787.255, 'duration': 12.486}, {'end': 10803.207, 'text': 'And it goes on from there.', 'start': 10802.006, 'duration': 1.201}, {'end': 10815.419, 'text': 'So what if we wanted to make a visualization that would show how many customers had how many orders and what number of orders was the most popular?', 'start': 10803.227, 'duration': 12.192}, {'end': 10819.143, 'text': 'We would need to do a level of detail calculation.', 'start': 10815.439, 'duration': 3.704}, {'end': 10820.784, 'text': "So let's clear the workbook.", 'start': 10819.583, 'duration': 1.201}], 'summary': 'Data analysis shows 1 person with 17 orders and 7 people with 13 orders. visualization needed for order distribution.', 'duration': 33.529, 'max_score': 10787.255, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k10787255.jpg'}, {'end': 11056.125, 'src': 'embed', 'start': 11021.304, 'weight': 10, 'content': [{'end': 11023.645, 'text': "And that's an introduction to level of detail.", 'start': 11021.304, 'duration': 2.341}, {'end': 11033.248, 'text': "So let's name this sheet, level of detail, LOD orders per customer.", 'start': 11024.522, 'duration': 8.726}, {'end': 11044.156, 'text': "Perfect Now let's make a new sheet and we are going to do an analysis about new customers.", 'start': 11035.31, 'duration': 8.846}, {'end': 11049.84, 'text': "So we'll call this level of detail, new customer analysis.", 'start': 11045.237, 'duration': 4.603}, {'end': 11056.125, 'text': 'So this visualization is going to be about customer acquisition over time.', 'start': 11052.423, 'duration': 3.702}], 'summary': 'Creating sheets for level of detail and new customer analysis with visualizations.', 'duration': 34.821, 'max_score': 11021.304, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k11021304.jpg'}, {'end': 11272.383, 'src': 'embed', 'start': 11240.465, 'weight': 11, 'content': [{'end': 11249.689, 'text': 'apply, okay, and now we can take our new field, which is new or existing, drag it on the filters and we only want new.', 'start': 11240.465, 'duration': 9.224}, {'end': 11258.857, 'text': "We'll hit apply, and we can see that we have new customers, but less over time.", 'start': 11250.37, 'duration': 8.487}, {'end': 11272.383, 'text': "So now we're going to change this count distinct to be a running total and we can see over time how our new customers are adding up.", 'start': 11260.319, 'duration': 12.064}], 'summary': 'Analysis shows decrease in new customers over time; switching to running total for tracking.', 'duration': 31.918, 'max_score': 11240.465, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k11240465.jpg'}, {'end': 11339.115, 'src': 'embed', 'start': 11316.197, 'weight': 12, 'content': [{'end': 11326.625, 'text': "Here, while it's leveling out in the red, it looks like the west region leveled out as well, but picked up sooner and started getting new customers.", 'start': 11316.197, 'duration': 10.428}, {'end': 11332.53, 'text': 'So this type of analysis will help you view new customers over time.', 'start': 11327.366, 'duration': 5.164}, {'end': 11339.115, 'text': "And it's only possible because we were able to do a level of detail calculation here on new or existing.", 'start': 11333.21, 'duration': 5.905}], 'summary': 'West region picked up new customers sooner, aiding analysis of new customers over time.', 'duration': 22.918, 'max_score': 11316.197, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k11316197.jpg'}], 'start': 9847.213, 'title': 'Using wikipedia page and visualizing data', 'summary': 'Demonstrates using a wikipedia page to visualize state data, by selecting and unselecting states to display information on a web page within the visualization. it also covers creating reference lines and bands in tableau, data visualization and analysis, and level of detail analysis.', 'chapters': [{'end': 9895.819, 'start': 9847.213, 'title': 'Using wikipedia page and visualizing data', 'summary': 'Demonstrates how to use a wikipedia page to visualize state data, by selecting and unselecting states to display information on a web page within the visualization.', 'duration': 48.606, 'highlights': ['By using a Wikipedia page, users can visualize state data by selecting and unselecting states, with the web page displaying the information within the visualization.', 'Dragging a web page from the objects eliminates the need to enter a URL, allowing for easy integration of web content into the visualization.', 'The ability to change the displayed state from Oklahoma to Texas within the visualization enhances the flexibility of the visualization tool.']}, {'end': 10456.806, 'start': 9896.139, 'title': 'Creating reference lines and bands', 'summary': 'Introduces how to create reference lines and bands in tableau, explaining their functionality and use cases, such as defining lines based on data and highlighting sections based on average computation, with examples of conditional formatting and sorting ship modes to analyze average days to ship.', 'duration': 560.667, 'highlights': ['Reference lines can be added for the whole table, for a pane, or for a cell, which enables the user to define lines based on different levels of data granularity. This feature allows users to add reference lines at various levels of granularity, such as for the whole table, for a pane, or for a cell, providing flexibility in defining and visualizing data.', 'The process of adding reference lines based on different levels of data granularity, such as for a cell, pane, or the whole table, is demonstrated with practical examples, showcasing how reference lines can be used to highlight specific sections based on the data. The demonstration includes practical examples of adding reference lines at different levels of data granularity, showcasing how it can be used to highlight specific sections based on the data, such as defining lines for the whole table, a pane, or a cell.', 'The chapter also covers the creation of reference bands, demonstrating how to define bands for the whole table, per pane, or per cell, and showcasing the customization options, such as changing the fill color and thickness of the bands. In addition to reference lines, the chapter covers the creation of reference bands, providing insights into defining bands for the whole table, per pane, or per cell, and showcasing customization options, including changing fill color and thickness.', 'The use of conditional formatting and sorting ship modes to analyze average days to ship is explained, demonstrating the creation and application of a calculated field to categorize shipments as early, late, or on time based on predefined conditions. The chapter explains the use of conditional formatting and sorting ship modes to analyze average days to ship, demonstrating the creation and application of a calculated field to categorize shipments as early, late, or on time based on predefined conditions, providing insights into effective data analysis.']}, {'end': 11019.804, 'start': 10458.126, 'title': 'Data visualization and analysis', 'summary': 'Discusses visualizing data using tableau, including creating a waterfall chart to analyze profit over time, and utilizing level of detail calculations to show the number of orders per customer.', 'duration': 561.678, 'highlights': ['The chapter discusses creating a waterfall chart to analyze profit over time, filtering data to the year 2014, and visualizing the running total of profit by month. Creating a waterfall chart for profit analysis, filtering data for 2014, visualizing running total of profit by month', 'The chapter explains the process of implementing level of detail calculation to show the number of orders per customer and sorting the number of orders by popularity. Implementing level of detail calculation for orders per customer, sorting orders by popularity', 'The chapter also discusses the benefits of using a uniform axis range for all rows and columns in data visualization. Benefits of using uniform axis range in data visualization']}, {'end': 11424.845, 'start': 11021.304, 'title': 'Level of detail analysis', 'summary': 'Explores using level of detail calculations in tableau to analyze new customer acquisition over time, creating a new field to distinguish new and existing customers, and visualizing new customer trends across different regions.', 'duration': 403.541, 'highlights': ['The chapter explores using level of detail calculations in Tableau to analyze new customer acquisition over time The chapter delves into using level of detail calculations in Tableau to analyze new customer acquisition over time, allowing for the comparison of new and existing customers and visualizing trends.', 'Creating a new field to distinguish new and existing customers The process involves creating a new field to differentiate new and existing customers based on their first order date, enabling the analysis of new customer trends over time.', 'Visualizing new customer trends across different regions The chapter discusses visualizing new customer trends across different regions, including the use of running totals to track the accumulation of new customers over time, and identifying regional differences in new customer acquisition.']}], 'duration': 1577.632, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xwj2p4LSD1k/pics/xwj2p4LSD1k9847213.jpg', 'highlights': ['By using a Wikipedia page, users can visualize state data by selecting and unselecting states, with the web page displaying the information within the visualization.', 'Dragging a web page from the objects eliminates the need to enter a URL, allowing for easy integration of web content into the visualization.', 'The ability to change the displayed state from Oklahoma to Texas within the visualization enhances the flexibility of the visualization tool.', 'Reference lines can be added for the whole table, for a pane, or for a cell, which enables the user to define lines based on different levels of data granularity.', 'The process of adding reference lines based on different levels of data granularity, such as for a cell, pane, or the whole table, is demonstrated with practical examples, showcasing how reference lines can be used to highlight specific sections based on the data.', 'The chapter also covers the creation of reference bands, demonstrating how to define bands for the whole table, per pane, or per cell, and showcasing the customization options, such as changing the fill color and thickness of the bands.', 'The use of conditional formatting and sorting ship modes to analyze average days to ship is explained, demonstrating the creation and application of a calculated field to categorize shipments as early, late, or on time based on predefined conditions.', 'The chapter discusses creating a waterfall chart to analyze profit over time, filtering data to the year 2014, and visualizing the running total of profit by month.', 'The chapter explains the process of implementing level of detail calculation to show the number of orders per customer and sorting the number of orders by popularity.', 'The chapter also discusses the benefits of using a uniform axis range for all rows and columns in data visualization.', 'The chapter explores using level of detail calculations in Tableau to analyze new customer acquisition over time.', 'Creating a new field to distinguish new and existing customers.', 'Visualizing new customer trends across different regions.']}], 'highlights': ['Tableau can connect 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, showcasing its industry recognition and reliability.', 'Tableau Prep is a new tool that visually allows data preparation before connecting and building reports, enhancing data visualization and report creation process.', 'Creating different visualizations (bar charts, line charts, scatter plots) in Tableau to analyze sales data and product performance.', 'Understanding hierarchies in dates allows for complex visualizations using hierarchies in dates, enabling quick comparison of data across different time periods and categories.', 'Creating calculated fields for profit ratios enhances the understanding of data visualization techniques.', 'The process of creating visualizations for sales and profit data by region, state, category, and subcategory is detailed, including the use of bar charts and interactive features for analysis.', 'Creating a donut chart for sales by category and region using dual axis charts for clear visualization.', 'Demonstrating the use of parameters to control visualization elements and filter data for dynamic filtering.', 'Explanation of creating a dual axis chart in Tableau by control-clicking and dragging measures, and adjusting the marks card to visualize data effectively.', 'The chapter demonstrates updating selections and filtering options in Tableau, enabling users to visualize sales data by region and identify states with no storage sales.', 'Demonstrates the benefits of utilizing different chart types, such as area charts and pie charts, to provide comprehensive insights into profit analysis and category segmentation within the data.', 'Creating Dashboard Actions Creating dashboard actions like using filter, highlight, and go to URL actions can enhance dashboard interaction and provide seamless navigation between different dashboards.', 'The chapter covers the process of creating calculated fields, making sets and parameters, and creating visualizations, enhancing the understanding of data visualization techniques.', 'The difference between a live connection and an extract connection is explained, emphasizing the automatic data update in a live connection and the need for manual refreshing in an extract connection, enhancing the comprehension of data management and real-time data updates.', 'The process of joining data in Tableau is detailed, including the automatic selection of join columns and the options for inner join, left join, right join, and full outer join, enhancing the understanding of data integration techniques and their applications.', "The chapter delves into the concept of ranking in Tableau, showcasing the creation of a calculated field for ranking based on sales and elucidating the functionality of the 'rank' table calculation, offering a comprehensive understanding of its application in data analysis.", 'The chapter discusses the options for ranking data, including the higher and lower of two options and unique ranking, providing practical examples of their application.', 'Explaining the process of creating charts such as sales by category and sales by subcategory in Tableau.', 'Illustrating the application of highlight actions in creating interactive visualizations in Tableau.', 'Exploring the implementation of URL actions for linking to external sources and integrating web pages within Tableau.', 'The ability to change the displayed state from Oklahoma to Texas within the visualization enhances the flexibility of the visualization tool.', 'Reference lines can be added for the whole table, for a pane, or for a cell, which enables the user to define lines based on different levels of data granularity.', 'The process of adding reference lines based on different levels of data granularity, such as for a cell, pane, or the whole table, is demonstrated with practical examples, showcasing how reference lines can be used to highlight specific sections based on the data.', 'The chapter also covers the creation of reference bands, demonstrating how to define bands for the whole table, per pane, or per cell, and showcasing the customization options, such as changing the fill color and thickness of the bands.', 'The chapter discusses creating a waterfall chart to analyze profit over time, filtering data to the year 2014, and visualizing the running total of profit by month.', 'The chapter explains the process of implementing level of detail calculation to show the number of orders per customer and sorting the number of orders by popularity.', 'The chapter also discusses the benefits of using a uniform axis range for all rows and columns in data visualization.', 'The chapter explores using level of detail calculations in Tableau to analyze new customer acquisition over time.', 'Creating a new field to distinguish new and existing customers.', 'Visualizing new customer trends across different regions.']}