title
Tableau Interview Questions & Answers | Tableau Career Path | Tableau Jobs | Edureka

description
***** Tableau Certification Training : https://www.edureka.co/tableau-certification-training ***** This Edureka Tableau interview questions and answer tutorial (Tableau Interview Questions and Answers blog: https://goo.gl/7F2BsJ) gives you an overview of Tableau job market trends, career path in Tableau and how to get your dream Tableau job along with interview questions answered by a Tableau expert. Click on the timestamp below to move directly to the topic you are interested in. 4:00 Qlikview vs Tableau 6:17 Tableau Interview Questions and Answers Subscribe to our channel to get video updates. Hit the subscribe button above. Check our complete Tableau playlist here: https://goo.gl/FveW5G #Tableauinterview #Tableau #Tableaututorial #Tableauquestions #Interviewquestions #TableauInterviewQuestions How it Works? 1. This is a 5 Week / 15 day Instructor led Online Course, 30 hours of online training, 20 hours of assignment and 15 hours of project work 2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 3. Towards the end of the Edureka Tableau online training, you will be working on a real-time project. Once you are successfully through with the project (reviewed by an expert), you will receive a Tableau certification with a performance based grading. - - - - - - - - - - - - - - About the Tableau Training Edureka’s online training on Tableau will cover various concepts of data visualization in depth, including conditional formatting, scripting, linking charts, dashboard integration, Tableau integration with R and more. The course includes a hands-on project on Tableau that will help you test your Tableau skills gained from our Tableau training. You will be awarded with a Tableau certification on successful completion of the online course. --------------------- After the successful completion of Edureka Tableau Certification Training, you will be able to: 1. Understand the need for visualization 2. Make advance insightful visuals 3. Perform scripting 4. Create comprehensive dashboards 5. Connect with multiple sources 6. Integrate Tableau with R ------------------------------------------- Who should go for Edureka Tableau online training? The following professionals can go for this Tableau course : 1. Data Scientists 2. Business Analysts 3. Statisticians and Analysts 4. Project Managers This Tableau course is a foundation for anyone who aspires to get into analytics and present data in a more sensible manner. Also, Edureka is proud to have happy learners from different parts of the world – India, United States (US), United Kingdon (UK), Singapore, Australia, UAE etc. who have taken up our Tableau training. ------------------------------------------- Pre-requisites There are no prerequisites for Edureka’s Tableau training. Knowledge of R language would be an advantage. ----------------------------------------- Why learn Data Visualization with Tableau? • Tableau Demand on Rise – According to IDC, by 2020, the world is set to generate 50 times the amount of data as in 2011. Tableau – the four time leader in Gartner’s magic quadrant – helps you mine the data and visualize business opportunities • Higher salaries - Tableau professionals are getting paid the best salaries in the industry, with an average of $106,000 in the US and a median of Rs.5 lakh in India • Great Career Opportunities – The career prospects for Tableau look great with top companies looking for Tableau talent. Top companies include Facebook, Dell, Applied Systems, Booz Allen Hamilton, NetJets, Groupon, General Motors, Sony Electronics, Sunguard, Bank of America, KPMG, Verizon and many others Read more about career opportunities with Tableau here ----------------------------------------------- Please write back to us at sales@edureka.co or call us at +91 88808 62004 for more information. Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka ------------------------------------------ Customer Review: Kirthi Krishnamurthy, BI Developer, says: “I learnt Data Visualization with Tableau in Edureka which was my best Online Session that was available at a very reasonable price. I had best course ,instructors and support team . Live sessions and interactive classes were enjoyable to learn lots of new concepts... Edureka Team is quick to respond to all the queries.LMS is great - can listen to previous lectures whenever we overcome doubts in any concepts!!! Thank you Edureka for making my career shine!!! I would recommend Edureka training to all my friends who wants to learn or enhance their technical skills.”

