title
Tableau Expert Full Course | Tableau Training | Tableau Tutorial | Tableau Full Course | Simplilearn

description
🔥Post Graduate Program In Data Analytics: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=TableauExpFSAug11-DlBIhpDjhbY&utm_medium=Descriptionff&utm_source=youtube 🔥IIT Kanpur Professional Certificate Course In Data Analytics (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-analytics?utm_campaign=TableauExpFSAug11-DlBIhpDjhbY&utm_medium=Descriptionff&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=TableauExpFSAug11-DlBIhpDjhbY&utm_medium=Descriptionff&utm_source=youtube 🔥Data Analyst Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/data-analyst-masters-certification-training-course?utm_campaign=TableauExpFSAug11-DlBIhpDjhbY&utm_medium=Descriptionff&utm_source=youtube This video on Tableau Expert Full Coursewill help beginners to learn the Tableau Fundamentals with a detailed theoretical explanation. The Tableau training video includes practical examples and extensive demo sessions for a better learning experience. This Tableau tutorial will help you master tableau from scratch. Below topics are covered in this Tableau Full Course video: 00:00:00 - 00:01:41 - Getting started 00:01:41 - 00:17:43 - Introduction to Tableau 00:17:43 - 00:39:15 - Data connections in Tableau 00:39:15 - 00:46:23 - Data joining and Blending using Tableau 00:46:23 - 00:51:35 - Data extracts in Tableau 00:51:35 - 00:56:37 - Data sources and Kerberos authentication 00:56:37 - 01:00:39 - Optimizing Performance 01:00:39 - 01:24:32 - Calculation in Tableau 01:24:32 - 01:48:34 - Aggregations and Table calculation using Tableau 01:48:32 - 02:00:56 - Box plots 02:00:56 - 02:17:05 - Formatting and Annotations 02:17:05 - 02:45:49 - Filtering Data 02:45:49 - 02:48:19 - Sorting of Data 02:48:19 - 02:54:47 - Combined fields, Groups and Sets 02:54:47 - 02:59:45 - Hierarchy and Drill Down in Tableau 02:59:45 - 03:05:53 - Grand totals and subtotals 03:05:53 - 03:51:55 - Mapping, Data Blending and Sorting 03:51:55 - 04:05:30 - Date Hierarchies 04:05:30 - 04:31:18 - What are parameters in Tableau? 04:31:18 - 04:52:08 - What are LOD expressions in Tableau? 04:52:08 - 07:23:48 - Tableau Dashboard Use Cases 07:23:48 - 08:26:56 - Tableau Interview Questions ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the Tableau Training videos: https://www.youtube.com/watch?v=fO7g0pnWaRA&list=PLEiEAq2VkUUJEvrsey26P-Bj4Vk6BLBVC #Tableau #TableauFullCourse #LearnTableauStepByStepForBeginners #TableauTrainingForBeginners #TableauTutorialForBeginners #TableauTutorial #LearnTableauIn8Hours #TableauCourse #Simplilearn 🔥Free Tableau Course with Completion Certificate: https://www.simplilearn.com/learn-tableau-online-free-course-skillup?utm_campaign=TableauExpFSAug11&utm_medium=Description&utm_source=youtube ➡️ About Post Graduate Program In Data Analytics This Data Analytics Program is ideal for all working professionals and prior programming knowledge is not required. It covers topics like data analysis, data visualization, regression techniques, and supervised learning in-depth via our applied learning model with live sessions by leading practitioners and industry projects. ✅ Key Features - Post Graduate Program certificate and Alumni Association membership - Exclusive hackathons and Ask me Anything sessions by IBM - 8X higher live interaction in live online classes by industry experts - Capstone from 3 domains and 14+ Data Analytics Projects with Industry datasets from Google PlayStore, Lyft, World Bank etc. - Master Classes delivered by Purdue faculty and IBM experts - Simplilearn's JobAssist helps you get noticed by top hiring companies - Resume preparation and LinkedIn profile building - 1:1 mock interview - Career accelerator webinars ✅ Skills Covered - Data Analytics - Statistical Analysis using Excel - Data Analysis Python and R - Data Visualization Tableau and Power BI - Linear and logistic regression modules - Clustering using kmeans - Supervised Learning 👉 Learn More at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=TableauExpFSAug11-DlBIhpDjhbY&utm_medium=Description&utm_source=youtube 🔥Caltech Data Analytics Bootcamp(US Only): https://www.simplilearn.com/data-analytics-bootcamp?utm_campaign=TableauExpFSAug11-DlBIhpDjhbY&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'Tableau Expert Full Course | Tableau Training | Tableau Tutorial | Tableau Full Course | Simplilearn', 'heatmap': [{'end': 2132.101, 'start': 911.955, 'weight': 0.726}, {'end': 30380.157, 'start': 30114.322, 'weight': 0.894}], 'summary': 'This tableau full course covers data connections, calculations, chart creation, formatting, mapping, data blending, filtering, spatial analysis, sales kpi, variance analysis, lod expressions, covid-19 data visualization, space missions analysis, interview questions, and tips for enhancing visualization and dashboard creation, with practical examples and use cases.', 'chapters': [{'end': 93.188, 'segs': [{'end': 93.188, 'src': 'embed', 'start': 15.58, 'weight': 0, 'content': [{'end': 18.521, 'text': 'hey, everyone welcome to simply learns youtube channel.', 'start': 15.58, 'duration': 2.941}, {'end': 22.782, 'text': 'in this session we will be learning the tableau expert full course.', 'start': 18.521, 'duration': 4.261}, {'end': 25.102, 'text': "let's have a look at the agenda for today's session.", 'start': 22.782, 'duration': 2.32}, {'end': 27.803, 'text': 'first, we will learn what exactly is tableau.', 'start': 25.102, 'duration': 2.701}, {'end': 31.284, 'text': 'followed by that, we will understand the data connections provided by tableau.', 'start': 27.803, 'duration': 3.481}, {'end': 34.765, 'text': 'then we will learn how to create data extracts using tableau.', 'start': 31.284, 'duration': 3.481}, {'end': 42.187, 'text': 'moving ahead, we will understand the tableau calculations, aggregations in tableau, creating quick table calculations, box and whiskers, plots, etc.', 'start': 34.765, 'duration': 7.422}, {'end': 47.11, 'text': 'Next, we will learn each and every single type of charts available in Tableau.', 'start': 43.007, 'duration': 4.103}, {'end': 51.093, 'text': 'Then, we will move ahead into formatting and annotations in Tableau.', 'start': 47.471, 'duration': 3.622}, {'end': 54.916, 'text': 'Then, we will understand how to filter data in Tableau.', 'start': 51.454, 'duration': 3.462}, {'end': 59.28, 'text': 'Followed by that, we have organizing and simplifying data in Tableau.', 'start': 55.377, 'duration': 3.903}, {'end': 63.225, 'text': 'Next, we will understand how to run mapping in Tableau.', 'start': 59.74, 'duration': 3.485}, {'end': 70.114, 'text': 'Then we have the data blending, data sorting, special field types, pivoting data paths, parameters in Tableau.', 'start': 63.445, 'duration': 6.669}, {'end': 73.819, 'text': 'Then we will understand the level of detail expressions in Tableau.', 'start': 70.375, 'duration': 3.444}, {'end': 79.882, 'text': 'Finally, we will enter the most important segment of the Tableau course that is the Tableau dashboard.', 'start': 74.54, 'duration': 5.342}, {'end': 84.984, 'text': 'After understanding all the fundamentals, we will put our skills to test using the Tableau projects.', 'start': 80.262, 'duration': 4.722}, {'end': 90.727, 'text': 'And finally, we will go through some of the most frequently asked interview questions based on Tableau.', 'start': 85.745, 'duration': 4.982}, {'end': 93.188, 'text': 'I hope I made myself clear with the agenda.', 'start': 91.347, 'duration': 1.841}], 'summary': 'Learn tableau expert full course covering data connections, calculations, charts, formatting, filtering, mapping, data blending, dashboard, projects, and interview questions.', 'duration': 77.608, 'max_score': 15.58, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY15580.jpg'}], 'start': 15.58, 'title': 'Tableau expert full course', 'summary': 'Covers a comprehensive tableau expert full course, encompassing data connections, data extracts, calculations, aggregations, chart creation, formatting, annotations, filtering, mapping, data blending, sorting, special field types, parameters, level of detail expressions, dashboards, projects, and interview questions.', 'chapters': [{'end': 93.188, 'start': 15.58, 'title': 'Tableau expert full course', 'summary': 'Covers a comprehensive tableau expert full course, including topics such as data connections, data extracts, calculations, aggregations, creating charts, formatting, annotations, filtering, mapping, data blending, sorting, special field types, parameters, level of detail expressions, dashboards, projects, and interview questions.', 'duration': 77.608, 'highlights': ['The chapter covers a comprehensive Tableau expert full course, including topics such as data connections, data extracts, calculations, aggregations, creating charts, formatting, annotations, filtering, mapping, data blending, sorting, special field types, parameters, level of detail expressions, dashboards, projects, and interview questions.', 'The session will cover each and every single type of charts available in Tableau.', 'The chapter will put the skills to test using Tableau projects.', 'The agenda includes understanding the level of detail expressions in Tableau.', 'The session will also cover the most frequently asked interview questions based on Tableau.']}], 'duration': 77.608, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY15580.jpg', 'highlights': ['The chapter covers a comprehensive Tableau expert full course, including various topics such as data connections, data extracts, calculations, aggregations, creating charts, formatting, annotations, filtering, mapping, data blending, sorting, special field types, parameters, level of detail expressions, dashboards, projects, and interview questions.', 'The session will cover each and every single type of charts available in Tableau.', 'The chapter will put the skills to test using Tableau projects.', 'The agenda includes understanding the level of detail expressions in Tableau.', 'The session will also cover the most frequently asked interview questions based on Tableau.']}, {'end': 1055.848, 'segs': [{'end': 132.454, 'src': 'embed', 'start': 93.568, 'weight': 0, 'content': [{'end': 97.249, 'text': 'But before we begin, make sure that you have subscribed to our YouTube channel,', 'start': 93.568, 'duration': 3.681}, {'end': 100.711, 'text': "and don't forget to hit that bell icon to never miss an update from Simply Learn.", 'start': 97.249, 'duration': 3.462}, {'end': 102.202, 'text': 'This is Ben.', 'start': 101.542, 'duration': 0.66}, {'end': 109.404, 'text': 'Ben started a store that sells automobile parts like brakes, exhausts, tires, lubricants, and car interiors.', 'start': 102.942, 'duration': 6.462}, {'end': 113.045, 'text': 'He made a good start with his business and achieved profits.', 'start': 110.104, 'duration': 2.941}, {'end': 119.407, 'text': 'However, as days passed by, along with his growing business, he faced some business challenges.', 'start': 113.765, 'duration': 5.642}, {'end': 123.868, 'text': 'He received orders from a variety of customers with different needs and requirements.', 'start': 120.047, 'duration': 3.821}, {'end': 129.532, 'text': 'For example, the northern states had higher demand for performance parts than others,', 'start': 124.528, 'duration': 5.004}, {'end': 132.454, 'text': 'and the eastern states demanded farm truck parts and lubricants more.', 'start': 129.532, 'duration': 2.922}], 'summary': "Ben's automobile parts store achieved profits but faced challenges with diverse customer demands.", 'duration': 38.886, 'max_score': 93.568, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY93568.jpg'}, {'end': 244.238, 'src': 'embed', 'start': 217.082, 'weight': 2, 'content': [{'end': 223.806, 'text': 'Now, Ben clearly understood the products that outperformed the sales charts and the products that did not have much demand.', 'start': 217.082, 'duration': 6.724}, {'end': 225.587, 'text': 'Let us elaborate a little.', 'start': 224.546, 'duration': 1.041}, {'end': 232.591, 'text': 'Ben found that the performance parts like sports exhausts, turbochargers, and engine management systems were selling well.', 'start': 226.207, 'duration': 6.384}, {'end': 238.374, 'text': 'With the Tableau Forecast feature, Ben identified the demand for performance products in the next quarter.', 'start': 233.291, 'duration': 5.083}, {'end': 244.238, 'text': 'So, he raised the prices on a few products that had the peak demand and earned higher profits.', 'start': 239.075, 'duration': 5.163}], 'summary': 'Ben identified top-selling products and raised prices for higher profits.', 'duration': 27.156, 'max_score': 217.082, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY217082.jpg'}, {'end': 316.658, 'src': 'embed', 'start': 278.649, 'weight': 3, 'content': [{'end': 283.252, 'text': 'He found the northern regions were interested in performance kits for their imported sports cars.', 'start': 278.649, 'duration': 4.603}, {'end': 286.635, 'text': 'The eastern regions had good demand for truck parts and lubricants.', 'start': 283.873, 'duration': 2.762}, {'end': 294.36, 'text': 'Using Tableau, Ben could generate various visualizations based on his data and come up with business-oriented decisions.', 'start': 287.435, 'duration': 6.925}, {'end': 303.445, 'text': 'Last but not least, Ben could also monitor his decisions and was able to make some necessary modifications to his business model on the go.', 'start': 295.12, 'duration': 8.325}, {'end': 308.429, 'text': 'Ben is now delighted as working with Tableau is a smooth and efficient process.', 'start': 304.106, 'duration': 4.323}, {'end': 316.658, 'text': 'Today, Tableau is being recognized as one of the best-in-class business intelligence tools because of its powerful and dependable features.', 'start': 309.289, 'duration': 7.369}], 'summary': 'Northern regions interested in sports car kits, eastern regions demand truck parts and lubricants. tableau aids in generating visualizations for informed business decisions, allowing for real-time modifications.', 'duration': 38.009, 'max_score': 278.649, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY278649.jpg'}, {'end': 469.014, 'src': 'embed', 'start': 424.208, 'weight': 5, 'content': [{'end': 428.553, 'text': 'So basically Tableau is a business and analytical software tool developed in America.', 'start': 424.208, 'duration': 4.345}, {'end': 437.422, 'text': 'Tableau helps people to understand, visualize and make data driven decisions in real time with extreme agility and accuracy.', 'start': 428.573, 'duration': 8.849}, {'end': 443.739, 'text': 'Now with this, let us continue with the next topic, which will be about the various versions of Tableau.', 'start': 438.496, 'duration': 5.243}, {'end': 446.661, 'text': 'So at first we have the Tableau desktop.', 'start': 444.32, 'duration': 2.341}, {'end': 456.587, 'text': 'So Tableau desktop is a data visualization application to facilitate you to examine virtually any kind of structured data and generate highly interactive,', 'start': 447.161, 'duration': 9.426}, {'end': 459.829, 'text': 'beautiful graphs, dashboards and reports within minutes.', 'start': 456.587, 'duration': 3.242}, {'end': 461.31, 'text': 'Once a quick installation.', 'start': 460.169, 'duration': 1.141}, {'end': 469.014, 'text': 'You can tie to virtually any data source from spreadsheets to data warehouses and display information in several graphic perspectives.', 'start': 461.59, 'duration': 7.424}], 'summary': 'Tableau is a data visualization tool that helps make data-driven decisions in real time, offering various versions including tableau desktop.', 'duration': 44.806, 'max_score': 424.208, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY424208.jpg'}, {'end': 1055.848, 'src': 'embed', 'start': 1028.88, 'weight': 7, 'content': [{'end': 1033.68, 'text': 'So according to Glassdoor, the average salary of a Tableau expert in America is $82, 000.', 'start': 1028.88, 'duration': 4.8}, {'end': 1035.262, 'text': 'And for a beginner, it is somewhere around $60, 000 per annum.', 'start': 1033.681, 'duration': 1.581}, {'end': 1037.463, 'text': 'And at the highest rate, it is $1,10, 000 per annum.', 'start': 1035.882, 'duration': 1.581}, {'end': 1051.307, 'text': 'Similarly, the average salary of a Tableau expert in India is 5,06, 000 per annum.', 'start': 1045.825, 'duration': 5.482}, {'end': 1055.848, 'text': 'And for a beginner, it is somewhere around 3,60, 000.', 'start': 1051.827, 'duration': 4.021}], 'summary': 'In america, tableau expert avg. salary is $82,000, beginner is $60,000. in india, expert avg. salary is 5,06,000, beginner is 3,60,000.', 'duration': 26.968, 'max_score': 1028.88, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY1028880.jpg'}], 'start': 93.568, 'title': 'Challenges and success in automobile business', 'summary': "Discusses challenges faced by ben's automobile parts store, and his success using tableau to analyze sales data, resulting in increased profits and improved customer satisfaction. it also explains tableau software, its features, advantages, and average salaries of tableau experts in america and india.", 'chapters': [{'end': 132.454, 'start': 93.568, 'title': 'Challenges in automobile parts business', 'summary': "Discusses ben's automobile parts store, where he initially made profits but faced challenges as his business grew, such as varying demand from different states.", 'duration': 38.886, 'highlights': ['Ben achieved profits after starting his automobile parts store.', 'Ben faced challenges due to varying demand from different states, with higher demand for performance parts in northern states and farm truck parts in eastern states.']}, {'end': 356.221, 'start': 133.114, 'title': "Ben's tableau success story", 'summary': 'Highlights how ben used tableau to analyze sales data, identify product demand, and make informed business decisions, resulting in increased profits and improved customer satisfaction.', 'duration': 223.107, 'highlights': ['Ben used Tableau to identify the demand for performance products and adjusted prices, resulting in higher profits. Ben raised the prices on products with high demand, such as performance parts like sports exhausts, turbochargers, and engine management systems, leading to increased profits.', "Ben leveraged Tableau's forecast feature to identify regional product demand and stabilize fluctuating sales. Using Tableau's forecast feature and geographic map, Ben identified regional product demand, leading to clearance sell offers on electronic products and stabilizing fluctuating sales.", "Tableau's capability to visualize sales data and make business-oriented decisions impressed Ben, leading to improved business performance. Ben used Tableau to generate various visualizations based on sales data, enabling him to make informed business decisions and improve business performance."]}, {'end': 1055.848, 'start': 356.681, 'title': 'Understanding tableau software', 'summary': 'Explains tableau as a business and analytical software tool that automates sql commands for data extraction, offers various versions including tableau desktop, server, online, public, and reader, provides features like robust security, collaboration, time series and forecasting, and informative and mobile view, and highlights its advantages such as remarkable visualization capabilities, ease of use, high performance, mobile friendliness, and thriving community, with average salaries of tableau experts in america and india at $82,000 and $5,06,000 per annum respectively.', 'duration': 699.167, 'highlights': ['Tableau is a business and analytical software tool developed in America, helping people to understand, visualize and make data-driven decisions in real time, with various versions including Tableau Desktop, Server, Online, Public, and Reader, offering features like robust security, collaboration, time series and forecasting, and informative and mobile view, and highlighting its advantages such as remarkable visualization capabilities, ease of use, high performance, mobile friendliness, and thriving community.', 'Tableau automates SQL commands for data extraction, offers various versions including Tableau Desktop, Server, Online, Public, and Reader, and provides features like robust security, collaboration, time series and forecasting, and informative and mobile view.', "Tableau's advantages include remarkable visualization capabilities, ease of use, high performance, mobile friendliness, and a thriving community, with average salaries of Tableau experts in America and India at $82,000 and $5,06,000 per annum respectively.", 'The companies looking for Tableau experts are Accenture, EY, PepsiCo, Deloitte, Wells Fargo, Capgemini, offering average salaries of Tableau experts in America at $82,000 and in India at $5,06,000 per annum.', 'Tableau is a business and analytical software tool developed in America, designed to understand, visualize and make data-driven decisions in real time, with various versions including Tableau Desktop, Server, Online, Public, and Reader, offering features like robust security, collaboration, time series and forecasting, and informative and mobile view.']}], 'duration': 962.28, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY93568.jpg', 'highlights': ['Ben achieved profits after starting his automobile parts store.', 'Ben faced challenges due to varying demand from different states.', 'Ben used Tableau to identify the demand for performance products and adjusted prices, resulting in higher profits.', "Ben leveraged Tableau's forecast feature to identify regional product demand and stabilize fluctuating sales.", "Tableau's capability to visualize sales data and make business-oriented decisions impressed Ben, leading to improved business performance.", 'Tableau is a business and analytical software tool developed in America, designed to understand, visualize and make data-driven decisions in real time, with various versions including Tableau Desktop, Server, Online, Public, and Reader, offering features like robust security, collaboration, time series and forecasting, and informative and mobile view.', 'Tableau automates SQL commands for data extraction, offers various versions including Tableau Desktop, Server, Online, Public, and Reader, and provides features like robust security, collaboration, time series and forecasting, and informative and mobile view.', "Tableau's advantages include remarkable visualization capabilities, ease of use, high performance, mobile friendliness, and a thriving community, with average salaries of Tableau experts in America and India at $82,000 and $5,06,000 per annum respectively.", 'The companies looking for Tableau experts are Accenture, EY, PepsiCo, Deloitte, Wells Fargo, Capgemini, offering average salaries of Tableau experts in America at $82,000 and in India at $5,06,000 per annum.']}, {'end': 3627.755, 'segs': [{'end': 1081.948, 'src': 'embed', 'start': 1055.849, 'weight': 0, 'content': [{'end': 1062.711, 'text': 'And for a highly skilled, experienced Tableau expert, the salaries range from 8,75, 000 per annum.', 'start': 1055.849, 'duration': 6.862}, {'end': 1066.752, 'text': 'So let me now begin with connecting to data.', 'start': 1062.731, 'duration': 4.021}, {'end': 1078.266, 'text': 'Now, in this particular topic, we are at the end of this lesson, you will be able to Understand how you can connect to Tableau Data Server.', 'start': 1067.133, 'duration': 11.133}, {'end': 1081.948, 'text': 'You will be able to differentiate between a join and blend.', 'start': 1078.706, 'duration': 3.242}], 'summary': 'Experienced tableau experts earn up to 8,75,000 per annum, and the lesson covers connecting to tableau data server and understanding joins vs. blends.', 'duration': 26.099, 'max_score': 1055.849, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY1055849.jpg'}, {'end': 1405.844, 'src': 'embed', 'start': 1376.997, 'weight': 2, 'content': [{'end': 1380.618, 'text': 'Now, if you connect to live, that means you connected to this particular sheet.', 'start': 1376.997, 'duration': 3.621}, {'end': 1387.712, 'text': 'live, that means any update happening onto your sheets, any kind of updates on the sheet.', 'start': 1380.618, 'duration': 7.094}, {'end': 1389.033, 'text': 'there is a nice connection.', 'start': 1387.712, 'duration': 1.321}, {'end': 1394.796, 'text': "It will automatically update your views as well onto your sheets that you're creating.", 'start': 1389.113, 'duration': 5.683}, {'end': 1400.62, 'text': 'And in case, if you select on an extract all right, this is what it means that it allows.', 'start': 1395.197, 'duration': 5.423}, {'end': 1405.844, 'text': 'uh, what it does is it imports that data into the tableau data engines.', 'start': 1400.62, 'duration': 5.224}], 'summary': 'Connecting to live allows automatic updates, while extracting imports data into tableau data engines.', 'duration': 28.847, 'max_score': 1376.997, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY1376997.jpg'}, {'end': 1442.373, 'src': 'embed', 'start': 1420.194, 'weight': 1, 'content': [{'end': 1428.702, 'text': 'in that manner, Tableau creates an extract of that file, providing you a disconnected where it allows you to give you a better performance,', 'start': 1420.194, 'duration': 8.508}, {'end': 1429.583, 'text': 'a better query.', 'start': 1428.702, 'duration': 0.881}, {'end': 1435.948, 'text': "That's how you can then work on and start creating and working on these extracts.", 'start': 1430.884, 'duration': 5.064}, {'end': 1439.952, 'text': 'Now you can refresh these extracts at a timely manner as well.', 'start': 1435.988, 'duration': 3.964}, {'end': 1442.373, 'text': 'So that is what Tableau extracts are.', 'start': 1440.292, 'duration': 2.081}], 'summary': 'Tableau creates extracts for better performance and query, allowing timely refresh.', 'duration': 22.179, 'max_score': 1420.194, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY1420194.jpg'}, {'end': 1816.563, 'src': 'embed', 'start': 1791.588, 'weight': 5, 'content': [{'end': 1797.031, 'text': "I'm going to ensure that you've selected that and that's how you will then connect to the data source.", 'start': 1791.588, 'duration': 5.443}, {'end': 1802.555, 'text': "And with that, you now have a new custom SQL option that's opened up for you all.", 'start': 1797.652, 'duration': 4.903}, {'end': 1810.94, 'text': "This is where you can, once you've connected, you can double click on the new custom SQL and you can write in your query.", 'start': 1802.975, 'duration': 7.965}, {'end': 1815.863, 'text': 'You can write in the SQL where you want to perform the query and pull in your data.', 'start': 1810.98, 'duration': 4.883}, {'end': 1816.563, 'text': 'All right.', 'start': 1816.243, 'duration': 0.32}], 'summary': 'Users can now utilize a new custom sql option to write and perform queries after connecting to the data source.', 'duration': 24.975, 'max_score': 1791.588, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY1791588.jpg'}, {'end': 2491.692, 'src': 'embed', 'start': 2465.383, 'weight': 4, 'content': [{'end': 2471.905, 'text': "So in case, if you all are facing of trouble, where you're not able to connect and see that particular option is throwing an error.", 'start': 2465.383, 'duration': 6.522}, {'end': 2478.027, 'text': "this legacy connection options comes in only when you're using a Microsoft Jet Data Engine driver.", 'start': 2471.905, 'duration': 6.122}, {'end': 2482.528, 'text': 'This is easily available in case if you do not have it, you can install this driver.', 'start': 2478.387, 'duration': 4.141}, {'end': 2486.85, 'text': 'With this, it will enable the right outer join and the custom SQL for us.', 'start': 2483.069, 'duration': 3.781}, {'end': 2491.692, 'text': 'all right to enable the uh right outer join here.', 'start': 2487.45, 'duration': 4.242}], 'summary': 'Legacy connection options enable right outer join and custom sql using microsoft jet data engine driver.', 'duration': 26.309, 'max_score': 2465.383, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY2465383.jpg'}, {'end': 2580.391, 'src': 'embed', 'start': 2552.728, 'weight': 6, 'content': [{'end': 2557.51, 'text': "So that's how you can blend your data, which creates a primary and a secondary data.", 'start': 2552.728, 'duration': 4.782}, {'end': 2571.117, 'text': "So we saw that in this example you can see that there's a customer segment department and some of sales wherein the bars are being created which are coming in from the primary connection.", 'start': 2557.83, 'duration': 13.287}, {'end': 2577.067, 'text': 'But in terms of the sales plan, these sales plan are coming in from a secondary data.', 'start': 2571.601, 'duration': 5.466}, {'end': 2580.391, 'text': 'You can see the amber connection here, the amber line here,', 'start': 2577.087, 'duration': 3.304}], 'summary': 'Blending data creates primary and secondary data, seen in customer segment and sales plan.', 'duration': 27.663, 'max_score': 2552.728, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY2552728.jpg'}, {'end': 2742.79, 'src': 'embed', 'start': 2721.551, 'weight': 3, 'content': [{'end': 2730.799, 'text': 'Joining is done once at the data source and this can be used for every worksheet, while blending will be done individually for every worksheet.', 'start': 2721.551, 'duration': 9.248}, {'end': 2736.844, 'text': 'And both the tables that are joined must exist in the SQL database,', 'start': 2731.2, 'duration': 5.644}, {'end': 2742.79, 'text': 'while in blending it helps us combine the database which is coming in from different sources, different locations.', 'start': 2736.844, 'duration': 5.946}], 'summary': 'Joining is done at data source, blending for each worksheet. tables must exist in sql database. blending combines data from different sources.', 'duration': 21.239, 'max_score': 2721.551, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY2721551.jpg'}, {'end': 3340.261, 'src': 'embed', 'start': 3310.994, 'weight': 8, 'content': [{'end': 3316.198, 'text': 'You need to configure your Tableau server with these Kerberos configurations.', 'start': 3310.994, 'duration': 5.204}, {'end': 3318.819, 'text': "So, it's a three-way authentication protocol.", 'start': 3316.498, 'duration': 2.321}, {'end': 3331.995, 'text': 'Now, how this works is a mechanism of a mutual authentication between the client and the server is provided with the Kerberos authentication.', 'start': 3321.241, 'duration': 10.754}, {'end': 3340.261, 'text': 'So when the user logs in to the directory, it directly asks for the credentials which are authenticated by Kerberos.', 'start': 3332.255, 'duration': 8.006}], 'summary': 'Configure tableau server with kerberos for three-way authentication.', 'duration': 29.267, 'max_score': 3310.994, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY3310994.jpg'}, {'end': 3526.923, 'src': 'embed', 'start': 3499.817, 'weight': 9, 'content': [{'end': 3507.599, 'text': 'the external query caching that it uses, and also provides a data engine vectorization, where it makes it even more quicker and faster.', 'start': 3499.817, 'duration': 7.782}, {'end': 3519.876, 'text': 'In order to quicken the process of your loading of data, what Tableau does is it creates and saves a shadow extract file on its own.', 'start': 3511.062, 'duration': 8.814}, {'end': 3520.558, 'text': 'All right.', 'start': 3520.317, 'duration': 0.241}, {'end': 3526.923, 'text': 'What it does is in the repository for you to load your data faster other than you creating an extract.', 'start': 3520.598, 'duration': 6.325}], 'summary': 'Tableau uses external query caching and data engine vectorization to speed up data loading by creating and saving a shadow extract file in the repository.', 'duration': 27.106, 'max_score': 3499.817, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY3499817.jpg'}], 'start': 1055.849, 'title': 'Tableau data analysis', 'summary': 'Covers connecting to tableau data server, live or extracting data connections, data source joining and blending, legacy connections, and data blending in tableau, with salaries for skilled tableau experts ranging from 8,75,000 per annum and optimization techniques for query performance.', 'chapters': [{'end': 1355.047, 'start': 1055.849, 'title': 'Tableau server connection & data analysis', 'summary': 'Covers connecting to tableau data server, understanding joining and blending, and performance optimization techniques, with salaries for skilled tableau experts ranging from 8,75,000 per annum.', 'duration': 299.198, 'highlights': ['Skilled Tableau experts earn salaries ranging from 8,75,000 per annum Experienced Tableau experts can earn salaries starting from 8,75,000 per annum.', 'Understanding how to connect to Tableau Data Server and differentiate between join and blend The chapter covers connecting to Tableau Data Server, understanding the difference between join and blend, and the various connection options available.', 'Performance optimization techniques and data preparation methods in Tableau Various performance optimization techniques and data preparation methods in Tableau are discussed.', 'Exploring Tableau server connection options and data source selection The process of connecting to Tableau server, selecting a data source, and creating a local copy is explained.', 'Identifying dimensions, measures, data types, and roles in Tableau The identification of dimensions, measures, data types, and roles in Tableau is demonstrated.']}, {'end': 1625.967, 'start': 1355.047, 'title': 'Tableau data connections and joins', 'summary': 'Covers connecting to live or extracting data in tableau, the benefits of using tableau extracts, and performing joins between tables for data analysis and visualization.', 'duration': 270.92, 'highlights': ['Tableau extracts allow for better performance and query capabilities by importing data into the Tableau data engine, providing a disconnected copy for improved performance. Tableau extracts improve performance and query capabilities by creating a disconnected copy of data in the Tableau data engine, allowing for better performance and query capabilities.', 'Connecting to live data in Tableau enables automatic updates to views based on changes in the source data, ensuring real-time synchronization. Connecting to live data in Tableau enables automatic updates to views based on changes in the source data, ensuring real-time synchronization for improved data accuracy.', 'The chapter demonstrates the process of performing joins in Tableau, including automatic join creation when pulling in multiple tables and modifying join types for data analysis. The chapter demonstrates the process of performing joins in Tableau, including automatic join creation when pulling in multiple tables and modifying join types for data analysis, providing insights into data relationships.']}, {'end': 2191.748, 'start': 1626.447, 'title': 'Data source joining and blending', 'summary': 'Explains how to perform data source joining and blending in tableau, enabling custom sql queries and write joins, with examples showing the automatic data blending feature and the differences between joining and blending.', 'duration': 565.301, 'highlights': ['The chapter explains how to perform data source joining and blending in Tableau It covers the process of connecting to data sources, enabling custom SQL queries, and write joins.', 'Enabling custom SQL queries and write joins The process to enable custom SQL queries and write joins is detailed, including the steps to specify a query and connect to data in a specific manner.', 'Automatic data blending feature and differences between joining and blending The examples demonstrate the automatic data blending feature and highlight the differences between joining and blending, including the inability to manipulate the join in data blending.']}, {'end': 2512.815, 'start': 2192.267, 'title': 'Legacy connections and table joins', 'summary': 'Discusses legacy connections, enabling right outer joins, creating and connecting to a custom sql query, working with extracts for improved performance, and types of table joins in tableau, including scenarios and enabling of right outer joins.', 'duration': 320.548, 'highlights': ['Legacy connections and enabling right outer joins are discussed, including the use of Microsoft Jet Data Engine driver for enabling the right outer join and custom SQL. Legacy connections and enabling right outer joins', 'The process of creating and connecting to a custom SQL query is explained, including the use of legacy connections for this purpose. Creating and connecting to a custom SQL query', 'The concept and advantages of using extracts for improved performance are outlined, including the ability to reduce the total amount of data and enable incremental fetch for data refresh. Advantages of using extracts for improved performance', 'Different types of table joins in Tableau are discussed, including inner, left, right, and full outer joins, along with scenarios for using joins in data analysis. Types of table joins in Tableau and usage scenarios']}, {'end': 3627.755, 'start': 2512.815, 'title': 'Data blending and optimization in tableau', 'summary': 'Covers data blending in tableau, distinguishing between primary and secondary data, creating data extracts to improve query performance, supported data sources, kerberos authentication for tableau server, and query optimization techniques including parallel query execution, query fusion, external query caching, and data engine vectorization.', 'duration': 1114.94, 'highlights': ['The chapter explains data blending in Tableau, distinguishing between primary and secondary data, and how to identify and establish connections between common fields, with a feature to explicitly define a link if not automatically established.', 'The process of creating data extracts in Tableau to improve query performance is detailed, including the option to create a subset of the data source, saving it as a Tableau extract for offline access, incremental refresh options, and aggregation settings for optimizing performance.', 'The supported data sources in Tableau are discussed, highlighting the differences between personal and professional editions in terms of database connectivity, additional database options, and supported data connections.', 'Kerberos authentication for Tableau Server is explained, detailing its function as a trusted authentication method for single sign-on, enabling a secure connection between the desktop and server.', 'The chapter explores query optimization techniques in Tableau, including parallel query execution for faster dashboard performance, query fusion to simplify complex queries, external query caching for faster data processing, and data engine vectorization for in-memory analytics and faster query execution.', "Tableau's automatic creation of shadow extract files in the repository to improve data loading speed is highlighted, with details on its automatic generation and replacement of the oldest files for optimized performance."]}], 'duration': 2571.906, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY1055849.jpg', 'highlights': ['Skilled Tableau experts earn salaries ranging from 8,75,000 per annum', 'Tableau extracts improve performance and query capabilities by creating a disconnected copy of data', 'Connecting to live data in Tableau enables automatic updates to views based on changes in the source data', 'The chapter explains how to perform data source joining and blending in Tableau', 'Legacy connections and enabling right outer joins are discussed, including the use of Microsoft Jet Data Engine driver', 'The process of creating and connecting to a custom SQL query is explained', 'The chapter explains data blending in Tableau, distinguishing between primary and secondary data', 'The process of creating data extracts in Tableau to improve query performance is detailed', 'Kerberos authentication for Tableau Server is explained, detailing its function as a trusted authentication method for single sign-on', "Tableau's automatic creation of shadow extract files in the repository to improve data loading speed is highlighted"]}, {'end': 4936.394, 'segs': [{'end': 3715.339, 'src': 'embed', 'start': 3669.466, 'weight': 1, 'content': [{'end': 3673.91, 'text': 'But let us understand these in detail now, all right? So let me begin.', 'start': 3669.466, 'duration': 4.444}, {'end': 3681.236, 'text': "So, at the end of this session, in terms of when we complete this topic, you're going to understand how you can make use of strings, dates,", 'start': 3673.95, 'duration': 7.286}, {'end': 3683.958, 'text': 'logical as well as arithmetic calculations.', 'start': 3681.236, 'duration': 2.722}, {'end': 3692.391, 'text': 'how you can work with different aggregation options, how you can make use of the grand totals and subtotals, the quick table calculations,', 'start': 3684.488, 'duration': 7.903}, {'end': 3702.895, 'text': 'which are inbuilt by Tableau, how you can create automatic and custom splits, discovering the ad hoc analytics which is offered by Tableau.', 'start': 3692.391, 'duration': 10.504}, {'end': 3706.397, 'text': 'and how you can perform the LOD, that is, level of details calculation.', 'start': 3702.895, 'duration': 3.502}, {'end': 3715.339, 'text': "So let's begin with the very first topic how you can work with strings, bits, logical and arithmetic calculations,", 'start': 3707.337, 'duration': 8.002}], 'summary': 'Learn to use strings, dates, logic, and arithmetic calculations, aggregation, and ad hoc analytics in tableau.', 'duration': 45.873, 'max_score': 3669.466, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY3669466.jpg'}, {'end': 3761.209, 'src': 'embed', 'start': 3735.427, 'weight': 0, 'content': [{'end': 3741.41, 'text': 'you can then apply certain functions and operators and finally create a calculation.', 'start': 3735.427, 'duration': 5.983}, {'end': 3748.583, 'text': 'you can create these four kinds of calculations the arithmetic, state string and logical ones.', 'start': 3741.41, 'duration': 7.173}, {'end': 3761.209, 'text': 'So let us understand and explore how we can use how Tableau provides us various built-in functions wherein we can use a calculated field and create an arithmetic calculation.', 'start': 3749.623, 'duration': 11.586}], 'summary': 'Tableau allows creation of arithmetic, string, state, and logical calculations using built-in functions.', 'duration': 25.782, 'max_score': 3735.427, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY3735427.jpg'}, {'end': 3850.909, 'src': 'embed', 'start': 3817.337, 'weight': 3, 'content': [{'end': 3824.544, 'text': 'and let me start showing you one of the examples of each that we can use in terms of creating them alright.', 'start': 3817.337, 'duration': 7.207}, {'end': 3828.991, 'text': 'And in here, let me quickly create one simple view.', 'start': 3826.188, 'duration': 2.803}, {'end': 3832.954, 'text': "So I'm going to add in my states to rows.", 'start': 3829.011, 'duration': 3.943}, {'end': 3839.099, 'text': "And I'm going to add sales to my columns and quickly create one bar chart here.", 'start': 3833.855, 'duration': 5.244}, {'end': 3839.78, 'text': 'All right.', 'start': 3839.459, 'duration': 0.321}, {'end': 3850.428, 'text': "Now I want to have my, let's say I want to analyze the sales across each state here.", 'start': 3842.962, 'duration': 7.466}, {'end': 3850.909, 'text': 'All right.', 'start': 3850.589, 'duration': 0.32}], 'summary': 'Creating a simple bar chart to analyze sales across states.', 'duration': 33.572, 'max_score': 3817.337, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY3817337.jpg'}, {'end': 3967.738, 'src': 'embed', 'start': 3938.044, 'weight': 4, 'content': [{'end': 3939.765, 'text': 'So those are aggregation functions.', 'start': 3938.044, 'duration': 1.721}, {'end': 3944.308, 'text': 'Yes, we have a bar chart.', 'start': 3943.227, 'duration': 1.081}, {'end': 3947.95, 'text': "I'm going to still analyze and show these details to you further in terms of aggregation.", 'start': 3944.628, 'duration': 3.322}, {'end': 3954.334, 'text': "So what I did was instead of just using the product name as it is, I've used a count distinct, all right.", 'start': 3947.97, 'duration': 6.364}, {'end': 3960.758, 'text': 'Could you please drag and drop the product name? You want me to show that to you once again, Siva? Yes.', 'start': 3955.515, 'duration': 5.243}, {'end': 3964.761, 'text': "I'm going to take this off my columns here.", 'start': 3961.539, 'duration': 3.222}, {'end': 3967.738, 'text': 'Now, when I want to add my product name.', 'start': 3965.137, 'duration': 2.601}], 'summary': 'Analyzing data using aggregation functions and bar chart for product names.', 'duration': 29.694, 'max_score': 3938.044, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY3938044.jpg'}, {'end': 4103.508, 'src': 'embed', 'start': 4072.666, 'weight': 6, 'content': [{'end': 4082.016, 'text': "And I'm going to divide this because I want to know sales per item sold.", 'start': 4072.666, 'duration': 9.35}, {'end': 4085.898, 'text': "Now, that is the reason I've created the count distinct product name here.", 'start': 4082.316, 'duration': 3.582}, {'end': 4092.622, 'text': "So, Diksha, when you mentioned you're seeing two bars, the only reason I did that was right now I'm just trying to create a count product name.", 'start': 4085.918, 'duration': 6.704}, {'end': 4103.508, 'text': "And once I add in the details, I'm then going to replace the particular view from it, all right? So, I'm going to divide this with the count product.", 'start': 4093.142, 'duration': 10.366}], 'summary': 'Analyzing sales per item sold to optimize performance.', 'duration': 30.842, 'max_score': 4072.666, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4072666.jpg'}, {'end': 4168.121, 'src': 'embed', 'start': 4131.433, 'weight': 5, 'content': [{'end': 4137.194, 'text': "And with that, in the measures, we have a new measure that's added up, which is the sales per item.", 'start': 4131.433, 'duration': 5.761}, {'end': 4140.837, 'text': "This particular calculated field I'm going to place it.", 'start': 4138.197, 'duration': 2.64}, {'end': 4147.321, 'text': "it's getting placed in the measures directly because it's returning a particular number right? The numerical value.", 'start': 4140.837, 'duration': 6.484}, {'end': 4148.642, 'text': "and hence it's placed in measures.", 'start': 4147.321, 'duration': 1.321}, {'end': 4153.044, 'text': 'Now let me add my sales for item into the columns.', 'start': 4149.182, 'duration': 3.862}, {'end': 4168.121, 'text': "So I'm going to replace my count product name here, all right? So here I can now see, You can see notice and this shows aggregated.", 'start': 4153.584, 'duration': 14.537}], 'summary': "New measure 'sales per item' added to measures, replacing count product name.", 'duration': 36.688, 'max_score': 4131.433, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4131433.jpg'}, {'end': 4209.432, 'src': 'embed', 'start': 4181.444, 'weight': 8, 'content': [{'end': 4184.785, 'text': 'And I cannot change the aggregation function here.', 'start': 4181.444, 'duration': 3.341}, {'end': 4186.786, 'text': 'So notice earlier when I specified.', 'start': 4184.805, 'duration': 1.981}, {'end': 4188.943, 'text': 'The default function is sum.', 'start': 4187.182, 'duration': 1.761}, {'end': 4196.426, 'text': 'We can change these aggregation functions for a particular measure from the inbuilt ones or we can specify it as a calculated field.', 'start': 4189.283, 'duration': 7.143}, {'end': 4201.608, 'text': 'Now in this case, it does not give us any option to change the aggregation function.', 'start': 4196.966, 'duration': 4.642}, {'end': 4205.21, 'text': 'It shows it is aggregated already because it is a calculated field.', 'start': 4202.029, 'duration': 3.181}, {'end': 4209.432, 'text': 'It is taking in the aggregation as we specified in the arithmetic calculation.', 'start': 4205.23, 'duration': 4.202}], 'summary': 'Aggregation function cannot be changed. default is sum. calculated field specifies aggregation.', 'duration': 27.988, 'max_score': 4181.444, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4181444.jpg'}, {'end': 4257.562, 'src': 'embed', 'start': 4231.671, 'weight': 9, 'content': [{'end': 4236.535, 'text': "Now we've already seen we've covered up the first type which was arithmetic calculation.", 'start': 4231.671, 'duration': 4.864}, {'end': 4242.3, 'text': 'Now let me show you an example of how we can use calculated fields and create a string calculation.', 'start': 4236.955, 'duration': 5.345}, {'end': 4252.659, 'text': "Alright? So let's say We want to analyze the customers beginning with the name S, all right? The one that's illustrated in the slide here.", 'start': 4242.72, 'duration': 9.939}, {'end': 4257.562, 'text': 'It says that we will be analyzing the customers beginning with S, okay?', 'start': 4252.679, 'duration': 4.883}], 'summary': 'Demonstrated creation of string calculation for analyzing customers beginning with the letter s.', 'duration': 25.891, 'max_score': 4231.671, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4231671.jpg'}, {'end': 4328.785, 'src': 'embed', 'start': 4301.629, 'weight': 11, 'content': [{'end': 4310.474, 'text': 'Now it would be pretty difficult if I add up the customer name in the filters here and then manually select the one with S.', 'start': 4301.629, 'duration': 8.845}, {'end': 4315.877, 'text': 'Or I can also use the wildcard wherein I am using the option to select one with an S.', 'start': 4310.474, 'duration': 5.403}, {'end': 4320.48, 'text': 'Similarly, I can also make use of the calculated field to achieve the same scenario.', 'start': 4315.877, 'duration': 4.603}, {'end': 4324.123, 'text': "So let's click on Create Calculated Field.", 'start': 4321.562, 'duration': 2.561}, {'end': 4328.785, 'text': "Let's name this as Customer with S.", 'start': 4324.463, 'duration': 4.322}], 'summary': 'The speaker discusses using filters, wildcards, and calculated fields to manipulate and analyze customer data.', 'duration': 27.156, 'max_score': 4301.629, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4301629.jpg'}, {'end': 4540.374, 'src': 'embed', 'start': 4514.403, 'weight': 12, 'content': [{'end': 4518.485, 'text': 'So this is how we can make use of the string calculations.', 'start': 4514.403, 'duration': 4.082}, {'end': 4518.945, 'text': 'All right.', 'start': 4518.625, 'duration': 0.32}, {'end': 4523.387, 'text': 'Next now, let us see how we can make use of the date calculation.', 'start': 4520.046, 'duration': 3.341}, {'end': 4526.647, 'text': "Now, we've already performed this kind of a calculation.", 'start': 4523.806, 'duration': 2.841}, {'end': 4531.85, 'text': "So I'm going to explain in terms of the date calculation, when we wrote in the dates to ship,", 'start': 4526.687, 'duration': 5.163}, {'end': 4536.972, 'text': 'what each of it meant all right when we wanted to analyze the difference.', 'start': 4531.85, 'duration': 5.122}, {'end': 4539.393, 'text': "Yes, it's going to be case sensitive in that case, Sujay.", 'start': 4537.072, 'duration': 2.321}, {'end': 4540.374, 'text': "You're absolutely right.", 'start': 4539.413, 'duration': 0.961}], 'summary': 'Explanation of string and date calculations with a focus on analyzing differences.', 'duration': 25.971, 'max_score': 4514.403, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4514403.jpg'}, {'end': 4816.742, 'src': 'embed', 'start': 4742.599, 'weight': 13, 'content': [{'end': 4746.342, 'text': "So for that we're going to create a calculated sheet.", 'start': 4742.599, 'duration': 3.743}, {'end': 4751.573, 'text': 'that will only specify the sales of subcategories of 100, 000 and above.', 'start': 4746.789, 'duration': 4.784}, {'end': 4753.374, 'text': "So let's create the calculated field.", 'start': 4751.593, 'duration': 1.781}, {'end': 4757.317, 'text': "Let's give it a name as sales KPI.", 'start': 4753.894, 'duration': 3.423}, {'end': 4762.021, 'text': "And now this is where we're going to provide logical functions and operators.", 'start': 4758.238, 'duration': 3.783}, {'end': 4764.503, 'text': 'And let me enter the syntax.', 'start': 4762.801, 'duration': 1.702}, {'end': 4816.742, 'text': "So I'm saying if my sum of sales KPI so the bracket if my sum of sales is greater than a hundred thousand then hi and and let's end the syntax here.", 'start': 4764.523, 'duration': 52.219}], 'summary': 'Creating a calculated sheet to specify subcategory sales of 100,000 and above.', 'duration': 74.143, 'max_score': 4742.599, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4742599.jpg'}], 'start': 3628.243, 'title': 'Tableau calculations and functions', 'summary': 'Provides an overview of tableau calculations, including working with strings, dates, logical and arithmetic calculations, aggregation options, creating bar charts, using aggregation functions, and creating calculated fields to analyze sales data, with examples and practical techniques for meaningful analysis.', 'chapters': [{'end': 3817.337, 'start': 3628.243, 'title': 'Tableau calculations overview', 'summary': 'Provides an overview of tableau calculations, including how to work with strings, dates, logical and arithmetic calculations, various aggregation options, quick table calculations, automatic and custom splits, ad hoc analytics, and level of details calculations, with the goal of enabling the creation of meaningful results from the data.', 'duration': 189.094, 'highlights': ['Tableau provides various built-in functions for creating arithmetic, string, date, and logical calculations, enabling the creation of new fields not present in the underlying data. Tableau offers built-in functions for arithmetic, string, date, and logical calculations, allowing the creation of new fields using specific formulas, operators, and functions.', 'Understanding how to use aggregation options, grand totals, subtotals, and quick table calculations provided by Tableau. The chapter covers the usage of different aggregation options, grand totals, subtotals, and quick table calculations offered by Tableau for data analysis.', 'Exploring automatic and custom splits, ad hoc analytics, and performing level of details calculations within Tableau. The chapter delves into the exploration of automatic and custom splits, ad hoc analytics, and the execution of level of details calculations in Tableau for advanced data manipulation and analysis.']}, {'end': 4068.925, 'start': 3817.337, 'title': 'Creating bar chart and using aggregation functions', 'summary': 'Discusses creating a bar chart and using aggregation functions to analyze sales data by demonstrating the process of creating a bar chart, selecting aggregation functions, and explaining the use of calculated fields for analyzing sales data.', 'duration': 251.588, 'highlights': ['The chapter demonstrates the process of creating a bar chart by adding states to rows and sales to columns, and then creating a bar chart to analyze sales across each state.', 'The speaker explains the process of using aggregation functions, specifically demonstrating the selection of count distinct for analyzing the count of distinct items in the product name field.', 'The chapter also covers the use of calculated fields to create a new field for analyzing sales per item, showcasing the process of creating a calculated field for performing arithmetic calculation.']}, {'end': 4370.041, 'start': 4072.666, 'title': 'Creating calculated fields in tableau', 'summary': 'Explains the process of creating calculated fields in tableau, including sales per item calculation using count distinct of product names, and creating a string calculation to analyze customers beginning with the letter s.', 'duration': 297.375, 'highlights': ['Creating sales per item calculation using count distinct of product names The process involves dividing the sales based on the count distinct of the product name to create a sales per item calculation.', 'Adding and placing the sales per item measure in the columns The new measure for sales per item is added and placed in the columns, as it returns a specific numerical value.', 'Explanation of using calculated fields to change aggregation functions and its limitations The limitations of changing aggregation functions for a calculated field are explained, as it is already aggregated based on the arithmetic calculation method.', 'Demonstration of creating a string calculation to analyze customers beginning with the letter S The process involves using a calculated field to identify and provide a discount to customers whose names begin with the letter S.', 'Exploring the functions and types available for creating calculated fields in Tableau The transcript illustrates the various functions and types provided by Tableau for creating calculated fields, including number, string, date type conversion, logical aggregate, user, and table calculation.']}, {'end': 4936.394, 'start': 4370.722, 'title': 'Tableau calculations and functions', 'summary': 'Explores creating calculated fields using string, date, and logical calculations in tableau, including examples of filtering customer names, date differences, and sales kpis.', 'duration': 565.672, 'highlights': ["Creating a calculated field to filter customer names beginning with 'S' The function demonstrates creating a calculated field to filter customer names beginning with 'S' and using a Boolean logic to include the specified option, resulting in a list of customer names starting with 'S'.", 'Explaining the date difference calculation using date functions The explanation covers using the date difference function to analyze the number of days required for shipping products, including the three inputs required for the calculation and the case sensitivity when specifying the part and role in the function.', 'Creating a calculated field for sales KPI highlighting subcategories with sales over $100,000 The example illustrates creating a calculated field to highlight subcategories with sales over $100,000, using logical functions and operators to distinguish between high and low sales, and adding the calculated field to the colors for visualization.']}], 'duration': 1308.151, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY3628243.jpg', 'highlights': ['Tableau provides various built-in functions for creating arithmetic, string, date, and logical calculations.', 'Understanding how to use aggregation options, grand totals, subtotals, and quick table calculations provided by Tableau.', 'Exploring automatic and custom splits, ad hoc analytics, and performing level of details calculations within Tableau.', 'The chapter demonstrates the process of creating a bar chart by adding states to rows and sales to columns.', 'The speaker explains the process of using aggregation functions, specifically demonstrating the selection of count distinct for analyzing the count of distinct items in the product name field.', 'The chapter also covers the use of calculated fields to create a new field for analyzing sales per item.', 'Creating sales per item calculation using count distinct of product names.', 'Adding and placing the sales per item measure in the columns.', 'Explanation of using calculated fields to change aggregation functions and its limitations.', 'Demonstration of creating a string calculation to analyze customers beginning with the letter S.', 'Exploring the functions and types available for creating calculated fields in Tableau.', "Creating a calculated field to filter customer names beginning with 'S'.", 'Explaining the date difference calculation using date functions.', 'Creating a calculated field for sales KPI highlighting subcategories with sales over $100,000.']}, {'end': 6246.647, 'segs': [{'end': 5076.699, 'src': 'embed', 'start': 5050.972, 'weight': 1, 'content': [{'end': 5060.243, 'text': "you've noticed a couple of times that by default we have our calculation wherein tableau takes in a default calculation, all right being the sum,", 'start': 5050.972, 'duration': 9.271}, {'end': 5063.974, 'text': 'But you can change these aggregation functions.', 'start': 5060.973, 'duration': 3.001}, {'end': 5067.055, 'text': 'You can see an entire list that Tableau provides to us.', 'start': 5063.994, 'duration': 3.061}, {'end': 5071.577, 'text': "And that's how you can make use of these aggregated functions.", 'start': 5068.036, 'duration': 3.541}, {'end': 5076.699, 'text': 'That is your, whether you want to have a summation, whether you want to have an average.', 'start': 5071.637, 'duration': 5.062}], 'summary': 'Tableau allows changing aggregation functions, such as sum and average.', 'duration': 25.727, 'max_score': 5050.972, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY5050972.jpg'}, {'end': 5117.037, 'src': 'embed', 'start': 5088.584, 'weight': 0, 'content': [{'end': 5096.007, 'text': 'And these will help you perform the kind of aggregation, the kind of calculation that you want to perform on that particular field.', 'start': 5088.584, 'duration': 7.423}, {'end': 5099.148, 'text': 'So, you can make use of these functions.', 'start': 5096.607, 'duration': 2.541}, {'end': 5110.513, 'text': 'So, now understand one thing, you can use Tableau to set up your aggregations only for measures in your relational data sources.', 'start': 5099.528, 'duration': 10.985}, {'end': 5117.037, 'text': 'All right, in terms of a multi-dimensional data source, it contains the aggregated data already.', 'start': 5111.195, 'duration': 5.842}], 'summary': 'Tableau can set up aggregations for measures in relational data sources, while multi-dimensional data sources contain pre-aggregated data.', 'duration': 28.453, 'max_score': 5088.584, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY5088584.jpg'}, {'end': 5515.211, 'src': 'embed', 'start': 5489.173, 'weight': 2, 'content': [{'end': 5499.504, 'text': 'it allows us to provide that kind of functionality wherein it computes the applied values all right in your entire table.', 'start': 5489.173, 'duration': 10.331}, {'end': 5506.006, 'text': 'And this is basically dependent on the structure, the table structure that you have in your view, okay?', 'start': 5500.163, 'duration': 5.843}, {'end': 5508.908, 'text': "So that's how you can make use of table calculations.", 'start': 5506.206, 'duration': 2.702}, {'end': 5515.211, 'text': 'And what Tableau does is, it provides some inbuilt functions which are usually in use.', 'start': 5508.988, 'duration': 6.223}], 'summary': 'Tableau allows for computed values based on table structure and provides inbuilt functions.', 'duration': 26.038, 'max_score': 5489.173, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY5489173.jpg'}, {'end': 5763.204, 'src': 'embed', 'start': 5733.796, 'weight': 3, 'content': [{'end': 5735.797, 'text': 'all right, you already said moving average,', 'start': 5733.796, 'duration': 2.001}, {'end': 5746.4, 'text': 'but this is one of the calculations that can be a moving average or any other calculation wherein moving calculations will ideally show us a fluctuation,', 'start': 5735.797, 'duration': 10.603}, {'end': 5750.181, 'text': 'a fluctuation that we can identify in terms of long trends.', 'start': 5746.4, 'duration': 3.781}, {'end': 5753.122, 'text': 'So that is what moving calculations are.', 'start': 5751.282, 'duration': 1.84}, {'end': 5763.204, 'text': "So we will see an example of this, of what are moving calculations, and that's how you'll be able to understand the difference of what these are.", 'start': 5753.522, 'duration': 9.682}], 'summary': 'Moving calculations like moving average help identify fluctuations in long trends.', 'duration': 29.408, 'max_score': 5733.796, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY5733796.jpg'}, {'end': 6027.817, 'src': 'embed', 'start': 5999.176, 'weight': 4, 'content': [{'end': 6008.203, 'text': "So I'm just going to undo and go back to our previous view where we were performing our table calculation and we selected the running total.", 'start': 5999.176, 'duration': 9.027}, {'end': 6018.273, 'text': "we had our summation summarizing at average, and we selected a particular field, all right? And let's click on OK.", 'start': 6010.549, 'duration': 7.724}, {'end': 6020.594, 'text': 'Let me enable the data label.', 'start': 6019.033, 'duration': 1.561}, {'end': 6027.817, 'text': "So here now, we can see our calculation that it's performing or running average of sales here for us now.", 'start': 6021.034, 'duration': 6.783}], 'summary': 'Performing running average of sales using table calculation.', 'duration': 28.641, 'max_score': 5999.176, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY5999176.jpg'}], 'start': 4937.495, 'title': 'Tableau sales kpi, aggregation, and calculation customization', 'summary': 'Covers sales kpi calculations in tableau with multiple conditions, aggregation options, functions like attr, count, sum, and customization of table calculations. it explains the usage of grand totals, subtotals, quick table calculations, and performing secondary calculations.', 'chapters': [{'end': 5180.976, 'start': 4937.495, 'title': 'Sales kpi and aggregation options in tableau', 'summary': 'Covers using multiple conditions for sales kpi calculations, including examples and scenarios, and then explains working with aggregation options in tableau, highlighting the ability to change default aggregation functions and use different mathematical functions for producing aggregated data.', 'duration': 243.481, 'highlights': ['The chapter covers using multiple conditions for sales KPI calculations, including examples and scenarios, and then explains working with aggregation options in Tableau.', 'You can use a case in which you can mention the east, west, or low and use different sales and budget scenarios to create calculated fields with multiple conditions.', 'Tableau provides a list of aggregation functions including summation, average, and other mathematical functions, each producing a particular aggregated data for performing the kind of calculation on the field.', 'You can change the default aggregation functions in Tableau, including options for average, median, count, count distinct, and other functions.', 'In multi-dimensional data sources, aggregated data is already contained, and predefined aggregations are provided by Tableau.']}, {'end': 5393.909, 'start': 5180.976, 'title': 'Tableau aggregation functions', 'summary': 'Explains the use of aggregation functions in tableau, including attr, count, count distinct, sum, average, median, and their utility in returning single values, unique values, and ignoring null values.', 'duration': 212.933, 'highlights': ['Tableau provides various inbuilt aggregation functions such as ATTR, count, count distinct, sum, average, and median. This highlights the availability of various inbuilt aggregation functions in Tableau.', 'The ATTR function returns the value of the expression if it only has a single value for all the rows in that group or displays an asterisk if not. This highlights the behavior of the ATTR function in returning single values or displaying an asterisk.', 'The count function returns the number of rows in the measure or dimension, ignoring null values, while count distinct returns the number of unique values. This highlights the difference between count and count distinct functions in returning all values and unique values respectively.']}, {'end': 5711.387, 'start': 5395.289, 'title': 'Tableau: totals, subtotals, and quick calculations', 'summary': 'Highlights the usage of grand totals and subtotals in tableau, enabling users to display subtotals and grand totals for data, and explains the functionality of quick table calculations, including examples of various inbuilt functions with their specific uses.', 'duration': 316.098, 'highlights': ['Tableau provides the functionality to add grand totals and subtotals, allowing users to display the subtotals and grand totals for data, visible in the grid.', 'Quick table calculations in Tableau enable users to apply various inbuilt functions such as running total, difference, percent difference, percent of total, rank, percentile, moving average, compound growth rates, and more, providing instant calculations based on specified requirements.', "Tableau's quick table calculations allow users to instantly compute and view calculations, such as percent to total, providing insights into the contribution of each year towards the entire total, enabling users to understand the data more effectively.", 'The process of enabling grand totals in Tableau involves accessing the analysis menu and enabling the total option, providing users with the capability to add grand totals to their data.']}, {'end': 5998.976, 'start': 5711.387, 'title': 'Customizing table calculations', 'summary': 'Covers customizing table calculations, including the concept of moving calculations and the process of manually performing customized table calculations, with a focus on the functions and computations involved.', 'duration': 287.589, 'highlights': ['Understanding the concept of moving calculations and their ability to identify fluctuations in long trends. Concept of moving calculations and their ability to identify fluctuations in long trends.', 'Explanation of the process of manually performing customized table calculations. Process of manually performing customized table calculations.', 'Explanation of the functions and computations involved in customized table calculations. Explanation of the functions and computations involved in customized table calculations.']}, {'end': 6246.647, 'start': 5999.176, 'title': 'Table calculations and secondary calculations', 'summary': 'Explains performing table calculations, selecting running total, enabling data labels, applying secondary calculations, specifying levels for calculation, and customizing calculations.', 'duration': 247.471, 'highlights': ['Performing table calculations such as running total and average. Explanation of performing table calculations like running total and average.', 'Applying secondary calculations to combine two calculations. Explanation of applying secondary calculations to combine two different calculations and the relevance of doing so.', 'Specifying levels for secondary calculations, such as yearly, quarterly, monthly, or daily levels. Information on specifying levels for secondary calculations, including options like yearly, quarterly, monthly, or daily levels.', 'Customizing calculations and editing table calculations. Information on customizing and editing table calculations to meet specific business needs and scenarios.']}], 'duration': 1309.152, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY4937495.jpg', 'highlights': ['The chapter covers using multiple conditions for sales KPI calculations, including examples and scenarios, and then explains working with aggregation options in Tableau.', 'Tableau provides various inbuilt aggregation functions such as ATTR, count, count distinct, sum, average, and median.', 'Quick table calculations in Tableau enable users to apply various inbuilt functions such as running total, difference, percent difference, percent of total, rank, percentile, moving average, compound growth rates, and more, providing instant calculations based on specified requirements.', 'Understanding the concept of moving calculations and their ability to identify fluctuations in long trends.', 'Performing table calculations such as running total and average.']}, {'end': 7135.72, 'segs': [{'end': 6382.798, 'src': 'embed', 'start': 6352.99, 'weight': 0, 'content': [{'end': 6357.454, 'text': 'All right, and that creates our line chart.', 'start': 6352.99, 'duration': 4.464}, {'end': 6357.914, 'text': "We're done.", 'start': 6357.494, 'duration': 0.42}, {'end': 6360.757, 'text': 'Next, we need to drill at a quarterly level.', 'start': 6358.415, 'duration': 2.342}, {'end': 6366.762, 'text': "All right, so let's drill our data and have a quarterly level.", 'start': 6360.777, 'duration': 5.985}, {'end': 6369.765, 'text': 'All right.', 'start': 6366.782, 'duration': 2.983}, {'end': 6374.729, 'text': 'and finally, then let us now have now we need to perform.', 'start': 6369.765, 'duration': 4.964}, {'end': 6378.693, 'text': 'we can see the sales and now we need to know the variance, the difference.', 'start': 6374.729, 'duration': 3.964}, {'end': 6382.798, 'text': 'all right, we want to know or we want to create a table calculation with difference.', 'start': 6378.693, 'duration': 4.105}], 'summary': 'Create line chart, drill quarterly data, analyze sales variance, and perform table calculation.', 'duration': 29.808, 'max_score': 6352.99, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY6352990.jpg'}, {'end': 6533.652, 'src': 'embed', 'start': 6505.708, 'weight': 1, 'content': [{'end': 6508.01, 'text': "So that's how we can make use of table calculations.", 'start': 6505.708, 'duration': 2.302}, {'end': 6512.292, 'text': "I'm going to move ahead with understanding what are box plots.", 'start': 6508.03, 'duration': 4.262}, {'end': 6513.273, 'text': 'All right.', 'start': 6512.953, 'duration': 0.32}, {'end': 6519.817, 'text': 'So in terms of box plots, now these are used when we want to compare a set of data.', 'start': 6513.653, 'duration': 6.164}, {'end': 6520.318, 'text': 'All right.', 'start': 6519.937, 'duration': 0.381}, {'end': 6529.964, 'text': 'And when we want to ideally analyze a distribution of data, which is highlighted up to five key values.', 'start': 6521.078, 'duration': 8.886}, {'end': 6530.444, 'text': 'All right.', 'start': 6530.124, 'duration': 0.32}, {'end': 6531.265, 'text': 'Within our data.', 'start': 6530.564, 'duration': 0.701}, {'end': 6532.851, 'text': "So that's a box plot.", 'start': 6531.69, 'duration': 1.161}, {'end': 6533.652, 'text': 'What it usually.', 'start': 6532.891, 'duration': 0.761}], 'summary': 'Box plots compare data distribution with up to five key values.', 'duration': 27.944, 'max_score': 6505.708, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY6505708.jpg'}, {'end': 6772.742, 'src': 'embed', 'start': 6749.142, 'weight': 5, 'content': [{'end': 6758.048, 'text': 'But to create a box plot, we can right click on the axis and go on to the reference line and choose the box plot option.', 'start': 6749.142, 'duration': 8.906}, {'end': 6767.598, 'text': 'Now this is where you can specify the whisker extending to your within the data within the 1.5% or the maximum extent of the data right?', 'start': 6758.413, 'duration': 9.185}, {'end': 6769.86, 'text': 'The minimum and maximum that we were talking about.', 'start': 6767.618, 'duration': 2.242}, {'end': 6772.742, 'text': 'The style of how you want it to look like.', 'start': 6770.32, 'duration': 2.422}], 'summary': 'Create a box plot with whiskers extending within 1.5% or maximum data range.', 'duration': 23.6, 'max_score': 6749.142, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY6749142.jpg'}, {'end': 6946.504, 'src': 'embed', 'start': 6922.508, 'weight': 2, 'content': [{'end': 6932.4, 'text': 'so its assigned the regions here, as you can see in terms we can see the regions and in the columns from the mark shelf right.', 'start': 6922.508, 'duration': 9.892}, {'end': 6936.061, 'text': 'remember that there will be regions which is placed in the columns.', 'start': 6932.4, 'duration': 3.661}, {'end': 6942.163, 'text': 'as soon as we selected on box plot, it automatically assigned region on the columns shelf.', 'start': 6936.061, 'duration': 6.102}, {'end': 6944.604, 'text': 'here in the marks card it reassigned it.', 'start': 6942.163, 'duration': 2.441}, {'end': 6946.504, 'text': 'let me just undo this option.', 'start': 6944.604, 'duration': 1.9}], 'summary': 'Demonstrating automatic region assignment in data visualization.', 'duration': 23.996, 'max_score': 6922.508, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY6922508.jpg'}, {'end': 7040.118, 'src': 'embed', 'start': 7011.756, 'weight': 3, 'content': [{'end': 7019.809, 'text': "Alright. Now what's happening here is it is aggregating the entire data in the current view and we can see a flattened view, a flattened look of our data here.", 'start': 7011.756, 'duration': 8.053}, {'end': 7023.431, 'text': 'So we want to disaggregate our measures in that matter.', 'start': 7020.289, 'duration': 3.142}, {'end': 7033.595, 'text': 'We want to have our aggregation level changed and disaggregate our data where it can give us an entire distribution of our data.', 'start': 7023.531, 'duration': 10.064}, {'end': 7040.118, 'text': "So here in the analysis menu, click on the analysis menu, you can see aggregated measures that's been enabled.", 'start': 7034.035, 'duration': 6.083}], 'summary': 'Aggregating and disaggregating data to obtain a comprehensive distribution.', 'duration': 28.362, 'max_score': 7011.756, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY7011756.jpg'}, {'end': 7066.22, 'src': 'embed', 'start': 7045.653, 'weight': 4, 'content': [{'end': 7060.738, 'text': 'alright. so I am going to disaggregate the measures here so that we can now see that the data which has is at a disaggregated level wherein we can now understand each of these marks instead of a single mark.', 'start': 7045.653, 'duration': 15.085}, {'end': 7066.22, 'text': 'we are able to view each of the marks for every column in a range of the data source that we have, alright.', 'start': 7060.738, 'duration': 5.482}], 'summary': 'Disaggregating measures allows for a detailed view of each mark for every column in the data source.', 'duration': 20.567, 'max_score': 7045.653, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY7045653.jpg'}], 'start': 6247.447, 'title': 'Sales variance analysis and box plots', 'summary': 'Covers the process of determining sales variance for year-over-year growth through quarterly breakdown, utilizing line charts and table calculations. it also explains the application of box plots in data analysis, and demonstrates creating and customizing box plots in tableau.', 'chapters': [{'end': 6881.979, 'start': 6247.447, 'title': 'Sales variance analysis and box plots', 'summary': 'Demonstrates the process of determining the sales variance for year-over-year growth through a quarterly breakdown, utilizing line charts and table calculations, followed by an explanation of box plots and their application in data analysis.', 'duration': 634.532, 'highlights': ['Sales Variance Analysis Process The chapter outlines the process of creating a line chart for year-over-year sales analysis, drilling down to quarterly breakdown, and performing table calculations to determine the sales variance, providing a comprehensive approach for sales analysis.', 'Box Plot Explanation A detailed explanation of box plots is provided, highlighting their function in analyzing the distribution of data, showcasing the visualization of the middle 50% of data, and the representation of minimum, median, and maximum values within the data.']}, {'end': 7135.72, 'start': 6883.019, 'title': 'Using box plot in tableau', 'summary': 'Demonstrates how to create and customize a box plot in tableau, emphasizing the process of changing chart types, managing aggregation levels, and adding additional analysis for visual enhancement.', 'duration': 252.701, 'highlights': ['Tableau determines individual marks for representation based on region when changing chart types, such as from a bar chart to a box plot. Tableau automatically assigns region on the columns shelf when changing from a bar chart to a box plot, allowing for visualization of individual marks based on region.', 'Box plot is intended to show the distribution of data, providing a flattened view of the aggregated data in the current view. Box plot aggregates the entire data in the current view and displays a flattened view to show the distribution of the data.', 'Disaggregating measures enables understanding of each individual mark for every column in the data source. Disaggregating measures allows for viewing each individual mark for every column in the data source, providing a detailed understanding of the data.', 'Customizing the box plot involves editing reference lines, changing banding and colors, and adjusting transparency levels for visual enhancement. The process of customizing the box plot includes editing reference lines, altering banding and colors, and adjusting transparency levels, thereby enhancing the visual appeal of the plot.']}], 'duration': 888.273, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY6247447.jpg', 'highlights': ['The chapter outlines the process of creating a line chart for year-over-year sales analysis, drilling down to quarterly breakdown, and performing table calculations to determine the sales variance, providing a comprehensive approach for sales analysis.', 'A detailed explanation of box plots is provided, highlighting their function in analyzing the distribution of data, showcasing the visualization of the middle 50% of data, and the representation of minimum, median, and maximum values within the data.', 'Tableau automatically assigns region on the columns shelf when changing from a bar chart to a box plot, allowing for visualization of individual marks based on region.', 'Box plot aggregates the entire data in the current view and displays a flattened view to show the distribution of the data.', 'Disaggregating measures allows for viewing each individual mark for every column in the data source, providing a detailed understanding of the data.', 'The process of customizing the box plot includes editing reference lines, altering banding and colors, and adjusting transparency levels, thereby enhancing the visual appeal of the plot.']}, {'end': 8190.452, 'segs': [{'end': 7189.602, 'src': 'embed', 'start': 7136.621, 'weight': 0, 'content': [{'end': 7141.523, 'text': 'Now with that, we can see that the discount is pretty much the same.', 'start': 7136.621, 'duration': 4.902}, {'end': 7147.346, 'text': 'The discount is pretty much the same for all the segments here.', 'start': 7142.083, 'duration': 5.263}, {'end': 7151.034, 'text': "If you notice in terms of whenever we're seeing all the west, All right.", 'start': 7147.446, 'duration': 3.588}, {'end': 7153.695, 'text': 'The discounts are pretty much the same for all the segments.', 'start': 7151.314, 'duration': 2.381}, {'end': 7158.416, 'text': 'Right That is one analysis that we can see.', 'start': 7154.375, 'duration': 4.041}, {'end': 7167.278, 'text': 'Also we can see that the interquartile range that is the 25% to the 75% of the discount.', 'start': 7159.056, 'duration': 8.222}, {'end': 7171.899, 'text': 'We have the central region and that is showing us the highest range.', 'start': 7167.698, 'duration': 4.201}, {'end': 7178.356, 'text': 'So this is how they are able to identify and see the highest ranges here.', 'start': 7173.172, 'duration': 5.184}, {'end': 7183.499, 'text': 'So each of it is representing the entire detailing that you can see here.', 'start': 7178.676, 'duration': 4.823}, {'end': 7189.602, 'text': 'So the boxes here, these boxes are representing the 50% of our data.', 'start': 7183.799, 'duration': 5.803}], 'summary': 'Discounts are consistent across segments, with the central region showing the highest range.', 'duration': 52.981, 'max_score': 7136.621, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY7136621.jpg'}, {'end': 7293.106, 'src': 'embed', 'start': 7251.761, 'weight': 5, 'content': [{'end': 7260.564, 'text': 'Now, formatting, as we already know, as we are aware, is a very important part of both our analysis as well as our presentation.', 'start': 7251.761, 'duration': 8.803}, {'end': 7263.886, 'text': 'Everything that you see, that you view in your sheet.', 'start': 7261.065, 'duration': 2.821}, {'end': 7269.968, 'text': 'you want to ensure that there is a proper formatting applied, that our shading fonts, lines and borders.', 'start': 7263.886, 'duration': 6.082}, {'end': 7275.084, 'text': 'All of this makes a lot of difference when it comes to how you want to present and view your data.', 'start': 7270.538, 'duration': 4.546}, {'end': 7283.215, 'text': "So it is pretty important and hence, in this particular chapter, we're going to be discussing on different formatting options that are available,", 'start': 7275.986, 'duration': 7.229}, {'end': 7292.325, 'text': 'how we can format our visualizations, how we can make use of the colors, the worksheet themes, in terms of resizing, in terms of working with labels,', 'start': 7283.215, 'duration': 9.11}, {'end': 7293.106, 'text': 'the mark type.', 'start': 7292.325, 'duration': 0.781}], 'summary': 'Proper formatting is crucial for data presentation and analysis, including shading, fonts, lines, and borders.', 'duration': 41.345, 'max_score': 7251.761, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY7251761.jpg'}, {'end': 7385.002, 'src': 'embed', 'start': 7338.041, 'weight': 3, 'content': [{'end': 7346.125, 'text': 'Before I proceed here, let me now move to the Tableau environment here and click on a new sheet.', 'start': 7338.041, 'duration': 8.084}, {'end': 7348.767, 'text': 'Now talking about spatial analysis.', 'start': 7346.606, 'duration': 2.161}, {'end': 7352.948, 'text': 'Spatial analysis is what is related to your geographic data, all right?', 'start': 7349.206, 'duration': 3.742}, {'end': 7354.709, 'text': 'So Tableau works.', 'start': 7353.288, 'duration': 1.421}, {'end': 7357.631, 'text': 'now how it works with fields in a special manner.', 'start': 7354.709, 'duration': 2.922}, {'end': 7361.213, 'text': 'Tableau also works with the geographic fields in a special manner.', 'start': 7357.631, 'duration': 3.582}, {'end': 7369.845, 'text': 'It gives spatial data some special importance It automatically assigns geographic roles to any data that you have in your data source.', 'start': 7361.293, 'duration': 8.552}, {'end': 7372.367, 'text': 'So if you notice I had discussed this yesterday.', 'start': 7369.865, 'duration': 2.502}, {'end': 7379.536, 'text': 'Right in your data source it can identify if there is any kind of data related to geography.', 'start': 7372.848, 'duration': 6.688}, {'end': 7382.439, 'text': 'It automatically assigns it with a geographic role.', 'start': 7379.676, 'duration': 2.763}, {'end': 7385.002, 'text': 'So that is a speciality of Tableau.', 'start': 7383.04, 'duration': 1.962}], 'summary': 'Tableau automatically assigns geographic roles to spatial data in the data source.', 'duration': 46.961, 'max_score': 7338.041, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY7338041.jpg'}, {'end': 7632.317, 'src': 'embed', 'start': 7608.588, 'weight': 6, 'content': [{'end': 7618.893, 'text': 'So this means Tableau allows you to either format your particular font or shading or bordering or coloring for the entire sheet,', 'start': 7608.588, 'duration': 10.305}, {'end': 7620.954, 'text': 'or you can also do it for a particular row.', 'start': 7618.893, 'duration': 2.061}, {'end': 7629.575, 'text': 'or a column, right? So, it gives you that option or you can select a particular field as well, whether you want to format a particular field.', 'start': 7621.63, 'duration': 7.945}, {'end': 7632.317, 'text': 'Now in terms of the font.', 'start': 7630.636, 'duration': 1.681}], 'summary': 'Tableau allows formatting for font, shading, bordering, and coloring for the entire sheet or specific rows, columns, or fields.', 'duration': 23.729, 'max_score': 7608.588, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY7608588.jpg'}, {'end': 8123.676, 'src': 'embed', 'start': 8097.026, 'weight': 8, 'content': [{'end': 8103.348, 'text': 'So there was a question put up where we were asked can we format the currency??', 'start': 8097.026, 'duration': 6.322}, {'end': 8105.929, 'text': 'So you have your answer.', 'start': 8103.509, 'duration': 2.42}, {'end': 8109.111, 'text': 'your questions been answered right here in terms of formatting.', 'start': 8105.929, 'duration': 3.182}, {'end': 8109.951, 'text': 'All right.', 'start': 8109.671, 'duration': 0.28}, {'end': 8111.672, 'text': 'So there we go.', 'start': 8110.271, 'duration': 1.401}, {'end': 8119.955, 'text': 'We can also format in terms of the numbering options as to how we want to format it based on the options here for number format.', 'start': 8111.712, 'duration': 8.243}, {'end': 8121.976, 'text': 'I will let you all know each of these options.', 'start': 8120.115, 'duration': 1.861}, {'end': 8123.676, 'text': 'So automatic is.', 'start': 8122.016, 'duration': 1.66}], 'summary': 'Answered formatting currency and numbering options.', 'duration': 26.65, 'max_score': 8097.026, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY8097026.jpg'}], 'start': 7136.621, 'title': 'Tableau formatting and spatial analysis', 'summary': 'Covers the analysis of discount consistency and range using box plots, as well as the importance of formatting in tableau, including spatial data analysis and map creation, and detailed explanations of formatting options like fonts, alignment, shading, borders, lines, and numbers.', 'chapters': [{'end': 7250.636, 'start': 7136.621, 'title': 'Analyzing discount and range with box plot', 'summary': 'Demonstrates the analysis of discount consistency across segments and the identification of the highest range using interquartile values in a box plot visualization.', 'duration': 114.015, 'highlights': ['The discount is pretty much the same for all segments, providing consistency in discount distribution across different segments.', 'The interquartile range analysis reveals the central region having the highest range, indicating the variability in discounts within the central region.', 'The box plot visualization represents 50% of the data, with the central box indicating the interquartile range and the whiskers showing the minimum and maximum values, providing a comprehensive understanding of the discount distribution.']}, {'end': 7490.514, 'start': 7251.761, 'title': 'Formatting and spatial analysis in tableau', 'summary': 'Covers the importance of formatting in analysis and presentation, as well as the various formatting options available in tableau, such as working with spatial data and creating maps.', 'duration': 238.753, 'highlights': ['Tableau automatically assigns geographic roles to data with spatial importance, providing options to customize roles and data types, improving spatial data analysis.', 'Understanding spatial analysis in Tableau, including how it automatically identifies and processes geographic data, such as adding longitude and latitude for mapping.', 'Importance of proper formatting in data presentation, including shading, fonts, lines, borders, and worksheet themes for effective visualization and analysis.']}, {'end': 8190.452, 'start': 7491.516, 'title': 'Formatting in tableau', 'summary': 'Discusses various formatting options in tableau, including formatting fonts, alignment, shading, borders, lines, and numbers, with examples and detailed explanations of each option.', 'duration': 698.936, 'highlights': ['Tableau allows you to format fonts, alignments, shading, borders, and lines for the entire sheet, a particular row, column, or field, offering flexibility in customizing the view. Tableau provides flexibility in formatting by allowing users to format fonts, alignments, shading, borders, and lines for the entire sheet, a specific row, column, or field, catering to individual customization needs.', 'The formatting options include customizing fonts, alignments, shading, borders, and lines based on the type of visualization, such as text tables, highlight tables, or heat maps. Users can customize fonts, alignments, shading, borders, and lines based on the visualization type, like text tables, highlight tables, or heat maps, providing tailored formatting for different visualizations.', 'Formatting numbers in Tableau involves options for automatic, standard, custom, and currency formats, allowing users to customize the display based on locale and personal preferences. Tableau offers options for automatic, standard, custom, and currency formats for formatting numbers, empowering users to customize the display based on locale and personal preferences.']}], 'duration': 1053.831, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY7136621.jpg', 'highlights': ['The discount is consistent across segments, ensuring uniform distribution.', 'The central region has the highest range, indicating variability in discounts.', 'Box plot visualization provides a comprehensive understanding of discount distribution.', 'Tableau automatically assigns geographic roles, improving spatial data analysis.', 'Understanding spatial analysis in Tableau, including automatic identification of geographic data.', 'Importance of proper formatting in data presentation for effective visualization and analysis.', 'Tableau allows flexible formatting for fonts, alignments, shading, borders, and lines.', 'Customizing formatting options based on visualization type for tailored formatting.', 'Options for automatic, standard, custom, and currency formats for formatting numbers.']}, {'end': 9464.57, 'segs': [{'end': 8333.484, 'src': 'embed', 'start': 8312.827, 'weight': 3, 'content': [{'end': 8322.627, 'text': 'And in this particular window, you have Four tabs as you can see, one being the general, one being wildcard, one being condition and top.', 'start': 8312.827, 'duration': 9.8}, {'end': 8330.298, 'text': "Now let me first explain each of these tabs and then we'll proceed further in understanding how we can filter on the dimension here.", 'start': 8322.986, 'duration': 7.312}, {'end': 8333.484, 'text': 'So, in the general option,', 'start': 8331.942, 'duration': 1.542}], 'summary': 'Explanation of four tabs for filtering data in a window.', 'duration': 20.657, 'max_score': 8312.827, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY8312826.jpg'}, {'end': 8401.465, 'src': 'embed', 'start': 8376.647, 'weight': 2, 'content': [{'end': 8384.232, 'text': 'that value contains that particular alphabet or starts with that alphabet, ends with that alphabet or exactly matches that alphabet.', 'start': 8376.647, 'duration': 7.585}, {'end': 8390.795, 'text': "So let's say, let's use the wildcard option and say I want the names starting with All right.", 'start': 8384.573, 'duration': 6.222}, {'end': 8396.12, 'text': 'The alphabet, let me choose the alphabet S.', 'start': 8391.156, 'duration': 4.964}, {'end': 8396.48, 'text': 'All right.', 'start': 8396.12, 'duration': 0.36}, {'end': 8401.465, 'text': "So I'm saying that all my customer names should start with the alphabet S.", 'start': 8396.701, 'duration': 4.764}], 'summary': 'Wildcard option used to filter customer names starting with the alphabet s.', 'duration': 24.818, 'max_score': 8376.647, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY8376647.jpg'}, {'end': 9382.44, 'src': 'embed', 'start': 9332.676, 'weight': 0, 'content': [{'end': 9335.619, 'text': 'You can drag a particular field right into the filter shelf.', 'start': 9332.676, 'duration': 2.943}, {'end': 9339.442, 'text': 'You can also turn on the quick filter and make use of it.', 'start': 9336.039, 'duration': 3.403}, {'end': 9341.484, 'text': 'So that is the filter shelf.', 'start': 9339.803, 'duration': 1.681}, {'end': 9348.511, 'text': 'We saw depending on the type, we can filter on a dimension or we can filter on a measure or a date as well.', 'start': 9341.544, 'duration': 6.967}, {'end': 9354.94, 'text': 'For complex analytical projects, organizing and simplifying data is one of the crucial tasks.', 'start': 9349.278, 'duration': 5.662}, {'end': 9359.121, 'text': 'It is important to be able to simplify data for proper analysis.', 'start': 9355.62, 'duration': 3.501}, {'end': 9367.964, 'text': 'Organizing and simplifying data is a critical part of Tableau mission to facilitate you to see and understand data.', 'start': 9361.042, 'duration': 6.922}, {'end': 9374.746, 'text': 'Tableau can help you with all stages of an analytics project by using these advanced capabilities.', 'start': 9368.924, 'duration': 5.822}, {'end': 9382.44, 'text': 'In this lesson, we will discuss advanced capabilities to complete sophisticated analytics projects.', 'start': 9376.673, 'duration': 5.767}], 'summary': 'Tableau provides advanced capabilities for organizing and simplifying data, crucial for complex analytics projects.', 'duration': 49.764, 'max_score': 9332.676, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY9332676.jpg'}], 'start': 8190.492, 'title': 'Tableau data filtering', 'summary': 'Covers customizing and applying filters in tableau, including options for numerical values, dimensions, and dates, as well as custom value list and wildcard filtering. it also explains advanced capabilities for filtering and organizing data, facilitating sophisticated projects and achieving sales analysis goals.', 'chapters': [{'end': 8354.851, 'start': 8190.492, 'title': 'Tableau data filtering', 'summary': 'Explains how to customize and apply filters in tableau to manipulate and narrow down data, including options for numerical values, dimensions, and dates, and the different ways to apply filters, such as through the filter shelf, quick filter, and data manipulation.', 'duration': 164.359, 'highlights': ['The chapter explains how to customize and apply filters in Tableau to manipulate and narrow down data. It covers the process of customizing and applying filters in Tableau to narrow down and manipulate data.', 'Options for numerical values, dimensions, and dates, and the different ways to apply filters, such as through the filter shelf, quick filter, and data manipulation. It discusses the options for applying filters to numerical values, dimensions, and dates, as well as the different methods like the filter shelf, quick filter, and data manipulation.', 'Explaining the four tabs - general, wildcard, condition, and top - in the filter window. It describes the functionality of the four tabs - general, wildcard, condition, and top - in the filter window.']}, {'end': 8533.698, 'start': 8355.45, 'title': 'Custom value list and wildcard filtering', 'summary': 'Explains the options of custom value list and wildcard filtering, where users can specify match values and filter data based on specific criteria, such as starting with a particular alphabet, and using custom value lists to avoid scrolling through a huge list.', 'duration': 178.248, 'highlights': ["Users can filter customer names using a wildcard to specify names starting with a particular alphabet, providing a more precise way to view data. Demonstrates how to use wildcard filtering to view customers' names starting with a specific alphabet, improving data precision.", 'Explanation of custom value list, allowing users to enter known values instead of scrolling through a long list, enhancing efficiency and user experience. Describes the benefits of using a custom value list to enter known values, improving efficiency and user experience.', 'Detailed explanation of applying conditions and top filters based on specific fields, dimensions, measures, or formulas for data analysis. Provides a detailed explanation of applying conditions and top filters for data analysis based on specific criteria.']}, {'end': 9058.225, 'start': 8534.518, 'title': 'Tableau data filtering', 'summary': 'Covers filtering in tableau, including filtering on dimensions and measures, using wildcard and conditions for filtering, and options for filtering ranges and null values, providing insights into effective data analysis and visualization.', 'duration': 523.707, 'highlights': ['Explaining filtering on dimensions and measures The transcript provides detailed information on filtering data in Tableau, including filtering on dimensions and measures to analyze and visualize data effectively.', 'Demonstrating wildcard and conditions for filtering The transcript explains the usage of wildcard and conditions for filtering, illustrating how to specify filter conditions and use wildcards for effective data filtering.', 'Detailing options for filtering ranges and null values The transcript details the options for filtering data based on ranges and handling null values, providing insights into effectively narrowing down data to specific ranges and handling null values in the visualization.']}, {'end': 9464.57, 'start': 9058.605, 'title': 'Tableau data filtering', 'summary': 'Covers advanced capabilities for filtering and organizing data in tableau, including specifying date ranges and performing complex analytics, with a focus on facilitating sophisticated projects and achieving sales analysis goals.', 'duration': 405.965, 'highlights': ["Tableau's advanced capabilities aim to facilitate sophisticated analytics projects, including filtering and sorting data, creating combined fields, defining aliases, working with sets, drilling into hierarchies, and changing aggregation functions for measures.", 'Tableau provides options for filtering on dates, including relative date filters and range of dates, enabling users to define specific date ranges and apply filters based on year, quarter, or month.', 'A sales manager aims to analyze subcategories under furniture with sales over $30,000 in 2013, demonstrating the practical application of filtering and analysis in Tableau for achieving specific sales goals.']}], 'duration': 1274.078, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY8190492.jpg', 'highlights': ["Tableau's advanced capabilities aim to facilitate sophisticated analytics projects, including filtering and sorting data, creating combined fields, defining aliases, working with sets, drilling into hierarchies, and changing aggregation functions for measures.", 'Options for numerical values, dimensions, and dates, and the different ways to apply filters, such as through the filter shelf, quick filter, and data manipulation. It discusses the options for applying filters to numerical values, dimensions, and dates, as well as the different methods like the filter shelf, quick filter, and data manipulation.', "Users can filter customer names using a wildcard to specify names starting with a particular alphabet, providing a more precise way to view data. Demonstrates how to use wildcard filtering to view customers' names starting with a specific alphabet, improving data precision.", 'Explaining the four tabs - general, wildcard, condition, and top - in the filter window. It describes the functionality of the four tabs - general, wildcard, condition, and top - in the filter window.']}, {'end': 11094.107, 'segs': [{'end': 9493.856, 'src': 'embed', 'start': 9465.011, 'weight': 0, 'content': [{'end': 9469.553, 'text': 'I think what you need is a bar chart where you can filter the results as per your analysis.', 'start': 9465.011, 'duration': 4.542}, {'end': 9471.414, 'text': "That's right.", 'start': 9470.853, 'duration': 0.561}, {'end': 9473.855, 'text': 'How can we do this in the most efficient manner?', 'start': 9471.814, 'duration': 2.041}, {'end': 9482.923, 'text': 'We can use Tableau application that provides a number of features to create bar charts and filter large amounts of data as per your desired analysis.', 'start': 9475.054, 'duration': 7.869}, {'end': 9488.43, 'text': "Great! You can start working on this task and present the analysis to me when you're done.", 'start': 9484.145, 'duration': 4.285}, {'end': 9493.856, 'text': "So before we proceed further, let's discuss what is a filter.", 'start': 9490.012, 'duration': 3.844}], 'summary': 'Utilize tableau to create bar chart with filtering for efficient analysis.', 'duration': 28.845, 'max_score': 9465.011, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY9465011.jpg'}, {'end': 9739.027, 'src': 'embed', 'start': 9713.116, 'weight': 1, 'content': [{'end': 9719.438, 'text': 'When you apply filter on a measure, it allows you to filter row-level data, select all values.', 'start': 9713.116, 'duration': 6.322}, {'end': 9724.54, 'text': 'To filter summary-level data, select one of the available aggregation functions.', 'start': 9720.098, 'duration': 4.442}, {'end': 9727.261, 'text': 'Date filters are extremely common.', 'start': 9725.24, 'duration': 2.021}, {'end': 9734.303, 'text': 'Date fields are a special kind of dimension that Tableau often handles differently than standard categorical data.', 'start': 9727.921, 'duration': 6.382}, {'end': 9739.027, 'text': 'So far, we have learned how to perform filtering and sorting on data.', 'start': 9735.083, 'duration': 3.944}], 'summary': 'Filtering allows row-level and summary-level data selection, common for date fields.', 'duration': 25.911, 'max_score': 9713.116, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY9713116.jpg'}, {'end': 10014.681, 'src': 'embed', 'start': 9984.415, 'weight': 2, 'content': [{'end': 9987.397, 'text': 'In Tableau, you can sort data in numerous ways.', 'start': 9984.415, 'duration': 2.982}, {'end': 9992.521, 'text': 'Sorting can be performed on axis, specific fields, and manually.', 'start': 9988.118, 'duration': 4.403}, {'end': 9996.444, 'text': 'Tableau supports computed sorting and manual sorting.', 'start': 9993.302, 'duration': 3.142}, {'end': 10005.194, 'text': 'Computed sorting uses programmatic rules to sort the view such as sorting alphabetically or from lowest to highest.', 'start': 9997.728, 'duration': 7.466}, {'end': 10014.681, 'text': 'Manual sorting enables you to reorganize the order of dimension in the table and can only be implemented on distinct fields with a distinct measure.', 'start': 10006.114, 'duration': 8.567}], 'summary': 'Tableau allows for sorting data in various ways, including computed sorting and manual sorting, with the ability to reorganize the order of dimensions in the table.', 'duration': 30.266, 'max_score': 9984.415, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY9984415.jpg'}, {'end': 10132.516, 'src': 'embed', 'start': 10105.698, 'weight': 4, 'content': [{'end': 10110.684, 'text': 'Two or more dimensions can be combined to create a Cartesian product of dimension members.', 'start': 10105.698, 'duration': 4.986}, {'end': 10115.112, 'text': 'The view includes all combinations of each member of the dimensions.', 'start': 10111.491, 'duration': 3.621}, {'end': 10117.152, 'text': "Let's look at an example.", 'start': 10115.852, 'duration': 1.3}, {'end': 10121.473, 'text': 'A combined field has been created using segment and region.', 'start': 10117.913, 'duration': 3.56}, {'end': 10127.115, 'text': 'When added to the view, it displays all combinations of segment and region elements.', 'start': 10122.154, 'duration': 4.961}, {'end': 10132.516, 'text': 'Creating groups and defining aliases are some more features that Tableau offers.', 'start': 10127.835, 'duration': 4.681}], 'summary': 'Combining dimensions creates a cartesian product of dimension members, displaying all combinations. tableau also offers features like creating groups and defining aliases.', 'duration': 26.818, 'max_score': 10105.698, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY10105698.jpg'}, {'end': 10200.829, 'src': 'embed', 'start': 10174.418, 'weight': 5, 'content': [{'end': 10181.26, 'text': 'Aliases will provide the flexibility for renaming dimension members to help make more sense in the current view.', 'start': 10174.418, 'duration': 6.842}, {'end': 10187.763, 'text': 'The good part is, Tableau does not change the original data on changing an alias in your view.', 'start': 10182.06, 'duration': 5.703}, {'end': 10193.066, 'text': 'You can change aliases at any time using the Edit Aliases dialog box.', 'start': 10188.423, 'duration': 4.643}, {'end': 10200.829, 'text': 'There are some things you need to keep in mind, such as aliases can only be defined for discrete dimensions and dates.', 'start': 10194.127, 'duration': 6.702}], 'summary': 'Tableau allows flexible renaming of dimension members without altering original data.', 'duration': 26.411, 'max_score': 10174.418, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY10174418.jpg'}, {'end': 10256.568, 'src': 'embed', 'start': 10227.431, 'weight': 6, 'content': [{'end': 10228.652, 'text': 'In such a condition,', 'start': 10227.431, 'duration': 1.221}, {'end': 10238.321, 'text': 'you might find that limiting the amount of information displayed to an important subset of records helps you work with and answer questions about the data more effectively.', 'start': 10228.652, 'duration': 9.669}, {'end': 10243.063, 'text': 'Sets are custom fields that define a subset of dimension members.', 'start': 10239.062, 'duration': 4.001}, {'end': 10249.326, 'text': 'A set can be created for specific dimension members in the view, or it can be based on a condition.', 'start': 10243.704, 'duration': 5.622}, {'end': 10256.568, 'text': 'Computed sets are dynamic as the number of members in the set can vary at runtime based on the condition.', 'start': 10250.086, 'duration': 6.482}], 'summary': 'Limiting information displayed with sets improves data analysis and understanding.', 'duration': 29.137, 'max_score': 10227.431, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY10227431.jpg'}, {'end': 10602.855, 'src': 'embed', 'start': 10581.48, 'weight': 8, 'content': [{'end': 10590.27, 'text': "What's amazing in that Tableau separates the data fields automatically into hierarchies, so you can easily break down the view by year, quarter,", 'start': 10581.48, 'duration': 8.79}, {'end': 10591.191, 'text': 'month, et cetera.', 'start': 10590.27, 'duration': 0.921}, {'end': 10595.948, 'text': 'Moreover, it also enables you to create your own custom hierarchies.', 'start': 10592.205, 'duration': 3.743}, {'end': 10602.855, 'text': "If you want to view your data at a lower or higher level in the hierarchy, then drilling is what you're looking for.", 'start': 10596.629, 'duration': 6.226}], 'summary': 'Tableau automatically separates data into hierarchies, allowing easy breakdown by year, quarter, month, etc., and enables creation of custom hierarchies.', 'duration': 21.375, 'max_score': 10581.48, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY10581480.jpg'}, {'end': 10718.412, 'src': 'embed', 'start': 10674.61, 'weight': 7, 'content': [{'end': 10679.955, 'text': 'He is required to create a report such that all the data is contained within the same report.', 'start': 10674.61, 'duration': 5.345}, {'end': 10681.837, 'text': "Let's see how he does that.", 'start': 10680.636, 'duration': 1.201}, {'end': 10691.67, 'text': 'Open Tableau 9.0.', 'start': 10682.918, 'duration': 8.752}, {'end': 10695.413, 'text': 'From the homepage, connect to the saved Sample Superstore dataset.', 'start': 10691.67, 'duration': 3.743}, {'end': 10699.416, 'text': 'Create a hierarchy by dragging State onto Region.', 'start': 10696.534, 'duration': 2.882}, {'end': 10706.362, 'text': 'Name the hierarchy as Geography.', 'start': 10704.26, 'duration': 2.102}, {'end': 10713.188, 'text': 'In the Geography hierarchy, drag City below State.', 'start': 10709.865, 'duration': 3.323}, {'end': 10718.412, 'text': 'Create a report with Region and Sales.', 'start': 10716.17, 'duration': 2.242}], 'summary': 'Create a tableau 9.0 report with a geography hierarchy and sales data.', 'duration': 43.802, 'max_score': 10674.61, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY10674610.jpg'}, {'end': 10851.638, 'src': 'embed', 'start': 10819.133, 'weight': 9, 'content': [{'end': 10821.955, 'text': 'Totals facilitate the aggregation of data in a view.', 'start': 10819.133, 'duration': 2.822}, {'end': 10826.697, 'text': 'You can compute grand totals and subtotals for the data in a view.', 'start': 10822.635, 'duration': 4.062}, {'end': 10831.2, 'text': 'These totals can be applied only on grid-type visualizations.', 'start': 10827.458, 'duration': 3.742}, {'end': 10836.684, 'text': 'Tableau does not compute subtotals and grand totals as just an aggregation.', 'start': 10832.08, 'duration': 4.604}, {'end': 10845.032, 'text': 'Instead, subtotals and grand totals are computed as a separate calculation of the measure at a coarser level of granularity.', 'start': 10837.425, 'duration': 7.607}, {'end': 10851.638, 'text': 'Tableau computes subtotals and grand totals as the original measure at a higher level of aggregation.', 'start': 10845.552, 'duration': 6.086}], 'summary': 'Tableau computes subtotals and grand totals as a separate calculation at a coarser level of granularity.', 'duration': 32.505, 'max_score': 10819.133, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY10819133.jpg'}, {'end': 10890.288, 'src': 'embed', 'start': 10865.608, 'weight': 10, 'content': [{'end': 10874.493, 'text': 'You can change the aggregation function by right-clicking a dimension in either the Rows or Columns shelf or by right-clicking a field in the Data pane.', 'start': 10865.608, 'duration': 8.885}, {'end': 10878.335, 'text': 'Here, we have changed the aggregation function to Average.', 'start': 10875.113, 'duration': 3.222}, {'end': 10884.661, 'text': 'Next, we are going to study about tableau bins which are useful to create a range of data.', 'start': 10879.315, 'duration': 5.346}, {'end': 10890.288, 'text': 'Bins are custom bandings of the values of a measure based on a specific size.', 'start': 10885.382, 'duration': 4.906}], 'summary': 'Changing aggregation function to average and studying tableau bins for creating data ranges.', 'duration': 24.68, 'max_score': 10865.608, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY10865608.jpg'}, {'end': 11049.286, 'src': 'embed', 'start': 11022.063, 'weight': 11, 'content': [{'end': 11030.666, 'text': 'You wish to view the number of customers who have been offered discounts between 0% and 10%, 10% and 20%, and so on.', 'start': 11022.063, 'duration': 8.603}, {'end': 11037.068, 'text': 'Create a histogram with discount bins and count of discounts and answer the following questions.', 'start': 11031.726, 'duration': 5.342}, {'end': 11043.161, 'text': 'How many customers were given discounts between 0% and 10%?', 'start': 11038.237, 'duration': 4.924}, {'end': 11049.286, 'text': 'What is the total sale recorded when customers were offered a discount between 20% and 30%?', 'start': 11043.161, 'duration': 6.125}], 'summary': 'Analyze customer discounts: create histogram, count discounts, and calculate total sales.', 'duration': 27.223, 'max_score': 11022.063, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY11022063.jpg'}], 'start': 9465.011, 'title': 'Tableau data analysis', 'summary': 'Covers the use of tableau for data filtering, analysis, and visualization, including creating bar charts, filtering methods, data sorting, creating combined fields, defining aliases, working with sets, drill down reports, and data aggregation techniques.', 'chapters': [{'end': 9563.58, 'start': 9465.011, 'title': 'Using tableau for efficient data filtering', 'summary': 'Explains the use of tableau for creating bar charts and filtering large amounts of data, where filters are essential to narrowing down the data displayed, and tableau provides multiple methods for filtering data.', 'duration': 98.569, 'highlights': ['Tableau provides a number of features to create bar charts and filter large amounts of data as per your desired analysis.', 'Filters in Tableau can be either static or interactive, and they are essential to any analysis.', 'Methods for filtering data in Tableau include selecting data in the view, dragging fields to the filters shelf, and activating quick filters.']}, {'end': 9929.942, 'start': 9565.34, 'title': 'Tableau filtering and analysis', 'summary': 'Explains the functionality of the filter tabs in tableau, including the general, wildcard, condition, and top tabs, and demonstrates the application of filters in tableau by creating a visualization with specific filter conditions.', 'duration': 364.602, 'highlights': ['Tableau allows filtering at row level and summary level calculations. Tableau allows filtering at row level data, where measure value is calculated individually for every row, and at summary level data, where measure value is calculated using an aggregation function.', 'Demonstration of applying filters in Tableau using specific filter conditions. The demonstration involves creating a horizontal bar chart with subcategory dimension and sales measure, applying filters for furniture category, 2013 sales, and subcategories with sales greater than $30,000, and observing the change in the bar chart after applying filters.', 'Explanation of the quick filter options in Tableau. The quick filter options include single values list, dropdown single values, slider multiple values, list multiple values, dropdown multiple values, slider wildcard match, and the ability to quickly add and modify filters.']}, {'end': 10485.775, 'start': 9930.582, 'title': 'Tableau: data analysis and visualization', 'summary': 'Introduces the sorting of data, creating combined fields, defining aliases, working with sets and combined sets in tableau, with a demonstration on creating a group and a computed set to display the aggregated profit ratio and bottom five subcategories by sales.', 'duration': 555.193, 'highlights': ['Sorting data is an integral part of data analysis, enabling better organization and understanding of data. Sorting data helps in visualizing and understanding data, better organization, and finding the data that you want, ultimately enabling more effective decisions.', 'Tableau supports various ways of sorting data, including computed sorting and manual sorting. Tableau supports computed sorting using programmatic rules and manual sorting to reorganize the order of dimension in the table.', 'Creating combined fields in Tableau allows for the creation of a cross product of members from different dimensions. Combined fields can create a Cartesian product of dimension members, displaying all combinations of each member of the dimensions.', 'Groups and aliases in Tableau enable the combining of dimension members and renaming dimension members to make more sense in the current view. Groups are used to combine dimension members to create a higher-level member, while aliases provide the flexibility for renaming dimension members to make more sense in the current view.', 'Sets in Tableau define a subset of dimension members and can be based on conditions, and combined sets can be formed by specifying logical operators between two sets. Sets define a subset of dimension members and can be based on conditions, and combined sets can be formed by specifying logical operators between two sets.']}, {'end': 11094.107, 'start': 10487.196, 'title': 'Tableau: drill down reports & data aggregation', 'summary': 'Covers the creation of drill down reports in tableau to analyze sales performance across different hierarchies and the use of grand totals, subtotals, aggregations, bins, and other data organization techniques, with a hands-on practice scenario included.', 'duration': 606.911, 'highlights': ['The chapter covers the creation of drill down reports in Tableau to analyze sales performance across different hierarchies Tableau offers the feature of hierarchy, allowing drilling down to several lower layers of detail for analyzing sales performance across different regions, states, and cities.', 'The chapter discusses the use of grand totals, subtotals, aggregations, and bins for data organization Tableau facilitates the computation of grand totals and subtotals as separate calculations, allows defining aggregations other than predefined choices, and creating bins for numeric dimensions based on specific sizes.', 'A hands-on practice scenario is provided for creating a histogram with discount bins and count of discounts The hands-on practice involves creating a histogram with discount bins to analyze the number of customers offered discounts within specific ranges and calculating the total sales recorded for specific discount ranges.']}], 'duration': 1629.096, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY9465011.jpg', 'highlights': ['Tableau provides features for creating bar charts and filtering large data sets.', 'Tableau allows filtering at row and summary levels, with various filter conditions.', 'Sorting data in Tableau enables better organization and understanding of data.', 'Tableau supports various ways of sorting data, including computed and manual sorting.', 'Creating combined fields in Tableau allows for the creation of a cross product of members from different dimensions.', 'Groups and aliases in Tableau enable the combining and renaming of dimension members.', 'Sets in Tableau define a subset of dimension members and can be based on conditions.', 'The chapter covers the creation of drill down reports in Tableau to analyze sales performance across different hierarchies.', 'Tableau offers the feature of hierarchy, allowing drilling down to several lower layers of detail for analyzing sales performance.', 'Tableau facilitates the computation of grand totals and subtotals as separate calculations.', 'Tableau allows defining aggregations other than predefined choices and creating bins for numeric dimensions based on specific sizes.', 'A hands-on practice scenario is provided for creating a histogram with discount bins and count of discounts.']}, {'end': 12600.712, 'segs': [{'end': 11135.238, 'src': 'embed', 'start': 11094.988, 'weight': 0, 'content': [{'end': 11101.655, 'text': 'Using the Sample Superstore Excel sheet, you have to create an appropriate visualization and answer the following questions.', 'start': 11094.988, 'duration': 6.667}, {'end': 11104.657, 'text': 'How many customers do you have on your list?', 'start': 11102.375, 'duration': 2.282}, {'end': 11108.001, 'text': 'What is the distinct order count for customer?', 'start': 11105.538, 'duration': 2.463}, {'end': 11108.841, 'text': 'Hillary Holden?', 'start': 11108.001, 'duration': 0.84}, {'end': 11112.638, 'text': 'Which customer has the highest count of order returns?', 'start': 11109.775, 'duration': 2.863}, {'end': 11115.12, 'text': 'Scenario 2..', 'start': 11113.378, 'duration': 1.742}, {'end': 11123.848, 'text': 'You are a store manager of a leading retail chain in the United States that wants to launch a discount campaign to promote the sales of related products.', 'start': 11115.12, 'duration': 8.728}, {'end': 11130.774, 'text': 'As a part of this campaign, you need to analyze the aggregated sales for envelopes, labels, and papers.', 'start': 11124.569, 'duration': 6.205}, {'end': 11135.238, 'text': 'You are required to see the combined sales of these products on a graph.', 'start': 11131.475, 'duration': 3.763}], 'summary': "Analyze sample superstore data, answer queries, and create visualizations for retail chain's discount campaign.", 'duration': 40.25, 'max_score': 11094.988, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY11094988.jpg'}, {'end': 11212.967, 'src': 'embed', 'start': 11161.169, 'weight': 3, 'content': [{'end': 11166.414, 'text': "We've already understood how we can build on a basic map view in Tableau.", 'start': 11161.169, 'duration': 5.245}, {'end': 11170.738, 'text': 'That Tableau assigns geographic roles in terms of fields in the data.', 'start': 11166.474, 'duration': 4.264}, {'end': 11172.36, 'text': 'We can customize the appearance.', 'start': 11170.778, 'duration': 1.582}, {'end': 11174.141, 'text': 'We can navigate and find locations.', 'start': 11172.4, 'duration': 1.741}, {'end': 11186.084, 'text': "But let's go further ahead and understand certain analysis on how we can use map layers, how we can make use of WMS, that is map, web map services.", 'start': 11174.702, 'duration': 11.382}, {'end': 11192.53, 'text': 'So if you remember earlier as well, we discussed on web map services that Tableau provides.', 'start': 11186.104, 'duration': 6.426}, {'end': 11202.698, 'text': "So let's understand, so that at the end of this particular topic we will be able to understand how we can modify locations within Tableau,", 'start': 11192.91, 'duration': 9.788}, {'end': 11205.24, 'text': 'how we can import and modify custom geocoding.', 'start': 11202.698, 'duration': 2.542}, {'end': 11208.543, 'text': 'We can make use of background images as well as maps.', 'start': 11205.741, 'duration': 2.802}, {'end': 11212.967, 'text': 'how we can describe the geocode locations within Tableau,', 'start': 11209.262, 'duration': 3.705}], 'summary': 'Tableau tutorial on customizing map views and using map layers and wms for analysis.', 'duration': 51.798, 'max_score': 11161.169, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY11161169.jpg'}, {'end': 11394.658, 'src': 'embed', 'start': 11372.754, 'weight': 5, 'content': [{'end': 11382.198, 'text': "for this, he's going to require pretty obvious a map visualization that can display the sales profit and the quantitative values as well.", 'start': 11372.754, 'duration': 9.444}, {'end': 11382.758, 'text': 'all right.', 'start': 11382.198, 'duration': 0.56}, {'end': 11386.86, 'text': "so let's begin and see how we can make use of the analysis now.", 'start': 11382.758, 'duration': 4.102}, {'end': 11391.482, 'text': "this is going to be a pretty interesting feature that we're going to see.", 'start': 11386.86, 'duration': 4.622}, {'end': 11394.658, 'text': "so Let's begin.", 'start': 11391.482, 'duration': 3.176}], 'summary': 'Requirement for a map visualization displaying sales profit and quantitative values.', 'duration': 21.904, 'max_score': 11372.754, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY11372754.jpg'}, {'end': 11860.265, 'src': 'embed', 'start': 11828.783, 'weight': 6, 'content': [{'end': 11830.103, 'text': 'So that is what geocoding is.', 'start': 11828.783, 'duration': 1.32}, {'end': 11832.424, 'text': 'So Tableau automatically defines it.', 'start': 11830.504, 'duration': 1.92}, {'end': 11841.867, 'text': "And in case if it doesn't, then you also have the option where you can import the file and you can then specify and create a custom geocoding also.", 'start': 11832.884, 'duration': 8.983}, {'end': 11844.568, 'text': 'So you can then provide a particular name.', 'start': 11842.247, 'duration': 2.321}, {'end': 11851.23, 'text': "So let's say you have an Excel file in that you will need to then custom specify.", 'start': 11844.588, 'duration': 6.642}, {'end': 11860.265, 'text': 'So yours is taking in the geocoding by default, but in terms of custom, what you then have to do is you can import an excel,', 'start': 11851.25, 'duration': 9.015}], 'summary': 'Tableau provides automatic geocoding and allows for custom geocoding by importing excel files.', 'duration': 31.482, 'max_score': 11828.783, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY11828783.jpg'}, {'end': 12197.768, 'src': 'embed', 'start': 12171.687, 'weight': 7, 'content': [{'end': 12182.779, 'text': 'So first up, what exactly is data planning? So, data blending is a method for combining data from multiple sources.', 'start': 12171.687, 'duration': 11.092}, {'end': 12190.224, 'text': 'Data blending brings in additional information from a secondary data source and displays it with data from the primary data source directly in the field.', 'start': 12183.08, 'duration': 7.144}, {'end': 12194.627, 'text': 'So, it might be a little complicated to understand, so let us make it a little simple.', 'start': 12190.864, 'duration': 3.763}, {'end': 12197.768, 'text': "Let's imagine that you have data.", 'start': 12195.847, 'duration': 1.921}], 'summary': 'Data blending combines data from multiple sources to enhance analysis.', 'duration': 26.081, 'max_score': 12171.687, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY12171687.jpg'}, {'end': 12293.28, 'src': 'embed', 'start': 12264.996, 'weight': 8, 'content': [{'end': 12267.256, 'text': 'and then we have the data blending option.', 'start': 12264.996, 'duration': 2.26}, {'end': 12269.017, 'text': 'So first, relationships.', 'start': 12267.877, 'duration': 1.14}, {'end': 12273.899, 'text': 'So why exactly we do not prefer relationships in a few situations?', 'start': 12269.437, 'duration': 4.462}, {'end': 12280.946, 'text': 'Relationships cannot be formed between tables from data sources published to Tableau Server or Tableau Online.', 'start': 12274.679, 'duration': 6.267}, {'end': 12284.49, 'text': "So, relationships can't be formed based on calculated fields.", 'start': 12281.407, 'duration': 3.083}, {'end': 12288.055, 'text': 'When you use data blending, you can create calculation fields.', 'start': 12284.911, 'duration': 3.144}, {'end': 12290.618, 'text': 'Those are called as data blending calculations.', 'start': 12288.375, 'duration': 2.243}, {'end': 12293.28, 'text': 'Now, next thing is the Joins.', 'start': 12291.218, 'duration': 2.062}], 'summary': 'Data blending in tableau allows creation of calculation fields and bypasses limitations of relationships.', 'duration': 28.284, 'max_score': 12264.996, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY12264996.jpg'}, {'end': 12363.307, 'src': 'embed', 'start': 12332.461, 'weight': 9, 'content': [{'end': 12336.226, 'text': 'Now, data blending, unlike relationships or joints, never truly combine the data.', 'start': 12332.461, 'duration': 3.765}, {'end': 12339.21, 'text': 'Instead, blends query each data source independently.', 'start': 12336.266, 'duration': 2.944}, {'end': 12344.677, 'text': 'The results are aggregated to the appropriate level, then the results are presented visually together in the view.', 'start': 12339.55, 'duration': 5.127}, {'end': 12347.661, 'text': "That's the reason why we use data blending.", 'start': 12345.418, 'duration': 2.243}, {'end': 12349.624, 'text': 'Now, up next.', 'start': 12348.943, 'duration': 0.681}, {'end': 12352.397, 'text': 'we have the data blending example.', 'start': 12350.515, 'duration': 1.882}, {'end': 12354.639, 'text': 'Now, this is where we get into the practical mode.', 'start': 12352.797, 'duration': 1.842}, {'end': 12356.761, 'text': "We'll get back to our data first.", 'start': 12354.659, 'duration': 2.102}, {'end': 12363.307, 'text': "We'll see what kind of data we are going to use for this particular example and what are we gonna do with that data in the table view.", 'start': 12356.841, 'duration': 6.466}], 'summary': 'Data blending aggregates results from independent sources for visualization.', 'duration': 30.846, 'max_score': 12332.461, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY12332461.jpg'}], 'start': 11094.988, 'title': 'Sales analysis and advanced mapping functions', 'summary': 'Presents a sales analysis of the sample superstore excel sheet, including the count of customers, distinct order count for a specific customer, and aggregated sales for paper products, with a focus on envelopes, labels, and papers. it also discusses advanced mapping functions in tableau, including modifying locations, importing and modifying custom geocoding, using map layers, and understanding geographic roles, with a demonstration of creating a map visualization to analyze sales, profit, and quantity.', 'chapters': [{'end': 11161.129, 'start': 11094.988, 'title': 'Sales analysis and visualizations', 'summary': 'Presents a sales analysis of the sample superstore excel sheet, including the count of customers, distinct order count for a specific customer, and aggregated sales for paper products, with a focus on envelopes, labels, and papers, concluding with a brief introduction to mapping.', 'duration': 66.141, 'highlights': ['Creating appropriate visualizations using the Sample Superstore Excel sheet, including bar charts for analyzing sales of paper products and answering specific questions regarding customer count and order details.', 'Analyzing the aggregated sales for envelopes, labels, and papers to prepare for a discount campaign, focusing on launching a sales promotion for related products.', 'Identifying the distinct order count for a specific customer, Hillary Holden, to understand individual customer purchasing behavior and preferences.', 'Introducing the lesson on mapping and exploring various examples of maps for data representation and analysis.']}, {'end': 12168.525, 'start': 11161.169, 'title': 'Advanced mapping functions in tableau', 'summary': 'Discusses advanced mapping functions in tableau, including modifying locations, importing and modifying custom geocoding, using map layers, and understanding geographic roles. it also demonstrates creating a map visualization to analyze sales, profit, and quantity, and explains the process of geocoding and using custom geocoding in tableau.', 'duration': 1007.356, 'highlights': ['The chapter discusses advanced mapping functions in Tableau, including modifying locations, importing and modifying custom geocoding, using map layers, and understanding geographic roles. The chapter covers advanced mapping functions, such as modifying locations within Tableau, importing and modifying custom geocoding, using map layers, and understanding geographic roles.', "It demonstrates creating a map visualization to analyze sales, profit, and quantity. The chapter demonstrates creating a map visualization to analyze sales, profit, and quantity, providing insight into the company's performance and identifying low-performing states for potential improvement.", 'It explains the process of geocoding and using custom geocoding in Tableau. The chapter explains the process of geocoding, which involves Tableau automatically assigning geographic roles to fields, and also delves into using custom geocoding by providing latitude and longitude values in a CSV file.']}, {'end': 12600.712, 'start': 12171.687, 'title': 'Understanding data blending in tableau', 'summary': 'Explains data blending in tableau, highlighting its purpose, advantages over joins and relationships, and a practical example using car and bike sales datasets.', 'duration': 429.025, 'highlights': ['Data blending is a method for combining data from multiple sources, bringing in additional information from a secondary data source and displaying it with data from the primary data source directly in the field.', "Tableau's data blending overcomes limitations of relationships and joins, allowing the creation of calculated fields and avoiding data duplication.", 'The practical example involves blending car and bike sales datasets, demonstrating the process of preparing and modifying the datasets for data blending in Tableau.']}], 'duration': 1505.724, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY11094988.jpg', 'highlights': ['Creating appropriate visualizations using the Sample Superstore Excel sheet, including bar charts for analyzing sales of paper products and answering specific questions regarding customer count and order details.', 'Analyzing the aggregated sales for envelopes, labels, and papers to prepare for a discount campaign, focusing on launching a sales promotion for related products.', 'Identifying the distinct order count for a specific customer, Hillary Holden, to understand individual customer purchasing behavior and preferences.', 'Introducing the lesson on mapping and exploring various examples of maps for data representation and analysis.', 'The chapter discusses advanced mapping functions in Tableau, including modifying locations, importing and modifying custom geocoding, using map layers, and understanding geographic roles.', "It demonstrates creating a map visualization to analyze sales, profit, and quantity, providing insight into the company's performance and identifying low-performing states for potential improvement.", 'It explains the process of geocoding and using custom geocoding in Tableau.', 'Data blending is a method for combining data from multiple sources, bringing in additional information from a secondary data source and displaying it with data from the primary data source directly in the field.', "Tableau's data blending overcomes limitations of relationships and joins, allowing the creation of calculated fields and avoiding data duplication.", 'The practical example involves blending car and bike sales datasets, demonstrating the process of preparing and modifying the datasets for data blending in Tableau.']}, {'end': 13392.464, 'segs': [{'end': 12723.438, 'src': 'embed', 'start': 12673.818, 'weight': 2, 'content': [{'end': 12681.742, 'text': 'okay, sorry, so you can read it right on the right hand side of this particular dialog box, control d,', 'start': 12673.818, 'duration': 7.924}, {'end': 12686.144, 'text': 'you can directly press control d and add your new data source as well.', 'start': 12681.742, 'duration': 4.402}, {'end': 12688.425, 'text': "so now we'll add the new data source.", 'start': 12686.144, 'duration': 2.281}, {'end': 12693.307, 'text': "so since another data set that you're working on is also an excel file, we'll select the excel file.", 'start': 12688.425, 'duration': 4.882}, {'end': 12696.443, 'text': 'so that was bike sales.', 'start': 12694.542, 'duration': 1.901}, {'end': 12703.228, 'text': 'and yeah, there you go, we have a bike sales data set right on my screen right now.', 'start': 12696.443, 'duration': 6.785}, {'end': 12708.932, 'text': 'so in here as well, you can see some excess or unnecessary columns.', 'start': 12703.228, 'duration': 5.704}, {'end': 12710.933, 'text': "so we'll remove that as well.", 'start': 12708.932, 'duration': 2.001}, {'end': 12713.235, 'text': "so we'll hide this.", 'start': 12710.933, 'duration': 2.302}, {'end': 12716.777, 'text': "we'll hide this, we'll hide this as well.", 'start': 12713.235, 'duration': 3.542}, {'end': 12723.438, 'text': 'now we have engine size, horsepower, fuel capacity, efficiency.', 'start': 12718.288, 'duration': 5.15}], 'summary': 'Adding and cleaning bike sales data, removing unnecessary columns.', 'duration': 49.62, 'max_score': 12673.818, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY12673818.jpg'}, {'end': 12952.394, 'src': 'embed', 'start': 12924.051, 'weight': 1, 'content': [{'end': 12926.973, 'text': 'so this happens when you have multiple sources only.', 'start': 12924.051, 'duration': 2.922}, {'end': 12934.255, 'text': "now let's click that and you can see we have the automatic option and the tableau has automatically, you know,", 'start': 12926.973, 'duration': 7.282}, {'end': 12938.917, 'text': 'found a data blend option for the columns which have the same names.', 'start': 12934.255, 'duration': 4.662}, {'end': 12946.886, 'text': 'so we have manufacturer, model and manufacturer and model in both bikes and cars.', 'start': 12938.917, 'duration': 7.969}, {'end': 12952.394, 'text': 'so we also have the same names for annual sales engine fuel, fuel efficiency, horsepower also.', 'start': 12946.886, 'duration': 5.508}], 'summary': 'Tableau automatically identifies and blends columns with matching names from multiple sources, including manufacturer, model, annual sales, engine fuel, fuel efficiency, and horsepower.', 'duration': 28.343, 'max_score': 12924.051, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY12924051.jpg'}, {'end': 13353.432, 'src': 'embed', 'start': 13331.691, 'weight': 0, 'content': [{'end': 13341.423, 'text': "Now let's drag this calculated field into the rows icon and you can see the sum of both sales happening in this particular segment here,", 'start': 13331.691, 'duration': 9.732}, {'end': 13345.146, 'text': 'which shows you the sum of sales of both cars and bikes.', 'start': 13341.423, 'duration': 3.723}, {'end': 13347.988, 'text': 'Now you can see that we have 28 nulls over here, right?', 'start': 13345.767, 'duration': 2.221}, {'end': 13353.432, 'text': "So we should be having all the you know when you're calculating the sum of annual sales of both the data sets,", 'start': 13348.229, 'duration': 5.203}], 'summary': 'Total sales of cars and bikes: 28 nulls in annual sales data.', 'duration': 21.741, 'max_score': 13331.691, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY13331691.jpg'}], 'start': 12601.112, 'title': 'Blending data sets in tableau', 'summary': 'Covers blending two data sets in tableau, including steps to add, remove, and hide columns, creating a blend relationship based on common column names, using the custom option for columns with different names, and demonstrates creating a calculated field to sum the sales of both data sets for a comprehensive analysis.', 'chapters': [{'end': 13074.269, 'start': 12601.112, 'title': 'Blending data sets in tableau', 'summary': 'Explains how to blend two data sets in tableau, including steps to add, remove, and hide columns, as well as the process of creating a blend relationship based on common column names and using the custom option for columns with different names.', 'duration': 473.157, 'highlights': ['The chapter explains the process of adding a new data source to Tableau, including selecting the new data source icon, entering the worksheet, using the data section, and using the shortcut Control+D, with a focus on adding a new Excel file as a data source for bike sales data set.', 'The chapter demonstrates the process of removing excess or unnecessary columns from a data set, such as hiding specific columns like engine size, annual sales, and others, in order to streamline the data for blending.', "The chapter details the steps to create a blend relationship between two data sets in Tableau, highlighting the automatic option for columns with the same names and the custom option for columns with different names, with a specific example of blending the 'region' from cars and 'zone' from bikes data sets.", 'The chapter explains how to identify the primary data set or data source in Tableau, showcasing the use of a little tiny blue tick icon to indicate the currently selected data set during operations and manipulations, providing clarity on working with multiple data sets.', 'The chapter emphasizes the importance of seeking assistance from the Simply Learn Community for learning challenges, offering a solution-oriented approach and expert support for problem-solving during the learning process.']}, {'end': 13392.464, 'start': 13074.289, 'title': 'Data blending and calculations', 'summary': 'Demonstrates how to use data blending to compare car and bike sales, create a calculated field to sum the sales of both data sets, and address null values in the calculation field, resulting in a comprehensive analysis of the combined sales.', 'duration': 318.175, 'highlights': ['The Dodge Viper is identified as having the largest engine, showcasing its dominance as a muscle car in America. The Dodge Viper is highlighted as having the largest engine, emphasizing its significance as a muscle car in America.', 'The Multistrada 950 is determined to have the highest mileage according to the dataset, providing valuable insight into the most fuel-efficient bike. The Multistrada 950 is identified as having the highest mileage, offering crucial information about the most fuel-efficient bike.', 'The process involves creating a calculated field to sum the sales of both cars and bikes, enabling a comprehensive analysis of combined sales across the datasets. The process includes creating a calculated field to sum the sales of both cars and bikes, allowing for a comprehensive analysis of combined sales across the datasets.']}], 'duration': 791.352, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY12601112.jpg', 'highlights': ['Demonstrates creating a calculated field to sum the sales of both data sets for a comprehensive analysis.', 'Details the steps to create a blend relationship between two data sets in Tableau, highlighting the automatic option for columns with the same names and the custom option for columns with different names.', 'The chapter explains the process of adding a new data source to Tableau, including selecting the new data source icon, entering the worksheet, using the data section, and using the shortcut Control+D, with a focus on adding a new Excel file as a data source for bike sales data set.', 'The chapter demonstrates the process of removing excess or unnecessary columns from a data set, such as hiding specific columns like engine size, annual sales, and others, in order to streamline the data for blending.', 'The process involves creating a calculated field to sum the sales of both cars and bikes, enabling a comprehensive analysis of combined sales across the datasets.']}, {'end': 16273.366, 'segs': [{'end': 13445.174, 'src': 'embed', 'start': 13421.535, 'weight': 0, 'content': [{'end': 13428.601, 'text': 'So what are the differences between data blending and joins? So this particular shot data table should explain you the differences between them.', 'start': 13421.535, 'duration': 7.066}, {'end': 13433.244, 'text': 'So in data blending, the data gets aggregated first, then the data gets combined.', 'start': 13429.021, 'duration': 4.223}, {'end': 13439.769, 'text': 'But where in joins, the data will be joined first or combined first, then the data is aggregated.', 'start': 13433.605, 'duration': 6.164}, {'end': 13445.174, 'text': 'And the second difference is when we use data blending, the data set is from different data sources.', 'start': 13440.35, 'duration': 4.824}], 'summary': 'Data blending aggregates, then combines data from different sources; joins first combine, then aggregate.', 'duration': 23.639, 'max_score': 13421.535, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY13421535.jpg'}, {'end': 13888.787, 'src': 'embed', 'start': 13856.78, 'weight': 1, 'content': [{'end': 13858.541, 'text': 'based on the selections that we wanted.', 'start': 13856.78, 'duration': 1.761}, {'end': 13860.142, 'text': "Let's have a quick recap.", 'start': 13858.961, 'duration': 1.181}, {'end': 13865.825, 'text': 'So we can sort on the axis on a specific field or we can do it manually as well as we saw.', 'start': 13860.382, 'duration': 5.443}, {'end': 13873.589, 'text': 'Tableau supports computed where we could use the toolbars or the axis or we could perform a manual sort as well when we clicked on a particular pill.', 'start': 13866.225, 'duration': 7.364}, {'end': 13877.812, 'text': 'We had the option to manually sort our fields also.', 'start': 13873.97, 'duration': 3.842}, {'end': 13882.105, 'text': 'So here it comes before sorting, when you have done it on the axis.', 'start': 13878.444, 'duration': 3.661}, {'end': 13888.787, 'text': 'as I said, you can hover over the particular axis, a floating icon appears and you can sort your data alright.', 'start': 13882.105, 'duration': 6.682}], 'summary': 'Tableau allows manual and computed sorting based on selections, fields, or axis, offering flexibility in data organization.', 'duration': 32.007, 'max_score': 13856.78, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY13856780.jpg'}, {'end': 14216.271, 'src': 'embed', 'start': 14190.548, 'weight': 2, 'content': [{'end': 14198.233, 'text': 'So if you notice, we already have the order date and Tableau has automatically created the hierarchy, the level here for us.', 'start': 14190.548, 'duration': 7.685}, {'end': 14202.839, 'text': "And by default, it's taking in the highest level of the time hierarchy here.", 'start': 14198.715, 'duration': 4.124}, {'end': 14207.663, 'text': 'So it takes in the level at a yearly level here for our sales that we can see.', 'start': 14202.859, 'duration': 4.804}, {'end': 14211.406, 'text': 'Now this is how Jason will be able to achieve his view,', 'start': 14208.564, 'duration': 2.842}, {'end': 14216.271, 'text': 'where he can see the sales at a yearly level for all the years that are present in the data source.', 'start': 14211.406, 'duration': 4.865}], 'summary': 'Tableau automatically creates hierarchy for order date, showing sales at yearly level for all years in data source.', 'duration': 25.723, 'max_score': 14190.548, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY14190548.jpg'}, {'end': 14741.319, 'src': 'embed', 'start': 14707.826, 'weight': 3, 'content': [{'end': 14713.229, 'text': "So that's how we can pivot our data and make our data look even more useful, even more meaningful.", 'start': 14707.826, 'duration': 5.403}, {'end': 14718.493, 'text': "Okay So let's go back to our presentation slide here.", 'start': 14713.85, 'duration': 4.643}, {'end': 14725.537, 'text': "And so that's how we can make use of the pivoting and make our views, enhance our views and make it better.", 'start': 14719.333, 'duration': 6.204}, {'end': 14731.612, 'text': 'So, we will get started by understanding the proper definition of the parameter in Tableau.', 'start': 14727.048, 'duration': 4.564}, {'end': 14741.319, 'text': 'So, what exactly are parameters in Tableau? So, a parameter will allow you to provide a value to pass into Tableau.', 'start': 14733.613, 'duration': 7.706}], 'summary': 'Using pivoting and parameters in tableau to enhance data views and provide values for analysis.', 'duration': 33.493, 'max_score': 14707.826, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY14707826.jpg'}, {'end': 14838.042, 'src': 'embed', 'start': 14810.951, 'weight': 4, 'content': [{'end': 14814.573, 'text': 'So there are multiple parameters that you can use in your day-to-day Tableau usage.', 'start': 14810.951, 'duration': 3.622}, {'end': 14818.114, 'text': "So we'll learn the most frequently used parameters.", 'start': 14815.013, 'duration': 3.101}, {'end': 14822.516, 'text': "We're going to use the top end parameters date field parameter, dynamic measures.", 'start': 14818.554, 'duration': 3.962}, {'end': 14823.516, 'text': 'dynamic dimensions.', 'start': 14822.516, 'duration': 1}, {'end': 14826.438, 'text': 'dynamic measures and dimensions, reference lines and some sets.', 'start': 14823.516, 'duration': 2.922}, {'end': 14828.398, 'text': 'So I hope so far so good.', 'start': 14827.038, 'duration': 1.36}, {'end': 14830.279, 'text': "Now let's begin with our practical session.", 'start': 14828.638, 'duration': 1.641}, {'end': 14831.58, 'text': "So let's get back to Tableau.", 'start': 14830.299, 'duration': 1.281}, {'end': 14833.681, 'text': "So we'll be using the superstore dataset.", 'start': 14831.84, 'duration': 1.841}, {'end': 14838.042, 'text': 'We have dates and et cetera, et cetera columns, which we need for the parameters to be applied.', 'start': 14833.781, 'duration': 4.261}], 'summary': 'Learn frequently used tableau parameters like date field, dynamic measures, dimensions, reference lines, and sets in practical session using superstore dataset.', 'duration': 27.091, 'max_score': 14810.951, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY14810951.jpg'}], 'start': 13393.205, 'title': 'Tableau data manipulation', 'summary': 'Covers data blending vs joins in tableau, sorting data, time analysis, pivoting data, parameters use cases, and dynamic measures and dimensions. it highlights differences between data blending and joins, sorting methods, time analysis for sales performance, data pivoting techniques, parameter use cases, and dynamic measures and dimensions creation in tableau.', 'chapters': [{'end': 13557.302, 'start': 13393.205, 'title': 'Data blending vs joins in tableau', 'summary': 'Covers the differences between data blending and joins in tableau, highlighting that data blending involves aggregating data first and then combining it, while joins combine data first and then aggregate it. it also explains the limitations of data blending, such as compromising query execution speed and high granularity.', 'duration': 164.097, 'highlights': ['Data blending involves aggregating data first and then combining it, while joins combine data first and then aggregate it.', 'When using data blending, the data set is from different data sources, whereas joins require data from a single source.', 'Data blending allows only Left Join, considered an advanced version of Joins, while Joins have different types such as Left Join, Right Join, etc.', 'Data can be available in different levels of granularity in data blending, while all data granularity should be maintained at the same level in joins.', 'Data blending sends separate queries to each data set, aggregates them, and then performs data blending operations, while joins send queries to the data at a row level.']}, {'end': 14012.226, 'start': 13557.362, 'title': 'Tableau: sorting data', 'summary': 'Covers sorting data in tableau, including using quick sort from the toolbar or axis, manually sorting data, and computed sorting based on specific fields or data source order, with examples of sorting region based on sales aggregation and manual sorting of regions. it also discusses handling date hierarchies, creating custom dates, and filtering dimensions dynamically using relative date filtering.', 'duration': 454.864, 'highlights': ['Tableau supports computed sorting as well as manual sorting based on specific fields or data source order. Tableau supports computed sorting and manual sorting based on specific fields or data source order, providing flexibility in arranging dimension members.', 'Examples of sorting region based on sales aggregation and manual sorting of regions were demonstrated. Demonstrated examples include sorting region based on sales aggregation and manually arranging regions, showcasing practical applications of sorting methods in Tableau.', 'The chapter also covers handling date hierarchies, creating custom dates, and filtering dimensions dynamically using relative date filtering. The chapter also covers handling date hierarchies, creating custom dates, and dynamically filtering dimensions using relative date filtering, offering comprehensive insights into working with date data in Tableau.']}, {'end': 14498.459, 'start': 14012.226, 'title': 'Tableau time analysis', 'summary': 'Details how tableau automatically creates time hierarchies, enabling users to analyze sales performance at yearly, quarterly, and monthly levels, and demonstrates pivoting of date parts for better insights.', 'duration': 486.233, 'highlights': ['Tableau automatically creates time hierarchies for date fields, allowing users to drill down into sales performance at yearly, quarterly, and monthly levels. Tableau creates time hierarchies for date fields, enabling users to drill down into sales performance at different levels, providing a comprehensive view for analysis.', 'Demonstrates how Tableau handles date and time data from relational sources, automatically identifying and creating hierarchies based on the date field. Tableau handles date and time data from relational sources by automatically creating hierarchies based on the date field, simplifying the analysis process for users.', 'Illustrates the process of pivoting date parts in Tableau to gain better insights by placing fields with different levels on different shelves. Demonstrates the process of pivoting date parts in Tableau to gain better insights by placing fields with different levels on different shelves, allowing for a more detailed analysis of sales data.']}, {'end': 14791.279, 'start': 14498.96, 'title': 'Pivoting data in tableau', 'summary': 'Discusses the technique of pivoting data in tableau to achieve drilling and color coding, allowing for enhanced visualization and analysis. it also explains the concept of parameters in tableau and their similarity to filters, providing flexibility in data visualization and analysis.', 'duration': 292.319, 'highlights': ['The technique of pivoting data in Tableau to achieve drilling and color coding is demonstrated, allowing for enhanced visualization and analysis. Demonstrates the process of achieving drilling and color coding in Tableau using the pivot technique to enhance visualization and analysis.', 'The concept of parameters in Tableau is explained, allowing for the provision of values to pass into Tableau and providing flexibility in data visualization and analysis. Explains the concept of parameters in Tableau and their role in providing flexibility and control in data visualization and analysis.']}, {'end': 15393.845, 'start': 14791.679, 'title': 'Tableau parameters use cases', 'summary': 'Introduces the use cases of parameters in tableau, focusing on top n parameters and date field parameters, demonstrating their application through practical examples and providing step-by-step guidance on creating and utilizing these parameters for data visualization and analysis.', 'duration': 602.166, 'highlights': ['The chapter introduces the use cases of parameters in Tableau, focusing on top N parameters and date field parameters. The chapter discusses the use cases of parameters in Tableau, highlighting the focus on top N parameters and date field parameters for data visualization and analysis.', 'Step-by-step guidance is provided on creating and utilizing parameters for data visualization and analysis. The chapter provides step-by-step guidance on creating and utilizing parameters for data visualization and analysis, offering practical examples and demonstrations.', 'Demonstrates the application of top N parameters through creating a bar chart and applying filters to identify top items based on sales. The chapter demonstrates the application of top N parameters by creating a bar chart and applying filters to identify top items based on sales, allowing for dynamic analysis of data.', 'Illustrates the creation of a date parameter and a calculated field for analyzing data by year, quarter, month, week, and day. The chapter illustrates the creation of a date parameter and a calculated field for analyzing data by year, quarter, month, week, and day, showcasing the versatility of date field parameters for data analysis.']}, {'end': 16273.366, 'start': 15394.305, 'title': 'Dynamic measures and dimensions in tableau', 'summary': 'Covers the creation of dynamic measures and dimensions, reference lines, and sets in tableau, demonstrating the usage and application of dynamic parameters and sets in real-time data visualization and analysis.', 'duration': 879.061, 'highlights': ['The chapter explains the creation of dynamic dimensions and measures in Tableau, using dynamic parameters to filter and display the desired dimensions and measures, showcasing the application of dynamic dimensions and measures in generating visualizations and analyzing real-time data. The chapter covers the creation of dynamic dimensions and measures in Tableau, demonstrating the usage of dynamic parameters to filter and display desired dimensions and measures, showing the application of dynamic dimensions and measures in generating visualizations and analyzing real-time data.', 'The chapter illustrates the use of reference lines in Tableau, showcasing the creation and application of reference lines to visualize and analyze data across different time periods, demonstrating the interactive nature of reference lines through the use of parameters for real-time data analysis. The chapter illustrates the use of reference lines in Tableau, showcasing the creation and application of reference lines to visualize and analyze data across different time periods, demonstrating the interactive nature of reference lines through the use of parameters for real-time data analysis.', 'The chapter demonstrates the utilization of sets in Tableau, explaining the creation and application of sets for categorizing and visualizing data, showcasing the dynamic nature of sets through the use of parameters for real-time data visualization and analysis. The chapter demonstrates the utilization of sets in Tableau, explaining the creation and application of sets for categorizing and visualizing data, showcasing the dynamic nature of sets through the use of parameters for real-time data visualization and analysis.', 'The chapter discusses the differences between Tableau parameters and Tableau filters, highlighting key distinctions such as the static and dynamic nature of parameters and filters, the scope of implementation, and the support for multiple values and data types. The chapter discusses the differences between Tableau parameters and Tableau filters, highlighting key distinctions such as the static and dynamic nature of parameters and filters, the scope of implementation, and the support for multiple values and data types.']}], 'duration': 2880.161, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY13393205.jpg', 'highlights': ['Data blending involves aggregating data first and then combining it, while joins combine data first and then aggregate it.', 'Tableau supports computed sorting as well as manual sorting based on specific fields or data source order.', 'Tableau automatically creates time hierarchies for date fields, allowing users to drill down into sales performance at yearly, quarterly, and monthly levels.', 'The technique of pivoting data in Tableau to achieve drilling and color coding is demonstrated, allowing for enhanced visualization and analysis.', 'The chapter introduces the use cases of parameters in Tableau, focusing on top N parameters and date field parameters.', 'The chapter explains the creation of dynamic dimensions and measures in Tableau, using dynamic parameters to filter and display the desired dimensions and measures, showcasing the application of dynamic dimensions and measures in generating visualizations and analyzing real-time data.']}, {'end': 17503.39, 'segs': [{'end': 16322.237, 'src': 'embed', 'start': 16274.286, 'weight': 0, 'content': [{'end': 16279.308, 'text': 'So LOD expression stands for level of detail expressions in Tableau.', 'start': 16274.286, 'duration': 5.022}, {'end': 16286.334, 'text': 'The LOD expressions will allow you to compute values at data source level and visualization level.', 'start': 16280.288, 'duration': 6.046}, {'end': 16292.14, 'text': 'However, LOD expressions give you even more control on the level of granularity that you want to compute.', 'start': 16286.855, 'duration': 5.285}, {'end': 16295.204, 'text': 'They can be performed at more granular level.', 'start': 16292.761, 'duration': 2.443}, {'end': 16298.187, 'text': 'That is, we use include LOD expression there.', 'start': 16295.384, 'duration': 2.803}, {'end': 16307.871, 'text': 'a less granular level where the exclude LOD expression will be handy and finally an entirely independent level that is the fixed LOD expression.', 'start': 16298.647, 'duration': 9.224}, {'end': 16315.634, 'text': "So in this tutorial, I'll explain you the types of LOD expressions you can use in Tableau as well as when to use them and how to format them.", 'start': 16308.271, 'duration': 7.363}, {'end': 16322.237, 'text': 'I will also use an example to demonstrate how to create simple LOD expressions in Tableau.', 'start': 16316.154, 'duration': 6.083}], 'summary': 'Lod expressions in tableau allow computing values at different levels of granularity and offer more control.', 'duration': 47.951, 'max_score': 16274.286, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY16274286.jpg'}, {'end': 16371.641, 'src': 'embed', 'start': 16345.976, 'weight': 2, 'content': [{'end': 16351.461, 'text': "Now let's move into the next part where we will understand the two types of LOD expressions in Tableau.", 'start': 16345.976, 'duration': 5.485}, {'end': 16354.924, 'text': 'So basically there are two types of LOD expressions in Tableau.', 'start': 16351.861, 'duration': 3.063}, {'end': 16360.929, 'text': 'The first one is the row level LOD expression and the second one is the view level LOD expression.', 'start': 16355.104, 'duration': 5.825}, {'end': 16368.277, 'text': 'So in tableau expressions referring to unaggregated data source columns and are computed for each row.', 'start': 16361.75, 'duration': 6.527}, {'end': 16371.641, 'text': 'in the underlying table are the row level expressions.', 'start': 16368.277, 'duration': 3.364}], 'summary': 'Tableau has two types of lod expressions: row level and view level.', 'duration': 25.665, 'max_score': 16345.976, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY16345976.jpg'}, {'end': 16499.503, 'src': 'embed', 'start': 16473.152, 'weight': 3, 'content': [{'end': 16479.435, 'text': 'Fields based on include level of detail expressions will change as you add or remove dimensions from the view.', 'start': 16473.152, 'duration': 6.283}, {'end': 16485.861, 'text': "Now, let's get back to tableau and try to execute a simple example for include level of detail expression.", 'start': 16479.915, 'duration': 5.946}, {'end': 16492.589, 'text': 'Now, we are back on tableau and we are going to use the sample data set in the tableau which is a superstore data set.', 'start': 16485.881, 'duration': 6.708}, {'end': 16496.521, 'text': 'Now to create LOD expressions in Tableau, we have some steps.', 'start': 16493.499, 'duration': 3.022}, {'end': 16499.503, 'text': 'So the first step is to set up a visualization first.', 'start': 16496.881, 'duration': 2.622}], 'summary': 'Tableau lod expressions allow for dynamic changes based on dimensions, using the superstore dataset.', 'duration': 26.351, 'max_score': 16473.152, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY16473151.jpg'}, {'end': 16835.816, 'src': 'embed', 'start': 16808.86, 'weight': 5, 'content': [{'end': 16812.622, 'text': 'Now we have the average sales per customer, according to regions.', 'start': 16808.86, 'duration': 3.762}, {'end': 16817.605, 'text': 'So the average sales per customer is 796.9 units.', 'start': 16813.043, 'duration': 4.562}, {'end': 16819.786, 'text': 'And that is in the central region.', 'start': 16818.346, 'duration': 1.44}, {'end': 16822.588, 'text': 'Next we have the east region, south and west.', 'start': 16820.247, 'duration': 2.341}, {'end': 16826.33, 'text': "So that's how we use the include level of detail expressions in Tableau.", 'start': 16823.048, 'duration': 3.282}, {'end': 16830.193, 'text': 'Now we are done with one example based on include level of detail expression.', 'start': 16826.751, 'duration': 3.442}, {'end': 16832.154, 'text': "Let's try to execute another example.", 'start': 16830.393, 'duration': 1.761}, {'end': 16834.775, 'text': 'Now we have this sheet too.', 'start': 16833.314, 'duration': 1.461}, {'end': 16835.816, 'text': "Let's try to rename it.", 'start': 16834.815, 'duration': 1.001}], 'summary': 'Average sales per customer is 796.9 units in the central region.', 'duration': 26.956, 'max_score': 16808.86, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY16808860.jpg'}, {'end': 17063.583, 'src': 'embed', 'start': 17034.344, 'weight': 6, 'content': [{'end': 17040.789, 'text': 'Exclude level of detail expressions are useful for percent of total or difference from overall average scenarios.', 'start': 17034.344, 'duration': 6.445}, {'end': 17044.592, 'text': 'They are comparable to such features as totals and reference lines.', 'start': 17041.409, 'duration': 3.183}, {'end': 17051.837, 'text': 'Exclude level of detail expressions cannot be used in row level expressions where there are no dimensions to omit,', 'start': 17045.172, 'duration': 6.665}, {'end': 17057.221, 'text': 'but it can be used to modify either of view level calculation or anything between.', 'start': 17051.837, 'duration': 5.384}, {'end': 17063.583, 'text': 'that is, you can use an exclude calculation to remove dimensions from some other level of detail expressions.', 'start': 17057.221, 'duration': 6.362}], 'summary': 'Exclude level of detail expressions are useful for modifying view level calculations or anything between, but cannot be used in row level expressions.', 'duration': 29.239, 'max_score': 17034.344, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17034344.jpg'}, {'end': 17277.504, 'src': 'embed', 'start': 17253.239, 'weight': 7, 'content': [{'end': 17259.743, 'text': 'So, the fixed level of detail expressions compute a value using the specified dimensions without reference to the dimensions in the view.', 'start': 17253.239, 'duration': 6.504}, {'end': 17266.321, 'text': "Now let's get back to Tableau and try to execute an example based on fixed level of detail expressions in Tableau.", 'start': 17260.999, 'duration': 5.322}, {'end': 17268.921, 'text': 'Now we are back on Tableau.', 'start': 17267.621, 'duration': 1.3}, {'end': 17273.163, 'text': "Let's create a new sheet and rename that sheet as fixed LOD.", 'start': 17268.941, 'duration': 4.222}, {'end': 17277.504, 'text': "Let's type an enter.", 'start': 17276.484, 'duration': 1.02}], 'summary': 'Tableau allows for fixed level of detail expressions, demonstrated through creating a new sheet and naming it fixed lod.', 'duration': 24.265, 'max_score': 17253.239, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17253239.jpg'}, {'end': 17430.856, 'src': 'embed', 'start': 17405.077, 'weight': 8, 'content': [{'end': 17410.061, 'text': 'The next difference is Table calculations are generated as query results,', 'start': 17405.077, 'duration': 4.984}, {'end': 17414.584, 'text': 'whereas the LOD expressions are generated as a part of query to the underlying data source.', 'start': 17410.061, 'duration': 4.523}, {'end': 17422.75, 'text': 'The third difference is table calculations are capable to generate either equal or less granule than the set LOD or level of detail.', 'start': 17415.125, 'duration': 7.625}, {'end': 17430.856, 'text': 'But whereas on the LOD expressions case, the level of detail expressions can generate results independent of the set level of detail.', 'start': 17423.15, 'duration': 7.706}], 'summary': 'Table calculations are query results, lod expressions are part of query. table calcs can generate equal or less granule than set lod, while lod expressions can generate independent results.', 'duration': 25.779, 'max_score': 17405.077, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17405077.jpg'}, {'end': 17487.59, 'src': 'embed', 'start': 17459.282, 'weight': 9, 'content': [{'end': 17466.224, 'text': "let's continue with the next part of this particular tutorial, where we will be discussing the limitations of LOD expressions in Tableau.", 'start': 17459.282, 'duration': 6.942}, {'end': 17470.745, 'text': 'So, following are the limitations of LOD expressions in Tableau.', 'start': 17467.685, 'duration': 3.06}, {'end': 17476.907, 'text': 'So, the first one is LOD expressions behave unreliable views when floating values are involved.', 'start': 17470.865, 'duration': 6.042}, {'end': 17487.59, 'text': 'So LOD expressions that reference floating point measures tend to behave in an unreliable fashion when used in a view that requires a comparison of the values in the expression.', 'start': 17478.207, 'duration': 9.383}], 'summary': 'Discussing limitations of lod expressions in tableau, including unreliable behavior with floating point measures.', 'duration': 28.308, 'max_score': 17459.282, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17459282.jpg'}], 'start': 16274.286, 'title': 'Tableau lod expressions', 'summary': 'Covers understanding, types, and practical use of level of detail (lod) expressions in tableau, including their relation to aggregation and granularity, creating visualizations, and discussing the limitations, with practical examples and use cases for include, exclude, and fixed lod expressions.', 'chapters': [{'end': 16345.196, 'start': 16274.286, 'title': 'Understanding lod expressions in tableau', 'summary': 'Explains the concept of level of detail (lod) expressions in tableau, including the types of lod expressions, their purposes, and an example demonstration. it also highlights the inverse proportional relation between aggregation and granularity levels.', 'duration': 70.91, 'highlights': ['LOD expressions allow computation of values at data source level and visualization level, giving more control over the level of granularity.', 'Three types of LOD expressions are include, exclude, and fixed, each used for different levels of granularity and independence.', 'The tutorial covers when and how to use LOD expressions in Tableau, along with a demonstration using a simple example.', 'The concept of aggregation and granularity levels is explained, with emphasis on their inverse proportional relation.']}, {'end': 16594.097, 'start': 16345.976, 'title': 'Types of lod expressions in tableau', 'summary': 'Explains the two types of lod expressions in tableau, including row level and view level, and highlights the steps to create and utilize lod expressions, along with practical examples and use cases for include level of detail expressions.', 'duration': 248.121, 'highlights': ['The chapter explains the two types of LOD expressions in Tableau, including row level and view level. ', 'The chapter provides steps to create and utilize LOD expressions, including setting up a visualization, creating a calculated field for LOD expression, and using the expression in the visualization. ', 'The chapter offers practical examples and use cases for include level of detail expressions in Tableau, emphasizing their usefulness in calculating at a fine level of detail in the database and re-aggregating for visualization. ']}, {'end': 17010.47, 'start': 16597.16, 'title': 'Tableau lod expressions', 'summary': 'Demonstrates creating visualizations and using include level of detail expressions in tableau to calculate average sales per customer and per state, resulting in visualizations showing the sales distribution across different regions and categories.', 'duration': 413.31, 'highlights': ['The chapter demonstrates creating visualizations and using include level of detail expressions in Tableau The chapter covers the process of creating visualizations and using include level of detail (LOD) expressions in Tableau to perform calculations.', 'Calculating average sales per customer and per state The chapter illustrates the process of creating a new calculated field to calculate the average sales per customer and per state using include level of detail (LOD) expressions.', 'Visualizations showing the sales distribution across different regions and categories The chapter showcases visualizations displaying the distribution of sales across different regions, as well as the average sales across different categories, using the include level of detail (LOD) expressions in Tableau.']}, {'end': 17503.39, 'start': 17011.231, 'title': 'Tableau lod expressions', 'summary': 'Discusses exclude and fixed level of detail expressions in tableau, demonstrating their usage through creating calculated fields and visualizations, highlighting the differences between table calculations and lod expressions, and outlining the limitations of lod expressions, such as their behavior with floating values and visibility in the data source.', 'duration': 492.159, 'highlights': ['Exclude LOD expressions in Tableau are used for percent of total or difference from overall average scenarios, and cannot be used in row level expressions where there are no dimensions to omit. Exclude LOD expressions are useful for percent of total or difference from overall average scenarios and cannot be used in row level expressions without dimensions.', "The chapter demonstrates the creation of a calculated field 'Exclude Region' to calculate the level of details which excludes the region from the sum of sales, and then uses this field to create a visualization, showcasing the practical application of exclude level of detail expressions. A calculated field 'Exclude Region' is created to exclude the region from the sum of sales, and then used in a visualization to demonstrate the practical application of exclude level of detail expressions.", "The chapter explains the usage of fixed level of detail expressions, demonstrating the creation of a calculated field 'Sales by Region' and its application in a text table to showcase how fixed level of detail expressions compute values using specified dimensions without reference to the dimensions in the view. Fixed level of detail expressions compute values using specified dimensions without reference to the dimensions in the view, as demonstrated through the creation of a calculated field 'Sales by Region' and its application in a text table.", 'The differences between table calculations and LOD expressions are outlined, covering aspects such as filters behavior, generation process, granule capabilities, usage as aggregated measures, and embedding of dimensions in the calculation syntax. The differences between table calculations and LOD expressions are outlined, including aspects such as filters behavior, generation process, granule capabilities, usage as aggregated measures, and embedding of dimensions in the calculation syntax.', 'The limitations of LOD expressions in Tableau are discussed, highlighting issues related to their behavior with floating values and their visibility in the data source. The limitations of LOD expressions in Tableau are discussed, including issues related to their behavior with floating values and their visibility in the data source.']}], 'duration': 1229.104, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY16274286.jpg', 'highlights': ['LOD expressions allow computation of values at data source level and visualization level, giving more control over the level of granularity.', 'The tutorial covers when and how to use LOD expressions in Tableau, along with a demonstration using a simple example.', 'The chapter explains the two types of LOD expressions in Tableau, including row level and view level.', 'The chapter offers practical examples and use cases for include level of detail expressions in Tableau, emphasizing their usefulness in calculating at a fine level of detail in the database and re-aggregating for visualization.', 'The chapter demonstrates creating visualizations and using include level of detail expressions in Tableau.', 'The chapter showcases visualizations displaying the distribution of sales across different regions, as well as the average sales across different categories, using the include level of detail (LOD) expressions in Tableau.', 'Exclude LOD expressions in Tableau are used for percent of total or difference from overall average scenarios, and cannot be used in row level expressions where there are no dimensions to omit.', "The chapter explains the usage of fixed level of detail expressions, demonstrating the creation of a calculated field 'Sales by Region' and its application in a text table to showcase how fixed level of detail expressions compute values using specified dimensions without reference to the dimensions in the view.", 'The differences between table calculations and LOD expressions are outlined, covering aspects such as filters behavior, generation process, granule capabilities, usage as aggregated measures, and embedding of dimensions in the calculation syntax.', 'The limitations of LOD expressions in Tableau are discussed, highlighting issues related to their behavior with floating values and their visibility in the data source.']}, {'end': 18990.583, 'segs': [{'end': 17543.439, 'src': 'embed', 'start': 17519.972, 'weight': 0, 'content': [{'end': 17527.181, 'text': 'the linking field from the primary data source must be in the view before you can use an LOD expression from the secondary data source.', 'start': 17519.972, 'duration': 7.209}, {'end': 17533.514, 'text': 'Today we will be building dashboards from start to finish, first about world population, then health,', 'start': 17527.671, 'duration': 5.843}, {'end': 17537.956, 'text': "next we'll build a dashboard about economy and finally we'll build a dashboard about business ease.", 'start': 17533.514, 'duration': 4.442}, {'end': 17543.439, 'text': 'I would recommend getting access to the dataset before you start this tutorial so you can build along with me.', 'start': 17538.537, 'duration': 4.902}], 'summary': 'Tutorial covers building dashboards on world population, health, economy, and business ease.', 'duration': 23.467, 'max_score': 17519.972, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17519972.jpg'}, {'end': 17727.924, 'src': 'embed', 'start': 17702.628, 'weight': 1, 'content': [{'end': 17709.372, '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': 17702.628, 'duration': 6.744}, {'end': 17716.617, 'text': 'Our next visualization for this dashboard is going to be population over time.', 'start': 17710.353, 'duration': 6.264}, {'end': 17721.6, 'text': "So let's bring on our time element.", 'start': 17718.058, 'duration': 3.542}, {'end': 17724.582, 'text': 'One trick for bringing on a time element.', 'start': 17722.301, 'duration': 2.281}, {'end': 17727.924, 'text': 'if we just drag it on, so year with the calendar mark here.', 'start': 17724.582, 'duration': 3.342}], 'summary': 'Visualization shows total population, percent contribution, and country name. next, adding population over time with a time element.', 'duration': 25.296, 'max_score': 17702.628, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17702628.jpg'}, {'end': 17916.769, 'src': 'embed', 'start': 17883.978, 'weight': 3, 'content': [{'end': 17896.508, 'text': "And we'll call this world population trend.", 'start': 17883.978, 'duration': 12.53}, {'end': 17903.917, 'text': "Excellent And we're going to make one more visualization for this and it's going to be a pie chart.", 'start': 17898.61, 'duration': 5.307}, {'end': 17907.26, 'text': 'So the pie chart is also going to be based off of population.', 'start': 17904.357, 'duration': 2.903}, {'end': 17916.769, 'text': "So we're going to click on population and we're going to control click on country and come over to show me and click your pie chart.", 'start': 17908.942, 'duration': 7.827}], 'summary': 'Creating a pie chart visualization based on world population trend.', 'duration': 32.791, 'max_score': 17883.978, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17883978.jpg'}, {'end': 18079.555, 'src': 'embed', 'start': 18043.49, 'weight': 4, 'content': [{'end': 18047.354, 'text': "And now let's rename it and then we'll put it all together on a dashboard.", 'start': 18043.49, 'duration': 3.864}, {'end': 18060.235, 'text': "great. so let's make our dashboard.", 'start': 18056.892, 'duration': 3.343}, {'end': 18065.2, 'text': 'we have this new dashboard button down here and you can choose what sizes you want.', 'start': 18060.235, 'duration': 4.965}, {'end': 18068.764, 'text': 'so we have a fixed size where you just select the width and height.', 'start': 18065.2, 'duration': 3.564}, {'end': 18079.555, 'text': 'we have automatic which will just fill your screen, and we have a range which has a minimum size and a maximum size.', 'start': 18068.764, 'duration': 10.791}], 'summary': 'Creating a dashboard with options for fixed, automatic, and range sizes.', 'duration': 36.065, 'max_score': 18043.49, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY18043490.jpg'}, {'end': 18310.348, 'src': 'embed', 'start': 18279.506, 'weight': 5, 'content': [{'end': 18286.293, 'text': 'So at this point we have a visualization or three visualizations all on the same page, which is the basics of a dashboard.', 'start': 18279.506, 'duration': 6.787}, {'end': 18291.157, 'text': 'However, we might want to be able to interact with them a little bit more than just hovering.', 'start': 18286.753, 'duration': 4.404}, {'end': 18295.956, 'text': 'And so this is where we should look into adding filters.', 'start': 18292.173, 'duration': 3.783}, {'end': 18302.141, 'text': 'So we have information over time, we have information by country, and we have some information by region here.', 'start': 18296.477, 'duration': 5.664}, {'end': 18310.348, 'text': 'One of the quickest things you can do to add functionality to the dashboard is by clicking this uses filter button.', 'start': 18302.982, 'duration': 7.366}], 'summary': 'Three visualizations on a dashboard can be made interactive by adding filters for time, country, and region.', 'duration': 30.842, 'max_score': 18279.506, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY18279506.jpg'}, {'end': 18448.281, 'src': 'embed', 'start': 18416.03, 'weight': 2, 'content': [{'end': 18419.411, 'text': 'So we can click, use as filter here and click Asia.', 'start': 18416.03, 'duration': 3.381}, {'end': 18425.594, 'text': 'and now it zooms into Asia on our map and shows us just the Asia world population trend.', 'start': 18419.411, 'duration': 6.183}, {'end': 18429.676, 'text': "and here's rest of the world and we can see that Asia is grayed out.", 'start': 18425.594, 'duration': 4.082}, {'end': 18431.817, 'text': "and there's the rest of the world.", 'start': 18429.676, 'duration': 2.141}, {'end': 18433.617, 'text': "and here's the rest of the world population trend.", 'start': 18431.817, 'duration': 1.8}, {'end': 18438.54, 'text': 'We might also want to be able to use this to filter to a certain year.', 'start': 18434.558, 'duration': 3.982}, {'end': 18448.281, 'text': 'So if we click use as filter Then we click on 2011.', 'start': 18438.56, 'duration': 9.721}], 'summary': 'Using filters, we zoomed into asia on the map and viewed the 2011 population trend.', 'duration': 32.251, 'max_score': 18416.03, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY18416030.jpg'}, {'end': 18660.131, 'src': 'embed', 'start': 18634.758, 'weight': 6, 'content': [{'end': 18639.775, 'text': 'And when you click on something in this view, it shows you where it exists.', 'start': 18634.758, 'duration': 5.017}, {'end': 18646.881, 'text': 'So we can see this horizontal container is outlined now and then we change it to vertical and it outlines this.', 'start': 18640.656, 'duration': 6.225}, {'end': 18654.767, 'text': 'Now a horizontal container allows things to be side by side and a vertical container allows things to be one on top of the other.', 'start': 18647.381, 'duration': 7.386}, {'end': 18660.131, 'text': 'And so in our vertical container we see all this extra space for extra things to be on top of each other.', 'start': 18655.147, 'duration': 4.984}], 'summary': 'Demonstrating the functionality of containers for layout, with clear visual indication of their behavior.', 'duration': 25.373, 'max_score': 18634.758, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY18634758.jpg'}, {'end': 18800.42, 'src': 'embed', 'start': 18775.356, 'weight': 7, 'content': [{'end': 18780.82, 'text': 'So the dashboard is basically for 2012 except for the trend which shows you the past and the future.', 'start': 18775.356, 'duration': 5.464}, {'end': 18785.764, 'text': 'So one way that you can do that is clicking apply to worksheets here.', 'start': 18781.32, 'duration': 4.444}, {'end': 18798.26, 'text': 'and you can choose selected worksheets and it will show you all the worksheets in this visualization or in this dashboard and you can click show all worksheets in workbook and then,', 'start': 18787.116, 'duration': 11.144}, {'end': 18800.42, 'text': 'if there were other worksheets, it would show them.', 'start': 18798.26, 'duration': 2.16}], 'summary': 'Dashboard for 2012 with trend showing past and future, apply to selected worksheets to visualize all worksheets in dashboard.', 'duration': 25.064, 'max_score': 18775.356, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY18775356.jpg'}], 'start': 17503.39, 'title': 'Limitations and visualization in tableau', 'summary': 'Discusses limitations of lod expressions in tableau, visualizing world population trends with line graphs and pie charts, creating and customizing dashboards, and adding filters for interactive dashboards, focusing on world population, health, economy, and business ease, with a specific emphasis on asia and the year 2012.', 'chapters': [{'end': 17755.191, 'start': 17503.39, 'title': 'Limitations of lod expressions in tableau', 'summary': 'Discusses limitations of lod expressions in tableau, including referencing parameters in dimensionality declaration, data blending, and building dashboards for world population, health, economy, and business ease.', 'duration': 251.801, 'highlights': ['Building dashboards for world population, health, economy, and business ease The tutorial covers building dashboards for world population, health, economy, and business ease, providing a comprehensive approach to data visualization.', 'Limitation of LOD expressions with data blending An important limitation discussed is that the linking field from the primary data source must be in the view before using an LOD expression from the secondary data source.', 'Labeling visualization with country contributions to world population The tutorial demonstrates how to label the visualization with country contributions to world population by percentage, providing insights into the population distribution.']}, {'end': 18042.649, 'start': 17756.071, 'title': 'Visualizing world population', 'summary': 'Demonstrates how to visualize world population trends using line graphs and pie charts, emphasizing the importance of accurately interpreting data and using forecasting techniques to project future population growth with a focus on asia.', 'duration': 286.578, 'highlights': ['The importance of accurately interpreting data and using forecasting techniques to project future population growth with a focus on Asia Emphasizes the significance of accurately interpreting data and utilizing forecasting techniques to project future population growth, particularly focusing on Asia.', 'Demonstrating how to visualize world population trends using line graphs and pie charts Illustrates the process of visualizing world population trends through the use of line graphs and pie charts.', 'Adjusting the axis to exclude zero for a more focused data representation Discusses the option to exclude zero on the axis to create a more focused representation of data.']}, {'end': 18279.126, 'start': 18043.49, 'title': 'Dashboard layout and customization', 'summary': 'Discusses creating a dashboard, choosing different sizes, and customizing visualizations, with a focus on maintaining layout consistency and optimizing space usage.', 'duration': 235.636, 'highlights': ['Creating a dashboard with different size options - fixed, automatic, and range Different size options for creating a dashboard are available, such as fixed, automatic, and range, each offering distinct advantages for layout consistency and screen adaptability.', 'Adjusting visualization fitting options and controlling space allocation The ability to adjust fitting options for visualizations, including standard fit, entire view, fit width, and fit height, allows for precise control over space allocation and presentation of visual data.', 'Customizing and optimizing visualizations on the dashboard Customizing visualizations by editing titles, removing unnecessary legends, and optimizing space usage for better data presentation and visualization clarity.']}, {'end': 18738.269, 'start': 18279.506, 'title': 'Adding filters for interactive dashboards', 'summary': 'Discusses how to add filters to visualizations to enhance interactivity, such as using filters to modify actions and create meaningful visualizations, and the process of adding and formatting filters on the dashboard.', 'duration': 458.763, 'highlights': ['Filters can be added to visualizations to enhance interactivity, such as using filters to modify actions and create meaningful visualizations. The chapter discusses the process of adding filters to visualizations to enhance interactivity, including modifying actions to create meaningful visualizations and using filters to interact with the data.', 'Adding and formatting filters on the dashboard is crucial for creating a user-friendly and visually appealing dashboard. The process of adding and formatting filters on the dashboard is crucial for creating a user-friendly and visually appealing dashboard, with options to customize the layout and hierarchy of items.', 'Understanding the layout and hierarchy of containers within the dashboard, such as horizontal and vertical containers, is essential for organizing visual elements. Understanding the layout and hierarchy of containers within the dashboard, such as horizontal and vertical containers, is essential for organizing visual elements, allowing for flexibility in arranging visual components.']}, {'end': 18990.583, 'start': 18743.612, 'title': 'Tableau dashboard features', 'summary': 'Explains how tableau dashboards can be effectively used to visualize data, apply filters and actions, and customize visualizations, with a focus on the year 2012, providing insights into the usability and functionality of the platform.', 'duration': 246.971, 'highlights': ['The dashboard is designed for the year 2012, with the trend displaying both past and future data, while other visualizations show one year at a time.', 'Applying filters to worksheets allows for synchronization and the ability to select all worksheets within the visualization, enhancing the user experience.', 'Customizing filters to show apply buttons enables users to make changes and updates more effectively, ensuring a smoother interactive experience.', "Utilizing full screen mode provides an opportunity to test the dashboard's appearance and functionality from an end-user perspective, enhancing the overall user experience."]}], 'duration': 1487.193, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY17503390.jpg', 'highlights': ['Building dashboards for world population, health, economy, and business ease.', 'Demonstrating how to label the visualization with country contributions to world population by percentage.', 'The importance of accurately interpreting data and using forecasting techniques to project future population growth with a focus on Asia.', 'Demonstrating how to visualize world population trends using line graphs and pie charts.', 'Creating a dashboard with different size options - fixed, automatic, and range.', 'Adding and formatting filters on the dashboard is crucial for creating a user-friendly and visually appealing dashboard.', 'Understanding the layout and hierarchy of containers within the dashboard, such as horizontal and vertical containers, is essential for organizing visual elements.', 'The dashboard is designed for the year 2012, with the trend displaying both past and future data, while other visualizations show one year at a time.']}, {'end': 21044.384, 'segs': [{'end': 19088.039, 'src': 'embed', 'start': 18991.403, 'weight': 1, 'content': [{'end': 18995.026, 'text': "Next we're going to make a dashboard revolving around health information.", 'start': 18991.403, 'duration': 3.623}, {'end': 19000.35, 'text': "So first we're going to make a map about birth rates.", 'start': 18995.706, 'duration': 4.644}, {'end': 19004.573, 'text': "So we're going to call it birth rate rank.", 'start': 19000.83, 'duration': 3.743}, {'end': 19008.345, 'text': 'and to make a map.', 'start': 19007.265, 'duration': 1.08}, {'end': 19014.767, 'text': "we're going to double click on country and we're going to change it to a map type.", 'start': 19008.345, 'duration': 6.422}, {'end': 19020.108, 'text': "so we have a filled map here and then we're going to bring birth rate onto color.", 'start': 19014.767, 'duration': 5.341}, {'end': 19025.15, 'text': "so let's define our colors a little bit by clicking on this color part of the marks card.", 'start': 19020.108, 'duration': 5.042}, {'end': 19037.024, 'text': "we'll click edit colors and we're going to change it to red and gold, and the idea here is that The red is for a higher birth rate,", 'start': 19025.15, 'duration': 11.874}, {'end': 19041.205, 'text': 'which is more associated with countries that have poor health.', 'start': 19037.024, 'duration': 4.181}, {'end': 19042.625, 'text': "So we'll hit apply.", 'start': 19041.805, 'duration': 0.82}, {'end': 19048.868, 'text': 'And now we have our higher birth rate countries highlighted in red.', 'start': 19042.645, 'duration': 6.223}, {'end': 19053.829, 'text': "Next, we're going to create a class.", 'start': 19049.448, 'duration': 4.381}, {'end': 19055.97, 'text': "So we're going to duplicate birth rate.", 'start': 19053.869, 'duration': 2.101}, {'end': 19058.451, 'text': "And let's edit that field.", 'start': 19057.05, 'duration': 1.401}, {'end': 19062.212, 'text': "We're going to call it birth rate class.", 'start': 19059.891, 'duration': 2.321}, {'end': 19076.076, 'text': "And so we're going to say that anything that is in the top 50 countries with the highest birth rate is categorized as having an alarming birth rate.", 'start': 19063.792, 'duration': 12.284}, {'end': 19083.118, 'text': 'So we will first do the average birth rate.', 'start': 19076.176, 'duration': 6.942}, {'end': 19088.039, 'text': "And then we're going to do a rank on that.", 'start': 19084.438, 'duration': 3.601}], 'summary': 'Creating a health dashboard with birth rate map and alarming birth rate classification based on top 50 countries with highest birth rate.', 'duration': 96.636, 'max_score': 18991.403, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY18991403.jpg'}, {'end': 19157.572, 'src': 'embed', 'start': 19116.704, 'weight': 5, 'content': [{'end': 19122.286, 'text': 'So if I put a space and then I start to type if and I click if, it will not delete rank.', 'start': 19116.704, 'duration': 5.582}, {'end': 19129.099, 'text': "So we're going to say if the rank of average is less than or equal to 50.", 'start': 19122.774, 'duration': 6.325}, {'end': 19137.446, 'text': "So if it's in the top 50, then alarming birth rate.", 'start': 19129.099, 'duration': 8.347}, {'end': 19149.135, 'text': 'Else if, and we can take this again, is greater than 50, then normal birth rate.', 'start': 19140.568, 'duration': 8.567}, {'end': 19157.572, 'text': 'always make sure you put on the end.', 'start': 19156.252, 'duration': 1.32}], 'summary': "Using an 'if' statement, if the average rank is <= 50, it's alarming birth rate; else, it's normal birth rate.", 'duration': 40.868, 'max_score': 19116.704, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY19116704.jpg'}, {'end': 19848.984, 'src': 'embed', 'start': 19816.242, 'weight': 0, 'content': [{'end': 19824.968, 'text': 'and now, with these separate color palettes, you can quickly see the difference with birth rate and spending on health,', 'start': 19816.242, 'duration': 8.726}, {'end': 19830.411, 'text': 'and that is our heat map with separate legends.', 'start': 19824.968, 'duration': 5.443}, {'end': 19832.493, 'text': "so let's build this all into a dashboard.", 'start': 19830.411, 'duration': 2.082}, {'end': 19846.622, 'text': "now we're going to call it our health dashboard and for simplicity, we're going to make it automatic, so it fills our screen.", 'start': 19832.493, 'duration': 14.129}, {'end': 19848.984, 'text': "and then we're going to first bring on our map.", 'start': 19846.622, 'duration': 2.362}], 'summary': 'Using separate color palettes, birth rate and health spending are visualized in a heat map, integrated into an automatic health dashboard.', 'duration': 32.742, 'max_score': 19816.242, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY19816242.jpg'}, {'end': 20374.098, 'src': 'embed', 'start': 20349.843, 'weight': 7, 'content': [{'end': 20356.326, 'text': 'So GDP or gross domestic product versus gross domestic product per capita or per person.', 'start': 20349.843, 'duration': 6.483}, {'end': 20370.557, 'text': 'And to make a scatter plot, you have one measure on one axis and then another measure, which is going to be GDP per capita,', 'start': 20357.686, 'duration': 12.871}, {'end': 20374.098, 'text': 'which we will now create on the other axis.', 'start': 20370.557, 'duration': 3.541}], 'summary': 'Comparing gdp and gdp per capita in scatter plot.', 'duration': 24.255, 'max_score': 20349.843, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY20349843.jpg'}, {'end': 20548.534, 'src': 'embed', 'start': 20499.293, 'weight': 6, 'content': [{'end': 20505.037, 'text': 'Also you can click to highlight and you can see all of the Americas highlighted in context.', 'start': 20499.293, 'duration': 5.744}, {'end': 20523.789, 'text': "The next visualization we're going to make is going to be showing how much countries spend on health care as a part of their GDP.", 'start': 20509.56, 'duration': 14.229}, {'end': 20528.72, 'text': "So we're going to rename it to be GDP on healthcare.", 'start': 20523.869, 'duration': 4.851}, {'end': 20534.604, 'text': "And we're going to look at each of our countries.", 'start': 20532.923, 'duration': 1.681}, {'end': 20548.534, 'text': "And we're going to make a bar chart that shows the health expense GDP.", 'start': 20537.606, 'duration': 10.928}], 'summary': "Visualizing countries' healthcare spending as a share of gdp.", 'duration': 49.241, 'max_score': 20499.293, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY20499293.jpg'}, {'end': 20814.681, 'src': 'embed', 'start': 20790.444, 'weight': 8, 'content': [{'end': 20800.251, 'text': "An interesting thing you can do in Tableau is you can see this outlier of the United States is making it difficult to see the rest of the information or to visualize if there's any trend there.", 'start': 20790.444, 'duration': 9.807}, {'end': 20806.455, 'text': 'So you could right click on it and click exclude and then it will exclude it from your data set very quickly.', 'start': 20800.891, 'duration': 5.564}, {'end': 20809.958, 'text': "And then it'll just click this back button to get it back.", 'start': 20807.876, 'duration': 2.082}, {'end': 20814.681, 'text': "Great Now let's take a look at filters.", 'start': 20812.48, 'duration': 2.201}], 'summary': 'In tableau, you can quickly exclude outlier data points, like the united states, to better visualize trends and information.', 'duration': 24.237, 'max_score': 20790.444, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY20790444.jpg'}, {'end': 20900.405, 'src': 'embed', 'start': 20868.629, 'weight': 9, 'content': [{'end': 20875.135, 'text': "so we're going to apply to worksheets and we can click selected worksheets and we can click all on dashboard.", 'start': 20868.629, 'duration': 6.506}, {'end': 20878.646, 'text': "Okay Let's bring this over here.", 'start': 20875.155, 'duration': 3.491}, {'end': 20884.428, 'text': "We're going to allow them to see all at once and be able to scroll and select the ones they want.", 'start': 20879.006, 'duration': 5.422}, {'end': 20889.111, 'text': 'And now, when we select different ones, it affects all three worksheets.', 'start': 20884.808, 'duration': 4.303}, {'end': 20900.405, 'text': "We're also going to add an action for a URL action.", 'start': 20894.173, 'duration': 6.232}], 'summary': 'Enhancing dashboard functionality with multiple worksheets and url actions.', 'duration': 31.776, 'max_score': 20868.629, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY20868629.jpg'}], 'start': 18991.403, 'title': 'Health data visualization', 'summary': 'Covers creating a health dashboard to analyze birth rates, building visualizations and charts in tableau, customizing data visualization, and analyzing gdp and healthcare expenses to highlight regional disparities and spending proportions.', 'chapters': [{'end': 19088.039, 'start': 18991.403, 'title': 'Health dashboard: birth rate analysis', 'summary': 'Discusses creating a dashboard focusing on health information, specifically analyzing birth rates using tableau to visualize the data and classify countries into alarming birth rate categories.', 'duration': 96.636, 'highlights': ['The red color on the map represents a higher birth rate, which is associated with countries that have poor health.', 'The top 50 countries with the highest birth rate are categorized as having an alarming birth rate.', 'The process involves creating a map, defining colors, and classifying birth rates for visualization and analysis.']}, {'end': 19816.242, 'start': 19089.76, 'title': 'Tableau visualizations and chart creation', 'summary': 'Discusses the creation of visualizations and charts in tableau, including the use of if statements, table calculations, and the creation of heat maps and blended axis charts.', 'duration': 726.482, 'highlights': ["The chapter explains the use of if statements to categorize data based on a specific condition, such as if the rank of average is less than or equal to 50, then it's classified as alarming birth rate, and if it's greater than 50, it's classified as normal birth rate. The chapter explains the use of if statements to categorize data based on specific conditions, such as if the rank of average is less than or equal to 50, then it's classified as alarming birth rate, and if it's greater than 50, it's classified as normal birth rate.", 'It discusses the creation of blended axis charts and the synchronization of axes in Tableau, providing insights on visualizing multiple charts on the same axis and ensuring alignment of data. It discusses the creation of blended axis charts and the synchronization of axes in Tableau, providing insights on visualizing multiple charts on the same axis and ensuring alignment of data.', 'The chapter covers the creation of heat maps in Tableau, including the customization of legends and colors to visualize and analyze different metrics independently within the same visualization. The chapter covers the creation of heat maps in Tableau, including the customization of legends and colors to visualize and analyze different metrics independently within the same visualization.']}, {'end': 20240.764, 'start': 19816.242, 'title': 'Building health dashboard', 'summary': 'Demonstrates building a health dashboard with separate legends and filters for country and year, allowing users to visualize birth rates, spending on health, and life expectancy, and adjusting the size and colors of the visualizations to enhance clarity and user experience.', 'duration': 424.522, 'highlights': ['The dashboard includes separate legends and filters for country and year, providing users with interactive visualization of birth rates, spending on health, and life expectancy, enhancing user experience (Relevance: High)', 'Adjusting the size and layout of the visualizations to optimize space and presentation, demonstrating practical techniques for improving dashboard aesthetics and functionality (Relevance: Medium)', 'Enhancing the clarity and distinctiveness of colors in the heat map by changing the color sequence to a stepped color with three distinct categories, improving the visual representation of data (Relevance: Medium)', 'Demonstrating how to navigate to specific worksheets from the dashboard and edit colors to enhance dramatic differences, improving the visual appeal and interpretability of the data (Relevance: Low)']}, {'end': 20592.099, 'start': 20241.565, 'title': 'Gdp visualization and analysis', 'summary': 'Demonstrates the creation of visualizations to analyze gdp, gdp per capita, and healthcare expenses, highlighting regional disparities and spending proportions.', 'duration': 350.534, 'highlights': ['The visualization creation process includes mapping overall GDP, creating scatter plots for GDP versus GDP per capita, and showing healthcare expenses as a proportion of GDP.', 'The scatter plot analysis reveals disparities in GDP and GDP per capita across different countries and regions, providing insights into their economic performance.', 'The demonstration also includes the customization of color schemes and the use of visual elements like circles and highlighting to enhance the clarity and interpretability of the visualizations.']}, {'end': 21044.384, 'start': 20592.799, 'title': 'Customizing data visualization in tableau', 'summary': 'Covers customizing data visualization in tableau, including formatting data to percentage and currency, customizing tooltips, creating dashboards, excluding outliers, applying filters to multiple worksheets, and adding url actions for interactive mapping.', 'duration': 451.585, 'highlights': ['The chapter covers formatting data to percentage and currency, customizing tooltips, creating dashboards, excluding outliers, and applying filters to multiple worksheets in Tableau.', 'The tutorial explains how to apply a URL action for interactive mapping in Tableau.', 'The speaker demonstrates how to customize tooltips and exclude outliers in Tableau.', 'The tutorial highlights the process of formatting data to percentage and currency in Tableau.', 'The chapter explains how to create dashboards and apply filters to multiple worksheets in Tableau.']}], 'duration': 2052.981, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY18991403.jpg', 'highlights': ['The dashboard includes separate legends and filters for country and year, providing users with interactive visualization of birth rates, spending on health, and life expectancy, enhancing user experience', 'The red color on the map represents a higher birth rate, which is associated with countries that have poor health', 'The top 50 countries with the highest birth rate are categorized as having an alarming birth rate', 'The process involves creating a map, defining colors, and classifying birth rates for visualization and analysis', 'The chapter covers the creation of heat maps in Tableau, including the customization of legends and colors to visualize and analyze different metrics independently within the same visualization', "The chapter explains the use of if statements to categorize data based on a specific condition, such as if the rank of average is less than or equal to 50, then it's classified as alarming birth rate, and if it's greater than 50, it's classified as normal birth rate", 'The visualization creation process includes mapping overall GDP, creating scatter plots for GDP versus GDP per capita, and showing healthcare expenses as a proportion of GDP', 'The scatter plot analysis reveals disparities in GDP and GDP per capita across different countries and regions, providing insights into their economic performance', 'The chapter covers formatting data to percentage and currency, customizing tooltips, creating dashboards, excluding outliers, and applying filters to multiple worksheets in Tableau', 'The tutorial explains how to apply a URL action for interactive mapping in Tableau']}, {'end': 22412.562, 'segs': [{'end': 21082.429, 'src': 'embed', 'start': 21044.844, 'weight': 0, 'content': [{'end': 21048.806, 'text': 'Our final dashboard is going to be about the ease of doing business in a country.', 'start': 21044.844, 'duration': 3.962}, {'end': 21058.03, 'text': 'So our first visualization is going to be a bar chart, which we will call days to start business.', 'start': 21049.346, 'duration': 8.684}, {'end': 21069.779, 'text': "so how many days it takes to start a business is important to know when you're trying to start a business in a country and also can be an indicator of how easy it will be to do business in that country.", 'start': 21059.15, 'duration': 10.629}, {'end': 21082.429, 'text': "so let's make a bar chart that includes every country and then we're going to bring on days to start a business and we will sort it smallest to biggest,", 'start': 21069.779, 'duration': 12.65}], 'summary': 'Dashboard on ease of doing business with bar chart of days to start business for each country.', 'duration': 37.585, 'max_score': 21044.844, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY21044844.jpg'}, {'end': 21289.257, 'src': 'embed', 'start': 21255.83, 'weight': 1, 'content': [{'end': 21261.051, 'text': 'But if we here convert it to a measure, then it also automatically made it a count.', 'start': 21255.83, 'duration': 5.221}, {'end': 21267.032, 'text': 'So the first thing to do would be to change the data type to a number.', 'start': 21261.931, 'duration': 5.101}, {'end': 21275.654, 'text': 'And now we can change it to a measure and aggregate it.', 'start': 21268.912, 'duration': 6.742}, {'end': 21277.434, 'text': 'So we could do the sum.', 'start': 21275.794, 'duration': 1.64}, {'end': 21280.109, 'text': 'of ease of business.', 'start': 21278.767, 'duration': 1.342}, {'end': 21289.257, 'text': "In our use case, we're actually going to do the average of ease of business and then we want to have the smallest on the top.", 'start': 21280.949, 'duration': 8.308}], 'summary': 'Convert to measure, change data type to number, aggregate ease of business, average and arrange smallest on top.', 'duration': 33.427, 'max_score': 21255.83, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY21255830.jpg'}, {'end': 21770.381, 'src': 'embed', 'start': 21736.008, 'weight': 2, 'content': [{'end': 21750.339, 'text': "and let's grab the tax rate and then we'll erase this and we'll hit ok, and I've made a typo.", 'start': 21736.008, 'duration': 14.331}, {'end': 21760.177, 'text': 'so Singapore is the most business friend, is not what I meant to say, so I can click edit business friendly, but has a tax rate of.', 'start': 21750.339, 'duration': 9.838}, {'end': 21767.86, 'text': 'And you can move this around, draws the line to Singapore, which is the mark that we wanted to annotate.', 'start': 21760.518, 'duration': 7.342}, {'end': 21770.381, 'text': 'So that is an annotation on a mark.', 'start': 21768.06, 'duration': 2.321}], 'summary': 'Singapore is the most business-friendly with a tax rate annotation.', 'duration': 34.373, 'max_score': 21736.008, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY21736008.jpg'}, {'end': 21851.054, 'src': 'embed', 'start': 21819.753, 'weight': 3, 'content': [{'end': 21823.915, 'text': "And it's going to be about phone and internet usage.", 'start': 21819.753, 'duration': 4.162}, {'end': 21833.799, 'text': "Because you may want to know about the phone and internet trends when you're looking to start a business.", 'start': 21825.736, 'duration': 8.063}, {'end': 21836.88, 'text': "So we're gonna do this one over time.", 'start': 21835.44, 'duration': 1.44}, {'end': 21841.182, 'text': 'So it does not need to have that year filter on it.', 'start': 21838.081, 'duration': 3.101}, {'end': 21845.044, 'text': "And we're doing our continuous, our axis.", 'start': 21843.063, 'duration': 1.981}, {'end': 21849.714, 'text': "And we're going to look at mobile phone usage.", 'start': 21846.072, 'duration': 3.642}, {'end': 21851.054, 'text': 'So I double clicked it.', 'start': 21850.194, 'duration': 0.86}], 'summary': 'Analyzing phone and internet usage trends for business purposes.', 'duration': 31.301, 'max_score': 21819.753, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY21819753.jpg'}, {'end': 22212.307, 'src': 'embed', 'start': 22176.616, 'weight': 4, 'content': [{'end': 22181.978, 'text': "That makes it clear that it's just changing this chart so that people don't get confused.", 'start': 22176.616, 'duration': 5.362}, {'end': 22191.822, 'text': "Another thing that we can do that we should do on all of our visualizations is change the titles so that they're more business or user friendly.", 'start': 22183.159, 'duration': 8.663}, {'end': 22199.897, 'text': "Great, and so we have our filter and let's use this as a filter,", 'start': 22192.863, 'duration': 7.034}, {'end': 22212.307, 'text': "and that way we can click on New Zealand and we can see it's a most business-friendly regulations and we can see its internet and phone usage over time.", 'start': 22199.897, 'duration': 12.41}], 'summary': 'Improve visualizations for user friendliness, including filter for specific data like new zealand.', 'duration': 35.691, 'max_score': 22176.616, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY22176616.jpg'}, {'end': 22386.554, 'src': 'embed', 'start': 22355.812, 'weight': 5, 'content': [{'end': 22360.312, 'text': 'Those are what are the total number of confirmed cases in different nations?', 'start': 22355.812, 'duration': 4.5}, {'end': 22363.893, 'text': 'What are the total number of recovered cases in different nations?', 'start': 22360.892, 'duration': 3.001}, {'end': 22374.215, 'text': "So we'll be using the map chart for these and we'll be finding out the insights about how are the cases going on in the current situation or in the current date or year.", 'start': 22363.933, 'duration': 10.282}, {'end': 22379.743, 'text': "Followed by that, we'll also look into the insights of the confirmed and recovered cases in India as well.", 'start': 22374.995, 'duration': 4.748}, {'end': 22386.554, 'text': "Followed by that, we'll enter into the next query, where we'll find out the trend line of COVID-19 in the international level, like how it started.", 'start': 22380.144, 'duration': 6.41}], 'summary': "Analyzing global covid-19 cases and trends, including india's data.", 'duration': 30.742, 'max_score': 22355.812, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY22355812.jpg'}], 'start': 21044.844, 'title': 'Visualizing business data', 'summary': 'Discusses creating bar charts to visualize the days it takes to start a business, visualizing business data using tableau, analyzing business-friendly regions, and exploring phone and internet usage trends in preparation for starting a business.', 'chapters': [{'end': 21192.528, 'start': 21044.844, 'title': 'Ease of doing business dashboard', 'summary': "Discusses creating a bar chart to visualize the days it takes to start a business in various countries, filtering out countries with no data, and defining a 'business-friendly market' based on the number of days to start a business, especially focusing on those taking less than or equal to 25 days in 2012.", 'duration': 147.684, 'highlights': ['Creating a bar chart to visualize the days it takes to start a business in various countries. The visualization aims to represent the time required to start a business in different countries, providing a comparative analysis.', "Defining a 'business-friendly market' based on the number of days to start a business, especially focusing on those taking less than or equal to 25 days in 2012. The chapter emphasizes the importance of categorizing countries as 'business-friendly' based on the time required to start a business, particularly highlighting those taking 25 days or less in 2012.", 'Filtering out countries with no data and focusing on a specific year (2012) for analysis. The process involves excluding countries with no available data and narrowing the focus to the year 2012 for in-depth examination.']}, {'end': 21580.455, 'start': 21194.727, 'title': 'Visualizing business data', 'summary': 'Discusses visualizing business data using tableau, including converting data types, filtering, and creating conditional categories based on business friendliness, with the top three being the most business friendly, followed by varied regulations from four to ten.', 'duration': 385.728, 'highlights': ['Converting ease of business to a measure and aggregating it by taking the average to represent business friendliness. The process involves converting the ease of business data type to a number, then aggregating it by taking the average to represent the business friendliness.', 'Creating conditional categories for business friendliness based on ease of business ratings, categorizing them as most business friendly, moderate, strict, and not preferred for business. The chapter explains the creation of conditional categories based on ease of business ratings, categorizing the data as most business friendly, moderate, strict, and not preferred for business.', 'Sorting the business friendliness categories to display the most business friendly at the top, followed by moderate, strict, and not preferred. The chapter covers the sorting of business friendliness categories to display the most business friendly at the top, followed by moderate, strict, and not preferred.']}, {'end': 21817.8, 'start': 21580.455, 'title': 'Business-friendly regions analysis', 'summary': 'Demonstrates an analysis of business-friendly regions in 2012, highlighting singapore as the most business-friendly country with a 27% tax rate, while saudi arabia has an 8% tax rate, and annotations are made to depict the business-friendliness and tax rates of different countries.', 'duration': 237.345, 'highlights': ['Singapore is the most business-friendly with a 27% tax rate, while Saudi Arabia has an 8% tax rate, showcasing varying tax rates among different regions.', 'Annotations are made to depict the business-friendliness and tax rates of different countries, providing additional information for the visualization.', 'The demonstration includes an analysis of business-friendly regions in 2012, emphasizing the importance of business tax rates in determining business-friendliness.']}, {'end': 22049.286, 'start': 21819.753, 'title': 'Phone & internet usage trends', 'summary': 'Explores trends in phone and internet usage over time, examining the visualizations and data manipulation techniques, in preparation for starting a business.', 'duration': 229.533, 'highlights': ['The chapter explores trends in phone and internet usage over time The chapter focuses on analyzing trends in phone and internet usage to gain insights for starting a business.', 'Different visualization techniques are used to compare mobile phone and internet usage Various visualization techniques, including side-by-side visualizations with different axes and line and bar charts, are employed to compare and analyze mobile phone and internet usage trends.', 'Emphasis on data manipulation and visualization customization for better insights The emphasis is on manipulating data, customizing visualizations, and changing attributes such as width, color, and axis arrangement to enhance insights into phone and internet usage trends.']}, {'end': 22412.562, 'start': 22049.286, 'title': 'Tableau project insights', 'summary': 'Discusses the process of setting up filters, creating visualizations, and analyzing covid-19 data in tableau, including insights on confirmed and recovered cases, trend lines, death rates, and future predictions.', 'duration': 363.276, 'highlights': ['The chapter discusses the process of setting up filters and creating visualizations in Tableau, including the need to set specific filters unconnected to others to accurately display data. It explains the importance of setting up filters unconnected to others to accurately display data, ensuring that the filters only affect specific visualizations and not others.', "Insights on COVID-19 data, including the total number of confirmed and recovered cases in different nations, trend lines, and death rates, are highlighted as key analytical points within the chapter. The chapter provides insights on COVID-19 data, such as total confirmed and recovered cases in different nations, trend lines, and international death rates, offering valuable analytical points for understanding the pandemic's impact.", "The chapter outlines the future predictions of COVID-19 at the international level, adding a forward-looking perspective to the analysis of the pandemic's impact. It discusses the future predictions of COVID-19 at the international level, providing a forward-looking perspective to understand the potential trajectory of the pandemic."]}], 'duration': 1367.718, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY21044844.jpg', 'highlights': ['Creating a bar chart to visualize the days it takes to start a business in various countries.', 'Converting ease of business to a measure and aggregating it by taking the average to represent business friendliness.', 'Singapore is the most business-friendly with a 27% tax rate, while Saudi Arabia has an 8% tax rate, showcasing varying tax rates among different regions.', 'The chapter explores trends in phone and internet usage over time.', 'The chapter discusses the process of setting up filters and creating visualizations in Tableau, including the need to set specific filters unconnected to others to accurately display data.', 'Insights on COVID-19 data, including the total number of confirmed and recovered cases in different nations, trend lines, and death rates, are highlighted as key analytical points within the chapter.']}, {'end': 23301.07, 'segs': [{'end': 22435.36, 'src': 'embed', 'start': 22412.862, 'weight': 0, 'content': [{'end': 22420.848, 'text': "Basically, we'll create a trend line which will give us the forecast levels of the COVID-19, like is it going to increase or is it going to decrease,", 'start': 22412.862, 'duration': 7.986}, {'end': 22422.67, 'text': "or what's going to happen in the near future?", 'start': 22420.848, 'duration': 1.822}, {'end': 22429.616, 'text': 'So I hope I made myself clear with the queries or the insights that we are going to take from the COVID-19 dataset using Tableau.', 'start': 22423.31, 'duration': 6.306}, {'end': 22432.838, 'text': "So without further ado, let's get started with the Tableau.", 'start': 22430.076, 'duration': 2.762}, {'end': 22435.36, 'text': 'So we are on Tableau right now.', 'start': 22433.719, 'duration': 1.641}], 'summary': 'Creating a trend line to forecast covid-19 levels using tableau.', 'duration': 22.498, 'max_score': 22412.862, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY22412862.jpg'}, {'end': 22486.654, 'src': 'embed', 'start': 22459.604, 'weight': 2, 'content': [{'end': 22476.568, 'text': 'So you can see that we just got connected with that data and there will be some minute errors in the data or there will be some problem with the data which the tableau might identify,', 'start': 22459.604, 'duration': 16.964}, {'end': 22482.391, 'text': 'and when it identifies something messy with the data, it will show you an option.', 'start': 22476.568, 'duration': 5.823}, {'end': 22486.654, 'text': 'maybe you might want to use the data interpreter, so i prefer using that.', 'start': 22482.391, 'duration': 4.263}], 'summary': 'Tableau may identify errors in the data and suggest using data interpreter.', 'duration': 27.05, 'max_score': 22459.604, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY22459604.jpg'}, {'end': 22594.542, 'src': 'embed', 'start': 22568.052, 'weight': 4, 'content': [{'end': 22576.895, 'text': 'So we have the serial numbers, observation dates, province, state and country or region last update and confirmed deaths recovered.', 'start': 22568.052, 'duration': 8.843}, {'end': 22581.557, 'text': 'So, basically, these three columns will be telling us the confirmed cases in that particular region,', 'start': 22577.375, 'duration': 4.182}, {'end': 22588.499, 'text': 'country or state and the deaths happened in that region, country or state and recovered rate and the last update.', 'start': 22581.557, 'duration': 6.942}, {'end': 22594.542, 'text': "when was the last test done, the latest test done and in which region, and what's the observation date.", 'start': 22588.499, 'duration': 6.043}], 'summary': 'The data includes serial numbers, observation dates, province/state, country/region, last update, confirmed deaths, and recovered cases for tracking covid-19 cases.', 'duration': 26.49, 'max_score': 22568.052, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY22568052.jpg'}, {'end': 22759.47, 'src': 'embed', 'start': 22728.601, 'weight': 1, 'content': [{'end': 22736.023, 'text': 'now, according to our second query, We are supposed to find the total number of recovered cases in different nations.', 'start': 22728.601, 'duration': 7.422}, {'end': 22739.145, 'text': "So now let's create a new sheet for that.", 'start': 22737.183, 'duration': 1.962}, {'end': 22743.508, 'text': "Now. for that we'll be selecting the country or region,", 'start': 22739.765, 'duration': 3.743}, {'end': 22751.453, 'text': "and then we'll be selecting the recovered and hover over to the show me icon and let's select the map for that.", 'start': 22743.508, 'duration': 7.945}, {'end': 22759.47, 'text': 'Now you can see that we have a lot of recovery happening in India.', 'start': 22754.548, 'duration': 4.922}], 'summary': 'Finding total recovered cases in nations, india has a significant number.', 'duration': 30.869, 'max_score': 22728.601, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY22728601.jpg'}, {'end': 23068.657, 'src': 'embed', 'start': 23034.909, 'weight': 3, 'content': [{'end': 23039.273, 'text': 'So we can see that Maharashtra has a larger number of confirmed cases.', 'start': 23034.909, 'duration': 4.364}, {'end': 23041.555, 'text': "It's the biggest state of India.", 'start': 23039.973, 'duration': 1.582}, {'end': 23043.836, 'text': "So maybe, yeah, that's true.", 'start': 23042.215, 'duration': 1.621}, {'end': 23048.38, 'text': "And now we'll get back to the duplicate sheet of recovery cases in India.", 'start': 23044.157, 'duration': 4.223}, {'end': 23053.944, 'text': "And now let's make it look a bit more appealing by changing the way the data looks.", 'start': 23048.4, 'duration': 5.544}, {'end': 23058.348, 'text': 'So for this, we can select the packed bubble option.', 'start': 23054.525, 'duration': 3.823}, {'end': 23068.657, 'text': 'Now we can see the bubbles which show the recovery states happening in the Indian states or the recovery cases.', 'start': 23059.506, 'duration': 9.151}], 'summary': 'Maharashtra has the largest number of confirmed cases in india.', 'duration': 33.748, 'max_score': 23034.909, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY23034909.jpg'}], 'start': 22412.862, 'title': 'Covid-19 data visualization and trend forecasting', 'summary': "Covers using tableau to analyze a covid-19 dataset from kaggle, clean the data, understand the columns, and forecast the trend of covid-19 cases and recovery rates. it also demonstrates visualizing and analyzing covid-19 data, including creating maps for confirmed and recovered cases, analyzing india's cases and recoveries, and forecasting a trend line of covid-19 cases.", 'chapters': [{'end': 22605.232, 'start': 22412.862, 'title': 'Covid-19 trend forecasting using tableau', 'summary': 'Discusses using tableau to analyze a covid-19 dataset from kaggle, cleaning the data, and understanding the columns to forecast the trend of covid-19 cases and recovery rates.', 'duration': 192.37, 'highlights': ['Using Tableau to forecast COVID-19 trend levels The chapter discusses creating a trend line in Tableau to forecast the levels of COVID-19, determining if it will increase or decrease in the near future.', 'Data set cleanup and interpretation with Tableau The process of using Tableau to clean and interpret the COVID-19 dataset, identifying and resolving errors, and understanding the changes made to the data set.', 'Understanding the columns in the COVID-19 data set An explanation of the columns in the COVID-19 data set, including information about confirmed cases, deaths, recovery rates, observation dates, and regions.']}, {'end': 23301.07, 'start': 22606.852, 'title': 'Visualizing covid-19 data', 'summary': "Demonstrates how to visualize and analyze covid-19 data using tableau, including creating maps for confirmed and recovered cases, analyzing india's cases and recoveries, and forecasting a trend line of covid-19 cases.", 'duration': 694.218, 'highlights': ["Creating map charts to visualize confirmed and recovered cases at the international level, highlighting India's higher recovery rate compared to other nations. Visualization of confirmed and recovered cases at the international level using map charts. India's higher recovery rate compared to other nations.", "Analyzing and visualizing the total confirmed and recovered cases in India using text tables, pie charts, and packed bubble charts, highlighting Maharashtra's high number of confirmed cases and recoveries. Analysis and visualization of total confirmed and recovered cases in India using various chart types. Highlighting Maharashtra's high number of confirmed cases and recoveries.", 'Forecasting a trend line of COVID-19 cases using Tableau, including creating a trend line and interpreting the formula for the trend line. Forecasting a trend line of COVID-19 cases using Tableau. Interpretation of the formula for the trend line.']}], 'duration': 888.208, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY22412862.jpg', 'highlights': ['Using Tableau to forecast COVID-19 trend levels', "Creating map charts to visualize confirmed and recovered cases at the international level, highlighting India's higher recovery rate compared to other nations", 'Data set cleanup and interpretation with Tableau', "Analyzing and visualizing the total confirmed and recovered cases in India using text tables, pie charts, and packed bubble charts, highlighting Maharashtra's high number of confirmed cases and recoveries", 'Understanding the columns in the COVID-19 data set', 'Forecasting a trend line of COVID-19 cases using Tableau, including creating a trend line and interpreting the formula for the trend line']}, {'end': 26625.158, 'segs': [{'end': 23338.07, 'src': 'embed', 'start': 23302.352, 'weight': 0, 'content': [{'end': 23308.693, 'text': 'So in January, we find one OK, this is in billions, maybe.', 'start': 23302.352, 'duration': 6.341}, {'end': 23310.455, 'text': 'Yeah, maybe even trillions.', 'start': 23309.014, 'duration': 1.441}, {'end': 23320.142, 'text': 'Who knows? But but based on the data we have in the last year, we have a decrement of the confirmed cases in January.', 'start': 23310.815, 'duration': 9.327}, {'end': 23326.687, 'text': "So it's basically indicating that Corona is basically or slowly decreasing.", 'start': 23320.202, 'duration': 6.485}, {'end': 23327.688, 'text': "That's a good sign.", 'start': 23326.907, 'duration': 0.781}, {'end': 23334.633, 'text': "Now, now let's try to find out the trend line for India.", 'start': 23330.35, 'duration': 4.283}, {'end': 23338.07, 'text': "Let's duplicate this.", 'start': 23336.849, 'duration': 1.221}], 'summary': 'Confirmed cases of corona decreased in january, indicating a positive trend.', 'duration': 35.718, 'max_score': 23302.352, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY23302352.jpg'}, {'end': 23794.187, 'src': 'embed', 'start': 23761.385, 'weight': 2, 'content': [{'end': 23762.466, 'text': "Let's keep it as it is.", 'start': 23761.385, 'duration': 1.081}, {'end': 23767.169, 'text': "Now let's quickly get back to our presentation and check out our next query.", 'start': 23763.086, 'duration': 4.083}, {'end': 23770.911, 'text': 'So find the highest death rates at international level.', 'start': 23767.649, 'duration': 3.262}, {'end': 23780.917, 'text': 'So we are basically going to find which nation or the country has the highest death rates and which is the country with the least amount of death rates,', 'start': 23771.231, 'duration': 9.686}, {'end': 23782.278, 'text': 'so which is the safest country.', 'start': 23780.917, 'duration': 1.361}, {'end': 23785.141, 'text': "Now let's get back to Tableau.", 'start': 23782.959, 'duration': 2.182}, {'end': 23787.943, 'text': "Now we're not going to mess with this particular sheet.", 'start': 23785.661, 'duration': 2.282}, {'end': 23789.344, 'text': "Let's create a new sheet.", 'start': 23788.063, 'duration': 1.281}, {'end': 23794.187, 'text': "Let's rename the sheet as highest death rates.", 'start': 23790.344, 'duration': 3.843}], 'summary': 'Analyzing international death rates to identify safest and most dangerous countries.', 'duration': 32.802, 'max_score': 23761.385, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY23761385.jpg'}, {'end': 24220.095, 'src': 'embed', 'start': 24189.897, 'weight': 3, 'content': [{'end': 24195.701, 'text': "Yeah, that's how we can find the variation of presence of COVID-19 in a particular country.", 'start': 24189.897, 'duration': 5.804}, {'end': 24199.829, 'text': "So with that, let's move into the next query.", 'start': 24196.508, 'duration': 3.321}, {'end': 24207.351, 'text': 'So the next query is, can we forecast the sheet of future and reference of COVID-19 presence? Yes, we can do that.', 'start': 24199.929, 'duration': 7.422}, {'end': 24209.092, 'text': "Let's get back to Tableau.", 'start': 24207.411, 'duration': 1.681}, {'end': 24220.095, 'text': "For that, let's create a new sheet and rename it as forecast of COVID-19 presence.", 'start': 24210.212, 'duration': 9.883}], 'summary': 'Analyzing covid-19 presence and forecasting using tableau.', 'duration': 30.198, 'max_score': 24189.897, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY24189897.jpg'}, {'end': 24334.909, 'src': 'embed', 'start': 24263.373, 'weight': 1, 'content': [{'end': 24267.696, 'text': "Now let's select this to day.", 'start': 24263.373, 'duration': 4.323}, {'end': 24273.36, 'text': 'We can change that to year.', 'start': 24269.838, 'duration': 3.522}, {'end': 24279.625, 'text': "Now let's select forecast option.", 'start': 24277.343, 'duration': 2.282}, {'end': 24282.727, 'text': "Yeah, so this is how it's going to be.", 'start': 24279.865, 'duration': 2.862}, {'end': 24289.246, 'text': 'So in the year of 2020, we had the confirmed cases around this number, which is 7637053464, so which is nearly 76, 370 lakh.', 'start': 24284.105, 'duration': 5.141}, {'end': 24292.747, 'text': 'And in the 2021, the number got a little decreased.', 'start': 24289.266, 'duration': 3.481}, {'end': 24308.171, 'text': 'which is 17, 130 lakh cases.', 'start': 24304.807, 'duration': 3.364}, {'end': 24314.177, 'text': 'And in the end of 2022, which is the forecast, we can see there is a little more drop.', 'start': 24308.691, 'duration': 5.486}, {'end': 24317.741, 'text': "So it's a good sign that the COVID-19 is getting decreased.", 'start': 24314.357, 'duration': 3.384}, {'end': 24321.024, 'text': 'So this is the forecast of the COVID-19 presence in India.', 'start': 24317.901, 'duration': 3.123}, {'end': 24323.227, 'text': 'So we can change the path.', 'start': 24321.725, 'duration': 1.502}, {'end': 24328.163, 'text': 'to step one.', 'start': 24325.421, 'duration': 2.742}, {'end': 24328.964, 'text': 'the line is okay.', 'start': 24328.163, 'duration': 0.801}, {'end': 24330.045, 'text': 'the line is pretty good.', 'start': 24328.964, 'duration': 1.081}, {'end': 24331.466, 'text': 'no worries on that.', 'start': 24330.045, 'duration': 1.421}, {'end': 24334.909, 'text': "so basically, we've finished all the queries on our presentation mode.", 'start': 24331.466, 'duration': 3.443}], 'summary': 'In 2020, there were 76,370 lakh confirmed covid-19 cases in india, which decreased to 17,130 lakh in 2021, and a further drop is forecasted for 2022.', 'duration': 71.536, 'max_score': 24263.373, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY24263373.jpg'}, {'end': 24570.287, 'src': 'embed', 'start': 24534.078, 'weight': 5, 'content': [{'end': 24535.919, 'text': 'We have the top 10 ones only here.', 'start': 24534.078, 'duration': 1.841}, {'end': 24537.36, 'text': 'Yeah, this is good.', 'start': 24536.66, 'duration': 0.7}, {'end': 24540.001, 'text': 'So this is how we can have the dashboard.', 'start': 24538.08, 'duration': 1.921}, {'end': 24543.583, 'text': "And now let's create another dashboard for Indian results.", 'start': 24540.442, 'duration': 3.141}, {'end': 24550.867, 'text': "So again, let's change the dimensions of the screen.", 'start': 24544.384, 'duration': 6.483}, {'end': 24554.463, 'text': "It's pretty good.", 'start': 24553.923, 'duration': 0.54}, {'end': 24562.906, 'text': "Now let's take the confirmed cases in India and drop it over here.", 'start': 24555.043, 'duration': 7.863}, {'end': 24566.647, 'text': 'And recovery cases in India and drop it over there.', 'start': 24563.386, 'duration': 3.261}, {'end': 24570.287, 'text': 'And trend lines in India over here.', 'start': 24566.667, 'duration': 3.62}], 'summary': 'Creating dashboards for indian covid-19 data with top 10 results.', 'duration': 36.209, 'max_score': 24534.078, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY24534078.jpg'}, {'end': 25336.045, 'src': 'embed', 'start': 25307.803, 'weight': 6, 'content': [{'end': 25313.924, 'text': "So, the 4th query reads, what are the top 10 busiest flight routes? For that, let's get back to Tableau again.", 'start': 25307.803, 'duration': 6.121}, {'end': 25320.966, 'text': "Let's rename the newly created sheet, busiest routes.", 'start': 25313.944, 'duration': 7.022}, {'end': 25328.164, 'text': 'Now the sheet has been replaced or renamed.', 'start': 25325.223, 'duration': 2.941}, {'end': 25336.045, 'text': 'Now to find out the top busiest routes, we need a calculated field to remove the effects of San Francisco airport first.', 'start': 25328.784, 'duration': 7.261}], 'summary': 'Using tableau, the 4th query aims to identify the top 10 busiest flight routes, involving calculation to exclude san francisco airport.', 'duration': 28.242, 'max_score': 25307.803, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY25307803.jpg'}, {'end': 25820.9, 'src': 'embed', 'start': 25782.466, 'weight': 7, 'content': [{'end': 25789.048, 'text': 'okay, now we have the newly created flight line over here.', 'start': 25782.466, 'duration': 6.582}, {'end': 25794.09, 'text': "now we'll drag that flight line to detail.", 'start': 25789.048, 'duration': 5.042}, {'end': 25798.771, 'text': 'now, once we drag that Flight line to the detail.', 'start': 25794.09, 'duration': 4.681}, {'end': 25803.155, 'text': 'We have the lines or flights taking off from SFO to different parts of the world.', 'start': 25798.791, 'duration': 4.364}, {'end': 25815.506, 'text': 'Now we can make it look a bit more appealing or more informative by dragging the routes or yeah.', 'start': 25803.716, 'duration': 11.79}, {'end': 25820.9, 'text': 'into detail.', 'start': 25819.019, 'duration': 1.881}], 'summary': 'New flight line created from sfo to different parts of the world.', 'duration': 38.434, 'max_score': 25782.466, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY25782466.jpg'}, {'end': 25947.216, 'src': 'embed', 'start': 25916.851, 'weight': 8, 'content': [{'end': 25920.854, 'text': 'we have the flights taking off in the month of march.', 'start': 25916.851, 'duration': 4.003}, {'end': 25924.976, 'text': 'the busiest month was the march and the busiest day was 6th of march.', 'start': 25920.854, 'duration': 4.122}, {'end': 25927.598, 'text': "i don't know what was so special on that day.", 'start': 25924.976, 'duration': 2.622}, {'end': 25930.26, 'text': 'if you know it, please let me know in the comment section below.', 'start': 25927.598, 'duration': 2.662}, {'end': 25933.221, 'text': 'and yeah, so totally.', 'start': 25930.26, 'duration': 2.961}, {'end': 25934.542, 'text': 'we created a dashboard.', 'start': 25933.221, 'duration': 1.321}, {'end': 25942.213, 'text': "now let's rename the dashboard as SFO flight data dashboard.", 'start': 25934.542, 'duration': 7.671}, {'end': 25947.216, 'text': 'And we are done.', 'start': 25946.616, 'duration': 0.6}], 'summary': 'March was the busiest month for flights, with the 6th being the busiest day. a dashboard for sfo flight data was created.', 'duration': 30.365, 'max_score': 25916.851, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY25916851.jpg'}, {'end': 26010.078, 'src': 'embed', 'start': 25969.195, 'weight': 9, 'content': [{'end': 25973.637, 'text': 'So we are going to find out what are the average temperature details of the launch sites.', 'start': 25969.195, 'duration': 4.442}, {'end': 25976.478, 'text': 'what are the average wind speed details of the launch sites.', 'start': 25973.637, 'duration': 2.841}, {'end': 25978.919, 'text': 'what are the average humidity details of the launch sites.', 'start': 25976.478, 'duration': 2.441}, {'end': 25983.92, 'text': 'So, we need all these to, you know, before launching a satellite or a rocket into space.', 'start': 25979.319, 'duration': 4.601}, {'end': 25986.241, 'text': 'Everything needs to be in ideal condition.', 'start': 25984.18, 'duration': 2.061}, {'end': 25992.165, 'text': 'So followed by that we have what are the different varieties of launch vehicles used by different companies.', 'start': 25986.881, 'duration': 5.284}, {'end': 25994.186, 'text': 'So there are a lot many companies.', 'start': 25992.185, 'duration': 2.001}, {'end': 25997.508, 'text': 'We are from government sector, we are from private sector.', 'start': 25994.346, 'duration': 3.162}, {'end': 26006.635, 'text': 'For example USA military satellites belong to government and private satellites like SpaceX and few others.', 'start': 25997.568, 'duration': 9.067}, {'end': 26010.078, 'text': 'Next we have what is the mission status of the company.', 'start': 26007.415, 'duration': 2.663}], 'summary': 'Analyzing average temperature, wind speed, and humidity of launch sites before rocket launch; discussing various launch vehicles used by government and private sectors; and reviewing mission status of the company.', 'duration': 40.883, 'max_score': 25969.195, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY25969195.jpg'}, {'end': 26460.997, 'src': 'embed', 'start': 26406.473, 'weight': 11, 'content': [{'end': 26414.695, 'text': 'side by side bar chart and now we can drag the company to color so that we can have different colors for different companies.', 'start': 26406.473, 'duration': 8.222}, {'end': 26417.356, 'text': 'so we have the mission details.', 'start': 26414.695, 'duration': 2.661}, {'end': 26423.577, 'text': 'so SpaceX found a maximum success in the recent days and little failures.', 'start': 26417.356, 'duration': 6.221}, {'end': 26428.799, 'text': 'and Yeah, Boeing found good success as well and some failures.', 'start': 26423.577, 'duration': 5.222}, {'end': 26433.822, 'text': 'So, these are the mission status of different companies and different satellites as well.', 'start': 26429.32, 'duration': 4.502}, {'end': 26439.905, 'text': 'So, we have even US Air Force here faced some satellites here, some failures in some satellites.', 'start': 26434.483, 'duration': 5.422}, {'end': 26440.546, 'text': "It's okay.", 'start': 26439.946, 'duration': 0.6}, {'end': 26444.108, 'text': "So, now let's get back to presentation mode.", 'start': 26441.847, 'duration': 2.261}, {'end': 26449.751, 'text': 'Now, the sixth query is track records of launch sites.', 'start': 26446.209, 'duration': 3.542}, {'end': 26457.013, 'text': 'Okay, we had the payload as sum, so we change it to count, distinct count.', 'start': 26451.627, 'duration': 5.386}, {'end': 26460.997, 'text': 'So now we have a better observation of failures and successes over here.', 'start': 26457.674, 'duration': 3.323}], 'summary': 'Spacex had a high success rate, boeing had mixed success, and us air force faced some satellite failures.', 'duration': 54.524, 'max_score': 26406.473, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY26406473.jpg'}], 'start': 23302.352, 'title': 'Covid-19 and space missions analysis', 'summary': 'Discusses the decreasing trend of confirmed covid-19 cases in india, using tableau for analysis, and covers covid-19 forecast, data visualization, creation of dashboards, and analysis of space missions dataset, including the average temperature, wind speed, and humidity of launch sites, and track records of launch sites.', 'chapters': [{'end': 23761.325, 'start': 23302.352, 'title': 'Covid-19 trends in india', 'summary': 'Discusses the decreasing trend of confirmed covid-19 cases in india, with a significant drop from over 30 crores to nearly 20 crores in the previous year, and the process of grouping indian states in tableau for analysis.', 'duration': 458.973, 'highlights': ['The confirmed cases of COVID-19 in India have decreased from over 30 crores to nearly 20 crores in the previous year, indicating a significant drop. The number of confirmed COVID-19 cases in India has decreased from over 30 crores to nearly 20 crores in the previous year, indicating a significant drop.', "The chapter explains the process of grouping Indian states in Tableau for analysis, demonstrating the selection of specific states and the creation of a new group named 'Indian States Group'. The chapter explains the process of grouping Indian states in Tableau for analysis, demonstrating the selection of specific states and the creation of a new group named 'Indian States Group'.", "The trend line for India shows a gradual drop of COVID-19 cases, indicating a positive sign for the country's situation. The trend line for India shows a gradual drop of COVID-19 cases, indicating a positive sign for the country's situation."]}, {'end': 24261.852, 'start': 23761.385, 'title': 'Analyzing covid-19 data with tableau', 'summary': 'Discusses using tableau to analyze covid-19 data, including finding the highest and least death rates at the international level, identifying variation in covid-19 cases around the world, and forecasting future covid-19 presence.', 'duration': 500.467, 'highlights': ['The chapter discusses using Tableau to analyze COVID-19 data and finding the highest and least death rates at the international level. It covers finding the highest and least death rates at the international level and using Tableau to visualize and sort the data.', 'The chapter demonstrates using Tableau to identify variation in COVID-19 cases around the world, highlighting France as having the maximum variation despite fewer confirmed cases compared to the US. It shows using Tableau to create box and whisker plots to identify the variation in COVID-19 cases around the world, with France having the maximum variation despite fewer confirmed cases compared to the US.', 'The chapter also explores forecasting future COVID-19 presence using Tableau. It discusses using Tableau to forecast future COVID-19 presence by creating a new sheet and using observation date and confirmed cases to analyze and visualize the data.']}, {'end': 25482.4, 'start': 24263.373, 'title': 'Covid-19 forecast and tableau data visualization', 'summary': 'Discusses the covid-19 forecast in india, with confirmed cases reaching 76,370 lakh in 2020 and dropping to 17,130 lakh in 2021. it also covers the creation of dashboards in tableau for international and indian covid-19 data, as well as the initiation of a new project on airline datasets, outlining the queries and steps taken for data visualization in tableau.', 'duration': 1219.027, 'highlights': ['The chapter discusses the COVID-19 forecast in India, with confirmed cases reaching 76,370 lakh in 2020 and dropping to 17,130 lakh in 2021. The chapter provides specific numbers for confirmed COVID-19 cases in India, stating that in 2020, there were 76,370 lakh cases, and in 2021, the number dropped to 17,130 lakh cases.', 'The creation of dashboards in Tableau for international and Indian COVID-19 data is outlined. The chapter details the process of creating dashboards for both international and Indian COVID-19 data using Tableau, including steps such as changing dimensions, adding data visualizations, and modifying layout dimensions.', 'The initiation of a new project on airline datasets, outlining the queries and steps taken for data visualization in Tableau, is highlighted. The chapter highlights the transition to a new project focused on airline datasets in Tableau, outlining specific queries such as total number of flights, busiest day at San Francisco airport, and top 10 busiest flight routes, as well as the steps taken for data visualization in Tableau.']}, {'end': 25947.216, 'start': 25483.6, 'title': 'Creating calculated fields and dashboard in tableau', 'summary': 'Covers creating calculated fields for origin, destination, and distance using makepoint and distance functions, sorting and filtering data, visualizing flight routes and distances on a map, and creating a dashboard with insights on busiest and longest routes.', 'duration': 463.616, 'highlights': ['Created calculated fields for origin, destination, and distance using makepoint and distance functions. The speaker demonstrated creating calculated fields for origin and destination using makepoint function and then calculating the distance using the distance function.', "Visualized flight routes and distances on a map using calculated field 'flights line' and details of routes and distances. The process of visualizing flight routes from SFO on a map using calculated field 'flights line' and incorporating details of routes and distances for a more informative display.", "Created a dashboard named 'SFO flight data dashboard' with insights on busiest and longest routes. The creation of a dashboard named 'SFO flight data dashboard' to provide insights on the busiest and longest routes, along with details on flights taking off and the busiest month and day."]}, {'end': 26625.158, 'start': 25947.456, 'title': 'Space missions analysis', 'summary': 'Details the analysis of a space missions dataset, including the average temperature, wind speed, and humidity of launch sites, the varieties of launch vehicles used by different companies, the mission status of companies, and the track records of launch sites.', 'duration': 677.702, 'highlights': ['The analysis includes the average temperature, wind speed, and humidity of launch sites, essential for ensuring ideal conditions before launching satellites or rockets into space. Insights into the average temperature, wind speed, and humidity of launch sites.', 'The analysis provides information on the different varieties of launch vehicles used by different companies, including government and private sectors such as USA military satellites and private satellites like SpaceX. Identification of the launch vehicles used by different companies.', 'The mission status of companies and satellites is analyzed, indicating the success and failure rates of different companies such as SpaceX, Boeing, and US Air Force. Analysis of the mission status, including success and failure rates of different companies.', 'The track records of launch sites are detailed, providing insights into the success and failure rates of different space centers and launch sites. Insights into the success and failure rates of different space centers and launch sites.']}], 'duration': 3322.806, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY23302352.jpg', 'highlights': ['The confirmed cases of COVID-19 in India have decreased from over 30 crores to nearly 20 crores in the previous year, indicating a significant drop.', "The trend line for India shows a gradual drop of COVID-19 cases, indicating a positive sign for the country's situation.", 'The chapter discusses using Tableau to analyze COVID-19 data and finding the highest and least death rates at the international level.', 'The chapter also explores forecasting future COVID-19 presence using Tableau.', 'The chapter provides specific numbers for confirmed COVID-19 cases in India, stating that in 2020, there were 76,370 lakh cases, and in 2021, the number dropped to 17,130 lakh cases.', 'The chapter details the process of creating dashboards for both international and Indian COVID-19 data using Tableau, including steps such as changing dimensions, adding data visualizations, and modifying layout dimensions.', 'The initiation of a new project on airline datasets in Tableau, outlining specific queries such as total number of flights, busiest day at San Francisco airport, and top 10 busiest flight routes, as well as the steps taken for data visualization.', "The process of visualizing flight routes from SFO on a map using calculated field 'flights line' and incorporating details of routes and distances for a more informative display.", "The creation of a dashboard named 'SFO flight data dashboard' to provide insights on the busiest and longest routes, along with details on flights taking off and the busiest month and day.", 'Insights into the average temperature, wind speed, and humidity of launch sites.', 'Identification of the launch vehicles used by different companies.', 'Analysis of the mission status, including success and failure rates of different companies.', 'Insights into the success and failure rates of different space centers and launch sites.']}, {'end': 27935.57, 'segs': [{'end': 26738.571, 'src': 'embed', 'start': 26690.847, 'weight': 1, 'content': [{'end': 26695.951, 'text': 'So dimensions are qualitative and you can use them to categorize your data.', 'start': 26690.847, 'duration': 5.104}, {'end': 26700.234, 'text': 'So for example, you can categorize your data by what country it comes from.', 'start': 26696.291, 'duration': 3.943}, {'end': 26704.356, 'text': 'and measures are quantitative and can be aggregated.', 'start': 26700.854, 'duration': 3.502}, {'end': 26710.16, 'text': 'So you can do a sum of sales, or you can do the average profit.', 'start': 26704.717, 'duration': 5.443}, {'end': 26721.107, 'text': 'Did you know that Tableau automatically assigns each field a data type and a role, and that it automatically aggregates your measures using sum?', 'start': 26710.5, 'duration': 10.607}, {'end': 26724.449, 'text': 'But you can change what the default aggregation is.', 'start': 26721.427, 'duration': 3.022}, {'end': 26726.009, 'text': 'Question 3.', 'start': 26724.989, 'duration': 1.02}, {'end': 26733.871, 'text': 'What do you understand by discrete and continuous in Tableau? So we have discrete values and continuous values.', 'start': 26726.009, 'duration': 7.862}, {'end': 26738.571, 'text': 'Discrete is represented as blue and continuous is represented as green.', 'start': 26734.131, 'duration': 4.44}], 'summary': 'Dimensions categorize qualitative data, measures aggregate quantitative data. tableau auto-aggregates measures using sum, and allows for changing default aggregation. discrete values are represented as blue, continuous as green.', 'duration': 47.724, 'max_score': 26690.847, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY26690847.jpg'}, {'end': 27056.927, 'src': 'embed', 'start': 27028.601, 'weight': 0, 'content': [{'end': 27037.177, 'text': 'we wanted to know the percent of total profits associated with the corporate segment, And the corporate segment has 32.12% of the total profits.', 'start': 27028.601, 'duration': 8.576}, {'end': 27041.839, 'text': "And here's our solution with 32.12%.", 'start': 27037.877, 'duration': 3.962}, {'end': 27044.281, 'text': 'So did you get it right? Comment below if you got that.', 'start': 27041.839, 'duration': 2.442}, {'end': 27048.063, 'text': 'What are the different joins in Tableau? Give an example.', 'start': 27044.821, 'duration': 3.242}, {'end': 27052.245, 'text': 'So in Tableau, you can join your data.', 'start': 27048.643, 'duration': 3.602}, {'end': 27056.927, 'text': 'So if we wanted to look at orders and tie it to people,', 'start': 27052.525, 'duration': 4.402}], 'summary': 'Corporate segment accounts for 32.12% of total profits.', 'duration': 28.326, 'max_score': 27028.601, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY27028601.jpg'}, {'end': 27167.53, 'src': 'embed', 'start': 27140.703, 'weight': 4, 'content': [{'end': 27146.248, 'text': "it's a really helpful way for you to explain your point and it really portrays that you know what you're talking about.", 'start': 27140.703, 'duration': 5.545}, {'end': 27150.633, 'text': 'What is the difference between a join and blending in Tableau?', 'start': 27146.569, 'duration': 4.064}, {'end': 27159.862, 'text': 'So I just showed you how to make a join here and we are joining an Excel sheet to another Excel sheet,', 'start': 27151.073, 'duration': 8.789}, {'end': 27163.225, 'text': 'all within the same connection to that Excel file.', 'start': 27159.862, 'duration': 3.363}, {'end': 27167.53, 'text': "So when you're joining data, we'll look over here at the joining side.", 'start': 27163.686, 'duration': 3.844}], 'summary': 'Joining in tableau allows combining data from different sources, like joining two excel sheets within the same connection.', 'duration': 26.827, 'max_score': 27140.703, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY27140703.jpg'}, {'end': 27316.564, 'src': 'embed', 'start': 27288.112, 'weight': 3, 'content': [{'end': 27294.515, 'text': 'And so a live connection will query that database every time you open up the dashboard or visualization,', 'start': 27288.112, 'duration': 6.403}, {'end': 27297.096, 'text': "so that you're getting the most recent information each time.", 'start': 27294.515, 'duration': 2.581}, {'end': 27301.658, 'text': "And it's useful for if you need information that's a little bit more real time.", 'start': 27297.496, 'duration': 4.162}, {'end': 27305.36, 'text': 'However, it can be slower, especially if your queries are complicated.', 'start': 27301.758, 'duration': 3.602}, {'end': 27307.481, 'text': 'With an extract.', 'start': 27305.8, 'duration': 1.681}, {'end': 27316.564, 'text': "it will run the query beforehand and store the information on Tableau Server or on your local machine and so that it's faster to get to.", 'start': 27307.481, 'duration': 9.083}], 'summary': 'Live connection gives real-time data but slower. extract stores data for faster access.', 'duration': 28.452, 'max_score': 27288.112, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY27288112.jpg'}, {'end': 27510.777, 'src': 'embed', 'start': 27483.016, 'weight': 5, 'content': [{'end': 27485.579, 'text': 'but we can bring on our average shipping delay.', 'start': 27483.016, 'duration': 2.563}, {'end': 27493.707, 'text': 'And you can see on average how many days it took.', 'start': 27491.285, 'duration': 2.422}, {'end': 27501.114, 'text': "And let's change our number here to include decimal places.", 'start': 27496.089, 'duration': 5.025}, {'end': 27505.273, 'text': 'So a calculated field is a new field made from existing data.', 'start': 27502.051, 'duration': 3.222}, {'end': 27510.777, 'text': 'It can be used to create more robust visualizations, and it does not affect the original data set.', 'start': 27505.954, 'duration': 4.823}], 'summary': 'Reducing average shipping delay by calculating new field with decimal places for more robust visualizations.', 'duration': 27.761, 'max_score': 27483.016, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY27483016.jpg'}], 'start': 26625.158, 'title': 'Tableau interview questions, data analysis, blending, and visualization', 'summary': "Covers common tableau interview questions, such as data types, dimensions, and measures, and provides insights into tableau data analysis, including the corporate segment's 32.12% total profits. it also explores data blending, live vs. extract connections, calculated fields, sets, and parameters in tableau.", 'chapters': [{'end': 26993.139, 'start': 26625.158, 'title': 'Tableau interview questions', 'summary': 'Provides answers to common tableau interview questions, covering data types, dimensions and measures, discrete and continuous values, filters, and building a visualization with the superstore dataset.', 'duration': 367.981, 'highlights': ['Tableau automatically assigns each field a data type and a role, and it automatically aggregates your measures using sum Tableau automatically assigns data types and roles to fields, and aggregates measures using sum by default.', 'Dimensions are qualitative and can be used to categorize data, while measures are quantitative and can be aggregated Dimensions are qualitative and used for data categorization, while measures are quantitative and aggregatable.', 'Discrete values are represented as blue and continuous values are represented as green in Tableau In Tableau, discrete values are shown as blue, and continuous values are shown as green.', 'Filters in Tableau include extract filters, data source filters, context filters, dimensions filters, measures filters, and table calculation filters Tableau filters encompass extract, data source, context, dimensions, measures, and table calculation filters, each with a specific order of application.', 'Building a visualization with the Superstore dataset, which includes three customer segments The chapter demonstrates building a visualization with the Superstore dataset, involving three customer segments.']}, {'end': 27243.579, 'start': 26993.219, 'title': 'Tableau data analysis', 'summary': 'Discusses the percentage of total profits associated with the corporate segment in tableau, revealing that the corporate segment has 32.12% of the total profits. it also explains different types of joins and the difference between joining and blending in tableau.', 'duration': 250.36, 'highlights': ['The corporate segment has 32.12% of the total profits. The chapter reveals that the corporate segment accounts for 32.12% of the total profits, providing a quantifiable data point.', 'Explanation of different types of joins in Tableau - inner join, left join, right join, outer join, and union. The chapter provides a detailed explanation of various types of joins in Tableau, offering a comprehensive understanding of each type.', 'Clarification on the difference between joining and blending in Tableau, with a focus on combining data from different sources. The chapter distinguishes between joining and blending in Tableau and emphasizes the process of combining data from different sources, providing clarity on the distinction between the two methods.']}, {'end': 27935.57, 'start': 27243.979, 'title': 'Tableau data blending and visualization', 'summary': 'Discusses data blending, live vs. extract connections, calculated fields, creating sets, and parameters in tableau, highlighting key differences and providing practical examples.', 'duration': 691.591, 'highlights': ["Tableau's live connection queries the database every time the dashboard is opened, providing real-time information, while an extract runs queries beforehand and stores the information for faster access. Live connection provides real-time data, but can be slower for complex queries. Extract runs queries beforehand for faster access, but does not provide real-time information.", 'A calculated field is an additional field created from existing data, useful for creating more robust visualizations without affecting the original data set. Calculated fields are created using existing data, allowing for the creation of new fields without affecting the original data set.', 'Sets can be used to show both the top and bottom elements in the same visualization, and sets can be more complex than groups, allowing for the use of conditions and multiple dimensions or measures. Sets can display top and bottom elements in the same visualization, while being more complex than groups and allowing the use of conditions and multiple dimensions or measures.', 'Parameters are dynamic values that users can select, and they can be used to replace constant values in calculations, filters, and reference lines. Parameters are dynamic and can replace constant values in calculations, filters, and reference lines.']}], 'duration': 1310.412, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY26625158.jpg', 'highlights': ['The corporate segment has 32.12% of the total profits.', 'Tableau automatically assigns each field a data type and a role, and it automatically aggregates your measures using sum.', 'Dimensions are qualitative and can be used to categorize data, while measures are quantitative and can be aggregated.', "Tableau's live connection queries the database every time the dashboard is opened, providing real-time information, while an extract runs queries beforehand and stores the information for faster access.", 'Explanation of different types of joins in Tableau - inner join, left join, right join, outer join, and union.', 'A calculated field is an additional field created from existing data, useful for creating more robust visualizations without affecting the original data set.']}, {'end': 28721.862, 'segs': [{'end': 27989.644, 'src': 'embed', 'start': 27964.806, 'weight': 0, 'content': [{'end': 27970.291, 'text': 'So it replaces a constant value and allows the end user to select the value.', 'start': 27964.806, 'duration': 5.485}, {'end': 27977.937, 'text': "Question 13, what is the difference between tree maps and heat maps? So let's first talk about what each of these are.", 'start': 27970.811, 'duration': 7.126}, {'end': 27981.901, 'text': 'Heat maps compare categories using size and color.', 'start': 27977.957, 'duration': 3.944}, {'end': 27985.062, 'text': 'I think the biggest thing about heat maps is the color.', 'start': 27982.461, 'duration': 2.601}, {'end': 27989.644, 'text': "Size is somewhat optional, so let's build this visualization quickly.", 'start': 27985.202, 'duration': 4.442}], 'summary': 'Heat maps compare categories using size and color for quick visualization.', 'duration': 24.838, 'max_score': 27964.806, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY27964806.jpg'}, {'end': 28106.116, 'src': 'embed', 'start': 28077.179, 'weight': 1, 'content': [{'end': 28078.7, 'text': 'So that is a heat map.', 'start': 28077.179, 'duration': 1.521}, {'end': 28082.664, 'text': 'A tree map is used to represent hierarchical data.', 'start': 28079.181, 'duration': 3.483}, {'end': 28088.85, 'text': "Now hierarchy is the term you need to remember when you're talking about the difference between the tree map and a heat map.", 'start': 28082.744, 'duration': 6.106}, {'end': 28094.889, 'text': 'In the heat map, none of these boxes have to do with the hierarchy with each other.', 'start': 28089.685, 'duration': 5.204}, {'end': 28101.833, 'text': 'Whereas with the tree map, you can see that this box has a thick white line between it and the other ones.', 'start': 28095.209, 'duration': 6.624}, {'end': 28106.116, 'text': 'And that means that that section are all connected.', 'start': 28102.314, 'duration': 3.802}], 'summary': 'Heat map vs tree map: heat map displays non-hierarchical data, while tree map represents hierarchical data with connected boxes.', 'duration': 28.937, 'max_score': 28077.179, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY28077179.jpg'}, {'end': 28277.731, 'src': 'embed', 'start': 28248.127, 'weight': 2, 'content': [{'end': 28249.368, 'text': "because it's all right inside.", 'start': 28248.127, 'duration': 1.241}, {'end': 28255.953, 'text': "Whereas with the TWB, It has to connect to the data source or else it doesn't have the data to build the visualizations.", 'start': 28249.528, 'duration': 6.425}, {'end': 28259.996, 'text': 'It just knows it has the instructions of what to do with that data.', 'start': 28256.093, 'duration': 3.903}, {'end': 28267.062, 'text': 'So the biggest difference is TWBX has the data inside of it, whereas a TWB only has the instructions.', 'start': 28260.117, 'duration': 6.945}, {'end': 28268.484, 'text': 'Question 15.', 'start': 28267.383, 'duration': 1.101}, {'end': 28273.948, 'text': 'Explain the difference between Tableau Worksheet, Dashboard, Story, and Workbook.', 'start': 28268.484, 'duration': 5.464}, {'end': 28277.731, 'text': "Perfect Here's a breakdown and explanation of each of those.", 'start': 28274.208, 'duration': 3.523}], 'summary': 'Twbx contains data, twb has instructions only. tableau has worksheet, dashboard, story, and workbook.', 'duration': 29.604, 'max_score': 28248.127, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY28248127.jpg'}, {'end': 28320.915, 'src': 'embed', 'start': 28292.841, 'weight': 3, 'content': [{'end': 28301.507, 'text': 'The big difference between a worksheet and a dashboard is that the worksheet is just one visualization,', 'start': 28292.841, 'duration': 8.666}, {'end': 28304.769, 'text': 'and so it is only one set of columns and rows here.', 'start': 28301.507, 'duration': 3.262}, {'end': 28308.33, 'text': 'And a dashboard could contain multiple visualizations.', 'start': 28305.309, 'duration': 3.021}, {'end': 28314.473, 'text': 'So if we wanted to see our heat map and our tree map on the same page, that would be a dashboard.', 'start': 28308.771, 'duration': 5.702}, {'end': 28320.915, 'text': 'And then a story is somewhat similar to a presentation mode.', 'start': 28314.933, 'duration': 5.982}], 'summary': 'Worksheets have one visualization, dashboards have multiple visualizations, and stories are similar to presentation mode.', 'duration': 28.074, 'max_score': 28292.841, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY28292841.jpg'}, {'end': 28589.07, 'src': 'embed', 'start': 28566.758, 'weight': 4, 'content': [{'end': 28578.081, 'text': 'the difference between a blended axis and a dual axis chart is one that the blended axis uses the same scale and the dual axis could have two different scales.', 'start': 28566.758, 'duration': 11.323}, {'end': 28581.622, 'text': 'And two, a dual axis has two marks cards.', 'start': 28578.661, 'duration': 2.961}, {'end': 28587.567, 'text': "So let's say we wanted our profit to not be a line chart, but to be a bar chart.", 'start': 28582.102, 'duration': 5.465}, {'end': 28589.07, 'text': 'That gives you that option.', 'start': 28587.767, 'duration': 1.303}], 'summary': 'Blended axis uses same scale, dual axis has different scales and two marks cards, providing options like bar chart for profit.', 'duration': 22.312, 'max_score': 28566.758, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY28566758.jpg'}, {'end': 28721.862, 'src': 'embed', 'start': 28697.208, 'weight': 5, 'content': [{'end': 28703.115, 'text': "That's because the syntax for left is that the string must go first.", 'start': 28697.208, 'duration': 5.907}, {'end': 28707.376, 'text': 'First you say left, then you put the string, and then you put the number.', 'start': 28703.635, 'duration': 3.741}, {'end': 28709.177, 'text': "So let's talk about what left does.", 'start': 28707.657, 'duration': 1.52}, {'end': 28716.48, 'text': 'It returns a specific number of characters from the left, and if you had done it correctly, the left is this side.', 'start': 28709.617, 'duration': 6.863}, {'end': 28721.862, 'text': 'So if you had done the string first and you said you want three, the result would be TAB.', 'start': 28716.56, 'duration': 5.302}], 'summary': "The left function returns a specific number of characters from the left side of a string, e.g., 'tab' when applied to a specific string and length.", 'duration': 24.654, 'max_score': 28697.208, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY28697208.jpg'}], 'start': 27936.271, 'title': 'Comparing tree maps and tableau file formats', 'summary': "Discusses the differences between tree maps and heat maps, and tableau file formats including twbx and twb, visualization types such as worksheet, dashboard, story, workbook, blended axis, and dual axis charts, with a clarification on the 'left 3, tableau' error.", 'chapters': [{'end': 28199.7, 'start': 27936.271, 'title': 'Comparing tree maps and heat maps', 'summary': 'Discusses the differences between tree maps and heat maps, highlighting how heat maps use color and size to represent categories, while tree maps are used to represent hierarchical data, and provides examples and visualizations to illustrate the distinctions.', 'duration': 263.429, 'highlights': ['Heat maps compare categories using size and color, allowing users to visualize data through color and optionally size, as demonstrated by the visualization of regions, categories, and subcategories based on profit and sales, providing insights into activity and sales performance.', 'Tree maps are used to represent hierarchical data, with the size and color indicating differences and hierarchies within the data, as shown by the comparison of sales and profit across categories and subcategories, allowing for easy visualization and comparison of hierarchical data structures.', 'The demonstration of the functionality of heat maps and tree maps provides a clear understanding of how they visually represent data, enabling users to make informed decisions based on the insights derived from the visualizations.']}, {'end': 28721.862, 'start': 28199.721, 'title': 'Tableau file formats and visualization types', 'summary': "Explains the differences between twbx and twb tableau file formats, the distinctions among tableau worksheet, dashboard, story, and workbook, the uses of blended axis and dual axis charts, and clarifies the function of 'left 3, tableau' as returning an error due to incorrect syntax.", 'duration': 522.141, 'highlights': ['The biggest difference is that TWBX contains all of the unnecessary information to build the visualization, compresses it all together, and has the data inside of it, whereas a TWB only contains instructions about how to interact with the data source. TWBX contains all unnecessary information to build the visualization and compresses it all together, while TWB only contains instructions about how to interact with the data source.', 'The difference between a worksheet and a dashboard is that a worksheet is a single visualization, while a dashboard could contain multiple visualizations, and a story is somewhat similar to a presentation mode with different pages for sequential viewing. Worksheet is a single visualization, dashboard could contain multiple visualizations, and a story is similar to a presentation mode with different pages for sequential viewing.', 'A blended axis allows the use of two measures that share an axis with the same scale, whereas a dual axis allows comparison of measures with two different scales, and the use of dual axes could be beneficial when showing different scales in the same view. Blended axis allows the use of two measures that share an axis with the same scale, while a dual axis allows comparison of measures with two different scales, beneficial for showing different scales in the same view.', "The function 'Left 3, Tableau' will return an error due to the incorrect syntax as the string must go first followed by the number in the 'left' function. The function 'Left 3, Tableau' will return an error due to the incorrect syntax as the string must go first followed by the number in the 'left' function."]}], 'duration': 785.591, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY27936271.jpg', 'highlights': ['Heat maps compare categories using size and color, allowing users to visualize data through color and optionally size, providing insights into activity and sales performance.', 'Tree maps are used to represent hierarchical data, with the size and color indicating differences and hierarchies within the data, allowing for easy visualization and comparison of hierarchical data structures.', 'TWBX contains all unnecessary information to build the visualization and compresses it all together, while TWB only contains instructions about how to interact with the data source.', 'A dashboard could contain multiple visualizations, and a story is similar to a presentation mode with different pages for sequential viewing.', 'Blended axis allows the use of two measures that share an axis with the same scale, while a dual axis allows comparison of measures with two different scales, beneficial for showing different scales in the same view.', "The function 'Left 3, Tableau' will return an error due to the incorrect syntax as the string must go first followed by the number in the 'left' function."]}, {'end': 30383.64, 'segs': [{'end': 28765.672, 'src': 'embed', 'start': 28741.915, 'weight': 1, 'content': [{'end': 28751.064, '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': 28741.915, 'duration': 9.149}, {'end': 28754.746, 'text': 'So when you click on the indicator you can choose from the following.', 'start': 28751.744, 'duration': 3.002}, {'end': 28763.971, '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': 28755.086, 'duration': 8.885}, {'end': 28765.672, 'text': "So we'll look at both of these.", 'start': 28764.432, 'duration': 1.24}], 'summary': 'The system displays an indicator for null points and allows filtering or showing data.', 'duration': 23.757, 'max_score': 28741.915, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY28741915.jpg'}, {'end': 29053.206, 'src': 'embed', 'start': 29019.43, 'weight': 3, 'content': [{'end': 29021.872, 'text': 'Find the customer with the lowest overall profit.', 'start': 29019.43, 'duration': 2.442}, {'end': 29027.817, 'text': "What is his slash her profit ratio? Let's go ahead and build this visualization.", 'start': 29022.233, 'duration': 5.584}, {'end': 29033.722, 'text': 'Customer profit.', 'start': 29032.861, 'duration': 0.861}, {'end': 29039.976, 'text': "And we're going to bring all of our customers on.", 'start': 29035.692, 'duration': 4.284}, {'end': 29044.299, 'text': "And then we're going to bring on profit.", 'start': 29041.037, 'duration': 3.262}, {'end': 29048.543, 'text': "Let's do it as a visualization.", 'start': 29046.661, 'duration': 1.882}, {'end': 29050.064, 'text': "So I'll bring it on to columns.", 'start': 29048.583, 'duration': 1.481}, {'end': 29053.206, 'text': "And then let's sort smallest to biggest.", 'start': 29050.764, 'duration': 2.442}], 'summary': 'Identify customer with lowest profit and visualize profit ratio.', 'duration': 33.776, 'max_score': 29019.43, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY29019430.jpg'}, {'end': 29176.305, 'src': 'embed', 'start': 29123.161, 'weight': 0, 'content': [{'end': 29130.646, 'text': "So I'm sure you're familiar with what ranking is, which is assigning something, a position like first place or second place,", 'start': 29123.161, 'duration': 7.485}, {'end': 29133.789, 'text': 'usually within a category and usually based on a measure.', 'start': 29130.646, 'duration': 3.143}, {'end': 29144.777, 'text': 'So Tableau is able to rank in several different ways where you can do rank or rank dense, rank modified, or rank unique.', 'start': 29134.209, 'duration': 10.568}, {'end': 29149.201, 'text': "And we'll take a look at these in a visualization here and talk about the difference.", 'start': 29144.977, 'duration': 4.224}, {'end': 29158.108, 'text': "But if you are asked about the rank function in Tableau, it's worth bringing up that there are several different ways to rank,", 'start': 29149.501, 'duration': 8.607}, {'end': 29162.651, 'text': 'and going into a little bit of detail on those different ways will be helpful for you.', 'start': 29158.108, 'duration': 4.543}, {'end': 29167.738, 'text': "Let's build off of this rank example instead.", 'start': 29164.195, 'duration': 3.543}, {'end': 29170.76, 'text': "So we're going to bring on our store.", 'start': 29168.218, 'duration': 2.542}, {'end': 29174.723, 'text': "And we've got store A, B, C, D, and E.", 'start': 29171.321, 'duration': 3.402}, {'end': 29176.305, 'text': "And then we'll bring on our sales.", 'start': 29174.723, 'duration': 1.582}], 'summary': 'Tableau offers multiple ranking methods like rank, rank dense, rank modified, or rank unique, providing various ways to assign positions within a category and based on a measure.', 'duration': 53.144, 'max_score': 29123.161, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY29123161.jpg'}, {'end': 29488.87, 'src': 'embed', 'start': 29455.517, 'weight': 4, 'content': [{'end': 29458.778, 'text': "When we select Nebraska, it'll change.", 'start': 29455.517, 'duration': 3.261}, {'end': 29470.11, 'text': 'So the major points to know on how to embed a web page is you bring it in from the objects section and then, if they ask how to make it dynamic,', 'start': 29460.782, 'duration': 9.328}, {'end': 29474.293, 'text': 'you use dashboard actions and a URL action.', 'start': 29470.11, 'duration': 4.183}, {'end': 29476.355, 'text': 'Question 24.', 'start': 29475.054, 'duration': 1.301}, {'end': 29479.418, 'text': 'Design a view to show region-wide profit and sales.', 'start': 29476.355, 'duration': 3.063}, {'end': 29488.87, 'text': 'So one way you could do this is by bringing on region and then bringing on profit and sales.', 'start': 29481.246, 'duration': 7.624}], 'summary': 'To embed a web page, use objects section and dashboard actions. view should show region-wide profit and sales.', 'duration': 33.353, 'max_score': 29455.517, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY29455517.jpg'}, {'end': 29583.871, 'src': 'embed', 'start': 29541.276, 'weight': 5, 'content': [{'end': 29547.46, 'text': 'And so that is another view where you could look at profit and sales by region.', 'start': 29541.276, 'duration': 6.184}, {'end': 29552.664, 'text': "And it's a little bit more, takes advantage of some of the mapping capabilities in Tableau.", 'start': 29548.061, 'duration': 4.603}, {'end': 29554.845, 'text': 'It may be what your interviewer is looking for.', 'start': 29552.784, 'duration': 2.061}, {'end': 29557.867, 'text': 'So you could discuss multiple ways to look at it.', 'start': 29555.186, 'duration': 2.681}, {'end': 29560.389, 'text': 'But here is one way that we could recommend it.', 'start': 29558.228, 'duration': 2.161}, {'end': 29567.975, 'text': 'Question 25, how can you optimize the performance of a dashboard? There are multiple ways to optimize the performance of the dashboard.', 'start': 29560.909, 'duration': 7.066}, {'end': 29575.082, 'text': "Some of the things that you might mention is that you could exclude any fields you're not using from your visualization.", 'start': 29568.035, 'duration': 7.047}, {'end': 29576.284, 'text': 'Just keep them off.', 'start': 29575.143, 'duration': 1.141}, {'end': 29578.326, 'text': 'Or you can use extract filters.', 'start': 29576.304, 'duration': 2.022}, {'end': 29583.871, 'text': 'And if you recall, extract filters will remove out rows of data from the extract.', 'start': 29578.406, 'duration': 5.465}], 'summary': 'Recommend optimizing dashboard performance by excluding unused fields and using extract filters.', 'duration': 42.595, 'max_score': 29541.276, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY29541276.jpg'}, {'end': 29697.216, 'src': 'embed', 'start': 29671.649, 'weight': 7, 'content': [{'end': 29677.571, 'text': 'So first we want to show aggregated sales totals across a range of product categories and subcategories.', 'start': 29671.649, 'duration': 5.922}, {'end': 29683.493, 'text': 'We want to show the duration of events or activities and we want to show quarter-wise profit growth.', 'start': 29677.891, 'duration': 5.602}, {'end': 29690.214, 'text': 'So to show aggregated sales totals across a range of products, subcategories, and categories, you could use a tree map.', 'start': 29684.113, 'duration': 6.101}, {'end': 29697.216, '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': 29690.594, 'duration': 6.622}], 'summary': 'Visualize aggregated sales and profit growth with tree map.', 'duration': 25.567, 'max_score': 29671.649, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY29671649.jpg'}, {'end': 29931.337, 'src': 'embed', 'start': 29897.755, 'weight': 8, 'content': [{'end': 29899.697, 'text': '28. What is a level of detail expression?', 'start': 29897.755, 'duration': 1.942}, {'end': 29911.187, 'text': 'A level of detail expression or an LOD expression is maybe the way they will present it to you, and LOD stands for level of detail.', 'start': 29903.263, 'duration': 7.924}, {'end': 29916.529, 'text': 'So obviously it helps you get to the level of detail that you want in your visualization,', 'start': 29911.387, 'duration': 5.142}, {'end': 29923.052, 'text': 'but it also is used to run complex queries at the data source level instead of all in the Tableau interface.', 'start': 29916.529, 'duration': 6.523}, {'end': 29931.337, 'text': "So we're going to take a look at an example here which is adding a dimension to an already calculated aggregate field.", 'start': 29923.832, 'duration': 7.505}], 'summary': 'Lod expression helps control visualization detail and optimize data queries.', 'duration': 33.582, 'max_score': 29897.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY29897755.jpg'}, {'end': 29979.117, 'src': 'embed', 'start': 29956.931, 'weight': 9, 'content': [{'end': 29964.913, 'text': 'But if we want a side by side and so that you can see the total sales for furniture and you can see it broken up by subcategory,', 'start': 29956.931, 'duration': 7.982}, {'end': 29966.814, 'text': 'you can use a level of detail calculation.', 'start': 29964.913, 'duration': 1.901}, {'end': 29969.754, 'text': 'This, I already made the field for it.', 'start': 29967.414, 'duration': 2.34}, {'end': 29971.735, 'text': "I've called it exclude subcategory.", 'start': 29969.774, 'duration': 1.961}, {'end': 29972.455, 'text': "So that's right here.", 'start': 29971.815, 'duration': 0.64}, {'end': 29974.976, 'text': 'Right now, it just contains sales.', 'start': 29973.255, 'duration': 1.721}, {'end': 29979.117, 'text': "But we're going to use the level of detail calculation exclude.", 'start': 29975.696, 'duration': 3.421}], 'summary': 'A level of detail calculation called exclude subcategory is used to show total sales for furniture and broken up by subcategory.', 'duration': 22.186, 'max_score': 29956.931, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY29956931.jpg'}, {'end': 30085.252, 'src': 'embed', 'start': 30055.716, 'weight': 10, 'content': [{'end': 30059.158, 'text': 'How do you calculate daily profit measure using level of detail?', 'start': 30055.716, 'duration': 3.442}, {'end': 30066.785, 'text': "Here's another opportunity for you to pause the video and take a look at calculating a daily profit measure using level of detail.", 'start': 30059.499, 'duration': 7.286}, {'end': 30068.706, 'text': 'We are going to get started.', 'start': 30067.205, 'duration': 1.501}, {'end': 30070.928, 'text': 'Profitable level of detail.', 'start': 30069.627, 'duration': 1.301}, {'end': 30077.189, 'text': 'So we want to have a daily profit measure And I already made a place for it, profit per day.', 'start': 30071.028, 'duration': 6.161}, {'end': 30085.252, 'text': 'And we want to look at the profit for a day regardless of what else is on the visualization.', 'start': 30079.17, 'duration': 6.082}], 'summary': 'Calculate daily profit measure using level of detail for visualization.', 'duration': 29.536, 'max_score': 30055.716, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY30055716.jpg'}, {'end': 30380.157, 'src': 'heatmap', 'start': 30114.322, 'weight': 0.894, 'content': [{'end': 30115.123, 'text': 'And close it off.', 'start': 30114.322, 'duration': 0.801}, {'end': 30117.827, 'text': 'So now we have our profit per day.', 'start': 30115.704, 'duration': 2.123}, {'end': 30121.672, 'text': "Okay And now we're going to make a KPI.", 'start': 30118.808, 'duration': 2.864}, {'end': 30130.034, 'text': 'which for our purposes, if profit for a day is greater than 2, 000, then that day is highly profitable.', 'start': 30123.871, 'duration': 6.163}, {'end': 30133.516, 'text': "If it's less than zero, then it's unprofitable, otherwise it is profitable.", 'start': 30130.315, 'duration': 3.201}, {'end': 30145.803, 'text': "So we're going to go if our profit per day is greater than 2, 000, then we're going to call it highly profitable.", 'start': 30133.997, 'duration': 11.806}, {'end': 30150.486, 'text': 'Else if.', 'start': 30150.026, 'duration': 0.46}, {'end': 30167.537, 'text': "We're going to do less than or equal to 0, then profitable, else, otherwise it is profitable.", 'start': 30153.814, 'duration': 13.723}, {'end': 30173.238, 'text': 'Always have to end with an end.', 'start': 30167.557, 'duration': 5.681}, {'end': 30175.679, 'text': 'Great OK.', 'start': 30174.158, 'duration': 1.521}, {'end': 30183.632, 'text': "So now we're going to make some visualizations, and it's going to look at it by year.", 'start': 30176.419, 'duration': 7.213}, {'end': 30190.776, 'text': 'Now it all fits in one view.', 'start': 30183.652, 'duration': 7.124}, {'end': 30195.899, 'text': 'We can rotate these labels to make it easier to see.', 'start': 30191.377, 'duration': 4.522}, {'end': 30200.342, 'text': "And we're going to bring on order ID.", 'start': 30195.919, 'duration': 4.423}, {'end': 30206.261, 'text': "but now it's showing like a lot of orders.", 'start': 30203.8, 'duration': 2.461}, {'end': 30212.004, 'text': "And so we actually want it to be used as a measure and we're going to do a count distinct.", 'start': 30206.761, 'duration': 5.243}, {'end': 30218.566, 'text': 'Great, so now we can see how many orders were on each day.', 'start': 30214.545, 'duration': 4.021}, {'end': 30222.668, 'text': "And so that's helpful for us to see how many orders are on this day each day.", 'start': 30219.347, 'duration': 3.321}, {'end': 30230.091, 'text': 'but we want to see the orders on each day that are highly profitable versus unprofitable, versus just profitable.', 'start': 30222.668, 'duration': 7.423}, {'end': 30236.727, 'text': "So we're going to use our level of detail and break it up into different sections.", 'start': 30230.471, 'duration': 6.256}, {'end': 30240.771, 'text': 'So we have highly profitable, profitable, and unprofitable.', 'start': 30237.588, 'duration': 3.183}, {'end': 30243.253, 'text': "Let's also bring this on to our color.", 'start': 30241.191, 'duration': 2.062}, {'end': 30246.753, 'text': 'Highly profitable, profitable, unprofitable.', 'start': 30244.932, 'duration': 1.821}, {'end': 30251.195, 'text': 'And now we can see that the profitable ones are going up.', 'start': 30247.213, 'duration': 3.982}, {'end': 30255.917, 'text': "Unprofitable ones seem to be going down in 2015, and that's nice, but they are going up.", 'start': 30251.735, 'duration': 4.182}, {'end': 30258.458, 'text': 'And highly profitable is not very many.', 'start': 30256.277, 'duration': 2.181}, {'end': 30262.039, 'text': 'Oh, in this case we did area charts instead of just line charts.', 'start': 30259.218, 'duration': 2.821}, {'end': 30269.664, 'text': 'To make that change, you change it from automatic to area, and that helps you see some of that spatially as well.', 'start': 30262.419, 'duration': 7.245}, {'end': 30274.169, 'text': 'Comment below if you were able to make this visualization on your own.', 'start': 30270.124, 'duration': 4.045}, {'end': 30275.912, 'text': 'Question 30.', 'start': 30274.83, 'duration': 1.082}, {'end': 30279.216, 'text': 'How can you schedule a workbook in Tableau after publishing it?', 'start': 30275.912, 'duration': 3.304}, {'end': 30286.643, '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': 30279.797, 'duration': 6.846}, {'end': 30288.644, 'text': 'So in Tableau,', 'start': 30287.043, 'duration': 1.601}, {'end': 30297.828, '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': 30288.644, 'duration': 9.184}, {'end': 30303.71, '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': 30298.168, 'duration': 5.542}, {'end': 30307.592, 'text': "Well, you're not going to see it, but you can see it if you make a refresh.", 'start': 30303.75, 'duration': 3.842}, {'end': 30314.914, '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': 30308.132, 'duration': 6.782}, {'end': 30324.378, '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': 30314.934, 'duration': 9.444}, {'end': 30332.283, 'text': 'and then you select schedule a refresh so that looks like this you can press these three dots next to it and click refresh extracts,', 'start': 30324.798, 'duration': 7.485}, {'end': 30340.129, 'text': 'or you can go to actions, and then here you click schedule a refresh instead of refresh now and then, oftentimes in tableau,', 'start': 30332.283, 'duration': 7.846}, {'end': 30341.91, 'text': "you'll have several different options.", 'start': 30340.129, 'duration': 1.781}, {'end': 30345.272, 'text': 'you can choose daily at 7am or every four hours.', 'start': 30341.91, 'duration': 3.362}, {'end': 30349.595, 'text': 'if an interviewer is asking you about how to schedule a refresh,', 'start': 30345.272, 'duration': 4.323}, {'end': 30359.142, 'text': 'it might be worthwhile bringing up the fact that you only need to schedule a refresh if you are using an extract on your data source,', 'start': 30349.595, 'duration': 9.547}, {'end': 30364.506, 'text': "and then that will help them know that you know the difference between live and extracts, if they didn't ever ask that question.", 'start': 30359.142, 'duration': 5.364}, {'end': 30367.889, 'text': 'So with that, we have come to an end of this Tableau Expert full course.', 'start': 30364.726, 'duration': 3.163}, {'end': 30374.874, 'text': 'If you have any queries regarding the topics covered in this session, or if you need the datasets or the code used in this particular tutorial,', 'start': 30368.269, 'duration': 6.605}, {'end': 30380.157, 'text': 'then please feel free to write us down in the comment section below, and our team of experts will be happy to resolve all your queries.', 'start': 30374.874, 'duration': 5.283}], 'summary': 'The tutorial covers creating kpis, visualizations, and scheduling refresh in tableau.', 'duration': 265.835, 'max_score': 30114.322, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY30114322.jpg'}, {'end': 30332.283, 'src': 'embed', 'start': 30308.132, 'weight': 11, 'content': [{'end': 30314.914, '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': 30308.132, 'duration': 6.782}, {'end': 30324.378, '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': 30314.934, 'duration': 9.444}, {'end': 30332.283, 'text': 'and then you select schedule a refresh so that looks like this you can press these three dots next to it and click refresh extracts,', 'start': 30324.798, 'duration': 7.485}], 'summary': 'Tableau server allows scheduling data source refresh for efficient data management.', 'duration': 24.151, 'max_score': 30308.132, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY30308132.jpg'}], 'start': 28722.282, 'title': 'Tableau functions and interview tips', 'summary': 'Discusses handling null values, rank functions, and level of detail calculations in tableau. it also provides interview tips covering various aspects such as web page embedding, dashboard optimization, and level of detail expressions.', 'chapters': [{'end': 29019.43, 'start': 28722.282, 'title': 'Handling null values in tableau', 'summary': 'Discusses how tableau handles null and special values, including options to filter the data, display null values at the default position, and finding subcategories ranked by sales within each delivery method.', 'duration': 297.148, 'highlights': ['Tableau is unable to plot null values or zeros or negative values on a logarithmic axis, and it will display an indicator in the lower right corner to indicate the exclusion of those points. Tableau cannot plot null, zero, or negative values on a logarithmic axis, and it shows an indicator for their exclusion.', 'Options to handle null values include filtering the data to exclude null values from the visualization or displaying null values at the default position. Two options to handle null values in Tableau are filtering the data to exclude null values or displaying null values at the default position.', 'Using the rank table calculation in Tableau helps to determine the subcategories ranked by sales within each delivery method, such as finding the subcategory ranked number two for first class ship mode. Utilizing the rank table calculation in Tableau helps in determining the ranking of subcategories by sales within each delivery method, such as identifying the subcategory ranked number two for first class ship mode.']}, {'end': 29351.525, 'start': 29019.43, 'title': 'Customer profit analysis and tableau rank functions', 'summary': 'Covers finding the customer with the lowest overall profit, determining the profit ratio, and explaining the rank function in tableau with practical examples and variations of ranking methods.', 'duration': 332.095, 'highlights': ['Explaining the rank function in Tableau and its variations The transcript delves into explaining the rank function in Tableau, including rank, rank dense, rank modified, and rank unique, with practical examples and how each method works differently in assigning rankings.', 'Determining the profit ratio for the customer with the lowest profit It describes the process of calculating the profit ratio for the customer with the lowest profit, Cindy Stewart, by taking the sum of profit and dividing it by the sum of sales, providing a real-world scenario to understand the concept.', 'Identifying the customer with the lowest overall profit The chapter identifies Cindy Stewart as the customer with the lowest profit and proceeds to explain the approach to calculate her profit ratio, providing practical insights into data visualization and analysis.']}, {'end': 29923.052, 'start': 29352.679, 'title': 'Tableau interview tips', 'summary': 'Provides insights on embedding web pages, designing views, optimizing dashboard performance, choosing visualizations, handling missing geographical data, and using level of detail expressions in tableau interviews.', 'duration': 570.373, 'highlights': ['To embed a web page in a dashboard, grab it from the objects section and use dashboard actions and a URL action to make it dynamic based on selection. Demonstrates how to embed a web page in a Tableau dashboard and make it dynamic based on user selection using dashboard actions and a URL action.', 'Designing a view to show region-wide profit and sales involves using mapping capabilities in Tableau to visualize profit and sales by region and state. Explains how to utilize mapping capabilities in Tableau to create a view showing profit and sales by region and state, demonstrating creativity and advanced functionality.', 'Optimizing dashboard performance can be achieved by excluding unused fields, using extract filters, limiting filters, utilizing min and max instead of average, and using boolean and numerical calculations. Provides multiple methods for optimizing dashboard performance by excluding unused fields, using extract filters, and utilizing efficient calculations.', 'Tree maps, Gantt charts, and waterfall charts are recommended for showing aggregated sales totals, duration of events, and profit growth respectively, in Tableau visualizations. Recommends specific visualizations such as tree maps, Gantt charts, and waterfall charts for displaying aggregated sales, event duration, and profit growth in Tableau.', 'When encountering missing geographical data in map view, options include editing locations, filtering the data, or showing data at the default position. Provides solutions for handling missing geographical data in map view by editing locations, filtering the data, or showing data at the default position.', 'Level of detail expressions (LOD) in Tableau allow for running complex queries at the data source level and help in achieving the desired level of detail in visualizations. Defines level of detail expressions (LOD) and their significance in Tableau for running complex queries and specifying the level of detail in visualizations.']}, {'end': 30383.64, 'start': 29923.832, 'title': 'Level of detail calculations in tableau', 'summary': 'Explains how to use level of detail (lod) calculations in tableau to exclude a dimension from a calculated field and to create a daily profit measure using the fixed lod calculation, alongside scheduling a workbook refresh on tableau server.', 'duration': 459.808, 'highlights': ['The chapter explains how to use level of detail (LOD) calculations in Tableau to exclude a dimension from a calculated field The tutorial demonstrates using a level of detail calculation to exclude a subcategory from the total sales, providing a clear example of how LOD calculations can be used to manipulate visualizations.', 'The tutorial provides a detailed walkthrough of creating a daily profit measure using the fixed LOD calculation It shows how to use a fixed LOD calculation to calculate the sum of profit per day, and then categorize the daily profit as highly profitable, profitable, or unprofitable, providing a practical example of implementing fixed LOD calculations for business analysis.', 'The chapter includes a guide on scheduling a workbook refresh on Tableau Server It explains the process of refreshing extracts on Tableau Server, highlighting the importance of scheduling a refresh for data sources using extracts, showcasing an essential aspect of maintaining data accuracy in Tableau visualizations.']}], 'duration': 1661.358, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/DlBIhpDjhbY/pics/DlBIhpDjhbY28722282.jpg', 'highlights': ['Utilizing the rank table calculation in Tableau helps in determining the ranking of subcategories by sales within each delivery method, such as identifying the subcategory ranked number two for first class ship mode.', 'Two options to handle null values in Tableau are filtering the data to exclude null values or displaying null values at the default position.', 'Explaining the rank function in Tableau and its variations The transcript delves into explaining the rank function in Tableau, including rank, rank dense, rank modified, and rank unique, with practical examples and how each method works differently in assigning rankings.', 'Determining the profit ratio for the customer with the lowest profit It describes the process of calculating the profit ratio for the customer with the lowest profit, Cindy Stewart, by taking the sum of profit and dividing it by the sum of sales, providing a real-world scenario to understand the concept.', 'To embed a web page in a dashboard, grab it from the objects section and use dashboard actions and a URL action to make it dynamic based on selection.', 'Designing a view to show region-wide profit and sales involves using mapping capabilities in Tableau to visualize profit and sales by region and state.', 'Provides multiple methods for optimizing dashboard performance by excluding unused fields, using extract filters, and utilizing efficient calculations.', 'Recommends specific visualizations such as tree maps, Gantt charts, and waterfall charts for displaying aggregated sales, event duration, and profit growth in Tableau.', 'Defines level of detail expressions (LOD) and their significance in Tableau for running complex queries and specifying the level of detail in visualizations.', 'The tutorial demonstrates using a level of detail calculation to exclude a subcategory from the total sales, providing a clear example of how LOD calculations can be used to manipulate visualizations.', 'It shows how to use a fixed LOD calculation to calculate the sum of profit per day, and then categorize the daily profit as highly profitable, profitable, or unprofitable, providing a practical example of implementing fixed LOD calculations for business analysis.', 'It explains the process of refreshing extracts on Tableau Server, highlighting the importance of scheduling a refresh for data sources using extracts, showcasing an essential aspect of maintaining data accuracy in Tableau visualizations.']}], 'highlights': ['The chapter covers a comprehensive Tableau expert full course, including various topics such as data connections, data extracts, calculations, aggregations, creating charts, formatting, annotations, filtering, mapping, data blending, sorting, special field types, parameters, level of detail expressions, dashboards, projects, and interview questions.', 'Tableau automates SQL commands for data extraction, offers various versions including Tableau Desktop, Server, Online, Public, and Reader, and provides features like robust security, collaboration, time series and forecasting, and informative and mobile view.', 'Understanding how to use aggregation options, grand totals, subtotals, and quick table calculations provided by Tableau.', 'The chapter covers using multiple conditions for sales KPI calculations, including examples and scenarios, and then explains working with aggregation options in Tableau.', 'The chapter outlines the process of creating a line chart for year-over-year sales analysis, drilling down to quarterly breakdown, and performing table calculations to determine the sales variance, providing a comprehensive approach for sales analysis.', 'Tableau allows flexible formatting for fonts, alignments, shading, borders, and lines.', "Tableau's advanced capabilities aim to facilitate sophisticated analytics projects, including filtering and sorting data, creating combined fields, defining aliases, working with sets, drilling into hierarchies, and changing aggregation functions for measures.", 'Tableau provides features for creating bar charts and filtering large data sets.', 'The chapter covers the creation of drill down reports in Tableau to analyze sales performance across different hierarchies.', 'The chapter discusses advanced mapping functions in Tableau, including modifying locations, importing and modifying custom geocoding, using map layers, and understanding geographic roles.', 'LOD expressions allow computation of values at data source level and visualization level, giving more control over the level of granularity.', 'The dashboard includes separate legends and filters for country and year, providing users with interactive visualization of birth rates, spending on health, and life expectancy, enhancing user experience', 'The chapter explores trends in phone and internet usage over time.', 'Tableau supports computed sorting as well as manual sorting based on specific fields or data source order.', 'The chapter discusses using Tableau to analyze COVID-19 data and finding the highest and least death rates at the international level.', "Tableau's live connection queries the database every time the dashboard is opened, providing real-time information, while an extract runs queries beforehand and stores the information for faster access.", 'Heat maps compare categories using size and color, allowing users to visualize data through color and optionally size, providing insights into activity and sales performance.', 'Utilizing the rank table calculation in Tableau helps in determining the ranking of subcategories by sales within each delivery method, such as identifying the subcategory ranked number two for first class ship mode.', 'The tutorial demonstrates using a level of detail calculation to exclude a subcategory from the total sales, providing a clear example of how LOD calculations can be used to manipulate visualizations.', 'It explains the process of refreshing extracts on Tableau Server, highlighting the importance of scheduling a refresh for data sources using extracts, showcasing an essential aspect of maintaining data accuracy in Tableau visualizations.']}