title
Tableau For Data Science 2022 | Tableau For Data Visualization | Tableau Tutorial | Simplilearn

description
🔥 Post Graduate Program In Data Science: https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=GoogleDataStudio-zieh2hr1toQ&utm_medium=Descriptionff&utm_source=youtube 🔥IIT Kanpur Professional Certificate Course In Data Science (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-science?utm_campaign=GoogleDataStudio-zieh2hr1toQ&utm_medium=Descriptionff&utm_source=youtube 🔥 Data Science Bootcamp (US Only): https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=TableauTraining-Wh4sCCZjOwo&utm_medium=Descriptionff&utm_source=youtube 🔥Data Scientist Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?utm_campaign=TableauTraining-Wh4sCCZjOwo&utm_medium=Descriptionff&utm_source=youtube 🟡 Caltech AI & Machine Learning Bootcamp (For US Learners Only) - https://www.simplilearn.com/ai-machine-learning-bootcamp?utm_campaign=TableauTraining-Wh4sCCZjOwo&utm_medium=Descriptionff&utm_source=youtube This video is an updated and complete Tableau Full Course In 8 Hours. This Tableau Tutorial is designed to guide you right from the introduction. The video includes the Business Intelligence fundamentals, Charts in Tableau, Calculated fields, and other crucial segments and finally, you will also learn to design and customize your own Tableau Dashboard that provides you with real-time interactive data visualization. The Tableau Training For Beginners video includes the following topics. 🔥Free Tableau Course: https://www.simplilearn.com/learn-tableau-online-free-course-skillup?utm_campaign=TableauTraining&utm_medium=Description&utm_source=youtube Below topics are explained in this Tableau tutorial video: 0:00 Tableau - Introduction 00:50 Business Intelligence 01:51 Tableau 01:55 Why Tableau? 02:29 Tableau Products 05:42 Excel vs Tableau Summary 05:51 Tableau Installation 05:54 Installation of Tableau 06:46 Tableau Interface 10:48 [Demo: Dimensions and Measures] 15:38 Visualization - Chart - Average by Region 01:00:53 Donut Chart - Pie Chart 01:12:08 Dashboards- Worksheets 01:25:32 Dashboards -Sales 01:40:12 Profit version of the dashboard 01:53:54 Linking overall dashboard to sales dashboard 02:02:15 Segment Dashboard 02:06:48 Top Customers by Sales 02:14:50 Difference between live connection and extract connection 02:32:29 Actions in Tableau - Sales by Category Stacked 02:44:23 Reference Bands and Lines 02:54:58 Analysis -Delays: Profit Waterfall 03:08:46 Population Dashboard 03:32:48 Health Dashboard 03:53:57 Economy Dashboard 04:07:02 Dashboard - Ease of Business 04:28:24 What is Tableau? 04:29:01 Why is it important? 04:30:09 Joins 04:32:49 Dimensions & Measures 04:33:19 Dashboard Designing 04:44:18 Win percent based on Toss Decision 04:55:04 Dashboard - Batsman Performance 05:56:45 Dashboard -Bowler Performance 06:29:07 What are the different joins in Tableau? 06:30:49 What is the difference between Join and Blending? 06:32:59 What is the difference b/w Live and Extract? 07:02:00 Find the customer with the lowest overall profit. What is his/her profit ratio? 07:03:33 What is the Rank function in Tableau? 07:07:42 How can you embed a webpage in a dashboard? 07:22:57 How can you schedule a workbook in Tableau after publishing it? Dataset Link - https://drive.google.com/drive/folders/18BFipLUm5pUcsjmjDKGg2dBR_I6mZzPX To learn more about Tableau, subscribe to our YouTube channel: https://www.youtube.com/user/Simplilearn?sub_confirmation=1 Watch more videos on Tableau Training: https://www.youtube.com/watch?v=YlSuzn8WvgM&list=PLEiEAq2VkUUJEvrsey26P-Bj4Vk6BLBVC #Tableau #TableauTraining #TableauCertification #TableauDeskTop10 #BusinessAnalytics #DataScience #Simplilearn ➡️ About Caltech Post Graduate Program In Data Science This Post Graduation in Data Science leverages the superiority of Caltech's academic eminence. The Data Science program covers critical Data Science topics like Python programming, R programming, Machine Learning, Deep Learning, and Data Visualization tools through an interactive learning model with live sessions by global practitioners and practical labs. ✅ Key Features - Simplilearn's JobAssist helps you get noticed by top hiring companies - Caltech PG program in Data Science completion certificate - Earn up to 14 CEUs from Caltech CTME - 25+ hands-on projects from the likes of Amazon, Walmart, Uber, and many more - 8X higher interaction in live online classes by industry experts ✅ Skills Covered - Exploratory Data Analysis - Descriptive Statistics - Inferential Statistics - Model Building and Fine Tuning - Data Visualization 👉 Learn More At: https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=GoogleDataStudio-zieh2hr1toQ&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'Tableau For Data Science 2022 | Tableau For Data Visualization | Tableau Tutorial | Simplilearn', 'heatmap': [{'end': 4006.072, 'start': 3200.118, 'weight': 0.763}, {'end': 26677.295, 'start': 26418.722, 'weight': 0.709}], 'summary': 'This tableau tutorial covers basic concepts, benefits, and installation, data visualization, dashboard tips, design, visualization techniques, ranking options, actions, data analysis, and business analysis. it includes creating various visualizations, dashboards, and analyzing cricket match data, providing insights into sales, profit, gdp, and healthcare data.', 'chapters': [{'end': 98.37, 'segs': [{'end': 50.273, 'src': 'embed', 'start': 21.898, 'weight': 2, 'content': [{'end': 27.183, 'text': 'then focus on use cases and how you can work on the platform to get the hands-on experience you need.', 'start': 21.898, 'duration': 5.285}, {'end': 32.731, 'text': "Then we'll take you through 30 important interview questions that you might face in a Tableau interview.", 'start': 27.941, 'duration': 4.79}, {'end': 39.204, 'text': 'Before we begin, make sure you subscribe to our channel and click on the bell icon to never miss an update from Simply Learn.', 'start': 33.412, 'duration': 5.792}, {'end': 42.311, 'text': 'Hello and welcome to Tableau Training for Beginners.', 'start': 39.77, 'duration': 2.541}, {'end': 45.332, 'text': "My name is Michelle Covine and I'm with the Simply Learn team.", 'start': 42.711, 'duration': 2.621}, {'end': 50.273, 'text': "Today we'll be talking about all the things you need to know to get started with Tableau.", 'start': 45.952, 'duration': 4.321}], 'summary': 'Tableau training covers use cases, 30 interview questions, and basics for beginners.', 'duration': 28.375, 'max_score': 21.898, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo21898.jpg'}, {'end': 108.877, 'src': 'embed', 'start': 81.363, 'weight': 0, 'content': [{'end': 85.524, 'text': 'When you have a question about what your customers are feeling, what your customers are doing,', 'start': 81.363, 'duration': 4.161}, {'end': 88.845, 'text': "who the customers are and what's the best channel to target them.", 'start': 85.524, 'duration': 3.321}, {'end': 94.307, 'text': 'business intelligence is a method of transforming your data into these insights and measurable metrics.', 'start': 88.845, 'duration': 5.462}, {'end': 98.37, 'text': 'Business intelligence tools are designed to make the data flow manageable.', 'start': 94.747, 'duration': 3.623}, {'end': 105.835, 'text': 'In the age of information, Tableau is one of many tools to help manage the data flow and turn data into actionable information.', 'start': 99.01, 'duration': 6.825}, {'end': 108.877, 'text': 'We also have Qlik and SAP and Oracle.', 'start': 106.295, 'duration': 2.582}], 'summary': 'Business intelligence tools like tableau, qlik, sap, and oracle help transform data into actionable insights and measurable metrics.', 'duration': 27.514, 'max_score': 81.363, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo81363.jpg'}], 'start': 5.185, 'title': 'Tableau for beginners', 'summary': 'Introduces tableau as a key tool for visualizing and understanding large amounts of data, covering basic concepts, use cases, and important interview questions, emphasizing its role in transforming data into actionable insights for businesses.', 'chapters': [{'end': 98.37, 'start': 5.185, 'title': 'Tableau tutorial for beginners', 'summary': 'Introduces tableau as a key tool for visualizing and understanding large amounts of data, covering basic concepts, use cases, and important interview questions, emphasizing its role in transforming data into actionable insights for businesses.', 'duration': 93.185, 'highlights': ['Business intelligence technologies are used by companies to collect, analyze, and present data in order to create actionable information.', 'Businesses seek insights about their customers, products, and services to answer questions such as customer satisfaction, customer retention, and product/service awareness.', 'Tableau tutorial covers basic concepts, use cases, and 30 important interview questions, providing a comprehensive understanding of the platform.']}], 'duration': 93.185, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5185.jpg', 'highlights': ['Tableau tutorial covers basic concepts, use cases, and 30 important interview questions, providing a comprehensive understanding of the platform.', 'Business intelligence technologies are used by companies to collect, analyze, and present data in order to create actionable information.', 'Businesses seek insights about their customers, products, and services to answer questions such as customer satisfaction, customer retention, and product/service awareness.']}, {'end': 869.764, 'segs': [{'end': 291.492, 'src': 'embed', 'start': 247.391, 'weight': 0, 'content': [{'end': 250.773, 'text': 'And then we also want to look at quantity and put that into values.', 'start': 247.391, 'duration': 3.382}, {'end': 257.418, 'text': "And it's automatically summing up sales and quantity but you can choose if you want it to be sum or not.", 'start': 251.174, 'duration': 6.244}, {'end': 264.843, 'text': "And then we'll take our values and put it on rows so that we can see sales and quantity one on top of the other.", 'start': 257.858, 'duration': 6.985}, {'end': 267.465, 'text': "And that's the basics of a pivot chart.", 'start': 264.863, 'duration': 2.602}, {'end': 269.887, 'text': "Now let's do a similar thing in Tableau.", 'start': 267.525, 'duration': 2.362}, {'end': 278.081, 'text': 'Okay, so we have our connection to the data, and Tableau automatically splits out the dimensions from the measures.', 'start': 271.155, 'duration': 6.926}, {'end': 280.023, 'text': "We'll go into more depth on that later.", 'start': 278.201, 'duration': 1.822}, {'end': 287.529, 'text': 'But we can come and grab region and put it onto columns, and we get a similar thing, maybe a little nicer formatted.', 'start': 280.603, 'duration': 6.926}, {'end': 291.492, 'text': 'And then we can come and put quantity there.', 'start': 287.969, 'duration': 3.523}], 'summary': 'Using pivot charts, sales and quantity data can be visualized in tableau for analysis.', 'duration': 44.101, 'max_score': 247.391, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo247391.jpg'}, {'end': 364.462, 'src': 'embed', 'start': 342.449, 'weight': 7, 'content': [{'end': 351.234, '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.449, 'duration': 8.785}, {'end': 353.915, 'text': "Let's get started with the Tableau installation.", 'start': 351.754, 'duration': 2.161}, {'end': 359.478, '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.516, 'duration': 4.962}, {'end': 364.462, 'text': 'Here are some of the browsers you can use to install Tableau.', 'start': 361.319, 'duration': 3.143}], 'summary': 'Comparison of pivot tables in excel and tableau, with tableau installation requirements.', 'duration': 22.013, 'max_score': 342.449, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo342449.jpg'}], 'start': 99.01, 'title': 'Tableau benefits and installation', 'summary': 'Discusses the benefits of using tableau, including its ability to connect to 40 different data sources and build interactive dashboards with simple analytics. it also covers the installation process of tableau public, connecting to data sources, understanding dimensions and measures, and creating visualizations.', 'chapters': [{'end': 341.749, 'start': 99.01, 'title': 'Benefits of tableau as a business intelligence tool', 'summary': 'Discusses the benefits of using tableau, including its ability to connect to 40 different data sources, build interactive dashboards with simple analytics, and its leadership in the gartner magic quadrant for the last six years. it also provides an overview of the products offered by tableau.', 'duration': 242.739, 'highlights': ['Tableau can connect to 40 different data sources, providing direct access to data and increasing the likelihood of obtaining valuable insights.', 'It offers simple analytics such as trends and forecasting, enabling a deeper understanding of the data.', 'Tableau has been a leader in the Gartner Magic quadrant for six years, including 2018, showcasing its reliability and performance in the business intelligence market.', 'Tableau Public is a free version of Tableau Desktop that can support up to a million rows of data, providing a cost-effective solution for smaller-scale data analysis.', 'Tableau Online allows users to securely publish and share dashboards in the cloud, enhancing collaboration and accessibility to data-driven insights.', 'Tableau provides quick flexibility to turn text into visualizations, offering a user-friendly and efficient approach to data analysis and presentation.']}, {'end': 869.764, 'start': 342.449, 'title': 'Tableau public installation and data visualization', 'summary': 'Covers the installation process of tableau public, requirements for installation, connecting to data sources, understanding dimensions and measures, and creating visualizations in tableau public.', 'duration': 527.315, 'highlights': ['Connecting to Data Sources in Tableau Public The process of connecting to data sources in Tableau Public is explained, including how to choose an Excel file, preview the data, and classify fields such as geographical and date fields.', 'Understanding Dimensions and Measures in Tableau Public The distinction between dimensions and measures in Tableau Public is clarified, with dimensions containing qualitative data such as names and dates, while measures contain quantitative data that can be aggregated.', 'Visualizing Data in Tableau Public The process of visualizing data in Tableau Public is demonstrated, including how to create different types of visualizations, use dimensions and measures, and understand the concepts of discrete and continuous labels.', 'Tableau Public Installation and Requirements The requirements for installing Tableau Public on Windows and Mac systems are outlined, and the step-by-step process of downloading and installing Tableau Public is explained, including creating a Tableau Public account.']}], 'duration': 770.754, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo99010.jpg', 'highlights': ['Tableau can connect to 40 different data sources, providing direct access to data and increasing the likelihood of obtaining valuable insights.', 'Tableau offers simple analytics such as trends and forecasting, enabling a deeper understanding of the data.', 'Tableau has been a leader in the Gartner Magic quadrant for six years, including 2018, showcasing its reliability and performance in the business intelligence market.', 'Tableau Public is a free version of Tableau Desktop that can support up to a million rows of data, providing a cost-effective solution for smaller-scale data analysis.', 'Tableau Online allows users to securely publish and share dashboards in the cloud, enhancing collaboration and accessibility to data-driven insights.', 'Tableau provides quick flexibility to turn text into visualizations, offering a user-friendly and efficient approach to data analysis and presentation.', 'Connecting to Data Sources in Tableau Public The process of connecting to data sources in Tableau Public is explained, including how to choose an Excel file, preview the data, and classify fields such as geographical and date fields.', 'Understanding Dimensions and Measures in Tableau Public The distinction between dimensions and measures in Tableau Public is clarified, with dimensions containing qualitative data such as names and dates, while measures contain quantitative data that can be aggregated.', 'Visualizing Data in Tableau Public The process of visualizing data in Tableau Public is demonstrated, including how to create different types of visualizations, use dimensions and measures, and understand the concepts of discrete and continuous labels.', 'Tableau Public Installation and Requirements The requirements for installing Tableau Public on Windows and Mac systems are outlined, and the step-by-step process of downloading and installing Tableau Public is explained, including creating a Tableau Public account.']}, {'end': 2755.4, 'segs': [{'end': 992.057, 'src': 'embed', 'start': 927.709, 'weight': 0, 'content': [{'end': 933.191, 'text': "Now that we've had an overview of how Tableau works, let's go into a little more detail.", 'start': 927.709, 'duration': 5.482}, {'end': 937.674, 'text': 'Tableau is very much built on the premise of drag and drop.', 'start': 933.752, 'duration': 3.922}, {'end': 947.739, 'text': "So let's build a simple visualization and talk about what each of these shells and marks cards specifically do.", 'start': 938.374, 'duration': 9.365}, {'end': 952.742, 'text': "So we're going to make a simple chart, which is average sales by region.", 'start': 948.359, 'duration': 4.383}, {'end': 958.966, 'text': 'so we know we want sales on.', 'start': 953.422, 'duration': 5.544}, {'end': 961.248, 'text': "let's do sales on rows.", 'start': 958.966, 'duration': 2.282}, {'end': 972.057, 'text': "now, for rows and for metrics, since this is continuous, like we talked about before, it's making an axis for our sales.", 'start': 961.248, 'duration': 10.809}, {'end': 979.49, 'text': 'we also can drag region onto columns and it makes one column per region.', 'start': 972.057, 'duration': 7.433}, {'end': 981.651, 'text': "So that's how it works with dimensions.", 'start': 979.53, 'duration': 2.121}, {'end': 989.476, 'text': "If you pull a dimension onto columns, you're saying I want one blank per column.", 'start': 982.131, 'duration': 7.345}, {'end': 992.057, 'text': 'I want one region per column.', 'start': 989.896, 'duration': 2.161}], 'summary': 'Tableau allows drag and drop for creating visualizations; example includes average sales by region.', 'duration': 64.348, 'max_score': 927.709, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo927709.jpg'}, {'end': 1211.837, 'src': 'embed', 'start': 1191.322, 'weight': 3, 'content': [{'end': 1201.009, 'text': 'So we will right click on our sum of sales here in the rows, hover over measure, which right now is sum, and change it to average.', 'start': 1191.322, 'duration': 9.687}, {'end': 1203.931, 'text': 'And we have a different result here.', 'start': 1201.55, 'duration': 2.381}, {'end': 1211.837, 'text': "so let's sort again, and we can see that the south region actually has the highest average of sales, which was not the case for the sum.", 'start': 1203.931, 'duration': 7.906}], 'summary': 'Changed sum to average, revealing south region has highest average sales.', 'duration': 20.515, 'max_score': 1191.322, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo1191322.jpg'}, {'end': 1269.38, 'src': 'embed', 'start': 1241.123, 'weight': 2, 'content': [{'end': 1246.386, 'text': 'you can also choose to only show the minimum and the maximum.', 'start': 1241.123, 'duration': 5.263}, {'end': 1253.849, 'text': "this becomes handy on a line chart where you don't want all marks labeled, because it gets very messy,", 'start': 1246.386, 'duration': 7.463}, {'end': 1259.152, 'text': 'but you want the tallest and the shortest part to be labeled and maybe you just want the tallest.', 'start': 1253.849, 'duration': 5.303}, {'end': 1264.475, 'text': "so we'll click label minimum value and remove that checkbox and now we just have the tallest value there.", 'start': 1259.152, 'duration': 5.323}, {'end': 1269.38, 'text': "And one card that we haven't used yet is the filters card.", 'start': 1265.817, 'duration': 3.563}], 'summary': 'Line chart can display min and max values for clarity and focus.', 'duration': 28.257, 'max_score': 1241.123, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo1241123.jpg'}, {'end': 1791.36, 'src': 'embed', 'start': 1764.85, 'weight': 4, 'content': [{'end': 1769.293, 'text': 'Also up here we have our title which right now is the same name as our sheet.', 'start': 1764.85, 'duration': 4.443}, {'end': 1778.077, 'text': 'So if we rename the sheet to profit by subcategory, then it names the title up here.', 'start': 1770.475, 'duration': 7.602}, {'end': 1780.037, 'text': 'So this is making it look a little bit better.', 'start': 1778.097, 'duration': 1.94}, {'end': 1786.759, 'text': 'And then here we have profit and it shows it but without any like dollar signs.', 'start': 1780.057, 'duration': 6.702}, {'end': 1791.36, 'text': "So let's come up here to profit and click format.", 'start': 1787.279, 'duration': 4.081}], 'summary': 'Renaming sheet to profit by subcategory updates the title, making it look better. clicking format adds dollar signs to profit.', 'duration': 26.51, 'max_score': 1764.85, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo1764850.jpg'}], 'start': 870.264, 'title': 'Tableau data visualization and analysis', 'summary': 'Covers sorting data in tableau by quantity and sales, creating visualizations, adjusting colors, building scatter plots, analyzing sales data, and creating profit ratio visualizations, with a focus on techniques, features, and applications for effective data visualization and analysis.', 'chapters': [{'end': 961.248, 'start': 870.264, 'title': 'Tableau sorting and visualization', 'summary': 'Covers sorting data in tableau by quantity and sales, demonstrating how to sort descending by quantity to reveal the highest sales, and introduces the drag and drop feature for creating a simple visualization of average sales by region.', 'duration': 90.984, 'highlights': ['Demonstrated sorting data in Tableau by quantity and sales, showing that the highest sales occur when three items are purchased.', 'Introduced the drag and drop feature in Tableau for creating a simple visualization of average sales by region.']}, {'end': 1523.858, 'start': 961.248, 'title': 'Tableau data visualization basics', 'summary': 'Provides an overview of tableau data visualization basics, including techniques for creating visualizations, adjusting colors, sizes, labels, tooltips, filters, and changing the type of mark manually, as well as building scatter plots and utilizing the highlight feature.', 'duration': 562.61, 'highlights': ['Tableau has the benefit of having unlimited undos, allowing for easy adjustments and experimentation in the visualization process. Tableau provides unlimited undos, enabling users to easily adjust and experiment with visualizations.', 'The technique of using measures to determine the color and size in visualizations is demonstrated, showcasing the dynamic adjustments based on sales and profit data. The method of using measures to determine color and size in visualizations is showcased, illustrating dynamic adjustments based on sales and profit data.', 'The process of changing the type of mark manually to create different visualizations, such as bar charts and line charts, is explained, providing flexibility in visual representation. The explanation of manually changing the type of mark to create different visualizations, such as bar charts and line charts, offers flexibility in visual representation.', 'The concept of building a scatter plot and utilizing the detail feature to determine the level of visualization is described, highlighting the use of scatter plots for visualizing sales and discount data per order or product. The concept of building a scatter plot and utilizing the detail feature to determine the level of visualization is described, emphasizing the use of scatter plots for visualizing sales and discount data per order or product.', 'The utilization of the highlight feature in Tableau to isolate and visualize specific dimensions, such as furniture and technology categories, is demonstrated, showcasing the ability to focus on specific data subsets within visualizations. The demonstration of the highlight feature in Tableau to isolate and visualize specific dimensions, such as furniture and technology categories, showcases the ability to focus on specific data subsets within visualizations.']}, {'end': 2096.004, 'start': 1525.228, 'title': 'Tableau visualization and analysis', 'summary': 'Discusses using tableau for visualizing and analyzing sales data, including identifying top-selling products, profit by category and subcategory, formatting visualization, creating hierarchies, and enhancing visualization depth.', 'duration': 570.776, 'highlights': ['The advanced copier is the top-selling product with the highest sales, while office supplies binders have low sales despite being highly discounted.', 'The visualization demonstrates the profitability of different categories and subcategories, highlighting tables as the biggest drain on profit.', 'Formatting tips include rotating labels, renaming titles, formatting profit to currency, and hiding field labels for columns to improve visualization appearance and clarity.', 'The creation of hierarchies allows for detailed analysis by category, subcategory, and product name, enabling users to quickly drill down and filter data for specific insights.', 'Enhancing visualization depth involves incorporating sales data across regions and using color-coded squares to represent sales, making it easier for users to identify top-selling categories.']}, {'end': 2334.033, 'start': 2096.024, 'title': 'Tableau data analysis', 'summary': 'Discusses how to visualize sales data in tableau, highlighting the highest sales in the west and technology in the east, the use of hierarchies in dates for complex visualizations, and the application of calculated fields to create a profit ratio.', 'duration': 238.009, 'highlights': ['The West shows the highest sales, while technology dominates in the East, contributing to a drop in sales in quarter two of 2016.', 'Tableau allows complex visualizations through hierarchies built into dates, enabling quick comparison of sales data across different periods and categories.', "The use of calculated fields is demonstrated through the creation of a 'profit ratio' to analyze data more effectively."]}, {'end': 2755.4, 'start': 2334.373, 'title': 'Creating profit ratio visualization', 'summary': 'Explores creating a profit ratio visualization in tableau, demonstrating the difference between aggregated and unaggregated calculations, and showcasing the impact of various fields on the visualization, ultimately leading to the creation of a bar chart by profit ratio and sales per customer by region.', 'duration': 421.027, 'highlights': ['The chapter explores creating a profit ratio visualization in Tableau, demonstrating the difference between aggregated and unaggregated calculations. It covers the process of creating a profit ratio visualization, including the difference between aggregated and unaggregated calculations, providing a foundational understanding of the topic.', 'Demonstrates the impact of various fields on the visualization, ultimately leading to the creation of a bar chart by profit ratio and sales per customer by region. The demonstration showcases how different fields such as profit, sales, and region impact the visualization, leading to the creation of a bar chart by profit ratio and sales per customer by region, highlighting the practical application of the concepts.', 'Explains the process of creating specific calculated fields, such as total number of customers and sales per customer, to derive insights for decision-making. It explains the process of creating specific calculated fields, including total number of customers and sales per customer, providing insights for decision-making and analysis of customer and sales data.']}], 'duration': 1885.136, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo870264.jpg', 'highlights': ['Demonstrated sorting data in Tableau by quantity and sales, showing that the highest sales occur when three items are purchased.', 'Tableau has the benefit of having unlimited undos, allowing for easy adjustments and experimentation in the visualization process.', 'The technique of using measures to determine the color and size in visualizations is demonstrated, showcasing the dynamic adjustments based on sales and profit data.', 'The concept of building a scatter plot and utilizing the detail feature to determine the level of visualization is described, highlighting the use of scatter plots for visualizing sales and discount data per order or product.', 'The advanced copier is the top-selling product with the highest sales, while office supplies binders have low sales despite being highly discounted.', 'The visualization demonstrates the profitability of different categories and subcategories, highlighting tables as the biggest drain on profit.', 'The West shows the highest sales, while technology dominates in the East, contributing to a drop in sales in quarter two of 2016.', 'The chapter explores creating a profit ratio visualization in Tableau, demonstrating the difference between aggregated and unaggregated calculations.', 'Explains the process of creating specific calculated fields, such as total number of customers and sales per customer, to derive insights for decision-making.']}, {'end': 4161.765, 'segs': [{'end': 3042.518, 'src': 'embed', 'start': 3014.777, 'weight': 4, 'content': [{'end': 3019.921, 'text': "And let's double click on sales and it's going to put it into text.", 'start': 3014.777, 'duration': 5.144}, {'end': 3021.222, 'text': "And that's not what I want.", 'start': 3020.321, 'duration': 0.901}, {'end': 3025.826, 'text': "So let's take sales and drag it onto rows and it automatically makes a bar chart.", 'start': 3021.322, 'duration': 4.504}, {'end': 3032.131, 'text': 'So now we have one bar with the axis of sales for furniture, office supplies, and technology.', 'start': 3026.266, 'duration': 5.865}, {'end': 3038.115, 'text': "Now let's take profit and also put it on rows.", 'start': 3032.851, 'duration': 5.264}, {'end': 3042.518, 'text': 'So now we have two bar charts, one for sales and one for profit.', 'start': 3038.655, 'duration': 3.863}], 'summary': 'Visualization of sales and profit in bar charts for furniture, office supplies, and technology.', 'duration': 27.741, 'max_score': 3014.777, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo3014777.jpg'}, {'end': 4006.072, 'src': 'heatmap', 'start': 3177.488, 'weight': 10, 'content': [{'end': 3183.45, 'text': "So we'll go to the profit marks card and take profit onto color and do the same thing there.", 'start': 3177.488, 'duration': 5.962}, {'end': 3189.233, 'text': 'We have red, blue diverging, advanced, center is zero.', 'start': 3184.05, 'duration': 5.183}, {'end': 3193.494, 'text': "Great So now if it's negative, it will be there.", 'start': 3189.673, 'duration': 3.821}, {'end': 3194.635, 'text': "So let's sort this.", 'start': 3193.734, 'duration': 0.901}, {'end': 3196.176, 'text': 'by profit.', 'start': 3195.555, 'duration': 0.621}, {'end': 3199.878, 'text': 'And so both of them have sorted with profit in mind.', 'start': 3196.716, 'duration': 3.162}, {'end': 3204.542, 'text': 'And we can easily see our subcategories that have a negative profit.', 'start': 3200.118, 'duration': 4.424}, {'end': 3208.364, 'text': "Rename this, and we'll call it our details sheet.", 'start': 3205.402, 'duration': 2.962}, {'end': 3214.469, 'text': 'So now we have these four visualizations that all have to do with similar information.', 'start': 3208.985, 'duration': 5.484}, {'end': 3217.759, 'text': 'I think I want these bigger on the states.', 'start': 3215.478, 'duration': 2.281}, {'end': 3219.54, 'text': "So we'll just keep making that bigger.", 'start': 3218.119, 'duration': 1.421}, {'end': 3223.282, 'text': "Perfect Now we're going to make our first dashboard.", 'start': 3219.84, 'duration': 3.442}, {'end': 3230.485, 'text': 'So for our dashboard we have information over here that shows you what sheets you can bring on.', 'start': 3223.702, 'duration': 6.783}, {'end': 3236.148, 'text': "These get a little bit more complex so they'll be covered in more in depth type of videos.", 'start': 3230.706, 'duration': 5.442}, {'end': 3238.609, 'text': 'And then we have our size.', 'start': 3236.528, 'duration': 2.081}, {'end': 3245.936, 'text': "We could make a range of sizes based on maybe what you're viewing this on.", 'start': 3239.85, 'duration': 6.086}, {'end': 3248.898, 'text': "But we're just going to change it to a fixed size.", 'start': 3246.236, 'duration': 2.662}, {'end': 3254.163, 'text': "And we're going to make it 1400 by 1000.", 'start': 3249.859, 'duration': 4.304}, {'end': 3258.407, 'text': 'And this is our dashboard size.', 'start': 3254.163, 'duration': 4.244}, {'end': 3261.87, 'text': "So let's bring on sales profit by region.", 'start': 3258.627, 'duration': 3.243}, {'end': 3263.732, 'text': 'Sales and profit by state.', 'start': 3262.391, 'duration': 1.341}, {'end': 3270.056, 'text': 'Now a map needs a little bit more horizontal space than region does.', 'start': 3264.873, 'duration': 5.183}, {'end': 3276.741, 'text': "Let's bring sales and profit by category underneath the region and the detail underneath the state.", 'start': 3270.477, 'duration': 6.264}, {'end': 3278.722, 'text': 'Give our map more space again.', 'start': 3277.241, 'duration': 1.481}, {'end': 3285.128, 'text': 'Perfect Now Tableau has this neat feature called uses filter.', 'start': 3279.326, 'duration': 5.802}, {'end': 3293.751, '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.508, 'duration': 8.243}, {'end': 3299.613, 'text': 'So if I just want to look at the south and I click on south it zooms in to all my south states.', 'start': 3294.091, 'duration': 5.522}, {'end': 3306.216, 'text': 'Now my categories have updated to be just the south ones and my details have updated as well.', 'start': 3299.894, 'duration': 6.322}, {'end': 3315.322, 'text': 'So we could see that Central has pretty big sales, you know, bigger than the South, but the profit is lower than the South.', 'start': 3306.696, 'duration': 8.626}, {'end': 3318.324, 'text': 'So we can click on Central and focus on Central.', 'start': 3315.723, 'duration': 2.601}, {'end': 3324.168, 'text': "Let's use that uses filter on all three of these.", 'start': 3319.245, 'duration': 4.923}, {'end': 3326.961, 'text': 'dashboards that lead us up to the detail.', 'start': 3325, 'duration': 1.961}, {'end': 3335.807, 'text': "So building a quick dashboard like this let's make this taller would allow you to do some sort of analysis such as let's take a look at Central,", 'start': 3327.242, 'duration': 8.565}, {'end': 3338.749, 'text': 'because they have relatively high profits but low sales.', 'start': 3335.807, 'duration': 2.942}, {'end': 3343.272, 'text': 'So we click on Central and then we see, oh man, Texas is having a really hard time.', 'start': 3338.889, 'duration': 4.383}, {'end': 3350.317, 'text': "So let's click on Texas and now we're seeing in Texas that we have negative profit in these categories.", 'start': 3343.332, 'duration': 6.985}, {'end': 3354.7, 'text': 'So we can control click on furniture and office supplies.', 'start': 3350.617, 'duration': 4.083}, {'end': 3360.984, 'text': 'And we can see all of our products that are really just killing us in Texas, all of our subcategories.', 'start': 3355.24, 'duration': 5.744}, {'end': 3364.466, 'text': "And if we want to go deeper into products, we'll just click that plus sign.", 'start': 3361.144, 'duration': 3.322}, {'end': 3366.087, 'text': 'And now we see all the products.', 'start': 3364.706, 'duration': 1.381}, {'end': 3367.448, 'text': "And we'll sort again.", 'start': 3366.107, 'duration': 1.341}, {'end': 3373.051, 'text': 'And we can see all the products by subcategory that are really just killing us.', 'start': 3367.468, 'duration': 5.583}, {'end': 3376.883, 'text': 'and are maybe not worthwhile to make anymore.', 'start': 3374.222, 'duration': 2.661}, {'end': 3384.106, 'text': "So we're going to have to reconsider making the 3.6 cubic foot counter height office refrigerator, at least for Texas.", 'start': 3377.183, 'duration': 6.923}, {'end': 3385.486, 'text': "It's not very helpful there.", 'start': 3384.306, 'duration': 1.18}, {'end': 3389.928, 'text': 'And then, when you back out of that subcategory section,', 'start': 3385.907, 'duration': 4.021}, {'end': 3402.477, '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': 3389.928, 'duration': 12.549}, {'end': 3406.62, 'text': "Now let's move on and take a look on how to create parameters and sets.", 'start': 3402.817, 'duration': 3.803}, {'end': 3413.966, 'text': "So new sheet and let's make a quick visualization that will apply our parameters and our sets to.", 'start': 3407.12, 'duration': 6.846}, {'end': 3423.242, '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.475, 'duration': 7.767}, {'end': 3431.989, '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.582, 'duration': 8.407}, {'end': 3434.551, 'text': 'how many of our top customers that they want to see.', 'start': 3431.989, 'duration': 2.562}, {'end': 3443.859, 'text': "So let's click this down arrow and click create parameter and we will name it top and customers.", 'start': 3435.332, 'duration': 8.527}, {'end': 3454.161, 'text': "Great We're going to make it an integer and we're going to give them the option to choose the number of customers within a range.", 'start': 3446.428, 'duration': 7.733}, {'end': 3461.553, 'text': "Our low is going to be 5, so we'll let them see 5 or up to 20.", 'start': 3454.682, 'duration': 6.871}, {'end': 3465.036, 'text': "and we're going to let them skip with step size of five.", 'start': 3461.553, 'duration': 3.483}, {'end': 3469.88, 'text': "Let's start their current value right in the middle with 10.", 'start': 3465.336, 'duration': 4.544}, {'end': 3474.424, 'text': 'Okay, so now if you want to see how this parameter looks, you can come down to parameters.', 'start': 3469.88, 'duration': 4.544}, {'end': 3480.089, 'text': 'Before we only had dimensions and measures on the left side of our Tableau workspace,', 'start': 3474.904, 'duration': 5.185}, {'end': 3483.271, 'text': "but now we have parameters that it's appeared once we create a parameter.", 'start': 3480.089, 'duration': 3.182}, {'end': 3488.856, 'text': 'We can right click on that parameter and click show parameter control, and we can see our top end customers.', 'start': 3483.531, 'duration': 5.325}, {'end': 3493.737, 'text': "Right now our parameter control isn't built into any of our visualizations, but you can see how it works.", 'start': 3489.116, 'duration': 4.621}, {'end': 3501.219, 'text': 'We allow them to go down to five and up to 20 with steps of five.', 'start': 3493.957, 'duration': 7.262}, {'end': 3504.32, 'text': "Great Now we're going to create a set.", 'start': 3501.859, 'duration': 2.461}, {'end': 3510.801, 'text': 'A set is a custom field that defines a subset of data based on some conditions.', 'start': 3504.8, 'duration': 6.001}, {'end': 3515.502, 'text': "So the set we're going to build is going to be based on customer name.", 'start': 3511.181, 'duration': 4.321}, {'end': 3521.824, 'text': 'So when you right click on customer name, you can come down and click create, hover on create and create a set.', 'start': 3515.762, 'duration': 6.062}, {'end': 3523.024, 'text': 'With so far.', 'start': 3522.264, 'duration': 0.76}, {'end': 3531.326, 'text': 'when we created a parameter and a calculated field, you clicked here with this down arrow and you saw create calculated field and create parameter,', 'start': 3523.024, 'duration': 8.302}, {'end': 3532.106, 'text': "but it's not there.", 'start': 3531.326, 'duration': 0.78}, {'end': 3539.747, 'text': 'A set has to be based on an existing field so you come and you click on the field you want it to be based on and then hover on create and you see set.', 'start': 3532.366, 'duration': 7.381}, {'end': 3542.188, 'text': "So here's how we can create a set.", 'start': 3540.608, 'duration': 1.58}, {'end': 3549.593, 'text': "Let's name it Top N Customers by sales.", 'start': 3542.608, 'duration': 6.985}, {'end': 3556.74, 'text': "So we're going to allow them to select the top end customers and have that select our top customers by sales.", 'start': 3550.074, 'duration': 6.666}, {'end': 3565.53, 'text': 'So we want this set to include anything that is in the top however many they define by the parameter by sales.', 'start': 3557.281, 'duration': 8.249}, {'end': 3570.088, 'text': 'So you can come over here to top and change it to by field.', 'start': 3565.91, 'duration': 4.178}, {'end': 3573.592, 'text': 'We want it to be top, but not just top static 10.', 'start': 3570.508, 'duration': 3.084}, {'end': 3576.757, 'text': "We're going to click here and our parameter shows up.", 'start': 3573.592, 'duration': 3.165}, {'end': 3579.34, 'text': "So it's going to be top, top end customers.", 'start': 3577.037, 'duration': 2.303}, {'end': 3586.433, 'text': "And then you can choose another field here for it to be defined by and it's sales.", 'start': 3580.387, 'duration': 6.046}, {'end': 3588.555, 'text': 'And we want it to be by sum of sales.', 'start': 3586.894, 'duration': 1.661}, {'end': 3595.983, '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.256, 'duration': 6.727}, {'end': 3600.147, 'text': 'And now we would see our top end customers by average profit.', 'start': 3596.043, 'duration': 4.104}, {'end': 3602.95, 'text': 'But we want sales and sum.', 'start': 3600.908, 'duration': 2.042}, {'end': 3608.554, 'text': "Okay, so we've created our set, and we can drag it onto rows to see how it works.", 'start': 3603.85, 'duration': 4.704}, {'end': 3613.878, 'text': 'And we can see these are our top 10 customers by their sales.', 'start': 3609.234, 'duration': 4.644}, {'end': 3618.822, 'text': "And we have this in slash out that's generated by our set.", 'start': 3614.498, 'duration': 4.324}, {'end': 3625.427, 'text': "So if we take our set, first let's see how this line moves when we change our number here.", 'start': 3619.122, 'duration': 6.305}, {'end': 3626.988, 'text': "So right now it's 10.", 'start': 3625.567, 'duration': 1.421}, {'end': 3631.468, 'text': 'When we move it up, we see our line moves down to include the top 15.', 'start': 3626.988, 'duration': 4.48}, {'end': 3633.69, 'text': 'and now we can quickly see our top 20.', 'start': 3631.468, 'duration': 2.222}, {'end': 3638.655, 'text': "We'll go back to 10 and let's grab the set and drag it onto our filters.", 'start': 3633.69, 'duration': 4.965}, {'end': 3642.859, 'text': 'So now we have filtered the data down to our top 10.', 'start': 3639.155, 'duration': 3.704}, {'end': 3644.721, 'text': 'If this were applied to a dashboard,', 'start': 3642.859, 'duration': 1.862}, {'end': 3652.288, '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.721, 'duration': 7.567}, {'end': 3655.609, 'text': "Now let's move on to creating a donut chart.", 'start': 3652.688, 'duration': 2.921}, {'end': 3661.992, 'text': 'So a donut chart is basically a pie chart with a white center.', 'start': 3656.169, 'duration': 5.823}, {'end': 3668.815, 'text': "So let's start by building a pie chart, which in Tableau is pretty easy, especially if you use Show Me.", 'start': 3662.272, 'duration': 6.543}, {'end': 3675.423, 'text': "So let's create a pie chart for each category by sales.", 'start': 3669.115, 'duration': 6.308}, {'end': 3680.425, 'text': "So we're gonna click category and then we're gonna control click sales so we have them both selected.", 'start': 3675.543, 'duration': 4.882}, {'end': 3683.547, 'text': "We'll come over to show me and click pie.", 'start': 3680.625, 'duration': 2.922}, {'end': 3686.148, 'text': 'And there we have our pie chart.', 'start': 3684.007, 'duration': 2.141}, {'end': 3687.529, 'text': "We'll close show me.", 'start': 3686.528, 'duration': 1.001}, {'end': 3693.612, 'text': "Let's come up here and click entire view so we see our pie very clearly here.", 'start': 3687.649, 'duration': 5.963}, {'end': 3700.896, 'text': 'If we wanted to have one pie for each region, we can take region and drag that onto columns.', 'start': 3693.892, 'duration': 7.004}, {'end': 3705.457, 'text': 'So we have one column for each region and then one pi for each of them.', 'start': 3701.576, 'duration': 3.881}, {'end': 3711.779, 'text': 'You can see that the pi varies in size based on sales as well as the angle is for sales.', 'start': 3705.777, 'duration': 6.002}, {'end': 3715.921, 'text': 'So East has more sales in general than South.', 'start': 3712.16, 'duration': 3.761}, {'end': 3722.962, 'text': 'And this helps you to see that technology has smaller sales in the south than it does in the east.', 'start': 3716.661, 'duration': 6.301}, {'end': 3731.964, '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.443, 'duration': 8.521}, {'end': 3733.985, 'text': "by whatever measure you're using.", 'start': 3731.964, 'duration': 2.021}, {'end': 3738.106, 'text': "But for our purposes for donut charts, we're going to want them to all be the same size.", 'start': 3734.305, 'duration': 3.801}, {'end': 3743.867, 'text': 'So we took sales off of size and now we have all of our pie charts the same size.', 'start': 3738.526, 'duration': 5.341}, {'end': 3751.31, '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': 3744.107, 'duration': 7.203}, {'end': 3760.813, '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.57, 'duration': 9.243}, {'end': 3769.376, '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.813, 'duration': 8.563}, {'end': 3773.858, 'text': "And now we're going to make a second number of records by minimum.", 'start': 3769.716, 'duration': 4.142}, {'end': 3780.322, 'text': 'And we can do that by doing those steps again by dragging number of records up here and changing it to minimum again.', 'start': 3774.158, 'duration': 6.164}, {'end': 3788.226, 'text': 'Or a quick trick that I can show you is if you want to duplicate anything you have on the chart here,', 'start': 3781.042, 'duration': 7.184}, {'end': 3792.729, 'text': 'you can just hit control and then click and drag it and it will duplicate it.', 'start': 3788.226, 'duration': 4.503}, {'end': 3801.673, 'text': 'So if you wanted your number of records to also be down here onto your details or on your labels, you can control click it and then leave it there.', 'start': 3793.109, 'duration': 8.564}, {'end': 3810.878, 'text': 'Great, so now we have our two axes and we have our two marks cards that each affect their own set of visualizations.', 'start': 3801.954, 'duration': 8.924}, {'end': 3817.162, 'text': "So let's go to this top one affects these, so let's show that by changing the size.", 'start': 3811.098, 'duration': 6.064}, {'end': 3819.643, 'text': "And it's made these bigger.", 'start': 3818.683, 'duration': 0.96}, {'end': 3822.104, 'text': 'And this bottom one affects these.', 'start': 3819.663, 'duration': 2.441}, {'end': 3824.984, 'text': "And we'll do that by changing it to circle.", 'start': 3822.524, 'duration': 2.46}, {'end': 3827.064, 'text': 'So now each of these are a circle.', 'start': 3825.544, 'duration': 1.52}, {'end': 3829.365, 'text': "Let's take category off of color.", 'start': 3827.504, 'duration': 1.861}, {'end': 3832.145, 'text': 'And we can take sum of sales off of detail.', 'start': 3829.665, 'duration': 2.48}, {'end': 3834.326, 'text': "And let's change the color to white.", 'start': 3832.165, 'duration': 2.161}, {'end': 3837.886, 'text': "And now we're going to put this white circle on top of our pie chart.", 'start': 3835.086, 'duration': 2.8}, {'end': 3839.947, 'text': 'By clicking here on our second measure.', 'start': 3838.026, 'duration': 1.921}, {'end': 3841.887, 'text': 'And clicking dual axis.', 'start': 3840.627, 'duration': 1.26}, {'end': 3844.807, 'text': "And now it's got them lined up one on top of the other.", 'start': 3842.487, 'duration': 2.32}, {'end': 3846.308, 'text': 'And we have our donut chart.', 'start': 3844.827, 'duration': 1.481}, {'end': 3847.568, 'text': 'So we want our donut.', 'start': 3846.588, 'duration': 0.98}, {'end': 3850.322, 'text': 'slices to be a little thinner.', 'start': 3848.536, 'duration': 1.786}, {'end': 3853.391, 'text': 'We can change the size of our inner circle and make it bigger.', 'start': 3850.502, 'duration': 2.889}, {'end': 3860.567, 'text': 'Perfect And so now we have one pie chart for each region, one donut chart for each region.', 'start': 3854.582, 'duration': 5.985}, {'end': 3871.916, 'text': 'And if we wanted to take this header and put it inside of our pie chart, what we can do is take region and put it on the label for the circle.', 'start': 3860.947, 'duration': 10.969}, {'end': 3873.477, 'text': "And it's putting it down here.", 'start': 3872.296, 'duration': 1.181}, {'end': 3878.241, 'text': 'You can come and edit that by clicking on label and changing its alignment.', 'start': 3874.037, 'duration': 4.204}, {'end': 3880.422, 'text': "So let's put it in the middle.", 'start': 3878.761, 'duration': 1.661}, {'end': 3885.804, 'text': "Perfect, so now we can see our header here, so we don't need it down here anymore.", 'start': 3881.463, 'duration': 4.341}, {'end': 3890.206, 'text': 'You can right click and click Show Header, and it hides that header.', 'start': 3886.184, 'duration': 4.022}, {'end': 3897.648, 'text': "We also don't want to see our labels for our axes, so we right click and click Show Header there, and now we just see our pies.", 'start': 3890.286, 'duration': 7.362}, {'end': 3911.472, 'text': "So to get how the number of sales here for each of them, let's go to remember our pie marks card and let's take our sales and add it to label.", 'start': 3898.348, 'duration': 13.124}, {'end': 3916.294, 'text': 'So now each of our slices of pie can tell you how much sales they have.', 'start': 3911.832, 'duration': 4.462}, {'end': 3920.995, 'text': "If you take the sales here that's on label, right click and click format.", 'start': 3916.594, 'duration': 4.401}, {'end': 3925.997, 'text': "We can change that to currency and let's get rid of our decimal places.", 'start': 3921.315, 'duration': 4.682}, {'end': 3929.687, 'text': 'Perfect, now close formatting.', 'start': 3927.585, 'duration': 2.102}, {'end': 3934.371, 'text': "And let's say we want the total amount of sales to be in the middle here with central.", 'start': 3930.167, 'duration': 4.204}, {'end': 3939.895, 'text': 'So we go back to affecting our circle, grab sales, drag it to label.', 'start': 3934.771, 'duration': 5.124}, {'end': 3950.564, 'text': 'So now we have four donut charts, formatted to allow us to quickly see the sales numbers for each segment and also for the donut as a whole.', 'start': 3940.716, 'duration': 9.848}, {'end': 3959.311, 'text': 'You can also change the colors that Tableau selects for each slice by coming to the marks card that has color for the pie,', 'start': 3950.844, 'duration': 8.467}, {'end': 3961.893, 'text': 'so category color and clicking edit colors.', 'start': 3959.311, 'duration': 2.582}, {'end': 3968.442, 'text': 'You could change it to any of these automatic ones, where, if you double-click on one,', 'start': 3962.374, 'duration': 6.068}, {'end': 3972.486, 'text': 'it gives you all of the options for colors that you could possibly want.', 'start': 3968.442, 'duration': 4.044}, {'end': 3975.349, 'text': "There's also several different palettes you could choose from.", 'start': 3972.706, 'duration': 2.643}, {'end': 3981.055, 'text': "So let's say we like this one, and you can just click Assign Palette, and it will grab those off of there.", 'start': 3975.369, 'duration': 5.686}, {'end': 3985.28, 'text': "Those look very similar to what we have already, so I'm going to pick a different one.", 'start': 3981.095, 'duration': 4.185}, {'end': 3988.964, 'text': 'And click Assign Palette, click Apply.', 'start': 3986.821, 'duration': 2.143}, {'end': 3997.488, 'text': 'And this allows you to make some color changes to fit your business a little bit more specifically.', 'start': 3991.084, 'duration': 6.404}, {'end': 4002.39, 'text': "Perfect Let's say we make our pies bigger.", 'start': 3998.048, 'duration': 4.342}, {'end': 4006.072, 'text': 'Increase that size.', 'start': 4002.41, 'duration': 3.662}], 'summary': 'Creating visualizations, dashboards, parameters, and sets in tableau for data analysis and insight.', 'duration': 27.054, 'max_score': 3177.488, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo3177488.jpg'}, {'end': 3293.751, 'src': 'embed', 'start': 3264.873, 'weight': 1, 'content': [{'end': 3270.056, 'text': 'Now a map needs a little bit more horizontal space than region does.', 'start': 3264.873, 'duration': 5.183}, {'end': 3276.741, 'text': "Let's bring sales and profit by category underneath the region and the detail underneath the state.", 'start': 3270.477, 'duration': 6.264}, {'end': 3278.722, 'text': 'Give our map more space again.', 'start': 3277.241, 'duration': 1.481}, {'end': 3285.128, 'text': 'Perfect Now Tableau has this neat feature called uses filter.', 'start': 3279.326, 'duration': 5.802}, {'end': 3293.751, '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.508, 'duration': 8.243}], 'summary': 'Map needs more space than region, sales and profit by category under region, detail under state, and tableau uses filter feature for dashboard filtering.', 'duration': 28.878, 'max_score': 3264.873, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo3264873.jpg'}, {'end': 3367.448, 'src': 'embed', 'start': 3343.332, 'weight': 0, 'content': [{'end': 3350.317, 'text': "So let's click on Texas and now we're seeing in Texas that we have negative profit in these categories.", 'start': 3343.332, 'duration': 6.985}, {'end': 3354.7, 'text': 'So we can control click on furniture and office supplies.', 'start': 3350.617, 'duration': 4.083}, {'end': 3360.984, 'text': 'And we can see all of our products that are really just killing us in Texas, all of our subcategories.', 'start': 3355.24, 'duration': 5.744}, {'end': 3364.466, 'text': "And if we want to go deeper into products, we'll just click that plus sign.", 'start': 3361.144, 'duration': 3.322}, {'end': 3366.087, 'text': 'And now we see all the products.', 'start': 3364.706, 'duration': 1.381}, {'end': 3367.448, 'text': "And we'll sort again.", 'start': 3366.107, 'duration': 1.341}], 'summary': 'Analyzing texas data reveals negative profit in furniture and office supplies, prompting further investigation.', 'duration': 24.116, 'max_score': 3343.332, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo3343332.jpg'}, {'end': 3860.567, 'src': 'embed', 'start': 3829.665, 'weight': 3, 'content': [{'end': 3832.145, 'text': 'And we can take sum of sales off of detail.', 'start': 3829.665, 'duration': 2.48}, {'end': 3834.326, 'text': "And let's change the color to white.", 'start': 3832.165, 'duration': 2.161}, {'end': 3837.886, 'text': "And now we're going to put this white circle on top of our pie chart.", 'start': 3835.086, 'duration': 2.8}, {'end': 3839.947, 'text': 'By clicking here on our second measure.', 'start': 3838.026, 'duration': 1.921}, {'end': 3841.887, 'text': 'And clicking dual axis.', 'start': 3840.627, 'duration': 1.26}, {'end': 3844.807, 'text': "And now it's got them lined up one on top of the other.", 'start': 3842.487, 'duration': 2.32}, {'end': 3846.308, 'text': 'And we have our donut chart.', 'start': 3844.827, 'duration': 1.481}, {'end': 3847.568, 'text': 'So we want our donut.', 'start': 3846.588, 'duration': 0.98}, {'end': 3850.322, 'text': 'slices to be a little thinner.', 'start': 3848.536, 'duration': 1.786}, {'end': 3853.391, 'text': 'We can change the size of our inner circle and make it bigger.', 'start': 3850.502, 'duration': 2.889}, {'end': 3860.567, 'text': 'Perfect And so now we have one pie chart for each region, one donut chart for each region.', 'start': 3854.582, 'duration': 5.985}], 'summary': 'Creating pie and donut charts for sales with dual axis, and adjusting sizes for each region.', 'duration': 30.902, 'max_score': 3829.665, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo3829665.jpg'}, {'end': 3959.311, 'src': 'embed', 'start': 3930.167, 'weight': 6, 'content': [{'end': 3934.371, 'text': "And let's say we want the total amount of sales to be in the middle here with central.", 'start': 3930.167, 'duration': 4.204}, {'end': 3939.895, 'text': 'So we go back to affecting our circle, grab sales, drag it to label.', 'start': 3934.771, 'duration': 5.124}, {'end': 3950.564, 'text': 'So now we have four donut charts, formatted to allow us to quickly see the sales numbers for each segment and also for the donut as a whole.', 'start': 3940.716, 'duration': 9.848}, {'end': 3959.311, 'text': 'You can also change the colors that Tableau selects for each slice by coming to the marks card that has color for the pie,', 'start': 3950.844, 'duration': 8.467}], 'summary': 'Using tableau, create four donut charts to visualize sales data for each segment and as a whole.', 'duration': 29.144, 'max_score': 3930.167, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo3930167.jpg'}, {'end': 4006.072, 'src': 'embed', 'start': 3975.369, 'weight': 7, 'content': [{'end': 3981.055, 'text': "So let's say we like this one, and you can just click Assign Palette, and it will grab those off of there.", 'start': 3975.369, 'duration': 5.686}, {'end': 3985.28, 'text': "Those look very similar to what we have already, so I'm going to pick a different one.", 'start': 3981.095, 'duration': 4.185}, {'end': 3988.964, 'text': 'And click Assign Palette, click Apply.', 'start': 3986.821, 'duration': 2.143}, {'end': 3997.488, 'text': 'And this allows you to make some color changes to fit your business a little bit more specifically.', 'start': 3991.084, 'duration': 6.404}, {'end': 4002.39, 'text': "Perfect Let's say we make our pies bigger.", 'start': 3998.048, 'duration': 4.342}, {'end': 4006.072, 'text': 'Increase that size.', 'start': 4002.41, 'duration': 3.662}], 'summary': 'Demonstrates how to assign and apply color palettes for business customization, allowing for specific color changes and adjustments in size.', 'duration': 30.703, 'max_score': 3975.369, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo3975369.jpg'}, {'end': 4107.095, 'src': 'embed', 'start': 4056.95, 'weight': 2, 'content': [{'end': 4060.255, 'text': "And now we're going to create our dual axis again.", 'start': 4056.95, 'duration': 3.305}, {'end': 4065.864, 'text': 'So we grab number of records, put it on rows and see how it adds an axis,', 'start': 4060.336, 'duration': 5.528}, {'end': 4069.87, 'text': 'but each one of these categories has a different value for the number of records.', 'start': 4065.864, 'duration': 4.006}, {'end': 4077.176, 'text': 'However, they have the same minimum value for number of records and it puts them all back onto the same spot.', 'start': 4069.99, 'duration': 7.186}, {'end': 4082.659, 'text': 'Great And then we will control click and drag to make our two axes.', 'start': 4077.536, 'duration': 5.123}, {'end': 4086, 'text': "Let's come to our top one and make it bigger.", 'start': 4083.219, 'duration': 2.781}, {'end': 4091.443, 'text': 'That affected both of them because we still have sales on size.', 'start': 4086.02, 'duration': 5.423}, {'end': 4094.243, 'text': 'for both of them.', 'start': 4092.782, 'duration': 1.461}, {'end': 4099.648, 'text': 'so sales is affecting the size of the pie chart as well as the size of the angles.', 'start': 4094.243, 'duration': 5.405}, {'end': 4107.095, 'text': "so let's take sales off of size for both of them and make the second pie chart a little smaller, perfect.", 'start': 4099.648, 'duration': 7.447}], 'summary': 'Creating dual axis with different values for number of records and adjusting sales size for two pie charts.', 'duration': 50.145, 'max_score': 4056.95, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo4056950.jpg'}], 'start': 2755.44, 'title': 'Visualizing sales data', 'summary': 'Covers creating calculated fields, replacing data, and using different visualization techniques to analyze sales data, including the use of show me feature to generate visualizations based on region and sales. it also explores creating visualizations for sales and profit data, including color-coding for profitability, geographical mapping, and comparison of sales and profit by category, resulting in four visualizations that provide insights into the data.', 'chapters': [{'end': 2834.083, 'start': 2755.44, 'title': 'Sales visualization and analysis', 'summary': 'Covers creating calculated fields, replacing data, and using different visualization techniques to analyze sales data, including the use of show me feature to generate visualizations based on region and sales.', 'duration': 78.643, 'highlights': ['The chapter covers creating calculated fields and replacing total number of customers with sales per customer, allowing for analysis of sales per customer ratio and identifying the highest performing customers.', 'The use of show me feature is demonstrated to generate different visualizations based on region and sales data, with the example of creating a tree map to visualize sales by region, using both size and color to represent sales and profit.']}, {'end': 3230.485, 'start': 2834.243, 'title': 'Visualizing sales and profit data', 'summary': 'Covers the use of tableau to create visualizations for sales and profit data, including color-coding for profitability, geographical mapping, and comparison of sales and profit by category, resulting in four visualizations that provide insights into the data.', 'duration': 396.242, 'highlights': ['Tableau generates longitude and latitude for geographical fields like state, city, and country, enabling easy visualization of sales data on a map. Tableau automatically generates longitude and latitude for geographical fields like state, city, and country, enabling easy visualization of sales data on a map, providing geographical insights.', 'Visualization of sales and profit data by category using bar charts and color-coding helps in comparing and contrasting the sales and profit numbers, providing insights into the performance of different categories. Visualizing sales and profit data by category using bar charts and color-coding helps in comparing and contrasting the sales and profit numbers, providing insights into the performance of different categories and identifying trends.', 'Creation of a details sheet provides a comprehensive overview of subcategories, sales, and profit data, with color-coding for easy identification of negative profit. Creation of a details sheet provides a comprehensive overview of subcategories, sales, and profit data, with color-coding for easy identification of negative profit, enabling detailed analysis of the data.']}, {'end': 3683.547, 'start': 3230.706, 'title': 'Creating interactive dashboards in tableau', 'summary': 'Demonstrates creating interactive dashboards in tableau, utilizing features like fixed size, filter, uses filter, parameters, sets, and donut chart, to analyze sales and profits by region, category, and customer names, allowing users to make data-driven decisions.', 'duration': 452.841, 'highlights': ['The chapter demonstrates creating interactive dashboards in Tableau, utilizing features like fixed size, filter, uses filter, parameters, sets, and donut chart. The transcript covers the creation of interactive dashboards in Tableau, including the use of various features and tools such as fixed size, filter, uses filter, parameters, sets, and donut chart.', 'Analyzing sales and profits by region, category, and customer names. The transcript includes analysis of sales and profits by region, category, and customer names, providing insights into the performance of different segments.', 'Allowing users to make data-driven decisions. The chapter focuses on enabling users to make data-driven decisions by providing tools and visualization techniques for analyzing and interpreting the data effectively.']}, {'end': 4161.765, 'start': 3684.007, 'title': 'Creating dual axis charts and donut charts', 'summary': 'Demonstrates how to create dual axis charts and donut charts in tableau, using various measures and dimensions, allowing for visualizations that provide insights into regional sales, pie and donut chart customization, and color palette selection.', 'duration': 477.758, 'highlights': ['The chapter demonstrates creating dual axis charts and donut charts in Tableau, with a focus on visualizing regional sales and customizing pie and donut charts for effective data representation. Creating dual axis charts and donut charts in Tableau, visualizing regional sales, customizing pie and donut charts.', 'The chapter emphasizes the importance of allowing the size and angle of pie charts to be affected by the chosen measure, providing insights into the variation in sales between different regions. Emphasizing the importance of size and angle in pie charts, variation in sales between different regions.', 'The chapter provides guidance on creating a dual axis chart by utilizing two axes and manipulating marks cards to affect different visualizations, improving the understanding of data presentation. Guidance on creating a dual axis chart, utilizing two axes, manipulating marks cards for different visualizations.', "The chapter demonstrates the process of creating a two-dimensional pie chart, showcasing the capability of Tableau to present multiple pie charts simultaneously or split a single pie chart by categories. Creating a two-dimensional pie chart, Tableau's capability to present multiple pie charts simultaneously or split a single pie chart by categories.", 'The chapter provides insights into customizing color palettes for pie and donut charts, allowing for tailored visual representations to align with specific business needs. Customizing color palettes for pie and donut charts, tailored visual representations to align with specific business needs.']}], 'duration': 1406.325, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo2755440.jpg', 'highlights': ['The chapter covers creating calculated fields and replacing total number of customers with sales per customer, allowing for analysis of sales per customer ratio and identifying the highest performing customers.', 'The use of show me feature is demonstrated to generate different visualizations based on region and sales data, with the example of creating a tree map to visualize sales by region, using both size and color to represent sales and profit.', 'Tableau generates longitude and latitude for geographical fields like state, city, and country, enabling easy visualization of sales data on a map, providing geographical insights.', 'Visualization of sales and profit data by category using bar charts and color-coding helps in comparing and contrasting the sales and profit numbers, providing insights into the performance of different categories and identifying trends.', 'Creation of a details sheet provides a comprehensive overview of subcategories, sales, and profit data, with color-coding for easy identification of negative profit, enabling detailed analysis of the data.', 'The chapter demonstrates creating interactive dashboards in Tableau, utilizing features like fixed size, filter, uses filter, parameters, sets, and donut chart.', 'Analyzing sales and profits by region, category, and customer names, providing insights into the performance of different segments.', 'Allowing users to make data-driven decisions by providing tools and visualization techniques for analyzing and interpreting the data effectively.', 'The chapter demonstrates creating dual axis charts and donut charts in Tableau, visualizing regional sales, customizing pie and donut charts.', 'Emphasizing the importance of size and angle in pie charts, variation in sales between different regions.', 'Guidance on creating a dual axis chart, utilizing two axes, manipulating marks cards for different visualizations.', "Creating a two-dimensional pie chart, Tableau's capability to present multiple pie charts simultaneously or split a single pie chart by categories.", 'Customizing color palettes for pie and donut charts, tailored visual representations to align with specific business needs.']}, {'end': 5401.493, 'segs': [{'end': 4249.871, 'src': 'embed', 'start': 4226.142, 'weight': 3, 'content': [{'end': 4234.723, 'text': "So while we like to hide this axis, We'd also like to maybe hide this grid line that's occurring.", 'start': 4226.142, 'duration': 8.581}, {'end': 4237.384, 'text': 'So you can click right click and format.', 'start': 4235.023, 'duration': 2.361}, {'end': 4239.525, 'text': "And let's go to our lines.", 'start': 4237.804, 'duration': 1.721}, {'end': 4242.827, 'text': 'Change that zero line to none.', 'start': 4241.346, 'duration': 1.481}, {'end': 4246.709, 'text': 'Perfect Get rid of some of the clutter on this visualization.', 'start': 4243.327, 'duration': 3.382}, {'end': 4249.871, 'text': 'Still feel like this outer pie should be a little bigger.', 'start': 4247.149, 'duration': 2.722}], 'summary': 'Adjust visualization: hide axis and grid line, enlarge outer pie.', 'duration': 23.729, 'max_score': 4226.142, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo4226142.jpg'}, {'end': 4685.584, 'src': 'embed', 'start': 4661.156, 'weight': 4, 'content': [{'end': 4667.558, 'text': "let's go to sales by year and we're gonna say we want this same filter to affect both worksheets.", 'start': 4661.156, 'duration': 6.402}, {'end': 4673.76, 'text': "so we're gonna right click here, hover over, apply to worksheets and click selected worksheets.", 'start': 4667.558, 'duration': 6.202}, {'end': 4678.121, 'text': 'now we select sales by year, is selected and we select profit by year.', 'start': 4673.76, 'duration': 4.361}, {'end': 4685.584, 'text': 'okay, so when we go to the profit by year sheet, you can see that it now has category on there.', 'start': 4678.121, 'duration': 7.463}], 'summary': 'Sales and profit data filtered by year applied to multiple worksheets.', 'duration': 24.428, 'max_score': 4661.156, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo4661156.jpg'}, {'end': 4835.177, 'src': 'embed', 'start': 4802.505, 'weight': 1, 'content': [{'end': 4807.527, 'text': "And now it is year, but it's based on a range, and we have this slider.", 'start': 4802.505, 'duration': 5.022}, {'end': 4811.349, 'text': 'And you can see how that slider affects our visualization.', 'start': 4807.547, 'duration': 3.802}, {'end': 4815.504, 'text': 'Let me show you a trick to make this apply to both.', 'start': 4812.102, 'duration': 3.402}, {'end': 4823.149, 'text': 'Not a trick, but just if you have not applied it to both worksheets, but you already added it to the visualization.', 'start': 4815.925, 'duration': 7.224}, {'end': 4825.631, 'text': "See, it's here, but it's only affecting one worksheet.", 'start': 4823.269, 'duration': 2.362}, {'end': 4835.177, 'text': "You can change the worksheet's settings right on the filter instead of having to go to the worksheet where the filter exists.", 'start': 4825.811, 'duration': 9.366}], 'summary': 'Year-based slider affects visualization, can be applied to both worksheets.', 'duration': 32.672, 'max_score': 4802.505, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo4802505.jpg'}, {'end': 4933.466, 'src': 'embed', 'start': 4905.009, 'weight': 0, 'content': [{'end': 4909.112, 'text': 'off of color, and that makes our combined one line again perfect.', 'start': 4905.009, 'duration': 4.103}, {'end': 4918.078, 'text': 'now, if we want this to be on the same space as this, we right click here, the second measure in the row section, and click dual axis.', 'start': 4909.112, 'duration': 8.966}, {'end': 4919.519, 'text': "so let's put it right on top.", 'start': 4918.078, 'duration': 1.441}, {'end': 4921.36, 'text': 'I can see this versus this.', 'start': 4919.519, 'duration': 1.841}, {'end': 4928.564, 'text': 'Now, if we wanted to, on hover, show that this is overall sales, we can click on tooltip.', 'start': 4922.381, 'duration': 6.183}, {'end': 4933.466, 'text': "Region is missing because we don't have it with the color by region anymore.", 'start': 4928.924, 'duration': 4.542}], 'summary': 'Using dual axis to compare data and adding tooltip for additional information.', 'duration': 28.457, 'max_score': 4905.009, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo4905009.jpg'}, {'end': 5149.597, 'src': 'embed', 'start': 5113.882, 'weight': 5, 'content': [{'end': 5118.523, 'text': 'So it filters this line to those regions just as much as it filters these lines.', 'start': 5113.882, 'duration': 4.641}, {'end': 5129.813, 'text': "So I'm going to remove out that tool tip line cause it could be a little misleading.", 'start': 5124.932, 'duration': 4.881}, {'end': 5139.555, 'text': "Let's continue on and make a dashboard that digs a little bit more into sales specifically.", 'start': 5132.794, 'duration': 6.761}, {'end': 5141.655, 'text': "Great So we'll make our first sheet.", 'start': 5139.835, 'duration': 1.82}, {'end': 5149.597, 'text': "We'll call it sales by region and we're going to make another pie chart.", 'start': 5141.695, 'duration': 7.902}], 'summary': 'Creating a sales dashboard with a focus on regions and pie charts.', 'duration': 35.715, 'max_score': 5113.882, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5113882.jpg'}], 'start': 4162.066, 'title': 'Tableau dashboard tips', 'summary': 'Covers creating two-dimensional pie and donut charts, applying filters to multiple worksheets, creating dual axis charts and dashboards, and providing tips for tableau dashboard customization, with step-by-step guidance, examples, and emphasis on consistency in data presentation.', 'chapters': [{'end': 4558.611, 'start': 4162.066, 'title': 'Creating two-dimensional pie and donut charts', 'summary': 'Demonstrates how to create two-dimensional pie and donut charts in tableau, offering step-by-step guidance and tips for customizing visualizations, including adding borders, labels, and tooltips, and emphasizes the importance of consistency in data presentation.', 'duration': 396.545, 'highlights': ['The chapter demonstrates how to create two-dimensional pie and donut charts in Tableau, offering step-by-step guidance and tips for customizing visualizations, including adding borders, labels, and tooltips.', 'The presenter emphasizes the importance of consistency in data presentation, highlighting the need to ensure that labels are consistent with the data being displayed.', 'The presenter provides guidance on customizing visualizations, such as adding borders, labels, and tooltips, offering practical tips for enhancing the clarity and effectiveness of the visualizations.']}, {'end': 4775.893, 'start': 4558.951, 'title': 'Dashboard filtering and applying filters to multiple worksheets', 'summary': 'Discusses applying filters to multiple worksheets in a dashboard, enabling the dashboard to be filtered by category and region, and the difference between filters for continuous and discrete fields.', 'duration': 216.942, 'highlights': ['Enabling the dashboard to be filtered by category and region The chapter discusses enabling the dashboard to be filtered by category and region, allowing users to filter out regions and change their time selection.', 'Applying filters to multiple worksheets in a dashboard The chapter demonstrates applying filters to multiple worksheets in a dashboard, ensuring that one filter affects both worksheets to maintain consistency.', 'Difference between filters for continuous and discrete fields The chapter explains the difference between filters for continuous and discrete fields, highlighting that filters for continuous fields are a range instead of just a list.']}, {'end': 5225.345, 'start': 4775.893, 'title': 'Creating dual axis charts and dashboards', 'summary': 'Demonstrates how to create dual axis charts and synchronized dashboards in tableau, enabling users to visualize and compare overall sales and profit by region as well as sales by region in percentage format, with examples of using filters to impact visualizations and applying quick table calculations.', 'duration': 449.452, 'highlights': ['Demonstrating how to create dual axis charts and synchronized dashboards in Tableau The speaker provides a step-by-step guide on creating dual axis charts and synchronized dashboards in Tableau, allowing for the visualization of multiple measures simultaneously.', 'Visualizing and comparing overall sales and profit by region The tutorial showcases the process of visualizing and comparing overall sales and profit by region using dual axis charts, enabling users to gain insights into the performance of different regions.', 'Visualizing sales by region in percentage format using quick table calculations The presenter demonstrates the use of quick table calculations to represent sales by region in percentage format, providing a comprehensive view of sales distribution across different regions.', 'Impact of filters on visualizations The tutorial explains the impact of filters on visualizations, showing how applying filters can dynamically alter the displayed data and affect the overall visualization.']}, {'end': 5401.493, 'start': 5225.345, 'title': 'Tableau dashboard tips', 'summary': 'Explains how to apply quick table calculations in tableau, add filters, and create a filled map based on state, while also demonstrating how to customize labels and resolve label overlap issues.', 'duration': 176.148, 'highlights': ['Applying quick table calculations The speaker demonstrates the process of applying quick table calculations in Tableau to display the sum of sales and explains the benefits of using control and drag for quick table calculation.', 'Creating a filled map based on state The speaker explains the process of creating a filled map based on state in Tableau, showcasing different color palettes to represent sales by state and the option to customize labels for better visualization.', 'Adding filters and ensuring filter application to all sheets The speaker adds a filter for region and emphasizes the importance of ensuring that the filter gets added to all sheets, offering practical insights into filter management in Tableau.', 'Customizing labels and resolving label overlap issues The speaker demonstrates the customization of labels by adding dollar sign and state labels, as well as resolving label overlap issues by adjusting the settings to allow labels to appear without overlap.']}], 'duration': 1239.427, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo4162066.jpg', 'highlights': ['The chapter demonstrates how to create two-dimensional pie and donut charts in Tableau, offering step-by-step guidance and tips for customizing visualizations, including adding borders, labels, and tooltips.', 'Demonstrating how to create dual axis charts and synchronized dashboards in Tableau, allowing for the visualization of multiple measures simultaneously.', 'Enabling the dashboard to be filtered by category and region, allowing users to filter out regions and change their time selection.', 'Applying filters to multiple worksheets in a dashboard, ensuring that one filter affects both worksheets to maintain consistency.', 'The presenter emphasizes the importance of consistency in data presentation, highlighting the need to ensure that labels are consistent with the data being displayed.', 'The tutorial explains the impact of filters on visualizations, showing how applying filters can dynamically alter the displayed data and affect the overall visualization.']}, {'end': 7822.638, 'segs': [{'end': 5453.665, 'src': 'embed', 'start': 5426.749, 'weight': 13, 'content': [{'end': 5432.876, 'text': "For filters for this one, let's right click on sales here and click show filter.", 'start': 5426.749, 'duration': 6.127}, {'end': 5440.005, 'text': "So basically wherever you're using your metrics, your dimensions or your measures, you can right click on them.", 'start': 5433.077, 'duration': 6.928}, {'end': 5443.798, 'text': 'and create your filters.', 'start': 5440.896, 'duration': 2.902}, {'end': 5450.363, 'text': 'So now we could, the lowest amount for a state is $920 for sales for this time period.', 'start': 5443.818, 'duration': 6.545}, {'end': 5453.665, 'text': 'And we could filter out ones that have sales lower than that.', 'start': 5450.543, 'duration': 3.122}], 'summary': 'Filtering sales data: lowest sales for a state is $920; filters can be created for metrics and dimensions.', 'duration': 26.916, 'max_score': 5426.749, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5426749.jpg'}, {'end': 5715.048, 'src': 'embed', 'start': 5683.721, 'weight': 8, 'content': [{'end': 5685.982, 'text': "Let's move our legends out of there.", 'start': 5683.721, 'duration': 2.261}, {'end': 5689.624, 'text': 'So we can grab this legend and come and put it on this side.', 'start': 5686.402, 'duration': 3.222}, {'end': 5703.619, 'text': "And this legend, come put it over here so that we're getting a little bit more near the visualizations they belong to.", 'start': 5692.811, 'duration': 10.808}, {'end': 5706.341, 'text': 'This legend goes up here with this one.', 'start': 5703.919, 'duration': 2.422}, {'end': 5715.048, 'text': "I'm going to actually click here and change it from a tiled, so right here it says tiled object, to a floating object.", 'start': 5706.461, 'duration': 8.587}], 'summary': 'Moving legends for better visualization alignment and organization.', 'duration': 31.327, 'max_score': 5683.721, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5683721.jpg'}, {'end': 5787.046, 'src': 'embed', 'start': 5758.439, 'weight': 14, 'content': [{'end': 5760.66, 'text': 'It gives you some of the most flexibility.', 'start': 5758.439, 'duration': 2.221}, {'end': 5764.361, 'text': 'But if you wanted them to only be able to select a single value,', 'start': 5761.08, 'duration': 3.281}, {'end': 5770.264, 'text': "you could turn it into a radio button list so that it's a selected all or it's one at a time.", 'start': 5764.361, 'duration': 5.903}, {'end': 5775.847, 'text': 'You could also do a drop down or a slider and make that happen.', 'start': 5771.965, 'duration': 3.882}, {'end': 5781.323, 'text': 'A slider is a little bit different from a range.', 'start': 5778.962, 'duration': 2.361}, {'end': 5787.046, 'text': "On the range, you can see that we could edit either side, and it's picking everything in between.", 'start': 5781.744, 'duration': 5.302}], 'summary': 'Options like radio buttons, dropdowns, and sliders offer flexibility for selecting values.', 'duration': 28.607, 'max_score': 5758.439, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5758439.jpg'}, {'end': 5836.187, 'src': 'embed', 'start': 5815.139, 'weight': 9, 'content': [{'end': 5828.562, 'text': 'This could be really helpful for if you had a filter for by products and that will allow somebody to look at just one product at a time if they know their name of the product but also not have to just open up the product list and scroll and scroll and scroll,', 'start': 5815.139, 'duration': 13.423}, {'end': 5830.303, 'text': 'since there are very a lot of products.', 'start': 5828.562, 'duration': 1.741}, {'end': 5834.125, 'text': 'So we can filter by region by doing this.', 'start': 5830.743, 'duration': 3.382}, {'end': 5836.187, 'text': 'Oh, this is a great reminder.', 'start': 5834.786, 'duration': 1.401}], 'summary': 'Filtering by products can save time; helps find specific products easily.', 'duration': 21.048, 'max_score': 5815.139, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5815139.jpg'}, {'end': 5977.944, 'src': 'embed', 'start': 5949.953, 'weight': 1, 'content': [{'end': 5952.814, 'text': 'so if we just wanted to look at Texas, we click this.', 'start': 5949.953, 'duration': 2.861}, {'end': 5964.716, 'text': 'this updates to just central this updates to just Texas down here and unselect by clicking on maybe another state.', 'start': 5952.814, 'duration': 11.902}, {'end': 5969.579, 'text': 'or when you click on the state again, it should unselect and we can do the same thing here.', 'start': 5964.716, 'duration': 4.863}, {'end': 5975.302, 'text': 'or if we just want to look at one subcategory and say let me scroll down a bit storage.', 'start': 5969.579, 'duration': 5.723}, {'end': 5976.903, 'text': 'now everything updates to the storage.', 'start': 5975.302, 'duration': 1.601}, {'end': 5977.944, 'text': "it's interesting.", 'start': 5976.903, 'duration': 1.041}], 'summary': 'The tool allows users to select specific states and subcategories for analysis, updating the data accordingly.', 'duration': 27.991, 'max_score': 5949.953, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5949953.jpg'}, {'end': 6163.093, 'src': 'embed', 'start': 6135.056, 'weight': 15, 'content': [{'end': 6137.698, 'text': "And let's add back in a region filter.", 'start': 6135.056, 'duration': 2.642}, {'end': 6143.542, 'text': 'And this one no longer has the icon that shows you that it affects multiple sheets.', 'start': 6138.278, 'duration': 5.264}, {'end': 6145.043, 'text': 'Which is what we want for now.', 'start': 6144.002, 'duration': 1.041}, {'end': 6147.624, 'text': 'So you might want.', 'start': 6145.663, 'duration': 1.961}, {'end': 6155.349, 'text': 'perhaps there would be a situation where you would have two dashboards and you would want these filters that you put on here to affect both dashboards.', 'start': 6147.624, 'duration': 7.725}, {'end': 6157.77, 'text': "And in this case that's not what I want.", 'start': 6155.769, 'duration': 2.001}, {'end': 6163.093, 'text': 'Great, so another one we can use the basics for is sales by subcategory.', 'start': 6158.01, 'duration': 5.083}], 'summary': 'Adding region filter without affecting multiple sheets. sales by subcategory can be used as well.', 'duration': 28.037, 'max_score': 6135.056, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo6135056.jpg'}, {'end': 6391.724, 'src': 'embed', 'start': 6368.993, 'weight': 2, 'content': [{'end': 6376.837, 'text': 'And 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': 6368.993, 'duration': 7.844}, {'end': 6385.4, 'text': 'Otherwise, we have to add that line, this line here, and it makes these lines smaller and lower, more difficult to see.', 'start': 6377.057, 'duration': 8.343}, {'end': 6388.923, 'text': 'back to our profit over time by category.', 'start': 6386.701, 'duration': 2.222}, {'end': 6391.724, 'text': "so that's some of the benefits of having an area chart.", 'start': 6388.923, 'duration': 2.801}], 'summary': 'An area chart quickly shows 2013 profit of around $50,000, aiding visibility.', 'duration': 22.731, 'max_score': 6368.993, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo6368993.jpg'}, {'end': 6557.116, 'src': 'embed', 'start': 6531.21, 'weight': 3, 'content': [{'end': 6536.116, 'text': 'The level of detail for the whole chart is a big factor as well on how many slices you get.', 'start': 6531.21, 'duration': 4.906}, {'end': 6543.625, 'text': 'Great Profit by region, profit by category, by subcategory, and by profit over time.', 'start': 6536.416, 'duration': 7.209}, {'end': 6546.467, 'text': 'and we have our category filter.', 'start': 6544.025, 'duration': 2.442}, {'end': 6548.469, 'text': "we don't have our subcategory filter yet.", 'start': 6546.467, 'duration': 2.002}, {'end': 6552.552, 'text': "we grabbed category, but let's right click on subcategory and click show filter.", 'start': 6548.469, 'duration': 4.083}, {'end': 6553.753, 'text': 'there we go.', 'start': 6552.552, 'duration': 1.201}, {'end': 6557.116, 'text': 'now we have a filter for category and subcategory.', 'start': 6553.753, 'duration': 3.363}], 'summary': 'Detailed chart influences slice count. profit by region, category, subcategory, and over time with filters.', 'duration': 25.906, 'max_score': 6531.21, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo6531210.jpg'}, {'end': 6755.291, 'src': 'embed', 'start': 6724.338, 'weight': 5, 'content': [{'end': 6727.42, 'text': 'Excellent And we have our profit dashboard.', 'start': 6724.338, 'duration': 3.082}, {'end': 6728.341, 'text': "Let's see.", 'start': 6727.82, 'duration': 0.521}, {'end': 6731.603, 'text': 'There is this checkbox down here called show dashboard title.', 'start': 6728.521, 'duration': 3.082}, {'end': 6735.826, 'text': 'So if we wanted to have the title at the top here, you can click that button.', 'start': 6731.923, 'duration': 3.903}, {'end': 6741.01, 'text': "Any floating objects, don't shift down like everything else did.", 'start': 6736.207, 'duration': 4.803}, {'end': 6744.233, 'text': 'There we go.', 'start': 6741.03, 'duration': 3.203}, {'end': 6747.806, 'text': 'So we could have that title, we could not have that title.', 'start': 6745.464, 'duration': 2.342}, {'end': 6749.147, 'text': "That's up to you.", 'start': 6748.406, 'duration': 0.741}, {'end': 6755.291, 'text': 'Excellent So at this point we have our overall dashboard that looks at sales and profit.', 'start': 6749.627, 'duration': 5.664}], 'summary': 'Created profit dashboard with option to show/hide title, focusing on sales and profit.', 'duration': 30.953, 'max_score': 6724.338, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo6724338.jpg'}, {'end': 6871.723, 'src': 'embed', 'start': 6843.322, 'weight': 12, 'content': [{'end': 6848.604, 'text': "Great, so we'll go to our overall dashboard and we'll be creating what's called an action.", 'start': 6843.322, 'duration': 5.282}, {'end': 6852.685, 'text': 'So you can make an action on a worksheet.', 'start': 6849.204, 'duration': 3.481}, {'end': 6858.347, 'text': 'You can see right here, actions, or on a dashboard, actions.', 'start': 6853.686, 'duration': 4.661}, {'end': 6863.269, 'text': "So since we're linking between two dashboards, this is gonna be a dashboard action.", 'start': 6858.907, 'duration': 4.362}, {'end': 6866.54, 'text': 'Sorry, just trying to unhighlight there.', 'start': 6864.639, 'duration': 1.901}, {'end': 6871.723, 'text': "But if you're ever looking for an action you made and you can't find it, look in the other one.", 'start': 6867.22, 'duration': 4.503}], 'summary': 'Creating a dashboard action to link between two dashboards.', 'duration': 28.401, 'max_score': 6843.322, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo6843322.jpg'}, {'end': 7663.256, 'src': 'embed', 'start': 7638.665, 'weight': 11, 'content': [{'end': 7644.448, 'text': "Excellent Now you can see that when we sorted it, it didn't take this big guy and put it all the way at the top.", 'start': 7638.665, 'duration': 5.783}, {'end': 7647.409, 'text': 'It just sorted it each within its own section.', 'start': 7644.808, 'duration': 2.601}, {'end': 7650.491, 'text': 'Great And so here we have our in and out.', 'start': 7647.829, 'duration': 2.662}, {'end': 7656.913, 'text': "And that's not a super user friendly title for our users of this dashboard.", 'start': 7650.931, 'duration': 5.982}, {'end': 7660.375, 'text': "They're like in and out of top end customers by sales.", 'start': 7656.933, 'duration': 3.442}, {'end': 7663.256, 'text': 'Maybe we want this to say something a little bit more user friendly.', 'start': 7660.435, 'duration': 2.821}], 'summary': 'Sorting grouped data by section and improving user-friendly dashboard titles.', 'duration': 24.591, 'max_score': 7638.665, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo7638665.jpg'}, {'end': 7730.771, 'src': 'embed', 'start': 7688.885, 'weight': 0, 'content': [{'end': 7689.886, 'text': "so it's going to be top.", 'start': 7688.885, 'duration': 1.001}, {'end': 7692.648, 'text': "And then we want to use the number that's in our parameter.", 'start': 7690.006, 'duration': 2.642}, {'end': 7695.751, 'text': 'So we have to convert it from a number to a string.', 'start': 7692.728, 'duration': 3.023}, {'end': 7698.133, 'text': 'And we have to concatenate them together.', 'start': 7696.031, 'duration': 2.102}, {'end': 7700.315, 'text': 'In Tableau, you can use a plus sign.', 'start': 7698.633, 'duration': 1.682}, {'end': 7705.479, 'text': "Top And always make sure you have space between what you're concatenating together.", 'start': 7700.575, 'duration': 4.904}, {'end': 7707.04, 'text': "That's something that I tend to forget.", 'start': 7705.539, 'duration': 1.501}, {'end': 7709.362, 'text': 'Top space customers.', 'start': 7707.701, 'duration': 1.661}, {'end': 7712.945, 'text': "So if they pick 20, it'll say top 20 customers.", 'start': 7709.903, 'duration': 3.042}, {'end': 7718.207, 'text': "so if it's in the set, then top blank customers.", 'start': 7713.866, 'duration': 4.341}, {'end': 7721.768, 'text': "else if it's not in the set, we will just call it other.", 'start': 7718.207, 'duration': 3.561}, {'end': 7726.209, 'text': 'and in tableau you always need to end your if statement with an end here.', 'start': 7721.768, 'duration': 4.441}, {'end': 7728.85, 'text': "it tells us our calculation is valid while we're here.", 'start': 7726.209, 'duration': 2.641}, {'end': 7730.771, 'text': 'i want to show you a little trick.', 'start': 7728.85, 'duration': 1.921}], 'summary': 'In tableau, concatenate numbers to strings for dynamic labeling and use if-else statements to categorize data.', 'duration': 41.886, 'max_score': 7688.885, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo7688885.jpg'}, {'end': 7790.376, 'src': 'embed', 'start': 7756.976, 'weight': 4, 'content': [{'end': 7759.318, 'text': "and then I clicked on string and I'm like what does this do?", 'start': 7756.976, 'duration': 2.342}, {'end': 7761.04, 'text': 'click on it and it tells me so.', 'start': 7759.318, 'duration': 1.722}, {'end': 7764.824, 'text': 'this makes it really useful inside of tableau, also in tableau.', 'start': 7761.04, 'duration': 3.784}, {'end': 7766.886, 'text': 'you can make a comment in here.', 'start': 7764.824, 'duration': 2.062}, {'end': 7774.013, 'text': "so if somebody's like what's going on here, you can press dash, dash or slash, slash and type in.", 'start': 7766.886, 'duration': 7.127}, {'end': 7777.556, 'text': 'this is a more user-friendly title.', 'start': 7774.013, 'duration': 3.543}, {'end': 7779.472, 'text': 'hit OK, and there we go.', 'start': 7777.556, 'duration': 1.916}, {'end': 7781.633, 'text': 'we have our more user-friendly title.', 'start': 7779.472, 'duration': 2.161}, {'end': 7790.376, 'text': "we drag it here, we see our top 20 customers and other, and we don't want to show this anymore, but we still want it in place.", 'start': 7781.633, 'duration': 8.743}], 'summary': 'Demonstrates using string and making user-friendly title in tableau.', 'duration': 33.4, 'max_score': 7756.976, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo7756976.jpg'}], 'start': 5401.933, 'title': 'Tableau dashboard design', 'summary': 'Illustrates creating visualizations for sales data using tableau, designing and customizing dashboards, configuring filters, creating distinct dashboards for sales and profit visualizations, and utilizing parameters for controlling data.', 'chapters': [{'end': 5613.523, 'start': 5401.933, 'title': 'Tableau sales visualization', 'summary': 'Illustrates how to create visualizations for sales data using tableau, including techniques for filtering data by sales, state, and subcategory, as well as using color to represent different categories and distinctions, ultimately leading to the creation of a sales dashboard.', 'duration': 211.59, 'highlights': ['Tableau senses when the marks are too close together and will hide anything that overlaps, providing a clear visualization for sales by state.', 'Techniques for filtering data by sales and state, with the ability to set the lowest amount for sales and filter out states based on specific criteria.', 'Creation of a visualization for sales by subcategory, demonstrating the use of color to represent different categories and distinctions, and adding filters for subcategory and date to enhance data analysis.', 'Instructions for creating a sales dashboard and adjusting the size, emphasizing the importance of asking questions in the comments for further assistance.']}, {'end': 6073.637, 'start': 5613.703, 'title': 'Dashboard design and customization', 'summary': 'Demonstrates the process of designing and customizing a dashboard in tableau, including adding legends, filters, resizing, and applying filters to multiple worksheets, enabling users to select and filter data efficiently, and creating distinct dashboards for sales and profit visualizations.', 'duration': 459.934, 'highlights': ['The process of designing and customizing a dashboard in Tableau, including adding legends, filters, resizing, and applying filters to multiple worksheets. The demonstration showcases the practical process of creating a visually appealing and functional dashboard with legends and filters, emphasizing the importance of resizing and arranging visualizations for optimal presentation, and applying filters to multiple worksheets for efficient data analysis.', 'Enabling users to efficiently select and filter data using different filter types and search options. The presenter discusses the various filter types available in Tableau, such as multiple values dropdown, radio button list, dropdown, and slider, highlighting their flexibility and search functionality for efficient data selection, particularly useful for large datasets.', 'Creating distinct dashboards for sales and profit visualizations, ensuring proper substitution of sales with profit in visualizations. The process of duplicating and customizing visualizations for distinct dashboards is demonstrated, emphasizing the importance of replacing sales with profit in relevant visualizations to accurately represent profit data and maintain dashboard organization.']}, {'end': 6631.327, 'start': 6074.098, 'title': 'Tableau dashboard creation', 'summary': 'Demonstrates the process of creating a tableau dashboard, including configuring filters, duplicating worksheets, and building visualizations such as area charts and pie charts for profit analysis.', 'duration': 557.229, 'highlights': ['The process of creating a Tableau dashboard, including configuring filters, duplicating worksheets, and building visualizations for profit analysis.', 'Demonstrating the benefits of using area charts for analyzing profit over time by category and the flexibility to add more detailed views like quarters.', 'Explaining the impact of different mark card settings on the level of detail in pie charts, and the importance of color and level of detail in determining the number of slices in the pie chart.', 'Utilizing Tableau features such as quick table calculations and action filters to manipulate data for effective dashboard creation.', 'Emphasizing the importance of paying attention to layout containers and utilizing features like show filter to ensure proper arrangement and functionality of the dashboard.']}, {'end': 7506.755, 'start': 6631.347, 'title': 'Dashboard design and linking', 'summary': 'Covers dashboard design and linking between sales and profit dashboards using filter actions, including details on synchronizing axis, setting default number formatting, and creating a segment dashboard with a parameter.', 'duration': 875.408, 'highlights': ['The chapter covers filter actions for linking between dashboards, including synchronizing axis and setting default number formatting, resulting in time-saving benefits. filter actions, synchronizing axis, default number formatting, time-saving benefits', 'Detail on creating a segment dashboard with a parameter, including setting up visualizations for sales and profit by segment and managing dual axis for sales and profit. segment dashboard, parameter, visualizations for sales and profit, dual axis', 'Explanation on utilizing dashboard actions to link between dashboards, along with insights into using go to URL actions for external linking, providing comprehensive understanding of dashboard actions. dashboard actions, go to URL actions, comprehensive understanding']}, {'end': 7822.638, 'start': 7507.075, 'title': 'Tableau dashboard tips', 'summary': 'Covers creating bar charts, customizing colors, sorting data, creating user-friendly labels using calculated fields, and controlling data with parameters in tableau.', 'duration': 315.563, 'highlights': ['Creating bar charts for sales data The chapter discusses creating bar charts for sales data and segment analysis.', 'Customizing colors and opacity The speaker explains how to customize colors and make them more opaque using Tableau, highlighting the benefits and drawbacks.', 'Creating user-friendly labels using calculated fields The section details the process of creating user-friendly labels using calculated fields, with an example of creating a label based on a parameter value.', 'Controlling data with parameters The chapter explains how to control data with parameters in Tableau, demonstrating the process of setting parameters and using them to control changes in the data.']}], 'duration': 2420.705, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo5401933.jpg', 'highlights': ['Tableau senses when the marks are too close together and will hide anything that overlaps, providing a clear visualization for sales by state.', 'Techniques for filtering data by sales and state, with the ability to set the lowest amount for sales and filter out states based on specific criteria.', 'Creation of a visualization for sales by subcategory, demonstrating the use of color to represent different categories and distinctions, and adding filters for subcategory and date to enhance data analysis.', 'The process of designing and customizing a dashboard in Tableau, including adding legends, filters, resizing, and applying filters to multiple worksheets.', 'Enabling users to efficiently select and filter data using different filter types and search options.', 'Creating distinct dashboards for sales and profit visualizations, ensuring proper substitution of sales with profit in visualizations.', 'The process of creating a Tableau dashboard, including configuring filters, duplicating worksheets, and building visualizations for profit analysis.', 'Demonstrating the benefits of using area charts for analyzing profit over time by category and the flexibility to add more detailed views like quarters.', 'Utilizing Tableau features such as quick table calculations and action filters to manipulate data for effective dashboard creation.', 'The chapter covers filter actions for linking between dashboards, including synchronizing axis and setting default number formatting, resulting in time-saving benefits.', 'Detail on creating a segment dashboard with a parameter, including setting up visualizations for sales and profit by segment and managing dual axis for sales and profit.', 'Explanation on utilizing dashboard actions to link between dashboards, along with insights into using go to URL actions for external linking, providing comprehensive understanding of dashboard actions.', 'Creating bar charts for sales data The chapter discusses creating bar charts for sales data and segment analysis.', 'Customizing colors and opacity The speaker explains how to customize colors and make them more opaque using Tableau, highlighting the benefits and drawbacks.', 'Creating user-friendly labels using calculated fields The section details the process of creating user-friendly labels using calculated fields, with an example of creating a label based on a parameter value.', 'Controlling data with parameters The chapter explains how to control data with parameters in Tableau, demonstrating the process of setting parameters and using them to control changes in the data.']}, {'end': 9037.172, 'segs': [{'end': 8036.119, 'src': 'embed', 'start': 8005.973, 'weight': 7, 'content': [{'end': 8007.493, 'text': 'Floating right up here.', 'start': 8005.973, 'duration': 1.52}, {'end': 8016.375, 'text': 'Floating does not work very well for if you were to make this an automatic dashboard so that the size changes all the time.', 'start': 8007.753, 'duration': 8.622}, {'end': 8021.517, 'text': 'Because floating could end up right on top of your visualization and keep you from being able to see what you need to see.', 'start': 8016.655, 'duration': 4.862}, {'end': 8026.418, 'text': "And let's make these affect all the dashboards in the workbook.", 'start': 8022.557, 'duration': 3.861}, {'end': 8031.655, 'text': "Again, we don't have to do this for our parameter.", 'start': 8028.573, 'duration': 3.082}, {'end': 8036.119, 'text': 'It will already affect all the dashboards in the whole workbook.', 'start': 8032.376, 'duration': 3.743}], 'summary': 'Avoid using floating elements for automatic dashboards to prevent obstruction and ensure visibility for users.', 'duration': 30.146, 'max_score': 8005.973, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo8005973.jpg'}, {'end': 8187.192, 'src': 'embed', 'start': 8155.491, 'weight': 9, 'content': [{'end': 8165.998, 'text': "As an example of this, let's say that in our sample superstore we have Kelly Williams associated with the central region, but that's changed.", 'start': 8155.491, 'duration': 10.507}, {'end': 8167.459, 'text': "So let's go ahead and change that.", 'start': 8166.078, 'duration': 1.381}, {'end': 8178.086, 'text': "We will change it to Sarah Smith and we'll save it.", 'start': 8167.479, 'duration': 10.607}, {'end': 8187.192, 'text': "Now let's go back to our Tableau workbooks and you can see we can refresh it over here and see Sarah Smith come in.", 'start': 8178.888, 'duration': 8.304}], 'summary': 'Kelly williams in central region changed to sarah smith in tableau workbooks.', 'duration': 31.701, 'max_score': 8155.491, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo8155491.jpg'}, {'end': 8251.684, 'src': 'embed', 'start': 8225.183, 'weight': 6, 'content': [{'end': 8240.096, 'text': "So I'm going to start with our orders table and then we're going to pull on people and Tableau is going to create a join for us and it's going to choose the column that we would like to join on,", 'start': 8225.183, 'duration': 14.913}, {'end': 8242.558, 'text': 'based on the names in the two data sources.', 'start': 8240.096, 'duration': 2.462}, {'end': 8251.684, 'text': "So if these two data sources didn't have a column that had the same name, then Tableau wouldn't be able to guess what two to join on.", 'start': 8243.018, 'duration': 8.666}], 'summary': 'Tableau creates joins based on matching column names in data sources.', 'duration': 26.501, 'max_score': 8225.183, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo8225183.jpg'}, {'end': 8417.295, 'src': 'embed', 'start': 8389.491, 'weight': 0, 'content': [{'end': 8399.994, 'text': 'So it grabs all the grades A, B, C, D, F, and incomplete, and only the rows from the left table that join appropriately.', 'start': 8389.491, 'duration': 10.503}, {'end': 8403.434, 'text': "So since Charles doesn't join appropriately, he doesn't show up.", 'start': 8400.614, 'duration': 2.82}, {'end': 8410.256, 'text': "We also have B and C showing up, even though it doesn't exist in the student table.", 'start': 8403.995, 'duration': 6.261}, {'end': 8417.295, 'text': "and it won't be tied to a student because that join wasn't able to complete as it didn't exist over there.", 'start': 8411.514, 'duration': 5.781}], 'summary': "Grades a, b, c, d, f, and incomplete are joined, charles doesn't show up, b and c appear even though they don't exist in the student table.", 'duration': 27.804, 'max_score': 8389.491, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo8389491.jpg'}, {'end': 8500.483, 'src': 'embed', 'start': 8442.242, 'weight': 3, 'content': [{'end': 8453.093, 'text': "Here in our sample superstore data set, you could look and see if there are any regions in the orders table that don't exist in the people table.", 'start': 8442.242, 'duration': 10.851}, {'end': 8455.874, 'text': "And that's how you can know what kind of join you want.", 'start': 8453.513, 'duration': 2.361}, {'end': 8467.277, 'text': "And so if you want those orders to still show up even though they don't have a region, or their region is not in the people table,", 'start': 8456.434, 'duration': 10.843}, {'end': 8468.917, 'text': "that's when you would do a left join.", 'start': 8467.277, 'duration': 1.64}, {'end': 8472.721, 'text': "For our purposes, we'll do an inner join.", 'start': 8469.997, 'duration': 2.724}, {'end': 8492.94, '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': 8473.382, 'duration': 19.558}, {'end': 8495.801, 'text': 'You can see it says there, drag table to union.', 'start': 8493.38, 'duration': 2.421}, {'end': 8500.483, 'text': "And that's helpful for if you have an Excel sheet for maybe different years.", 'start': 8496.321, 'duration': 4.162}], 'summary': 'Analyzing sample superstore data for join types and union operation.', 'duration': 58.241, 'max_score': 8442.242, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo8442242.jpg'}, {'end': 8790.843, 'src': 'embed', 'start': 8761.191, 'weight': 2, 'content': [{'end': 8763.852, 'text': 'So we can do that by coming up to data and clicking new data source.', 'start': 8761.191, 'duration': 2.661}, {'end': 8768.955, 'text': 'Or you can just click this plus data source right here and click Microsoft Excel.', 'start': 8764.773, 'duration': 4.182}, {'end': 8773.577, 'text': "We're going to use this rank example worksheet.", 'start': 8769.635, 'duration': 3.942}, {'end': 8777.819, 'text': "Perfect and it's already pulled in the sheet we want because there's only one sheet.", 'start': 8774.558, 'duration': 3.261}, {'end': 8780.101, 'text': "And we'll go to sheet two.", 'start': 8779.14, 'duration': 0.961}, {'end': 8782.282, 'text': 'Pull on store.', 'start': 8781.301, 'duration': 0.981}, {'end': 8790.843, 'text': 'pull on sales, and we will rename sheet two as rank example.', 'start': 8783.08, 'duration': 7.763}], 'summary': 'Demonstrating data source selection and manipulation in microsoft excel.', 'duration': 29.652, 'max_score': 8761.191, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo8761191.jpg'}, {'end': 8902.909, 'src': 'embed', 'start': 8872.152, 'weight': 1, 'content': [{'end': 8873.192, 'text': 'And we can see our ranks.', 'start': 8872.152, 'duration': 1.04}, {'end': 8876.113, 'text': "So E had the highest sales, so it's 1.", 'start': 8873.372, 'duration': 2.741}, {'end': 8876.773, 'text': 'D is next.', 'start': 8876.113, 'duration': 0.66}, {'end': 8881.901, 'text': 'And C and B are tied, 20 and 20.', 'start': 8877.153, 'duration': 4.748}, {'end': 8884.462, 'text': 'And so they both share the rank of three.', 'start': 8881.901, 'duration': 2.561}, {'end': 8888.664, 'text': 'And then because they are two of them that share the same rank, we skip four.', 'start': 8884.922, 'duration': 3.742}, {'end': 8891.965, 'text': 'And the next one gets fifth place.', 'start': 8888.684, 'duration': 3.281}, {'end': 8895.026, 'text': "But now this isn't the only way to rank.", 'start': 8892.865, 'duration': 2.161}, {'end': 8897.687, 'text': "So let's make another one of these.", 'start': 8896.026, 'duration': 1.661}, {'end': 8901.108, 'text': "We'll click duplicate and edit.", 'start': 8898.307, 'duration': 2.801}, {'end': 8902.909, 'text': "Let's erase copy.", 'start': 8901.789, 'duration': 1.12}], 'summary': 'E had the highest sales, d is next, c and b tied at 20, with 2 sharing third place.', 'duration': 30.757, 'max_score': 8872.152, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo8872152.jpg'}], 'start': 7822.818, 'title': 'Tableau visualizations and techniques', 'summary': 'Covers sales and profit visualization, tableau data visualization techniques, table joins and unions, and table calculations and ranking. it includes insights on negative profit despite big sales, implementation of filters and automatic dashboard resizing, impact of parameters on all sheets, difference between live and extract connections, different types of joins, usage of union in tableau, database side and table side calculations, level of detail calculations, ranking methods in tableau, and creation of calculated fields for ranking by sales.', 'chapters': [{'end': 7898.275, 'start': 7822.818, 'title': 'Sales and profit visualization', 'summary': 'Discusses visualizing sales and profit, highlighting negative profit despite big sales and the implementation of filters and automatic dashboard resizing.', 'duration': 75.457, 'highlights': ['The visualizations reveal a negative amount of profit despite big sales, highlighting the importance of monitoring profit alongside sales.', 'The implementation of filters for category and segment allows for more refined data analysis and visualization.', 'The automatic dashboard resizing feature ensures adaptability to various display screens, enhancing the dynamic nature of visualizations.']}, {'end': 8251.684, 'start': 7898.355, 'title': 'Tableau data visualization techniques', 'summary': 'Discusses the use of parameters, visualization legends, and data connection types in tableau, emphasizing the impact of parameters on all sheets, the difference between live and extract connections, and the process of joining data.', 'duration': 353.329, 'highlights': ['The impact of parameters on all sheets in Tableau Parameters in Tableau affect all sheets in the workbook, and any changes made to a parameter reflect across all related visualizations, ensuring consistent impact across the dashboard.', "Difference between live and extract connections in Tableau Live connections update data based on changes in the data source, while extract connections create a subset of data for improved performance but require manual or scheduled refreshes for updates, as demonstrated with the example of Sarah Smith's data not updating in the extract until a manual refresh.", 'Process of joining data in Tableau Tableau facilitates the joining of data sources based on matching column names, enabling the combination of different datasets for comprehensive analysis and visualization.']}, {'end': 8548.218, 'start': 8252.918, 'title': 'Table joins and unions in tableau', 'summary': 'Explains different types of joins, including inner join, left join, right join, and full outer join, and their impact on the resulting data sets, and also discusses the usage of union in tableau for combining data from separate sources.', 'duration': 295.3, 'highlights': ['The chapter explains different types of joins, including inner join, left join, right join, and full outer join, and their impact on the resulting data sets. It provides a clear understanding of how each type of join affects the data, with examples and explanations for each type of join.', 'The usage of union in Tableau is discussed for combining data from separate sources, such as adding more orders from a second Excel sheet, which is helpful for combining data from different years. It demonstrates how to use the union feature to add more data from separate tables, enabling the combination of data from different sources, such as orders from different years.', 'It explains how a left join includes all the data from the left table and only the pieces from the right table that apply to the left table, while a right join does the opposite, taking everything from the right table and only the rows from the left table that join appropriately. The chapter provides a detailed comparison between left join and right join, illustrating how they differ in including data from the respective tables based on the join conditions.']}, {'end': 9037.172, 'start': 8549.241, 'title': 'Table calculations and ranking in tableau', 'summary': 'Discusses the difference between database side and table side calculations, demonstrating the use of percentage of total sales split by subcategory and category, and the distinctions between level of detail calculations and table calculations. it also explores the concept of ranking in tableau, showcasing the creation of calculated fields for ranking by sales, including the implications of using different ranking methods such as rank dense and rank modified.', 'duration': 487.931, 'highlights': ['The chapter demonstrates the difference between database side and table side calculations, showcasing percentage of total sales split by subcategory and category, and explaining the distinction between level of detail calculations and table calculations. The chapter provides a clear comparison of calculations performed on the database side versus the table side, illustrating the use of percentage of total sales split by subcategory and category, and delineating the differences between level of detail calculations and table calculations.', 'It explains the implications of using different ranking methods in Tableau, such as rank dense and rank modified, and the errors encountered when attempting to use the same name for different calculated fields. The chapter delves into the consequences of employing various ranking methods in Tableau, including rank dense and rank modified, and elucidates the encountered errors associated with using identical names for distinct calculated fields.', 'The chapter also highlights the importance of aggregating fields when using table calculation functions and the detailed explanation of the rank function as a table calculation. The chapter emphasizes the significance of aggregating fields when utilizing table calculation functions and provides a comprehensive explanation of the rank function as a table calculation.']}], 'duration': 1214.354, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo7822818.jpg', 'highlights': ['The visualizations reveal a negative amount of profit despite big sales, highlighting the importance of monitoring profit alongside sales.', 'The implementation of filters for category and segment allows for more refined data analysis and visualization.', 'The automatic dashboard resizing feature ensures adaptability to various display screens, enhancing the dynamic nature of visualizations.', 'Parameters in Tableau affect all sheets in the workbook, ensuring consistent impact across the dashboard.', 'Difference between live and extract connections in Tableau: Live connections update data based on changes in the data source, while extract connections create a subset of data for improved performance.', 'Tableau facilitates the joining of data sources based on matching column names, enabling comprehensive analysis and visualization.', 'The chapter explains different types of joins, including inner join, left join, right join, and full outer join, and their impact on the resulting data sets.', 'The usage of union in Tableau is discussed for combining data from separate sources, such as adding more orders from a second Excel sheet, which is helpful for combining data from different years.', 'The chapter provides a detailed comparison between left join and right join, illustrating how they differ in including data from the respective tables based on the join conditions.', 'The chapter provides a clear comparison of calculations performed on the database side versus the table side, illustrating the use of percentage of total sales split by subcategory and category, and delineating the differences between level of detail calculations and table calculations.', 'The chapter delves into the consequences of employing various ranking methods in Tableau, including rank dense and rank modified, and elucidates the encountered errors associated with using identical names for distinct calculated fields.', 'The chapter emphasizes the significance of aggregating fields when utilizing table calculation functions and provides a comprehensive explanation of the rank function as a table calculation.']}, {'end': 9815.571, 'segs': [{'end': 9146.492, 'src': 'embed', 'start': 9113.438, 'weight': 5, 'content': [{'end': 9117.599, 'text': "So it defaults to descending and it's saying the biggest is the best.", 'start': 9113.438, 'duration': 4.161}, {'end': 9121.26, 'text': "So for sales that's accurate.", 'start': 9118.499, 'duration': 2.761}, {'end': 9123.14, 'text': "So what it's doing is biggest down.", 'start': 9121.3, 'duration': 1.84}, {'end': 9127.741, 'text': 'Now here it has to decide which one to give three and which one to do four.', 'start': 9123.7, 'duration': 4.041}, {'end': 9134.243, 'text': "And it's doing that based on the ASCII values of the store.", 'start': 9127.761, 'duration': 6.482}, {'end': 9137.586, 'text': "So it's looking at more information on the row.", 'start': 9135.185, 'duration': 2.401}, {'end': 9146.492, 'text': 'And since uppercase B comes before lowercase c, uppercase B is getting the 3, even though they both have 20 for sales.', 'start': 9138.087, 'duration': 8.405}], 'summary': 'The system sorts sales data in descending order, prioritizing the largest values. it assigns a rank based on ascii values, favoring uppercase letters over lowercase ones.', 'duration': 33.054, 'max_score': 9113.438, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9113438.jpg'}, {'end': 9314.146, 'src': 'embed', 'start': 9286.59, 'weight': 4, 'content': [{'end': 9289.893, 'text': 'so you can click here and you can see all the sheets.', 'start': 9286.59, 'duration': 3.303}, {'end': 9292.815, 'text': 'or you can see the other data source.', 'start': 9289.893, 'duration': 2.922}, {'end': 9295.538, 'text': 'if we click rank example, it will show the rank example data source.', 'start': 9292.815, 'duration': 2.723}, {'end': 9302.041, 'text': 'so we just want sales by category to be the source sheet and the target sheet.', 'start': 9296.218, 'duration': 5.823}, {'end': 9305.802, 'text': 'we want it to be sales by subcategory.', 'start': 9302.041, 'duration': 3.761}, {'end': 9306.923, 'text': 'so on select.', 'start': 9305.802, 'duration': 1.121}, {'end': 9308.924, 'text': 'we want it to be sales by subcategory.', 'start': 9306.923, 'duration': 2.001}, {'end': 9314.146, 'text': "we're going to use all the fields available to create this filter and hit ok.", 'start': 9308.924, 'duration': 5.222}], 'summary': 'The goal is to filter sales data by subcategory using all available fields.', 'duration': 27.556, 'max_score': 9286.59, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9286590.jpg'}, {'end': 9415.974, 'src': 'embed', 'start': 9387.709, 'weight': 6, 'content': [{'end': 9392.052, 'text': "But we go to Sales by Category and click Technology, it'll take you to the Technology subcategory.", 'start': 9387.709, 'duration': 4.343}, {'end': 9395.055, 'text': 'Great So we have our Sales by Category 2.', 'start': 9392.693, 'duration': 2.362}, {'end': 9396.055, 'text': "Let's bring it to the end.", 'start': 9395.055, 'duration': 1}, {'end': 9397.937, 'text': 'Rename it.', 'start': 9397.276, 'duration': 0.661}, {'end': 9410.51, 'text': "We're going to call it sales by category stacked because we're going to take subcategory here and drag it onto color.", 'start': 9404.346, 'duration': 6.164}, {'end': 9415.974, 'text': 'And now we can see our different subcategories in the colors there.', 'start': 9412.272, 'duration': 3.702}], 'summary': "Renamed sales by category 2 to 'sales by category stacked' and visualized subcategories by color.", 'duration': 28.265, 'max_score': 9387.709, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9387709.jpg'}, {'end': 9628.443, 'src': 'embed', 'start': 9598.799, 'weight': 0, 'content': [{'end': 9602.58, 'text': "So now it's colored based on the darkest is the highest sales.", 'start': 9598.799, 'duration': 3.781}, {'end': 9610.669, 'text': "We're going to put state onto label so you can see the state name and we're going to put sales onto label so we can see the sales amount.", 'start': 9603.646, 'duration': 7.023}, {'end': 9617.752, 'text': "Let's quickly change our default property for sales so that it always shows up as currency.", 'start': 9611.049, 'duration': 6.703}, {'end': 9628.443, 'text': "Now we're going to lose the decimal places, so it'll by default show up with a dollar sign and so on.", 'start': 9617.772, 'duration': 10.671}], 'summary': 'Data visualization showing high sales by state with currency formatting.', 'duration': 29.644, 'max_score': 9598.799, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9598799.jpg'}, {'end': 9726.754, 'src': 'embed', 'start': 9696.783, 'weight': 1, 'content': [{'end': 9703.208, 'text': "Let's rename our sheet to URL filter by state.", 'start': 9696.783, 'duration': 6.425}, {'end': 9705.509, 'text': 'And so when we click on Texas.', 'start': 9704.088, 'duration': 1.421}, {'end': 9708.131, 'text': 'Okay back to URL filter by state.', 'start': 9706.27, 'duration': 1.861}, {'end': 9709.232, 'text': "Let's go to our worksheets.", 'start': 9708.211, 'duration': 1.021}, {'end': 9711.513, 'text': 'And go to our actions.', 'start': 9710.493, 'duration': 1.02}, {'end': 9713.835, 'text': 'And on the go to subcategory.', 'start': 9711.853, 'duration': 1.982}, {'end': 9719.847, 'text': "it is also affecting this URL filter by state because we didn't unselect it.", 'start': 9715.342, 'duration': 4.505}, {'end': 9726.754, 'text': "Now, to keep that from being a problem, we're going to just come here in sales by category, be the only sheet,", 'start': 9720.247, 'duration': 6.507}], 'summary': "Renamed sheet to 'url filter by state' and fixed issue with 'sales by category' sheet.", 'duration': 29.971, 'max_score': 9696.783, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9696783.jpg'}], 'start': 9037.172, 'title': 'Ranking options and tableau actions', 'summary': 'Explains ranking options and unique ranking based on sales, demonstrating ascending and descending ranking. it also covers tableau actions for creating dashboard interactivity, including filtering data and linking tableau with external sources.', 'chapters': [{'end': 9137.586, 'start': 9037.172, 'title': 'Ranking options and unique ranking', 'summary': 'Explains the concept of ranking options and unique ranking, demonstrating the application of ascending and descending ranking based on sales, and how unique ranking is determined even when the numbers are the same.', 'duration': 100.414, 'highlights': ['The process demonstrates the application of ascending and descending ranking based on sales.', 'The explanation of unique ranking, showcasing how it is determined even when the numbers are the same.', 'The system defaults to descending ranking for sales, considering the biggest as the best.', 'The unique ranking is decided based on the ASCII values of the store, providing a clear understanding of the process.']}, {'end': 9815.571, 'start': 9138.087, 'title': 'Tableau actions and dashboard interactions', 'summary': 'Covers how to use actions in tableau to create interactivity within dashboards, including creating worksheet actions to filter data and using url actions to link tableau with external sources, as well as highlighting and navigating between different visualizations.', 'duration': 677.484, 'highlights': ['Creating worksheet actions to filter data and navigate between visualizations The chapter demonstrates how to create a worksheet action to move from the sales by category sheet to the sales by subcategory sheet, allowing filtering based on the selected category, providing an interactive way to drill down into data.', 'Utilizing highlight actions to visually emphasize selected data points Highlight actions are explained, demonstrating how to use them to visually emphasize selected data points and enable users to interactively explore and compare different categories and subcategories within the visualizations.', 'Implementing URL actions to link Tableau with external sources and create interactive dashboards The chapter showcases the use of URL actions in Tableau to link to external sources, such as Wikipedia, based on selected data points, providing a way to access additional information or navigate to relevant web pages directly from the Tableau dashboard.']}], 'duration': 778.399, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9037172.jpg', 'highlights': ['The process demonstrates the application of ascending and descending ranking based on sales.', 'The explanation of unique ranking, showcasing how it is determined even when the numbers are the same.', 'The system defaults to descending ranking for sales, considering the biggest as the best.', 'The unique ranking is decided based on the ASCII values of the store, providing a clear understanding of the process.', 'Creating worksheet actions to filter data and navigate between visualizations.', 'Utilizing highlight actions to visually emphasize selected data points.', 'Implementing URL actions to link Tableau with external sources and create interactive dashboards.']}, {'end': 11285.309, 'segs': [{'end': 9864.92, 'src': 'embed', 'start': 9841.592, 'weight': 4, 'content': [{'end': 9849.979, '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': 9841.592, 'duration': 8.387}, {'end': 9851.54, 'text': "So we'll change it to Texas.", 'start': 9850.379, 'duration': 1.161}, {'end': 9852.761, 'text': 'And this will change to Texas.', 'start': 9851.64, 'duration': 1.121}, {'end': 9860.157, 'text': 'If you unselect, it leaves the page there based on the one that you had just selected.', 'start': 9855.373, 'duration': 4.784}, {'end': 9864.92, 'text': "Next we're going to take a look at reference bands and lines.", 'start': 9862.178, 'duration': 2.742}], 'summary': 'The visualization will take us to texas instead of oklahoma, unselecting leaves the page based on the selected item, and the next topic is reference bands and lines.', 'duration': 23.328, 'max_score': 9841.592, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9841592.jpg'}, {'end': 10459.273, 'src': 'embed', 'start': 10427.222, 'weight': 0, 'content': [{'end': 10433.103, 'text': 'And now we can see the best ones, the on time ones, and the ones that stand out as late.', 'start': 10427.222, 'duration': 5.881}, {'end': 10436.644, 'text': 'And standard class happens late a lot.', 'start': 10434.383, 'duration': 2.261}, {'end': 10445.466, 'text': "It's interesting to see that on average the District of Columbia has second class as a late shipment.", 'start': 10436.984, 'duration': 8.482}, {'end': 10459.273, 'text': 'You can see that all of these share the same axis size so they all go from 0 to 6 even though this one never gets that close to 6.', 'start': 10448.188, 'duration': 11.085}], 'summary': 'District of columbia has second class as a late shipment on average.', 'duration': 32.051, 'max_score': 10427.222, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo10427222.jpg'}, {'end': 10565.314, 'src': 'embed', 'start': 10534.854, 'weight': 1, 'content': [{'end': 10538.975, 'text': "And then we're going to take our order date and bring it onto columns.", 'start': 10534.854, 'duration': 4.121}, {'end': 10540.855, 'text': "And we're going to look at it by month.", 'start': 10539.075, 'duration': 1.78}, {'end': 10545.081, 'text': "But we're going to look at it by our discrete month.", 'start': 10541.459, 'duration': 3.622}, {'end': 10548.924, 'text': 'So you can see that I chose the one that has month and year.', 'start': 10545.802, 'duration': 3.122}, {'end': 10551.585, 'text': 'And then I chose discrete.', 'start': 10550.205, 'duration': 1.38}, {'end': 10557.729, 'text': "And then we're going to take profit and put it onto rows.", 'start': 10553.607, 'duration': 4.122}, {'end': 10565.314, 'text': "And we're going to change it from profit to our running total of profit.", 'start': 10558.37, 'duration': 6.944}], 'summary': 'Analyzing order dates by discrete month and calculating running total of profit.', 'duration': 30.46, 'max_score': 10534.854, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo10534854.jpg'}, {'end': 10882.043, 'src': 'embed', 'start': 10852.079, 'weight': 2, 'content': [{'end': 10862.005, 'text': "so we're going to do it fixed and you can choose dimensions and it computes an aggregation using only the specified dimensions,", 'start': 10852.079, 'duration': 9.926}, {'end': 10867.648, 'text': "so it will ignore all the other dimensions and we're going to have it based on customer name.", 'start': 10862.005, 'duration': 5.643}, {'end': 10877.641, 'text': "so we're going to have fixed customer name And we're going to get account distinct of order ID.", 'start': 10867.648, 'duration': 9.993}, {'end': 10880.523, 'text': 'And make sure you close it with your curly bracket.', 'start': 10878.521, 'duration': 2.002}, {'end': 10882.043, 'text': 'And we have no errors.', 'start': 10880.983, 'duration': 1.06}], 'summary': 'Aggregating account distinct of order ids by customer name with no errors', 'duration': 29.964, 'max_score': 10852.079, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo10852079.jpg'}], 'start': 9816.311, 'title': 'Visualizing data and analysis', 'summary': 'Covers linking wikipedia page to visualization, creating reference lines and bands, visualizing shipment delays, building waterfall chart, using level of detail calculation, and conducting customer acquisition analysis with key insights and techniques demonstrated.', 'chapters': [{'end': 9864.92, 'start': 9816.311, 'title': 'Wikipedia page and visualization', 'summary': "Demonstrates how to link a wikipedia page to a state in a visualization, allowing for the display of the selected state's information without leaving the visualization, as well as the use of reference bands and lines.", 'duration': 48.609, 'highlights': ["The chapter explains how to link a Wikipedia page to a state in a visualization, enabling the display of the selected state's information within the visualization, eliminating the need to access a separate web page.", 'It also covers the use of reference bands and lines for visualization purposes.']}, {'end': 10425.901, 'start': 9865.241, 'title': 'Creating reference lines and bands', 'summary': 'Explains how to create reference lines and bands in tableau, including their application in visualizations, and demonstrates conditional formatting for average days to ship by state and ship mode.', 'duration': 560.66, 'highlights': ['Reference lines and bands can be added to a visualization for the whole table, per pane, or per cell, providing a way to compare data across different categories. The chapter explains how reference lines and bands can be added to a visualization for the whole table, per pane, or per cell, providing a way to compare data across different categories.', 'The average for each section is computed using the value of sum of sales, allowing for comparison of aggregated data across different categories. The average for each section is computed using the value of sum of sales, allowing for comparison of aggregated data across different categories.', 'Conditional formatting is demonstrated through the creation of a calculated field to categorize average days to ship as early, on time, or late, and applying color coding to represent these categories in the visualization. Conditional formatting is demonstrated through the creation of a calculated field to categorize average days to ship as early, on time, or late, and applying color coding to represent these categories in the visualization.']}, {'end': 10732.503, 'start': 10427.222, 'title': 'Visualizing shipment delays and building waterfall chart', 'summary': 'Discusses analyzing shipment delays, comparing independent and uniform axis range, and building a waterfall chart to visualize profit over time, with a focus on the year 2014.', 'duration': 305.281, 'highlights': ['Building a waterfall chart to visualize profit over time for the year 2014 The chapter explains the process of filtering order dates for 2014, using discrete month and year, calculating running total of profit, and visualizing it as a gaunt bar with color-coded positive and negative profits.', 'Analyzing shipment delays and comparing independent and uniform axis range for visualization The transcript discusses comparing the on-time and late shipments, revealing interesting insights about the District of Columbia having second-class late shipments, and the impact of using uniform axis range for easy comparison.', 'Discussing the benefits and functionality of a waterfall chart The chapter explains how a waterfall chart provides a clear overview of total sales over time, highlights the contributions of each month, and demonstrates how it helps identify problems and significant growth periods.']}, {'end': 10988.915, 'start': 10733.104, 'title': 'Level of detail calculation', 'summary': 'Discusses using a level of detail calculation to visualize the number of orders per customer, with the most popular order count being 5, and the least popular being 17, based on the analysis of customer orders.', 'duration': 255.811, 'highlights': ['Using a level of detail calculation called fixed, the number of orders per customer is visualized, with 134 customers ordering five items, making it the most popular order count. 134 customers ordered five items.', 'The visualization revealed that seven is the next most popular order count, while 17 is the least popular, and one is relatively unpopular. Seven is the next most popular order count.', 'The chapter explains the process of creating a calculated field using a level of detail calculation called fixed, based on customer name and count distinct of order ID, to show the number of orders per customer. Creating a calculated field using a level of detail calculation called fixed.']}, {'end': 11285.309, 'start': 10990.417, 'title': 'Customer acquisition analysis', 'summary': 'Covers the creation of a level of detail visualization for customer acquisition over time, using various techniques such as filtering, running total, and analysis by region, demonstrating the increase and stagnation of new customer orders.', 'duration': 294.892, 'highlights': ['A level of detail visualization is created for customer acquisition over time, utilizing techniques like filtering and running total to analyze new customer orders.', 'The process involves creating a calculated field to distinguish new and existing customers based on their first order date, resulting in the identification of regions with varying rates of new customer acquisition.', 'The analysis indicates a period of stagnation in new orders for the east region in February 2014, prompting further investigation into the discrepancy in new customer acquisition between regions.']}], 'duration': 1468.998, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo9816311.jpg', 'highlights': ["The chapter explains how to link a Wikipedia page to a state in a visualization, enabling the display of the selected state's information within the visualization, eliminating the need to access a separate web page.", 'Building a waterfall chart to visualize profit over time for the year 2014.', 'Using a level of detail calculation called fixed, the number of orders per customer is visualized, with 134 customers ordering five items, making it the most popular order count.', 'A level of detail visualization is created for customer acquisition over time, utilizing techniques like filtering and running total to analyze new customer orders.', 'Analyzing shipment delays and comparing independent and uniform axis range for visualization.']}, {'end': 12893.477, 'segs': [{'end': 11493.622, 'src': 'embed', 'start': 11440.134, 'weight': 4, 'content': [{'end': 11450.737, 'text': 'That explains that China and India contribute the most to world population.', 'start': 11440.134, 'duration': 10.603}, {'end': 11467.262, 'text': 'Just calling out this section of the visualization.', 'start': 11463.241, 'duration': 4.021}, {'end': 11469.623, 'text': "And let's name this sheet.", 'start': 11468.102, 'duration': 1.521}, {'end': 11486.38, 'text': 'So here we have our visualization and when you hover you can see both the total population and its percent contribution and the country name.', 'start': 11479.659, 'duration': 6.721}, {'end': 11493.622, 'text': 'Our next visualization for this dashboard is going to be population over time.', 'start': 11487.381, 'duration': 6.241}], 'summary': 'China and india contribute the most to world population, with visualizations showcasing total population, percent contribution, and country names.', 'duration': 53.488, 'max_score': 11440.134, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo11440134.jpg'}, {'end': 11943.359, 'src': 'embed', 'start': 11897.181, 'weight': 1, 'content': [{'end': 11898.202, 'text': 'but it can get closer.', 'start': 11897.181, 'duration': 1.021}, {'end': 11905.693, 'text': 'And then as they get smaller and smaller screens, you at least know that it will never make it get smaller than this particular size.', 'start': 11898.322, 'duration': 7.371}, {'end': 11911.083, 'text': "So there's some benefits to that as well, where you still have a little bit of control of what it will look like in the end.", 'start': 11906.154, 'duration': 4.929}, {'end': 11913.547, 'text': "Great, let's bring on our worksheets.", 'start': 11911.844, 'duration': 1.703}, {'end': 11926.946, 'text': "and you can see that when you hover it fills up that space and that's where it's going to show up.", 'start': 11920.561, 'duration': 6.385}, {'end': 11932.55, 'text': 'You can also adjust the lines in between different visualizations for things that need more space or less space.', 'start': 11927.366, 'duration': 5.184}, {'end': 11938.255, 'text': 'Another important thing to recognize is that when you click on a visualization like this one.', 'start': 11933.25, 'duration': 5.005}, {'end': 11943.359, 'text': "Up here it will tell you how it's viewing that visualization within that space.", 'start': 11938.695, 'duration': 4.664}], 'summary': 'Benefits of controlling screen size; adjusting space for visualizations.', 'duration': 46.178, 'max_score': 11897.181, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo11897181.jpg'}, {'end': 12135.051, 'src': 'embed', 'start': 12111.846, 'weight': 5, 'content': [{'end': 12119.99, 'text': "Now you can see that when we click on China, it doesn't make a lot of sense to have this pie chart update based on that China click,", 'start': 12111.846, 'duration': 8.144}, {'end': 12124.508, 'text': "because it's just going to show duplicated information.", 'start': 12119.99, 'duration': 4.518}, {'end': 12135.051, 'text': 'so it shows the 20%, or the 20% here and the 17 billion, and then here it does the same thing, except for it shows 100%,', 'start': 12124.508, 'duration': 10.543}], 'summary': 'Pie chart update for china click shows duplicated information with 20% and 17 billion, and then 100%.', 'duration': 23.205, 'max_score': 12111.846, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo12111846.jpg'}, {'end': 12247.199, 'src': 'embed', 'start': 12215.575, 'weight': 7, 'content': [{'end': 12225.297, 'text': 'So if we click use as filter Then we click on 2011.', 'start': 12215.575, 'duration': 9.722}, {'end': 12228.219, 'text': 'You can see these numbers are slightly updating, so this is 19%.', 'start': 12225.297, 'duration': 2.922}, {'end': 12231.282, 'text': 'Then we come here, 19.5%.', 'start': 12228.219, 'duration': 3.063}, {'end': 12242.012, 'text': "Come down here, and we can see that the pie updates a little bit, although it hasn't been anything dramatic, but you can kind of see it over time.", 'start': 12231.282, 'duration': 10.73}, {'end': 12247.199, 'text': "So that's one way to add filters to your visualization.", 'start': 12243.837, 'duration': 3.362}], 'summary': 'Using the filter for 2011 results in a 19.5% update in the visualization.', 'duration': 31.624, 'max_score': 12215.575, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo12215575.jpg'}, {'end': 12797.123, 'src': 'embed', 'start': 12768.414, 'weight': 0, 'content': [{'end': 12772.036, 'text': "Next we're going to make a dashboard revolving around health information.", 'start': 12768.414, 'duration': 3.622}, {'end': 12777.36, 'text': "So first we're going to make a map about birth rates.", 'start': 12772.717, 'duration': 4.643}, {'end': 12781.583, 'text': "So we're going to call it birth rate rank.", 'start': 12777.86, 'duration': 3.723}, {'end': 12785.376, 'text': 'and to make a map.', 'start': 12784.275, 'duration': 1.101}, {'end': 12791.78, 'text': "we're going to double click on country and we're going to change it to a map type.", 'start': 12785.376, 'duration': 6.404}, {'end': 12797.123, 'text': "so we have a filled map here and then we're going to bring birth rate onto color.", 'start': 12791.78, 'duration': 5.343}], 'summary': 'Create a health dashboard with birth rate map visualization.', 'duration': 28.709, 'max_score': 12768.414, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo12768414.jpg'}, {'end': 12893.477, 'src': 'embed', 'start': 12866.772, 'weight': 3, 'content': [{'end': 12873.047, 'text': "Do you see, sometimes, When you're auto-completing your statements,", 'start': 12866.772, 'duration': 6.275}, {'end': 12880.631, 'text': 'it will replace one of these functions that you have with the one that you pressed tab for.', 'start': 12873.047, 'duration': 7.584}, {'end': 12887.234, 'text': 'So if I type if or I start to type if and then I come here and click on if, it replaced my rank with if.', 'start': 12880.731, 'duration': 6.503}, {'end': 12893.477, 'text': "So keep an eye out for that if you're like, where did my thing go? It's because I was typing it right next to it.", 'start': 12887.514, 'duration': 5.963}], 'summary': 'Auto-complete replaces functions when pressed; be vigilant to avoid accidental replacements.', 'duration': 26.705, 'max_score': 12866.772, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo12866772.jpg'}], 'start': 11285.769, 'title': 'Data visualization and dashboard creation in tableau', 'summary': 'Covers level of detail calculations and population visualization, data visualization techniques including adjusting time elements, adding forecasts, creating pie charts, and building dashboards, adding filters to visualizations, and dashboard layout creation in tableau, emphasizing the use of containers, filters, actions, and dashboard formatting.', 'chapters': [{'end': 11493.622, 'start': 11285.769, 'title': 'Level of detail calculations and population visualization', 'summary': 'Discusses the use of level of detail calculations to analyze new customers over time and demonstrates the creation of a population visualization dashboard, highlighting the contribution of countries to world population.', 'duration': 207.853, 'highlights': ['The chapter discusses the use of level of detail calculations to analyze new customers over time, with the west region picking up new customers sooner than others.', 'Creation of a population visualization dashboard, demonstrating the use of map-based visualization colored by population total and labeled by percentage contribution of countries.', 'Manual selection of countries with indicators and labels, highlighting that China and India contribute the most to world population.']}, {'end': 12056.13, 'start': 11495.062, 'title': 'Data visualization techniques', 'summary': 'Explores techniques for creating data visualizations, including adjusting time elements, adding forecasts, creating pie charts, and building dashboards, emphasizing the importance of accurately representing data and user communication.', 'duration': 561.068, 'highlights': ['The chapter discusses techniques for adjusting time elements, including changing date values and creating continuous axes, to effectively visualize data over time. The chapter explains the process of adjusting time elements by changing date values and creating continuous axes to effectively visualize data over time.', 'It emphasizes the potential misleading impact of excluding zero on axes, affecting the interpretation of data, and underscores the importance of accurately representing data without misleading users. The chapter stresses the potential misleading impact of excluding zero on axes, emphasizing the importance of accurately representing data without misleading users.', 'The chapter demonstrates the process of adding and customizing forecasts in visualizations, including adjusting the time frame and prediction intervals, to provide insights into future trends. The chapter demonstrates the process of adding and customizing forecasts in visualizations, including adjusting the time frame and prediction intervals to provide insights into future trends.', 'It explains the steps for creating pie charts based on population data, including grouping data, adjusting labels, and visualizing data as a percentage of the total, to effectively represent population distributions. The chapter explains the steps for creating pie charts based on population data, including grouping data, adjusting labels, and visualizing data as a percentage of the total to effectively represent population distributions.', 'It discusses the considerations for building dashboards, including layout options and visualization adjustments, to ensure optimal user experience and data representation. The chapter discusses the considerations for building dashboards, including layout options and visualization adjustments, to ensure an optimal user experience and accurate data representation.']}, {'end': 12382.558, 'start': 12056.51, 'title': 'Adding filters to visualizations', 'summary': 'Discusses the process of adding filters to visualizations, including using actions to filter data based on user interactions and using actual filtering to refine the data, showcasing the impact on various visualizations and the importance of formatting on the dashboard.', 'duration': 326.048, 'highlights': ['Using actions to filter data based on user interactions, such as selecting a country or year, allowing for dynamic updates and refined analysis.', 'Utilizing actual filtering, like adding a year filter, to enable more specific data refinement and analysis, while being cautious of its impact on other visualizations and the need for dashboard-specific formatting.', 'Demonstrating the significance of formatting on dashboards, emphasizing the need to format directly on dashboards rather than workbooks for effective publishing and user experience.']}, {'end': 12893.477, 'start': 12382.638, 'title': 'Dashboard layout and health information', 'summary': 'Discusses creating a dashboard layout in tableau, emphasizing the use of horizontal and vertical containers, filters, actions, and dashboard formatting. it also covers the creation of a map for birth rate rank and the use of classes for categorizing birth rates.', 'duration': 510.839, 'highlights': ['The chapter discusses creating a dashboard layout in Tableau, emphasizing the use of horizontal and vertical containers, filters, actions, and dashboard formatting. Explanation of dashboard layout, use of horizontal and vertical containers, filters, actions, and dashboard formatting.', 'It covers the creation of a map for birth rate rank and the use of classes for categorizing birth rates. Creation of a map for birth rate rank, use of classes for categorizing birth rates based on birth rate averages and ranks.']}], 'duration': 1607.708, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo11285769.jpg', 'highlights': ['The west region picks up new customers sooner than others.', 'Creation of a population visualization dashboard with map-based visualization colored by population total and labeled by percentage contribution of countries.', 'China and India contribute the most to world population.', 'Demonstrates the process of adding and customizing forecasts in visualizations, including adjusting the time frame and prediction intervals.', 'Explains the steps for creating pie charts based on population data, including grouping data, adjusting labels, and visualizing data as a percentage of the total.', 'Using actions to filter data based on user interactions, such as selecting a country or year, allowing for dynamic updates and refined analysis.', 'Demonstrating the significance of formatting on dashboards, emphasizing the need to format directly on dashboards rather than workbooks for effective publishing and user experience.', 'Emphasizing the use of horizontal and vertical containers, filters, actions, and dashboard formatting in creating a dashboard layout in Tableau.']}, {'end': 14049.289, 'segs': [{'end': 13815.552, 'src': 'embed', 'start': 13720.695, 'weight': 0, 'content': [{'end': 13724.097, 'text': 'Another thing to pay attention to is this fixed width.', 'start': 13720.695, 'duration': 3.402}, {'end': 13728.259, 'text': 'So once you start to drag the size on something, it no longer is dynamic.', 'start': 13724.777, 'duration': 3.482}, {'end': 13738.584, 'text': "So if we unfix that width so that it's only taking up whatever space is left.", 'start': 13730.08, 'duration': 8.504}, {'end': 13740.365, 'text': 'Oh, and that one is not fixed width.', 'start': 13738.944, 'duration': 1.421}, {'end': 13746.108, 'text': 'And then we can edit the width on this to be even bigger.', 'start': 13741.726, 'duration': 4.382}, {'end': 13749.59, 'text': 'Then it will squish things over to where we would like them to be.', 'start': 13747.368, 'duration': 2.222}, {'end': 13756.621, 'text': "that's one of the ways you can add space or make things the size you would like them to be.", 'start': 13751.198, 'duration': 5.423}, {'end': 13758.722, 'text': "now let's take a look at filters.", 'start': 13756.621, 'duration': 2.101}, {'end': 13761.884, 'text': 'oh, before we take a look at filters, i want to look at this map one more time,', 'start': 13758.722, 'duration': 3.162}, {'end': 13768.928, 'text': 'because i think that it would be useful for our colors to be a little bit more distinct.', 'start': 13761.884, 'duration': 7.044}, {'end': 13777.673, 'text': "so one quick way to navigate to your worksheet from your dashboard is to click this go to sheet button and while we're here,", 'start': 13768.928, 'duration': 8.745}, {'end': 13781.526, 'text': "i'm going to click on color, edit colors, and we did red and gold.", 'start': 13777.673, 'duration': 3.853}, {'end': 13786.05, 'text': "And we're going to change it from this sequence to a stepped color.", 'start': 13781.906, 'duration': 4.144}, {'end': 13788.892, 'text': "And we're going to change it to three colors.", 'start': 13786.07, 'duration': 2.822}, {'end': 13792.356, 'text': "So it's going to either be this color, this color, this color.", 'start': 13788.932, 'duration': 3.424}, {'end': 13798.101, 'text': "And when I hit OK, you can kind of see it's a little bit more dramatic in our differences.", 'start': 13792.796, 'duration': 5.305}, {'end': 13801.064, 'text': "And it's put everything into the three categories we defined.", 'start': 13798.181, 'duration': 2.883}, {'end': 13803.005, 'text': "So let's go back to our dashboard.", 'start': 13801.744, 'duration': 1.261}, {'end': 13805.628, 'text': 'And we can see the difference there.', 'start': 13803.025, 'duration': 2.603}, {'end': 13809.248, 'text': "And now we're going to take a look at our filters.", 'start': 13807.307, 'duration': 1.941}, {'end': 13812.23, 'text': 'So we want to be able to filter by country.', 'start': 13809.688, 'duration': 2.542}, {'end': 13815.552, 'text': "So let's bring country onto filters.", 'start': 13813.35, 'duration': 2.202}], 'summary': 'Demonstrated adjusting width, color mapping, and applying filters in dashboard.', 'duration': 94.857, 'max_score': 13720.695, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo13720695.jpg'}, {'end': 13860.717, 'src': 'embed', 'start': 13833.891, 'weight': 1, 'content': [{'end': 13843.013, 'text': "And so one disadvantage of doing it on the worksheet is that you can see all of the worksheets in the workbook and you have to differentiate between which ones are on the dashboard and which ones aren't.", 'start': 13833.891, 'duration': 9.122}, {'end': 13845.053, 'text': 'And these are the three on this dashboard.', 'start': 13843.433, 'duration': 1.62}, {'end': 13846.114, 'text': "So we're going to hit okay.", 'start': 13845.093, 'duration': 1.021}, {'end': 13849.874, 'text': "Now we're also going to do it by year.", 'start': 13847.554, 'duration': 2.32}, {'end': 13860.717, 'text': "So when we drag the year onto filters, we're going to allow them to choose years.", 'start': 13849.894, 'duration': 10.823}], 'summary': 'Disadvantage of using worksheet: need to differentiate worksheets on dashboard. three worksheets on dashboard. year filter allows choosing years.', 'duration': 26.826, 'max_score': 13833.891, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo13833891.jpg'}], 'start': 12893.737, 'title': 'Data visualization and analysis', 'summary': 'Covers the process of defining table calculations, using if statements to label birth rates, creating visualizations for birth rate map and average life expectancy, and analyzing data including life expectancy trends, birth rates, health expenditures, and infant mortality rate in tableau.', 'chapters': [{'end': 13053.305, 'start': 12893.737, 'title': 'Table calculation and birth rate labeling', 'summary': 'Explains the process of defining table calculations and using if statements to label birth rates as alarming or normal based on the rank, with the outcome of having both alarming and normal birth rates labeled, and the troubleshooting steps for incorrect labeling.', 'duration': 159.568, 'highlights': ['The process of defining table calculations and using if statements to label birth rates as alarming or normal based on the rank.', 'The outcome of having both alarming and normal birth rates labeled based on the defined if statements.', 'The troubleshooting steps for incorrect labeling including changing the table calculation settings and the compute using dimension.']}, {'end': 13236.647, 'start': 13053.925, 'title': 'Visualizations and blended axis charts', 'summary': 'Discusses creating visualizations for birth rate map and average life expectancy, using blended axis charts to compare male and female life expectancy and addressing issues with axis scaling and overlapping labels.', 'duration': 182.722, 'highlights': ['Creating visualizations for birth rate map and average life expectancy The chapter discusses creating visualizations for birth rate map and average life expectancy, indicating the types of visualizations used and the data being represented.', 'Using blended axis charts to compare male and female life expectancy The chapter explains the process of using blended axis charts to compare male and female life expectancy, highlighting the steps involved in setting up the visualization.', 'Addressing issues with axis scaling and overlapping labels The chapter addresses issues with axis scaling and overlapping labels, highlighting the impact of different chart types and the need to adjust axis scaling for accurate representation of data.']}, {'end': 13792.356, 'start': 13237.467, 'title': 'Data visualization and analysis', 'summary': 'Covers the visualization and analysis of data including life expectancy trends, birth rates, health expenditures, and infant mortality rate, while utilizing tableau to create visualizations such as line graphs, heat maps, and dashboards.', 'duration': 554.889, 'highlights': ['The visualization shows the average life expectancy over time for both genders increasing, with higher life expectancy for females. The average life expectancy for both genders is shown to be increasing over time, with females having higher life expectancy.', 'The forecast predicts the life expectancy for both genders over the next two years, and the trend analysis is performed using different visualizations. The forecast predicts the life expectancy for both genders over the next two years, and different visualizations are used for trend analysis.', 'A heat map is created to compare different measures such as birth rates, health expenditures, and infant mortality rates across different countries, with the ability to view the data independently. A heat map is created to compare birth rates, health expenditures, and infant mortality rates across countries, allowing independent data visualization.', 'The process of formatting data fields, changing from sum to average, and customizing color palettes for better data visualization is demonstrated. The process of formatting data fields, changing from sum to average, and customizing color palettes for better data visualization is demonstrated.', "The creation of a dashboard named 'health dashboard' is shown, which includes visualizations such as maps, heat maps, and life expectancy lines, along with the arrangement of legends and adjustments for visual clarity. The creation of a dashboard named 'health dashboard' is shown, which includes visualizations such as maps, heat maps, and life expectancy lines, along with the arrangement of legends and adjustments for visual clarity.", 'The process of adjusting visualization sizes, using dynamic widths, and utilizing filters for improved data presentation is explained. The process of adjusting visualization sizes, using dynamic widths, and utilizing filters for improved data presentation is explained.']}, {'end': 14049.289, 'start': 13792.796, 'title': 'Dashboard filters and visualization', 'summary': 'Covers setting up filters for country and year, applying them to specific worksheets, and adjusting the display of filters to enhance the health dashboard and prepare for an upcoming dashboard on the economy.', 'duration': 256.493, 'highlights': ['Setting up filters for country and year and applying them to specific worksheets. Demonstrates the process of setting up filters for country and year and applying them to specific worksheets to enhance data visualization.', 'Adjusting the display of filters to improve the layout of the health dashboard. Illustrates the process of adjusting the display of filters to improve the layout of the health dashboard, including changing the width and type of drop-down for country and year filters.', 'Preparation for an upcoming dashboard on the economy, specifically focusing on GDP. Mentions the preparation for an upcoming dashboard on the economy, with the first sheet intended to display a map related to overall GDP, indicating a shift in focus from health to economy data visualization.']}], 'duration': 1155.552, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo12893737.jpg', 'highlights': ['The process of defining table calculations and using if statements to label birth rates as alarming or normal based on the rank.', 'Creating visualizations for birth rate map and average life expectancy, indicating the types of visualizations used and the data being represented.', 'The visualization shows the average life expectancy over time for both genders increasing, with higher life expectancy for females.', 'A heat map is created to compare birth rates, health expenditures, and infant mortality rates across countries, allowing independent data visualization.', 'Setting up filters for country and year and applying them to specific worksheets.', 'Preparation for an upcoming dashboard on the economy, specifically focusing on GDP.']}, {'end': 15470.829, 'segs': [{'end': 14124.976, 'src': 'embed', 'start': 14082.882, 'weight': 1, 'content': [{'end': 14102.695, 'text': 'Hmm Okay, red for there, and then we want to do maybe like a deeper green, and that way you can see who has the highest GDP, which is green.', 'start': 14082.882, 'duration': 19.813}, {'end': 14111.402, 'text': 'We hit apply, okay, and then it will eventually get lighter and lighter until it goes to gray, which then it will lead to green.', 'start': 14103.276, 'duration': 8.126}, {'end': 14118.167, 'text': "Okay And next we're going to make scatterplot.", 'start': 14112.202, 'duration': 5.965}, {'end': 14124.976, 'text': 'which we will call GDP versus GDP per capita.', 'start': 14120.233, 'duration': 4.743}], 'summary': 'Using colors to represent gdp and creating scatterplot for gdp versus gdp per capita.', 'duration': 42.094, 'max_score': 14082.882, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo14082882.jpg'}, {'end': 14625.727, 'src': 'embed', 'start': 14577.905, 'weight': 3, 'content': [{'end': 14583.469, 'text': 'So you could right click on it and click exclude and then it will exclude it from your data set very quickly.', 'start': 14577.905, 'duration': 5.564}, {'end': 14586.972, 'text': "And then it'll just click this back button to get it back.", 'start': 14584.89, 'duration': 2.082}, {'end': 14591.695, 'text': "Great Now let's take a look at filters.", 'start': 14589.494, 'duration': 2.201}, {'end': 14595.198, 'text': 'We are going to do a single filter.', 'start': 14593.337, 'duration': 1.861}, {'end': 14600.298, 'text': "So let's go to this visualization and we'll bring on country.", 'start': 14596.857, 'duration': 3.441}, {'end': 14602.359, 'text': "We'll click use all.", 'start': 14601.339, 'duration': 1.02}, {'end': 14606.26, 'text': "Okay Now we're going to apply it to worksheets.", 'start': 14602.379, 'duration': 3.881}, {'end': 14608.641, 'text': 'So I showed you how we can apply it to worksheets here.', 'start': 14606.56, 'duration': 2.081}, {'end': 14612.282, 'text': "You can also apply it to worksheets once it's on the dashboard.", 'start': 14609.761, 'duration': 2.521}, {'end': 14617.124, 'text': 'So if we come here and look at filters, we can see that country is on the filters for this visualization.', 'start': 14612.762, 'duration': 4.362}, {'end': 14625.727, 'text': "But if we come down here and look at filters, we still see country because it's in the details of the information.", 'start': 14617.764, 'duration': 7.963}], 'summary': 'Demonstrating quick exclusion of data and applying single filter to worksheets', 'duration': 47.822, 'max_score': 14577.905, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo14577905.jpg'}, {'end': 15171.39, 'src': 'embed', 'start': 15130.677, 'weight': 4, 'content': [{'end': 15134.44, 'text': 'So you could just grab ease of business and drag it into the dialog box here.', 'start': 15130.677, 'duration': 3.763}, {'end': 15135.681, 'text': "And that's really nice.", 'start': 15134.901, 'duration': 0.78}, {'end': 15147.633, 'text': "So we're going to say if it is greater than or equal to one and less than or equal to three,", 'start': 15135.881, 'duration': 11.752}, {'end': 15163.644, 'text': "then we're going to say it has the most business friendly regulations.", 'start': 15147.633, 'duration': 16.011}, {'end': 15171.39, 'text': 'Give us a little more room to look at.', 'start': 15170.189, 'duration': 1.201}], 'summary': 'Ease of business: 1-3 = most business friendly regulations.', 'duration': 40.713, 'max_score': 15130.677, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo15130677.jpg'}, {'end': 15470.829, 'src': 'embed', 'start': 15416.331, 'weight': 0, 'content': [{'end': 15432.837, 'text': 'but you can also see that there are places that have even lower tax rates, like Saudi Arabia, and we have 8% here.', 'start': 15416.331, 'duration': 16.506}, {'end': 15438.88, 'text': "it looks like we don't ever go to that second decimal place.", 'start': 15432.837, 'duration': 6.043}, {'end': 15448.633, 'text': "so let's quickly format this.", 'start': 15438.88, 'duration': 9.753}, {'end': 15453.617, 'text': 'oh, business tax rate is also text.', 'start': 15448.633, 'duration': 4.984}, {'end': 15470.829, 'text': 'so if we could convert our data type to decimal and then we will format it to be a percentage and we just need the one decimal place.', 'start': 15453.617, 'duration': 17.212}], 'summary': 'Comparing tax rates, 8% in contrast to lower rates like in saudi arabia.', 'duration': 54.498, 'max_score': 15416.331, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo15416331.jpg'}], 'start': 14050.75, 'title': 'Data visualization for business analysis', 'summary': 'Covers creating gdp maps, scatterplots, and tableau visualizations to analyze gdp, healthcare data, and business-friendly markets, including region-wise variations and ease of doing business in different countries.', 'chapters': [{'end': 14151.112, 'start': 14050.75, 'title': 'Data visualization: gdp mapping and scatterplot creation', 'summary': 'Demonstrates creating a map with gdp data represented by color intensity and then proceeds to create a scatterplot to compare gdp with gdp per capita.', 'duration': 100.362, 'highlights': ['Creating a map with GDP data represented by color intensity, allowing easy visualization of countries with the highest GDP.', 'Demonstrating the creation of a scatterplot to compare GDP with GDP per capita, illustrating the correlation between these two measures.']}, {'end': 14606.26, 'start': 14153.393, 'title': 'Visualizing gdp and healthcare data', 'summary': 'Explores visualizing gdp and healthcare data to analyze gdp per capita, healthcare expenses as a percentage of gdp, and region-wise variations, using tableau visualizations.', 'duration': 452.867, 'highlights': ["Visualizing GDP per capita by summing up the GDP across various dimensions and dividing it by the total population provides insights into countries' economic well-being.", "Analyzing healthcare expenses as a percentage of GDP and per capita helps identify countries' healthcare spending patterns and disparities.", 'Utilizing Tableau features like color-coded regions, customized tooltips, and filtering options enhances the visualization and analysis of the data.']}, {'end': 14858.585, 'start': 14606.56, 'title': 'Dashboard customization and country analysis', 'summary': 'Demonstrates how to customize a dashboard to affect all worksheets and add url actions for country data, enabling users to filter visualizations and navigate to wikipedia pages, while also creating a bar chart to analyze the ease of doing business in different countries.', 'duration': 252.025, 'highlights': ['The chapter explains how to customize a dashboard to affect all worksheets, allowing the selection of different countries to impact all three worksheets simultaneously. The customization enables the selection of different countries to affect all three worksheets simultaneously, improving user interaction and analysis.', "The demonstration includes adding URL actions for country data, allowing users to navigate to Wikipedia pages specifically related to the economy of the selected country. The addition of URL actions enables users to navigate to Wikipedia pages specifically related to the economy of the selected country, enhancing the dashboard's informational value.", 'The chapter also covers creating a bar chart to analyze the ease of doing business in different countries, providing valuable insight into the time it takes to start a business in each country. The creation of a bar chart enables the analysis of the ease of doing business in different countries, providing valuable insight into the time it takes to start a business in each country.']}, {'end': 15470.829, 'start': 14859.425, 'title': 'Analysis of business-friendly markets', 'summary': 'Discusses the analysis of business-friendly markets, filtering based on days to start a business, visualizing ease of business, and categorizing business regulations based on ease of business ratings.', 'duration': 611.404, 'highlights': ['The chapter discusses filtering countries based on a good market, defined by the number of days it takes to start a business, with a threshold of 25 days.', 'It explains the visualization of ease of business using a bar chart, converting ease of business to a measure, and filtering out data without ease of business ratings.', 'The chapter details the categorization of business regulations based on ease of business ratings, grouping them as most business-friendly, moderate, strict, and not preferred for business, and visualizing them by region and business tax rates.']}], 'duration': 1420.079, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo14050750.jpg', 'highlights': ['Creating a map with GDP data represented by color intensity for easy visualization of countries with the highest GDP.', 'Demonstrating the creation of a scatterplot to compare GDP with GDP per capita, illustrating the correlation between these two measures.', "Analyzing healthcare expenses as a percentage of GDP and per capita to identify countries' healthcare spending patterns and disparities.", 'Utilizing Tableau features like color-coded regions, customized tooltips, and filtering options to enhance visualization and analysis of the data.', 'Customizing a dashboard to affect all worksheets, allowing the selection of different countries to impact all three worksheets simultaneously, improving user interaction and analysis.', "Adding URL actions for country data, enabling users to navigate to Wikipedia pages specifically related to the economy of the selected country, enhancing the dashboard's informational value.", 'Creating a bar chart to analyze the ease of doing business in different countries, providing valuable insight into the time it takes to start a business in each country.', 'Filtering countries based on a good market, defined by the number of days it takes to start a business, with a threshold of 25 days.', 'Visualizing ease of business using a bar chart, converting ease of business to a measure, and filtering out data without ease of business ratings.', 'Categorizing business regulations based on ease of business ratings, grouping them as most business-friendly, moderate, strict, and not preferred for business, and visualizing them by region and business tax rates.']}, {'end': 17372.277, 'segs': [{'end': 16083.49, 'src': 'embed', 'start': 16053.902, 'weight': 1, 'content': [{'end': 16062.487, 'text': "We're going to add the apply button and now we're going to make it apply to all the visualizations by clicking apply to workbooks,", 'start': 16053.902, 'duration': 8.585}, {'end': 16065.549, 'text': 'selected worksheets, all on dashboard okay.', 'start': 16062.487, 'duration': 3.062}, {'end': 16075.114, 'text': 'Now we can see that if we just want to look at Afghanistan, okay, we can see how many days it takes to start a business there.', 'start': 16066.93, 'duration': 8.184}, {'end': 16078.616, 'text': "It's not preferred for business and it's internet and phone.", 'start': 16075.595, 'duration': 3.021}, {'end': 16083.49, 'text': 'usage over time.', 'start': 16082.569, 'duration': 0.921}], 'summary': 'Apply button added to visualize data across visualizations and compare business conditions in afghanistan.', 'duration': 29.588, 'max_score': 16053.902, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo16053902.jpg'}, {'end': 16200.347, 'src': 'embed', 'start': 16170.699, 'weight': 0, 'content': [{'end': 16175.162, 'text': "So after you've put together a data set, you can publish it out and more people can use it than just you.", 'start': 16170.699, 'duration': 4.463}, {'end': 16176.543, 'text': 'That sounds interesting.', 'start': 16175.582, 'duration': 0.961}, {'end': 16181.285, 'text': "How about we visually show the stats of IPL? So first we'll look at connecting to data.", 'start': 16176.683, 'duration': 4.602}, {'end': 16183.327, 'text': 'This will be the first step in Tableau.', 'start': 16181.586, 'duration': 1.741}, {'end': 16192.152, 'text': "So if you've opened up your workbook and you see this page, you can click here, connect to data, and we're going to choose a text file.", 'start': 16184.487, 'duration': 7.665}, {'end': 16200.347, 'text': "and we're going to join our deliveries data to our matches data.", 'start': 16193.558, 'duration': 6.789}], 'summary': 'After assembling a dataset, it can be shared for wider usage. in tableau, connect to data and join deliveries to matches data.', 'duration': 29.648, 'max_score': 16170.699, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo16170699.jpg'}, {'end': 16269.263, 'src': 'embed', 'start': 16245.373, 'weight': 2, 'content': [{'end': 16255.12, 'text': "And so since these two don't match, since we have two, two, three, three, but then we have four and six, these two don't exist in our resulting table.", 'start': 16245.373, 'duration': 9.747}, {'end': 16257.72, 'text': "because they don't have matches in both tables.", 'start': 16255.66, 'duration': 2.06}, {'end': 16265.542, 'text': 'In a left join, resulting table contains all values from the left table and the corresponding matches from the right table.', 'start': 16258.201, 'duration': 7.341}, {'end': 16269.263, 'text': 'So we have Delhi, Chennai, and Bangalore, and then we have their matches.', 'start': 16265.902, 'duration': 3.361}], 'summary': 'Left join retains values from left table and corresponding matches from right table.', 'duration': 23.89, 'max_score': 16245.373, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo16245373.jpg'}, {'end': 16855.769, 'src': 'embed', 'start': 16830.358, 'weight': 4, 'content': [{'end': 16835.182, 'text': 'but if I want to change the order of that, see how it does the count and then the city?', 'start': 16830.358, 'duration': 4.824}, {'end': 16838.364, 'text': 'I could drag.', 'start': 16837.783, 'duration': 0.581}, {'end': 16842.018, 'text': 'so you saw, right inside of here we have two that are on label.', 'start': 16839.156, 'duration': 2.862}, {'end': 16848.824, 'text': 'so they have this little t inside of a box and now city is on top of count of id.', 'start': 16842.018, 'duration': 6.806}, {'end': 16851.946, 'text': 'so city and then count.', 'start': 16848.824, 'duration': 3.122}, {'end': 16855.769, 'text': 'we could also allow people to filter.', 'start': 16851.946, 'duration': 3.823}], 'summary': 'Demonstrating rearranging and filtering data in a software interface.', 'duration': 25.411, 'max_score': 16830.358, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo16830358.jpg'}], 'start': 15474.83, 'title': 'Data visualization and analysis', 'summary': 'Covers creating business visualizations, visualization best practices, tableau data visualization, visualizing data in tableau, visualizing cricket match data, and analyzing the toss decision impact on match win percentage, with insights such as 60% matches won by teams choosing to field and 39% by teams choosing to bat.', 'chapters': [{'end': 15924.88, 'start': 15474.83, 'title': 'Creating business visualizations', 'summary': 'Covers creating annotations and visualizations on business-friendly countries, business taxes, phone and internet usage trends, and dashboard creation, with a focus on using tableau.', 'duration': 450.05, 'highlights': ['Creating annotations on business-friendly countries and business tax rates using Tableau The user demonstrates how to annotate a mark in Tableau, highlighting the most business-friendly country with a business tax rate and correcting an annotation typo for Singapore.', 'Visualizing phone and internet usage trends for business insights The chapter explains the process of creating visualizations for phone and internet usage trends over time, utilizing Tableau to show average usage across countries and customizing visualization styles.', 'Dashboard creation for ease of business analysis The user showcases the creation of a dashboard in Tableau, incorporating visualizations for ease of business, phone and internet usage, and demonstrating the use of filters and legends for data analysis.']}, {'end': 16083.49, 'start': 15924.88, 'title': 'Visualization best practices', 'summary': 'Discusses the best practices for visualization, including filtering, title customization, and highlighting, with examples of using filters to analyze business-friendly regulations and internet and phone usage in different countries.', 'duration': 158.61, 'highlights': ['Explaining the purpose of using floating filters to clarify their effect on specific visualizations. Floating filters are useful to clarify the visualization they affect, avoiding confusion for users.', 'Emphasizing the importance of customizing visualization titles to be more business or user friendly. Customizing visualization titles to be more user-friendly or business-oriented is essential for effective communication.', 'Demonstrating the use of filters to analyze business-friendly regulations and internet and phone usage in different countries. Using filters to analyze business-friendly regulations and internet and phone usage in different countries provides insights into adoption and changes over time.']}, {'end': 16687.777, 'start': 16085.712, 'title': 'Tableau data visualization', 'summary': 'Discusses the use of tableau for data visualization, highlighting its importance, advantages, and practical application in creating interactive charts and graphs, as well as utilizing joins, dimensions, measures, and designing dashboards for visual data analysis.', 'duration': 602.065, 'highlights': ["Tableau's importance and advantages Tableau is important for visualization, offering advantages such as speed of analysis, self-reliance, visual discovery, blending diverse data sets, and centralized data usage.", 'Using joins for multiple datasets The discussion covers the use of joins in Tableau, explaining inner join, left join, right join, and full outer join for combining multiple datasets based on matching values and corresponding nulls.', 'Understanding dimensions and measures The concept of dimensions and measures in Tableau is explained, highlighting dimensions as qualitative fields and measures as numerical values used for mathematical functions and aggregation.', 'Designing dashboards and visualizations The chapter provides insights into designing dashboards and visualizations in Tableau, including creating worksheets, building visualizations, and utilizing dimensions and measures for data analysis.']}, {'end': 16855.769, 'start': 16687.858, 'title': 'Visualizing data in tableau', 'summary': 'Demonstrates the process of visualizing data in tableau, including using dimensions and measures to create a dynamic and interactive visualization, as well as customizing the appearance and labels for better presentation and understanding of the data.', 'duration': 167.911, 'highlights': ['Using dimensions and measures to create a dynamic visualization The speaker demonstrates using city and country as dimensions and ID as a measure to create a dynamic visualization that adjusts the size and color of circles based on the data.', 'Customizing the appearance and labels for better presentation The chapter explains the process of customizing the appearance by adjusting the size, color, and opacity of the visualization, as well as adding labels with city names and count of IDs for improved presentation and understanding.']}, {'end': 17086.331, 'start': 16855.769, 'title': 'Visualizing cricket match data', 'summary': 'Demonstrates creating visualizations for cricket match data, including filtering by city and batsman runs, and analyzing win percentage based on toss decision.', 'duration': 230.562, 'highlights': ['Creating a tree map visualization to display batsmen with the most runs, with Mumbai identified as the city with the most runs associated with it.', 'Filtering out batsmen and cities with a total of runs less than 400, refining the visualization to display only relevant data.', 'Analyzing win percentage based on toss decision to determine which decision leads to a win more often, offering insights for strategic decision-making in cricket matches.']}, {'end': 17372.277, 'start': 17087.372, 'title': 'Toss decision impact on match win', 'summary': 'Analyzes the impact of toss decision on match win percentage, revealing that 60% of matches were won by teams choosing to field, compared to 39% by teams choosing to bat, and demonstrates the use of annotations and filters to provide dynamic insights.', 'duration': 284.905, 'highlights': ['60% of the matches were won by the people who chose field, while 39% were won by the people who chose bat. The data shows that teams choosing to field won 60% of the matches, while teams choosing to bat won 39%, indicating a significant impact of toss decision on match win percentage.', "Demonstrates the use of annotations and filters to provide dynamic insights. The chapter illustrates how annotations and filters can be utilized to provide dynamic insights, allowing for interactive and contextual exploration of the data, enhancing the visualization's interpretability and usability.", 'Exploration of the impact of toss decision on match win percentage. The exploration focuses on understanding the impact of toss decision on match win percentage, providing valuable insights into the relationship between toss decision and the likelihood of winning the game.']}], 'duration': 1897.447, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo15474830.jpg', 'highlights': ['60% of the matches were won by the people who chose field, while 39% were won by the people who chose bat. The data shows that teams choosing to field won 60% of the matches, while teams choosing to bat won 39%, indicating a significant impact of toss decision on match win percentage.', 'Using dimensions and measures to create a dynamic visualization The speaker demonstrates using city and country as dimensions and ID as a measure to create a dynamic visualization that adjusts the size and color of circles based on the data.', 'Creating a tree map visualization to display batsmen with the most runs, with Mumbai identified as the city with the most runs associated with it.', 'Exploration of the impact of toss decision on match win percentage. The exploration focuses on understanding the impact of toss decision on match win percentage, providing valuable insights into the relationship between toss decision and the likelihood of winning the game.', "Demonstrates the use of annotations and filters to provide dynamic insights. The chapter illustrates how annotations and filters can be utilized to provide dynamic insights, allowing for interactive and contextual exploration of the data, enhancing the visualization's interpretability and usability.", 'Dashboard creation for ease of business analysis The user showcases the creation of a dashboard in Tableau, incorporating visualizations for ease of business, phone and internet usage, and demonstrating the use of filters and legends for data analysis.']}, {'end': 21569.962, 'segs': [{'end': 17420.14, 'src': 'embed', 'start': 17372.897, 'weight': 0, 'content': [{'end': 17377.838, 'text': "So we're going to call this advantage of toss winning.", 'start': 17372.897, 'duration': 4.941}, {'end': 17399.119, 'text': "So we're going to bring on all of the toss winning teams and we're going to also bring on all of the teams that actually won.", 'start': 17380.706, 'duration': 18.413}, {'end': 17408.165, 'text': 'So how it works is we can see all the teams and then you can see if they won or not.', 'start': 17399.359, 'duration': 8.806}, {'end': 17413.334, 'text': "So we're going to quickly make a couple of changes to this.", 'start': 17408.405, 'duration': 4.929}, {'end': 17420.14, 'text': 'the first one is this team changed its name to this team name.', 'start': 17413.334, 'duration': 6.806}], 'summary': 'Analyzing impact of toss winning on match outcomes and team changes.', 'duration': 47.243, 'max_score': 17372.897, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo17372897.jpg'}, {'end': 19551.122, 'src': 'embed', 'start': 19524.096, 'weight': 10, 'content': [{'end': 19530.277, 'text': "so we'll pull runs out here onto rows and it now gives us bars for all of those rows.", 'start': 19524.096, 'duration': 6.181}, {'end': 19537.559, 'text': "if we were looking at multiple batsmen so I select all here it'll section them out by their names,", 'start': 19530.277, 'duration': 7.282}, {'end': 19541.72, 'text': "but it's a little bit difficult to tell where one batsman ends and one begins.", 'start': 19537.559, 'duration': 4.161}, {'end': 19546.001, 'text': "sometimes just it's not that visually easy, even though there are lines.", 'start': 19541.72, 'duration': 4.281}, {'end': 19547.802, 'text': 'so we could make those lines darker.', 'start': 19546.001, 'duration': 1.801}, {'end': 19551.122, 'text': 'or another thing we could do is take batsmen and pull it onto color,', 'start': 19547.802, 'duration': 3.32}], 'summary': 'Data visualization tool can improve clarity by using color and darker lines for better distinction.', 'duration': 27.026, 'max_score': 19524.096, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo19524096.jpg'}, {'end': 20014.292, 'src': 'embed', 'start': 19964.935, 'weight': 5, 'content': [{'end': 19968.877, 'text': "And it's just trying to make it darker or lighter depending on how many runs there were.", 'start': 19964.935, 'duration': 3.942}, {'end': 19970.357, 'text': "But that's not what I want.", 'start': 19969.257, 'duration': 1.1}, {'end': 19972.918, 'text': 'I want to use it as a dimension.', 'start': 19970.817, 'duration': 2.101}, {'end': 19975.94, 'text': 'And now we can see we have zero through six.', 'start': 19973.699, 'duration': 2.241}, {'end': 19983.903, 'text': 'And that means that a batsman either has zero runs or one, two, four, or six runs.', 'start': 19976.72, 'duration': 7.183}, {'end': 19986.504, 'text': 'Now there is three runs as well.', 'start': 19984.723, 'duration': 1.781}, {'end': 19992.286, 'text': "However, because we're only selecting one year, and one batsman.", 'start': 19986.584, 'duration': 5.702}, {'end': 19999.368, 'text': 'This particular batsman for this particular year only had either zero runs, one run, two, four, or six.', 'start': 19992.826, 'duration': 6.542}, {'end': 20006.27, 'text': "So when we change it to a dimension, it's now, instead of summing up all of the runs, it is now just showing you their options.", 'start': 19999.688, 'duration': 6.582}, {'end': 20010.191, 'text': "But it's still doing it like a scale from light to dark.", 'start': 20006.87, 'duration': 3.321}, {'end': 20014.292, 'text': 'I want six distinct colors, one for each.', 'start': 20010.731, 'duration': 3.561}], 'summary': 'Using runs as a dimension, showing options from 0 to 6, with 6 distinct colors.', 'duration': 49.357, 'max_score': 19964.935, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo19964935.jpg'}, {'end': 20103.546, 'src': 'embed', 'start': 20071.775, 'weight': 4, 'content': [{'end': 20077.661, 'text': "We don't want to take every time that he got a 6 and do 6 plus 6 plus 6 plus 6.", 'start': 20071.775, 'duration': 5.886}, {'end': 20081.043, 'text': 'What we want to do is count how many times he got a 6.', 'start': 20077.661, 'duration': 3.382}, {'end': 20084.847, 'text': "So we're going to change it from a sum to a count.", 'start': 20081.043, 'duration': 3.804}, {'end': 20087.589, 'text': 'And you can see he got a 6 24 times.', 'start': 20085.988, 'duration': 1.601}, {'end': 20090.292, 'text': "And so before, let's go back.", 'start': 20089.131, 'duration': 1.161}, {'end': 20103.546, 'text': 'It was taking 24 and timesing it by 6, which is 144, and summing up each of those times.', 'start': 20094.58, 'duration': 8.966}], 'summary': 'The number 6 appeared 24 times in the data.', 'duration': 31.771, 'max_score': 20071.775, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo20071775.jpg'}, {'end': 20185.659, 'src': 'embed', 'start': 20154.743, 'weight': 3, 'content': [{'end': 20156.364, 'text': 'Number of records is a little bit simpler.', 'start': 20154.743, 'duration': 1.621}, {'end': 20169.416, 'text': "So let's also bring number of records onto the label, and we can see quickly that mostly he got ones and got more fours than he got twos actually,", 'start': 20156.845, 'duration': 12.571}, {'end': 20175.322, 'text': 'which might be interesting to people who are trying to see how well this batsman does.', 'start': 20169.416, 'duration': 5.906}, {'end': 20179.894, 'text': 'Our next visualization has to do with the batsman strike rate.', 'start': 20176.451, 'duration': 3.443}, {'end': 20185.659, 'text': "So we'll make our new sheet, season strike rate.", 'start': 20181.235, 'duration': 4.424}], 'summary': 'Batsman mostly got fours, and strike rate is next visualization.', 'duration': 30.916, 'max_score': 20154.743, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo20154743.jpg'}, {'end': 20778.952, 'src': 'embed', 'start': 20747.455, 'weight': 8, 'content': [{'end': 20748.836, 'text': "So I'm going to click on dashboard here.", 'start': 20747.455, 'duration': 1.381}, {'end': 20754.078, 'text': "I'm going to change it to automatic size, which will fill my screen.", 'start': 20749.536, 'duration': 4.542}, {'end': 20756.339, 'text': "I'm going to change it back to fixed size.", 'start': 20754.498, 'duration': 1.841}, {'end': 20761.701, 'text': 'So now we have our width and our height based on what automatic size was.', 'start': 20756.719, 'duration': 4.982}, {'end': 20764.942, 'text': "Let's just round it out a little bit.", 'start': 20762.301, 'duration': 2.641}, {'end': 20776.149, 'text': "So instead of 1678, I'm going to change it to be Just an even 1600 and same even 900.", 'start': 20765.022, 'duration': 11.127}, {'end': 20778.952, 'text': 'So now we have our fixed size here.', 'start': 20776.149, 'duration': 2.803}], 'summary': 'Adjusting dashboard size from automatic to fixed, now set at 1600x900.', 'duration': 31.497, 'max_score': 20747.455, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo20747455.jpg'}, {'end': 21315.619, 'src': 'embed', 'start': 21291.566, 'weight': 7, 'content': [{'end': 21299.189, 'text': 'You see, the color that we selected before for the background is in this little palette of recently used colors,', 'start': 21291.566, 'duration': 7.623}, {'end': 21304.331, 'text': "and I want one slightly different than that, so I'm just going to enter in the one that I want.", 'start': 21299.189, 'duration': 5.142}, {'end': 21307.493, 'text': "And I'll copy that so I can use it on the others.", 'start': 21305.371, 'duration': 2.122}, {'end': 21312.957, 'text': 'However, if I did want the same color as I had there, I could just select it right at the recently used colors.', 'start': 21308.313, 'duration': 4.644}, {'end': 21315.619, 'text': 'Okay And there we go.', 'start': 21313.217, 'duration': 2.402}], 'summary': 'Selecting a different color for the background and copying it for future use.', 'duration': 24.053, 'max_score': 21291.566, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo21291566.jpg'}], 'start': 17372.897, 'title': 'Analyzing cricket data', 'summary': 'Discusses the advantage of winning the toss, data analysis in tableau, parameter-based data visualization, creating dashboards, pie charts, and specific focus on batsmen and bowlers dashboards, offering insights into match outcomes and player performance.', 'chapters': [{'end': 17451.706, 'start': 17372.897, 'title': 'Toss winning advantage analysis', 'summary': 'Discusses the analysis of the advantage of winning the toss and its impact on match outcomes, including grouping teams by winners and making changes to team names for better analysis.', 'duration': 78.809, 'highlights': ['The chapter discusses the analysis of the advantage of winning the toss and its impact on match outcomes.', 'Teams are grouped based on winners, and changes are made to team names for better analysis.', 'The chapter emphasizes the importance of analyzing the correlation between toss winning and match outcomes.']}, {'end': 18063.35, 'start': 17453.126, 'title': 'Data analysis in tableau', 'summary': 'Discusses the manual creation and updating of groups in tableau, excluding data based on specific criteria, analyzing the correlation between toss winners and game winners, and utilizing visualizations to explore batting team performance, leading batsmen, and the use of filters and parameters for data analysis.', 'duration': 610.224, 'highlights': ['The chapter discusses the manual creation and updating of groups in Tableau Manually creating and updating groups in Tableau can be cumbersome and time-consuming, requiring manual effort to create and update the groups, especially when dealing with changing data sources.', 'Analyzing the correlation between toss winners and game winners The analysis reveals a correlation between toss winners and game winners, with specific teams having a higher likelihood of winning when they win the toss, illustrated through visualizations and percentage calculations.', 'Utilizing visualizations to explore batting team performance and leading batsmen Visualizations are used to explore batting team performance and leading batsmen, allowing for the identification of top performers and the ability to filter and analyze the data based on team, year, and specific criteria.']}, {'end': 18560.761, 'start': 18063.37, 'title': 'Parameter-based data visualization', 'summary': 'Discusses leveraging parameters to dynamically filter and visualize data, allowing users to choose the number of data points to display, and creating visualizations for top batsmen and bowlers based on runs and dismissals over time.', 'duration': 497.391, 'highlights': ['Users can dynamically choose the number of data points to display using parameters, providing flexibility and interactivity for data visualization.', 'Visualizations are created to display the top five batsmen and bowlers based on runs and dismissals over time, offering insights into player performance.', 'Parameters can be customized to allow users to select a range of data points, and visualizations can be tailored to showcase specific metrics such as batsman runs and dismissals for bowlers.', 'The process involves sorting and organizing data for effective visualization, enabling the identification of top performers and trends over time.', 'Creating dashboards for the visualizations facilitates the presentation and analysis of key metrics and trends in a comprehensive and interactive format.']}, {'end': 19764.12, 'start': 18561.642, 'title': 'Creating dashboards in tableau', 'summary': "Discusses creating dashboards in tableau, emphasizing the importance of space allocation, layout adjustments, filtering techniques, and visualization customization. it also covers the use cases behind the visualizations, such as analyzing batsmen and bowlers' performance and understanding the impact of different actions and filters on the dashboards.", 'duration': 1202.478, 'highlights': ['Space Allocation and Layout Adjustments The importance of space allocation and layout adjustments is highlighted, emphasizing the need for extra space in visualizations and the options for automatic, minimum, and maximum size adjustments based on screen resolutions.', 'Filtering Techniques and Visualization Customization The use of filters to show specific data, such as filtering out runs scored less than 100, and visualization customization, including creating pie charts and applying color and angle to visualize data effectively.', 'Impact of Actions and Filters on Dashboards The impact of actions and filters on dashboards is demonstrated, including the use of actions to filter remaining sheets based on selected city and the application of filters to affect selected worksheets or all worksheets.', "Understanding Use Cases and Data Visualization The chapter discusses use cases behind the visualizations, such as analyzing batsmen and bowlers' performance, understanding the impact of different actions and filters on the dashboards, and the importance of visualizing data effectively for decision-making."]}, {'end': 20490.473, 'start': 19764.48, 'title': 'Creating pie charts and visualizations', 'summary': 'Demonstrates creating pie charts and visualizations, including changing dimensions to measures, determining angles and counts, and calculating strike rate for batsmen.', 'duration': 725.993, 'highlights': ['Creating pie charts and visualizations The chapter primarily focuses on creating pie charts and visualizations for analyzing cricket data, including dismissal kinds, runs distribution, and strike rate.', 'Changing dimensions to measures The process of changing dismissal kinds from a dimension to a measure to determine the size of the angles in the pie chart is explained, leading to accurate representation of the data.', 'Determining angles and counts The chapter explains the method of determining the size of angles in the pie chart by counting the dismissal kinds and the batsman runs, ensuring accurate visualization of the data.', 'Calculating strike rate for batsmen The process of calculating the strike rate for batsmen by dividing the total runs by the number of balls bowled, and visualizing it over time, is demonstrated.']}, {'end': 21569.962, 'start': 20490.793, 'title': 'Creating batsmen and bowler dashboards', 'summary': "Covers creating calculated fields for 'balls per boundary' and 'boundaries count', building and formatting the batsmen dashboard, and starting on the bowler dashboard, with a focus on visualizations and layout.", 'duration': 1079.169, 'highlights': ["Creating calculated fields for 'balls per boundary' and 'boundaries count' The chapter provides a detailed explanation of creating calculated fields for 'balls per boundary' and 'boundaries count', including the use of if statements and summing up to count boundaries.", 'Building and formatting the batsmen dashboard The process of building the batsmen dashboard is explained, including steps for automatic and fixed size, dashboard title and visualizations formatting, and using floating visualizations for layout.', 'Starting on the bowler dashboard, with a focus on visualizations and layout The beginning steps of creating the bowler dashboard are highlighted, focusing on visualizations for bowler performance against teams and the layout considerations for the dashboard.']}], 'duration': 4197.065, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo17372897.jpg', 'highlights': ['The chapter emphasizes the importance of analyzing the correlation between toss winning and match outcomes.', 'The analysis reveals a correlation between toss winners and game winners, with specific teams having a higher likelihood of winning when they win the toss, illustrated through visualizations and percentage calculations.', 'Visualizations are used to explore batting team performance and leading batsmen, allowing for the identification of top performers and the ability to filter and analyze the data based on team, year, and specific criteria.', 'Parameters can be customized to allow users to select a range of data points, and visualizations can be tailored to showcase specific metrics such as batsman runs and dismissals for bowlers.', 'Creating dashboards for the visualizations facilitates the presentation and analysis of key metrics and trends in a comprehensive and interactive format.', 'The importance of space allocation and layout adjustments is highlighted, emphasizing the need for extra space in visualizations and the options for automatic, minimum, and maximum size adjustments based on screen resolutions.', "The chapter discusses use cases behind the visualizations, such as analyzing batsmen and bowlers' performance, understanding the impact of different actions and filters on the dashboards, and the importance of visualizing data effectively for decision-making.", 'The chapter primarily focuses on creating pie charts and visualizations for analyzing cricket data, including dismissal kinds, runs distribution, and strike rate.', 'The process of changing dismissal kinds from a dimension to a measure to determine the size of the angles in the pie chart is explained, leading to accurate representation of the data.', 'The process of calculating the strike rate for batsmen by dividing the total runs by the number of balls bowled, and visualizing it over time, is demonstrated.', "The chapter provides a detailed explanation of creating calculated fields for 'balls per boundary' and 'boundaries count', including the use of if statements and summing up to count boundaries.", 'The process of building the batsmen dashboard is explained, including steps for automatic and fixed size, dashboard title and visualizations formatting, and using floating visualizations for layout.', 'The beginning steps of creating the bowler dashboard are highlighted, focusing on visualizations for bowler performance against teams and the layout considerations for the dashboard.']}, {'end': 24206.009, 'segs': [{'end': 21823.752, 'src': 'embed', 'start': 21797.159, 'weight': 9, 'content': [{'end': 21804.043, 'text': "So for bowling average, we have a situation where maybe somebody doesn't know what the bowling average means.", 'start': 21797.159, 'duration': 6.884}, {'end': 21814.143, 'text': 'so You can right-click on your chart in the outside area, outside of the graph area, and click on caption.', 'start': 21804.043, 'duration': 10.1}, {'end': 21816.465, 'text': 'And the caption will pop up.', 'start': 21815.004, 'duration': 1.461}, {'end': 21821.79, 'text': "And it's automatically making a caption, which is bowling average calculated for each bowler.", 'start': 21816.905, 'duration': 4.885}, {'end': 21823.752, 'text': "It's just describing what's happening.", 'start': 21821.81, 'duration': 1.942}], 'summary': 'Automatic caption feature describes the bowling average for each bowler.', 'duration': 26.593, 'max_score': 21797.159, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo21797159.jpg'}, {'end': 21997.003, 'src': 'embed', 'start': 21967.665, 'weight': 13, 'content': [{'end': 21971.606, 'text': 'Also here, we can see that it says Economy Calculated for our label.', 'start': 21967.665, 'duration': 3.941}, {'end': 21974.988, 'text': 'If we hit Edit Axis, we can change the title.', 'start': 21972.107, 'duration': 2.881}, {'end': 21977.709, 'text': "So we're just going to call it Economy.", 'start': 21976.028, 'duration': 1.681}, {'end': 21982.35, 'text': 'Probably need to do the same thing for Bowling Average.', 'start': 21980.49, 'duration': 1.86}, {'end': 21983.09, 'text': 'There we go.', 'start': 21982.63, 'duration': 0.46}, {'end': 21984.431, 'text': 'Edit Axis.', 'start': 21983.751, 'duration': 0.68}, {'end': 21989.193, 'text': 'Bowling Average.', 'start': 21988.072, 'duration': 1.121}, {'end': 21991.113, 'text': "Okay It got mad because I didn't close it.", 'start': 21989.213, 'duration': 1.9}, {'end': 21992.874, 'text': 'And then there we have it.', 'start': 21991.693, 'duration': 1.181}, {'end': 21997.003, 'text': "Again, I'm going to right-click in some empty space and click caption.", 'start': 21993.539, 'duration': 3.464}], 'summary': 'Adjusting chart axes titles for economy and bowling average.', 'duration': 29.338, 'max_score': 21967.665, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo21967665.jpg'}, {'end': 22519.768, 'src': 'embed', 'start': 22491.675, 'weight': 10, 'content': [{'end': 22505.527, 'text': "Okay You notice one thing that's happening here is we cannot see at this point the filters.", 'start': 22491.675, 'duration': 13.852}, {'end': 22508.83, 'text': 'There are no filters popping in here even though we added filters.', 'start': 22505.868, 'duration': 2.962}, {'end': 22514.135, 'text': "Now why would that be? That's because we have no filters being shown on our visualization.", 'start': 22509.231, 'duration': 4.904}, {'end': 22519.768, 'text': 'None of our worksheets showed the filters, they just existed here.', 'start': 22516.846, 'duration': 2.922}], 'summary': 'No filters are being shown on the visualization.', 'duration': 28.093, 'max_score': 22491.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo22491675.jpg'}, {'end': 22774.144, 'src': 'embed', 'start': 22721.012, 'weight': 4, 'content': [{'end': 22727.256, 'text': "One thing that's happening here is it looks a little bit like this one has more up and down space than this one does.", 'start': 22721.012, 'duration': 6.244}, {'end': 22729.818, 'text': "And that's because it's missing this label.", 'start': 22728.077, 'duration': 1.741}, {'end': 22734.621, 'text': "And it also isn't colored the same as these other ones as it represents the bowler.", 'start': 22730.238, 'duration': 4.383}, {'end': 22736.002, 'text': 'Well, we can fix that.', 'start': 22734.981, 'duration': 1.021}, {'end': 22739.884, 'text': 'Because if you remember, we did not put bowler onto the columns.', 'start': 22736.382, 'duration': 3.502}, {'end': 22741.165, 'text': 'We put it on there.', 'start': 22740.205, 'duration': 0.96}, {'end': 22742.186, 'text': "There's our label.", 'start': 22741.185, 'duration': 1.001}, {'end': 22744.768, 'text': "We also didn't put it on to color.", 'start': 22743.567, 'duration': 1.201}, {'end': 22745.768, 'text': 'And there we go.', 'start': 22745.248, 'duration': 0.52}, {'end': 22751.032, 'text': 'So that gives us a little bit more consistency between these two visualizations.', 'start': 22746.309, 'duration': 4.723}, {'end': 22756.575, 'text': "However, they're still labeled Economy Rate and Bowling Average with their captions at the bottom there.", 'start': 22751.692, 'duration': 4.883}, {'end': 22767.12, 'text': 'OK And since these are the same width, I would like to line them up on the x-axis.', 'start': 22756.595, 'duration': 10.525}, {'end': 22772.243, 'text': "So I'm going to take this there.", 'start': 22767.821, 'duration': 4.422}, {'end': 22774.144, 'text': 'And that lines those up.', 'start': 22772.943, 'duration': 1.201}], 'summary': 'Adjustments made to improve consistency in visualizations, aligning x-axis and adding missing label for better clarity.', 'duration': 53.132, 'max_score': 22721.012, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo22721012.jpg'}, {'end': 22847.822, 'src': 'embed', 'start': 22810.524, 'weight': 6, 'content': [{'end': 22812.285, 'text': 'see how it did not make it bigger.', 'start': 22810.524, 'duration': 1.761}, {'end': 22825.094, 'text': 'that is because the formatting in here, such as changing the font or bolding it, requires you to have whatever text you want selected.', 'start': 22812.285, 'duration': 12.809}, {'end': 22825.874, 'text': "so now it's bigger.", 'start': 22825.094, 'duration': 0.78}, {'end': 22832.198, 'text': 'there we go.', 'start': 22825.874, 'duration': 6.324}, {'end': 22841.24, 'text': "i like the white on the blue, so i won't change these individual dashboards or individual worksheets to be a different color.", 'start': 22832.198, 'duration': 9.042}, {'end': 22843.761, 'text': "Let's take a look.", 'start': 22843.121, 'duration': 0.64}, {'end': 22847.822, 'text': 'Here we have our second dashboard.', 'start': 22845.582, 'duration': 2.24}], 'summary': 'The speaker demonstrates formatting text and discusses color choices for dashboards.', 'duration': 37.298, 'max_score': 22810.524, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo22810524.jpg'}, {'end': 23206.678, 'src': 'embed', 'start': 23181.363, 'weight': 11, 'content': [{'end': 23187.507, 'text': 'We have extract filters that filter the data as it extracts and it will affect how big your extract is.', 'start': 23181.363, 'duration': 6.144}, {'end': 23195.811, 'text': 'We also have data source filters here which will filter the data out of the data source, however the extract will still be the same size.', 'start': 23187.807, 'duration': 8.004}, {'end': 23201.915, 'text': "So let's take a look at this handy visualization that Tableau has on their website.", 'start': 23196.032, 'duration': 5.883}, {'end': 23206.678, 'text': 'We have the order of operations and in blue we have our filters.', 'start': 23202.315, 'duration': 4.363}], 'summary': "Extract filters affect extract size, data source filters don't impact extract size. tableau visualization shows order of operations.", 'duration': 25.315, 'max_score': 23181.363, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo23181363.jpg'}, {'end': 23406.212, 'src': 'embed', 'start': 23379.379, 'weight': 0, 'content': [{'end': 23384.881, 'text': 'Then you could take your orders and pull it So you see that pop up, drag table to union.', 'start': 23379.379, 'duration': 5.502}, {'end': 23387.663, 'text': "And that's another way to add more data.", 'start': 23385.382, 'duration': 2.281}, {'end': 23389.964, 'text': 'And so those are all worth mentioning.', 'start': 23388.163, 'duration': 1.801}, {'end': 23392.385, 'text': "Let's take a look at the different kinds of joins.", 'start': 23390.264, 'duration': 2.121}, {'end': 23399.548, 'text': 'We have our inner join, which will only give you the values that have matches in both tables.', 'start': 23393.065, 'duration': 6.483}, {'end': 23406.212, 'text': 'Our left join, that will give you all the values in the left table and its matches in the right table.', 'start': 23400.369, 'duration': 5.843}], 'summary': 'Explains joins: inner join gives matching values, left join includes all left table values and their matches in the right table.', 'duration': 26.833, 'max_score': 23379.379, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo23379379.jpg'}, {'end': 23443.714, 'src': 'embed', 'start': 23420.321, 'weight': 2, 'content': [{'end': 23428.386, 'text': "And then as we discussed the union, you can see it's represented by a more vertical join, and what it does is it adds more rows.", 'start': 23420.321, 'duration': 8.065}, {'end': 23436.392, 'text': 'All the rest of these are about adding more columns, but this will add more rows in the same columns that you had before.', 'start': 23428.967, 'duration': 7.425}, {'end': 23443.714, 'text': 'If you have the opportunity to draw out the answer to this question and make these Venn diagrams.', 'start': 23437.152, 'duration': 6.562}], 'summary': 'Union operation adds more rows to existing columns in venn diagrams.', 'duration': 23.393, 'max_score': 23420.321, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo23420321.jpg'}, {'end': 23520.899, 'src': 'embed', 'start': 23488.253, 'weight': 8, 'content': [{'end': 23495.299, 'text': "However, let's say we already had two different data sources in Tableau, and we wanted to bring together two of them.", 'start': 23488.253, 'duration': 7.046}, {'end': 23497.421, 'text': "So in this case, it's an Oracle table.", 'start': 23495.339, 'duration': 2.082}, {'end': 23499.823, 'text': 'And we brought in an Oracle table, and we made a data source.', 'start': 23497.541, 'duration': 2.282}, {'end': 23504.027, 'text': 'And then also an Excel table that had a second data source.', 'start': 23500.204, 'duration': 3.823}, {'end': 23506.969, 'text': 'and you can blend it together to get your combined data set.', 'start': 23504.407, 'duration': 2.562}, {'end': 23510.572, 'text': "So the major difference, what you're going to really want to take away from this,", 'start': 23507.049, 'duration': 3.523}, {'end': 23520.899, 'text': 'is that blending is from two separate tableau data sources and that joining is all within one data source and it ends up just being one data source in the end.', 'start': 23510.572, 'duration': 10.327}], 'summary': 'In tableau, blending combines data from 2 sources, while joining is within 1 source.', 'duration': 32.646, 'max_score': 23488.253, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo23488253.jpg'}, {'end': 23559.333, 'src': 'embed', 'start': 23530.146, 'weight': 1, 'content': [{'end': 23531.846, 'text': "So let's go back to our example here.", 'start': 23530.146, 'duration': 1.7}, {'end': 23533.187, 'text': "Let's bring on people.", 'start': 23532.066, 'duration': 1.121}, {'end': 23537.648, 'text': "It is automatically said we're going to join it on region and we're going to do an inner join.", 'start': 23533.687, 'duration': 3.961}, {'end': 23538.648, 'text': "That's fine by me.", 'start': 23537.668, 'duration': 0.98}, {'end': 23546.61, 'text': 'And so we come here and now we have just one set of dimension and measures under orders.', 'start': 23539.248, 'duration': 7.362}, {'end': 23553.852, 'text': "However, if we were to add a second data source, which we will, it'll be an Excel file and it will be based off of this rank example.", 'start': 23547.01, 'duration': 6.842}, {'end': 23555.692, 'text': "We'll open that up.", 'start': 23554.972, 'duration': 0.72}, {'end': 23559.333, 'text': 'And now when we go to sheet one, we have two data sources.', 'start': 23556.112, 'duration': 3.221}], 'summary': 'Using tableau, joining data sources based on region, resulting in one set of dimensions and measures under orders, with the possibility of adding a second excel data source for additional data.', 'duration': 29.187, 'max_score': 23530.146, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo23530146.jpg'}, {'end': 23992.879, 'src': 'embed', 'start': 23968.547, 'weight': 3, 'content': [{'end': 23974.33, 'text': 'So you could say sets are more complex and you can use conditions to create the sets,', 'start': 23968.547, 'duration': 5.783}, {'end': 23978.293, 'text': 'and you can also use multiple dimensions and measures to create the sets.', 'start': 23974.33, 'duration': 3.963}, {'end': 23982.775, 'text': 'For example, here we create a group of subcategory.', 'start': 23979.033, 'duration': 3.742}, {'end': 23986.316, 'text': 'So we grab all of these things together and can group it.', 'start': 23982.795, 'duration': 3.521}, {'end': 23992.879, 'text': "And that will be, we'll have copiers and envelopes, and then we'll have one group of all of these together.", 'start': 23986.756, 'duration': 6.123}], 'summary': 'Sets can be more complex, using conditions and multiple dimensions and measures to create groups, such as copiers and envelopes.', 'duration': 24.332, 'max_score': 23968.547, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo23968547.jpg'}], 'start': 21570.342, 'title': 'Tableau data visualization', 'summary': 'Covers basic tableau concepts, such as dimensions, measures, filters, joins, and blending, and delves into creating visualizations for bowler performance, dashboard formatting, and positioning, emphasizing the importance of filter consistency and data manipulation techniques.', 'chapters': [{'end': 22451.293, 'start': 21570.342, 'title': 'Visualizing bowler performance', 'summary': 'Discusses the creation of visualizations for analyzing bowler performance, including measures such as dismissal types, bowling average, and economy rate, while emphasizing the importance of proper filter application across the dashboard. key points include creating visualizations for bowler versus player analysis, calculating bowling average and economy rate, and maintaining filter consistency throughout the dashboard.', 'duration': 880.951, 'highlights': ['Creating visualizations for bowler versus player analysis The chapter discusses creating visualizations to analyze how a bowler has performed against particular players, including the use of dismissal kind and batsmen data.', 'Calculating bowling average and economy rate The process of calculating bowling average as runs conceded per wicket taken and economy rate as runs conceded per over is explained, with emphasis on the creation of calculated fields and their application in the visualizations.', 'Emphasizing filter consistency throughout the dashboard The importance of applying filters consistently across all visualizations in the dashboard is highlighted, with a focus on avoiding confusion and ensuring that filters are appropriately applied to all relevant data.']}, {'end': 22956.129, 'start': 22451.833, 'title': 'Dashboard formatting and positioning', 'summary': 'Discusses formatting and positioning of visualizations on the dashboard, including adjusting the size, alignment, and consistency of elements, and the process of creating two separate dashboards for batsman and bowler performance with learnings about formatting, floating versus tiled, and data types in tableau.', 'duration': 504.296, 'highlights': ['The chapter discusses the process of creating two separate dashboards for batsman and bowler performance. It includes learnings about formatting, floating versus tiled, and data types in Tableau.', 'The transcript explains the adjustments made to the size, alignment, and consistency of elements on the dashboard. It includes specific size adjustments like making visualizations taller or wider, aligning elements on both x and y axes, and ensuring consistency in labeling and formatting.', 'The speaker explains the process of positioning legends and filters on the dashboard. It includes insights into the positioning of legends, filters, and the options available for changing filters on the dashboard.']}, {'end': 23529.926, 'start': 22956.449, 'title': 'Tableau basics and data manipulation', 'summary': 'Covers basic concepts of tableau, including dimensions and measures, discrete and continuous values, filters, customer segments analysis, types of joins, and the difference between joining and blending in tableau.', 'duration': 573.477, 'highlights': ['Tableau automatically assigns data type and role for each field and aggregates measures using sum by default. Tableau automatically assigns data type and role for each field and aggregates measures using sum by default.', 'Dimensions are qualitative, used for categorizing data, while measures are quantitative and can be aggregated. Dimensions are qualitative, used for categorizing data, while measures are quantitative and can be aggregated.', 'Discrete values are represented as blue, continuous values as green in Tableau. Discrete values are represented as blue, continuous values as green in Tableau.', 'Different types of filters include extract filters, data source filters, context filters, and table calculation filters, each applying in a specific order. Different types of filters include extract filters, data source filters, context filters, and table calculation filters, each applying in a specific order.', 'Blending in Tableau combines data from separate data sources, while joining brings together tables within the same data source. Blending in Tableau combines data from separate data sources, while joining brings together tables within the same data source.']}, {'end': 24206.009, 'start': 23530.146, 'title': 'Tableau data visualization', 'summary': 'Discussed the differences between blending and joining data sources, live and extract connections, creating calculated fields, displaying top and bottom sales, and the distinctions between sets and groups in tableau, with practical examples and steps provided for each concept.', 'duration': 675.863, 'highlights': ['Blending vs joining data sources The chapter explains the visual difference between blending and joining data sources, where blending results in two separate sets of data, while joining combines data based on a specified condition.', 'Live vs extract connections It details the differences between live and extract connections, with live connections providing real-time information but potentially slower, while extract connections store information for faster access but are not real-time.', 'Creating calculated fields The process of creating calculated fields is illustrated, demonstrating how to derive new fields from existing data and utilize them for more robust visualizations.', 'Displaying top and bottom sales The steps for displaying top and bottom sales in the same view using sets and combining sets are outlined, providing a practical demonstration of dynamic filtering and grouping.', 'Sets vs groups in Tableau The distinctions between sets and groups in Tableau are explained, highlighting that sets can be more complex, based on conditions and multiple dimensions, while groups are simpler and use only one dimension to determine the group.', 'Understanding parameters in Tableau The concept of parameters in Tableau is defined as dynamic values that users can select, replacing constant values in calculations, filters, and reference lines.']}], 'duration': 2635.667, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo21570342.jpg', 'highlights': ['Creating visualizations for bowler versus player analysis, including dismissal kind and batsmen data', 'Calculating bowling average and economy rate with emphasis on calculated fields', 'Emphasizing filter consistency throughout the dashboard for avoiding confusion', 'Creating two separate dashboards for batsman and bowler performance with formatting insights', 'Adjusting size, alignment, and consistency of elements on the dashboard', 'Positioning legends and filters on the dashboard for effective visualization', 'Tableau automatically assigns data type and role for each field and aggregates measures using sum by default', 'Understanding the differences between dimensions and measures in Tableau', 'Differentiating discrete and continuous values in Tableau', 'Explaining different types of filters and their specific order of application', 'Distinguishing between blending and joining in Tableau', 'Detailing the differences between live and extract connections in Tableau', 'Illustrating the process of creating calculated fields for more robust visualizations', 'Displaying top and bottom sales in the same view using sets and combining sets', 'Explaining the distinctions between sets and groups in Tableau', 'Defining the concept of parameters in Tableau as dynamic values that users can select']}, {'end': 24999.811, 'segs': [{'end': 24329.467, 'src': 'embed', 'start': 24295.091, 'weight': 3, 'content': [{'end': 24302.254, 'text': 'So we have region, category, and subcategory.', 'start': 24295.091, 'duration': 7.163}, {'end': 24309.057, 'text': "And we're making a heat map so we want to bring profit onto color.", 'start': 24302.274, 'duration': 6.783}, {'end': 24318.319, 'text': "and you can see we've got hotter and colder in this case for a heat map we might want to change.", 'start': 24310.273, 'duration': 8.046}, {'end': 24324.784, 'text': "so in this case what it's doing is hotter is negative, but we could reverse that and then hotter is positive,", 'start': 24318.319, 'duration': 6.465}, {'end': 24329.467, 'text': 'and so hotter maybe means this is where more activity is.', 'start': 24324.784, 'duration': 4.683}], 'summary': 'Analyzing data to create a heat map based on profit and activity levels.', 'duration': 34.376, 'max_score': 24295.091, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo24295091.jpg'}, {'end': 24527.637, 'src': 'embed', 'start': 24478.638, 'weight': 0, 'content': [{'end': 24481.159, 'text': "and then here's the subcategories.", 'start': 24478.638, 'duration': 2.521}, {'end': 24488.704, 'text': "However, if you were trying to compare furniture to office supplies, It's really difficult to tell which one has more sales.", 'start': 24481.499, 'duration': 7.205}, {'end': 24498.273, 'text': 'but if we go over to sheet 7, that has our tree map on it, you can see really quickly that office supplies has much more sales than furniture.', 'start': 24488.704, 'duration': 9.569}, {'end': 24502.718, 'text': 'In this case, office supplies has much more profit than furniture.', 'start': 24498.754, 'duration': 3.964}, {'end': 24506.782, 'text': 'The biggest difference is that tree maps have the hierarchy.', 'start': 24502.738, 'duration': 4.044}, {'end': 24508.543, 'text': 'Question number 14.', 'start': 24507.142, 'duration': 1.401}, {'end': 24513.387, 'text': 'What is the difference between TWBX and TWB?', 'start': 24508.543, 'duration': 4.844}, {'end': 24523.574, 'text': 'So these are all Tableau file formats and the TWBX contains all of the unnecessary information to build a visualization.', 'start': 24513.687, 'duration': 9.887}, {'end': 24525.496, 'text': "So it's called a packaged workbook.", 'start': 24523.654, 'duration': 1.842}, {'end': 24527.637, 'text': 'and it compresses it all together.', 'start': 24526.136, 'duration': 1.501}], 'summary': 'Office supplies has much more sales and profit than furniture. twbx contains unnecessary information to build a visualization.', 'duration': 48.999, 'max_score': 24478.638, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo24478638.jpg'}, {'end': 24654.409, 'src': 'embed', 'start': 24571.506, 'weight': 1, 'content': [{'end': 24576.951, 'text': 'Explain the difference between Tableau Worksheet, Dashboard, Story, and Workbook.', 'start': 24571.506, 'duration': 5.445}, {'end': 24580.734, 'text': "Perfect Here's a breakdown and explanation of each of those.", 'start': 24577.211, 'duration': 3.523}, {'end': 24588.219, 'text': "And in Tableau, this entire thing that we've been looking at, all of these sheets, is a workbook.", 'start': 24581.174, 'duration': 7.045}, {'end': 24591.581, 'text': 'However, this sheet 7 is just one worksheet.', 'start': 24588.819, 'duration': 2.762}, {'end': 24595.384, 'text': 'All of them together is a workbook, and sheet 7 is a worksheet.', 'start': 24591.941, 'duration': 3.443}, {'end': 24604.53, 'text': 'The big difference between a worksheet and a dashboard is that the worksheet is just one visualization,', 'start': 24595.864, 'duration': 8.666}, {'end': 24607.792, 'text': 'and so it is only one set of columns and rows here.', 'start': 24604.53, 'duration': 3.262}, {'end': 24611.333, 'text': 'And a dashboard could contain multiple visualizations.', 'start': 24608.332, 'duration': 3.001}, {'end': 24617.495, 'text': 'So if we wanted to see our heat map and our tree map on the same page, that would be a dashboard.', 'start': 24611.793, 'duration': 5.702}, {'end': 24623.917, 'text': 'And then a story is somewhat similar to a presentation mode.', 'start': 24617.955, 'duration': 5.962}, {'end': 24626.818, 'text': 'And so you can have different pages.', 'start': 24624.277, 'duration': 2.541}, {'end': 24631.179, 'text': 'And so we could say here is our heat map.', 'start': 24627.378, 'duration': 3.801}, {'end': 24637.581, 'text': 'And then we could make another page and look at our tree map.', 'start': 24631.699, 'duration': 5.882}, {'end': 24640.28, 'text': 'and then look at our heat map.', 'start': 24639.079, 'duration': 1.201}, {'end': 24648.425, 'text': "And then we could duplicate that page and we could say, let's focus on furniture.", 'start': 24643.342, 'duration': 5.083}, {'end': 24650.987, 'text': "So we're gonna highlight furniture.", 'start': 24648.445, 'duration': 2.542}, {'end': 24654.409, 'text': 'And then so, if we were to go through these one at a time,', 'start': 24651.847, 'duration': 2.562}], 'summary': 'Tableau has worksheet, dashboard, and story. a worksheet is one visualization, a dashboard can contain multiple visualizations, and a story is similar to a presentation mode with different pages.', 'duration': 82.903, 'max_score': 24571.506, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo24571506.jpg'}, {'end': 24728.831, 'src': 'embed', 'start': 24696.028, 'weight': 2, 'content': [{'end': 24701.688, 'text': "So when you're looking at a dashboard, So on a worksheet, we see dimensions and measures.", 'start': 24696.028, 'duration': 5.66}, {'end': 24704.692, 'text': "When you're looking at a dashboard, you no longer see dimensions and measures.", 'start': 24701.788, 'duration': 2.904}, {'end': 24707.436, 'text': 'What you do see are all of the worksheets.', 'start': 24705.012, 'duration': 2.424}, {'end': 24715.887, 'text': 'Similarly, when you look at a story, you no longer see any dimensions and measures, but you do see all the worksheets and the dashboards.', 'start': 24707.896, 'duration': 7.991}, {'end': 24717.828, 'text': 'Question 16.', 'start': 24716.468, 'duration': 1.36}, {'end': 24720.009, 'text': 'What do you understand by blended axis?', 'start': 24717.828, 'duration': 2.181}, {'end': 24728.831, 'text': 'With a blended axis, you could use two measures that share an axis, and that means they necessarily have the same scale.', 'start': 24720.549, 'duration': 8.282}], 'summary': 'Dashboards show worksheets, blended axis uses measures with shared scale.', 'duration': 32.803, 'max_score': 24696.028, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo24696028.jpg'}], 'start': 24208.611, 'title': 'Tableau visualizations and parameter control', 'summary': 'Covers parameter controls, heat maps, tree maps, tableau file formats, visualizations (worksheet, dashboard, and story), blended axis, dual axis, and an error in a function.', 'chapters': [{'end': 24478.638, 'start': 24208.611, 'title': 'Parameter control and visualization types', 'summary': 'Explains the use of parameter controls to replace constant values, allowing users to select values, and the differences between heat maps and tree maps in visualizations, highlighting their use of color, size, and hierarchy.', 'duration': 270.027, 'highlights': ['The chapter demonstrates the use of parameter controls to replace constant values, allowing users to select values such as 5, 10, 15, or 20 for top and bottom customers, providing flexibility and interactivity for end users.', 'It explains the differences between heat maps and tree maps, emphasizing that heat maps compare categories using size and color, while tree maps are used to represent hierarchical data, with heat maps using color to draw attention to areas of heat or activity, and tree maps indicating hierarchy through box connections and size differences.', 'The chapter also highlights the construction of heat maps and tree maps, showcasing the use of dimensions and measures to create visualizations where color and size indicate differences, with heat maps using color to represent profit and sales, and tree maps displaying hierarchy through box connections and color differences.']}, {'end': 24999.811, 'start': 24478.638, 'title': 'Tableau visualizations and file formats', 'summary': 'Discusses the differences between tableau file formats, visualizations (worksheet, dashboard, and story), blended axis, dual axis, and an error in a function, highlighting the key points and functionalities of each concept.', 'duration': 521.173, 'highlights': ['The biggest difference is that tree maps have the hierarchy, with office supplies having much more sales than furniture.', 'TWBX contains all unnecessary information to build a visualization, while TWB only contains instructions about how to interact with the data source. TWBX has the data inside of it, whereas TWB only has the instructions.', 'Workbook contains the sheets, and the dashboards are the stories. The worksheet is a single view, dashboard is multiple views, and a story is a sequence.', 'With a blended axis, you could use two measures that share an axis, and that means they necessarily have the same scale.', 'A dual axis allows you to compare measures with two different scales, and you can synchronize axes for a similar visualization, with each axis having its own marks card.', 'An error will be returned in the following function.']}], 'duration': 791.2, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo24208611.jpg', 'highlights': ['The chapter demonstrates the use of parameter controls to replace constant values, providing flexibility and interactivity for end users.', 'Heat maps compare categories using size and color, while tree maps represent hierarchical data.', 'The construction of heat maps and tree maps showcases the use of dimensions and measures to create visualizations where color and size indicate differences.', 'TWBX contains all unnecessary information to build a visualization, while TWB only contains instructions about how to interact with the data source.', 'Workbook contains the sheets, and the dashboards are the stories. The worksheet is a single view, dashboard is multiple views, and a story is a sequence.', 'With a blended axis, you could use two measures that share an axis, and that means they necessarily have the same scale.', 'A dual axis allows you to compare measures with two different scales, and you can synchronize axes for a similar visualization.']}, {'end': 26680.178, 'segs': [{'end': 25068.695, 'src': 'embed', 'start': 25025.283, 'weight': 3, 'content': [{'end': 25031.364, 'text': "There's also one called right, and that would come from the other end and go EAU.", 'start': 25025.283, 'duration': 6.081}, {'end': 25032.945, 'text': "So that's where these answers came from.", 'start': 25031.525, 'duration': 1.42}, {'end': 25034.727, 'text': 'Question 19.', 'start': 25033.345, 'duration': 1.382}, {'end': 25037.169, 'text': 'How do you handle null and other special values?', 'start': 25034.727, 'duration': 2.442}, {'end': 25044.938, 'text': 'Tableau is unable to plot null values or zeros or negative values on a logarithmic axis,', 'start': 25037.63, 'duration': 7.308}, {'end': 25054.088, 'text': 'and so it will display an indicator in the lower right corner which looks like this, telling you that it is unable to draw those two points.', 'start': 25044.938, 'duration': 9.15}, {'end': 25057.77, 'text': 'So when you click on the indicator you can choose from the following.', 'start': 25054.768, 'duration': 3.002}, {'end': 25066.974, 'text': 'First you can choose to filter the data which will exclude the null values from the visualization or you can click show data at the default position.', 'start': 25058.11, 'duration': 8.864}, {'end': 25068.695, 'text': "So we'll look at both of these.", 'start': 25067.434, 'duration': 1.261}], 'summary': 'Tableau cannot plot null, zeros, or negatives on logarithmic axis; it displays an indicator and offers options to filter or show data.', 'duration': 43.412, 'max_score': 25025.283, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo25025283.jpg'}, {'end': 25402.894, 'src': 'embed', 'start': 25381.163, 'weight': 6, 'content': [{'end': 25389.467, 'text': 'So for Cindy, we want to take all of her profit over all of her transactions and divide by all of her sales,', 'start': 25381.163, 'duration': 8.304}, {'end': 25395.43, 'text': 'instead of doing it row by row profit divided by sales, profit divided by sales and then summing that up at the end.', 'start': 25389.467, 'duration': 5.963}, {'end': 25402.894, 'text': "so we'll take our profit ratio and put it on the label and we can see what her profit ratio is.", 'start': 25395.43, 'duration': 7.464}], 'summary': "Cindy's profit ratio will be calculated by summing all profits and dividing by total sales.", 'duration': 21.731, 'max_score': 25381.163, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo25381163.jpg'}, {'end': 26044.841, 'src': 'embed', 'start': 25993.62, 'weight': 1, 'content': [{'end': 26000.225, 'text': 'The reason we bring up a tree map here is that they are known for allowing you to show a visualization using hierarchies.', 'start': 25993.62, 'duration': 6.605}, {'end': 26001.646, 'text': "So let's take a look at that.", 'start': 26000.625, 'duration': 1.021}, {'end': 26006.33, 'text': "We're going to show aggregated sales totals across a range of product categories and subcategories.", 'start': 26001.886, 'duration': 4.444}, {'end': 26019.161, 'text': 'So if we come here and make a sheet and we want to see sales across control, click category and subcategory and then we click a tree map,', 'start': 26006.751, 'duration': 12.41}, {'end': 26021.417, 'text': 'What happens?', 'start': 26020.017, 'duration': 1.4}, {'end': 26024.938, 'text': "it's showing it based on size and color.", 'start': 26021.417, 'duration': 3.521}, {'end': 26029.919, 'text': 'And so it shows the bigger the size, the more sales, and the darker the color, the more sales.', 'start': 26025.458, 'duration': 4.461}, {'end': 26036.64, 'text': 'And the reason we choose a tree map over just a normal heat map is that it makes a category here.', 'start': 26030.639, 'duration': 6.001}, {'end': 26044.841, 'text': 'So we can compare this box that has all the technology in it, see how all of these are technology, to this box that has all of the office supplies.', 'start': 26036.78, 'duration': 8.061}], 'summary': 'Using a tree map to visualize sales data by product categories and subcategories, showing size and color-based sales comparison.', 'duration': 51.221, 'max_score': 25993.62, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo25993620.jpg'}, {'end': 26677.295, 'src': 'heatmap', 'start': 26418.722, 'weight': 0.709, 'content': [{'end': 26420.825, 'text': 'So now we have our profit per day.', 'start': 26418.722, 'duration': 2.103}, {'end': 26422.086, 'text': "We'll hit OK.", 'start': 26420.845, 'duration': 1.241}, {'end': 26424.689, 'text': "And now we're going to make a KPI.", 'start': 26422.627, 'duration': 2.062}, {'end': 26433.037, 'text': 'which for our purposes, if profit for a day is greater than 2,000, then that day is highly profitable.', 'start': 26426.874, 'duration': 6.163}, {'end': 26436.539, 'text': "If it's less than zero, then it's unprofitable, otherwise it is profitable.", 'start': 26433.338, 'duration': 3.201}, {'end': 26448.806, 'text': "So we're gonna go if our profit per day is greater than 2,000, then we're gonna call it highly profitable.", 'start': 26437, 'duration': 11.806}, {'end': 26470.562, 'text': "Else if We're going to do less than or equal to 0, then profitable, else, otherwise it is profitable.", 'start': 26453.049, 'duration': 17.513}, {'end': 26476.245, 'text': 'Always have to end with an end.', 'start': 26470.582, 'duration': 5.663}, {'end': 26478.687, 'text': 'Great OK.', 'start': 26476.265, 'duration': 2.422}, {'end': 26484.655, 'text': "So now we're going to make some visualizations.", 'start': 26479.447, 'duration': 5.208}, {'end': 26486.656, 'text': "It's going to look at it by year.", 'start': 26485.255, 'duration': 1.401}, {'end': 26493.799, 'text': 'Now it all fits in one view.', 'start': 26486.676, 'duration': 7.123}, {'end': 26498.941, 'text': 'We can rotate these labels to make it easier to see.', 'start': 26494.399, 'duration': 4.542}, {'end': 26509.264, 'text': "And we're going to bring on order ID but now it's showing like a lot of orders.", 'start': 26498.981, 'duration': 10.283}, {'end': 26515.007, 'text': "And so we actually want it to be used as a measure and we're going to do a count distinct.", 'start': 26509.784, 'duration': 5.223}, {'end': 26521.589, 'text': 'Great, so now we can see how many orders were on each day.', 'start': 26517.568, 'duration': 4.021}, {'end': 26525.691, 'text': "And so that's helpful for us to see how many orders are on this day each day.", 'start': 26522.37, 'duration': 3.321}, {'end': 26533.114, 'text': 'but we want to see the orders on each day that are highly profitable versus unprofitable, versus just profitable.', 'start': 26525.691, 'duration': 7.423}, {'end': 26539.747, 'text': "So we're going to use our level of detail and break it up into different sections.", 'start': 26533.494, 'duration': 6.253}, {'end': 26543.789, 'text': 'So we have highly profitable, profitable, and unprofitable.', 'start': 26540.587, 'duration': 3.202}, {'end': 26546.27, 'text': "Let's also bring this on to our color.", 'start': 26544.209, 'duration': 2.061}, {'end': 26549.773, 'text': 'Highly profitable, profitable, unprofitable.', 'start': 26547.952, 'duration': 1.821}, {'end': 26558.958, 'text': "And now we can see that the profitable ones are going up, unprofitable ones seem to be going down in 2015, and that's nice, but they are going up.", 'start': 26550.233, 'duration': 8.725}, {'end': 26561.459, 'text': 'And highly profitable is not very many.', 'start': 26559.298, 'duration': 2.161}, {'end': 26565.061, 'text': 'Oh, in this case we did area charts instead of just line charts.', 'start': 26562.24, 'duration': 2.821}, {'end': 26572.666, 'text': 'To make that change, you change it from automatic to area, and that helps you see some of that spatially as well.', 'start': 26565.442, 'duration': 7.224}, {'end': 26577.192, 'text': 'Comment below if you were able to make this visualization on your own.', 'start': 26573.127, 'duration': 4.065}, {'end': 26578.914, 'text': 'Question 30.', 'start': 26577.832, 'duration': 1.082}, {'end': 26582.218, 'text': 'How can you schedule a workbook in Tableau after publishing it?', 'start': 26578.914, 'duration': 3.304}, {'end': 26589.644, 'text': "So, when you publish a workbook in Tableau, if you've used an extract, you're going to need to refresh that extract.", 'start': 26582.818, 'duration': 6.826}, {'end': 26591.665, 'text': 'So in Tableau,', 'start': 26590.044, 'duration': 1.621}, {'end': 26600.848, 'text': "when you create a Tableau data source and it's an extract version of the data source it will no longer update if the data from your database updates.", 'start': 26591.665, 'duration': 9.183}, {'end': 26606.73, 'text': "So somebody's made some changes to your database or your Excel file and you want to see that in your Tableau visualization.", 'start': 26601.168, 'duration': 5.562}, {'end': 26610.612, 'text': "Well, you're not going to see it, but you can see it if you make a refresh.", 'start': 26606.77, 'duration': 3.842}, {'end': 26617.936, 'text': 'So you do that on Tableau server and you can remember that you have to get all the way to your data source.', 'start': 26611.152, 'duration': 6.784}, {'end': 26627.402, 'text': 'So you can go to your data sources or to your workbooks and then you look at the data source on your workbook and you go actions, extract, refresh.', 'start': 26617.956, 'duration': 9.446}, {'end': 26629.863, 'text': 'And then you select schedule a refresh.', 'start': 26627.802, 'duration': 2.061}, {'end': 26631.304, 'text': 'So that looks like this.', 'start': 26630.003, 'duration': 1.301}, {'end': 26636.446, 'text': 'You can press these three dots next to it and click refresh extracts or you can go to actions.', 'start': 26631.824, 'duration': 4.622}, {'end': 26640.909, 'text': 'And then here you click schedule a refresh instead of refresh now.', 'start': 26636.686, 'duration': 4.223}, {'end': 26644.911, 'text': "And then oftentimes in Tableau you'll have several different options.", 'start': 26641.429, 'duration': 3.482}, {'end': 26647.752, 'text': 'You can choose daily at 7 a.m. or every four hours.', 'start': 26644.931, 'duration': 2.821}, {'end': 26657.157, 'text': 'If an interviewer is asking you about how to schedule a refresh, it might be worthwhile bringing up the fact that you only need to schedule a refresh.', 'start': 26648.272, 'duration': 8.885}, {'end': 26666.145, 'text': 'if you are using an extract on your data source, and then that will help them know that you know the difference between live and extracts,', 'start': 26657.917, 'duration': 8.228}, {'end': 26667.886, 'text': "if they didn't ever ask that question.", 'start': 26666.145, 'duration': 1.741}, {'end': 26670.569, 'text': 'thank you, michelle, for that really great session.', 'start': 26667.886, 'duration': 2.683}, {'end': 26674.092, 'text': "with that we've reached the end of this complete tableau tutorial.", 'start': 26670.569, 'duration': 3.523}, {'end': 26677.295, 'text': 'i hope you guys enjoyed the video, do like and share it.', 'start': 26674.092, 'duration': 3.203}], 'summary': 'The tutorial covered creating kpis and visualizations in tableau, with a focus on scheduling data refresh for tableau workbooks.', 'duration': 258.573, 'max_score': 26418.722, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo26418722.jpg'}, {'end': 26470.562, 'src': 'embed', 'start': 26426.874, 'weight': 5, 'content': [{'end': 26433.037, 'text': 'which for our purposes, if profit for a day is greater than 2,000, then that day is highly profitable.', 'start': 26426.874, 'duration': 6.163}, {'end': 26436.539, 'text': "If it's less than zero, then it's unprofitable, otherwise it is profitable.", 'start': 26433.338, 'duration': 3.201}, {'end': 26448.806, 'text': "So we're gonna go if our profit per day is greater than 2,000, then we're gonna call it highly profitable.", 'start': 26437, 'duration': 11.806}, {'end': 26470.562, 'text': "Else if We're going to do less than or equal to 0, then profitable, else, otherwise it is profitable.", 'start': 26453.049, 'duration': 17.513}], 'summary': 'Profit over $2000 is highly profitable, less than $0 is unprofitable, else profitable.', 'duration': 43.688, 'max_score': 26426.874, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo26426874.jpg'}, {'end': 26591.665, 'src': 'embed', 'start': 26565.442, 'weight': 0, 'content': [{'end': 26572.666, 'text': 'To make that change, you change it from automatic to area, and that helps you see some of that spatially as well.', 'start': 26565.442, 'duration': 7.224}, {'end': 26577.192, 'text': 'Comment below if you were able to make this visualization on your own.', 'start': 26573.127, 'duration': 4.065}, {'end': 26578.914, 'text': 'Question 30.', 'start': 26577.832, 'duration': 1.082}, {'end': 26582.218, 'text': 'How can you schedule a workbook in Tableau after publishing it?', 'start': 26578.914, 'duration': 3.304}, {'end': 26589.644, 'text': "So, when you publish a workbook in Tableau, if you've used an extract, you're going to need to refresh that extract.", 'start': 26582.818, 'duration': 6.826}, {'end': 26591.665, 'text': 'So in Tableau,', 'start': 26590.044, 'duration': 1.621}], 'summary': 'To schedule a workbook in tableau, refresh the extract after publishing.', 'duration': 26.223, 'max_score': 26565.442, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo26565442.jpg'}], 'start': 25000.232, 'title': 'Tableau data analysis', 'summary': 'Covers tableau syntax for handling null values, table calculations, rank functions, visualization techniques, and dashboard optimization. it includes examples such as finding top product subcategories by sales, analyzing data using table calculations, and embedding web pages in dashboards.', 'chapters': [{'end': 25295.397, 'start': 25000.232, 'title': 'Tableau syntax and handling null values', 'summary': 'Discusses the syntax for left and right functions in tableau, handling null values in visualizations, and finding top product subcategories by sales within each delivery method.', 'duration': 295.165, 'highlights': ['The left function in Tableau returns a specific number of characters from the left of a string and must be used with the string first followed by the number. The left function in Tableau returns a specific number of characters from the left of a string and must be used with the string first followed by the number.', 'Handling null values in Tableau involves options to filter the data to exclude null values or to show data at the default position, which can impact the visualization and representation of zero sales. Handling null values in Tableau involves options to filter the data to exclude null values or to show data at the default position, which can impact the visualization and representation of zero sales.', 'Using table calculations in Tableau allows for ranking subcategories by sales within each delivery method, providing a clear analysis of top product subcategories for each ship mode. Using table calculations in Tableau allows for ranking subcategories by sales within each delivery method, providing a clear analysis of top product subcategories for each ship mode.']}, {'end': 25614.334, 'start': 25295.918, 'title': 'Table calculation and rank functions in tableau', 'summary': 'Introduces the application of table calculations in tableau to analyze data, presents an example of finding the customer with the lowest overall profit, and explains the rank function in tableau with various ranking methods demonstrated through visualizations.', 'duration': 318.416, 'highlights': ['Explaining the rank function in Tableau Tableau is able to rank data using different methods such as rank, rank dense, rank modified, or rank unique, allowing for assigning positions based on a measure, demonstrated through visualizations.', 'Demonstrating the application of table calculations in Tableau The chapter provides a practical example of using table calculations to find the customer with the lowest overall profit and to calculate the profit ratio, showcasing the functionality of table calculations in analyzing data.', 'Illustrating the process of finding the customer with the lowest overall profit Cindy Stewart is identified as the customer with the lowest profit and her profit ratio, obtained by summing profit divided by sales, is displayed, providing a specific example of analyzing individual customer data.']}, {'end': 26071.712, 'start': 25617.813, 'title': 'Tableau visualization and dashboard optimization', 'summary': 'Discusses tableau visualization techniques, dashboard optimization, and embedding web pages, including using rank unique, embedding web pages in dashboards, designing a view to show region-wide profit and sales, optimizing dashboard performance, and selecting visualizations for specific scenarios.', 'duration': 453.899, 'highlights': ['Using rank unique to determine rank and handling ties based on ASCII order in Tableau visualization Rank unique refuses to give 2 the same rank and determines ties based on ASCII order.', 'Embedding web pages in Tableau dashboards and making them dynamic based on user selection using URL action and dashboard actions Demonstrating how to embed a web page and make it dynamic based on user selection using URL action and dashboard actions.', 'Designing a view to show region-wide profit and sales using mapping capabilities in Tableau Utilizing mapping capabilities in Tableau to show profit and sales by region, including using state data to create a regional view.', 'Optimizing dashboard performance in Tableau by excluding unused fields, using extract filters, limiting filter usage, and using min and max instead of average Providing methods to optimize dashboard performance, such as excluding unused fields, using extract filters, limiting filter usage, and preferring min and max over average functions.', 'Selecting appropriate visualizations for scenarios: using tree map for aggregated sales, Gantt chart for duration, and unspecified visualization for quarter-wise profit growth Suggesting the use of a tree map for showing aggregated sales, a Gantt chart for displaying duration, and providing guidance on visualizing quarter-wise profit growth.']}, {'end': 26680.178, 'start': 26071.792, 'title': 'Tableau visualization techniques', 'summary': 'Covers techniques such as using waterfall charts to show profit growth, handling missing geographical entities in map view, utilizing level of detail expressions to refine visualizations, and scheduling workbook refreshes in tableau server.', 'duration': 608.386, 'highlights': ["Using waterfall charts to show profit growth Waterfall charts can be used to visually display how profit changes across different periods, helping to determine if it's increasing or decreasing.", "Handling missing geographical entities in map view Tableau's inability to map certain geographical locations due to unknown or ambiguous data can be addressed by editing locations, filtering the data, or showing data at default position.", 'Utilizing level of detail expressions to refine visualizations Level of detail expressions (LOD) help in defining the level of detail in visualizations, running complex queries at the data source level, and using calculations like exclude, include, and fixed to refine data presentation.', 'Scheduling workbook refreshes in Tableau Server After publishing a workbook in Tableau, scheduling a refresh is necessary when using an extract data source to ensure the visualization reflects the latest data from the database.']}], 'duration': 1679.946, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Wh4sCCZjOwo/pics/Wh4sCCZjOwo25000232.jpg', 'highlights': ['Using table calculations in Tableau allows for ranking subcategories by sales within each delivery method, providing a clear analysis of top product subcategories for each ship mode.', 'Demonstrating the application of table calculations in Tableau to find the customer with the lowest overall profit and to calculate the profit ratio, showcasing the functionality of table calculations in analyzing data.', 'Designing a view to show region-wide profit and sales using mapping capabilities in Tableau, including using state data to create a regional view.', 'Optimizing dashboard performance in Tableau by excluding unused fields, using extract filters, limiting filter usage, and using min and max instead of average.', "Using waterfall charts to visually display how profit changes across different periods, helping to determine if it's increasing or decreasing.", 'Utilizing level of detail expressions (LOD) to help in defining the level of detail in visualizations, running complex queries at the data source level, and using calculations like exclude, include, and fixed to refine data presentation.', 'Scheduling workbook refreshes in Tableau Server after publishing a workbook in Tableau, scheduling a refresh is necessary when using an extract data source to ensure the visualization reflects the latest data from the database.']}], 'highlights': ['Tableau tutorial covers basic concepts, benefits, and installation, data visualization, dashboard tips, design, visualization techniques, ranking options, actions, data analysis, and business analysis.', 'Tableau can connect to 40 different data sources, providing direct access to data and increasing the likelihood of obtaining valuable insights.', 'Tableau offers simple analytics such as trends and forecasting, enabling a deeper understanding of the data.', 'Tableau has been a leader in the Gartner Magic quadrant for six years, including 2018, showcasing its reliability and performance in the business intelligence market.', 'Tableau Public is a free version of Tableau Desktop that can support up to a million rows of data, providing a cost-effective solution for smaller-scale data analysis.', 'Demonstrated sorting data in Tableau by quantity and sales, showing that the highest sales occur when three items are purchased.', 'The technique of using measures to determine the color and size in visualizations is demonstrated, showcasing the dynamic adjustments based on sales and profit data.', 'The concept of building a scatter plot and utilizing the detail feature to determine the level of visualization is described, highlighting the use of scatter plots for visualizing sales and discount data per order or product.', 'The advanced copier is the top-selling product with the highest sales, while office supplies binders have low sales despite being highly discounted.', 'The West shows the highest sales, while technology dominates in the East, contributing to a drop in sales in quarter two of 2016.', 'The chapter covers creating calculated fields and replacing total number of customers with sales per customer, allowing for analysis of sales per customer ratio and identifying the highest performing customers.', 'Tableau generates longitude and latitude for geographical fields like state, city, and country, enabling easy visualization of sales data on a map, providing geographical insights.', 'The chapter demonstrates creating interactive dashboards in Tableau, utilizing features like fixed size, filter, uses filter, parameters, sets, and donut chart.', 'The chapter explains different types of joins, including inner join, left join, right join, and full outer join, and their impact on the resulting data sets.', 'The chapter provides a detailed comparison between left join and right join, illustrating how they differ in including data from the respective tables based on the join conditions.', 'The chapter provides a clear comparison of calculations performed on the database side versus the table side, illustrating the use of percentage of total sales split by subcategory and category, and delineating the differences between level of detail calculations and table calculations.', 'The process demonstrates the application of ascending and descending ranking based on sales.', 'The explanation of unique ranking, showcasing how it is determined even when the numbers are the same.', 'The system defaults to descending ranking for sales, considering the biggest as the best.', 'The unique ranking is decided based on the ASCII values of the store, providing a clear understanding of the process.', "The chapter explains how to link a Wikipedia page to a state in a visualization, enabling the display of the selected state's information within the visualization, eliminating the need to access a separate web page.", 'Building a waterfall chart to visualize profit over time for the year 2014.', "The chapter explains how to link a Wikipedia page to a state in a visualization, enabling the display of the selected state's information within the visualization, eliminating the need to access a separate web page.", 'The chapter demonstrates the use of parameter controls to replace constant values, providing flexibility and interactivity for end users.', 'Using table calculations in Tableau allows for ranking subcategories by sales within each delivery method, providing a clear analysis of top product subcategories for each ship mode.', 'Designing a view to show region-wide profit and sales using mapping capabilities in Tableau, including using state data to create a regional view.']}