detail
{'title': 'Tableau Interview Questions & Answers | Tableau Career Path | Tableau Jobs | Edureka', 'heatmap': [{'end': 1979.339, 'start': 1871.926, 'weight': 1}], 'summary': "Delves into tableau's future, job trends, advantages, optimization, calculations, performance, dashboard design, mobile view, data blending, functions, data storytelling, visualization, and analysis, offering practical insights and tips for career growth and job prospects in the tableau ecosystem.", 'chapters': [{'end': 150.739, 'segs': [{'end': 26.41, 'src': 'embed', 'start': 0.229, 'weight': 0, 'content': [{'end': 7.275, 'text': 'So, before we start to go through the different questions you can encounter during Tableau related interviews,', 'start': 0.229, 'duration': 7.046}, {'end': 14.821, 'text': 'let me just sort of like tell you the background, whether you have made the right choice by choosing to learn Tableau or not.', 'start': 7.275, 'duration': 7.546}, {'end': 21.106, 'text': 'So here in this particular slide you can see the future of Tableau as a software.', 'start': 15.301, 'duration': 5.805}, {'end': 26.41, 'text': "This particular chart which you can see is known as Gartner's Magic Quadrant.", 'start': 21.946, 'duration': 4.464}], 'summary': "Assessing tableau's potential using gartner's magic quadrant", 'duration': 26.181, 'max_score': 0.229, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I229.jpg'}], 'start': 0.229, 'title': "Tableau's future and job trends", 'summary': "Highlights tableau's position as a leader in gartner's magic quadrant, with consistent ability to execute and strong job market growth, as seen in the increase in tableau-related jobs and rising salary trends.", 'chapters': [{'end': 150.739, 'start': 0.229, 'title': "Tableau's future and job trends", 'summary': "Highlights tableau's position as a leader in gartner's magic quadrant, with consistent ability to execute and strong job market growth, as seen in the increase in tableau-related jobs and rising salary trends.", 'duration': 150.51, 'highlights': ["Tableau is consistently positioned as a leader in Gartner's Magic Quadrant, with a strong ability to execute and a bright future in terms of completeness of vision, as indicated by its position at the top of the stack. (Relevance Score: 5)", 'The demand for Tableau professionals has shown exponential growth, with the number of Tableau-related jobs increasing considerably from January 2015 to January 2016. (Relevance Score: 4)', 'The national salary trend for Tableau professionals indicates a significant increase, reflecting a positive job market and higher demand for Tableau skills. (Relevance Score: 3)']}], 'duration': 150.51, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I229.jpg', 'highlights': ["Tableau is consistently positioned as a leader in Gartner's Magic Quadrant, with a strong ability to execute and a bright future in terms of completeness of vision, as indicated by its position at the top of the stack. (Relevance Score: 5)", 'The demand for Tableau professionals has shown exponential growth, with the number of Tableau-related jobs increasing considerably from January 2015 to January 2016. (Relevance Score: 4)', 'The national salary trend for Tableau professionals indicates a significant increase, reflecting a positive job market and higher demand for Tableau skills. (Relevance Score: 3)']}, {'end': 1215.573, 'segs': [{'end': 176.228, 'src': 'embed', 'start': 151.099, 'weight': 6, 'content': [{'end': 158.265, 'text': "So it's worth our time and effort to learn Tableau and work in this particular field.", 'start': 151.099, 'duration': 7.166}, {'end': 162.848, 'text': 'One thing which I can tell you from my perspective, being a Tableau developer myself,', 'start': 158.665, 'duration': 4.183}, {'end': 168.552, 'text': "I can tell you the job satisfaction level is going to be high because it's fun to work in Tableau.", 'start': 162.848, 'duration': 5.704}, {'end': 170.934, 'text': 'So you get constant feedback.', 'start': 168.993, 'duration': 1.941}, {'end': 176.228, 'text': 'Guys, am I audible? So I just got a message that my audio connection was lost.', 'start': 171.795, 'duration': 4.433}], 'summary': 'Learn tableau for high job satisfaction and constant feedback.', 'duration': 25.129, 'max_score': 151.099, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I151099.jpg'}, {'end': 247.842, 'src': 'embed', 'start': 221.917, 'weight': 5, 'content': [{'end': 228.822, 'text': "I've worked across multiple multinational companies, many of them were Fortune 500, and many of them were using Tableau.", 'start': 221.917, 'duration': 6.905}, {'end': 235.587, 'text': 'So I worked in John Deere, I worked in Rio Tinto, all of them are Fortune 500 companies, all of them are using Tableau.', 'start': 229.262, 'duration': 6.325}, {'end': 238.569, 'text': 'So industry adoption is very high.', 'start': 236.888, 'duration': 1.681}, {'end': 246.181, 'text': 'These are two top contender when it comes to visual analytics.', 'start': 241.82, 'duration': 4.361}, {'end': 247.842, 'text': 'We have Tableau and we have QlikView.', 'start': 246.241, 'duration': 1.601}], 'summary': 'Worked in fortune 500 companies like john deere and rio tinto, with high industry adoption of tableau and qlikview.', 'duration': 25.925, 'max_score': 221.917, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I221917.jpg'}, {'end': 760.41, 'src': 'embed', 'start': 734.767, 'weight': 4, 'content': [{'end': 742.014, 'text': "but what I have seen is I've been using Tableau for quite some time now and I started using it way back, I think from version five or six.", 'start': 734.767, 'duration': 7.247}, {'end': 745.857, 'text': 'I do not remember exactly, but it was lacking a lot of features back then.', 'start': 742.014, 'duration': 3.843}, {'end': 752.823, 'text': 'And users were constantly providing feedback that this particular feature should be available, that feature should be available.', 'start': 746.658, 'duration': 6.165}, {'end': 760.41, 'text': 'In fact, we got this survey from Tableau, where we provided our feedback, and several of those feedback which we provided.', 'start': 752.863, 'duration': 7.547}], 'summary': 'Tableau user since version 5, provided feedback on features.', 'duration': 25.643, 'max_score': 734.767, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I734767.jpg'}, {'end': 1199.001, 'src': 'embed', 'start': 1172.775, 'weight': 0, 'content': [{'end': 1176.717, 'text': 'And use Boolean calculation whenever possible with alias.', 'start': 1172.775, 'duration': 3.942}, {'end': 1183.677, 'text': "So how to do that, how to use Boolean calculation whenever possible? Okay, so I'll just repeat what I said.", 'start': 1177.877, 'duration': 5.8}, {'end': 1186.197, 'text': 'So a couple of tips which I was sharing.', 'start': 1183.697, 'duration': 2.5}, {'end': 1191.559, 'text': "You can create an extract of your data that's going to speeden up your calculations,", 'start': 1187.398, 'duration': 4.161}, {'end': 1196.2, 'text': 'because Tableau optimizes its extract to make the dashboard perform better.', 'start': 1191.559, 'duration': 4.641}, {'end': 1199.001, 'text': 'So always create an extract whenever possible.', 'start': 1196.62, 'duration': 2.381}], 'summary': 'Create data extracts to speed up tableau calculations and optimize dashboard performance.', 'duration': 26.226, 'max_score': 1172.775, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1172775.jpg'}], 'start': 151.099, 'title': "Tableau's advantages and optimization", 'summary': "Covers tableau's high job satisfaction, industry adoption by major companies, ease of use compared to qlikview, benefits including rapid visualization and intuitive features, and tips for optimizing dashboard performance, with a notable example showing significant time differences in browser performance.", 'chapters': [{'end': 368.313, 'start': 151.099, 'title': 'Tableau: high job satisfaction and industry adoption', 'summary': "Discusses the high job satisfaction level in tableau due to instant feedback, industry adoption by major companies like cisco, google, and facebook, and the ease of use compared to qlikview. it also highlights the constraints in tableau such as the absence of etl tools and the need for data preparation outside of tableau's environment.", 'duration': 217.214, 'highlights': ['Tableau provides high job satisfaction due to instant feedback, visual components, and exciting work environment.', 'Major companies like Cisco, Google, Yahoo, LinkedIn, Facebook, and YouTube use Tableau, demonstrating its high industry adoption.', 'Tableau can analyze billions of data and is user-friendly, making it easier to learn compared to QlikView.', 'QlikView offers ETL tools and allows data manipulation within the platform, unlike Tableau.', 'The absence of ETL tools in Tableau necessitates data preparation outside its environment, requiring proficiency in other tools like SQL, Excel, or Access for data manipulation.']}, {'end': 869.181, 'start': 369.925, 'title': 'Tableau: easy, intuitive, and powerful', 'summary': 'Discusses the benefits of using tableau, such as its ease of use, rapid visualization, intuitive features, active user community, in-memory bi platform, and user feedback-driven updates, highlighting its advantage over other visualization tools and the ease of transition for ms excel users.', 'duration': 499.256, 'highlights': ["Tableau's ease of use makes it very intuitive and allows rapid visualization, enabling the creation of complex dashboards in a matter of days, not weeks, providing a significant advantage over other visualization tools.", "Tableau's visual appeal is based on best practices of visualization, offering vibrant, automatically generated colors and simple, visually appealing charts, demonstrating its superiority over 3D and fancy charts.", "Tableau's intuitive features and Excel-like formulas facilitate an easy transition for MS Excel users, making it user-friendly and accessible to a wide user base, contributing to its high adoption rate.", 'Tableau boasts an active user community, providing ample support and resources for developers, enhancing its usability and troubleshooting capabilities, ensuring a smoother user experience.', "Tableau's in-memory BI platform enables high scalability and rapid visualization, handling large data sets efficiently and outperforming tools like Excel, showcasing its superior performance and speed.", 'Tableau values user feedback and continuously updates its features and functionalities based on user input, indicating its commitment to improvement and innovation, with potential future enhancements such as an integrated ETL tool and advanced data manipulation features.']}, {'end': 1215.573, 'start': 869.361, 'title': 'Optimizing tableau reports', 'summary': 'Discusses tips for optimizing tableau dashboard performance, including browser selection, leveraging dbms for complex calculations and data aggregation, using extracts, avoiding unnecessary data connections, and filtering best practices, with a notable example of a test showing 11 seconds result in internet explorer 7 versus 3 seconds in firefox.', 'duration': 346.212, 'highlights': ['Leverage DBMS for complex calculations and data aggregation, considering creating a DBMS view that does the calculation, with a notable example of improved performance due to data aggregation within DBMS.', 'Use the latest and fastest browser for Tableau Server, as a recent test showed a significant time difference of 11 seconds in Internet Explorer 7 versus 3 seconds in Firefox for the same data pool from Tableau server.', 'Consider the use of pre-computed aggregated summary tables for large data sets, especially beyond 10 million rows, as it drastically improves performance, and turn off automatic updates whenever possible to speed up Tableau.', 'When filtering, try to avoid the exclude option, as Tableau performs slower when using this option, and use Boolean calculations with alias whenever possible to improve dashboard performance.', 'Use extracts to optimize data and improve dashboard performance, and refresh the extract when needed to ensure efficient calculations and data refreshing.']}], 'duration': 1064.474, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I151099.jpg', 'highlights': ["Tableau's in-memory BI platform enables high scalability and rapid visualization, outperforming tools like Excel.", 'Major companies like Cisco, Google, Yahoo, LinkedIn, Facebook, and YouTube use Tableau, demonstrating its high industry adoption.', "Tableau's ease of use allows rapid visualization, enabling the creation of complex dashboards in a matter of days, not weeks.", 'Tableau values user feedback and continuously updates its features and functionalities based on user input.', 'Leverage DBMS for complex calculations and data aggregation, with a notable example of improved performance due to data aggregation within DBMS.', 'Use the latest and fastest browser for Tableau Server to improve performance, as shown by a significant time difference in browser performance.', 'Consider the use of pre-computed aggregated summary tables for large data sets, especially beyond 10 million rows, as it drastically improves performance.', 'Use extracts to optimize data and improve dashboard performance, and refresh the extract when needed to ensure efficient calculations and data refreshing.', "Tableau's intuitive features and Excel-like formulas facilitate an easy transition for MS Excel users, contributing to its high adoption rate.", "Tableau's visual appeal is based on best practices of visualization, offering vibrant, automatically generated colors and simple, visually appealing charts."]}, {'end': 1758.47, 'segs': [{'end': 1266.298, 'src': 'embed', 'start': 1232.661, 'weight': 3, 'content': [{'end': 1246.87, 'text': "So, for example, if you're using an if-else formula, if you're using an if-else formula, you're trying to, let's say, analyze if, let's say,", 'start': 1232.661, 'duration': 14.209}, {'end': 1254.533, 'text': 'if the age, if age is less than 25 years or if age is less than 18, say, not adult.', 'start': 1246.87, 'duration': 7.663}, {'end': 1256.734, 'text': 'Else, say adult.', 'start': 1255.374, 'duration': 1.36}, {'end': 1263.477, 'text': "Okay, if that is the formula you're trying to build, just build a simple formula, age less than 18.", 'start': 1257.254, 'duration': 6.223}, {'end': 1266.298, 'text': 'You will get results in form of true and false.', 'start': 1263.477, 'duration': 2.821}], 'summary': 'Using if-else formula to analyze age for adult classification.', 'duration': 33.637, 'max_score': 1232.661, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1232661.jpg'}, {'end': 1569.34, 'src': 'embed', 'start': 1536.743, 'weight': 1, 'content': [{'end': 1538.564, 'text': 'Here is a formula you can see.', 'start': 1536.743, 'duration': 1.821}, {'end': 1548.109, 'text': 'If region is east and customer segment is equal to consumer, then call it east consumer else.', 'start': 1539.164, 'duration': 8.945}, {'end': 1551.25, 'text': 'Now this is the start of another if statement.', 'start': 1548.749, 'duration': 2.501}, {'end': 1553.751, 'text': 'Hence, to end statement here.', 'start': 1551.53, 'duration': 2.221}, {'end': 1559.934, 'text': 'Are you able to recognize this? So one if statement, another if statement.', 'start': 1554.471, 'duration': 5.463}, {'end': 1563.699, 'text': 'This is nested if, one statement within another.', 'start': 1560.518, 'duration': 3.181}, {'end': 1566.98, 'text': 'This one will be slow.', 'start': 1564.539, 'duration': 2.441}, {'end': 1569.34, 'text': 'You can write it like this.', 'start': 1568.08, 'duration': 1.26}], 'summary': 'Nested if statements in code, indicating potential performance issues.', 'duration': 32.597, 'max_score': 1536.743, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1536743.jpg'}, {'end': 1628.101, 'src': 'embed', 'start': 1596.276, 'weight': 0, 'content': [{'end': 1598.498, 'text': 'So in that case, use today, do not use now.', 'start': 1596.276, 'duration': 2.222}, {'end': 1604.523, 'text': 'For smaller data set, more or less you can use today or now, depending on your preference.', 'start': 1599.139, 'duration': 5.384}, {'end': 1605.703, 'text': "I mean it doesn't really matter.", 'start': 1604.643, 'duration': 1.06}, {'end': 1611.308, 'text': "But when it comes to large data set, if you're performing a lot of time related calculation based on today's date,", 'start': 1605.984, 'duration': 5.324}, {'end': 1613.709, 'text': 'you do not need timestamp level details.', 'start': 1611.308, 'duration': 2.401}, {'end': 1615.651, 'text': "don't use now, use today.", 'start': 1613.709, 'duration': 1.942}, {'end': 1619.954, 'text': "So that will restrict the scope of calculation, it'll be faster.", 'start': 1617.052, 'duration': 2.902}, {'end': 1623.658, 'text': 'Also, you should logically optimize your calculations.', 'start': 1620.775, 'duration': 2.883}, {'end': 1628.101, 'text': 'So for example here, take use of, you know, make use of logical calculation.', 'start': 1623.678, 'duration': 4.423}], 'summary': "Use 'today' instead of 'now' for large data sets to optimize time-related calculations and restrict scope for faster performance.", 'duration': 31.825, 'max_score': 1596.276, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1596276.jpg'}, {'end': 1709.477, 'src': 'embed', 'start': 1681.427, 'weight': 4, 'content': [{'end': 1687.892, 'text': 'We have already, this is a logical statement, right? So we make use of logic and we just skip this entire check.', 'start': 1681.427, 'duration': 6.465}, {'end': 1691.074, 'text': 'And that will make our code run faster.', 'start': 1688.573, 'duration': 2.501}, {'end': 1697.599, 'text': 'Next step, when using extracts and custom aggregation, divide the calculation into multiple part.', 'start': 1691.975, 'duration': 5.624}, {'end': 1704.432, 'text': 'Place the row level calculation on one calculated field and the aggregated calculation on a second calculated field.', 'start': 1698.266, 'duration': 6.166}, {'end': 1709.477, 'text': 'And then extract and optimize the pre-computed row level calculation.', 'start': 1704.492, 'duration': 4.985}], 'summary': 'Optimizing code with logical statements and custom aggregation can improve performance.', 'duration': 28.05, 'max_score': 1681.427, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1681427.jpg'}], 'start': 1215.573, 'title': 'Optimizing tableau calculations', 'summary': 'Provides tips for optimizing if-else statements and logical calculations in tableau, such as using include options, boolean calculations with alias, else if instead of nested else if, and dividing calculations into row-level and aggregated calculations, to improve performance and efficiency when working with large data sets and custom aggregations.', 'chapters': [{'end': 1615.651, 'start': 1215.573, 'title': 'Optimizing if-else statements in tableau', 'summary': 'Shares tips for optimizing if-else statements in tableau, including using include options, boolean calculations with alias, and else if instead of nested else if, to improve performance and efficiency when working with large data sets.', 'duration': 400.078, 'highlights': ['Use simple calculations with alias instead of IF-ELSE formula to categorize data, resulting in faster performance for large data sets. By using simple calculations with alias instead of IF-ELSE formula to categorize data, you can achieve faster performance for large data sets.', 'Utilize Boolean calculations with alias to categorize data based on specific conditions, leading to efficient performance when working with large data sets. Utilizing Boolean calculations with alias to categorize data based on specific conditions can lead to efficient performance when working with large data sets.', 'Optimize IF-ELSE statements by using else if instead of nested else if to improve processing speed and efficiency. Optimizing IF-ELSE statements by using else if instead of nested else if can significantly improve processing speed and efficiency.', 'Prefer using today over now for time-related calculations in large data sets to avoid unnecessary timestamp level details and enhance performance. Prefer using today over now for time-related calculations in large data sets to avoid unnecessary timestamp level details and enhance performance.']}, {'end': 1758.47, 'start': 1617.052, 'title': 'Optimizing logical calculations and custom aggregation', 'summary': 'Discusses optimizing logical calculations for speed by leveraging logical calculation and skipping unnecessary checks, and also emphasizes dividing calculations into row-level and aggregated calculations when using extracts and custom aggregations to improve performance.', 'duration': 141.418, 'highlights': ['The chapter emphasizes optimizing logical calculations to improve speed by making use of logical calculation and skipping unnecessary checks, resulting in faster code execution.', 'It also highlights the importance of dividing calculations into row-level and aggregated calculations when using extracts and custom aggregations to improve performance, demonstrated through examples of summing salaries based on gender and optimizing pre-computed row-level calculations.']}], 'duration': 542.897, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1215573.jpg', 'highlights': ['Utilize Boolean calculations with alias to categorize data based on specific conditions, leading to efficient performance when working with large data sets.', 'Optimizing IF-ELSE statements by using else if instead of nested else if can significantly improve processing speed and efficiency.', 'Use simple calculations with alias instead of IF-ELSE formula to categorize data, resulting in faster performance for large data sets.', 'Prefer using today over now for time-related calculations in large data sets to avoid unnecessary timestamp level details and enhance performance.', 'The chapter emphasizes optimizing logical calculations to improve speed by making use of logical calculation and skipping unnecessary checks.', 'The importance of dividing calculations into row-level and aggregated calculations when using extracts and custom aggregations to improve performance.']}, {'end': 2444.051, 'segs': [{'end': 1834.041, 'src': 'embed', 'start': 1759.61, 'weight': 0, 'content': [{'end': 1767.473, 'text': 'This tip, this particular tip tells you, if you are doing something like this, break it apart into two different pieces.', 'start': 1759.61, 'duration': 7.863}, {'end': 1768.894, 'text': 'Create two variables.', 'start': 1767.673, 'duration': 1.221}, {'end': 1774.735, 'text': 'Type it like this, this entire thing, will become a new variable.', 'start': 1769.814, 'duration': 4.921}, {'end': 1778.816, 'text': "Let's say we'll call it male salary.", 'start': 1774.955, 'duration': 3.861}, {'end': 1783.458, 'text': 'Then you will say equal to, this will be the formula of male salary.', 'start': 1779.857, 'duration': 3.601}, {'end': 1788.02, 'text': 'And then you will just perform a sum of male salary.', 'start': 1784.318, 'duration': 3.702}, {'end': 1789.46, 'text': "So there'll be two variables.", 'start': 1788.2, 'duration': 1.26}, {'end': 1797.223, 'text': "If you create two variables and then take an extract Tableau's going to perform the row level calculation and optimize it,", 'start': 1790.141, 'duration': 7.082}, {'end': 1799.244, 'text': 'and then aggregations will be faster.', 'start': 1797.223, 'duration': 2.021}, {'end': 1802.125, 'text': 'Is it possible?', 'start': 1799.264, 'duration': 2.861}, {'end': 1810.002, 'text': 'Okay, were you able to comprehend this particular point which I just mentioned, this particular thing?', 'start': 1803.74, 'duration': 6.262}, {'end': 1811.863, 'text': 'Any questions with respect to this one?', 'start': 1810.402, 'duration': 1.461}, {'end': 1814.384, 'text': 'Okay, perfect, thank you.', 'start': 1812.723, 'duration': 1.661}, {'end': 1817.645, 'text': 'Thanks for confirming, okay.', 'start': 1816.024, 'duration': 1.621}, {'end': 1821.431, 'text': 'Remove any unneeded dimension or measure from your palette.', 'start': 1818.308, 'duration': 3.123}, {'end': 1821.891, 'text': 'Next point.', 'start': 1821.451, 'duration': 0.44}, {'end': 1825.434, 'text': 'So we are working on some particular visualization.', 'start': 1822.392, 'duration': 3.042}, {'end': 1829.317, 'text': "let's say this one and what you will see from time to time.", 'start': 1825.434, 'duration': 3.883}, {'end': 1832.12, 'text': "there'll be something lying in the detail section which you're not using.", 'start': 1829.317, 'duration': 2.803}, {'end': 1834.041, 'text': 'Maybe you were experimenting with your view.', 'start': 1832.18, 'duration': 1.861}], 'summary': 'Breaking calculations into variables improves performance in tableau', 'duration': 74.431, 'max_score': 1759.61, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1759610.jpg'}, {'end': 1979.339, 'src': 'heatmap', 'start': 1871.926, 'weight': 1, 'content': [{'end': 1877.707, 'text': "Okay, but it's still just lying there sitting there making my dashboard slower.", 'start': 1871.926, 'duration': 5.781}, {'end': 1886.049, 'text': "So in those cases, it's actually good to revisit your shelf and see if there is some extra item which is not needed typically in the detail shelf.", 'start': 1877.967, 'duration': 8.082}, {'end': 1888.609, 'text': 'You will find some of those things just remove them.', 'start': 1886.069, 'duration': 2.54}, {'end': 1896.93, 'text': 'Okay, so there are a lot of tips which I shared with you in terms of making your reports perform better performance optimization.', 'start': 1889.229, 'duration': 7.701}, {'end': 1899.271, 'text': 'There are further tips which I can give you.', 'start': 1896.97, 'duration': 2.301}, {'end': 1906.405, 'text': "for example, If you're making a tabular structure in Tableau, you're not really creating a visualization,", 'start': 1899.271, 'duration': 7.134}, {'end': 1908.266, 'text': 'rather creating a tabular structure like this.', 'start': 1906.405, 'duration': 1.861}, {'end': 1914.652, 'text': 'This is table and people are supposed to scroll through this table and look through the data.', 'start': 1908.587, 'duration': 6.065}, {'end': 1916.673, 'text': 'So we have this tabular structure.', 'start': 1915.192, 'duration': 1.481}, {'end': 1928.863, 'text': "If you're picking any of these three, make sure the scrolling feature is not taking you very far down, because if your table is very, very big,", 'start': 1917.134, 'duration': 11.729}, {'end': 1933.147, 'text': "it's going to give a terrible hit to your performance.", 'start': 1928.863, 'duration': 4.284}, {'end': 1939.711, 'text': "So just make sure if you're doing something like this, create a hierarchy, enable plus and minus features.", 'start': 1934.348, 'duration': 5.363}, {'end': 1944.694, 'text': 'especially people create huge table when there is hierarchy involved.', 'start': 1939.711, 'duration': 4.983}, {'end': 1948.416, 'text': 'So, for example global sales broken up by regional.', 'start': 1944.994, 'duration': 3.422}, {'end': 1950.517, 'text': 'sales broken up by country level.', 'start': 1948.416, 'duration': 2.101}, {'end': 1952.678, 'text': 'sales broken up by state level.', 'start': 1950.517, 'duration': 2.161}, {'end': 1954.979, 'text': 'sales broken up by city level sales.', 'start': 1952.678, 'duration': 2.301}, {'end': 1961.841, 'text': 'This will turn out to be a huge table and people have to really scroll down, create a hierarchy.', 'start': 1955.8, 'duration': 6.041}, {'end': 1967.35, 'text': 'let people click on plus and minus button, expand or collapse the view.', 'start': 1961.841, 'duration': 5.509}, {'end': 1972.117, 'text': 'Because that view is going to slow down your dashboard considerably.', 'start': 1968.031, 'duration': 4.086}, {'end': 1974.34, 'text': "So that's another tip I wanted to share.", 'start': 1972.578, 'duration': 1.762}, {'end': 1979.339, 'text': 'And then we have some context filters.', 'start': 1976.498, 'duration': 2.841}], 'summary': 'Optimize tableau reports for better performance. remove unnecessary items and enable hierarchy for large tables.', 'duration': 107.413, 'max_score': 1871.926, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1871926.jpg'}, {'end': 2075.068, 'src': 'embed', 'start': 2042.323, 'weight': 5, 'content': [{'end': 2049.105, 'text': 'So for example, you can enable your report to refresh every 15 minutes or end of a particular month or every four hours.', 'start': 2042.323, 'duration': 6.782}, {'end': 2052.286, 'text': 'So there are different predefined timings in which you can.', 'start': 2049.364, 'duration': 2.922}, {'end': 2055.054, 'text': 'schedule the refresh of your report.', 'start': 2053.492, 'duration': 1.562}, {'end': 2060.077, 'text': 'The person who asked the question.', 'start': 2057.835, 'duration': 2.242}, {'end': 2062.819, 'text': 'does that answer your question, or was it something else??', 'start': 2060.077, 'duration': 2.742}, {'end': 2075.068, 'text': 'Okay, so, just in case, if anyone has any further question with respect to scheduling, just follow this particular link and it will guide you further.', 'start': 2063.9, 'duration': 11.168}], 'summary': 'Report can be scheduled to refresh every 15 minutes, end of month, or every four hours.', 'duration': 32.745, 'max_score': 2042.323, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I2042323.jpg'}, {'end': 2192.319, 'src': 'embed', 'start': 2164.29, 'weight': 1, 'content': [{'end': 2170.814, 'text': "There's a practical application sitting in front of you which you have to replicate in Tableau and make it better, of course.", 'start': 2164.29, 'duration': 6.524}, {'end': 2176.417, 'text': "Visually appealing and Tableau's fast engine slicing and dicing ability, all these things you have to apply.", 'start': 2171.054, 'duration': 5.363}, {'end': 2179.018, 'text': 'These projects will be easier to handle.', 'start': 2177.317, 'duration': 1.701}, {'end': 2184.917, 'text': "Mostly it'll win you a lot of accolades and appreciation.", 'start': 2181.736, 'duration': 3.181}, {'end': 2186.838, 'text': 'Then you have brand new projects.', 'start': 2185.397, 'duration': 1.441}, {'end': 2192.319, 'text': "Brand new projects as in like, business doesn't know what it wants.", 'start': 2186.958, 'duration': 5.361}], 'summary': 'Replicate and improve practical applications in tableau for easier handling and winning accolades.', 'duration': 28.029, 'max_score': 2164.29, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I2164290.jpg'}, {'end': 2325.696, 'src': 'embed', 'start': 2298.399, 'weight': 3, 'content': [{'end': 2302.666, 'text': 'Okay, so you will know in and out of your data once you come out of the Tableau environment.', 'start': 2298.399, 'duration': 4.267}, {'end': 2304.068, 'text': "You'll slice and dice the data.", 'start': 2302.906, 'duration': 1.162}, {'end': 2306.171, 'text': 'You can go to any level in Tableau.', 'start': 2304.088, 'duration': 2.083}, {'end': 2310.918, 'text': 'So exploratory research to guide predictive modeling is done quite commonly in Tableau.', 'start': 2306.191, 'duration': 4.727}, {'end': 2315.747, 'text': "So you'll pull your data, you'll create scatterplot, you'll create some bar charts and you'll see how the trend is moving.", 'start': 2311.263, 'duration': 4.484}, {'end': 2325.696, 'text': 'And then you will deploy predictive models where you find interesting trends or where you see there is potential of predictive modeling to bring out some good results.', 'start': 2316.007, 'duration': 9.689}], 'summary': 'Tableau enables in-depth data analysis and predictive modeling with various visualizations.', 'duration': 27.297, 'max_score': 2298.399, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I2298399.jpg'}], 'start': 1759.61, 'title': 'Tableau performance optimization', 'summary': 'Covers performance optimization tips for tableau, including breaking down calculations, removing unneeded dimensions, utilizing hierarchy, context filters, and scheduled report refresh times. it also discusses different types of tableau projects and their potential impact.', 'chapters': [{'end': 1899.271, 'start': 1759.61, 'title': 'Performance optimization tips for tableau', 'summary': 'Discusses performance optimization tips for tableau, including the benefits of breaking down calculations into separate variables and removing unneeded dimensions or measures to improve aggregation speed and visualization performance.', 'duration': 139.661, 'highlights': ['Breaking down calculations into separate variables can optimize row level calculation and improve aggregation speed in Tableau.', 'Removing unneeded dimensions or measures from the visualization shelf can enhance performance and speed up visualization rendering.', 'Revisiting the visualization shelf to eliminate any extra items that are not needed, particularly in the detail section, can contribute to improving the performance and speed of Tableau dashboards.']}, {'end': 2444.051, 'start': 1899.271, 'title': 'Optimizing tableau performance and project types', 'summary': 'Discusses tips for optimizing tableau performance, including avoiding large tabular structures and utilizing hierarchy, context filters, and scheduled report refresh times. it also outlines different types of tableau projects and their potential impact, such as migration projects, brand new projects, ad hoc reporting, and exploratory research for predictive modeling.', 'duration': 544.78, 'highlights': ['Utilize hierarchy and plus/minus features to avoid performance impact from large tables Creating hierarchy and enabling plus/minus features for large tables can prevent performance slowdowns, especially when dealing with hierarchically broken down data, such as global sales by region, country, state, and city levels.', 'Optimize dashboard performance using context filters Context filters can be utilized to optimize the performance of Tableau dashboards, providing a method for improving dashboard speed and responsiveness by focusing on specific data subsets.', 'Schedule report refresh times for improved performance Tableau allows for scheduled report refreshes at predefined intervals, such as every 15 minutes, end of a month, or every four hours, contributing to improved data currency and overall performance.', 'Types of Tableau projects and their impact Different types of Tableau projects include migration projects, brand new projects, ad hoc reporting, and exploratory research for predictive modeling, each with varying levels of complexity, potential impact, and specific considerations.', 'Involvement of business people in dashboard design Involving business stakeholders in dashboard design through recurring meetings and continuous feedback can significantly influence the success and relevance of the end product, especially in migration and brand new projects.']}], 'duration': 684.441, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I1759610.jpg', 'highlights': ['Utilize hierarchy and plus/minus features to avoid performance impact from large tables', 'Optimize dashboard performance using context filters', 'Schedule report refresh times for improved performance', 'Breaking down calculations into separate variables can optimize row level calculation and improve aggregation speed in Tableau', 'Removing unneeded dimensions or measures from the visualization shelf can enhance performance and speed up visualization rendering', 'Revisiting the visualization shelf to eliminate any extra items that are not needed can contribute to improving the performance and speed of Tableau dashboards', 'Types of Tableau projects and their impact', 'Involvement of business people in dashboard design']}, {'end': 3082.853, 'segs': [{'end': 2592.094, 'src': 'embed', 'start': 2542.893, 'weight': 1, 'content': [{'end': 2551.781, 'text': 'Show your users that they can click on one section of the pie then another section of the histogram, and then the bar chart will auto filter.', 'start': 2542.893, 'duration': 8.888}, {'end': 2557.244, 'text': 'So they can choose male employees between age of 45 to 60.', 'start': 2552.481, 'duration': 4.763}, {'end': 2564.769, 'text': 'They can choose female employees between age of 25 to 35, and they can see the numbers, how many employees are working in each department.', 'start': 2557.244, 'duration': 7.525}, {'end': 2569.672, 'text': 'These drill down capabilities of Tableau you should utilize to the fullest.', 'start': 2565.029, 'duration': 4.643}, {'end': 2574.699, 'text': 'Also, Please include actionable information.', 'start': 2571.633, 'duration': 3.066}, {'end': 2582.345, 'text': 'Some information which might be very relevant and interesting to you might not be actionable to your end users.', 'start': 2575.359, 'duration': 6.986}, {'end': 2586.589, 'text': 'You may show them that your sales is decreasing.', 'start': 2583.006, 'duration': 3.583}, {'end': 2592.094, 'text': "They might be knowing it already or even if they're not knowing it, it's just going to panic them.", 'start': 2587.73, 'duration': 4.364}], 'summary': "Utilize tableau's drill down capabilities to show users gender and age-specific employee numbers and department distribution, and ensure the information presented is actionable.", 'duration': 49.201, 'max_score': 2542.893, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I2542893.jpg'}, {'end': 2896.037, 'src': 'embed', 'start': 2837.197, 'weight': 0, 'content': [{'end': 2842.679, 'text': "Then we have PMO, project management office, which have, let's say, 10 people only.", 'start': 2837.197, 'duration': 5.482}, {'end': 2850.264, 'text': 'I want to see bifurcation of male and female in these three departments.', 'start': 2843.86, 'duration': 6.404}, {'end': 2854.146, 'text': 'I want to compare which has a healthy gender ratio.', 'start': 2850.384, 'duration': 3.762}, {'end': 2855.867, 'text': 'What should I show?', 'start': 2854.566, 'duration': 1.301}, {'end': 2857.608, 'text': 'real values or percentage values?', 'start': 2855.867, 'duration': 1.741}, {'end': 2861.631, 'text': 'Percentage values is what we should be showing right?', 'start': 2858.369, 'duration': 3.262}, {'end': 2865.814, 'text': 'Because you cannot compare apple and oranges.', 'start': 2861.991, 'duration': 3.823}, {'end': 2876.194, 'text': 'Okay, so if you say, There are 100 female in testing and there are only 40 female in HR.', 'start': 2866.074, 'duration': 10.12}, {'end': 2884.315, 'text': "That will present a very wrong picture because 100 female out of 500 in testing, that's like 20%.", 'start': 2877.275, 'duration': 7.04}, {'end': 2888.236, 'text': "and 40 female out of 50 in HR, that's like 80%.", 'start': 2884.315, 'duration': 3.921}, {'end': 2889.296, 'text': "So there's no comparison.", 'start': 2888.236, 'duration': 1.06}, {'end': 2893.457, 'text': 'The gender ratio is probably, you know, the female ratio is much more higher in HR.', 'start': 2889.716, 'duration': 3.741}, {'end': 2896.037, 'text': 'So here you need to show percentage value.', 'start': 2893.777, 'duration': 2.26}], 'summary': 'Analyze gender ratio in pmo, testing, and hr departments using percentage values for accurate comparison.', 'duration': 58.84, 'max_score': 2837.197, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I2837197.jpg'}, {'end': 2996.781, 'src': 'embed', 'start': 2958.659, 'weight': 4, 'content': [{'end': 2966.142, 'text': "Whenever I'm going to use female anywhere else, maybe if I'm going to say let's talk about terminations, how many female got terminated?", 'start': 2958.659, 'duration': 7.483}, {'end': 2967.683, 'text': 'how many male got terminated like that?', 'start': 2966.142, 'duration': 1.541}, {'end': 2969.964, 'text': 'So I will try to use the same color scheme.', 'start': 2968.023, 'duration': 1.941}, {'end': 2972.345, 'text': 'So be consistent and differential.', 'start': 2970.024, 'duration': 2.321}, {'end': 2976.947, 'text': 'Show applied filters for user ease.', 'start': 2973.185, 'duration': 3.762}, {'end': 2986.674, 'text': 'Now what happens is if your users have too many different filters, and especially if they are working across multiple dashboards.', 'start': 2977.447, 'duration': 9.227}, {'end': 2991.137, 'text': 'if you have provided them six, seven different dashboards and somehow you have linked these dashboards,', 'start': 2986.674, 'duration': 4.463}, {'end': 2996.781, 'text': 'so if they are applying filter in one area and they are actually looking at dashboard in some other place,', 'start': 2991.137, 'duration': 5.644}], 'summary': 'Use consistent color scheme, apply filters for user ease, link dashboards for efficient navigation.', 'duration': 38.122, 'max_score': 2958.659, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I2958659.jpg'}], 'start': 2444.432, 'title': 'Dashboard design and visualization best practices', 'summary': 'Emphasizes involving business people in dashboard design, iterative approach, drill down capabilities, and discouraging multiple histograms. it also focuses on actionable insights in tableau dashboards, simple and non-cluttered design, relevant filters, and consideration for colorblindness. additionally, it highlights visualization best practices such as presenting percentage values over numeric values, consistent and differential color coding, and displaying applied filters for user ease.', 'chapters': [{'end': 2564.769, 'start': 2444.432, 'title': 'Effective dashboard design for business success', 'summary': 'Emphasizes the importance of involving business people in dashboard design, using an iterative approach, and implementing drill down capabilities to enhance the chances of success. it also advocates against creating multiple histograms and instead utilizing the drill down capabilities of the dashboard.', 'duration': 120.337, 'highlights': ['Involving business people and seeking their feedback is crucial for the success of migration and brand new projects. Increased success rate of migration and brand new projects.', 'Using an iterative dashboard design approach by building certain components, gathering feedback, and then refining the dashboard leads to higher chances of success. Increased success rate of dashboard design projects.', 'Implementing drill down capabilities within the dashboard instead of creating separate charts for different conditions enhances user experience and efficiency. Improved user engagement and efficiency in data analysis.']}, {'end': 2812.116, 'start': 2565.029, 'title': 'Utilizing tableau for actionable insights', 'summary': 'Emphasizes the importance of actionable information in tableau dashboards, highlighting the need to keep it simple and non-cluttered, utilize relevant filters, and consider colorblindness when choosing color schemes, with a focus on improving user adoption and success.', 'duration': 247.087, 'highlights': ['The importance of actionable information in Tableau dashboards is emphasized, with a focus on simplicity and non-cluttered design to enhance user adoption and success.', 'Utilizing relevant filters in Tableau to show only relevant values, thereby reducing confusion and frustration for end users.', 'Consideration of colorblindness in dashboard design, including the use of shades instead of vibrant colors to ensure accessibility for all users.', 'The need to choose between percentage and real numeric value in data visualization to effectively convey information to the audience.']}, {'end': 3082.853, 'start': 2812.316, 'title': 'Visualization best practices', 'summary': 'Highlights the importance of showing percentage values over numeric values when presenting gender ratios in different departments, emphasizing the need for consistent and differential color coding and displaying applied filters for user ease.', 'duration': 270.537, 'highlights': ['Showing percentage values over numeric values is important when presenting gender ratios in different departments, as it provides a more accurate comparison and understanding of the gender distribution. Importance of using percentage values for gender ratios, example of comparing female ratios in testing and HR departments.', 'Emphasizes the need for consistent and differential color coding in visualizations, ensuring that the same color scheme is used for similar data across different dashboards to maintain consistency and differentiation. Importance of maintaining consistent and differential color coding, example of using specific colors for female employees and managerial employees.', 'Suggests displaying applied filters for user ease, especially when users are working across multiple linked dashboards, to provide visibility into the filters they have applied and facilitate their analytical process. The importance of displaying applied filters for user ease, example of displaying applied filters such as gender and department name.']}], 'duration': 638.421, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I2444432.jpg', 'highlights': ['Involving business people and seeking their feedback is crucial for the success of migration and brand new projects. Increased success rate of migration and brand new projects.', 'Using an iterative dashboard design approach by building certain components, gathering feedback, and then refining the dashboard leads to higher chances of success. Increased success rate of dashboard design projects.', 'Implementing drill down capabilities within the dashboard instead of creating separate charts for different conditions enhances user experience and efficiency. Improved user engagement and efficiency in data analysis.', 'The importance of actionable information in Tableau dashboards is emphasized, with a focus on simplicity and non-cluttered design to enhance user adoption and success.', 'Utilizing relevant filters in Tableau to show only relevant values, thereby reducing confusion and frustration for end users.', 'Consideration of colorblindness in dashboard design, including the use of shades instead of vibrant colors to ensure accessibility for all users.', 'Showing percentage values over numeric values is important when presenting gender ratios in different departments, as it provides a more accurate comparison and understanding of the gender distribution. Importance of using percentage values for gender ratios, example of comparing female ratios in testing and HR departments.', 'Emphasizes the need for consistent and differential color coding in visualizations, ensuring that the same color scheme is used for similar data across different dashboards to maintain consistency and differentiation. Importance of maintaining consistent and differential color coding, example of using specific colors for female employees and managerial employees.', 'Suggests displaying applied filters for user ease, especially when users are working across multiple linked dashboards, to provide visibility into the filters they have applied and facilitate their analytical process. The importance of displaying applied filters for user ease, example of displaying applied filters such as gender and department name.', 'The need to choose between percentage and real numeric value in data visualization to effectively convey information to the audience.']}, {'end': 4093.535, 'segs': [{'end': 3161.332, 'src': 'embed', 'start': 3130.779, 'weight': 1, 'content': [{'end': 3131.96, 'text': 'what filters they have applied.', 'start': 3130.779, 'duration': 1.181}, {'end': 3133.561, 'text': 'Otherwise, people will get confused.', 'start': 3132.16, 'duration': 1.401}, {'end': 3135.082, 'text': "They'll absorb some other information.", 'start': 3133.581, 'duration': 1.501}, {'end': 3137.263, 'text': "They'll make different interpretation out of it.", 'start': 3135.502, 'duration': 1.761}, {'end': 3140.926, 'text': 'They might not even be aware they are looking at only female population.', 'start': 3137.784, 'duration': 3.142}, {'end': 3143.667, 'text': "They'll assume that it's for all employees.", 'start': 3141.326, 'duration': 2.341}, {'end': 3149.251, 'text': 'So show applied filters for user ease.', 'start': 3146.929, 'duration': 2.322}, {'end': 3150.672, 'text': "It's a good idea.", 'start': 3150.051, 'duration': 0.621}, {'end': 3153.153, 'text': 'And test your dashboard on different screens.', 'start': 3151.192, 'duration': 1.961}, {'end': 3157.696, 'text': 'I would recommend using this particular feature of Tableau.', 'start': 3154.314, 'duration': 3.382}, {'end': 3161.332, 'text': 'Go to dashboard, keep a fixed size.', 'start': 3158.47, 'duration': 2.862}], 'summary': 'Recommend showing applied filters for user ease and testing dashboard on different screens for better usability.', 'duration': 30.553, 'max_score': 3130.779, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I3130779.jpg'}, {'end': 3526.124, 'src': 'embed', 'start': 3499.184, 'weight': 4, 'content': [{'end': 3504.609, 'text': "First thing you need to know and of course I'm sure most of you might be knowing it already there's a primary data source.", 'start': 3499.184, 'duration': 5.425}, {'end': 3505.81, 'text': "there's a secondary data source.", 'start': 3504.609, 'duration': 1.201}, {'end': 3509.112, 'text': 'primary data source looks up in blue.', 'start': 3505.81, 'duration': 3.302}, {'end': 3511.494, 'text': 'secondary data source shows up in orange.', 'start': 3509.112, 'duration': 2.382}, {'end': 3520.582, 'text': 'The first field which you are going to pull up into your Tableau environment in your particular sheet that is going to define your primary data source.', 'start': 3512.035, 'duration': 8.547}, {'end': 3523.184, 'text': "There's no set primary data source.", 'start': 3520.622, 'duration': 2.562}, {'end': 3526.124, 'text': "Let's say we have sales and promotion.", 'start': 3523.903, 'duration': 2.221}], 'summary': 'Understanding primary and secondary data sources is crucial for tableau integration.', 'duration': 26.94, 'max_score': 3499.184, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I3499184.jpg'}, {'end': 3585.849, 'src': 'embed', 'start': 3548.253, 'weight': 0, 'content': [{'end': 3568.508, 'text': "New data source, Excel, and I'm going to connect to HRV1 and I'm going to connect to, let's say, performance rating, okay, performance rating.", 'start': 3548.253, 'duration': 20.255}, {'end': 3570.528, 'text': "And I'll go back to this sheet.", 'start': 3569.048, 'duration': 1.48}, {'end': 3573.569, 'text': "So I've connected to performance rating.", 'start': 3572.109, 'duration': 1.46}, {'end': 3578.33, 'text': 'Now I have two containers, okay, one and two.', 'start': 3574.969, 'duration': 3.361}, {'end': 3583.828, 'text': "If I'm going to build a view, let's say I take last rating into this field.", 'start': 3579.364, 'duration': 4.464}, {'end': 3585.849, 'text': 'This becomes my primary data source.', 'start': 3583.948, 'duration': 1.901}], 'summary': 'Connecting excel to hrv1 and performance rating, resulting in primary data source.', 'duration': 37.596, 'max_score': 3548.253, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I3548253.jpg'}, {'end': 3868.655, 'src': 'embed', 'start': 3835.613, 'weight': 2, 'content': [{'end': 3838.035, 'text': 'Now let me just pull up number of employees.', 'start': 3835.613, 'duration': 2.422}, {'end': 3840.777, 'text': "I'm gonna pull up number of employees.", 'start': 3839.316, 'duration': 1.461}, {'end': 3845.561, 'text': "And I'm going to apply a filter on department.", 'start': 3841.878, 'duration': 3.683}, {'end': 3847.403, 'text': 'Let me apply a filter on department.', 'start': 3845.902, 'duration': 1.501}, {'end': 3851.091, 'text': 'Okay, so you will not be able to see quick filters.', 'start': 3848.41, 'duration': 2.681}, {'end': 3852.411, 'text': 'You can just drag it here.', 'start': 3851.151, 'duration': 1.26}, {'end': 3855.232, 'text': 'And then you can choose certain departments.', 'start': 3852.431, 'duration': 2.801}, {'end': 3858.853, 'text': "Let's say I choose development and HR only.", 'start': 3855.752, 'duration': 3.101}, {'end': 3860.533, 'text': 'Say apply, okay.', 'start': 3858.873, 'duration': 1.66}, {'end': 3863.074, 'text': 'And you can actually apply this filter.', 'start': 3861.353, 'duration': 1.721}, {'end': 3868.655, 'text': 'And then once you have dropped your field in this filter section, then you can right click and choose show quick filter.', 'start': 3863.294, 'duration': 5.361}], 'summary': 'Demonstration of applying filters on employee data for specific departments.', 'duration': 33.042, 'max_score': 3835.613, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I3835613.jpg'}], 'start': 3083.974, 'title': 'Tableau dashboard best practices, mobile dashboard view, and data blending', 'summary': 'Covers best practices for tableau dashboards including applied filters, fixed size, and data blending, optimizing for mobile, connecting to databases, and the process of data blending with focus on user ease and effective visualization.', 'chapters': [{'end': 3267.424, 'start': 3083.974, 'title': 'Tableau dashboard best practices', 'summary': 'Emphasizes the importance of showing applied filters, using fixed dashboard size, and checking on different screens for user ease, and recommends against choosing automatic size for dashboards while also providing tips for effective data blending in tableau.', 'duration': 183.45, 'highlights': ['Importance of showing applied filters Showing applied filters is imperative to avoid confusion and misinterpretation, especially when using action filters, as it helps users understand the specific data they are viewing and make informed decisions.', 'Using fixed dashboard size Choosing a fixed dashboard size is recommended to ensure consistent display across different screens, as the automatic size option can lead to distortion and inconsistent visualization, which is crucial when projecting or sharing dashboards with different users.', "Recommendation for effective data blending When conducting data blending in Tableau, it's important to keep in mind that the primary data source will be displayed in blue, and the secondary data source will be displayed in orange, providing a visual distinction that aids in understanding the blended data."]}, {'end': 3724.08, 'start': 3268.464, 'title': 'Mobile dashboard view and database connection', 'summary': 'Discusses optimizing dashboards for mobile devices, connecting tableau to a database, and blending data sources, with a focus on responsive design and data integration.', 'duration': 455.616, 'highlights': ['You can optimize the view for mobile devices by defining exact width and height or choosing automatic, but choosing automatic will change the aspect ratio of charts, making it challenging. Options for optimizing dashboard view for mobile devices by defining exact width and height or choosing automatic, with the latter affecting the aspect ratio of charts.', 'Connecting Tableau to a database involves accessing Tableau Data Server or choosing a new data source, with options to connect to MS SQL and other databases, providing credentials, and creating live or extract connections. Process of connecting Tableau to a database, including accessing Tableau Data Server, choosing a new data source, connecting to MS SQL and other databases, providing credentials, and creating live or extract connections.', 'Data blending in Tableau involves defining primary and secondary data sources, using a default blend equivalent to a left outer join, and simulating left and right joins by switching primary and secondary data sources. Process of data blending in Tableau, including defining primary and secondary data sources, using a default blend equivalent to a left outer join, and simulating left and right joins by switching primary and secondary data sources.']}, {'end': 4093.535, 'start': 3724.521, 'title': 'Data blending in tableau', 'summary': 'Covers the process of data blending in tableau, including enabling blending feature, creating calculated fields, applying filters, and the impact of blending on the scope of analysis and visualization.', 'duration': 369.014, 'highlights': ['The correct field for blending should be employee ID and enabling it is crucial to avoid seeing the star symbol, indicating insufficient data for blending. Enabling blending based on employee ID is crucial to avoid insufficient data for blending, indicated by the star symbol.', 'Applying filters in blended data using quick filters and parameters is possible, allowing for refined data visualization and analysis. Applying filters in blended data using quick filters and parameters allows for refined data visualization and analysis.', 'Blending data between different fields like arrival and departure airport impacts the scope of analysis, requiring careful consideration during visualization. Blending data between different fields impacts the scope of analysis, requiring careful consideration during visualization.']}], 'duration': 1009.561, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I3083974.jpg', 'highlights': ['Importance of showing applied filters to avoid confusion and misinterpretation', 'Using fixed dashboard size for consistent display across different screens', 'Recommendation for effective data blending with visual distinction for primary and secondary data sources', 'Options for optimizing dashboard view for mobile devices by defining exact width and height or choosing automatic', 'Process of connecting Tableau to a database, including accessing Tableau Data Server and choosing a new data source', 'Process of data blending in Tableau, including defining primary and secondary data sources and using a default blend equivalent to a left outer join', 'Enabling blending based on employee ID is crucial to avoid insufficient data for blending', 'Applying filters in blended data using quick filters and parameters for refined data visualization and analysis', 'Blending data between different fields impacts the scope of analysis, requiring careful consideration during visualization']}, {'end': 5549.749, 'segs': [{'end': 4143.716, 'src': 'embed', 'start': 4094.675, 'weight': 1, 'content': [{'end': 4102.171, 'text': 'Is that okay? Make sense to all of us? We can, blend more than one data source, of course.', 'start': 4094.675, 'duration': 7.496}, {'end': 4106.274, 'text': 'Let me just, you know, since you have asked this question, let me show it practically to you.', 'start': 4102.432, 'duration': 3.842}, {'end': 4108.356, 'text': 'We may go a little bit overboard.', 'start': 4106.435, 'duration': 1.921}, {'end': 4109.817, 'text': "I'm sorry about that.", 'start': 4108.376, 'duration': 1.441}, {'end': 4112.138, 'text': 'We may go a little bit overboard.', 'start': 4110.596, 'duration': 1.542}, {'end': 4118.742, 'text': "Our designated time, I think, was till 10.30, and we'll be going a little bit overboard.", 'start': 4113.019, 'duration': 5.723}, {'end': 4120.383, 'text': 'So here it is.', 'start': 4119.702, 'duration': 0.681}, {'end': 4125.054, 'text': "Airlines dashboard, it's going to take a bit of time to open up.", 'start': 4121.773, 'duration': 3.281}, {'end': 4132.234, 'text': "So I'm just going to continue with the session and then we'll come back to it and I'll show you this example where I've blended more than one data,", 'start': 4125.413, 'duration': 6.821}, {'end': 4134.555, 'text': "where I've blended one data source more than once.", 'start': 4132.234, 'duration': 2.321}, {'end': 4138.916, 'text': "There's just one data source and I have brought it twice in this dashboard.", 'start': 4135.175, 'duration': 3.741}, {'end': 4143.716, 'text': "Okay, so in the meanwhile, it's opening up.", 'start': 4141.536, 'duration': 2.18}], 'summary': 'Demonstrating blending of multiple data sources practically, going slightly over scheduled time', 'duration': 49.041, 'max_score': 4094.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I4094675.jpg'}, {'end': 4283.838, 'src': 'embed', 'start': 4257.757, 'weight': 2, 'content': [{'end': 4263.674, 'text': 'Scatter plot, is used to show the relationship between two continuous numeric variable.', 'start': 4257.757, 'duration': 5.917}, {'end': 4269.155, 'text': 'When you want to explore the relationship between two continuous numeric variable, you use a scatter plot.', 'start': 4264.134, 'duration': 5.021}, {'end': 4275.736, 'text': 'So for example, salary of an employee versus age of the employee.', 'start': 4269.955, 'duration': 5.781}, {'end': 4280.317, 'text': 'You want to see if older employees are getting paid more than younger employees.', 'start': 4276.017, 'duration': 4.3}, {'end': 4283.838, 'text': "Or maybe experience of the employee versus the salary he's getting.", 'start': 4280.658, 'duration': 3.18}], 'summary': 'Scatter plot shows relationship between numeric variables, e.g. salary vs. age or experience vs. salary.', 'duration': 26.081, 'max_score': 4257.757, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I4257757.jpg'}, {'end': 4359.801, 'src': 'embed', 'start': 4329.328, 'weight': 3, 'content': [{'end': 4334.931, 'text': 'Histogram is used to show the distribution of continuous numeric variable.', 'start': 4329.328, 'duration': 5.603}, {'end': 4341.293, 'text': 'whether employees on average, they are earning on higher side or they are earning on lower side.', 'start': 4335.851, 'duration': 5.442}, {'end': 4344.314, 'text': 'Then we have box plot.', 'start': 4342.994, 'duration': 1.32}, {'end': 4350.657, 'text': 'Box plot again shows distribution of continuous numeric variable, but mostly used for exploration.', 'start': 4344.554, 'duration': 6.103}, {'end': 4353.258, 'text': 'It will also highlight the outliers for you.', 'start': 4350.737, 'duration': 2.521}, {'end': 4359.801, 'text': "So it'll point out each and every individual data point on a particular box plot.", 'start': 4354.298, 'duration': 5.503}], 'summary': 'Histogram and box plot display data distribution and outliers for continuous numeric variables.', 'duration': 30.473, 'max_score': 4329.328, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I4329328.jpg'}, {'end': 4853.304, 'src': 'embed', 'start': 4827.12, 'weight': 12, 'content': [{'end': 4831.323, 'text': 'As you can see, I blended the same data twice, once for arrival, once for departure.', 'start': 4827.12, 'duration': 4.203}, {'end': 4842.274, 'text': 'Does that give you some idea about data blending workarounds? Okay, and you can also overlay other charts over your geospatial map.', 'start': 4833.004, 'duration': 9.27}, {'end': 4847.079, 'text': 'So for example, you can create a pie chart on your geospatial map.', 'start': 4842.294, 'duration': 4.785}, {'end': 4847.759, 'text': 'You can do that.', 'start': 4847.219, 'duration': 0.54}, {'end': 4850.181, 'text': "Just in case if you're not aware already.", 'start': 4848.7, 'duration': 1.481}, {'end': 4853.304, 'text': 'Let me show you an example of that.', 'start': 4851.122, 'duration': 2.182}], 'summary': 'Data can be blended for arrival and departure, and charts can be overlaid on geospatial maps.', 'duration': 26.184, 'max_score': 4827.12, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I4827120.jpg'}, {'end': 4904.691, 'src': 'embed', 'start': 4876.828, 'weight': 4, 'content': [{'end': 4879.909, 'text': 'Okay, so these kind of things are possible.', 'start': 4876.828, 'duration': 3.081}, {'end': 4882.43, 'text': 'So this list can actually be very long.', 'start': 4880.229, 'duration': 2.201}, {'end': 4884.79, 'text': 'And there are several different workarounds.', 'start': 4883.11, 'duration': 1.68}, {'end': 4885.351, 'text': 'Just keep your.', 'start': 4884.83, 'duration': 0.521}, {'end': 4891.309, 'text': 'eye open, keep your interest intact in Tableau and you will learn a lot of workarounds there.', 'start': 4887.248, 'duration': 4.061}, {'end': 4892.989, 'text': 'Wonderful thing people have done.', 'start': 4891.569, 'duration': 1.42}, {'end': 4900.07, 'text': 'One place where I would suggest you can explore these workarounds is Tableau public server.', 'start': 4893.569, 'duration': 6.501}, {'end': 4904.691, 'text': 'So people publish their work on Tableau public server and they have done wonderful job.', 'start': 4900.27, 'duration': 4.421}], 'summary': 'Tableau offers numerous workarounds, with a wide range of possibilities for users to explore and learn from on tableau public server.', 'duration': 27.863, 'max_score': 4876.828, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I4876828.jpg'}, {'end': 5022.107, 'src': 'embed', 'start': 4970.779, 'weight': 5, 'content': [{'end': 4972.22, 'text': 'You want to calculate something like this.', 'start': 4970.779, 'duration': 1.441}, {'end': 4977.042, 'text': 'Salary of an individual minus average salary of the entire 100 people group.', 'start': 4972.62, 'duration': 4.422}, {'end': 4981.524, 'text': 'If you were going to try this in earlier version of Tableau, you will get this error.', 'start': 4977.702, 'duration': 3.822}, {'end': 4984.985, 'text': 'Cannot mix aggregate and non-aggregate arguments with this function.', 'start': 4981.944, 'duration': 3.041}, {'end': 4989.567, 'text': 'Level of details are a way to address this problem.', 'start': 4985.745, 'duration': 3.822}, {'end': 4993.964, 'text': "Okay, and it's a big topic and needs a lot of discussion.", 'start': 4990.382, 'duration': 3.582}, {'end': 4997.106, 'text': "Due to lack of time, we won't be able to take it up.", 'start': 4995.385, 'duration': 1.721}, {'end': 4999.527, 'text': 'So you can read more about them here.', 'start': 4997.646, 'duration': 1.881}, {'end': 5001.928, 'text': "It's pretty simple, straightforward, no rocket science.", 'start': 4999.627, 'duration': 2.301}, {'end': 5008.953, 'text': 'There is this Syntax which you need to be aware of level of details expression expression.', 'start': 5002.508, 'duration': 6.445}, {'end': 5011.296, 'text': 'syntax. fixed, include, exclude.', 'start': 5008.953, 'duration': 2.343}, {'end': 5015.159, 'text': 'Okay, so, using fixed, you can talk about.', 'start': 5011.296, 'duration': 3.863}, {'end': 5020.125, 'text': "I'm sorry, using include, you can talk about.", 'start': 5015.159, 'duration': 4.966}, {'end': 5022.107, 'text': 'Dimensions and exclude.', 'start': 5020.125, 'duration': 1.982}], 'summary': 'Level of details in tableau help handle aggregate and non-aggregate data, such as salary calculations for individuals in a group of 100 people.', 'duration': 51.328, 'max_score': 4970.779, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I4970779.jpg'}, {'end': 5099.829, 'src': 'embed', 'start': 5069.234, 'weight': 17, 'content': [{'end': 5072.815, 'text': 'This particular error message was pretty nagging, let me tell you.', 'start': 5069.234, 'duration': 3.581}, {'end': 5079.537, 'text': "Lot of times I've tried to do things which didn't work out because of this particular limitation of Tableau and level of detail.", 'start': 5073.715, 'duration': 5.822}, {'end': 5085.239, 'text': "seems to be a pretty exciting feature to me and I'm pretty sure you're going to encounter it frequently.", 'start': 5079.537, 'duration': 5.702}, {'end': 5093.005, 'text': 'Extracts, what are extracts? Extracts will increase the performance of your dashboard.', 'start': 5087.981, 'duration': 5.024}, {'end': 5099.829, 'text': "It's a way in which Tableau will extract the data, keep it aside, optimize it for faster performance.", 'start': 5093.025, 'duration': 6.804}], 'summary': 'Tableau extracts optimize data for faster dashboard performance.', 'duration': 30.595, 'max_score': 5069.234, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5069234.jpg'}, {'end': 5140.17, 'src': 'embed', 'start': 5117.224, 'weight': 0, 'content': [{'end': 5125.386, 'text': "I'm not sure if it's available by default in Tableau 9.0 and above, but count the formula was not available by default.", 'start': 5117.224, 'duration': 8.162}, {'end': 5130.067, 'text': "Unless and until you're creating an extract, this distinct count formula was not available to you.", 'start': 5125.486, 'duration': 4.581}, {'end': 5132.048, 'text': 'Only for extracted data.', 'start': 5130.708, 'duration': 1.34}, {'end': 5136.789, 'text': "And you can control refresh on an ever-changing data source if you're using extract.", 'start': 5132.768, 'duration': 4.021}, {'end': 5140.17, 'text': 'If you make a live connection.', 'start': 5138.109, 'duration': 2.061}], 'summary': "Tableau 9.0+ doesn't have default count formula; distinct count only available for extracted data.", 'duration': 22.946, 'max_score': 5117.224, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5117224.jpg'}, {'end': 5354.417, 'src': 'embed', 'start': 5326.101, 'weight': 9, 'content': [{'end': 5330.103, 'text': 'then you want to filter data based on geographical location.', 'start': 5326.101, 'duration': 4.002}, {'end': 5332.365, 'text': "So let's say you have applied a filter on India.", 'start': 5330.444, 'duration': 1.921}, {'end': 5334.166, 'text': 'So what is Tableau going to do??', 'start': 5332.885, 'duration': 1.281}, {'end': 5344.311, 'text': "Tableau is going to apply filter on female employees and then again it's going to apply filter on all the data set, all the rows on India.", 'start': 5334.366, 'duration': 9.945}, {'end': 5346.733, 'text': 'And then it will show you that data.', 'start': 5345.172, 'duration': 1.561}, {'end': 5349.414, 'text': 'There are some drawbacks of it.', 'start': 5347.933, 'duration': 1.481}, {'end': 5354.417, 'text': 'So what happens is, let me show you an example.', 'start': 5349.874, 'duration': 4.543}], 'summary': 'Tableau filters data by geographical location and gender, with drawbacks.', 'duration': 28.316, 'max_score': 5326.101, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5326101.jpg'}, {'end': 5558.497, 'src': 'embed', 'start': 5531.113, 'weight': 8, 'content': [{'end': 5537.739, 'text': 'Context filter will create a temporary table and then other filters which you are going to apply will get applied on the context filter.', 'start': 5531.113, 'duration': 6.626}, {'end': 5544.464, 'text': "So it'll be level filter, one filter applied, second filter will get applied to the filter data, not all the data.", 'start': 5538.479, 'duration': 5.985}, {'end': 5549.749, 'text': 'Usually used for top end values, extracting top end values, these kind of things.', 'start': 5545.165, 'duration': 4.584}, {'end': 5558.497, 'text': "Okay, what is data blending? We have already discussed it, so I'm not going to go back to this discussion again.", 'start': 5552.495, 'duration': 6.002}], 'summary': 'Context filter applies subsequent filters to filtered data, often used for extracting top end values.', 'duration': 27.384, 'max_score': 5531.113, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5531113.jpg'}], 'start': 4094.675, 'title': 'Tableau functions and techniques', 'summary': 'Discusses tableau functions and techniques, including the use of level of detail expressions, benefits of using extracts to improve dashboard performance, and key concepts of data visualization and filter types, providing practical insights on blending multiple data sources and creating various types of charts and workarounds.', 'chapters': [{'end': 4143.716, 'start': 4094.675, 'title': 'Blending multiple data sources', 'summary': 'Discusses blending more than one data source practically in a session, despite going a little over the designated time, and demonstrates an example of blending one data source more than once in a dashboard.', 'duration': 49.041, 'highlights': ['The chapter demonstrates practically blending more than one data source and bringing one data source twice in a dashboard.', 'The speaker mentions going a little overboard and extending the designated time till 10.30.']}, {'end': 4546.796, 'start': 4143.917, 'title': 'Types of charts & tableau formulas', 'summary': 'Covers widely used charts including bar graph, line chart, pie chart, scatter plot, histogram, and box plot, highlighting their specific uses, and also explores tableau formulas and workarounds.', 'duration': 402.879, 'highlights': ['Bar chart is used to compare categorical data such as male vs female salary or number of male vs female employees. Bar chart is used to compare categorical data such as male vs female salary or number of male vs female employees.', 'Line chart is utilized to show trend over a period of time, such as sales progression. Line chart is utilized to show trend over a period of time, such as sales progression.', 'Pie chart is employed to display percentage contribution, particularly for up to three categories. Pie chart is employed to display percentage contribution, particularly for up to three categories.', 'Scatter plot is used to reveal the relationship between two continuous numeric variables, like salary vs age or experience vs salary. Scatter plot is used to reveal the relationship between two continuous numeric variables, like salary vs age or experience vs salary.', 'Histogram shows the distribution of a continuous numeric variable, useful for analyzing weight distribution or average earnings. Histogram shows the distribution of a continuous numeric variable, useful for analyzing weight distribution or average earnings.', 'Box plot is primarily used for exploration to demonstrate the distribution of continuous numeric variables and highlight outliers. Box plot is primarily used for exploration to demonstrate the distribution of continuous numeric variables and highlight outliers.', 'Tableau formulas and functions are discussed, including numeric, string, and date functions, with a reference guide provided for further learning. Tableau formulas and functions are discussed, including numeric, string, and date functions, with a reference guide provided for further learning.', 'LOD (Level of Detail) calculations, a recent feature introduced in Tableau version nine, are briefly mentioned as a particular feature of Tableau. LOD (Level of Detail) calculations, a recent feature introduced in Tableau version nine, are briefly mentioned as a particular feature of Tableau.', 'Various workarounds in Tableau, including performance optimization and data blending, are briefly touched upon. Various workarounds in Tableau, including performance optimization and data blending, are briefly touched upon.']}, {'end': 4927.934, 'start': 4546.796, 'title': 'Tableau tricks and workarounds', 'summary': 'Explores advanced chart creation in tableau, including 100% stacked bar charts and donut charts, as well as overlaying charts on geospatial maps, with a mention of infographics and tableau public server. additionally, it touches on data blending workarounds and the use of level of detail expressions in tableau 9.0.', 'duration': 381.138, 'highlights': ['The chapter explores advanced chart creation in Tableau, including 100% stacked bar charts and donut charts. The session covers the creation of advanced charts like 100% stacked bar charts and donut charts, which are not available by default in Tableau.', 'Overlaying charts on geospatial maps is discussed. The discussion includes overlaying charts like pie charts on geospatial maps in Tableau.', 'Infographics and Tableau Public server are mentioned. The session mentions the creation of infographics in Tableau and encourages exploration of Tableau Public server for examples of advanced Tableau work.', 'Data blending workarounds and the use of level of detail expressions in Tableau 9.0 are briefly touched upon. Additionally, the session briefly touches on data blending workarounds and the use of level of detail expressions, introduced in Tableau 9.0.']}, {'end': 5549.749, 'start': 4927.934, 'title': 'Tableau functions and techniques', 'summary': 'Discusses the use of level of details expressions to resolve mixing aggregate and non-aggregate functions, the benefits of using extracts in tableau to improve dashboard performance, and the key concepts of data visualization and filter types.', 'duration': 621.815, 'highlights': ['Level of details expressions help to resolve the issue of mixing aggregate and non-aggregate functions in Tableau, allowing for calculations such as individual salary minus average salary for a group of employees. Level of details expressions address the problem of mixing aggregate and non-aggregate functions in Tableau, enabling calculations like individual salary minus average salary for a group of employees.', 'Using extracts in Tableau improves dashboard performance by optimizing data and providing additional formulas like COUNTD, which are not available by default for live connections. Extracts in Tableau improve dashboard performance by optimizing data and providing additional formulas like COUNTD, which are not available by default for live connections.', 'Data visualization techniques aim to present information intuitively using visual techniques, enabling quick data analysis and allowing users to interact with the data through parameters. Data visualization techniques aim to present information intuitively using visual techniques, enabling quick data analysis and allowing users to interact with the data through parameters.', 'The different types of filters in Tableau include normal filters, quick filters, and context filters, with context filters creating a temporary table to speed up dashboard performance and are commonly used for extracting top-end values. The different types of filters in Tableau include normal filters, quick filters, and context filters, with context filters creating a temporary table to speed up dashboard performance and are commonly used for extracting top-end values.']}], 'duration': 1455.074, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I4094675.jpg', 'highlights': ['The chapter demonstrates practically blending more than one data source and bringing one data source twice in a dashboard.', 'Using extracts in Tableau improves dashboard performance by optimizing data and providing additional formulas like COUNTD, which are not available by default for live connections.', 'Data visualization techniques aim to present information intuitively using visual techniques, enabling quick data analysis and allowing users to interact with the data through parameters.', 'The different types of filters in Tableau include normal filters, quick filters, and context filters, with context filters creating a temporary table to speed up dashboard performance and are commonly used for extracting top-end values.', 'Level of details expressions help to resolve the issue of mixing aggregate and non-aggregate functions in Tableau, allowing for calculations such as individual salary minus average salary for a group of employees.', 'The chapter explores advanced chart creation in Tableau, including 100% stacked bar charts and donut charts.', 'Overlaying charts on geospatial maps is discussed. The discussion includes overlaying charts like pie charts on geospatial maps in Tableau.', 'Infographics and Tableau Public server are mentioned. The session mentions the creation of infographics in Tableau and encourages exploration of Tableau Public server for examples of advanced Tableau work.', 'Bar chart is used to compare categorical data such as male vs female salary or number of male vs female employees.', 'Line chart is utilized to show trend over a period of time, such as sales progression.', 'Pie chart is employed to display percentage contribution, particularly for up to three categories.', 'Scatter plot is used to reveal the relationship between two continuous numeric variables, like salary vs age or experience vs salary.', 'Histogram shows the distribution of a continuous numeric variable, useful for analyzing weight distribution or average earnings.', 'Box plot is primarily used for exploration to demonstrate the distribution of continuous numeric variables and highlight outliers.', 'Tableau formulas and functions are discussed, including numeric, string, and date functions, with a reference guide provided for further learning.', 'LOD (Level of Detail) calculations, a recent feature introduced in Tableau version nine, are briefly mentioned as a particular feature of Tableau.', 'Various workarounds in Tableau, including performance optimization and data blending, are briefly touched upon.', 'Data blending workarounds and the use of level of detail expressions in Tableau 9.0 are briefly touched upon. Additionally, the session briefly touches on data blending workarounds and the use of level of detail expressions, introduced in Tableau 9.0.']}, {'end': 6495.573, 'segs': [{'end': 5649.972, 'src': 'embed', 'start': 5596.894, 'weight': 1, 'content': [{'end': 5600.257, 'text': 'It makes things more intuitive, straightforward and all.', 'start': 5596.894, 'duration': 3.363}, {'end': 5604.38, 'text': 'Data blending is generally used when you are working with different data sources.', 'start': 5601.238, 'duration': 3.142}, {'end': 5609.57, 'text': 'Stop me and ask me any questions you might have.', 'start': 5607.708, 'duration': 1.862}, {'end': 5617.897, 'text': "I just don't want it to be like a one-way communication where you're getting overwhelmed by the information I'm throwing to you.", 'start': 5609.97, 'duration': 7.927}, {'end': 5620.54, 'text': 'So just stop me and ask me any questions you might have.', 'start': 5618.358, 'duration': 2.182}, {'end': 5624.183, 'text': 'Another important question, this one is quite important actually.', 'start': 5621.621, 'duration': 2.562}, {'end': 5634.627, 'text': 'So what are the differences between TWB and TWBX? So TWB is general Tableau file, and TWB is Tableau packaged workbook.', 'start': 5624.784, 'duration': 9.843}, {'end': 5639.729, 'text': 'So TWB, Tableau workbook, and TWBX is Tableau packaged workbook.', 'start': 5635.007, 'duration': 4.722}, {'end': 5649.972, 'text': 'Tableau packaged workbook is like a complete set of data plus any image which you have kept in your dashboard,', 'start': 5640.189, 'duration': 9.783}], 'summary': 'Data blending enhances intuitive data integration. twb vs twbx differences explained.', 'duration': 53.078, 'max_score': 5596.894, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5596894.jpg'}, {'end': 5877.655, 'src': 'embed', 'start': 5820.338, 'weight': 0, 'content': [{'end': 5829.484, 'text': 'And these people, other people, associate, junior associate, senior associate, SME, support staff, these are individual performers.', 'start': 5820.338, 'duration': 9.146}, {'end': 5830.285, 'text': 'I can do that.', 'start': 5829.784, 'duration': 0.501}, {'end': 5832.246, 'text': 'I can say okay.', 'start': 5831.606, 'duration': 0.64}, {'end': 5835.628, 'text': 'This is how we create a group.', 'start': 5833.187, 'duration': 2.441}, {'end': 5836.569, 'text': 'Then we have set.', 'start': 5835.768, 'duration': 0.801}, {'end': 5840.351, 'text': 'In set what we do is we create a set.', 'start': 5837.149, 'duration': 3.202}, {'end': 5843.713, 'text': "So we'll say create and then we create a set.", 'start': 5840.471, 'duration': 3.242}, {'end': 5846.975, 'text': 'And then we can apply a condition.', 'start': 5845.514, 'duration': 1.461}, {'end': 5857.372, 'text': "Let's say you want to create a set of all those people whose average fixed salary is maybe greater than let's say 10.", 'start': 5847.595, 'duration': 9.777}, {'end': 5862.298, 'text': 'Okay, and you can say this is high earning people.', 'start': 5857.372, 'duration': 4.926}, {'end': 5864.961, 'text': 'So this is how you create a set.', 'start': 5862.318, 'duration': 2.643}, {'end': 5875.172, 'text': 'Okay, and then once you create a set, then what happens is you can pull this set into your analysis and maybe pull in some other details maybe.', 'start': 5865.882, 'duration': 9.29}, {'end': 5877.655, 'text': 'And then you can see this in and out.', 'start': 5875.733, 'duration': 1.922}], 'summary': 'Instruction on creating sets and applying conditions for analysis.', 'duration': 57.317, 'max_score': 5820.338, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5820338.jpg'}, {'end': 5940.451, 'src': 'embed', 'start': 5898.325, 'weight': 3, 'content': [{'end': 5902.846, 'text': 'So it can act as a filter on the fly if you choose this option, show member set.', 'start': 5898.325, 'duration': 4.521}, {'end': 5908.248, 'text': "If you choose this option, you'll see how many people are lying in that range, how many people are lying beyond that range.", 'start': 5903.126, 'duration': 5.122}, {'end': 5916.831, 'text': 'So basically they serve different purposes, but you can improvise them, use them along with formula and make them behave like each other.', 'start': 5908.528, 'duration': 8.303}, {'end': 5921.512, 'text': 'So for example, I can create a group and then I can create a formula on this.', 'start': 5916.931, 'duration': 4.581}, {'end': 5928.342, 'text': 'if else formula sort of, and then I can use it simultaneously to create like a set like feature.', 'start': 5922.517, 'duration': 5.825}, {'end': 5932.745, 'text': 'Also you can create unions and intersection in sets.', 'start': 5929.403, 'duration': 3.342}, {'end': 5934.607, 'text': 'I hope you are aware of all those things.', 'start': 5933.185, 'duration': 1.422}, {'end': 5940.451, 'text': 'So you can create a union of set, you can create an intersection of set, all these things you can do.', 'start': 5935.887, 'duration': 4.564}], 'summary': 'Filter and manipulate sets with formulas, unions, and intersections for various purposes.', 'duration': 42.126, 'max_score': 5898.325, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5898325.jpg'}], 'start': 5552.495, 'title': 'Tableau data blending', 'summary': "Covers tableau data blending, its use in combining data from different sources, emphasizing the advantages of joining over blending, explaining differences between twb and twbx file types, and detailing usage of tableau's page shelf and joining vs. blending data sources.", 'chapters': [{'end': 5620.54, 'start': 5552.495, 'title': 'Understanding data blending', 'summary': 'Discusses data blending, its use in combining data from different sources, and recommends data joining over blending when working with the same data source, emphasizing its intuitive and straightforward nature.', 'duration': 68.045, 'highlights': ['Data blending is used to combine data from different sources such as Excel, Oracle database, and Tableau server into a single view.', 'Data joining is recommended over data blending when working with the same data source, as it is more intuitive and straightforward.', 'Data blending is generally used when working with different data sources to create a comprehensive view.']}, {'end': 5940.451, 'start': 5621.621, 'title': 'Tableau file types and differences', 'summary': 'Explains the differences between twb and twbx file types in tableau, emphasizing the advantages of using twbx for sharing data, and also details the differences between groups and sets in tableau, showcasing their functionalities and use cases.', 'duration': 318.83, 'highlights': ['TWB contains only instructions for Tableau visualizations and no data, while TWBX is a complete set of data and images combined together into one zip file. TWB is just a set of instructions for Tableau to draw visualizations, while TWBX is a complete set of data and images combined together into one zip file.', 'It is suggested to always use TWBX when sharing Tableau work with someone who may not have access to the data, especially if images are embedded into the dashboard. It is recommended to always use TWBX when sharing Tableau work with someone who may not have access to the data, especially if images are embedded into the dashboard.', 'Groups in Tableau involve clubbing individual members together, while sets create an in and out feature based on specified conditions, and can be used as filters. Groups in Tableau involve clubbing individual members together, while sets create an in and out feature based on specified conditions, and can be used as filters.']}, {'end': 6165.902, 'start': 5941.372, 'title': 'Tableau page shelf & join vs. blend', 'summary': "Covers the usage of tableau's page shelf to create animation-like features and the differences between joining and blending data sources, emphasizing the advantages of joining. it also clarifies the concept of data blending in tableau and provides guidance on linking different data sources.", 'duration': 224.53, 'highlights': ["The usage of Tableau's page shelf to create animation-like features Tableau's page shelf allows the creation of animation-like features by displaying different department headcount trends over the past five years, enabling the visualization of various departments' data through separate pages.", 'Differences between joining and blending data sources Explains the distinction between joining and blending in Tableau, emphasizing that blending is used for data from different sources, while joining is preferred for data from the same source, highlighting the advantages and simplicity of using joins.', 'Clarification of the concept of data blending in Tableau Provides insights into the concept of data blending in Tableau, clarifying that it allows the integration of data from multiple sources into a single view, differentiating it from a traditional join.']}, {'end': 6495.573, 'start': 6165.902, 'title': 'Understanding data blending in tableau', 'summary': 'Explains the concept of data blending in tableau, highlighting its differences from data joining, its potential for innovative analysis, and the ability to emulate various types of joins. it also discusses blending of axes in tableau, detailing its application and the challenges encountered in using synchronized dual axes.', 'duration': 329.671, 'highlights': ['Data blending in Tableau allows bringing fields from different data sources together in one view, enabling innovative analysis and comparisons, such as aggregating sales data with monthly headcount from another source.', 'Data blending is a powerful feature in Tableau, offering flexibility in analysis but may encounter logical issues, which can be resolved by altering the blending scope.', 'Understanding how to emulate left join, right join, and inner join by setting primary and secondary data sources in Tableau can enhance data blending capabilities and analysis.', 'Blending of axes in Tableau enables the synchronization of measures on a single axis, providing a consolidated view of data, but users may encounter challenges in using synchronized dual axes, such as limitations in enabling this feature and scope-related issues.']}], 'duration': 943.078, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I5552495.jpg', 'highlights': ['Data blending combines data from different sources into a single view.', 'TWBX contains complete data and images, while TWB only contains instructions.', "Tableau's page shelf creates animation-like features for data visualization.", 'Data joining is recommended over blending for the same data source.', 'Understanding how to emulate left join, right join, and inner join enhances data blending capabilities.', 'Blending of axes in Tableau synchronizes measures on a single axis.']}, {'end': 8628.116, 'segs': [{'end': 6600.934, 'src': 'embed', 'start': 6570.983, 'weight': 8, 'content': [{'end': 6573.725, 'text': 'And you will say there seems to be a gender bias.', 'start': 6570.983, 'duration': 2.742}, {'end': 6575.595, 'text': 'if there is a gender bias.', 'start': 6574.694, 'duration': 0.901}, {'end': 6577.535, 'text': 'If you are investigating on gender bias.', 'start': 6575.915, 'duration': 1.62}, {'end': 6581.297, 'text': 'Third story point you can say where this gender bias is coming from.', 'start': 6577.875, 'duration': 3.422}, {'end': 6586.059, 'text': 'So you will say these are different departments where the gender bias is the highest.', 'start': 6582.397, 'duration': 3.662}, {'end': 6593.702, 'text': 'Then fourth story point, what might be the reason? You can provide some hyperlinks, some external sources for the reason.', 'start': 6587.099, 'duration': 6.603}, {'end': 6595.263, 'text': 'Then fifth story point.', 'start': 6594.202, 'duration': 1.061}, {'end': 6600.934, 'text': "Maybe you can show the revenue stream of those department which have healthy gender mix and probably they're better.", 'start': 6595.811, 'duration': 5.123}], 'summary': 'Investigate gender bias in different departments and its impact on revenue.', 'duration': 29.951, 'max_score': 6570.983, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I6570983.jpg'}, {'end': 6733.497, 'src': 'embed', 'start': 6703.692, 'weight': 1, 'content': [{'end': 6709.213, 'text': 'So discrete is something which has limited number of values.', 'start': 6703.692, 'duration': 5.521}, {'end': 6711.134, 'text': 'For example, your performance rating.', 'start': 6709.273, 'duration': 1.861}, {'end': 6717.696, 'text': "Let's say, your performance rating is given in value of one, two, three, four, five, where one is, let's say,", 'start': 6711.534, 'duration': 6.162}, {'end': 6720.496, 'text': 'the highest rating and five is the lowest rating.', 'start': 6717.696, 'duration': 2.8}, {'end': 6722.237, 'text': 'This becomes discrete data.', 'start': 6720.896, 'duration': 1.341}, {'end': 6726.978, 'text': 'A person can get a rating of one or two or three or four or five.', 'start': 6723.477, 'duration': 3.501}, {'end': 6733.497, 'text': 'Continuous data on the other hand takes continuous value, like it can contain any value.', 'start': 6727.918, 'duration': 5.579}], 'summary': 'Discrete data has limited values, while continuous data can take any value.', 'duration': 29.805, 'max_score': 6703.692, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I6703692.jpg'}, {'end': 7081.843, 'src': 'embed', 'start': 7059.134, 'weight': 9, 'content': [{'end': 7068.035, 'text': 'Seanak, when you say dynamic, what does it exactly mean? So of course parameters will be available to the users.', 'start': 7059.134, 'duration': 8.901}, {'end': 7075.356, 'text': 'They can change the value and based on the parameter, certain components of your dashboard can change, that can happen.', 'start': 7068.515, 'duration': 6.841}, {'end': 7081.843, 'text': 'So parameters by default are open to the end users, and they are supposed to see it all the time.', 'start': 7075.396, 'duration': 6.447}], 'summary': 'Dynamic parameters allow users to change dashboard values, affecting its components.', 'duration': 22.709, 'max_score': 7059.134, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I7059134.jpg'}, {'end': 7133.842, 'src': 'embed', 'start': 7104.891, 'weight': 10, 'content': [{'end': 7106.692, 'text': 'okay?, Perfect, thank you.', 'start': 7104.891, 'duration': 1.801}, {'end': 7111.188, 'text': 'Okay, so these are parameters.', 'start': 7109.867, 'duration': 1.321}, {'end': 7113.95, 'text': 'What are the difference between Tableau Desktop and Tableau Server?', 'start': 7111.288, 'duration': 2.662}, {'end': 7120.093, 'text': 'Tableau Desktop helps you create data visualization, workbook creation these kind of things it will help you do.', 'start': 7114.13, 'duration': 5.963}, {'end': 7125.317, 'text': 'Tableau Server is used to distribute these workbook to the end user.', 'start': 7120.394, 'duration': 4.923}, {'end': 7127.318, 'text': 'These workbook can be interactive.', 'start': 7125.377, 'duration': 1.941}, {'end': 7133.842, 'text': 'You can enable your users to apply filters, slice and dice the data pass value through parameters,', 'start': 7127.738, 'duration': 6.104}], 'summary': 'Tableau desktop creates visualizations, while tableau server distributes interactive workbooks to end users.', 'duration': 28.951, 'max_score': 7104.891, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I7104891.jpg'}, {'end': 7310.19, 'src': 'embed', 'start': 7281.035, 'weight': 12, 'content': [{'end': 7283.657, 'text': "I talked very briefly about it, I didn't build the context.", 'start': 7281.035, 'duration': 2.622}, {'end': 7290.242, 'text': "So if you get access to my recording, see the second session which I've taken.", 'start': 7284.197, 'duration': 6.045}, {'end': 7295.166, 'text': 'okay?. Second session I talk about which particular charts to use under what kind of situation.', 'start': 7290.242, 'duration': 4.924}, {'end': 7297.668, 'text': "I've presented that through examples as well.", 'start': 7295.927, 'duration': 1.741}, {'end': 7299.387, 'text': 'Think about it again.', 'start': 7298.547, 'duration': 0.84}, {'end': 7302.568, 'text': "I've just got one correct answer from Saba so far.", 'start': 7299.527, 'duration': 3.041}, {'end': 7305.309, 'text': 'Okay, so think about it this way.', 'start': 7303.788, 'duration': 1.521}, {'end': 7310.19, 'text': 'Let me just guide you here a little bit.', 'start': 7305.989, 'duration': 4.201}], 'summary': 'Discussed specific charts for different situations, with one correct answer received so far.', 'duration': 29.155, 'max_score': 7281.035, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I7281035.jpg'}, {'end': 7572.026, 'src': 'embed', 'start': 7521.32, 'weight': 11, 'content': [{'end': 7522.88, 'text': 'I want to visualize this information.', 'start': 7521.32, 'duration': 1.56}, {'end': 7530.786, 'text': 'Which chart do you suggest I should use? I want to show that good performance employees have higher salary.', 'start': 7523.62, 'duration': 7.166}, {'end': 7536.891, 'text': 'Average performance employees have somewhere in between and low performance employees have lowest salary.', 'start': 7531.447, 'duration': 5.444}, {'end': 7537.932, 'text': 'This is what I want to show.', 'start': 7537.011, 'duration': 0.921}, {'end': 7539.994, 'text': 'This makes logical sense as well.', 'start': 7538.592, 'duration': 1.402}, {'end': 7541.995, 'text': 'Business wants to validate it.', 'start': 7540.674, 'duration': 1.321}, {'end': 7544.337, 'text': 'I want to visualize it.', 'start': 7543.456, 'duration': 0.881}, {'end': 7549.121, 'text': 'Which chart would you prefer? Think about it and answer please.', 'start': 7544.537, 'duration': 4.584}, {'end': 7555.466, 'text': "Okay, I've got one answer from Chaitanya which is right.", 'start': 7551.903, 'duration': 3.563}, {'end': 7561.86, 'text': 'This is pretty simple, the simplest of all chart.', 'start': 7558.578, 'duration': 3.282}, {'end': 7565.202, 'text': "Okay, I've got answer from Arjeet, Sunil, all of them are correct.", 'start': 7562.44, 'duration': 2.762}, {'end': 7568.023, 'text': 'From Arnold as well, correct answer.', 'start': 7566.362, 'duration': 1.661}, {'end': 7570.385, 'text': 'Sabah as well, correct answer, all of you.', 'start': 7568.764, 'duration': 1.621}, {'end': 7572.026, 'text': 'It seems pretty straightforward.', 'start': 7570.785, 'duration': 1.241}], 'summary': 'Visualize salary based on performance using the simplest chart. all responses were correct.', 'duration': 50.706, 'max_score': 7521.32, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I7521320.jpg'}, {'end': 7642.903, 'src': 'embed', 'start': 7615.037, 'weight': 4, 'content': [{'end': 7618.898, 'text': "Okay, and then I'm going to pull, let's say, whatever, department name.", 'start': 7615.037, 'duration': 3.861}, {'end': 7623.359, 'text': "Okay, and I'm assuming people working in CEO office will get higher salary.", 'start': 7619.858, 'duration': 3.501}, {'end': 7631.16, 'text': 'People working in testing probably will get a bit lower salary, okay? But the situation looks gloomy here.', 'start': 7623.879, 'duration': 7.281}, {'end': 7634.301, 'text': 'CEO office getting very less, testing getting very high.', 'start': 7631.721, 'duration': 2.58}, {'end': 7635.381, 'text': 'Why is that so??', 'start': 7634.781, 'duration': 0.6}, {'end': 7637.782, 'text': 'Because we are looking at sum of salary, right?', 'start': 7635.841, 'duration': 1.941}, {'end': 7642.903, 'text': 'We should be looking at average salary because, and see, now the picture has flipped.', 'start': 7638.222, 'duration': 4.681}], 'summary': 'When analyzing salaries, consider average instead of sum for a clearer picture.', 'duration': 27.866, 'max_score': 7615.037, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I7615037.jpg'}, {'end': 7699.359, 'src': 'embed', 'start': 7667.348, 'weight': 2, 'content': [{'end': 7669.089, 'text': 'So we got to use aperture.', 'start': 7667.348, 'duration': 1.741}, {'end': 7671.551, 'text': 'So all these things you have to determine.', 'start': 7669.429, 'duration': 2.122}, {'end': 7680.373, 'text': 'from time to time in Tableau interviews, they will actually give you data and ask you to create a visualization.', 'start': 7674.631, 'duration': 5.742}, {'end': 7681.593, 'text': "It'll be fairly simple.", 'start': 7680.633, 'duration': 0.96}, {'end': 7690.616, 'text': "They're not going to ask you to create something very, very complex as such, but these are basic things which you need to keep in mind.", 'start': 7682.053, 'duration': 8.563}, {'end': 7699.359, 'text': 'Which chart will you use to visualize percentage of male and female customers? You are a manufacturing company.', 'start': 7691.876, 'duration': 7.483}], 'summary': 'Tableau interviews may require creating visualizations, often involving basic data and simple charts.', 'duration': 32.011, 'max_score': 7667.348, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I7667348.jpg'}, {'end': 8076.613, 'src': 'embed', 'start': 8051.303, 'weight': 7, 'content': [{'end': 8056.646, 'text': "I mean, it's better than pie chart if you are trying to break up 100% between different pieces.", 'start': 8051.303, 'duration': 5.343}, {'end': 8058.525, 'text': "then it's better than pie chart.", 'start': 8057.344, 'duration': 1.181}, {'end': 8060.606, 'text': 'Otherwise, there is no use of tree map.', 'start': 8058.585, 'duration': 2.021}, {'end': 8062.426, 'text': 'I mean pie chart will do the job for you.', 'start': 8060.666, 'duration': 1.76}, {'end': 8065.508, 'text': 'If you have three, four categories, create a pie chart.', 'start': 8062.767, 'duration': 2.741}, {'end': 8069.83, 'text': "It's going to serve the same information, give the same information.", 'start': 8066.988, 'duration': 2.842}, {'end': 8075.372, 'text': 'Specially tree map is used, I would suggest using a tree map when you have multiple different categories.', 'start': 8070.59, 'duration': 4.782}, {'end': 8076.613, 'text': "It's not going to look ugly.", 'start': 8075.452, 'duration': 1.161}], 'summary': 'Pie chart better for 3-4 categories, treemap for multiple categories.', 'duration': 25.31, 'max_score': 8051.303, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8051303.jpg'}, {'end': 8401.656, 'src': 'embed', 'start': 8374.334, 'weight': 14, 'content': [{'end': 8379.178, 'text': 'I want these bars to be of equal height and I want to show values as percentages.', 'start': 8374.334, 'duration': 4.844}, {'end': 8384.582, 'text': "So I'm gonna take number of records, I'm gonna throw it in here.", 'start': 8380.999, 'duration': 3.583}, {'end': 8390.786, 'text': 'These are male employees working in development, these are female employees working in HR.', 'start': 8386.343, 'duration': 4.443}, {'end': 8396.751, 'text': "And I'm gonna click here, quick table calculation, show it as percentage of total.", 'start': 8391.887, 'duration': 4.864}, {'end': 8401.656, 'text': 'But then what has happened This is actually percentage of entire total.', 'start': 8397.151, 'duration': 4.505}], 'summary': 'Equal height bars for male employees in development and female employees in hr, presented as percentages.', 'duration': 27.322, 'max_score': 8374.334, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8374334.jpg'}, {'end': 8490.849, 'src': 'embed', 'start': 8457.201, 'weight': 3, 'content': [{'end': 8457.801, 'text': "I don't know if you can.", 'start': 8457.201, 'duration': 0.6}, {'end': 8460.364, 'text': 'get re-enrolled in my session.', 'start': 8458.723, 'duration': 1.641}, {'end': 8462.244, 'text': "I think there shouldn't be any problem.", 'start': 8460.624, 'duration': 1.62}, {'end': 8464.005, 'text': 'Thanks, Arijit.', 'start': 8463.425, 'duration': 0.58}, {'end': 8467.206, 'text': 'So yeah, if you want to attend my session, most welcome.', 'start': 8464.525, 'duration': 2.681}, {'end': 8468.787, 'text': "I'll be more than happy to guide you.", 'start': 8467.307, 'duration': 1.48}, {'end': 8476.21, 'text': 'Okay, so coming back, and thanks once again for the generous feedback and generous compliment, really appreciate it.', 'start': 8469.948, 'duration': 6.262}, {'end': 8480.372, 'text': 'Okay, so coming back, we have now these different bars broken up.', 'start': 8476.23, 'duration': 4.142}, {'end': 8490.849, 'text': 'So each bar is now adding up to 100%, but I do not want to showcase that CEO office is like, you know, tiny, and this development is biggest.', 'start': 8480.812, 'duration': 10.037}], 'summary': 'Welcoming re-enrollment, guiding attendees, and adjusting bar percentages for ceo office representation.', 'duration': 33.648, 'max_score': 8457.201, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8457201.jpg'}, {'end': 8538.051, 'src': 'embed', 'start': 8506.3, 'weight': 0, 'content': [{'end': 8508.862, 'text': 'What is this section defining? It is defining this axis.', 'start': 8506.3, 'duration': 2.562}, {'end': 8510.603, 'text': "That's why I have to go here.", 'start': 8509.683, 'duration': 0.92}, {'end': 8511.844, 'text': 'I have to set the axis now.', 'start': 8510.643, 'duration': 1.201}, {'end': 8513.986, 'text': 'I set the values, I have to set the axis.', 'start': 8512.165, 'duration': 1.821}, {'end': 8519.096, 'text': "Quick table calculation, I'm gonna say it as percentage of total.", 'start': 8515.393, 'duration': 3.703}, {'end': 8524.2, 'text': "And then again, same step I'm gonna perform.", 'start': 8520.497, 'duration': 3.703}, {'end': 8526.882, 'text': "Table across, table down I'm gonna choose.", 'start': 8524.88, 'duration': 2.002}, {'end': 8528.443, 'text': 'Say apply, okay.', 'start': 8527.302, 'duration': 1.141}, {'end': 8538.051, 'text': 'This is my 100% stack bar chart showing clearly that CEO office has probably bad whatever gender ratio.', 'start': 8528.823, 'duration': 9.228}], 'summary': "Creating a 100% stack bar chart showing ceo office's gender ratio.", 'duration': 31.751, 'max_score': 8506.3, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8506300.jpg'}, {'end': 8610.009, 'src': 'embed', 'start': 8582.347, 'weight': 6, 'content': [{'end': 8586.868, 'text': "If you have questions, just drop me your question on that particular link which I've shared.", 'start': 8582.347, 'duration': 4.521}, {'end': 8589.669, 'text': "I'll get an email notification and I'll answer it to you.", 'start': 8587.649, 'duration': 2.02}, {'end': 8592.63, 'text': 'Seanak, let me do this.', 'start': 8590.289, 'duration': 2.341}, {'end': 8598.592, 'text': "Let me make you the I'll unmute you first, so you can speak out your question.", 'start': 8592.67, 'duration': 5.922}, {'end': 8603.826, 'text': 'and Thanks, guys, thanks for understanding, because we are running actually closely out of time.', 'start': 8598.592, 'duration': 5.234}, {'end': 8610.009, 'text': "I have to attend my office tomorrow so it'll take another 15, 20 minutes at least, donut chat.", 'start': 8603.846, 'duration': 6.163}], 'summary': 'Participants can submit questions via a provided link for email responses. the speaker will allow time for questions after unmuting participants, but the session is ending soon due to time constraints.', 'duration': 27.662, 'max_score': 8582.347, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8582347.jpg'}], 'start': 6495.934, 'title': 'Tableau features, storytelling, and visualization', 'summary': "Introduces tableau's story feature for narrative visualization, covers storytelling, data management, and visualizations in tableau desktop and server, and demonstrates creating 100% stacked bar plots to visualize gender distribution in different departments, providing comprehensive insights into tableau's capabilities.", 'chapters': [{'end': 6609.738, 'start': 6495.934, 'title': 'Tableau story feature overview', 'summary': "Introduces tableau's story feature, which allows users to present findings in a step-by-step manner, guiding viewers through a sequence of visualizations to convey a narrative, enabling contextual understanding and insights into data analysis.", 'duration': 113.804, 'highlights': ["Tableau's story feature enables users to present findings in a step-by-step manner, guiding viewers through a sequence of visualizations to convey a narrative. The story feature allows users to create a sequential presentation of visualizations, providing a guided tour for users to understand the context and insights of the data analysis.", "Users can use Tableau's story feature to build a contextual understanding by presenting various points in a guided tour, such as workforce profile, gender bias investigation, departmental analysis, external sources, revenue stream comparison, and concluding insights. The story feature enables users to build a narrative by presenting various points, including workforce profile, gender bias investigation, departmental analysis, external sources for reasons, revenue stream comparison, and concluding insights on healthy gender mix.", "Tableau's story feature was introduced in version eight, providing a new way to present analysis findings. The story feature was introduced in version eight, offering a new method for presenting analysis findings in a step-by-step manner."]}, {'end': 7104.891, 'start': 6610.019, 'title': 'Tableau storytelling and data management', 'summary': 'Covers the concept of storytelling in tableau, the difference between discrete and continuous data, automating reports, blending database and flat file data, tableau server platforms, publishing reports, and defining and making parameters dynamic.', 'duration': 494.872, 'highlights': ['Automating reports in Tableau involves creating and publishing dashboards onto Tableau server and scheduling the report for data refresh, enabling users to see new information automatically based on the provided time. Automating reports, Tableau server, scheduling, data refresh, new information', 'Data blending in Tableau involves pulling data from different sources, editing relationships, defining custom relationships if required, and blending data based on common or different column names. Data blending, pulling data, editing relationships, custom relationships, common column names', 'Tableau Server can run on both Windows and Mac platforms, providing flexibility and accessibility to users on different operating systems. Tableau Server, Windows, Mac, accessibility, flexibility', 'Publishing Tableau reports to Tableau server involves choosing the publish workbook option, providing credentials, selecting specific sheets to publish, and defining user permissions, making it a simple and menu-driven process. Publishing reports, Tableau server, credentials, specific sheets, user permissions, simple process', 'Parameters in Tableau allow users to accept inputs, interact with dashboards, pass values through parameters, use those values in calculations and filters, and make parameters dynamic to control values dynamically in the formula. Parameters, user inputs, dashboards, values, calculations, filters, dynamic control']}, {'end': 7666.948, 'start': 7104.891, 'title': 'Tableau: desktop vs server, charts and visualization', 'summary': 'Discusses the difference between tableau desktop and tableau server, the use of tableau reader for offline viewing, and the selection of charts for visualizing data relationships, emphasizing the importance of using scatter plots for continuous numeric variables and bar charts for comparing categories.', 'duration': 562.057, 'highlights': ['Tableau Server is used to distribute workbooks to end users, enabling interactive features like applying filters and slicing data. Tableau Server distributes workbooks to end users, enabling interactive features like applying filters and slicing data.', 'Tableau Reader can be used for offline viewing of files without any cost, allowing end users to view and interact with the dashboards created using Tableau Desktop. Tableau Reader allows offline viewing of files, enabling end users to view and interact with Tableau Desktop-created dashboards.', 'The chapter emphasizes the use of scatter plot for visualizing the relationship between two continuous numeric variables, with the dependent variable on the y-axis and the independent variable on the x-axis. The chapter emphasizes using scatter plot for visualizing the relationship between two continuous numeric variables, with the dependent variable on the y-axis and the independent variable on the x-axis.', 'The selection of a bar chart for visualizing the relationship between salary and performance rating, with each category represented by a bar showing the average salary. A bar chart is selected for visualizing the relationship between salary and performance rating, with each category represented by a bar showing the average salary.']}, {'end': 8271.575, 'start': 7667.348, 'title': 'Visualizing data with tableau', 'summary': 'Discussed the usage of different charts in tableau to visualize data, such as the pie chart for visualizing the percentage of male and female customers, histogram for displaying the distribution of customers by age, box plot for comparing salaries across departments, and tree map as an alternative to pie chart for visualizing percentage contribution to global sales by 20 countries. additionally, it covered using a line chart to analyze employee attrition trend over the last 36 months and 100% stacked bar chart to compare the percentage of male and female across 10 different departments of a company.', 'duration': 604.227, 'highlights': ['The chapter discussed the usage of different charts in Tableau to visualize data, such as the pie chart for visualizing the percentage of male and female customers, histogram for displaying the distribution of customers by age, box plot for comparing salaries across departments, and tree map as an alternative to pie chart for visualizing percentage contribution to global sales by 20 countries. Usage of different charts in Tableau, including pie chart, histogram, box plot, and tree map for specific data visualization purposes.', 'The usage of a line chart to analyze employee attrition trend over the last 36 months was emphasized. Emphasis on using a line chart to analyze employee attrition trend over the last 36 months.', 'The chapter also covered using a 100% stacked bar chart to compare the percentage of male and female across 10 different departments of a company. Usage of a 100% stacked bar chart to compare the percentage of male and female across 10 different departments of a company.']}, {'end': 8628.116, 'start': 8272.594, 'title': 'Creating 100% stackbar plot', 'summary': 'Demonstrates how to create a 100% stack bar plot, showcasing the gender ratio in different departments using a pivot table, bar plot, and table calculation, ensuring that each bar represents 100% and providing insights into the gender distribution.', 'duration': 355.522, 'highlights': ['The chapter demonstrates the process of creating a 100% stack bar plot to showcase the gender ratio in different departments using a pivot table, bar plot, and table calculation, ensuring that each bar represents 100% for accurate representation of gender distribution.', 'The instructor offers a workaround to ensure that the bars are of equal size in the 100% stack bar plot, providing a clear and accurate representation of the gender ratio in different departments.', 'The instructor acknowledges and appreciates feedback from the audience, maintaining an engaging and interactive session.', 'The instructor offers to share a YouTube video link for additional guidance on creating a 100% stack bar plot, ensuring that participants have resources for further learning and understanding.', 'The instructor demonstrates willingness to address participant questions outside the session by encouraging them to drop questions on the provided YouTube link, showcasing a commitment to supporting participants beyond the live session.']}], 'duration': 2132.182, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I6495934.jpg', 'highlights': ["Tableau's story feature enables step-by-step narrative visualization.", 'Automating reports in Tableau involves creating and publishing dashboards.', 'Data blending in Tableau involves pulling data from different sources.', 'Tableau Server provides flexibility and accessibility on Windows and Mac.', 'Parameters in Tableau allow dynamic control of values in formulas.', 'Tableau Server distributes workbooks to end users for interactive features.', 'Tableau Reader allows offline viewing and interaction with Tableau dashboards.', 'Scatter plot visualizes the relationship between two continuous variables.', 'Bar chart is selected for visualizing the relationship between salary and performance rating.', 'Usage of different charts in Tableau for specific data visualization purposes.', 'Line chart is emphasized for analyzing employee attrition trend over 36 months.', '100% stacked bar chart compares gender distribution across different departments.', 'Creating a 100% stack bar plot ensures accurate gender distribution representation.', 'Instructor offers YouTube video link for additional guidance on creating 100% stack bar plot.', 'Instructor demonstrates willingness to address participant questions outside the session.']}, {'end': 9485.788, 'segs': [{'end': 8659.172, 'src': 'embed', 'start': 8629.321, 'weight': 0, 'content': [{'end': 8644.072, 'text': 'Yeah, I want to ask like if you are creating a parameter and we want to show some, we want to show the data as per the data source which will change.', 'start': 8629.321, 'duration': 14.751}, {'end': 8655.881, 'text': 'If you are creating a calculated field, like for this particular year, the sales are going to be high, and for the previous year the sales are.', 'start': 8644.392, 'duration': 11.489}, {'end': 8659.172, 'text': 'That means you are showing like low, medium and high.', 'start': 8656.411, 'duration': 2.761}], 'summary': 'Creating dynamic parameters and calculated fields to display changing data sources and sales performance levels.', 'duration': 29.851, 'max_score': 8629.321, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8629321.jpg'}, {'end': 8904.903, 'src': 'embed', 'start': 8876.458, 'weight': 4, 'content': [{'end': 8878.079, 'text': 'other products has gone, win high.', 'start': 8876.458, 'duration': 1.621}, {'end': 8882.061, 'text': 'So that other product will be go, arrow will be up and this will be down.', 'start': 8878.139, 'duration': 3.922}, {'end': 8884.923, 'text': 'Okay, okay, okay, okay.', 'start': 8883.862, 'duration': 1.061}, {'end': 8890.706, 'text': 'I do not have an example readily available to showcase this.', 'start': 8886.643, 'duration': 4.063}, {'end': 8893.687, 'text': 'Let me just think of that situation.', 'start': 8892.086, 'duration': 1.601}, {'end': 8897.209, 'text': 'Maybe I can get my hands on such a data set and I can work something out for you.', 'start': 8893.787, 'duration': 3.422}, {'end': 8901.942, 'text': 'Some interesting application of parameters I can show you if you want to.', 'start': 8898.761, 'duration': 3.181}, {'end': 8904.903, 'text': 'So we can use parameters for predictive modeling.', 'start': 8902.242, 'duration': 2.661}], 'summary': 'Using parameters for predictive modeling can lead to improved product performance.', 'duration': 28.445, 'max_score': 8876.458, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8876458.jpg'}, {'end': 9227.362, 'src': 'embed', 'start': 9187.352, 'weight': 2, 'content': [{'end': 9191.555, 'text': 'second last session, where I cover predictive modeling.', 'start': 9187.352, 'duration': 4.203}, {'end': 9192.836, 'text': 'So this is my equation.', 'start': 9191.776, 'duration': 1.06}, {'end': 9194.538, 'text': "I'm going to write this equation down.", 'start': 9192.856, 'duration': 1.682}, {'end': 9200.803, 'text': 'Equation is minus 3.9 MRP plus 387.', 'start': 9196.179, 'duration': 4.624}, {'end': 9205.667, 'text': "So I'm just going to write it down quickly.", 'start': 9200.803, 'duration': 4.864}, {'end': 9218.294, 'text': 'Sale is equal to minus 3.9 multiplied by MRP plus 387 I think it was? 387, yeah.', 'start': 9206.068, 'duration': 12.226}, {'end': 9221.037, 'text': '387, okay.', 'start': 9218.314, 'duration': 2.723}, {'end': 9225.521, 'text': 'So this is the predictive model which we have built using Tableau.', 'start': 9221.958, 'duration': 3.563}, {'end': 9227.362, 'text': "Now I'm going to create a formula.", 'start': 9225.701, 'duration': 1.661}], 'summary': 'In the session, a predictive model for sales was presented with the equation sale = -3.9 * mrp + 387.', 'duration': 40.01, 'max_score': 9187.352, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I9187352.jpg'}], 'start': 8629.321, 'title': 'Data visualization and analysis in tableau', 'summary': 'Covers parameter-based dynamic data visualization for sales performance, including automatic shape and arrow adjustments, as well as the use of trend lines and parameters for analyzing salary trends, regression analysis, and creating predictive models for sales forecasting with insights into the impact of mrp on soap sales.', 'chapters': [{'end': 8706.359, 'start': 8629.321, 'title': 'Parameter-based dynamic data visualization', 'summary': 'Discusses using parameters to dynamically visualize data from different sources and to create calculated fields for dynamic representation of sales performance, including the automatic adjustment of shapes and arrows based on the data.', 'duration': 77.038, 'highlights': ['The need to dynamically visualize data from different sources using parameters and data blending, enabling the transition from one data source to another.', 'Creating calculated fields to dynamically represent sales performance, such as showing high, medium, and low sales for different years.', 'Automatic adjustment of shapes in Excel to reflect changes in sales performance, such as showing high sales with a corresponding shape change.', 'Dynamic representation of sales performance through the automatic adjustment of arrows based on the comparison of data between different years, reflecting changes in sales performance.']}, {'end': 9485.788, 'start': 8706.539, 'title': 'Using trend lines and parameters in tableau', 'summary': 'Discusses the use of trend lines and parameters in tableau to analyze salary trends, demonstrate regression analysis, and create a predictive model for sales forecasting, offering insights into the impact of mrp on soap sales.', 'duration': 779.249, 'highlights': ['Using trend lines to analyze salary trends The speaker suggests using trend lines to compare salaries for the past year and ongoing years, demonstrating how the trend line can display whether the data is going up or down, indicating a hiring trend over time.', 'Regression analysis for sales forecasting The speaker demonstrates creating a predictive model for sales forecasting by using regression analysis in Tableau, showing the impact of MRP on soap sales and the use of parameters to make the model flexible for different scenarios.', 'Application of parameters in predictive modeling The session showcases the use of parameters for predictive modeling and demonstrates how the flexibility of parameters can be leveraged to create dynamic predictive models for different scenarios, such as forecasting soap sales based on different MRP values.']}], 'duration': 856.467, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/SEctitOFm0I/pics/SEctitOFm0I8629321.jpg', 'highlights': ['Creating predictive models for sales forecasting with insights into the impact of MRP on soap sales', 'Using trend lines to analyze salary trends and hiring trends over time', 'Dynamic representation of sales performance through automatic adjustment of arrows based on data comparison', 'Creating calculated fields to dynamically represent sales performance for different years', 'Automatic adjustment of shapes in Excel to reflect changes in sales performance']}], 'highlights': ["Tableau is consistently positioned as a leader in Gartner's Magic Quadrant, with a strong ability to execute and a bright future in terms of completeness of vision, as indicated by its position at the top of the stack.", 'The demand for Tableau professionals has shown exponential growth, with the number of Tableau-related jobs increasing considerably from January 2015 to January 2016.', "Tableau's in-memory BI platform enables high scalability and rapid visualization, outperforming tools like Excel.", 'Utilize Boolean calculations with alias to categorize data based on specific conditions, leading to efficient performance when working with large data sets.', "Tableau's story feature enables step-by-step narrative visualization.", 'Creating predictive models for sales forecasting with insights into the impact of MRP on soap sales', 'Using trend lines to analyze salary trends and hiring trends over time', 'The importance of actionable information in Tableau dashboards is emphasized, with a focus on simplicity and non-cluttered design to enhance user adoption and success.', "Tableau's ease of use allows rapid visualization, enabling the creation of complex dashboards in a matter of days, not weeks.", 'Tableau values user feedback and continuously updates its features and functionalities based on user input.']}