title
Tableau Full Course - Learn Tableau in 6 Hours | Tableau Training for Beginners | Edureka

description
πŸ”₯ Edureka Tableau Certification Training (Use Code "π˜πŽπ”π“π”ππ„πŸπŸŽ"): https://www.edureka.co/tableau-certification-training This Edureka Tableau Full Course video will help you understand and learn Tableau in detail. This Tableau Tutorial is ideal for both beginners as well as professionals who want to master their Tableau concepts. Below are the topics covered in this tableau training for beginners video: 00:00 Agenda of Tableau Full Course 2:27 Introduction to Tableau & Data Visualization 2:39 What is Data Visualization? 3:37 Power of Data Visualization 5:09 Scope of Visual Analytics 6:28 Data Visualization using Tableau 7:16 Why Tableau? 9:11 What is Tableau? 10:25 Tableau Architecture 13:33 Tableau Desktop Installation 14:31 Tableau UI - Connections 15:24 Tableau Datatypes 16:59 Tableau Desktop UI 18:09 Tableau UI - Dimensions & Measures 19:52 Tableau UI - Show me 25:14 Functions in Tableau 25:22 Join & Union 25:56 Sort 26:19 Set 26:36 Forecasting 27:19 Highlighting 27:44 Device Designer 28:26 Visual Analysis 33:55 Components of Tableau 34:05 Tableau Product Family 36:59 Pros of Tableau 39:07 How to use Tableau 39:12 Connecting to Data 42:02 Joins 43:42 Show me the Data 44:38 Filters 46:59 Hierarchies 48:10 Groups 48:56 Sets 49:22 Data Types 51:57 Tableau Success 53:02 Demo - US Crime Dataset 1:02:58 Charts & Graphs 1:03:37 Generated Fields 1:09:16 Building Charts in Tableau 1:09:29 Bar Chart 1:11:14 Pareto Chart 1:14:39 Bullet Chart 1:16:56 Text Chart 1:17:35 Heat Map 1:18:40 Waterfall Chart 1:20:37 Gantt Chart 1:22:28 Pie Chart 1:23:09 Scatter Plot 1:24:11 Area Chart 1:24:48 Dual Axis Chart 1:25:43 Bubble Chart 1:26:08 Histogram 1:27:03 Features of Tableau 1:30 Dashboarding in Tableau 1:30:35 Use Case: Indian Premier League 2:11:43 Functions 2:12:41 Number Functions 2:36:55 String Functions 2:49:09 Date Functions 2:57:59 Type Conversion Functions 3:02:17 Aggregate Functions 3:08:12 Logical Functions 3:15:38 Level of Details 3:16:58 Introduction to LOD 3:18:29 Types of LOD 3:18:44 Working of LOD Expressions 3:21:44 Include Calculation 3:22:18 Exclude Calculation 3:22:46 Fixed Calculation 3:23:51 Aggregation & Level of Detail 3:26:46 Nesting in Level of Details 3:27:45 Data Sources Supported by LOD 3:27:57 How to create Level of Detail Expressions 3:33:35 Limitations of Level of Detail 3:35:20 Parameters 3:36:31 What are Parameters in Tableau? 3:38:46 Getting Started on the Desktop 3:41:25 Creating a parameter in Tableau 3:43:19 Using the parameter in a calculation 3:45:32 Parameter Control in Tableau 3:46:54 Using Parameters in your Visualization 3:49:47 Data Blending 3:50:55 Objective of Data Blending 3:53:36 Introduction to Data Blending in Tableau 3:53:53 Joining vs Blending in Tableau 3:54:03 Data Joining 3:54:47 Data Blending 3:59:52 Limitations of Data Blending 4:01:22 How to become a Tableau Developer 4:02:37 Who is a Tableau Developer? 4:04:58 Tableau Developer Roles & Responsibilities 4:08:12 Skills Required to become a Data Scientist 4:10:25 Tableau Training @ Edureka 4:12:33 Tableau Interview Questions Check our complete Tableau playlist here: https://goo.gl/NTpehs πŸ“’πŸ“’ 𝐓𝐨𝐩 𝟏𝟎 π“π«πžπ§ππ’π§π  π“πžπœπ‘π§π¨π₯𝐨𝐠𝐒𝐞𝐬 𝐭𝐨 π‹πžπšπ«π§ 𝐒𝐧 πŸπŸŽπŸπŸ’ π’πžπ«π’πžπ¬ πŸ“’πŸ“’ ⏩ NEW Top 10 Technologies To Learn In 2024 - https://www.youtube.com/watch?v=vaLXPv0ewHU - - - - - - - - - - - - - - - - - Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV Instagram: https://www.instagram.com/edureka_learning Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka Telegram: https://t.me/edurekaupdates #edureka #TableauFullCourse #TableauTraining #TableauTutorial #TableauTutorialForBeginners #TableauDashboard #TableauTraining #TableauCertification About the Tableau Course 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. Please write back to us at sales@edureka.in or call us at IND: 9606058406 / US: +18338555775 (toll-free) for more information.

detail
{'title': 'Tableau Full Course - Learn Tableau in 6 Hours | Tableau Training for Beginners | Edureka', 'heatmap': [{'end': 3463.422, 'start': 3235.033, 'weight': 0.957}, {'end': 4757.441, 'start': 4316.243, 'weight': 1}], 'summary': 'This 6-hour tableau training covers data visualization, functions, and more; demonstrates us crime dataset analysis, ipl data visualization, and dashboard creation; provides insights into tableau developer role and skills; emphasizes performance optimization and dashboard design best practices; and covers chart types, tableau formulas, features, and success stories from companies like us air force, burger king, and citibank.', 'chapters': [{'end': 371.48, 'segs': [{'end': 63.182, 'src': 'embed', 'start': 29.653, 'weight': 4, 'content': [{'end': 31.335, 'text': "So we're going to start out with some basics.", 'start': 29.653, 'duration': 1.682}, {'end': 36.482, 'text': "We're going to talk about data visualization and Tableau, and why do we need both of these,", 'start': 31.415, 'duration': 5.067}, {'end': 40.488, 'text': 'followed by which we are going to discuss installation of the Tableau desktop tool.', 'start': 36.482, 'duration': 4.006}, {'end': 44.874, 'text': 'Now, this is the tool that you are going to be using throughout the course of this video.', 'start': 41.028, 'duration': 3.846}, {'end': 54.131, 'text': 'Next, we are going to talk about data visualization using Tableau and then we are going to discuss an important concept called visual perception.', 'start': 45.74, 'duration': 8.391}, {'end': 63.182, 'text': 'We are also going to talk about how Tableau incorporates these visual perceptions into its components to give you optimum data visualization.', 'start': 54.591, 'duration': 8.591}], 'summary': 'Introduction to tableau, including installation and data visualization concepts.', 'duration': 33.529, 'max_score': 29.653, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So29653.jpg'}, {'end': 136.752, 'src': 'embed', 'start': 92.803, 'weight': 0, 'content': [{'end': 95.044, 'text': "Now this is Tableau's version of DAX.", 'start': 92.803, 'duration': 2.241}, {'end': 101.207, 'text': "Next, we're going to discuss level of detail, another very important, very fundamental concept.", 'start': 95.764, 'duration': 5.443}, {'end': 104.468, 'text': "Then we're going to discuss parameters in Tableau,", 'start': 101.747, 'duration': 2.721}, {'end': 109.951, 'text': "followed by which we're going to talk about data blending in Tableau and how it is different from SQL joins.", 'start': 104.468, 'duration': 5.483}, {'end': 114.207, 'text': 'Moving on, we are going to talk about the career aspect in Tableau.', 'start': 110.726, 'duration': 3.481}, {'end': 121.328, 'text': 'So we have a module called how to become a Tableau developer, which discusses the roles and responsibilities of a Tableau developer.', 'start': 114.647, 'duration': 6.681}, {'end': 125.829, 'text': 'To cap off the session, we have some interview questions for you based on Tableau.', 'start': 121.789, 'duration': 4.04}, {'end': 131.731, 'text': 'Now your instructors for this particular session is going to be Reshma and Upasana.', 'start': 126.29, 'duration': 5.441}, {'end': 136.752, 'text': "They're going to take you through step by step through all the sessions of this Tableau tutorial.", 'start': 131.871, 'duration': 4.881}], 'summary': 'Tableau tutorial covers dax, level of detail, parameters, data blending, career aspects, and interview questions.', 'duration': 43.949, 'max_score': 92.803, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So92803.jpg'}, {'end': 221.441, 'src': 'embed', 'start': 195.755, 'weight': 3, 'content': [{'end': 200.923, 'text': 'And visualization enables you to have a well-defined overview of your entire data.', 'start': 195.755, 'duration': 5.168}, {'end': 206.731, 'text': 'And the simpler your visualization is, the more insights and inferences you can make from it.', 'start': 201.343, 'duration': 5.388}, {'end': 210.656, 'text': 'So simple representations are the most powerful ones.', 'start': 207.311, 'duration': 3.345}, {'end': 216.379, 'text': 'So that is why we need data visualization to understand our data in a better way.', 'start': 211.357, 'duration': 5.022}, {'end': 221.441, 'text': 'And these can be used for analysis of data to make future predictions,', 'start': 216.839, 'duration': 4.602}], 'summary': 'Visualization simplifies data for better insights and predictions.', 'duration': 25.686, 'max_score': 195.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So195755.jpg'}, {'end': 337.105, 'src': 'embed', 'start': 313.292, 'weight': 2, 'content': [{'end': 320.474, 'text': 'It can be used for information analytics, for geospatial analytics, scientific analytics, knowledge discovery,', 'start': 313.292, 'duration': 7.182}, {'end': 325.796, 'text': 'data management and knowledge representation for presentation, production and dissemination.', 'start': 320.474, 'duration': 5.322}, {'end': 329.337, 'text': "It's used for cognitive and perceptual science.", 'start': 325.816, 'duration': 3.521}, {'end': 334.782, 'text': 'for interaction and there are many more usage of it.', 'start': 329.797, 'duration': 4.985}, {'end': 337.105, 'text': 'and why do we use visual analytics?', 'start': 334.782, 'duration': 2.323}], 'summary': 'Visual analytics used for information, geospatial, scientific analytics, and cognitive science.', 'duration': 23.813, 'max_score': 313.292, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So313292.jpg'}], 'start': 6.974, 'title': 'Tableau training and data visualization importance', 'summary': 'Provides a full course session on tableau, covering basics, data visualization, functions, and more, and emphasizes the importance of data visualization in understanding and analyzing data, making predictions, and improving company performance.', 'chapters': [{'end': 136.752, 'start': 6.974, 'title': 'Tableau training for beginners', 'summary': 'Covers a full course session on tableau, including basics, data visualization, tableau functions, level of detail, parameters, data blending, career aspects, and interview questions, conducted by instructors reshma and upasana.', 'duration': 129.778, 'highlights': ['The chapter covers a full course session on Tableau, including basics, data visualization, Tableau functions, level of detail, parameters, data blending, career aspects, and interview questions.', 'Instructors for the session are Reshma and Upasana, who will take you through all the sessions of this Tableau tutorial.', 'The session includes topics like data visualization, Tableau installation, visual perception, charts and graphs, and creating dashboards using the Tableau desktop app.', 'The chapter also discusses data aggregation topics like Tableau functions, level of detail, parameters, data blending, and career aspects in Tableau.']}, {'end': 371.48, 'start': 137.788, 'title': 'Importance of data visualization', 'summary': 'Explains the importance of data visualization, highlighting its role in understanding and analyzing data, making future predictions, and its wide usage in various fields. visual analytics is also emphasized as a tool for making better decisions, reducing risk, and improving company performance.', 'duration': 233.692, 'highlights': ['Data visualization enables a well-defined overview of entire data and simpler representations lead to more insights and inferences.', 'Visual analytics is widely used for information analytics, geospatial analytics, scientific analytics, knowledge discovery, data management, and knowledge representation.', 'Using visual analytics helps in making better decisions, reducing risk, and improving company performance by building better customer relationships and achieving better financial performance.', 'Pictorial representations such as graphs, bar diagrams, and charts allow visual access to huge amounts of data, making it easier to understand and analyze.', 'Data visualization is highly used in solving business problems and making future predictions, and Tableau is a tool commonly used for this purpose.']}], 'duration': 364.506, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So6974.jpg', 'highlights': ['The chapter covers a full course session on Tableau, including basics, data visualization, Tableau functions, level of detail, parameters, data blending, career aspects, and interview questions.', 'Instructors for the session are Reshma and Upasana, who will take you through all the sessions of this Tableau tutorial.', 'Using visual analytics helps in making better decisions, reducing risk, and improving company performance by building better customer relationships and achieving better financial performance.', 'Data visualization enables a well-defined overview of entire data and simpler representations lead to more insights and inferences.', 'The session includes topics like data visualization, Tableau installation, visual perception, charts and graphs, and creating dashboards using the Tableau desktop app.']}, {'end': 2340.157, 'segs': [{'end': 521.091, 'src': 'embed', 'start': 477.109, 'weight': 0, 'content': [{'end': 481.571, 'text': 'interactive visual analytics and an established enterprise platform.', 'start': 477.109, 'duration': 4.462}, {'end': 485.272, 'text': 'And you can represent your data in any way that you want.', 'start': 482.191, 'duration': 3.081}, {'end': 488.773, 'text': 'The visuals that Tableau gives you are very interactive.', 'start': 485.612, 'duration': 3.161}, {'end': 494.476, 'text': 'You can tweak them around, you can play around those graphs and the different charts that you make in Tableau.', 'start': 488.853, 'duration': 5.623}, {'end': 497.697, 'text': 'And you can visualize your data in many ways.', 'start': 494.896, 'duration': 2.801}, {'end': 501.519, 'text': 'also, it has very quick production time.', 'start': 498.817, 'duration': 2.702}, {'end': 507.683, 'text': 'it takes only a few seconds for Tableau to create the visualization that you want for your data,', 'start': 501.519, 'duration': 6.164}, {'end': 515.428, 'text': 'and that is the reason why Tableau has been among the top charts when it comes to a visual analytics and a presentation tool.', 'start': 507.683, 'duration': 7.745}, {'end': 521.091, 'text': "and let me tell you that and Tableau has managed to be in the Gartner's magic quadrant from years from now.", 'start': 515.428, 'duration': 5.663}], 'summary': "Tableau offers interactive visual analytics with quick production time, securing its place in gartner's magic quadrant.", 'duration': 43.982, 'max_score': 477.109, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So477109.jpg'}, {'end': 591.646, 'src': 'embed', 'start': 565.497, 'weight': 3, 'content': [{'end': 571.521, 'text': 'So, with Tableau, you can create and distribute interactive and shareable dashboards which depict the trends,', 'start': 565.497, 'duration': 6.024}, {'end': 575.303, 'text': 'variations and density of data in forms of graphs and charts.', 'start': 571.521, 'duration': 3.782}, {'end': 584.017, 'text': 'And this software also enables you data blending real-time collabs, which is what makes Tableau stand out from all its competitors,', 'start': 576.107, 'duration': 7.91}, {'end': 585.318, 'text': 'and it is very unique.', 'start': 584.017, 'duration': 1.301}, {'end': 591.646, 'text': 'You can use it for business purpose, for academic purpose, or for any purpose, whichever you want to.', 'start': 585.759, 'duration': 5.887}], 'summary': 'Tableau enables creation of interactive dashboards, real-time collabs, and is versatile for various purposes.', 'duration': 26.149, 'max_score': 565.497, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So565497.jpg'}, {'end': 718.845, 'src': 'embed', 'start': 693.163, 'weight': 2, 'content': [{'end': 698.429, 'text': 'And in addition, this means that Tableau can effectively utilize unlimited amounts of data.', 'start': 693.163, 'duration': 5.266}, {'end': 703.915, 'text': 'Well, in fact, Tableau is the front-end analytics client to several of the large databases in the world.', 'start': 698.97, 'duration': 4.945}, {'end': 710.002, 'text': 'And it has optimized every connector to receive the advantage of unique characteristics of every data source.', 'start': 704.316, 'duration': 5.686}, {'end': 713.841, 'text': 'And this is the visualization that you can produce using Tableau.', 'start': 710.919, 'duration': 2.922}, {'end': 716.503, 'text': 'You can make a workbook for Tableau readers.', 'start': 714.282, 'duration': 2.221}, {'end': 718.845, 'text': 'You can also make static readers.', 'start': 717.004, 'duration': 1.841}], 'summary': 'Tableau optimizes connectors to handle unlimited data and produce diverse visualizations.', 'duration': 25.682, 'max_score': 693.163, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So693163.jpg'}, {'end': 762.01, 'src': 'embed', 'start': 734.967, 'weight': 4, 'content': [{'end': 740.032, 'text': 'So in-memory connection is a very fast data engine to optimize your analytics.', 'start': 734.967, 'duration': 5.065}, {'end': 746.359, 'text': 'You can connect your data and after that with one click, you can extract your data to get in-memory in Tableau.', 'start': 740.493, 'duration': 5.866}, {'end': 755.027, 'text': "And Tableau's data engine fully consumes your entire system to attain fast queries, answers, and millions of rows of data on commodity hardware.", 'start': 746.919, 'duration': 8.108}, {'end': 762.01, 'text': 'And since the data engine can use disk storage as well as RAM and cache memory,', 'start': 755.908, 'duration': 6.102}], 'summary': 'In-memory connection in tableau offers fast analytics, utilizing disk storage, ram, and cache memory for millions of rows of data.', 'duration': 27.043, 'max_score': 734.967, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So734967.jpg'}, {'end': 864.105, 'src': 'embed', 'start': 833.504, 'weight': 6, 'content': [{'end': 836.025, 'text': 'After you have installed Tableau Desktop.', 'start': 833.504, 'duration': 2.521}, {'end': 845.688, 'text': 'the latest version of Tableau Desktop is 10.2, so you can install that and after installing it will ask you to register to activate your version.', 'start': 836.025, 'duration': 9.663}, {'end': 848.008, 'text': "So you'll get a license key.", 'start': 846.508, 'duration': 1.5}, {'end': 854.17, 'text': 'you can purchase the license key and if you are a student and you want it for academic purpose, you can get it for free for a year.', 'start': 848.008, 'duration': 6.162}, {'end': 859.372, 'text': 'So you just have to go through the registration process and there you have Tableau ready to use.', 'start': 854.63, 'duration': 4.742}, {'end': 864.105, 'text': 'Now let us go ahead and understand Tableau a little bit more.', 'start': 860.649, 'duration': 3.456}], 'summary': 'Install tableau desktop 10.2, register, and get a free academic license for a year.', 'duration': 30.601, 'max_score': 833.504, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So833504.jpg'}, {'end': 906.271, 'src': 'embed', 'start': 878.415, 'weight': 7, 'content': [{'end': 884.498, 'text': 'You can connect it to Excel files, to text files, JSON files, or any kind of server as well.', 'start': 878.415, 'duration': 6.083}, {'end': 891.541, 'text': 'So if you already have a data set in your system, you can just go browse onto the file location and you can open that.', 'start': 885.298, 'duration': 6.243}, {'end': 899.226, 'text': 'So in Tableau, you will have a sample data set, which is the superstore, and you can rename it if you want to.', 'start': 892.441, 'duration': 6.785}, {'end': 906.271, 'text': "And when you load that data set, you'll see a preview of all the different fields and attributes of the data set that you have.", 'start': 899.946, 'duration': 6.325}], 'summary': "Tableau allows connection to various data sources like excel, text, json, and servers. it provides a sample data set, 'superstore', and allows for data set preview and renaming.", 'duration': 27.856, 'max_score': 878.415, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So878415.jpg'}, {'end': 990.673, 'src': 'embed', 'start': 966.152, 'weight': 8, 'content': [{'end': 971.837, 'text': 'Tableau also uses whole numbers and decimal numbers and also text and strings.', 'start': 966.152, 'duration': 5.685}, {'end': 974.799, 'text': 'And all these data types are represented by symbols.', 'start': 972.477, 'duration': 2.322}, {'end': 979.183, 'text': 'You can see over here that text and string values are represented by ABC.', 'start': 975.14, 'duration': 4.043}, {'end': 982.726, 'text': 'The date values are represented with a calendar icon.', 'start': 979.724, 'duration': 3.002}, {'end': 986.79, 'text': 'The date and time values are represented with a calendar icon but with a clock.', 'start': 982.866, 'duration': 3.924}, {'end': 990.673, 'text': 'The numerical values are represented with a hash symbol.', 'start': 987.33, 'duration': 3.343}], 'summary': 'Tableau uses whole numbers, decimal numbers, text, and strings, each represented by specific symbols.', 'duration': 24.521, 'max_score': 966.152, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So966152.jpg'}, {'end': 1112.63, 'src': 'embed', 'start': 1085.857, 'weight': 9, 'content': [{'end': 1090.12, 'text': 'So now let us move on and let us understand about dimensions and measures.', 'start': 1085.857, 'duration': 4.263}, {'end': 1093.803, 'text': 'So dimension is a field that is an independent variable.', 'start': 1090.941, 'duration': 2.862}, {'end': 1100.908, 'text': 'And the data types could be the strings, it could be geographic locations, numbers, date time, anything.', 'start': 1094.303, 'duration': 6.605}, {'end': 1104.571, 'text': 'And Tableau guesses the data type according to dimension names.', 'start': 1101.649, 'duration': 2.922}, {'end': 1112.63, 'text': 'So when you specify region, it might take it as a text or it might also take it as a geographic location.', 'start': 1105.487, 'duration': 7.143}], 'summary': 'Dimensions are fields representing independent variables with diverse data types, such as strings, geographic locations, and numbers, while tableau guesses the data type based on dimension names.', 'duration': 26.773, 'max_score': 1085.857, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So1085857.jpg'}, {'end': 1227.663, 'src': 'embed', 'start': 1199.031, 'weight': 10, 'content': [{'end': 1204.154, 'text': 'You can show your data by representing it in a pie chart, by heat maps, by bar diagrams.', 'start': 1199.031, 'duration': 5.123}, {'end': 1207.396, 'text': 'There are different styles of representing in bar graphs.', 'start': 1204.534, 'duration': 2.862}, {'end': 1211.559, 'text': 'Or you can also represent it in the geographical map.', 'start': 1208.017, 'duration': 3.542}, {'end': 1217.4, 'text': 'When you choose a data set, it will automatically highlight the data that you can use to represent it.', 'start': 1212.239, 'duration': 5.161}, {'end': 1220.921, 'text': 'If you see over here, some are blurred and some are not.', 'start': 1218, 'duration': 2.921}, {'end': 1227.663, 'text': 'So if it is blurred, you can understand that your data set is not compatible to use these kind of line graphs.', 'start': 1221.761, 'duration': 5.902}], 'summary': 'Data can be represented in different styles like pie charts, heat maps, and bar diagrams, and data compatibility can be checked for specific representations.', 'duration': 28.632, 'max_score': 1199.031, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So1199031.jpg'}, {'end': 1527.547, 'src': 'embed', 'start': 1504.187, 'weight': 11, 'content': [{'end': 1512.712, 'text': 'But this is just to give you a brief idea because your data set will definitely contain at least one or two different kinds of data among these.', 'start': 1504.187, 'duration': 8.525}, {'end': 1516.475, 'text': 'And now let us understand functions in Tableau.', 'start': 1513.873, 'duration': 2.602}, {'end': 1520.197, 'text': 'Now you can use different functions to join different data sets.', 'start': 1517.195, 'duration': 3.002}, {'end': 1527.547, 'text': 'If you want to combine columns, you can use joins, and it uses all the SQL joins that you might have studied about.', 'start': 1521.004, 'duration': 6.543}], 'summary': 'Tableau functions can join different data sets using various sql joins.', 'duration': 23.36, 'max_score': 1504.187, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So1504187.jpg'}, {'end': 1621.402, 'src': 'embed', 'start': 1553.063, 'weight': 16, 'content': [{'end': 1557.286, 'text': 'You can also sort your data with the tableau sort function.', 'start': 1553.063, 'duration': 4.223}, {'end': 1561.149, 'text': "Let's say that you want it in an increasing or decreasing order.", 'start': 1557.907, 'duration': 3.242}, {'end': 1566.433, 'text': 'You want to maybe see that which one has the maximum amount of sales and you want it on the top.', 'start': 1561.349, 'duration': 5.084}, {'end': 1569.716, 'text': 'So you can use the increasing order for that also.', 'start': 1566.873, 'duration': 2.843}, {'end': 1571.837, 'text': 'And it has different sorting techniques.', 'start': 1570.096, 'duration': 1.741}, {'end': 1575.08, 'text': 'You can choose any sort function that you want to represent your data.', 'start': 1571.877, 'duration': 3.203}, {'end': 1580.022, 'text': 'And set is a type of filter which we can set a condition for displaying values.', 'start': 1575.64, 'duration': 4.382}, {'end': 1584.023, 'text': "Let's say that we just want to display just one kind of value.", 'start': 1580.422, 'duration': 3.601}, {'end': 1590.306, 'text': "For example over here, let's say that if you want to represent discount which is greater than 10%.", 'start': 1584.584, 'duration': 5.722}, {'end': 1591.586, 'text': 'So we can use set for that.', 'start': 1590.306, 'duration': 1.28}, {'end': 1595.128, 'text': 'And this is actually a collection of dimension members.', 'start': 1592.087, 'duration': 3.041}, {'end': 1599.047, 'text': 'And you can also use Tableau UI for forecasting.', 'start': 1596.325, 'duration': 2.722}, {'end': 1601.488, 'text': 'So this is used for prediction.', 'start': 1599.847, 'duration': 1.641}, {'end': 1608.153, 'text': 'When you have a set of different trends going on, you can represent it by a line graph to represent a trend.', 'start': 1602.049, 'duration': 6.104}, {'end': 1617.959, 'text': 'And you can derive a future prediction or a future line graph according to the graphs that is represented for different years or different months.', 'start': 1608.593, 'duration': 9.366}, {'end': 1621.402, 'text': 'And you can use the line graph to predict the future as well.', 'start': 1618.72, 'duration': 2.682}], 'summary': 'Tableau allows sorting, filtering, and forecasting data for future predictions.', 'duration': 68.339, 'max_score': 1553.063, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So1553063.jpg'}, {'end': 1708.588, 'src': 'embed', 'start': 1683.019, 'weight': 19, 'content': [{'end': 1688.364, 'text': 'So all the visualizations that are created together in the dashboards might not fit into because it might be too small.', 'start': 1683.019, 'duration': 5.345}, {'end': 1690.985, 'text': "and you won't get a proper visualization.", 'start': 1688.764, 'duration': 2.221}, {'end': 1696.188, 'text': 'So you can design it and you can tweak the visualizations according to devices as well.', 'start': 1691.025, 'duration': 5.163}, {'end': 1700.11, 'text': 'So this is how you can make different visualizations in Tableau.', 'start': 1696.829, 'duration': 3.281}, {'end': 1708.588, 'text': 'So let us first get introduced to visual analysis.', 'start': 1705.447, 'duration': 3.141}], 'summary': 'Optimize visualizations for different devices in tableau to ensure proper visualization.', 'duration': 25.569, 'max_score': 1683.019, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So1683019.jpg'}, {'end': 1856.124, 'src': 'embed', 'start': 1824.365, 'weight': 20, 'content': [{'end': 1826.627, 'text': 'Now the first one is called attentive learning.', 'start': 1824.365, 'duration': 2.262}, {'end': 1834.214, 'text': 'This is where you have to put on a lot of attention to find out the data or to gain insights or extract the right knowledge from it.', 'start': 1827.088, 'duration': 7.126}, {'end': 1836.456, 'text': 'The next one is pre-attentive.', 'start': 1834.855, 'duration': 1.601}, {'end': 1843.359, 'text': 'This does not require that much attention like the one before and this makes it very easier for us to grasp on.', 'start': 1836.856, 'duration': 6.503}, {'end': 1848.341, 'text': "So this is the baseline that you need to understand when you're trying to represent your data.", 'start': 1843.719, 'duration': 4.622}, {'end': 1856.124, 'text': 'Try to understand the ways and the possibilities about how you can represent your data in a more informative way.', 'start': 1848.721, 'duration': 7.403}], 'summary': 'Attentive learning requires focused attention, while pre-attentive makes it easier to grasp information. consider different ways to represent data for better understanding.', 'duration': 31.759, 'max_score': 1824.365, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So1824365.jpg'}, {'end': 2098.102, 'src': 'embed', 'start': 2071.391, 'weight': 5, 'content': [{'end': 2076.297, 'text': 'It can connect directly to data from your data warehouse for live up-to-date data analysis.', 'start': 2071.391, 'duration': 4.906}, {'end': 2079.502, 'text': 'It can perform queries without writing a single line of code.', 'start': 2076.719, 'duration': 2.783}, {'end': 2085.909, 'text': "It can also import data into Tableau's data engine from multiple sources and integrate them as well.", 'start': 2080.023, 'duration': 5.886}, {'end': 2091.475, 'text': 'You can also combine multiple views in an interactive dashboard with the help of Tableau Desktop.', 'start': 2086.37, 'duration': 5.105}, {'end': 2094.818, 'text': 'And another version of Tableau Desktop is the Tableau Server.', 'start': 2092.054, 'duration': 2.764}, {'end': 2098.102, 'text': 'Now this is a more enterprise-based Tableau Desktop.', 'start': 2094.858, 'duration': 3.244}], 'summary': 'Tableau enables live data analysis, query without code, data integration, and interactive dashboards.', 'duration': 26.711, 'max_score': 2071.391, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2071391.jpg'}, {'end': 2144.958, 'src': 'embed', 'start': 2113.458, 'weight': 13, 'content': [{'end': 2117.582, 'text': 'What it does is that it leverages fast databases through the live connections.', 'start': 2113.458, 'duration': 4.124}, {'end': 2126.146, 'text': 'Whereas Tableau Online over here, this is a hosted version of Tableau Server and it makes business intelligence faster and easier than before.', 'start': 2118.123, 'duration': 8.023}, {'end': 2132.109, 'text': 'You can publish Tableau Dashboards with Tableau Desktop and then you can share them with your colleagues or friends.', 'start': 2126.627, 'duration': 5.482}, {'end': 2134.61, 'text': 'And then we come to Tableau Reader.', 'start': 2132.749, 'duration': 1.861}, {'end': 2137.732, 'text': 'Now, this is just a readable version.', 'start': 2134.99, 'duration': 2.742}, {'end': 2144.958, 'text': 'it is a free desktop application and it will just enable you to open and view the visualizations built in the Tableau desktop.', 'start': 2137.732, 'duration': 7.226}], 'summary': 'Tableau products enable faster and easier business intelligence with live connections and visualization sharing.', 'duration': 31.5, 'max_score': 2113.458, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2113458.jpg'}, {'end': 2184.191, 'src': 'embed', 'start': 2155.346, 'weight': 15, 'content': [{'end': 2162.171, 'text': 'This completely depends on how the author has represented it, so you cannot make any changes, but you can only use filters on that.', 'start': 2155.346, 'duration': 6.825}, {'end': 2166.683, 'text': 'So these are the versions that you get in the Tableau product family.', 'start': 2162.901, 'duration': 3.782}, {'end': 2174.086, 'text': 'And right now the latest version of Tableau desktop is the Tableau 10.2, which is the best among them.', 'start': 2167.183, 'duration': 6.903}, {'end': 2177.848, 'text': 'So you can directly download Tableau desktop and you can register it.', 'start': 2174.266, 'duration': 3.582}, {'end': 2184.191, 'text': "You'll get a license key or even if you just want to try it first, they'll give you a trial version, which is for 15 days.", 'start': 2178.288, 'duration': 5.903}], 'summary': 'Tableau 10.2 is the latest version of tableau desktop, offering a 15-day trial period.', 'duration': 28.845, 'max_score': 2155.346, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2155346.jpg'}, {'end': 2225.175, 'src': 'embed', 'start': 2197.294, 'weight': 14, 'content': [{'end': 2202.735, 'text': 'So Tableau Public is something where you create visualizations but you cannot keep it with you.', 'start': 2197.294, 'duration': 5.441}, {'end': 2205.335, 'text': 'You have to publish it and everyone can see it.', 'start': 2202.775, 'duration': 2.56}, {'end': 2206.656, 'text': "So it's up to you.", 'start': 2205.935, 'duration': 0.721}, {'end': 2214.057, 'text': "I'll just suggest you to go and download Tableau Desktop and I will advise you to download the latest version which is 10.2.", 'start': 2206.856, 'duration': 7.201}, {'end': 2217.924, 'text': "So we'll move on and let us see why Tableau.", 'start': 2214.057, 'duration': 3.867}, {'end': 2225.175, 'text': 'So these are the pros of Tableau or the features of Tableau because of which it makes Tableau very easy and very popular.', 'start': 2218.444, 'duration': 6.731}], 'summary': 'Tableau public allows sharing visualizations; recommend downloading tableau desktop 10.2 for its features.', 'duration': 27.881, 'max_score': 2197.294, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2197294.jpg'}], 'start': 371.72, 'title': 'Tableau data visualization', 'summary': "Covers data visualization with tableau, its architecture, installation, dimensions, measures, visualizations, data sorting, filtering, forecasting, and insights into tableau's advantages, including its popularity and the latest version, tableau 10.2.", 'chapters': [{'end': 778.578, 'start': 371.72, 'title': 'Data visualization with tableau', 'summary': 'Explains how data visualization works, the features of tableau, its popularity, and the architecture of tableau, emphasizing its flexibility, quick production time, and unique data blending real-time collaboration, and in-memory connection.', 'duration': 406.858, 'highlights': ['Tableau is considered the gold standard for intuitive, interactive visual analytics, providing a very intuitive platform, and it is among the top charts for visual analytics and presentation tools.', "Tableau provides quick production time, taking only a few seconds to create visualizations, and has managed to be in Gartner's magic quadrant for years.", 'Tableau offers various data connectors for databases and allows integration and connection of different data sets, making it very flexible.', 'Tableau enables data blending real-time collabs, which is what makes Tableau stand out from all its competitors, and it is very unique.', 'In-memory connection in Tableau is a very fast data engine to optimize analytics, enabling fast queries, answers, and millions of rows of data on commodity hardware.']}, {'end': 1085.037, 'start': 778.578, 'title': 'Tableau architecture and installation', 'summary': 'Discusses the tableau architecture, installation process, and connecting to different data sources. it also covers data types and the tableau desktop ui.', 'duration': 306.459, 'highlights': ['The Tableau architecture involves connecting to a data source, analyzing it, and providing visualizations, with Tableau Desktop 10.2 being the latest version.', 'Installing Tableau is easy, taking only minutes, and can be free for academic purposes, requiring registration and a license key.', 'Tableau allows connecting to various data sources such as Excel, text, JSON files, or servers, enabling easy browsing and previewing of datasets.', 'Tableau supports diverse data types including Boolean, date, timestamp, geographical values, whole numbers, decimal numbers, and text, with automatic detection of data types.', 'The Tableau desktop UI includes dimensions and measures, a toolbar for data representation, rows and columns section for arranging data, and a canvas for creating workbooks or dashboards.']}, {'end': 1552.182, 'start': 1085.857, 'title': 'Understanding dimensions, measures, and visualizations', 'summary': 'Explains the concepts of dimensions and measures in tableau, where dimensions are independent variables with data types like strings, geographic locations, and numbers, while measures are all numeric data types; it also delves into different visualization options such as bar graphs, line graphs, dual axis graphs, geographical graphs, heat maps, and tree maps, along with the appropriate scenarios for using each visualization.', 'duration': 466.325, 'highlights': ['The chapter explains the concepts of dimensions and measures in Tableau, where dimensions are independent variables with data types like strings, geographic locations, and numbers, while measures are all numeric data types.', 'It delves into different visualization options such as bar graphs, line graphs, dual axis graphs, geographical graphs, heat maps, and tree maps, along with the appropriate scenarios for using each visualization.', 'The chapter discusses using different functions like joins and unions to combine different data sets in Tableau, including inner join, full outer join, left join, right join, and union.']}, {'end': 2001.895, 'start': 1553.063, 'title': 'Tableau data visualization', 'summary': 'Discusses data sorting, filtering, forecasting, visualization design, and visual analysis in tableau, emphasizing the importance of pre-attentive perception and the effectiveness of bar diagrams over pie charts for sales analysis.', 'duration': 448.832, 'highlights': ['The chapter highlights the sorting techniques available in Tableau, including sorting in increasing or decreasing order based on criteria such as maximum sales (e.g., highlighting trends with the maximum sales) and the use of different sorting functions to represent data. (Relevance: 5)', 'It discusses the use of set as a filter to display specific values (e.g., displaying discounts greater than 10%) and its application in representing dimension members, emphasizing its role in business intelligence for making predictions for investments. (Relevance: 4)', 'The chapter explains the use of Tableau UI for forecasting, particularly for representing trends with line graphs to derive future predictions based on historical data, highlighting its significance in business intelligence. (Relevance: 3)', 'It emphasizes the importance of designing visuals in Tableau for specific devices such as mobile phones or tablets due to varying screen resolutions, ensuring proper visualization and user experience, and provides insights into the cycle of visual analysis, from data acquisition to delivery. (Relevance: 2)', 'The chapter provides a practical exercise to illustrate the impact of pre-attentive perception on data visualization and understanding, highlighting the significance of visually enhancing data to facilitate quicker insights and knowledge extraction, and distinguishes between attentive and pre-attentive learning in data perception. (Relevance: 1)']}, {'end': 2340.157, 'start': 2002.275, 'title': 'Tableau visualization insights', 'summary': 'Emphasizes the advantages of tableau desktop for data visualization, including its ease of use, ability to connect to various data sources, and comprehensive visualization options, with tableau 10.2 being the latest version.', 'duration': 337.882, 'highlights': ['Tableau Desktop allows for direct connections to data warehouses for live up-to-date data analysis, and can perform queries without coding, making it a self-service business analytics tool.', 'Tableau Server is an enterprise-based version used for publishing and sharing dashboards throughout the organization, leveraging fast databases through live connections.', 'Tableau Public enables visualization creation and sharing with public access, while Tableau Reader allows the viewing of visualizations without the ability to edit or perform interactions.', 'The latest version of Tableau Desktop is Tableau 10.2, offering features such as easy data representation, direct connections to various data sources, and comprehensive visualization options, making it a popular and easy-to-use tool.']}], 'duration': 1968.437, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So371720.jpg', 'highlights': ['Tableau is considered the gold standard for intuitive, interactive visual analytics, and it is among the top charts for visual analytics and presentation tools.', "Tableau provides quick production time, taking only a few seconds to create visualizations, and has managed to be in Gartner's magic quadrant for years.", 'Tableau offers various data connectors for databases and allows integration and connection of different data sets, making it very flexible.', 'Tableau enables data blending real-time collabs, which is what makes Tableau stand out from all its competitors, and it is very unique.', 'In-memory connection in Tableau is a very fast data engine to optimize analytics, enabling fast queries, answers, and millions of rows of data on commodity hardware.', 'The Tableau architecture involves connecting to a data source, analyzing it, and providing visualizations, with Tableau Desktop 10.2 being the latest version.', 'Installing Tableau is easy, taking only minutes, and can be free for academic purposes, requiring registration and a license key.', 'Tableau allows connecting to various data sources such as Excel, text, JSON files, or servers, enabling easy browsing and previewing of datasets.', 'Tableau supports diverse data types including Boolean, date, timestamp, geographical values, whole numbers, decimal numbers, and text, with automatic detection of data types.', 'The chapter explains the concepts of dimensions and measures in Tableau, where dimensions are independent variables with data types like strings, geographic locations, and numbers, while measures are all numeric data types.', 'It delves into different visualization options such as bar graphs, line graphs, dual axis graphs, geographical graphs, heat maps, and tree maps, along with the appropriate scenarios for using each visualization.', 'The chapter discusses using different functions like joins and unions to combine different data sets in Tableau, including inner join, full outer join, left join, right join, and union.', 'Tableau Desktop allows for direct connections to data warehouses for live up-to-date data analysis, and can perform queries without coding, making it a self-service business analytics tool.', 'Tableau Server is an enterprise-based version used for publishing and sharing dashboards throughout the organization, leveraging fast databases through live connections.', 'Tableau Public enables visualization creation and sharing with public access, while Tableau Reader allows the viewing of visualizations without the ability to edit or perform interactions.', 'The latest version of Tableau Desktop is Tableau 10.2, offering features such as easy data representation, direct connections to various data sources, and comprehensive visualization options, making it a popular and easy-to-use tool.', 'The chapter highlights the sorting techniques available in Tableau, including sorting in increasing or decreasing order based on criteria such as maximum sales (e.g., highlighting trends with the maximum sales) and the use of different sorting functions to represent data.', 'It discusses the use of set as a filter to display specific values (e.g., displaying discounts greater than 10%) and its application in representing dimension members, emphasizing its role in business intelligence for making predictions for investments.', 'The chapter explains the use of Tableau UI for forecasting, particularly for representing trends with line graphs to derive future predictions based on historical data, highlighting its significance in business intelligence.', 'It emphasizes the importance of designing visuals in Tableau for specific devices such as mobile phones or tablets due to varying screen resolutions, ensuring proper visualization and user experience, and provides insights into the cycle of visual analysis, from data acquisition to delivery.', 'The chapter provides a practical exercise to illustrate the impact of pre-attentive perception on data visualization and understanding, highlighting the significance of visually enhancing data to facilitate quicker insights and knowledge extraction, and distinguishes between attentive and pre-attentive learning in data perception.']}, {'end': 3175.608, 'segs': [{'end': 2385.603, 'src': 'embed', 'start': 2359.106, 'weight': 0, 'content': [{'end': 2366.108, 'text': "And you can connect it to any kind of file, whether it's an Excel file, text file, JSON file, Access file, Spatial file.", 'start': 2359.106, 'duration': 7.002}, {'end': 2367.469, 'text': 'statistical file.', 'start': 2366.548, 'duration': 0.921}, {'end': 2375.995, 'text': 'If you also want to connect it to a server, you can connect it to a Tableau server, the Microsoft SQL server, MySQL, Oracle, Amazon,', 'start': 2367.909, 'duration': 8.086}, {'end': 2378.277, 'text': 'Redshift and there are even more options.', 'start': 2375.995, 'duration': 2.282}, {'end': 2385.603, 'text': "Well, in Tableau you also have a sample databases, so if you're using Tableau for the first time and you don't have a data set yet,", 'start': 2378.738, 'duration': 6.865}], 'summary': 'Tableau can connect to various file types and servers, including tableau server, microsoft sql server, mysql, oracle, amazon redshift, and more.', 'duration': 26.497, 'max_score': 2359.106, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2359106.jpg'}, {'end': 2433.259, 'src': 'embed', 'start': 2399.733, 'weight': 1, 'content': [{'end': 2401.134, 'text': 'You can connect live.', 'start': 2399.733, 'duration': 1.401}, {'end': 2407.598, 'text': 'It means that connecting directly to your data and the speed of your data source will determine the performance.', 'start': 2401.775, 'duration': 5.823}, {'end': 2414.243, 'text': "You can import all the data into Tableau's data engine, or you can import only some of the data,", 'start': 2408.099, 'duration': 6.144}, {'end': 2419.887, 'text': 'or the data or the fields or parameters that you might need in order to make your visualizations.', 'start': 2414.243, 'duration': 5.644}, {'end': 2422.549, 'text': 'So you can choose from any of these three options.', 'start': 2420.387, 'duration': 2.162}, {'end': 2427.033, 'text': 'So the second two options can be also called as in-memory connection.', 'start': 2423.31, 'duration': 3.723}, {'end': 2433.259, 'text': 'And in order to make connections to a database, Tableau has got an amount of optimized data connectors.', 'start': 2427.754, 'duration': 5.505}], 'summary': 'Tableau offers live connection, in-memory connection, and optimized data connectors for database connections.', 'duration': 33.526, 'max_score': 2399.733, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2399733.jpg'}, {'end': 2578.504, 'src': 'embed', 'start': 2547.469, 'weight': 2, 'content': [{'end': 2549.631, 'text': 'So these are the joins that are available.', 'start': 2547.469, 'duration': 2.162}, {'end': 2552.013, 'text': 'You might have seen this in the SQL joins.', 'start': 2549.691, 'duration': 2.322}, {'end': 2553.574, 'text': 'This is exactly the same.', 'start': 2552.113, 'duration': 1.461}, {'end': 2559.137, 'text': 'You can either choose a left join, a right join, an inner join and a full outer join.', 'start': 2554.255, 'duration': 4.882}, {'end': 2565.059, 'text': 'So the left join means everything from the data set including the common one from the other data set.', 'start': 2559.737, 'duration': 5.322}, {'end': 2570.181, 'text': 'The right join means everything from the second database and the common ones with the first database.', 'start': 2565.479, 'duration': 4.702}, {'end': 2578.504, 'text': 'The inner join means only the common part of both the two databases and full outer join means all the fields of both the databases.', 'start': 2570.721, 'duration': 7.783}], 'summary': 'Explains sql joins: left, right, inner, and full outer joins with their functionalities.', 'duration': 31.035, 'max_score': 2547.469, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2547469.jpg'}, {'end': 2650.44, 'src': 'embed', 'start': 2628.668, 'weight': 3, 'content': [{'end': 2638.352, 'text': 'So they can be in the form of heat maps, tree maps, in bar diagrams, in pie charts, or even you can represent it according to geographical locations.', 'start': 2628.668, 'duration': 9.684}, {'end': 2641.773, 'text': 'So you have the liberty to choose how you want to represent it.', 'start': 2638.792, 'duration': 2.981}, {'end': 2646.797, 'text': 'But sometimes it may happen that some of the options might be unavailable for your data.', 'start': 2642.273, 'duration': 4.524}, {'end': 2650.44, 'text': "And this completely depends on the data source that you're dealing with.", 'start': 2647.257, 'duration': 3.183}], 'summary': 'Data visualization options include heat maps, tree maps, bar diagrams, pie charts, and geographical representation, but availability depends on the data source.', 'duration': 21.772, 'max_score': 2628.668, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2628668.jpg'}, {'end': 2753.998, 'src': 'embed', 'start': 2725.675, 'weight': 6, 'content': [{'end': 2731.861, 'text': 'So filter is a Tableau term, and it technically applies only to context and traditional filters.', 'start': 2725.675, 'duration': 6.186}, {'end': 2738.748, 'text': 'But however, the custom SQL filter emulates the behavior of a global context filter, so we will refer to it as such.', 'start': 2732.382, 'duration': 6.366}, {'end': 2743.813, 'text': 'So now, since I was already talking about context filter, what is a context filter?', 'start': 2739.388, 'duration': 4.425}, {'end': 2749.413, 'text': 'It is filter in Tableau that affects the data that is transferred to each individual worksheet.', 'start': 2744.548, 'duration': 4.865}, {'end': 2753.998, 'text': 'So context filters are great when you want to limit the data seen by the worksheet.', 'start': 2749.893, 'duration': 4.105}], 'summary': 'Context filters in tableau limit data seen by worksheets.', 'duration': 28.323, 'max_score': 2725.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2725675.jpg'}, {'end': 2857.203, 'src': 'embed', 'start': 2829.178, 'weight': 7, 'content': [{'end': 2833.502, 'text': 'So while there are other methods to also enhance your data, sorting can be one option.', 'start': 2829.178, 'duration': 4.324}, {'end': 2837.746, 'text': 'But sorting cannot always be the right choice when you want to represent it.', 'start': 2834.002, 'duration': 3.744}, {'end': 2842.67, 'text': 'So you also have to be able to drill down to granularity of your detail too.', 'start': 2838.346, 'duration': 4.324}, {'end': 2845.633, 'text': 'And hierarchies can provide a way to do that.', 'start': 2843.17, 'duration': 2.463}, {'end': 2852.199, 'text': 'So you can start with a high-level overview of data and then drill down to lower levels of detail on demand.', 'start': 2846.253, 'duration': 5.946}, {'end': 2857.203, 'text': 'It means that you can represent even the granular form of data by hierarchies.', 'start': 2852.859, 'duration': 4.344}], 'summary': 'Sorting is one way to enhance data, but hierarchies allow for drill down to lower levels of detail.', 'duration': 28.025, 'max_score': 2829.178, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2829178.jpg'}, {'end': 2989.67, 'src': 'embed', 'start': 2958.809, 'weight': 8, 'content': [{'end': 2961.61, 'text': 'Now let us see the different data types in Tableau.', 'start': 2958.809, 'duration': 2.801}, {'end': 2963.71, 'text': 'So the first one is Boolean.', 'start': 2962.17, 'duration': 1.54}, {'end': 2968.431, 'text': 'So as you all know what Boolean is, it is either a true or false value.', 'start': 2964.17, 'duration': 4.261}, {'end': 2970.731, 'text': 'The next one are whole numbers.', 'start': 2968.971, 'duration': 1.76}, {'end': 2976.852, 'text': 'Like for example you can see like 300, 400, starting from zero to infinity, all the whole numbers.', 'start': 2971.051, 'duration': 5.801}, {'end': 2980.473, 'text': 'Then you can also represent decimal numbers in Tableau as well.', 'start': 2977.473, 'duration': 3}, {'end': 2984.974, 'text': 'Then you have got a data type which is called date or date and time stamp.', 'start': 2981.073, 'duration': 3.901}, {'end': 2989.67, 'text': 'It means that it will specify the month, day, year, and also the time.', 'start': 2985.58, 'duration': 4.09}], 'summary': 'Tableau has various data types such as boolean, whole numbers, decimal numbers, and date/time stamps.', 'duration': 30.861, 'max_score': 2958.809, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2958809.jpg'}, {'end': 3104.192, 'src': 'embed', 'start': 3071.695, 'weight': 9, 'content': [{'end': 3075.997, 'text': 'So you can also explicitly define which is a dimension and measure in Tableau.', 'start': 3071.695, 'duration': 4.302}, {'end': 3079.219, 'text': 'So dimensions are used to add level of detail.', 'start': 3076.577, 'duration': 2.642}, {'end': 3081, 'text': 'Now measures are just numbers.', 'start': 3079.639, 'duration': 1.361}, {'end': 3085.742, 'text': "So let's consider the same example again of a class of students and their marks.", 'start': 3081.5, 'duration': 4.242}, {'end': 3089.424, 'text': 'So their marks, since they are numbers, they will be treated as measures.', 'start': 3086.283, 'duration': 3.141}, {'end': 3091.966, 'text': 'And dimensions could be the name of subjects.', 'start': 3090.025, 'duration': 1.941}, {'end': 3096.288, 'text': 'So if you just say a mark of a particular student, that makes no sense.', 'start': 3092.626, 'duration': 3.662}, {'end': 3104.192, 'text': "But let's say that you add something like the mark of a particular student in science, mark of a particular student in social studies,", 'start': 3096.748, 'duration': 7.444}], 'summary': 'In tableau, dimensions add detail, measures are numbers. example: student marks as measures, subjects as dimensions.', 'duration': 32.497, 'max_score': 3071.695, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So3071695.jpg'}, {'end': 3140.193, 'src': 'embed', 'start': 3113.356, 'weight': 4, 'content': [{'end': 3117.218, 'text': 'So now let us see how successful Tableau has been in the past years.', 'start': 3113.356, 'duration': 3.862}, {'end': 3120.66, 'text': "So this is Gartner's magic quadrant.", 'start': 3117.978, 'duration': 2.682}, {'end': 3126.724, 'text': 'And this is the magic quadrant that Gartner created for the business intelligence and analytics platform.', 'start': 3121.4, 'duration': 5.324}, {'end': 3130.386, 'text': 'And you can see Tableau lies among the leaders quadrant.', 'start': 3127.184, 'duration': 3.202}, {'end': 3134.389, 'text': 'And this is the ability to execute, so this lies on top.', 'start': 3131.027, 'duration': 3.362}, {'end': 3140.193, 'text': "And let me tell you that Tableau has been leading in Gartner's magic quadrant since the past three years.", 'start': 3134.829, 'duration': 5.364}], 'summary': "Tableau has been a leader in gartner's magic quadrant for business intelligence and analytics platform for the past three years.", 'duration': 26.837, 'max_score': 3113.356, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So3113356.jpg'}, {'end': 3180.553, 'src': 'embed', 'start': 3152.766, 'weight': 5, 'content': [{'end': 3159.413, 'text': 'So there was something like Deloitte builds a culture of enablement with thousands of Tableau users.', 'start': 3152.766, 'duration': 6.647}, {'end': 3161.515, 'text': 'The same with data finaletics.', 'start': 3160.074, 'duration': 1.441}, {'end': 3165.719, 'text': "The finalist scores goal with data inside and they're all using Tableau.", 'start': 3161.876, 'duration': 3.843}, {'end': 3169.783, 'text': 'So you can see how popular Tableau has been and still is.', 'start': 3166.12, 'duration': 3.663}, {'end': 3175.608, 'text': "And I'm pretty sure that Tableau will stay popular because you've already seen what can we do with Tableau.", 'start': 3170.203, 'duration': 5.405}, {'end': 3180.553, 'text': "So now it's time to show you all the demo of how to use Tableau.", 'start': 3176.509, 'duration': 4.044}], 'summary': 'Deloitte and data finaletics enable thousands of users with tableau, a popular and powerful tool for data visualization.', 'duration': 27.787, 'max_score': 3152.766, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So3152766.jpg'}], 'start': 2340.618, 'title': 'Tableau data visualization', 'summary': "Covers connecting to various data sources in tableau, live connection options, in-memory connection, data joining, and visualization types. it also discusses maps, filters, sql custom filters, context filters, traditional filters, hierarchies, grouping, sets, data types, measures, dimensions, and tableau's recognition in gartner's magic quadrant and customer testimonials.", 'chapters': [{'end': 2665.292, 'start': 2340.618, 'title': 'Tableau data connection and visualization', 'summary': 'Discusses how to connect to various data sources in tableau, including file types and servers, and the options for live connection, in-memory connection, and data joining, with a focus on the visualization types available in tableau.', 'duration': 324.674, 'highlights': ['Tableau offers various options to connect to data sources including Excel, text, JSON, Access, spatial and statistical files, as well as servers like Tableau server, Microsoft SQL server, MySQL, Oracle, Amazon, Redshift.', 'Tableau provides options for live connection, in-memory connection, and optimized data connectors, allowing users to import all data, some of the data, or specific fields and parameters.', 'The chapter explains the process of combining different data sources using joins such as left join, right join, inner join, and full outer join, providing examples of how it can be useful for analyzing data from multiple sources.', 'The visualization options in Tableau include heat maps, tree maps, bar diagrams, pie charts, and geographical representations, offering users the flexibility to choose suitable visualization types based on their data, with some options being dependent on the available data fields.']}, {'end': 3175.608, 'start': 2665.737, 'title': 'Tableau data visualization & filtering', 'summary': "Discusses when and how to use different maps and filters in tableau, covering sql custom filters, context filters, traditional filters, hierarchies, grouping, sets, data types, measures, dimensions, and tableau's success in gartner's magic quadrant and customer testimonials.", 'duration': 509.871, 'highlights': ["Tableau has been leading in Gartner's magic quadrant for the past three years, positioning it among the leaders quadrant in the business intelligence and analytics platform, demonstrating its ability to execute effectively.", "Deloitte and Data Finaletics are among the companies using Tableau to enable thousands of users and achieve data-driven successes, showcasing Tableau's popularity and effectiveness in real-world applications.", 'The chapter provides insights into different types of filters in Tableau, including SQL custom filters, context filters, and traditional filters, with a focus on enhancing data visualization through effective filtering strategies.', 'The discussion covers the importance of hierarchies in representing data, allowing users to start with a high-level overview and drill down to granular levels, providing a comprehensive view of the data.', 'The transcript details various data types in Tableau, such as Boolean, whole numbers, decimal numbers, date and time stamps, text or string, and geographic values, enabling users to understand the diverse data representation capabilities within Tableau.', 'The distinction between dimensions and measures in Tableau is explained, where dimensions are used to add levels of detail onto data, while measures are utilized for numerical values, providing clarity on the role of each in data visualization and analysis.']}], 'duration': 834.99, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So2340618.jpg', 'highlights': ['Tableau offers various options to connect to data sources including Excel, text, JSON, Access, spatial and statistical files, as well as servers like Tableau server, Microsoft SQL server, MySQL, Oracle, Amazon, Redshift.', 'Tableau provides options for live connection, in-memory connection, and optimized data connectors, allowing users to import all data, some of the data, or specific fields and parameters.', 'The chapter explains the process of combining different data sources using joins such as left join, right join, inner join, and full outer join, providing examples of how it can be useful for analyzing data from multiple sources.', 'The visualization options in Tableau include heat maps, tree maps, bar diagrams, pie charts, and geographical representations, offering users the flexibility to choose suitable visualization types based on their data, with some options being dependent on the available data fields.', "Tableau has been leading in Gartner's magic quadrant for the past three years, positioning it among the leaders quadrant in the business intelligence and analytics platform, demonstrating its ability to execute effectively.", "Deloitte and Data Finaletics are among the companies using Tableau to enable thousands of users and achieve data-driven successes, showcasing Tableau's popularity and effectiveness in real-world applications.", 'The chapter provides insights into different types of filters in Tableau, including SQL custom filters, context filters, and traditional filters, with a focus on enhancing data visualization through effective filtering strategies.', 'The discussion covers the importance of hierarchies in representing data, allowing users to start with a high-level overview and drill down to granular levels, providing a comprehensive view of the data.', 'The transcript details various data types in Tableau, such as Boolean, whole numbers, decimal numbers, date and time stamps, text or string, and geographic values, enabling users to understand the diverse data representation capabilities within Tableau.', 'The distinction between dimensions and measures in Tableau is explained, where dimensions are used to add levels of detail onto data, while measures are utilized for numerical values, providing clarity on the role of each in data visualization and analysis.']}, {'end': 5922.247, 'segs': [{'end': 3230.351, 'src': 'embed', 'start': 3201.1, 'weight': 4, 'content': [{'end': 3204.2, 'text': 'The version is 10.2.', 'start': 3201.1, 'duration': 3.1}, {'end': 3207.801, 'text': 'So the first thing that I need to do, I need to connect to my database.', 'start': 3204.2, 'duration': 3.601}, {'end': 3212.742, 'text': 'And here you can see all the options or all the kind of data sets that you can go connect to.', 'start': 3208.461, 'duration': 4.281}, {'end': 3214.842, 'text': 'You can connect it to any kind of server.', 'start': 3212.782, 'duration': 2.06}, {'end': 3218.223, 'text': 'You can connect it to a local file that is in your system.', 'start': 3215.222, 'duration': 3.001}, {'end': 3220.903, 'text': 'So my file is a CSV file.', 'start': 3218.683, 'duration': 2.22}, {'end': 3222.564, 'text': "So I'm going to go ahead and click on more.", 'start': 3220.943, 'duration': 1.621}, {'end': 3224.564, 'text': 'And this is my file.', 'start': 3223.264, 'duration': 1.3}, {'end': 3230.351, 'text': "So I'll go select update now and I have chosen a live connection.", 'start': 3225.99, 'duration': 4.361}], 'summary': 'Version 10.2 allows connection to various data sets, including csv files, enabling live connections.', 'duration': 29.251, 'max_score': 3201.1, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So3201100.jpg'}, {'end': 3484.505, 'src': 'heatmap', 'start': 3235.033, 'weight': 0, 'content': [{'end': 3242.976, 'text': "So I've got a record ID, the agency code, agency name, type, the city, the state, year, month, incident.", 'start': 3235.033, 'duration': 7.943}, {'end': 3247.337, 'text': 'So these are all the different fields that we are going to work with.', 'start': 3243.896, 'duration': 3.441}, {'end': 3257.106, 'text': 'So it contains the crime type, whether the crime was solved or not, the victim, sex, the victim, race, victim, ethnicity, the perpetrator,', 'start': 3248.078, 'duration': 9.028}, {'end': 3258.447, 'text': 'which is basically the killer.', 'start': 3257.106, 'duration': 1.341}, {'end': 3260.569, 'text': "That's a fancy name for a killer.", 'start': 3258.467, 'duration': 2.102}, {'end': 3270.798, 'text': 'So this is all the killer details, the weapon, and it contains the crime records in US across multiple years.', 'start': 3261.19, 'duration': 9.608}, {'end': 3274.922, 'text': "So we'll go ahead and we'll play around with this dataset.", 'start': 3271.579, 'duration': 3.343}, {'end': 3281.727, 'text': 'So next thing you need to do, you need to make a worksheet where you can create all those visualizations in.', 'start': 3276.343, 'duration': 5.384}, {'end': 3286.371, 'text': 'So here, just click on this or click on here to go to your worksheet.', 'start': 3282.308, 'duration': 4.063}, {'end': 3289.293, 'text': 'So just click on here to go to your worksheet.', 'start': 3287.191, 'duration': 2.102}, {'end': 3291.295, 'text': 'So this is your first sheet.', 'start': 3289.873, 'duration': 1.422}, {'end': 3301.579, 'text': 'And the first thing that I want to find out from this data set which state has the maximum number of victims or which state has the maximum number of crimes,', 'start': 3291.635, 'duration': 9.944}, {'end': 3306.861, 'text': 'and that we can find out by taking in account the victim count, we can see that how many people were killed?', 'start': 3301.579, 'duration': 5.282}, {'end': 3312.283, 'text': 'so the place or the state where maximum people were killed should be the highest crime state.', 'start': 3306.861, 'duration': 5.422}, {'end': 3319.418, 'text': "So this is what we're going to find out, and these are dimensions, all the text fields and hierarchies.", 'start': 3313.277, 'duration': 6.141}, {'end': 3325.9, 'text': "So we've got the measures here which are numbers like victim count, age, perpetrator count and age and incident.", 'start': 3319.898, 'duration': 6.002}, {'end': 3329.921, 'text': 'So now I want a geographical visualization.', 'start': 3326.66, 'duration': 3.261}, {'end': 3333.941, 'text': 'So for that I have got my geographical measures.', 'start': 3330.301, 'duration': 3.64}, {'end': 3340.863, 'text': 'So these are the geographical values that will help me to plot the visualizations on a world map.', 'start': 3334.582, 'duration': 6.281}, {'end': 3346.486, 'text': "So here I'll just drag and drop longitude onto columns and latitude onto rows.", 'start': 3341.323, 'duration': 5.163}, {'end': 3350.909, 'text': 'And then let me select state and put it onto detail.', 'start': 3347.347, 'duration': 3.562}, {'end': 3354.712, 'text': 'And let me just take victim count and put it on color.', 'start': 3351.57, 'duration': 3.142}, {'end': 3357.735, 'text': 'And now you can see that the colors are different.', 'start': 3355.492, 'duration': 2.243}, {'end': 3364.723, 'text': 'Somewhere the blue is darker and the place where the blue is the darkest is California and the victim count is 11, 450 here.', 'start': 3357.775, 'duration': 6.948}, {'end': 3366.565, 'text': 'Next one might be Texas with 7, 048 victims.', 'start': 3364.763, 'duration': 1.802}, {'end': 3381.555, 'text': 'Now this shows the overall victim count across all years and if you want to see it just for a particular year, so we can add filters for that,', 'start': 3372.151, 'duration': 9.404}, {'end': 3385.596, 'text': 'because we have got a dimension which is year.', 'start': 3381.555, 'duration': 4.041}, {'end': 3394.8, 'text': 'so you just drag and drop here onto filter and you can select if you want it for a range of values, or at least at most.', 'start': 3385.596, 'duration': 9.204}, {'end': 3400.082, 'text': 'so you can just drag it and see the view across 10 years or 5 years altogether.', 'start': 3394.8, 'duration': 5.282}, {'end': 3401.937, 'text': 'So just click on OK.', 'start': 3400.796, 'duration': 1.141}, {'end': 3404.478, 'text': 'And then just click on show filter.', 'start': 3402.797, 'duration': 1.681}, {'end': 3407.28, 'text': 'So this is going to be something like that.', 'start': 3405.279, 'duration': 2.001}, {'end': 3410.402, 'text': 'So I want it from 2000 to 2014.', 'start': 3407.861, 'duration': 2.541}, {'end': 3416.046, 'text': 'So still California has got the highest victim count with 4002.', 'start': 3410.402, 'duration': 5.644}, {'end': 3420.669, 'text': "And let's say that you want discrete.", 'start': 3416.046, 'duration': 4.623}, {'end': 3423.711, 'text': 'That is you want it to see for one particular year.', 'start': 3420.749, 'duration': 2.962}, {'end': 3427.673, 'text': 'Then just go ahead and select any year.', 'start': 3424.471, 'duration': 3.202}, {'end': 3428.394, 'text': "Let's say 1980.", 'start': 3427.893, 'duration': 0.501}, {'end': 3428.874, 'text': 'Click on OK.', 'start': 3428.394, 'duration': 0.48}, {'end': 3432.672, 'text': 'on show filter.', 'start': 3431.631, 'duration': 1.041}, {'end': 3434.114, 'text': 'so now you have just selected 1980.', 'start': 3432.672, 'duration': 1.442}, {'end': 3441.501, 'text': 'now so New York has the highest number of victims in 1980, with a count of 426, and then comes California with 322, then, I guess,', 'start': 3434.114, 'duration': 7.387}, {'end': 3452.918, 'text': 'Texas with 230 and Florida with 148.', 'start': 3441.501, 'duration': 11.417}, {'end': 3455.219, 'text': 'So this is how you can use different filters.', 'start': 3452.918, 'duration': 2.301}, {'end': 3460.441, 'text': 'And we found out that California has the highest number of victims.', 'start': 3455.739, 'duration': 4.702}, {'end': 3463.422, 'text': 'So the crime rate is really high in California.', 'start': 3460.521, 'duration': 2.901}, {'end': 3469.624, 'text': 'So now we are going to find out that what are the weapons that are used most in order to kill people.', 'start': 3464.202, 'duration': 5.422}, {'end': 3473.365, 'text': "So we'll find out the favorite weapon of the killers.", 'start': 3470.144, 'duration': 3.221}, {'end': 3476.646, 'text': "So we'll just make another worksheet.", 'start': 3474.405, 'duration': 2.241}, {'end': 3479.207, 'text': "So now I'm going to do the same thing.", 'start': 3477.146, 'duration': 2.061}, {'end': 3482.408, 'text': "So I'm going to put longitudes and latitudes.", 'start': 3479.307, 'duration': 3.101}, {'end': 3484.505, 'text': 'columns and rows.', 'start': 3483.403, 'duration': 1.102}], 'summary': 'Analyzing crime records dataset reveals california has highest crime rate and firearm is most used weapon.', 'duration': 50.391, 'max_score': 3235.033, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So3235033.jpg'}, {'end': 3920.712, 'src': 'embed', 'start': 3894.017, 'weight': 2, 'content': [{'end': 3900.98, 'text': 'a data set should consist of geographical details like city, country or state for this particular generated field to be used.', 'start': 3894.017, 'duration': 6.963}, {'end': 3901.881, 'text': 'All right.', 'start': 3901.521, 'duration': 0.36}, {'end': 3904.122, 'text': "So let's see how we can use them.", 'start': 3902.381, 'duration': 1.741}, {'end': 3907.964, 'text': "Now I'm going to be opening a new sheet in tableau.", 'start': 3905.282, 'duration': 2.682}, {'end': 3911.045, 'text': 'All right.', 'start': 3910.665, 'duration': 0.38}, {'end': 3914.927, 'text': "So let's see how measure names and measure values work first.", 'start': 3911.305, 'duration': 3.622}, {'end': 3920.712, 'text': "So I'm going to pick up the highlighter to show you where you can find these.", 'start': 3915.805, 'duration': 4.907}], 'summary': 'A data set should include geographical details for generated field. exploring usage in tableau.', 'duration': 26.695, 'max_score': 3894.017, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So3894017.jpg'}, {'end': 4757.441, 'src': 'heatmap', 'start': 4316.243, 'weight': 1, 'content': [{'end': 4326.774, 'text': "I am going to be taking the subcategory of products, putting it in my columns, then I'm going to take profit and put in my rows.", 'start': 4316.243, 'duration': 10.531}, {'end': 4334.183, 'text': "Now stay with me because this is kind of a longer process than the other graphs, but it's pretty useful, I assure you.", 'start': 4327.475, 'duration': 6.708}, {'end': 4338.4, 'text': "Now I'm going to right click the subcategory and select the sort option.", 'start': 4334.639, 'duration': 3.761}, {'end': 4340.941, 'text': 'It is going to open this sort of a window.', 'start': 4338.881, 'duration': 2.06}, {'end': 4348.404, 'text': "I'm going to select the descending order and then I'm going to go to the fields and my field name is profit aggregation sum.", 'start': 4340.961, 'duration': 7.443}, {'end': 4354.947, 'text': 'Okay Then I am going to drag the profit measure again into the rows.', 'start': 4348.824, 'duration': 6.123}, {'end': 4358.708, 'text': "It's going to create two separate graphs like this.", 'start': 4356.167, 'duration': 2.541}, {'end': 4365.825, 'text': 'But if I right click here, you can see an option called dual axis.', 'start': 4359.562, 'duration': 6.263}, {'end': 4369.387, 'text': "I'm going to select this and it's going to turn this into circles.", 'start': 4365.885, 'duration': 3.502}, {'end': 4376.991, 'text': "It's basically merged the X axis of both the measures and has converted it into the visualization that you can see right now.", 'start': 4369.887, 'duration': 7.104}, {'end': 4381.753, 'text': 'Now, next, you have to go to the marks card and select some profit.', 'start': 4377.351, 'duration': 4.402}, {'end': 4391.146, 'text': "And, as the dropdown appears, going to select bar here and I'm going to go for the color lighter blue.", 'start': 4382.154, 'duration': 8.992}, {'end': 4399.993, 'text': "okay, now I'm going to the other profit and I'm going to select the line graph here and I'm going to go for the color orange.", 'start': 4391.146, 'duration': 8.847}, {'end': 4403.876, 'text': 'okay, maybe a darker orange, all right, this looks better.', 'start': 4399.993, 'duration': 3.883}, {'end': 4414.945, 'text': "now I'm going to select the sum of profit and second one right here and I'm going to right click here and choose add table calculation from the list.", 'start': 4403.876, 'duration': 11.069}, {'end': 4419.294, 'text': 'Now it opens this primary calculation type of a window.', 'start': 4415.632, 'duration': 3.662}, {'end': 4425.337, 'text': "I'm gonna select running total from the calculation type, because that's what we want, right?", 'start': 4419.934, 'duration': 5.403}, {'end': 4434.341, 'text': 'We want a running total and then select sum as the aggregation which is already selected and compute using table across.', 'start': 4425.357, 'duration': 8.984}, {'end': 4443.546, 'text': "All right, now I'm gonna add a secondary calculation and this is for our second graph and here I'm gonna select percent of total.", 'start': 4434.862, 'duration': 8.684}, {'end': 4447.163, 'text': 'Alright table across as we have done before.', 'start': 4444.301, 'duration': 2.862}, {'end': 4449.625, 'text': "Now I'm going to be closing this window.", 'start': 4447.744, 'duration': 1.881}, {'end': 4456.118, 'text': "As you can see, The line graph has changed and it's not on top of the bar graph anymore.", 'start': 4450.425, 'duration': 5.693}, {'end': 4460.34, 'text': 'That is because we have separate primary and secondary calculations.', 'start': 4456.578, 'duration': 3.762}, {'end': 4469.104, 'text': 'The line graph here is showing us the total running sum of profit as we had calculated and as you can see, here and now,', 'start': 4460.9, 'duration': 8.204}, {'end': 4474.286, 'text': 'you can basically select and change colors that you want to make the graph look as you like.', 'start': 4469.104, 'duration': 5.182}, {'end': 4479.288, 'text': "I'm going to keep it as it is and this is the procedure to create a Pareto chart in Tableau.", 'start': 4474.486, 'duration': 4.802}, {'end': 4482.517, 'text': 'Next in our list we have a bullet shot.', 'start': 4479.849, 'duration': 2.668}, {'end': 4484.984, 'text': "I'm going to rename it.", 'start': 4483.921, 'duration': 1.063}, {'end': 4491.44, 'text': 'Now bullet shot can be used as a gauge or an indicator to show the performance of measures.', 'start': 4486.317, 'duration': 5.123}, {'end': 4494.341, 'text': 'now two measures can be compared to each other using the bullet chart.', 'start': 4491.44, 'duration': 2.901}, {'end': 4501.625, 'text': "For example, if you're having to estimate save actual profit versus estimated profit we can compare both of them using the bullet shot.", 'start': 4494.681, 'duration': 6.944}, {'end': 4506.107, 'text': 'Now, this is going to be slightly different from the three charts that I showed before here.', 'start': 4501.885, 'duration': 4.222}, {'end': 4510.009, 'text': "We're going to start with the analysis option present in the menu bar.", 'start': 4506.147, 'duration': 3.862}, {'end': 4513.591, 'text': 'All right, select create calculated fields.', 'start': 4510.509, 'duration': 3.082}, {'end': 4521.624, 'text': "It opens this sort of a field window, and I'm going to just name it as estimated profit.", 'start': 4514.542, 'duration': 7.082}, {'end': 4525.525, 'text': "We're gonna type an estimated value.", 'start': 4523.485, 'duration': 2.04}, {'end': 4532.107, 'text': 'In this example, the profit is taken as the measure, so the calculated field is created for estimated profit.', 'start': 4525.766, 'duration': 6.341}, {'end': 4535.849, 'text': "So I'm just going to type in a number.", 'start': 4532.768, 'duration': 3.081}, {'end': 4540.714, 'text': "Let's just keep it 300, 000.", 'start': 4537.549, 'duration': 3.165}, {'end': 4545.68, 'text': 'Now, the good part about Tableau is that, till your expression is valid,', 'start': 4540.714, 'duration': 4.966}, {'end': 4553.388, 'text': 'it is not going to let you apply the changes you have made in a calculated field, which is great for beginners,', 'start': 4545.68, 'duration': 7.708}, {'end': 4556.832, 'text': 'because then you will know exactly where you have gone wrong.', 'start': 4553.388, 'duration': 3.444}, {'end': 4564.26, 'text': 'For example, if I remove this, You can see the field shows that the calculation contains errors.', 'start': 4557.153, 'duration': 7.107}, {'end': 4570.645, 'text': 'Not just that, it will even show you the syntax of what your expression should be.', 'start': 4564.74, 'duration': 5.905}, {'end': 4577.71, 'text': 'So here when I type a number, it shows that my calculation is valid and I can apply this and there you are.', 'start': 4571.245, 'duration': 6.465}, {'end': 4586.457, 'text': 'Now go to the measures in the data pane and you have to hold the control key on the keyboard because you have to select two different measures.', 'start': 4578.391, 'duration': 8.066}, {'end': 4590.4, 'text': 'So estimated profit and profit.', 'start': 4587.197, 'duration': 3.203}, {'end': 4597.494, 'text': 'Now click on this option called Show Me, which will show you the various graphs that you can apply here.', 'start': 4591.471, 'duration': 6.023}, {'end': 4599.795, 'text': 'Top right corner, this is the option.', 'start': 4597.954, 'duration': 1.841}, {'end': 4601.496, 'text': "This is the option I'm talking about.", 'start': 4600.156, 'duration': 1.34}, {'end': 4611.161, 'text': 'And you can see the bullet chart option also being highlighted, which means we can use this particular option for the measures that we have input.', 'start': 4602.137, 'duration': 9.024}, {'end': 4614.523, 'text': "So I'm gonna select this, and you have your bullet chart.", 'start': 4611.642, 'duration': 2.881}, {'end': 4618.025, 'text': 'Next in our list, we have text tables.', 'start': 4615.644, 'duration': 2.381}, {'end': 4626.328, 'text': "So let's just add another sheet going to a new worksheet going to do the same thing.", 'start': 4619.022, 'duration': 7.306}, {'end': 4632.072, 'text': 'So a lot of this is going to be dragging dimensions and measures and dropping them into columns and rows.', 'start': 4626.768, 'duration': 5.304}, {'end': 4634.474, 'text': "Don't mind me not repeating it again and again.", 'start': 4632.412, 'duration': 2.062}, {'end': 4650.871, 'text': "So after we've gotten a table like this, I'm going to drag this profit into the text box present at the marks card and here you have it.", 'start': 4642.179, 'duration': 8.692}, {'end': 4654.76, 'text': 'It creates a text table by default next up.', 'start': 4651.813, 'duration': 2.947}, {'end': 4656.002, 'text': 'We have a heat map.', 'start': 4654.84, 'duration': 1.162}, {'end': 4663.426, 'text': 'Now this is basically a graph which can visualize the data in the form of size as well as colors on different measures.', 'start': 4657.043, 'duration': 6.383}, {'end': 4666.947, 'text': 'now, two different measures can be visualized simultaneously using a heat map.', 'start': 4663.426, 'duration': 3.521}, {'end': 4672.37, 'text': 'So one measure can be assigned to size whereas another measure can be assigned to the color of the heat map.', 'start': 4667.408, 'duration': 4.962}, {'end': 4675.511, 'text': "So let's go ahead and create one now again.", 'start': 4672.87, 'duration': 2.641}, {'end': 4682.134, 'text': "I'm going to be holding the control key on the keyboard and select subcategory and sales from the data pane.", 'start': 4675.511, 'duration': 6.623}, {'end': 4684.555, 'text': 'So let me just select these two.', 'start': 4682.694, 'duration': 1.861}, {'end': 4692.777, 'text': "I'm going to go back to the show me button on the top right corner of the worksheet and select the heat map,", 'start': 4686.01, 'duration': 6.767}, {'end': 4696.181, 'text': "and it's going to look something like this does not have any color now.", 'start': 4692.777, 'duration': 3.404}, {'end': 4701.687, 'text': "I'm going to take this profit measure and drag and drop it in the color.", 'start': 4696.642, 'duration': 5.045}, {'end': 4703.509, 'text': "and now I'm going to drag.", 'start': 4701.687, 'duration': 1.822}, {'end': 4704.771, 'text': "let's say region.", 'start': 4703.509, 'duration': 1.262}, {'end': 4706.743, 'text': 'Where did the region go?', 'start': 4705.703, 'duration': 1.04}, {'end': 4710.524, 'text': "All right, I'm going to drag the region and put it in the columns.", 'start': 4707.203, 'duration': 3.321}, {'end': 4718.086, 'text': 'And now this has created a heat map which can be used to visualize sales and profit across different dimensions in different regions.', 'start': 4711.284, 'duration': 6.802}, {'end': 4727.208, 'text': "Next, I'm going to show you how to make a waterfall chart, which is also one of those charts which requires a little more work than the others.", 'start': 4719.366, 'duration': 7.842}, {'end': 4728.869, 'text': "So let's see how it's made.", 'start': 4727.788, 'duration': 1.081}, {'end': 4731.889, 'text': "Oh my God, we've got like 13 sheets right here.", 'start': 4728.889, 'duration': 3}, {'end': 4733.25, 'text': "Let's rename this.", 'start': 4731.909, 'duration': 1.341}, {'end': 4734.47, 'text': 'All right.', 'start': 4734.17, 'duration': 0.3}, {'end': 4741.238, 'text': 'Now waterfall chart is a chart that visualizes the cumulative effect of a measure over a dimension.', 'start': 4735.037, 'duration': 6.201}, {'end': 4746.039, 'text': 'It basically shows the contribution of growth or decline by each member of a dimension.', 'start': 4741.698, 'duration': 4.341}, {'end': 4754, 'text': "Now, let's take for example, you can see the contribution of profit by each subcategory by using a waterfall chart.", 'start': 4746.639, 'duration': 7.361}, {'end': 4757.441, 'text': "All right, so we'll start by making a basic bar chart.", 'start': 4754.4, 'duration': 3.041}], 'summary': 'The transcript demonstrates creating various visualizations in tableau, including pareto chart, bullet chart, text table, heat map, and waterfall chart.', 'duration': 441.198, 'max_score': 4316.243, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So4316243.jpg'}, {'end': 5261.876, 'src': 'embed', 'start': 5234.065, 'weight': 3, 'content': [{'end': 5237.908, 'text': "So it's clearly one of the top choices in the BI space.", 'start': 5234.065, 'duration': 3.843}, {'end': 5245.654, 'text': "So let's talk about a few features which has made it gain its wide market share in BI and analytics space.", 'start': 5238.508, 'duration': 7.146}, {'end': 5249.847, 'text': "So, first of all, it's amazing data visualization.", 'start': 5246.365, 'duration': 3.482}, {'end': 5255.771, 'text': 'tableau bi is known to offer the most advanced data visualization options and is definitely a market leader.', 'start': 5249.847, 'duration': 5.924}, {'end': 5261.876, 'text': 'The users can easily perform complex data visualizations by using the drag-and-drop feature,', 'start': 5256.292, 'duration': 5.584}], 'summary': 'Tableau bi is a top choice with advanced data visualization, a market leader in bi and analytics space.', 'duration': 27.811, 'max_score': 5234.065, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So5234065.jpg'}], 'start': 3176.509, 'title': 'Tableau for us crime dataset analysis', 'summary': 'Demonstrates the use of tableau version 10.2 to analyze a us crime dataset, identifying california as the state with the highest number of victims, preferred weapons for killings, and creating various visualizations including bar charts, line charts, pareto charts, and more. it also covers the features of tableau as a leading business intelligence tool and includes a case study on analyzing data from the indian premier league.', 'chapters': [{'end': 3291.295, 'start': 3176.509, 'title': 'Tableau demo: us crime dataset analysis', 'summary': 'Demonstrates the use of tableau to analyze the us crime dataset, including details of the dataset, connection process, and creation of visualizations, using tableau version 10.2 and a csv file with fields such as crime type, solved status, victim details, perpetrator details, weapon, and crime records across multiple years.', 'duration': 114.786, 'highlights': ['The dataset contains various fields including record ID, agency code, agency name, type, city, state, year, month, and incident, providing comprehensive details for analysis.', 'The CSV file chosen for analysis is connected through a live connection, enabling real-time updates and interactions with the data.', 'The dataset also includes information about crime type, solved status, victim details such as sex, race, and ethnicity, perpetrator details, and the weapon used, providing a rich source for in-depth analysis.']}, {'end': 3712.227, 'start': 3291.635, 'title': 'Crime analysis and visualization', 'summary': 'Discusses the analysis of crime data, identifying the state with the highest number of victims (california), the preferred weapons for killings (handgun and knives), and the correlation between perpetrator and victim counts, revealing a one-to-one murder scenario.', 'duration': 420.592, 'highlights': ['California has the highest victim count with 11,450, followed by Texas with 7,048 and New York with 426 in 1980.', 'Handguns and knives are the most used weapons for killings, with handguns accounting for 6,566 out of 11,000 victims and knives also causing a significant number of deaths.', 'The visualization reveals a direct correlation between perpetrator count and victim count, indicating a one-to-one murder scenario with no clear indication of a serial killer.']}, {'end': 4316.223, 'start': 3712.307, 'title': 'Tableau visualizations tutorial', 'summary': 'Covers a step-by-step tableau tutorial, including the generation of fields such as measure names, measure values, number of records, and geographical details, along with creating basic visualizations like bar charts, line charts, and pareto charts.', 'duration': 603.916, 'highlights': ['The chapter explains the generation of fields like measure names, measure values, number of records, and geographical details, which are essential components of Tableau visualizations.', 'It demonstrates the process of using measure names and measure values to create a bar chart that visualizes the aggregation of all measures present in a data set.', 'The tutorial showcases the utilization of generated fields like number of records to display the count of records present in a data set, offering practical insights into data analysis.', 'It illustrates the use of geographical details such as latitude and longitude to automatically generate a map visualization, enabling effective representation of spatial data in Tableau.', 'The session provides a comprehensive guide on creating different types of visualizations in Tableau, including bar charts, line charts, and Pareto charts, with clear explanations of their specific purposes and applications.']}, {'end': 5209.379, 'start': 4316.243, 'title': 'Creating various visualizations in tableau', 'summary': 'Details the step-by-step process of creating different visualizations in tableau, including pareto chart, bullet chart, text table, heat map, waterfall chart, gantt chart, pie chart, scatter plot, area chart, dual axis chart, bubble chart, and histogram, while emphasizing the importance of each visualization and its application.', 'duration': 893.136, 'highlights': ['The procedure to create a Pareto chart in Tableau involves sorting the subcategory by profit in descending order, utilizing dual axis to merge X axis of both measures, and applying different colors to the bar and line graphs for enhanced visualization.', 'The process of creating a bullet chart in Tableau includes utilizing the analysis option to create calculated fields, comparing two measures using the bullet chart, and understanding its application for performance comparison.', 'Creating a text table involves dragging dimensions and measures into columns and rows, and then dragging profit into the text box in the marks card to generate a default text table.', 'A heat map can be created by visualizing two different measures simultaneously, assigning one measure to size and another to color, and using the show me button to select the heat map option for visualization.', 'The process of making a waterfall chart in Tableau involves creating a basic bar chart, adding a calculated field for negative profit, utilizing quick table calculation for running total, and transforming it into a Gantt chart to visualize the cumulative effect of a measure over a dimension.', 'Creating a Gantt chart in Tableau entails selecting the Gantt bar from the marks card, utilizing the date difference formula to calculate time for shipment, and visualizing the time taken for each shipment across different ship modes.', 'To create a scatter plot, measures are added in both X and Y axes, and the subcategory is added to the color icon to display the relationship between the measures for each subcategory.', 'An area chart can represent quantitative data over a period of time and is created by selecting order date and quantity, and then clicking on the show me button to choose the area chart option.', 'A dual axis chart is built to visualize two different measures in two different chart types, requiring a date column and two measures, and it provides different scales to understand both measures effectively.', 'A bubble chart visualizes measures and dimensions in the form of bubbles, and can be created by simply clicking on the packed bubbles option.', 'A histogram shows the values present in a measure and its frequency and can be used to analyze the distribution of numerical data, such as the amount of discount and its frequency in a retail shop.']}, {'end': 5922.247, 'start': 5210.099, 'title': 'Tableau: bi features & case study', 'summary': "Covers the features of tableau, a leading business intelligence tool, such as its data visualization capabilities, customer satisfaction, ease of implementation, data source integration, mobile support, and online community. the transcript also includes a case study on using tableau to analyze data from the indian premier league, demonstrating the tool's capabilities in creating visualizations and insights from a large dataset.", 'duration': 712.148, 'highlights': ["Tableau's advanced data visualization options and intuitive interface make it a top choice in the BI space, with high customer satisfaction and a 90% adoption rate of the latest version.", "Easy implementation, support for popular data sources, and robust mobile app demonstrate Tableau's versatility and user-centric approach.", "The case study on analyzing Indian Premier League data showcases Tableau's capability to create insights and visualizations from a large dataset, demonstrating its potential for diverse data analysis use cases."]}], 'duration': 2745.738, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So3176509.jpg', 'highlights': ['California has the highest victim count with 11,450 in 1980', 'Handguns and knives are the most used weapons for killings', 'The dataset contains various fields providing comprehensive details for analysis', "Tableau's advanced data visualization options make it a top choice in the BI space", 'The CSV file chosen for analysis is connected through a live connection']}, {'end': 7790.965, 'segs': [{'end': 6465.916, 'src': 'embed', 'start': 6440.736, 'weight': 1, 'content': [{'end': 6446.72, 'text': 'So here is your visualization for all the orange cap holders throughout all the seasons.', 'start': 6440.736, 'duration': 5.984}, {'end': 6450.363, 'text': "And similarly now we'll create our purple cap holders.", 'start': 6447.461, 'duration': 2.902}, {'end': 6460.035, 'text': "So we'll rename this sheet and we'll name it purple cap and we'll do the same thing again.", 'start': 6453.194, 'duration': 6.841}, {'end': 6465.916, 'text': "Wherever we have put orange now in the same fields we'll put the purple cap.", 'start': 6460.915, 'duration': 5.001}], 'summary': 'Visualized orange and purple cap holders from all seasons.', 'duration': 25.18, 'max_score': 6440.736, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So6440736.jpg'}, {'end': 6604.392, 'src': 'embed', 'start': 6576.708, 'weight': 4, 'content': [{'end': 6579.931, 'text': "Let's rename this sheet as man of the series.", 'start': 6576.708, 'duration': 3.223}, {'end': 6585.516, 'text': "So now what we'll do is we need to find the man of the series.", 'start': 6582.233, 'duration': 3.283}, {'end': 6589.259, 'text': "So I'm going to represent this visualization in a geographical way.", 'start': 6586.016, 'duration': 3.243}, {'end': 6594.764, 'text': "That means I'm going to choose the world map because every season IPL is hosted at different countries.", 'start': 6589.319, 'duration': 5.445}, {'end': 6604.392, 'text': "So why not use a world map? So now you have auto-generated latitude and longitude fields so I'll just drag and drop this.", 'start': 6595.124, 'duration': 9.268}], 'summary': 'Analyzing man of the series using world map visualization.', 'duration': 27.684, 'max_score': 6576.708, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So6576708.jpg'}, {'end': 6922.801, 'src': 'embed', 'start': 6891.976, 'weight': 0, 'content': [{'end': 6902.878, 'text': "So it's a good thing that I am making analysis of the IPL details from 2008 to 2016 at the time when there is IPL going on in 2017.", 'start': 6891.976, 'duration': 10.902}, {'end': 6908.1, 'text': 'So if I could have waited a few more days to get it over, I could have included this year too.', 'start': 6902.878, 'duration': 5.222}, {'end': 6910.8, 'text': 'So okay, so let me just close this.', 'start': 6908.76, 'duration': 2.04}, {'end': 6912.661, 'text': "Let's get back to Tableau.", 'start': 6911.16, 'duration': 1.501}, {'end': 6922.801, 'text': "So we're supposed to call it Man of the Match Calc, right? So again, it's a similar thing.", 'start': 6914.321, 'duration': 8.48}], 'summary': 'Analysis of ipl data from 2008 to 2016, missed including 2017 data due to timing.', 'duration': 30.825, 'max_score': 6891.976, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So6891976.jpg'}, {'end': 7343.259, 'src': 'embed', 'start': 7315.362, 'weight': 2, 'content': [{'end': 7319.506, 'text': 'You can see that the highest peak is for Chennai Super Kings.', 'start': 7315.362, 'duration': 4.144}, {'end': 7321.447, 'text': 'So they have performed the best.', 'start': 7319.526, 'duration': 1.921}, {'end': 7324.49, 'text': 'They have won the most matches throughout all the seasons.', 'start': 7321.527, 'duration': 2.963}, {'end': 7328.114, 'text': 'So this is how we have a visualization of the best team.', 'start': 7324.951, 'duration': 3.163}, {'end': 7334.45, 'text': "So now we'll go ahead and we'll find best players throughout all seasons.", 'start': 7329.966, 'duration': 4.484}, {'end': 7340.956, 'text': "So we'll do that in a different workbook as well because the data source is again going to be different.", 'start': 7336.012, 'duration': 4.944}, {'end': 7343.259, 'text': "So we'll save this one.", 'start': 7341.597, 'duration': 1.662}], 'summary': 'Chennai super kings have won the most matches, making them the best-performing team.', 'duration': 27.897, 'max_score': 7315.362, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So7315362.jpg'}, {'end': 7615.027, 'src': 'embed', 'start': 7570.911, 'weight': 3, 'content': [{'end': 7575.632, 'text': "So we'll add a season filter to it that for a particular season, who were the top batsmen.", 'start': 7570.911, 'duration': 4.721}, {'end': 7578.873, 'text': "So we'll create a calculated field.", 'start': 7576.472, 'duration': 2.401}, {'end': 7588.116, 'text': 'So let me call it, Top 5 Calc.', 'start': 7581.873, 'duration': 6.243}, {'end': 7597.319, 'text': 'And this is it.', 'start': 7596.539, 'duration': 0.78}, {'end': 7600.641, 'text': 'Let us first choose season 8.', 'start': 7597.54, 'duration': 3.101}, {'end': 7602.342, 'text': 'That means last year.', 'start': 7600.641, 'duration': 1.701}, {'end': 7604.823, 'text': 'Let us choose season 8.', 'start': 7603.482, 'duration': 1.341}, {'end': 7607.204, 'text': 'This is for 2015 season.', 'start': 7604.823, 'duration': 2.381}, {'end': 7610.005, 'text': "So we'll click on OK over here.", 'start': 7608.064, 'duration': 1.941}, {'end': 7611.565, 'text': "So we'll go there.", 'start': 7610.025, 'duration': 1.54}, {'end': 7612.566, 'text': 'Right click.', 'start': 7612.066, 'duration': 0.5}, {'end': 7615.027, 'text': "We'll go to edit table calculations.", 'start': 7612.686, 'duration': 2.341}], 'summary': 'Adding a season filter to identify top 5 batsmen for a specific season.', 'duration': 44.116, 'max_score': 7570.911, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So7570911.jpg'}], 'start': 5922.908, 'title': 'Visualizing ipl data', 'summary': 'Delves into visualizing ipl data from 2008 to 2016, showcasing player ids, season details, awards like orange cap and purple cap, man of the series and match, best performing teams, and top five batsmen in the 2015 season using tableau for data integration and visualization.', 'chapters': [{'end': 5968.007, 'start': 5922.908, 'title': 'Cricket data analysis', 'summary': 'Highlights the key player ids, season details, and awards like orange cap, purple cap, and man of the series, demonstrating the data sets that will be used for analysis.', 'duration': 45.099, 'highlights': ['The first season had the season ID 1 and was played in 2008.', 'The player with ID 100 was given the orange cap.', 'The player with ID 1 being a captain is denoted by 1, otherwise 0.']}, {'end': 6545.775, 'start': 5968.047, 'title': 'Tableau data integration and visualization', 'summary': 'Explores data integration using tableau, including connecting to csv files, performing inner joins, and creating visualizations to display orange and purple cap holders across different seasons.', 'duration': 577.728, 'highlights': ['Performed data integration using Tableau, including connecting to CSV files and performing inner joins to combine multiple data sources.', 'Created a visualization of orange cap holders across different seasons, displaying the respective player names and seasons, such as Sean Marsh in 2008, Hayden in 2009, and Sachin Tendulkar in 2010.', 'Used calculated fields to display purple cap holders, removing null values and applying visual representations for purple cap holders.']}, {'end': 6922.801, 'start': 6548.215, 'title': 'Visualizing ipl data', 'summary': 'Discusses visualizing ipl data from 2008 to 2016, showcasing the man of the series and man of the match for each season across different countries, with a focus on cities and host countries, and also includes creating calculated fields and applying filters for better visualization.', 'duration': 374.586, 'highlights': ['The chapter discusses visualizing IPL data from 2008 to 2016, showcasing the man of the series and man of the match for each season across different countries, with a focus on cities and host countries.', 'The visualization includes a world map pinpointing different cities and locations where matches were held, along with the man of the series for each year, and filters to identify the man of the series for a particular season.', 'The analysis reveals that IPL matches were hosted in cities in India, UAE, and South Africa, with India hosting the tournament most frequently.', 'The visualization also simplifies the representation by using a straightforward visualization for the man of the match, displaying the match ID and the respective player.', 'The chapter reflects an engaging approach to IPL data analysis and demonstrates the use of Tableau for insightful visualizations, which could have included data from the ongoing IPL season in 2017.']}, {'end': 7340.956, 'start': 6923.721, 'title': 'Visualizing ipl data', 'summary': 'Demonstrates the process of visualizing ipl data using tableau, including filtering, joining, and creating visualizations to showcase the best performing team based on the number of wins throughout all seasons.', 'duration': 417.235, 'highlights': ['The process of visualizing IPL data using Tableau, including filtering, joining, and creating visualizations to showcase the best performing team based on the number of wins throughout all seasons.', 'Utilizing Tableau to create a workbook for representing the overall best team performance in the IPL, with Chennai Super Kings emerging as the top-performing team with the highest number of wins.', 'Utilizing Tableau to integrate and join data sources such as team.csv and match.csv, and then visualizing the performance of all teams together, showcasing the number of wins by each team throughout all the seasons.']}, {'end': 7790.965, 'start': 7341.597, 'title': 'Creating top players visualization', 'summary': 'Demonstrates how to connect and integrate multiple datasets to create a visualization of the top five batsmen in the 2015 season using tableau, identifying the players and their respective batting scores.', 'duration': 449.368, 'highlights': ['The process of connecting and integrating multiple datasets, including Ball by Ball, Match.csv, player.csv, player match.csv, and team.csv, to create a comprehensive data source for analysis and visualization.', "Demonstrating the use of filters and table calculations in Tableau to identify and display the top five batsmen in the 2015 season, namely AB de Villiers, Rahane, Warner, Simmons, and Kohli, along with their respective batting scores of 532, 540, 540, 562, and 505, and comparing these results with the official website's data for validation."]}], 'duration': 1868.057, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So5922908.jpg', 'highlights': ['Utilized Tableau for data integration and visualization of IPL data from 2008 to 2016.', 'Created visualizations of orange cap and purple cap holders across different seasons using Tableau.', 'Integrated and joined data sources using Tableau to showcase the best performing team in the IPL.', 'Demonstrated the use of filters and table calculations in Tableau to identify and display the top five batsmen in the 2015 season.', 'Visualized man of the series and man of the match for each season across different countries using Tableau.']}, {'end': 9405.344, 'segs': [{'end': 7867.521, 'src': 'embed', 'start': 7828.861, 'weight': 1, 'content': [{'end': 7836.484, 'text': 'drag and drop all these worksheets over here so that we can have an entire view of all the analysis and all the visualization that we made using Tableau.', 'start': 7828.861, 'duration': 7.623}, {'end': 7839.945, 'text': "So I'm just going to drag and drop these sheets over here.", 'start': 7837.044, 'duration': 2.901}, {'end': 7851.852, 'text': "Now I'll just drop the purple cap You can also adjust the size.", 'start': 7845.247, 'duration': 6.605}, {'end': 7855.714, 'text': 'There you go.', 'start': 7855.194, 'duration': 0.52}, {'end': 7859.096, 'text': 'And you can go ahead and add all the different sheets as well.', 'start': 7856.435, 'duration': 2.661}, {'end': 7867.521, 'text': 'So this is how it is going to look like.', 'start': 7866.02, 'duration': 1.501}], 'summary': 'Drag and drop worksheets for comprehensive tableau analysis and visualization.', 'duration': 38.66, 'max_score': 7828.861, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So7828861.jpg'}, {'end': 8024.881, 'src': 'embed', 'start': 7978.882, 'weight': 4, 'content': [{'end': 7985.187, 'text': 'We will start with the absolute function or the ABS and close using the ZN functions.', 'start': 7978.882, 'duration': 6.305}, {'end': 7989.49, 'text': "each of which I'm going to demonstrate to you using the tableau desktop.", 'start': 7985.985, 'duration': 3.505}, {'end': 7992.134, 'text': "So let's get started with our first function.", 'start': 7990.251, 'duration': 1.883}, {'end': 7997.843, 'text': 'So the first function in the number functions category is ABS or the absolute function.', 'start': 7992.675, 'duration': 5.168}, {'end': 7999.871, 'text': 'on your leftmost column.', 'start': 7998.63, 'duration': 1.241}, {'end': 8006.093, 'text': 'You can see the name of the function in the column in between you can see its syntax and on the right you can see the description.', 'start': 7999.931, 'duration': 6.162}, {'end': 8013.576, 'text': 'So what your ABS does is it returns the absolute value of the number or the parameter that you put in the bracket.', 'start': 8006.553, 'duration': 7.023}, {'end': 8024.881, 'text': 'So if I give like a negative number in there like a minus 5 then an absolute function is going to turn it into a 5 and return it back to you.', 'start': 8014.116, 'duration': 10.765}], 'summary': 'Demonstration of abs function in tableau desktop.', 'duration': 45.999, 'max_score': 7978.882, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So7978882.jpg'}, {'end': 8309.212, 'src': 'embed', 'start': 8278.273, 'weight': 5, 'content': [{'end': 8288.501, 'text': 'So if you give an R cosine of minus 1 you supposed to be getting something in lines of 3.1415926 as simple as that.', 'start': 8278.273, 'duration': 10.228}, {'end': 8293.324, 'text': "So let's go back to our tableau desktop and run this and see.", 'start': 8289.061, 'duration': 4.263}, {'end': 8299.76, 'text': "Again, we're going to go to analysis and create a calculated field.", 'start': 8294.213, 'duration': 5.547}, {'end': 8309.212, 'text': 'Go and type a cos minus one and apply it.', 'start': 8301.843, 'duration': 7.369}], 'summary': 'Calculating the cosine of minus 1 in tableau yields approximately 3.1415926.', 'duration': 30.939, 'max_score': 8278.273, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So8278272.jpg'}, {'end': 8376.78, 'src': 'embed', 'start': 8340.387, 'weight': 6, 'content': [{'end': 8348.41, 'text': 'Next we have our sign which as the name explains returns the arc sign of the given number in radiance.', 'start': 8340.387, 'duration': 8.023}, {'end': 8354.271, 'text': "I'm quickly going to show that here again.", 'start': 8349.17, 'duration': 5.101}, {'end': 8369.617, 'text': 'And it gives you the answer 1.571.', 'start': 8354.29, 'duration': 15.327}, {'end': 8374.179, 'text': 'Next we have the Arc tangent which is given in radians again.', 'start': 8369.617, 'duration': 4.562}, {'end': 8376.78, 'text': 'It is a tan which is the number function.', 'start': 8374.199, 'duration': 2.581}], 'summary': 'Demonstration of sign and arc tangent functions in radians, yielding an answer of 1.571.', 'duration': 36.393, 'max_score': 8340.387, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So8340387.jpg'}, {'end': 8560.58, 'src': 'embed', 'start': 8529.387, 'weight': 2, 'content': [{'end': 8529.768, 'text': 'All right.', 'start': 8529.387, 'duration': 0.381}, {'end': 8538.415, 'text': 'so, as you can see, it gives you point 7, 0, 7, 1, which is 1 by root, 2, which is again cos pi by 4.', 'start': 8529.768, 'duration': 8.647}, {'end': 8545.68, 'text': "next you have cot or cotangent of an angle same as cos that you're going to repeat.", 'start': 8538.415, 'duration': 7.265}, {'end': 8551.528, 'text': 'next you have cotangent or cot and we are going to implement it the same way as we did course.', 'start': 8545.68, 'duration': 5.848}, {'end': 8555.754, 'text': "I don't think these trigonometric functions need a lot of explanation.", 'start': 8552.269, 'duration': 3.485}, {'end': 8557.656, 'text': "We've all done these in school.", 'start': 8556.375, 'duration': 1.281}, {'end': 8560.58, 'text': "So let's just get this over with.", 'start': 8558.538, 'duration': 2.042}], 'summary': 'Trigonometric functions explained briefly, followed by a dismissive attitude towards further explanation.', 'duration': 31.193, 'max_score': 8529.387, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So8529387.jpg'}, {'end': 8871.1, 'src': 'embed', 'start': 8834.538, 'weight': 9, 'content': [{'end': 8839.841, 'text': "If your number is less than or equal to 0 it's going to return a null value.", 'start': 8834.538, 'duration': 5.303}, {'end': 8852.97, 'text': 'As we know that the natural log of 1 is 0 so that is what we get.', 'start': 8848.026, 'duration': 4.944}, {'end': 8859.497, 'text': "That's the only one I remember from school, and that's the reason I put that in as my input.", 'start': 8853.795, 'duration': 5.702}, {'end': 8867.339, 'text': 'now, something very similar is logarithm, with a base which we usually take as 10..', 'start': 8859.497, 'duration': 7.842}, {'end': 8871.1, 'text': 'So if the base value is omitted you decide to not put in a base.', 'start': 8867.339, 'duration': 3.761}], 'summary': 'Logarithm with base 10 is usually used, and natural log of 1 is 0.', 'duration': 36.562, 'max_score': 8834.538, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So8834538.jpg'}, {'end': 9184.759, 'src': 'embed', 'start': 9152.115, 'weight': 3, 'content': [{'end': 9156.096, 'text': "So with that, let's go to our tableau desktop and see how this functions.", 'start': 9152.115, 'duration': 3.981}, {'end': 9166.72, 'text': "So what I'm doing here is I'm going to round up every sales value to an integer.", 'start': 9161.578, 'duration': 5.142}, {'end': 9171.322, 'text': "That's why I did not put anything in the decimals place.", 'start': 9167.141, 'duration': 4.181}, {'end': 9175.144, 'text': 'If I take a sub category.', 'start': 9171.342, 'duration': 3.802}, {'end': 9176.874, 'text': 'All right.', 'start': 9176.013, 'duration': 0.861}, {'end': 9184.759, 'text': 'as you can see, everything has been rounded up to an integer, no matter what the sales in dollars is.', 'start': 9176.874, 'duration': 7.885}], 'summary': 'In tableau desktop, sales values are rounded up to integers, with no decimal places, for all subcategories.', 'duration': 32.644, 'max_score': 9152.115, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So9152115.jpg'}, {'end': 9405.344, 'src': 'embed', 'start': 9372.696, 'weight': 0, 'content': [{'end': 9373.877, 'text': 'So this is how it works.', 'start': 9372.696, 'duration': 1.181}, {'end': 9382.042, 'text': "I'm going to put in a field which I know does not have a zero value.", 'start': 9374.017, 'duration': 8.025}, {'end': 9390.359, 'text': "So I'm going to put in profit So here I'm going to put in the average of profit.", 'start': 9383.003, 'duration': 7.356}, {'end': 9392.98, 'text': "It's in the some mode now.", 'start': 9391.96, 'duration': 1.02}, {'end': 9403.543, 'text': "I'm just going to take the average, and I know for a fact it's not a non-zero value and it's returned to me the average of profit, which is 28.66.", 'start': 9393.02, 'duration': 10.523}, {'end': 9405.344, 'text': 'with that we come to the end of the segment.', 'start': 9403.543, 'duration': 1.801}], 'summary': 'Average profit value is 28.66.', 'duration': 32.648, 'max_score': 9372.696, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So9372696.jpg'}], 'start': 7791.505, 'title': 'Tableau functions and dashboards', 'summary': 'Covers creating dashboards in tableau, functions in tableau desktop 2019.1, less commonly used functions, and various math functions, with examples and practical applications. it also demonstrates the usage of number functions, including rounding and zn, with specific examples and quantifiable data such as an average profit of 28.66.', 'chapters': [{'end': 8049.862, 'start': 7791.505, 'title': 'Creating dashboards in tableau', 'summary': 'Explains how to create a dashboard in tableau, by dragging and dropping visualizations from different worksheets, adjusting their size, and adding more sheets to provide a comprehensive view of all the analysis and visualizations made using tableau.', 'duration': 258.357, 'highlights': ['The process of creating a dashboard in Tableau by dragging and dropping visualizations from different worksheets and adjusting their size to provide a comprehensive view of all the analysis and visualizations made using Tableau.', 'Explanation of the ABS function in Tableau, which returns the absolute value of a number or parameter, allowing computations on data values in the fields.']}, {'end': 8376.78, 'start': 8051.123, 'title': 'Tableau desktop functions tutorial', 'summary': 'Covers the use of functions in tableau desktop 2019.1, demonstrating absolute, arc cosine, arc sign, and arc tangent functions, with examples and visualizations using the sample superstore dataset.', 'duration': 325.657, 'highlights': ['The absolute function in Tableau Desktop is demonstrated with examples including converting negative numbers to positive, and applying it to fields like sales, producing visualizations of absolute sales by state.', 'The arc cosine function in Tableau Desktop is explained, showcasing its usage to calculate the R cosine of a given number, resulting in radians, with a practical example and visualization.', 'The arc sign function in Tableau Desktop is showcased, returning the arc sign of a given number in radians, with a demonstration of its application and the result obtained.', 'The arc tangent function in Tableau Desktop, provided in radians, is demonstrated, showing its application and the result obtained.']}, {'end': 8809.857, 'start': 8376.799, 'title': 'Tableau functions overview', 'summary': 'Provides an overview of less commonly used functions in tableau, including ceiling, cos, cot, degrees, div, exp, floor, and hex bin, and their applications in rounding, trigonometry, conversion, division, exponentiation, and visualization, with specific examples and supported data sources.', 'duration': 433.058, 'highlights': ['The functions covered in the section are ceiling, cos, cot, degrees, div, exp, floor, and hex bin, each with specific use cases and examples.', 'The ceiling function rounds a decimal number to the nearest integer of equal or greater value, demonstrated with an example of rounding 9.1265 to 10.', 'The floor function rounds a number to the nearest integer of lesser value and is supported by Microsoft Excel and text files but not by Microsoft Access, action vector, or Amazon Aurora.', 'The exp function returns e raised to the power of the given number, with an example of e raised to 2 equating to 7.3, and its applications in calculating growth rates.', 'The hex bin function maps x and y coordinates to the nearest hexagonal bin, efficient for visualizing geographical data and scatter plots, with considerations for appropriate scaling of inputs.']}, {'end': 9112.309, 'start': 8809.857, 'title': 'Math functions in tableau', 'summary': 'Covers various math functions in tableau including natural logarithm, logarithm with base 10, max, min, pi, power, radiance, and round, highlighting their usage, default behavior, and practical examples.', 'duration': 302.452, 'highlights': ['The natural logarithm of a number returns a null value if the number is less than or equal to 0, and the natural log of 1 is 0.', 'The logarithm function with base 10 by default returns the logarithm of a given number, e.g., log 100 base 10 is 2.', 'The Max function returns the maximum of two arguments of the same type, and can also be applied as an aggregate calculation, e.g., comparing sales and profit values.', 'The Min function returns the minimum of two arguments of the same type, and can be used to compare values like profit and sales.', 'The pi function returns the value of pi, which is approximately 3.142.', 'The power function raises a given base to a specified power, e.g., 10 raised to the power of 3 is 1000.', 'The radiance function converts the given angle in degrees to radiance, e.g., converting 45 degrees to pi by 4.', 'The round function rounds off a given number to the nearest integer.']}, {'end': 9405.344, 'start': 9112.91, 'title': 'Tableau functions overview', 'summary': 'Explains various number functions in tableau including rounding, sign, sine, square root, square, and zn, demonstrating their applications and outputs in tableau. it also highlights the functionality of rounding for decimal precision and the usage of zn to replace null values with zero, with an example yielding an average profit of 28.66.', 'duration': 292.434, 'highlights': ['The chapter demonstrates the functionality of rounding in Tableau, showcasing its ability to round a number to a specified number of digits or the nearest integer.', 'It explains the sign function and its output, showcasing how it returns the sign of a number as negative, zero, or positive, exemplified by obtaining a sign of 1 for positive profit.', 'It illustrates the usage of ZN to replace null values with zero, exemplified by obtaining an average profit of 28.66.', 'The chapter showcases the application of sine function to calculate the sine of an angle in radians, exemplified by obtaining the sine of pi/4 as 0.707.', 'It demonstrates the square root function, exemplifying the calculation of the square root of a number, showcased by obtaining the square root of 100 as 10.']}], 'duration': 1613.839, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So7791505.jpg', 'highlights': ['The usage of ZN to replace null values with zero, exemplified by obtaining an average profit of 28.66.', 'The process of creating a dashboard in Tableau by dragging and dropping visualizations from different worksheets and adjusting their size.', 'The functions covered in the section are ceiling, cos, cot, degrees, div, exp, floor, and hex bin, each with specific use cases and examples.', 'The chapter demonstrates the functionality of rounding in Tableau, showcasing its ability to round a number to a specified number of digits or the nearest integer.', 'The absolute function in Tableau Desktop is demonstrated with examples including converting negative numbers to positive, and applying it to fields like sales.', 'The arc cosine function in Tableau Desktop is explained, showcasing its usage to calculate the R cosine of a given number, resulting in radians.', 'The arc sign function in Tableau Desktop is showcased, returning the arc sign of a given number in radians, with a demonstration of its application and the result obtained.', 'The arc tangent function in Tableau Desktop, provided in radians, is demonstrated, showing its application and the result obtained.', 'The explanation of the ABS function in Tableau, which returns the absolute value of a number or parameter, allowing computations on data values in the fields.', 'The natural logarithm of a number returns a null value if the number is less than or equal to 0, and the natural log of 1 is 0.']}, {'end': 10932.232, 'segs': [{'end': 9433.688, 'src': 'embed', 'start': 9405.804, 'weight': 0, 'content': [{'end': 9408.645, 'text': 'Let me head back to the presentation to start with the next module.', 'start': 9405.804, 'duration': 2.841}, {'end': 9411.966, 'text': 'The second segment is string functions.', 'start': 9409.565, 'duration': 2.401}, {'end': 9416.715, 'text': 'Basically string functions allow you to manipulate string data.', 'start': 9412.992, 'duration': 3.723}, {'end': 9418.917, 'text': 'Now you can do all sorts of things with it,', 'start': 9417.195, 'duration': 1.722}, {'end': 9433.688, 'text': 'like pull out all the last names from your customers into a new field one member might be say Shubham Sinha and then you can pull out all the customers with the surname Sinha and then put them in a new field using the string functions.', 'start': 9418.917, 'duration': 14.771}], 'summary': 'String functions allow manipulation of string data, such as extracting surnames from customer names.', 'duration': 27.884, 'max_score': 9405.804, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So9405804.jpg'}, {'end': 9490.578, 'src': 'embed', 'start': 9442.567, 'weight': 1, 'content': [{'end': 9445.929, 'text': 'this by no way is an advanced tutorial.', 'start': 9442.567, 'duration': 3.362}, {'end': 9448.77, 'text': "I'm just going to show you how each syntax works.", 'start': 9446.089, 'duration': 2.681}, {'end': 9451.511, 'text': "So let's start with the first one.", 'start': 9450.091, 'duration': 1.42}, {'end': 9453.112, 'text': 'We have ASCII.', 'start': 9451.571, 'duration': 1.541}, {'end': 9461.856, 'text': 'as most of you know, there is an ASCII code for every character of the string, and what this function does is it returns that ASCII character.', 'start': 9453.112, 'duration': 8.744}, {'end': 9490.578, 'text': 'Now as we all know the string a has the ASCII code of 65 and that is what this returns next.', 'start': 9482.856, 'duration': 7.722}], 'summary': 'Basic tutorial on ascii code function, returns character for ascii code.', 'duration': 48.011, 'max_score': 9442.567, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So9442567.jpg'}, {'end': 10216.027, 'src': 'embed', 'start': 10141.758, 'weight': 2, 'content': [{'end': 10144.421, 'text': 'and it returns to us matador in all caps.', 'start': 10141.758, 'duration': 2.663}, {'end': 10148.044, 'text': 'So with that we come to the end of string functions.', 'start': 10145.181, 'duration': 2.863}, {'end': 10152.007, 'text': 'The next segment is on date functions.', 'start': 10149.025, 'duration': 2.982}, {'end': 10160.035, 'text': 'now, as the name suggests, the date functions allow you to manipulate dates in your data source, such as your month, date, date or time.', 'start': 10152.007, 'duration': 8.028}, {'end': 10162.277, 'text': "So let's go to our first function.", 'start': 10160.715, 'duration': 1.562}, {'end': 10174.776, 'text': 'We have the date add now the date add returns a specified date with the specified number interval added to a specified date part of that date.', 'start': 10163.05, 'duration': 11.726}, {'end': 10183.861, 'text': 'For example, if I put in month as the date, part 3 as the interval and a date as the date,', 'start': 10175.376, 'duration': 8.485}, {'end': 10189.063, 'text': 'this expression would add three months to the date 15th of April 2004..', 'start': 10183.861, 'duration': 5.202}, {'end': 10189.464, 'text': "So let's try this.", 'start': 10189.063, 'duration': 0.401}, {'end': 10216.027, 'text': 'Now this expression adds three months to the date.', 'start': 10213.405, 'duration': 2.622}], 'summary': 'The segment covers date functions, such as date add, and their manipulation of dates in data sources.', 'duration': 74.269, 'max_score': 10141.758, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So10141758.jpg'}, {'end': 10852.678, 'src': 'embed', 'start': 10823.328, 'weight': 4, 'content': [{'end': 10826.694, 'text': 'This is the same in the table next we have float.', 'start': 10823.328, 'duration': 3.366}, {'end': 10830.941, 'text': 'So, basically, if I enter a float 3, it is supposed to give me 3.00.', 'start': 10827.315, 'duration': 3.626}, {'end': 10842.887, 'text': 'next we have int or integer, which again opposite of float going to cut down the decimal part of the number and give me only the integer part.', 'start': 10830.941, 'duration': 11.946}, {'end': 10846.211, 'text': 'And finally we have a string expression.', 'start': 10843.588, 'duration': 2.623}, {'end': 10852.678, 'text': "Basically, you're going to pass in an argument through it and it's going to convert it into a string and give it back to you.", 'start': 10846.752, 'duration': 5.926}], 'summary': 'Data types include float, int, and string for numerical and text manipulation.', 'duration': 29.35, 'max_score': 10823.328, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So10823328.jpg'}], 'start': 9405.804, 'title': 'Various string and date functions', 'summary': 'Covers the usage of string functions in tableau, python, and databases, showcasing practical examples and use cases for each function. additionally, it demonstrates various string and date functions in tableau, enabling effective manipulation and conversion of data types.', 'chapters': [{'end': 9442.567, 'start': 9405.804, 'title': 'Tableau string functions', 'summary': "Covers the usage of string functions in tableau, allowing manipulation of string data, such as extracting last names from customer names and organizing them into new fields, with examples like 'shubham sinha' to 'sinha'. it also includes a presentation of all the string functions available in tableau.", 'duration': 36.763, 'highlights': ["The chapter covers the usage of string functions in Tableau, allowing manipulation of string data, such as extracting last names from customer names and organizing them into new fields, with examples like 'Shubham Sinha' to 'Sinha'.", 'The presentation includes an overview of all the string functions available in Tableau.']}, {'end': 9709.2, 'start': 9442.567, 'title': 'String manipulation functions in python', 'summary': 'Explains various string manipulation functions in python, including ascii, char, contains, ends with, find, and find nth, with practical examples and their return values.', 'duration': 266.633, 'highlights': ['The chapter covers ASCII and char functions, which return the ASCII character for a given string and the character encoded by the ASCII code, respectively.', 'The function contains returns true if a given string contains the specified substring, and the example demonstrates its return value as true.', 'The function ends with returns true if the given string ends with a certain substring, and the example demonstrates its return value as true.', 'The function find returns the index position of a specified substring in the string, with an optional start argument to ignore instances before the given index position, and the example illustrates its usage and return values.', 'The function find nth returns the position of the nth occurrence of a substring within a specified string, and the example showcases its practical usage and return value.']}, {'end': 10102.752, 'start': 9710.134, 'title': 'String functions in database', 'summary': 'Covers various string functions such as substring, length, lower, l trim, max, mid, min, right, our trim, space, and split, providing practical examples and use cases for each function, including comparisons and data manipulation.', 'duration': 392.618, 'highlights': ["The Max function returns the maximum value from a set of strings, with an example of comparing 'apples' and 'bananas' resulting in 'bananas'.", "The split function divides a string using a specified delimiter and returns the desired token, with an example using hyphen as the delimiter and returning 'B'.", "The mid function extracts a substring from a string based on the start index and optional length, demonstrated by extracting five characters starting from the second position in the word 'learning'.", "The length function returns the number of characters in a string, confirmed with the example of 'matador' having a length of 7.", "The min function returns the string with the minimum number of characters, exemplified by comparing 'apples' and 'bananas' and resulting in 'apples'."]}, {'end': 10624.308, 'start': 10106.374, 'title': 'String and date functions demo', 'summary': 'Demonstrates various string and date functions such as upper, date add, date diff, date name, date part, date trunk, day, is date, make date, make time, max, min, month, and now, showcasing their functionalities and examples.', 'duration': 517.934, 'highlights': ['The date add function adds three months to the specified date, resulting in the expression showing the addition of three different months, such as changing from April to July, demonstrating the manipulation of dates in the data source.', 'The date diff function returns the difference between two dates, with an example showing the difference as five weeks, highlighting its utility in calculating date disparities.', "The date name function returns the date part of the date as a string, exemplified by returning the string '2004' when specifying the date part as year, showcasing its ability to provide the date part as a string.", "The is date function returns 'true' if the given string is a valid date, demonstrated by returning 'true' for the valid date '28th of Feb,' illustrating its functionality in validating dates.", 'The now function returns the current date and time, with the output varying based on the connection nature, providing the system time for a live unpublished connection, and the data source server time for a live published connection, thus exemplifying its behavior based on connection type.']}, {'end': 10932.232, 'start': 10624.308, 'title': 'Tableau date and type conversion functions', 'summary': 'Covers tableau date functions including today, year, date, date time, date parse, along with type conversion functions such as float, integer, and string, enabling users to manipulate and convert data types effectively.', 'duration': 307.924, 'highlights': ['The chapter covers Tableau date functions including today, year, date, date time, date parse, enabling users to manipulate and analyze dates effectively.', 'Type conversion functions such as float, integer, and string allow users to convert data types, ensuring accurate data manipulation and analysis.', "Demonstration of using the type conversion function 'string' to convert a postal code from a number to a string, showcasing the practical application of type conversion functions."]}], 'duration': 1526.428, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So9405804.jpg', 'highlights': ['The chapter covers the usage of string functions in Tableau, allowing manipulation of string data, with practical examples.', 'The chapter covers ASCII and char functions, demonstrating their practical usage and return values.', 'The date add function adds three months to the specified date, showcasing the manipulation of dates in the data source.', 'The chapter covers Tableau date functions including today, year, date, date time, date parse, enabling effective date manipulation.', 'Type conversion functions such as float, integer, and string allow users to convert data types, ensuring accurate data manipulation.']}, {'end': 13714.319, 'segs': [{'end': 10968.989, 'src': 'embed', 'start': 10932.973, 'weight': 0, 'content': [{'end': 10935.194, 'text': "Let's move on to aggregate functions.", 'start': 10932.973, 'duration': 2.221}, {'end': 10938.998, 'text': 'There are a few more than the type functions here.', 'start': 10935.955, 'duration': 3.043}, {'end': 10946.718, 'text': 'So basically what aggregate functions let you do is that they allow you to summarize or change the granularity of your data.', 'start': 10939.634, 'duration': 7.084}, {'end': 10952.38, 'text': 'For example, if you want to know exactly how many orders your store had for a particular year,', 'start': 10947.098, 'duration': 5.282}, {'end': 10960.665, 'text': 'you can use the count D function to summarize the exact number of orders your company had and then break the visualization down by ear.', 'start': 10952.38, 'duration': 8.285}, {'end': 10968.989, 'text': 'So there are a bunch of aggregation function out here, most of which we have already used as number functions before.', 'start': 10961.165, 'duration': 7.824}], 'summary': 'Aggregate functions summarize and change data granularity, e.g., count d function for order analysis.', 'duration': 36.016, 'max_score': 10932.973, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So10932973.jpg'}, {'end': 11340.008, 'src': 'embed', 'start': 11312.802, 'weight': 3, 'content': [{'end': 11321.788, 'text': "Now most of these things we've already seen through the many functions that we have covered today and the rest are very common logical functions.", 'start': 11312.802, 'duration': 8.986}, {'end': 11323.949, 'text': 'If you are from any coding background.', 'start': 11321.988, 'duration': 1.961}, {'end': 11333.64, 'text': "So what I'm going to do for this particular segment is that I'm going to go through all of these functions first and then go to my tableau desktop to show you a tiny demo.", 'start': 11324.549, 'duration': 9.091}, {'end': 11340.008, 'text': 'So first of all and function now basically this performs a logical conjunction of the two functions.', 'start': 11334.081, 'duration': 5.927}], 'summary': 'Covered various logical functions and demonstrated a demo in tableau desktop.', 'duration': 27.206, 'max_score': 11312.802, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So11312802.jpg'}, {'end': 11800.079, 'src': 'embed', 'start': 11776.342, 'weight': 1, 'content': [{'end': 11782.706, 'text': "then we'll talk about the various calculation in LOD, which are the include, the exclude and the fixed calculation.", 'start': 11776.342, 'duration': 6.364}, {'end': 11790.112, 'text': "then we're going to talk a little bit about aggregation and LOD expressions, followed by nesting and inheritance in LOD.", 'start': 11782.706, 'duration': 7.406}, {'end': 11794.395, 'text': "Then we're going to talk about the data sources supported by level of detail and tableau.", 'start': 11790.512, 'duration': 3.883}, {'end': 11800.079, 'text': 'Finally, we have a short demo on how to create some simple LOD expressions and tableau.', 'start': 11794.875, 'duration': 5.204}], 'summary': 'Overview of lod calculations and data sources in tableau, with a demo.', 'duration': 23.737, 'max_score': 11776.342, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So11776342.jpg'}, {'end': 12341.68, 'src': 'embed', 'start': 12314.76, 'weight': 4, 'content': [{'end': 12318.802, 'text': 'For example, the following level of detail expression references two dimensions.', 'start': 12314.76, 'duration': 4.042}, {'end': 12326.428, 'text': 'When this expression is used in a view that has only segment as its level of detail the values must be aggregated.', 'start': 12319.403, 'duration': 7.025}, {'end': 12331.052, 'text': 'Here is what you would see if you drag the expression to a shelf.', 'start': 12326.909, 'duration': 4.143}, {'end': 12339.458, 'text': 'an aggregation in this case average, is automatically assigned by tableau, but you can always change the aggregation if you need it now,', 'start': 12331.052, 'duration': 8.406}, {'end': 12341.68, 'text': 'adding an LOD expression to the view.', 'start': 12339.458, 'duration': 2.222}], 'summary': 'Using lod expressions in tableau allows for automatic aggregation and the ability to change aggregation if needed.', 'duration': 26.92, 'max_score': 12314.76, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So12314760.jpg'}, {'end': 13315.884, 'src': 'embed', 'start': 13286.914, 'weight': 2, 'content': [{'end': 13293.296, 'text': 'So, basically, the scenario I am trying to create is a what-if scenario, like I had mentioned before.', 'start': 13286.914, 'duration': 6.382}, {'end': 13301.179, 'text': "so I'm going to say, for example, what if the sales has been hyped up by 3% now?", 'start': 13293.296, 'duration': 7.883}, {'end': 13305, 'text': 'this detail is not given readily to me in my data set.', 'start': 13301.179, 'duration': 3.821}, {'end': 13308.962, 'text': 'So I obviously have to create a parameter for it.', 'start': 13305.501, 'duration': 3.461}, {'end': 13315.884, 'text': "So, basically, this is a parameter which I'm going to be using in a calculated field to create a calculated field.", 'start': 13309.702, 'duration': 6.182}], 'summary': 'Creating a what-if scenario by increasing sales by 3% using a parameter in a calculated field.', 'duration': 28.97, 'max_score': 13286.914, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So13286914.jpg'}], 'start': 10932.973, 'title': 'Tableau data analysis functions', 'summary': 'Covers aggregate functions in data analysis, logical functions in tableau, levels of detail in tableau, and creating a sales graph in tableau, with a total of 21 specific functions and concepts discussed across these topics.', 'chapters': [{'end': 11272.129, 'start': 10932.973, 'title': 'Aggregate functions in data analysis', 'summary': 'Covers the concept of aggregate functions, including count, count d, max, min, average, correlation coefficient, covariance, percentile, median, and standard deviation, with practical examples and use cases.', 'duration': 339.156, 'highlights': ['The Pearson correlation measures the linear relationship between two variables and results range from minus 1 to plus 1, where one denotes an exact positive linear relationship, as when a positive change in one variable implies a positive change of the corresponding magnitude in the other (Pearson correlation coefficient).', 'The count D function returns the number of distinct items in a group, which means that if a certain item is there twice in a certain group, count D is going to count it as one item (count D).', 'The count function returns the number of items in a group, null values are obviously not counted (count).', "The aggregate function 'sum' returns the sum of all values in an expression and can be used only with numeric fields, with null values being ignored (sum).", 'The chapter also covers aggregate functions like attribute, correlation coefficient, covariance, max, median, min, percentile, and standard deviation, providing explanations and practical demonstrations.']}, {'end': 11674.218, 'start': 11272.729, 'title': 'Tableau logical functions', 'summary': "Covers logical functions in tableau, including 'and', 'case', 'else', 'if', 'is null', 'max', 'min', 'not', 'or', 'then', 'zn', and demonstrates a practical calculation using tableau desktop.", 'duration': 401.489, 'highlights': ["The logical 'and' function in Tableau performs a logical conjunction of two conditions and provides the output based on both conditions being true.", "The 'case' function in Tableau evaluates expressions, compares them to a sequence of values, and returns a result, offering a more concise alternative to 'if else' statements.", "The 'if null' function in Tableau returns expression 1 if the input expression is null, otherwise returns expression 2.", "The 'is date' function in Tableau returns true if a given string is a valid date.", 'The practical demonstration of creating a logical calculation using Tableau Desktop showcases the application of the covered logical functions in a real-world scenario.']}, {'end': 12433.998, 'start': 11674.838, 'title': 'Understanding levels of detail in tableau', 'summary': 'Explains the concept of levels of detail in tableau, including the types of lod expressions such as include, exclude, and fixed, their impact on aggregation, and the use of nesting in lod, aiming to provide a more efficient and granular data analysis approach.', 'duration': 759.16, 'highlights': ['The chapter discusses the various types of LOD calculations, including include, exclude, and fixed, which allow for more granular and less aggregated data analysis in Tableau.', 'It explains the impact of level of detail expressions on aggregation, with finer LOD expressions aggregating results up to the view level, while coarser LOD expressions may cause values to be replicated.', 'It provides insights into the nesting of LOD expressions, allowing users to write and nest multiple expressions as needed, along with the inheritance properties and impacts of fixed expressions on evaluation and affected filters.']}, {'end': 13185.632, 'start': 12433.998, 'title': 'Understanding tableau level of detail', 'summary': 'Explores the concept of level of detail in tableau, discussing the include, exclude, and fixed expressions, creating lod expressions for visualization, comparing lod with table calculations, and discussing the limitations of level of detail expressions.', 'duration': 751.634, 'highlights': ["The chapter discusses creating level of detail expressions for visualization, such as 'sales per customer' and 'exclude region', providing practical steps and examples for implementation.", 'It compares level of detail (LOD) expressions with table calculations, highlighting differences in generation, dimensions control, usage as aggregated measures, and the impact of filters.', 'It highlights the limitations of level of detail expressions, including unreliable behavior with floating-point measures, constraints when referencing parameters, and complexity limits in data blending, emphasizing the powerful capabilities of LOD expressions in solving complex problems in Tableau.']}, {'end': 13714.319, 'start': 13186.253, 'title': 'Creating sales graph in tableau', 'summary': 'Covers creating a sales graph in tableau, including steps to create a basic graph, customizing the date dialog box, creating a parameter for a what-if scenario, using parameters in calculated fields, and visualizing the effects on the data.', 'duration': 528.066, 'highlights': ["Creating a parameter for a what-if scenario by hyping up sales by 3% to create a calculated field, using Tableau functions to add a formula, and demonstrating Tableau's error detection system.", 'Customizing the date dialog box to show all months from 2015 to 2018, resulting in a more elaborate and informative graph.', 'Using parameter control to visualize the effects of the calculated field on the sales graph by comparing regular sales with sales grown by 3% in a dual axis graph.']}], 'duration': 2781.346, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So10932973.jpg', 'highlights': ['The chapter covers aggregate functions like sum, count, count D, attribute, correlation coefficient, covariance, max, median, min, percentile, and standard deviation.', 'The chapter discusses the various types of LOD calculations, including include, exclude, and fixed, allowing for more granular and less aggregated data analysis in Tableau.', "Creating a parameter for a what-if scenario by hyping up sales by 3% to create a calculated field, using Tableau functions to add a formula, and demonstrating Tableau's error detection system.", 'The practical demonstration of creating a logical calculation using Tableau Desktop showcases the application of the covered logical functions in a real-world scenario.', "The chapter discusses creating level of detail expressions for visualization, such as 'sales per customer' and 'exclude region', providing practical steps and examples for implementation."]}, {'end': 14460.273, 'segs': [{'end': 13786.006, 'src': 'embed', 'start': 13736.659, 'weight': 0, 'content': [{'end': 13744.883, 'text': 'Now parameters are dynamic and useful elements for you to add interactivity and flexibility to your dashboards and reports.', 'start': 13736.659, 'duration': 8.224}, {'end': 13750.747, 'text': 'It is a very versatile tool and can be used in way more than what I showed you in this demo.', 'start': 13745.204, 'duration': 5.543}, {'end': 13754.828, 'text': 'It can be used in various calculations sets equally.', 'start': 13751.187, 'duration': 3.641}, {'end': 13760.81, 'text': 'Well, now this is one of the many smart features that are there in tableau,', 'start': 13754.868, 'duration': 5.942}, {'end': 13768.813, 'text': 'which is emerging as one of the hottest Trends in business intelligence in 2019, and also, if I might add,', 'start': 13760.81, 'duration': 8.003}, {'end': 13776.556, 'text': 'it is one of the easiest data visualization tools to learn, one of the most interactive and smart softwares.', 'start': 13768.813, 'duration': 7.743}, {'end': 13786.006, 'text': 'And if you look at Google Trends, it seems like there can be no better time than right now to get certified in tableau to start learning tableau.', 'start': 13777.196, 'duration': 8.81}], 'summary': 'Tableau is a versatile and easy-to-learn data visualization tool, emerging as a hot trend in business intelligence in 2019, with increasing demand for certification.', 'duration': 49.347, 'max_score': 13736.659, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So13736659.jpg'}, {'end': 13886.852, 'src': 'embed', 'start': 13863.633, 'weight': 1, 'content': [{'end': 13871.876, 'text': 'the data you want to combine is stored in different databases and the granularity of the data captured in each table is different.', 'start': 13863.633, 'duration': 8.243}, {'end': 13875.865, 'text': 'So, in such a case, you use data blending now.', 'start': 13872.623, 'duration': 3.242}, {'end': 13880.228, 'text': 'data blending could be very useful under a few conditions,', 'start': 13875.865, 'duration': 4.363}, {'end': 13886.852, 'text': 'like you want to combine data from different databases that are not supported by cross database joints.', 'start': 13880.228, 'duration': 6.624}], 'summary': 'Data blending is useful when combining data from different databases with varying granularity.', 'duration': 23.219, 'max_score': 13863.633, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So13863633.jpg'}, {'end': 14058.984, 'src': 'embed', 'start': 14028.702, 'weight': 3, 'content': [{'end': 14031.945, 'text': 'It is basically an advanced version of your left join.', 'start': 14028.702, 'duration': 3.243}, {'end': 14039.219, 'text': 'Now, what is a join and how is it different from blending data in tableau?', 'start': 14033.138, 'duration': 6.081}, {'end': 14044.961, 'text': 'now, data blending stimulates a traditional left join, which I had mentioned a few seconds ago.', 'start': 14039.219, 'duration': 5.742}, {'end': 14050.702, 'text': 'The main difference between the two is when the join is performed with respect to aggregation.', 'start': 14045.261, 'duration': 5.441}, {'end': 14058.984, 'text': 'Now, when you use the left join to combine data, a query is sent to the database where the join is performed using.', 'start': 14051.302, 'duration': 7.682}], 'summary': 'Data blending in tableau is an advanced version of left join, differing in aggregation and query execution.', 'duration': 30.282, 'max_score': 14028.702, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So14028702.jpg'}, {'end': 14244.105, 'src': 'embed', 'start': 14208.721, 'weight': 4, 'content': [{'end': 14211.745, 'text': 'and that is why it is indicated by the second null value.', 'start': 14208.721, 'duration': 3.024}, {'end': 14214.972, 'text': 'Now, how can you blend your data now?', 'start': 14212.609, 'duration': 2.363}, {'end': 14223.52, 'text': 'You can use data blending when you have data and separate data sources that you want to analyze together on a single sheet example.', 'start': 14215.052, 'duration': 8.468}, {'end': 14229.907, 'text': "I'm going to show you now demonstrates how to blend your data from two different sources now for this.", 'start': 14223.56, 'duration': 6.347}, {'end': 14232.47, 'text': "I'll be moving on to my tableau desktop.", 'start': 14230.027, 'duration': 2.443}, {'end': 14244.105, 'text': "and here I'm going to be using two data sources named the sample Superstore, which is already included in the sample data sets of tableau,", 'start': 14233.835, 'duration': 10.27}], 'summary': 'Data blending allows analysis of data from multiple sources on a single sheet in tableau.', 'duration': 35.384, 'max_score': 14208.721, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So14208721.jpg'}, {'end': 14420.614, 'src': 'embed', 'start': 14389.199, 'weight': 5, 'content': [{'end': 14395.18, 'text': 'Let me go back to my presentation where we can go ahead now limitations of data blending.', 'start': 14389.199, 'duration': 5.981}, {'end': 14401.842, 'text': 'Now, what are the constraints that apply to this method? First of all blending with non-additive aggregates.', 'start': 14395.761, 'duration': 6.081}, {'end': 14412.632, 'text': 'Now there are some blending limitations around the non additive aggregates, such as your count D, median and raw SQL aggregate.', 'start': 14402.429, 'duration': 10.203}, {'end': 14420.614, 'text': "when you blend on a field with a high level of granularity, suppose date instead of your, let's say, queries can be slowed down.", 'start': 14412.632, 'duration': 7.982}], 'summary': 'Limitations of data blending include constraints with non-additive aggregates and slowed down queries with high granularity fields.', 'duration': 31.415, 'max_score': 14389.199, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So14389199.jpg'}], 'start': 13714.319, 'title': 'Tableau data blending and joins', 'summary': "Discusses the use of parameters in tableau for interactivity and flexibility, the versatility of tableau's features, and the importance of data blending in transforming and combining data for optimum efficiency. it also highlights the difference between data blending and joins, their impact on performance, practical examples of blending data from different sources, and the limitations and constraints of data blending, including issues with non-additive aggregates and the appearance of null values.", 'chapters': [{'end': 13939.495, 'start': 13714.319, 'title': 'Tableau data blending and using parameters', 'summary': "Discusses the use of parameters in tableau for interactivity and flexibility, the versatility of tableau's features, and the importance of data blending in transforming and combining data for optimum efficiency.", 'duration': 225.176, 'highlights': ["The versatility of Tableau's features, its emergence as a hot trend in business intelligence in 2019, and its ease of learning are highlighted, with a mention of the increasing demand for Tableau certification.", 'The significance of data blending is emphasized in addressing the need to combine data from different databases, especially when cross database joints are not supported, and when dealing with data at different levels of detail.', 'The benefits of using parameters in Tableau to add interactivity and flexibility to dashboards and reports are explained, showcasing its dynamic and useful elements.']}, {'end': 14460.273, 'start': 13939.675, 'title': 'Tableau: data blending and joins', 'summary': 'Discusses the use of data blending and joins in tableau, highlighting the difference between the two methods and their impact on performance, as well as providing practical examples of blending data from different sources. it also covers the limitations and constraints of data blending, including issues with non-additive aggregates and the appearance of null values.', 'duration': 520.598, 'highlights': ['Data blending vs. joins: Explains the difference between data blending and joins in Tableau, emphasizing the impact on performance and when to use each method.', 'Practical example of blending data: Provides a step-by-step example of blending data from two different sources in Tableau, demonstrating how to integrate the data based on a common dimension.', 'Limitations of data blending: Discusses the constraints and limitations of data blending, including issues with non-additive aggregates and the appearance of null values after blending data sources.']}], 'duration': 745.954, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So13714319.jpg', 'highlights': ["The versatility of Tableau's features and its increasing demand for certification.", 'The significance of data blending in combining data from different databases.', 'The benefits of using parameters in Tableau for interactivity and flexibility.', 'Explaining the difference between data blending and joins in Tableau.', 'Providing a practical example of blending data from different sources in Tableau.', 'Discussing the limitations of data blending, including issues with non-additive aggregates.']}, {'end': 15923.509, 'segs': [{'end': 14626.668, 'src': 'embed', 'start': 14578.125, 'weight': 3, 'content': [{'end': 14587.652, 'text': 'Now. this job is perfect for people who work well as a part of a team and who have problem solving skills that can manage their time productively to meet deadlines.', 'start': 14578.125, 'duration': 9.527}, {'end': 14597.742, 'text': 'A Tableau developer is usually someone that is proficient in data visualization, mathematical reasoning, database skills and extract,', 'start': 14588.439, 'duration': 9.303}, {'end': 14599.823, 'text': 'transform and loading processes.', 'start': 14597.742, 'duration': 2.081}, {'end': 14604.765, 'text': 'Pursuing a career as a Tableau developer can mean many things.', 'start': 14600.603, 'duration': 4.162}, {'end': 14608.206, 'text': 'A few of those I want to discuss with you today.', 'start': 14605.625, 'duration': 2.581}, {'end': 14611.487, 'text': 'First of all, the connectivity option you get.', 'start': 14608.986, 'duration': 2.501}, {'end': 14621.203, 'text': 'The reason why tableau stands out amongst all the bi tools is that there is a wide range of connectivity options now tableau can connect to any data.', 'start': 14612.276, 'duration': 8.927}, {'end': 14626.668, 'text': 'You can possibly think about starting from spreadsheets to databases and even big data.', 'start': 14621.243, 'duration': 5.425}], 'summary': 'Tableau developers need teamwork, problem-solving, and database skills. tableau can connect to various data sources.', 'duration': 48.543, 'max_score': 14578.125, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So14578125.jpg'}, {'end': 14702.495, 'src': 'embed', 'start': 14649.829, 'weight': 0, 'content': [{'end': 14656.652, 'text': 'Tableau is known as the leader in BI tools and it has been crowned the best by the IT research giant Gartner.', 'start': 14649.829, 'duration': 6.823}, {'end': 14666.738, 'text': "Gartner's Magic Quadrant mentioned Tableau for the fifth time in a row as the best amongst Tableau's competitors like Microsoft, SAP, and Qlik.", 'start': 14657.389, 'duration': 9.349}, {'end': 14672.985, 'text': 'In addition to having a great demand for Tableau experts, there are always rewards to offer.', 'start': 14667.619, 'duration': 5.366}, {'end': 14680.332, 'text': 'If you browse through the job portals like Indeed and AngelList, you can find plenty of job postings.', 'start': 14673.665, 'duration': 6.667}, {'end': 14689.971, 'text': 'Tableau professionals get the best of salaries in the IT come bi industry, with an average of $91, 000 per annum.', 'start': 14680.848, 'duration': 9.123}, {'end': 14694.853, 'text': 'that tons of jobs available which require tableau as a major skill set.', 'start': 14689.971, 'duration': 4.882}, {'end': 14702.495, 'text': "Now let's take a look at the responsibilities that come with this lucrative job profile.", 'start': 14695.813, 'duration': 6.682}], 'summary': 'Tableau is the leading bi tool, with high demand and an average salary of $91,000 per year.', 'duration': 52.666, 'max_score': 14649.829, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So14649829.jpg'}, {'end': 14925.543, 'src': 'embed', 'start': 14902.807, 'weight': 7, 'content': [{'end': 14913.293, 'text': 'And finally, they need to use BI technologies, structured query language, data analysis and ETL tools for storytelling and forecasting of data.', 'start': 14902.807, 'duration': 10.486}, {'end': 14920.62, 'text': 'Tableau represents data like no other tool with unique features like forecasting and storytelling.', 'start': 14914.315, 'duration': 6.305}, {'end': 14925.543, 'text': 'One can even connect to the data personally and understand the depth of the analysis.', 'start': 14921.34, 'duration': 4.203}], 'summary': 'Bi technologies, sql, tableau for data storytelling and forecasting.', 'duration': 22.736, 'max_score': 14902.807, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So14902807.jpg'}, {'end': 15303.672, 'src': 'embed', 'start': 15275.048, 'weight': 1, 'content': [{'end': 15280.972, 'text': 'So here you can see the number of jobs which are related to Tableau have increased exponentially.', 'start': 15275.048, 'duration': 5.924}, {'end': 15283.393, 'text': 'So this is January 2015.', 'start': 15281.712, 'duration': 1.681}, {'end': 15286.015, 'text': 'I think this might be January 2016.', 'start': 15283.393, 'duration': 2.622}, {'end': 15290.758, 'text': 'You can see the demand for Tableau professionals have grown considerably.', 'start': 15286.015, 'duration': 4.743}, {'end': 15298.063, 'text': 'And the national salary trend for Tableau again shows that the salary trend for Tableau is increasing.', 'start': 15291.219, 'duration': 6.844}, {'end': 15303.672, 'text': "So it's worth our time and effort to learn Tableau.", 'start': 15298.423, 'duration': 5.249}], 'summary': 'Tableau-related jobs have increased exponentially, with growing demand and increasing salaries.', 'duration': 28.624, 'max_score': 15275.048, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So15275048.jpg'}, {'end': 15399.743, 'src': 'embed', 'start': 15369.07, 'weight': 5, 'content': [{'end': 15370.791, 'text': 'So industry adoption is very high.', 'start': 15369.07, 'duration': 1.721}, {'end': 15375.655, 'text': 'And these are two top contender when it comes to visual analytics.', 'start': 15371.592, 'duration': 4.063}, {'end': 15377.316, 'text': 'We have Tableau and we have QlikView.', 'start': 15375.715, 'duration': 1.601}, {'end': 15383.241, 'text': 'And here is a comparison between them, the strong suit of QlikView versus Tableau.', 'start': 15377.696, 'duration': 5.545}, {'end': 15385.743, 'text': 'So both can analyze big data.', 'start': 15383.641, 'duration': 2.102}, {'end': 15390.387, 'text': 'Tableau, as you can see, I analyze billions of data, I analyze millions of data.', 'start': 15386.183, 'duration': 4.204}, {'end': 15391.808, 'text': 'ETL tools.', 'start': 15391.067, 'duration': 0.741}, {'end': 15393.801, 'text': 'are available in QlikView.', 'start': 15392.381, 'duration': 1.42}, {'end': 15396.642, 'text': 'ETL tools are not available in Tableau.', 'start': 15394.262, 'duration': 2.38}, {'end': 15399.743, 'text': "So that's one constraint which you will face in Tableau.", 'start': 15396.762, 'duration': 2.981}], 'summary': 'High industry adoption of tableau and qlikview. qlikview offers etl tools, tableau can analyze billions of data.', 'duration': 30.673, 'max_score': 15369.07, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So15369070.jpg'}, {'end': 15464.109, 'src': 'embed', 'start': 15436.213, 'weight': 4, 'content': [{'end': 15443.738, 'text': 'Tableau, on the other hand, is very intuitive, very user friendly and to work with Tableau, to pick up Tableau, to learn Tableau,', 'start': 15436.213, 'duration': 7.525}, {'end': 15446, 'text': 'is much easier as compared to ClickView.', 'start': 15443.738, 'duration': 2.262}, {'end': 15452.987, 'text': 'And once you have, you know, so while working with QlikView dashboards, you have to keep your end objective in mind.', 'start': 15446.742, 'duration': 6.245}, {'end': 15454.929, 'text': 'You have to do all those preparation.', 'start': 15453.027, 'duration': 1.902}, {'end': 15458.492, 'text': 'Going back and changing your dashboard will take extra effort.', 'start': 15455.009, 'duration': 3.483}, {'end': 15464.109, 'text': 'Tableau on the other hand, provides you the capability of rapid fire analysis.', 'start': 15459.012, 'duration': 5.097}], 'summary': 'Tableau is more intuitive and user-friendly than qlikview, offering rapid analysis capabilities.', 'duration': 27.896, 'max_score': 15436.213, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So15436213.jpg'}], 'start': 14460.273, 'title': 'Tableau developer insights and comparison', 'summary': "Provides insights into the role of a tableau developer, emphasizing its importance in the bi industry, detailing required skills, and highlighting increasing demand. it also compares tableau with qlikview, showcasing tableau's strengths in visualization and user community, with an average salary of $91,000 per annum.", 'chapters': [{'end': 14604.765, 'start': 14460.273, 'title': 'Tableau developer career insights', 'summary': 'Explores the role of a tableau developer, emphasizing the importance of tableau in the bi industry, detailing the responsibilities and skills required, and highlighting the increasing demand for tableau developers.', 'duration': 144.492, 'highlights': ['Tableau developer is one of the most sought after job roles in the BI industry, emphasizing the high demand for professionals skilled in Tableau.', 'Data blending in Tableau is a new approach that saves time, makes systems more efficient, and optimizes the data cycle, highlighting the efficiency and time-saving benefits of data blending in Tableau.', 'The responsibilities of a Tableau developer include creating solutions for data visualization, working with developers, creating tableau reports, and participating in feedback sessions to improve systems, showcasing the diverse tasks involved in the role.', 'The skills required for a Tableau developer include proficiency in data visualization, mathematical reasoning, database skills, and extract, transform, and loading processes, underlining the specific skills and expertise needed for this career.', 'Tableau is a platform that focuses on understanding data, creating dashboard reports, visualizations, and deriving insights to improve larger systems, outlining the primary functions and purpose of Tableau in business strategy.']}, {'end': 14902.047, 'start': 14605.625, 'title': 'Tableau developer: roles and skills', 'summary': 'Discusses the demand for tableau developers, emphasizing its connectivity options, career prospects, and key responsibilities, with an average salary of $91,000 per annum and a variety of job postings on platforms like indeed and angellist.', 'duration': 296.422, 'highlights': ['Tableau professionals receive an average salary of $91,000 per annum and there is a high demand for Tableau experts on job portals like Indeed and AngelList.', "Tableau is recognized as the leader in BI tools by Gartner's Magic Quadrant, mentioned for the fifth time in a row as the best amongst its competitors like Microsoft, SAP, and Qlik.", "Tableau's wide range of connectivity options allows it to connect to any data source, including spreadsheets, databases, big data, cloud applications like Salesforce, and cloud databases like Amazon Redshift.", 'The responsibilities of a Tableau developer include creating technical solutions, working with data storage tools, conducting tests and troubleshooting issues, enhancing existing systems, and creating technical documentation for completed projects.']}, {'end': 15368.609, 'start': 14902.807, 'title': 'Tableau developer skills & future', 'summary': "Discusses the skills required to become a tableau developer, the future prospects of tableau, and its job trends, including a mention of gartner's magic quadrant.", 'duration': 465.802, 'highlights': ['The demand for Tableau professionals has shown considerable growth, as the number of Tableau-related jobs has increased exponentially, and the national salary trend for Tableau professionals is on the rise.', "Tableau has been consistently positioned as a leader in Gartner's Magic Quadrant, demonstrating its strong ability to execute and completeness of vision, making it a top contender in the BI tools market.", "Tableau's unique features like forecasting, storytelling, and a wide range of connectivity options, including integration with R and Big Data, set it apart from other BI tools, enabling businesses to identify valuable data in expansive Hadoop data sets and engage with big data more feasibly.", "Skills required to become a Tableau developer include a bachelor's degree in business, computer science or similar field, proficiency with structured query languages in large data sets, excellent analytical skills, and experience in the whole life cycle development of applications at an enterprise level."]}, {'end': 15923.509, 'start': 15369.07, 'title': 'Tableau vs qlikview: a comparison', 'summary': "Highlights the comparison between tableau and qlikview, emphasizing tableau's ease of use, rapid visualization capabilities, active user community, and adherence to best visualization practices, making it a strong choice for data visualization, in contrast to qlikview's technical complexity and lack of etl tools.", 'duration': 554.439, 'highlights': ["Tableau offers a very intuitive and user-friendly interface, making it easy for novices to build dashboards and providing rapid visualization capabilities, enabling the creation of complex dashboards in a matter of days, in contrast to QlikView's technical complexity and longer dashboard creation time.", "Tableau has an active user community and works on user feedback, ensuring continuous improvement and potential feature enhancements, providing a supportive environment for developers, unlike QlikView's lack of community support and responsiveness to user needs.", 'Tableau is based on best practices of visualization, offering visually appealing charts, vibrant colors, and easy customization, promoting ease of transition for users familiar with MS Excel, while QlikView lacks ETL tools and does not follow best visualization practices, making it less user-friendly and visually appealing.', "Tableau's in-memory BI platform enables high scalability and rapid visualization, allowing users to work with large chunks of data efficiently, while QlikView lacks ETL tools and has constraints in handling big data, indicating Tableau's superiority in data handling capabilities."]}], 'duration': 1463.236, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So14460273.jpg', 'highlights': ['Tableau professionals receive an average salary of $91,000 per annum and there is a high demand for Tableau experts on job portals like Indeed and AngelList.', 'The demand for Tableau professionals has shown considerable growth, as the number of Tableau-related jobs has increased exponentially, and the national salary trend for Tableau professionals is on the rise.', "Tableau is recognized as the leader in BI tools by Gartner's Magic Quadrant, mentioned for the fifth time in a row as the best amongst its competitors like Microsoft, SAP, and Qlik.", "Tableau's wide range of connectivity options allows it to connect to any data source, including spreadsheets, databases, big data, cloud applications like Salesforce, and cloud databases like Amazon Redshift.", "Tableau offers a very intuitive and user-friendly interface, making it easy for novices to build dashboards and providing rapid visualization capabilities, enabling the creation of complex dashboards in a matter of days, in contrast to QlikView's technical complexity and longer dashboard creation time.", "Tableau's in-memory BI platform enables high scalability and rapid visualization, allowing users to work with large chunks of data efficiently, while QlikView lacks ETL tools and has constraints in handling big data, indicating Tableau's superiority in data handling capabilities.", "Tableau has been consistently positioned as a leader in Gartner's Magic Quadrant, demonstrating its strong ability to execute and completeness of vision, making it a top contender in the BI tools market.", "Tableau's unique features like forecasting, storytelling, and a wide range of connectivity options, including integration with R and Big Data, set it apart from other BI tools, enabling businesses to identify valuable data in expansive Hadoop data sets and engage with big data more feasibly.", 'The responsibilities of a Tableau developer include creating technical solutions, working with data storage tools, conducting tests and troubleshooting issues, enhancing existing systems, and creating technical documentation for completed projects.', 'The responsibilities of a Tableau developer include creating solutions for data visualization, working with developers, creating tableau reports, and participating in feedback sessions to improve systems, showcasing the diverse tasks involved in the role.']}, {'end': 17268.432, 'segs': [{'end': 15988.176, 'src': 'embed', 'start': 15948.681, 'weight': 0, 'content': [{'end': 15956.526, 'text': 'So a recent test which was run side by side on two different machines running the same data pool from Tableau Server.', 'start': 15948.681, 'duration': 7.845}, {'end': 15959.588, 'text': 'Internet Explorer 7 returned results in 11 seconds.', 'start': 15956.526, 'duration': 3.062}, {'end': 15961.45, 'text': 'Firefox returned results in three seconds.', 'start': 15959.588, 'duration': 1.862}, {'end': 15965.192, 'text': 'So the browser which you are using, that makes a difference.', 'start': 15961.53, 'duration': 3.662}, {'end': 15973.678, 'text': "So when you're working with Tableau Server, it's preferable to tell your users to use the latest browser which is the fastest one.", 'start': 15965.933, 'duration': 7.745}, {'end': 15975.659, 'text': 'So it does make a difference.', 'start': 15974.538, 'duration': 1.121}, {'end': 15981.252, 'text': 'Second tip, which I would like to share with you if complex calculations are needed in Tableau,', 'start': 15976.269, 'duration': 4.983}, {'end': 15984.374, 'text': 'consider creating a DBMS view that does the calculation.', 'start': 15981.252, 'duration': 3.122}, {'end': 15988.176, 'text': 'The database server is usually more powerful than the desktop.', 'start': 15985.115, 'duration': 3.061}], 'summary': "Using firefox with tableau server yielded 3-second results, while internet explorer took 11 seconds. advise users to opt for faster browsers. consider creating a dbms view for complex calculations in tableau, leveraging the database server's power.", 'duration': 39.495, 'max_score': 15948.681, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So15948681.jpg'}, {'end': 16092.692, 'src': 'embed', 'start': 16054.114, 'weight': 1, 'content': [{'end': 16060.258, 'text': 'Okay, so what you should do is you should summarize your data at DBMS level and then pull that data within Tableau.', 'start': 16054.114, 'duration': 6.144}, {'end': 16060.858, 'text': "It's going to help.", 'start': 16060.278, 'duration': 0.58}, {'end': 16062.019, 'text': 'Does that make sense?', 'start': 16061.319, 'duration': 0.7}, {'end': 16070.242, 'text': 'And consider the use of Pre-computer aggregated summary tables when large data set are required, typically when summary, summarized when used.', 'start': 16062.399, 'duration': 7.843}, {'end': 16072.003, 'text': 'Okay, again, same point.', 'start': 16070.682, 'duration': 1.321}, {'end': 16080.686, 'text': 'You have to sort of like keep in mind the granularity of your data if you are working on calculated fields which are not going to change frequently.', 'start': 16072.263, 'duration': 8.423}, {'end': 16083.847, 'text': 'Maybe row level calculations, some if-else calculation which you are doing.', 'start': 16080.726, 'duration': 3.121}, {'end': 16086.308, 'text': 'You can do that right within DBMS.', 'start': 16084.647, 'duration': 1.661}, {'end': 16090.831, 'text': "If you're aggregating your data, summarizing your data, do that outside of Tableau.", 'start': 16086.628, 'duration': 4.203}, {'end': 16092.692, 'text': "It's going to increase your speed.", 'start': 16090.871, 'duration': 1.821}], 'summary': 'Summarize data at dbms level, use aggregated summary tables for large datasets, consider data granularity for calculated fields to improve speed.', 'duration': 38.578, 'max_score': 16054.114, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So16054114.jpg'}, {'end': 16187.648, 'src': 'embed', 'start': 16159.921, 'weight': 3, 'content': [{'end': 16165.082, 'text': "Connect to only those data sources which you are going to use, which you are sure you're going to use.", 'start': 16159.921, 'duration': 5.161}, {'end': 16167.923, 'text': 'And use extracts.', 'start': 16166.062, 'duration': 1.861}, {'end': 16175.824, 'text': 'So when you extract the data, you will actually get additional features like you can use certain formulas.', 'start': 16168.503, 'duration': 7.321}, {'end': 16179.925, 'text': 'Tableau is going to optimize your data to improve its performance.', 'start': 16176.244, 'duration': 3.681}, {'end': 16184.286, 'text': 'So use of extract is going to increase the performance of your dashboard.', 'start': 16180.225, 'duration': 4.061}, {'end': 16187.648, 'text': 'When filtering, try to avoid the exclude option.', 'start': 16184.767, 'duration': 2.881}], 'summary': 'Use extracts for optimized data performance in tableau dashboards.', 'duration': 27.727, 'max_score': 16159.921, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So16159921.jpg'}, {'end': 16372.271, 'src': 'embed', 'start': 16344.492, 'weight': 8, 'content': [{'end': 16349.995, 'text': 'Are you able to recognize this? So one if statement, another if statement.', 'start': 16344.492, 'duration': 5.503}, {'end': 16352.336, 'text': 'This is nested if.', 'start': 16350.535, 'duration': 1.801}, {'end': 16353.737, 'text': 'One statement within another.', 'start': 16352.556, 'duration': 1.181}, {'end': 16356.998, 'text': 'Okay, this one will be slow.', 'start': 16354.297, 'duration': 2.701}, {'end': 16358.899, 'text': 'You can write it like this.', 'start': 16357.639, 'duration': 1.26}, {'end': 16366.384, 'text': 'Instead of giving this space between else and if and making it nested, Just give the next option as else if.', 'start': 16359.2, 'duration': 7.184}, {'end': 16368.166, 'text': 'Okay, check the second criteria.', 'start': 16366.664, 'duration': 1.502}, {'end': 16372.271, 'text': 'Here we have just one if statement, therefore just one end statement.', 'start': 16368.646, 'duration': 3.625}], 'summary': "The transcript discusses nested if statements, recommending using 'else if' for efficiency.", 'duration': 27.779, 'max_score': 16344.492, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So16344492.jpg'}, {'end': 16765.853, 'src': 'embed', 'start': 16733.362, 'weight': 2, 'content': [{'end': 16735.143, 'text': "So that's another tip I wanted to share.", 'start': 16733.362, 'duration': 1.781}, {'end': 16740.124, 'text': 'And then we have some context filters.', 'start': 16737.283, 'duration': 2.841}, {'end': 16749.328, 'text': 'Anyone of you is not aware of context filters? The context filters, they are also used for optimizing the performance from times to times.', 'start': 16740.504, 'duration': 8.824}, {'end': 16753.528, 'text': 'So there are many different features you can use to optimize the performance of your dashboard.', 'start': 16749.527, 'duration': 4.001}, {'end': 16765.853, 'text': 'Okay, third question can Tableau create operational report where data changes every second and also it looks like the drill down table data that Tableau shows as picture format and cannot be refreshed real time?', 'start': 16754.221, 'duration': 11.632}], 'summary': 'Tips for optimizing dashboard performance, including use of context filters and features in tableau.', 'duration': 32.491, 'max_score': 16733.362, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So16733362.jpg'}, {'end': 17176.777, 'src': 'embed', 'start': 17150.219, 'weight': 6, 'content': [{'end': 17157.305, 'text': 'You should always allow drill down capabilities within dashboard rather than creating separate charts for each different condition.', 'start': 17150.219, 'duration': 7.086}, {'end': 17161.848, 'text': 'Rather than creating distribution of male,', 'start': 17157.985, 'duration': 3.863}, {'end': 17168.454, 'text': "let's say we are working on a HR dashboard and we want to see how many male employees are working across different departments,", 'start': 17161.848, 'duration': 6.606}, {'end': 17171.236, 'text': 'how many female employees are working across different departments?', 'start': 17168.454, 'duration': 2.782}, {'end': 17176.777, 'text': 'and then how many male employees less than 25 years are working in different department?', 'start': 17171.636, 'duration': 5.141}], 'summary': 'Use drill down in dashboard for gender and age distribution in hr department.', 'duration': 26.558, 'max_score': 17150.219, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17150219.jpg'}], 'start': 15924.01, 'title': 'Optimizing tableau reports, data analysis, and performance', 'summary': 'Covers optimizing tableau reports for better performance, highlighting impact of browser choice on report retrieval time (e.g., ie 7: 11 sec, firefox: 3 sec), leveraging dbms views for complex calculations, aggregating data within dbms, using pre-computed aggregated summary tables, creating extracts, and optimizing if-else statements and logical calculations for faster performance. it also emphasizes visualization optimization and project-specific dashboard creation approaches.', 'chapters': [{'end': 15988.176, 'start': 15924.01, 'title': 'Optimizing tableau reports', 'summary': "Discusses optimizing tableau reports for better performance, highlighting the impact of browser choice on report retrieval time, with internet explorer 7 taking 11 seconds and firefox taking 3 seconds, and the recommendation to use the latest, fastest browser for tableau server. it also emphasizes the use of dbms views for complex calculations due to the database server's greater power.", 'duration': 64.166, 'highlights': ['The impact of browser choice on report retrieval time: Internet Explorer 7 took 11 seconds, while Firefox took 3 seconds, demonstrating the substantial difference in performance (quantifiable data).', 'The recommendation to use the latest, fastest browser for Tableau Server, with the discussion of its significant impact on report retrieval time (quantifiable data).', 'The suggestion to create a DBMS view for complex calculations in Tableau due to the greater power of the database server compared to the desktop.']}, {'end': 16260.579, 'start': 15988.837, 'title': 'Optimizing data analysis in tableau', 'summary': 'Emphasizes optimizing data analysis in tableau by aggregating data within dbms, using pre-computed aggregated summary tables for large datasets, and creating extracts to improve dashboard performance.', 'duration': 271.742, 'highlights': ['Aggregating data within DBMS and summarizing data outside of Tableau can increase speed, especially for large datasets beyond 10 million rows.', 'Using extracts in Tableau can optimize data and improve dashboard performance, making data analysis more efficient.', 'Pre-computed aggregated summary tables should be considered for large datasets, as they can significantly enhance performance and speed of analysis.', 'When filtering data, it is recommended to avoid using the exclude option in Tableau, as it can slow down the process, and instead use the include option for better performance.', 'Connecting to only necessary data sources and using Boolean calculations with alias whenever possible can improve the efficiency of data analysis in Tableau.']}, {'end': 16582.794, 'start': 16260.92, 'title': 'Optimizing if-else statements and logical calculations', 'summary': 'Discusses optimization techniques for if-else statements and logical calculations, including simplifying if-else formulas, using else if instead of nested if, and breaking down calculations into row level and aggregated calculations for faster performance.', 'duration': 321.874, 'highlights': ['Using else if rather than nested else if in logical statements can improve performance, as it eliminates the need for nested if statements and reduces processing time.', 'Breaking down calculations into row level and aggregated calculations can optimize performance by allowing Tableau to perform the row level calculation and aggregation separately, resulting in faster processing.', 'Utilizing logical calculations to simplify if statements can enhance performance, as it reduces the need for unnecessary checks and speeds up code execution.', "Optimizing timestamp-related calculations by using 'today' instead of 'now' for smaller datasets, as it restricts the scope of calculation and improves processing speed."]}, {'end': 17268.432, 'start': 16583.094, 'title': 'Tableau visualization and performance optimization', 'summary': 'Discusses the importance of revisiting visualizations to remove unused fields, optimizing performance through features like hierarchy and context filters, and different types of tableau projects and their approach to creating the best possible dashboard.', 'duration': 685.338, 'highlights': ['Optimizing performance by revisiting visualizations to remove unused fields, utilizing features like hierarchy and context filters, and involving business people in dashboard design', 'Different types of Tableau projects including migration, brand new, ad hoc reporting, and exploratory research to guide predictive modeling', 'Utilizing drill down capabilities within dashboard for various permutations and combinations instead of creating separate charts for each condition']}], 'duration': 1344.422, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So15924010.jpg', 'highlights': ['The impact of browser choice on report retrieval time: Internet Explorer 7 took 11 seconds, while Firefox took 3 seconds, demonstrating the substantial difference in performance (quantifiable data).', 'Aggregating data within DBMS and summarizing data outside of Tableau can increase speed, especially for large datasets beyond 10 million rows.', 'Optimizing performance by revisiting visualizations to remove unused fields, utilizing features like hierarchy and context filters, and involving business people in dashboard design', 'Using extracts in Tableau can optimize data and improve dashboard performance, making data analysis more efficient.', 'Pre-computed aggregated summary tables should be considered for large datasets, as they can significantly enhance performance and speed of analysis.', 'The recommendation to use the latest, fastest browser for Tableau Server, with the discussion of its significant impact on report retrieval time (quantifiable data).', 'Utilizing drill down capabilities within dashboard for various permutations and combinations instead of creating separate charts for each condition', 'The suggestion to create a DBMS view for complex calculations in Tableau due to the greater power of the database server compared to the desktop.', 'Using else if rather than nested else if in logical statements can improve performance, as it eliminates the need for nested if statements and reduces processing time.', 'Breaking down calculations into row level and aggregated calculations can optimize performance by allowing Tableau to perform the row level calculation and aggregation separately, resulting in faster processing.']}, {'end': 18701.637, 'segs': [{'end': 17313.577, 'src': 'embed', 'start': 17268.432, 'weight': 0, 'content': [{'end': 17277.641, 'text': 'good?. So these kind of actionable information, if you show, then the adoption or the success of your dashboard will be high.', 'start': 17268.432, 'duration': 9.209}, {'end': 17279.563, 'text': "Don't include too much.", 'start': 17278.081, 'duration': 1.482}, {'end': 17282.085, 'text': "So don't overburden your dashboard.", 'start': 17280.043, 'duration': 2.042}, {'end': 17282.866, 'text': 'Keep it simple.', 'start': 17282.125, 'duration': 0.741}, {'end': 17284.845, 'text': 'Keep it non-cluttered.', 'start': 17283.504, 'duration': 1.341}, {'end': 17287.748, 'text': 'If you want, create multiple dashboards in your file.', 'start': 17285.166, 'duration': 2.582}, {'end': 17291.151, 'text': "Don't put too much of information within one single screen.", 'start': 17288.448, 'duration': 2.703}, {'end': 17293.052, 'text': 'Show relevant filters.', 'start': 17291.671, 'duration': 1.381}, {'end': 17299.198, 'text': 'Relevant filters means in Tableau you have this feature of creating relevant filters.', 'start': 17293.753, 'duration': 5.445}, {'end': 17305.804, 'text': 'I hope you are aware of it, right? So for example, I can use floor number as a filter here.', 'start': 17299.378, 'duration': 6.426}, {'end': 17309.827, 'text': 'Floor number and these floor numbers are appearing.', 'start': 17306.905, 'duration': 2.922}, {'end': 17313.577, 'text': 'This is showing me different employees and which floor they are working on.', 'start': 17309.907, 'duration': 3.67}], 'summary': 'To improve dashboard adoption, keep it simple, non-cluttered, use relevant filters, and create multiple dashboards if needed.', 'duration': 45.145, 'max_score': 17268.432, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17268432.jpg'}, {'end': 17461.57, 'src': 'embed', 'start': 17408.474, 'weight': 2, 'content': [{'end': 17412.558, 'text': 'and that dashboard came back to me, I had to make it colorblind proof.', 'start': 17408.474, 'duration': 4.084}, {'end': 17417.141, 'text': 'So if your dashboard is being shared across multiple different users,', 'start': 17412.858, 'duration': 4.283}, {'end': 17423.987, 'text': 'maybe like 50 or 100 different users assume that some of them probably will be facing this difficulty.', 'start': 17417.141, 'duration': 6.846}, {'end': 17429.151, 'text': 'And just adopt some technique through which you can counter colorblindness.', 'start': 17425.048, 'duration': 4.103}, {'end': 17433.735, 'text': 'What are those techniques? You can use shades instead of vibrant colors.', 'start': 17429.391, 'duration': 4.344}, {'end': 17442.102, 'text': "So if you are creating some, if you're creating a bar chart like this, maybe something like this.", 'start': 17434.175, 'duration': 7.927}, {'end': 17443.463, 'text': 'Try to give shade.', 'start': 17442.542, 'duration': 0.921}, {'end': 17448.805, 'text': 'Here you can see these are shades of the same color, two different shades of almost the same color.', 'start': 17443.523, 'duration': 5.282}, {'end': 17451.946, 'text': 'This can be interpreted by a colorblind person.', 'start': 17449.285, 'duration': 2.661}, {'end': 17461.57, 'text': 'If you give two dark colors of different shades, maybe green or yellow, the colorblind person may find it difficult to comprehend.', 'start': 17453.106, 'duration': 8.464}], 'summary': 'Make dashboards colorblind-proof for 50-100 users by using shades instead of vibrant colors.', 'duration': 53.096, 'max_score': 17408.474, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17408474.jpg'}, {'end': 17574.688, 'src': 'embed', 'start': 17546.236, 'weight': 3, 'content': [{'end': 17548.517, 'text': 'So here you need to show percentage value.', 'start': 17546.236, 'duration': 2.281}, {'end': 17549.937, 'text': 'So just think carefully about it.', 'start': 17548.617, 'duration': 1.32}, {'end': 17552.698, 'text': 'The example which I gave to you was pretty apparent.', 'start': 17550.117, 'duration': 2.581}, {'end': 17555.341, 'text': 'In real world, it might not be that happened.', 'start': 17553.32, 'duration': 2.021}, {'end': 17560.463, 'text': 'So you have to think of it carefully, whether I should show percentage value or numeric value.', 'start': 17555.381, 'duration': 5.082}, {'end': 17565.184, 'text': 'And follow consistent and differential color coding.', 'start': 17561.923, 'duration': 3.261}, {'end': 17574.688, 'text': 'For example, if you are building a HR dashboard, you are showing male, female in a pie chart, and then male, female again in some 100% stacked bar.', 'start': 17565.865, 'duration': 8.823}], 'summary': 'Consider showing percentage or numeric value, use consistent color coding in hr dashboard.', 'duration': 28.452, 'max_score': 17546.236, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17546236.jpg'}, {'end': 17784.418, 'src': 'embed', 'start': 17759.068, 'weight': 5, 'content': [{'end': 17765.85, 'text': "Yeah, and especially if you're using action filters, then you can actually apply filters across different dashboards.", 'start': 17759.068, 'duration': 6.782}, {'end': 17773.793, 'text': "Okay, so I can choose female here and it's actually going to filter out some of my dashboard, some of my charts in this particular dashboard.", 'start': 17766.13, 'duration': 7.663}, {'end': 17777.374, 'text': 'You can enable those features also using action filters.', 'start': 17774.093, 'duration': 3.281}, {'end': 17781.856, 'text': "In that case, it's absolutely imperative to show these filters.", 'start': 17777.755, 'duration': 4.101}, {'end': 17784.418, 'text': 'what filters they have applied.', 'start': 17783.237, 'duration': 1.181}], 'summary': 'Action filters enable cross-dashboard filtering, imperative to display applied filters.', 'duration': 25.35, 'max_score': 17759.068, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17759068.jpg'}, {'end': 17835.884, 'src': 'embed', 'start': 17804.792, 'weight': 7, 'content': [{'end': 17808.174, 'text': 'I would recommend using this particular feature of Tableau.', 'start': 17804.792, 'duration': 3.382}, {'end': 17811.827, 'text': 'Go to dashboard, keep a fixed size.', 'start': 17808.945, 'duration': 2.882}, {'end': 17816.971, 'text': 'Do not, never, ever, ever, ever choose this option.', 'start': 17812.528, 'duration': 4.443}, {'end': 17819.552, 'text': 'This is suicidal.', 'start': 17817.691, 'duration': 1.861}, {'end': 17822.755, 'text': "And that's the word which comes to my mind.", 'start': 17820.593, 'duration': 2.162}, {'end': 17824.676, 'text': 'Automatic, never choose this.', 'start': 17823.015, 'duration': 1.661}, {'end': 17830.1, 'text': "If I'm going to project this through a projector on a screen, it's going to look different.", 'start': 17825.377, 'duration': 4.723}, {'end': 17835.884, 'text': "If I'm going to transfer it on to some of you, you have a different screen size, it's going to look different in your case.", 'start': 17830.42, 'duration': 5.464}], 'summary': "Avoid selecting the 'automatic' size option in tableau dashboards to ensure consistent display across different screens.", 'duration': 31.092, 'max_score': 17804.792, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17804792.jpg'}, {'end': 17875.312, 'src': 'embed', 'start': 17851.173, 'weight': 6, 'content': [{'end': 17857.755, 'text': "And also it's good to check it on different screens, especially if you're going to transfer it to different users.", 'start': 17851.173, 'duration': 6.582}, {'end': 17863.636, 'text': 'Now many of these tips are applicable for these two projects.', 'start': 17858.075, 'duration': 5.561}, {'end': 17872.971, 'text': 'So, for migration projects and brand new projects, especially if you have more than three, four users who are going to use that particular dashboard,', 'start': 17864.648, 'duration': 8.323}, {'end': 17875.312, 'text': 'make sure you are following those tips which I shared with you.', 'start': 17872.971, 'duration': 2.341}], 'summary': 'Tips for dashboard design: suitable for migration and new projects with 3-4 users', 'duration': 24.139, 'max_score': 17851.173, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17851173.jpg'}, {'end': 17917.495, 'src': 'embed', 'start': 17892.32, 'weight': 8, 'content': [{'end': 17899.728, 'text': "of course it's a more complex topic in Tableau, but for effective data blending, these are some points which you need to keep in mind.", 'start': 17892.32, 'duration': 7.408}, {'end': 17909.36, 'text': 'When you have data blending done, your primary data source will show up in blue, and secondary data source will show up in orange.', 'start': 17900.209, 'duration': 9.151}, {'end': 17912.283, 'text': 'Here you can see, this is secondary, this is primary.', 'start': 17909.62, 'duration': 2.663}, {'end': 17917.495, 'text': 'What if I want my dashboard to be viewable on mobile devices?', 'start': 17913.129, 'duration': 4.366}], 'summary': 'Effective data blending in tableau involves distinguishing primary and secondary data sources and considering mobile compatibility.', 'duration': 25.175, 'max_score': 17892.32, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17892320.jpg'}, {'end': 18162.948, 'src': 'embed', 'start': 18135.156, 'weight': 9, 'content': [{'end': 18141.338, 'text': 'The first field which you are going to pull up into your tableau environment in your particular sheet.', 'start': 18135.156, 'duration': 6.182}, {'end': 18143.699, 'text': 'That is going to define your primary data source.', 'start': 18141.838, 'duration': 1.861}, {'end': 18146.3, 'text': "There's no set primary data source.", 'start': 18143.719, 'duration': 2.581}, {'end': 18149.242, 'text': "Let's say we have sales and promotion.", 'start': 18147.02, 'duration': 2.222}, {'end': 18152.183, 'text': 'Sales have 10 fields, promotions have 20 fields.', 'start': 18149.622, 'duration': 2.561}, {'end': 18155.124, 'text': 'I click on this container, container for sales.', 'start': 18152.723, 'duration': 2.401}, {'end': 18162.948, 'text': 'Okay, let me just see if there is a dashboard I have prebuilt which has data blending feature.', 'start': 18155.425, 'duration': 7.523}], 'summary': 'Pull up primary data source in tableau with 10 fields for sales and 20 fields for promotions.', 'duration': 27.792, 'max_score': 18135.156, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18135156.jpg'}, {'end': 18400.88, 'src': 'embed', 'start': 18370.579, 'weight': 10, 'content': [{'end': 18375.083, 'text': 'Okay, you have to enable the blending feature on the correct field.', 'start': 18370.579, 'duration': 4.504}, {'end': 18379.306, 'text': 'And this was just part of the tip which I shared with you.', 'start': 18376.844, 'duration': 2.462}, {'end': 18382.948, 'text': 'We have to still come up to that level.', 'start': 18379.966, 'duration': 2.982}, {'end': 18387.832, 'text': "Okay, so while doing, and I'm just going to answer your question on filtering.", 'start': 18384.289, 'duration': 3.543}, {'end': 18392.751, 'text': 'Let me just complete this and then I will show you the example on filtering.', 'start': 18387.912, 'duration': 4.839}, {'end': 18396.035, 'text': 'So sometimes you see null value and this star symbol.', 'start': 18393.112, 'duration': 2.923}, {'end': 18400.88, 'text': 'Just make sure that you are clicking on the right chain.', 'start': 18396.595, 'duration': 4.285}], 'summary': 'Enable blending feature on correct field, addressing filtering questions and null value handling.', 'duration': 30.301, 'max_score': 18370.579, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18370579.jpg'}, {'end': 18503.122, 'src': 'embed', 'start': 18472.497, 'weight': 11, 'content': [{'end': 18473.998, 'text': 'And you can actually apply this filter.', 'start': 18472.497, 'duration': 1.501}, {'end': 18479.779, 'text': 'And then once you have dropped your field in this filter section, then you can right click and choose show quick filter.', 'start': 18474.138, 'duration': 5.641}, {'end': 18481.459, 'text': "And then it's going to work just well.", 'start': 18480.099, 'duration': 1.36}, {'end': 18482.76, 'text': 'This is one way.', 'start': 18482.08, 'duration': 0.68}, {'end': 18492.158, 'text': 'Another way is, you can create a parameter across and a parameter and a calculated field in your particular.', 'start': 18483.58, 'duration': 8.578}, {'end': 18497.84, 'text': 'you know, if both of your data source contains the same values, you can make use of parameters as well.', 'start': 18492.158, 'duration': 5.682}, {'end': 18500.981, 'text': 'Create a calculated field, use them in filter like I have done here.', 'start': 18498.14, 'duration': 2.841}, {'end': 18503.122, 'text': 'Department name, though it was not a calculated field.', 'start': 18501.141, 'duration': 1.981}], 'summary': 'Use filters and parameters to manipulate and manage data in your field for effective analysis and visualization.', 'duration': 30.625, 'max_score': 18472.497, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18472497.jpg'}], 'start': 17268.432, 'title': 'Dashboard design best practices', 'summary': 'Emphasizes the importance of simple, non-cluttered dashboards, relevant filters, and tableau best practices for user experience and consistent visualization across screens, improving user understanding and accessibility.', 'chapters': [{'end': 17384.18, 'start': 17268.432, 'title': 'Dashboard design best practices', 'summary': 'Emphasizes the importance of keeping dashboards simple and non-cluttered, using relevant filters in tableau to display only relevant values, thus improving user experience and reducing confusion.', 'duration': 115.748, 'highlights': ['Using relevant filters in Tableau to display only relevant values improves user experience and reduces confusion.', 'Keeping dashboards simple and non-cluttered enhances adoption and success rates.', 'Creating multiple dashboards in a file can prevent overburdening a single screen with too much information.']}, {'end': 17803.651, 'start': 17384.48, 'title': 'Designing accessible and user-friendly dashboards', 'summary': 'Highlights the importance of creating colorblind-proof dashboards, displaying values as percentage or real numeric values based on the context, maintaining consistent and differential color coding, showing applied filters for user ease, and testing dashboards on different screens for user accessibility and understanding.', 'duration': 419.171, 'highlights': ['Creating colorblind-proof dashboards by using shades instead of vibrant colors and being mindful of color choices to ensure accessibility for all users, as demonstrated through a real-life example of a colorblind leader encountering difficulties with a dashboard.', 'Displaying values as percentage or real numeric values based on the context, illustrated through a comparison of displaying gender ratios in different departments using percentage values for accurate representation.', 'Emphasizing the importance of maintaining consistent and differential color coding to avoid confusion and ensure clear visualization of data, with practical examples of using distinct color codes for different categories such as gender and job roles.', 'Demonstrating the usefulness of showing applied filters for user ease, especially in interconnected dashboards, and the potential confusion and misinterpretation that can arise if filters are not clearly displayed.', 'Highlighting the significance of testing dashboards on different screens to ensure user accessibility and understanding, emphasizing the need for dashboards to be compatible and comprehensible across various devices and display sizes.']}, {'end': 18313.105, 'start': 17804.792, 'title': 'Tableau dashboard best practices', 'summary': 'Emphasizes best practices for tableau dashboard design, including fixed size, effective data blending, and database connection, to ensure consistent visualization across different screens and users, particularly for migration and brand new projects, with specific tips for data blending and database connection.', 'duration': 508.313, 'highlights': ['Always use fixed size for Tableau dashboards to ensure consistent visualization across different screens and users.', 'Effective data blending in Tableau involves keeping in mind the colors used to differentiate between primary (blue) and secondary (orange) data sources.', 'When connecting to a database through Tableau, a step-by-step process is outlined, including options for Tableau Data Server and connecting to specific databases such as MS SQL.', 'The chapter provides insights into data blending, emphasizing that the first field pulled into Tableau defines the primary data source, and there is no fixed primary or secondary source.', 'The different types of joins (i.e., left outer join and right outer join) are explained, along with how to simulate them by switching the primary and secondary data sources in Tableau data blending.']}, {'end': 18701.637, 'start': 18313.725, 'title': 'Tableau data blending tips', 'summary': 'Covers tips on tableau data blending, including creating parameters for multiple data sources and the importance of correctly enabling and using blending features, with a focus on filtering and the implications of blending on analysis scopes.', 'duration': 387.912, 'highlights': ['Enabling the correct blending feature and creating a calculated field with a filter can facilitate the use of global filters from different data sources.', 'Data blending based on field names such as employee ID and last rating, and the importance of enabling connections between relevant fields for successful blending.', 'The process of applying filters in blended data, including using quick filters and parameters, and the need to carefully choose and apply filters in blended data.', 'The significance of the order of blending or blended fields in changing the scope of analysis, illustrated with an example of blending data from arrival and departure airports in Tableau.']}], 'duration': 1433.205, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So17268432.jpg', 'highlights': ['Using relevant filters in Tableau improves user experience and reduces confusion.', 'Keeping dashboards simple and non-cluttered enhances adoption and success rates.', 'Creating colorblind-proof dashboards ensures accessibility for all users.', 'Displaying values as percentage or real numeric values based on the context is crucial.', 'Maintaining consistent and differential color coding avoids confusion.', 'Showing applied filters for user ease is significant, especially in interconnected dashboards.', 'Testing dashboards on different screens ensures user accessibility and understanding.', 'Always use fixed size for Tableau dashboards to ensure consistent visualization.', 'Effective data blending in Tableau involves keeping in mind the colors used to differentiate between primary and secondary data sources.', 'Insights into data blending emphasize the first field pulled into Tableau defines the primary data source.', 'Enabling the correct blending feature and creating a calculated field with a filter facilitates the use of global filters from different data sources.', 'The process of applying filters in blended data is significant, including using quick filters and parameters.']}, {'end': 19470.095, 'segs': [{'end': 18794.284, 'src': 'embed', 'start': 18749.971, 'weight': 0, 'content': [{'end': 18752.411, 'text': 'Number of male employees versus number of female employees.', 'start': 18749.971, 'duration': 2.44}, {'end': 18754.232, 'text': 'We have categorical data here.', 'start': 18752.431, 'duration': 1.801}, {'end': 18758.245, 'text': 'If you are trying to compare categorical data, you use bar graph.', 'start': 18754.983, 'duration': 3.262}, {'end': 18763.087, 'text': 'Line graph is used to show trend over a period of time.', 'start': 18759.165, 'duration': 3.922}, {'end': 18766.409, 'text': 'If you want to see how things are moving with respect to time.', 'start': 18763.188, 'duration': 3.221}, {'end': 18772.853, 'text': 'Is your sales increasing? Is your sales decreasing? With respect to time, mostly, you use line chart.', 'start': 18766.469, 'duration': 6.384}, {'end': 18778.976, 'text': 'Pie chart is used to show the percentage contribution, mostly, in most of the cases.', 'start': 18773.413, 'duration': 5.563}, {'end': 18782.218, 'text': 'You can use it exceptionally also, but most of the cases.', 'start': 18778.996, 'duration': 3.222}, {'end': 18790.381, 'text': 'Pie chart is used to show contribution, percentage contribution to 100% of different components.', 'start': 18782.975, 'duration': 7.406}, {'end': 18794.284, 'text': 'Okay, so for example, you have your employee base.', 'start': 18790.981, 'duration': 3.303}], 'summary': 'Use bar graph to compare male vs female employees; line graph for trends over time; pie chart for percentage contribution.', 'duration': 44.313, 'max_score': 18749.971, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18749971.jpg'}, {'end': 18838.962, 'src': 'embed', 'start': 18812.865, 'weight': 3, 'content': [{'end': 18818.789, 'text': 'Scatterplot is used to show the relationship between two continuous numeric variable.', 'start': 18812.865, 'duration': 5.924}, {'end': 18824.273, 'text': 'When you want to explore the relationship between two continuous numeric variable, you use a scatterplot.', 'start': 18819.25, 'duration': 5.023}, {'end': 18830.057, 'text': 'So for example, salary of an employee versus age of the employee.', 'start': 18825.094, 'duration': 4.963}, {'end': 18835.44, 'text': 'You want to see if Older employees are getting paid more than younger employees.', 'start': 18831.158, 'duration': 4.282}, {'end': 18838.962, 'text': "Or maybe experience of the employee versus the salary he's getting.", 'start': 18835.761, 'duration': 3.201}], 'summary': 'Scatterplot shows relationship between continuous variables, e.g. salary vs. age or experience vs. salary.', 'duration': 26.097, 'max_score': 18812.865, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18812865.jpg'}, {'end': 18914.92, 'src': 'embed', 'start': 18884.449, 'weight': 4, 'content': [{'end': 18890.051, 'text': 'Histogram is used to show the distribution of continuous numeric variable.', 'start': 18884.449, 'duration': 5.602}, {'end': 18896.412, 'text': 'whether employees on average, they are earning on higher side or they are earning on lower side.', 'start': 18890.97, 'duration': 5.442}, {'end': 18899.434, 'text': 'Then we have box plot.', 'start': 18898.113, 'duration': 1.321}, {'end': 18905.776, 'text': 'Box plot again shows distribution of continuous numeric variable, but mostly used for exploration.', 'start': 18899.674, 'duration': 6.102}, {'end': 18908.378, 'text': 'It will also highlight the outliers for you.', 'start': 18905.857, 'duration': 2.521}, {'end': 18914.92, 'text': "So it'll point out each and every individual data point on a particular box plot.", 'start': 18909.418, 'duration': 5.502}], 'summary': 'Histogram and box plot display distribution of earnings and identify outliers.', 'duration': 30.471, 'max_score': 18884.449, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18884449.jpg'}, {'end': 18974.757, 'src': 'embed', 'start': 18949.85, 'weight': 6, 'content': [{'end': 18955.652, 'text': 'It contains details of different functions which are available within Tableau and with examples, certain examples.', 'start': 18949.85, 'duration': 5.802}, {'end': 18957.853, 'text': "It's not very detailed as such.", 'start': 18956.172, 'duration': 1.681}, {'end': 18963.495, 'text': "Each of the functions is not explained through rigorous examples as such, but it's a good reference.", 'start': 18958.013, 'duration': 5.482}, {'end': 18967.093, 'text': 'So we have numeric functions, string function, date function.', 'start': 18964.471, 'duration': 2.622}, {'end': 18968.293, 'text': "Let's explore date functions.", 'start': 18967.113, 'duration': 1.18}, {'end': 18974.757, 'text': 'Within date functions, we have date diff, date add, example here, date diff, example.', 'start': 18968.974, 'duration': 5.783}], 'summary': 'The transcript covers tableau functions including numeric, string, and date functions, with examples.', 'duration': 24.907, 'max_score': 18949.85, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18949850.jpg'}, {'end': 19042.139, 'src': 'embed', 'start': 19015.603, 'weight': 8, 'content': [{'end': 19020.065, 'text': 'Some functions, like lookup functions, are available in Tableau to some extent, not a great extent.', 'start': 19015.603, 'duration': 4.462}, {'end': 19026.05, 'text': 'LOD calculations, we are going to talk about LOD calculations.', 'start': 19021.708, 'duration': 4.342}, {'end': 19033.514, 'text': 'They are not going to be described here in Excel because this is a particular feature of Tableau.', 'start': 19026.511, 'duration': 7.003}, {'end': 19035.555, 'text': "It's not a feature of Excel.", 'start': 19033.894, 'duration': 1.661}, {'end': 19039.957, 'text': "And it's a pretty recent feature, LOD functions.", 'start': 19036.756, 'duration': 3.201}, {'end': 19042.139, 'text': 'It was introduced in version nine only.', 'start': 19040.458, 'duration': 1.681}], 'summary': 'Tableau offers limited lookup functions, lod calculations introduced in version nine.', 'duration': 26.536, 'max_score': 19015.603, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So19015603.jpg'}, {'end': 19171.288, 'src': 'embed', 'start': 19141.63, 'weight': 7, 'content': [{'end': 19145.132, 'text': 'So you have to take certain steps to generate this.', 'start': 19141.63, 'duration': 3.502}, {'end': 19146.353, 'text': 'We have donut charts.', 'start': 19145.512, 'duration': 0.841}, {'end': 19149.735, 'text': "Again, it's not available in Tableau.", 'start': 19148.314, 'duration': 1.421}, {'end': 19151.897, 'text': 'Donut chart, it looks something like this.', 'start': 19150.356, 'duration': 1.541}, {'end': 19156.981, 'text': 'All these charts can be created in Tableau, and there are workarounds available.', 'start': 19153.578, 'duration': 3.403}, {'end': 19159.082, 'text': 'You can create infographics.', 'start': 19157.161, 'duration': 1.921}, {'end': 19166.408, 'text': 'What are infographics? Infographics are like these jazzy graphics which are published in magazines and all.', 'start': 19159.563, 'duration': 6.845}, {'end': 19171.288, 'text': 'These are infographics, all right? These are infographics.', 'start': 19167.449, 'duration': 3.839}], 'summary': 'Tableau offers workarounds for creating donut charts and infographics.', 'duration': 29.658, 'max_score': 19141.63, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So19141630.jpg'}], 'start': 18703.035, 'title': 'Types of charts and tableau formulas', 'summary': 'Covers widely used chart types and their best uses, including bar graphs, line charts, pie charts, scatter plots, histograms, and box plots, with guidelines and examples. it also discusses tableau formulas, workarounds, numeric, string, and date functions, and provides insights on lod calculations.', 'chapters': [{'end': 18929.883, 'start': 18703.035, 'title': 'Types of charts and their best uses', 'summary': 'Discusses the widely used charts such as bar graph, line chart, pie chart, scatter plot, histogram, and box plot, providing guidelines on when to use each type based on the nature of the data and its relevance, with examples and best practices.', 'duration': 226.848, 'highlights': ['Bar chart is used for comparing categorical data, such as male vs. female salary or the number of male vs. female employees.', 'Line chart is used to show trends over time, for instance, tracking sales performance over a period.', 'Pie chart is employed to display percentage contributions, typically for showing the distribution of different components that contribute to 100%.', 'Scatter plot is utilized to explore the relationship between two continuous numeric variables, like salary vs. age or experience vs. salary.', 'Histogram is used to illustrate the distribution of a continuous numeric variable, providing insights into the frequency of specific ranges, useful for analyzing data such as passenger weight in an airline.', 'Box plot is employed for exploring the distribution of continuous numeric variables and identifying outliers, although it requires careful explanation due to its complexity and less common understanding.']}, {'end': 19470.095, 'start': 18930.283, 'title': 'Tableau formulas and workarounds', 'summary': 'Discusses tableau formulas, including numeric, string, and date functions, and suggests a reference guide for excel formulas. it also covers different workarounds in tableau, such as creating custom charts and infographics, and provides insights on lod calculations.', 'duration': 539.812, 'highlights': ['The chapter covers different functions available within Tableau, such as numeric, string, and date functions, with examples, and suggests a reference guide for Excel formulas.', 'It discusses various workarounds in Tableau, including creating custom charts such as 100% stacked bar charts and donut charts, and infographics, as well as overlaying charts on geospatial maps.', 'The chapter provides insights into LOD calculations, explaining the introduction of LOD functions in Tableau 9.0 and the use of level of detail expressions to address the problem of mixing aggregate and non-aggregate functions.']}], 'duration': 767.06, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So18703035.jpg', 'highlights': ['Bar chart is used for comparing categorical data, such as male vs. female salary or the number of male vs. female employees.', 'Line chart is used to show trends over time, for instance, tracking sales performance over a period.', 'Pie chart is employed to display percentage contributions, typically for showing the distribution of different components that contribute to 100%.', 'Scatter plot is utilized to explore the relationship between two continuous numeric variables, like salary vs. age or experience vs. salary.', 'Histogram is used to illustrate the distribution of a continuous numeric variable, providing insights into the frequency of specific ranges, useful for analyzing data such as passenger weight in an airline.', 'Box plot is employed for exploring the distribution of continuous numeric variables and identifying outliers, although it requires careful explanation due to its complexity and less common understanding.', 'The chapter covers different functions available within Tableau, such as numeric, string, and date functions, with examples, and suggests a reference guide for Excel formulas.', 'It discusses various workarounds in Tableau, including creating custom charts such as 100% stacked bar charts and donut charts, and infographics, as well as overlaying charts on geospatial maps.', 'The chapter provides insights into LOD calculations, explaining the introduction of LOD functions in Tableau 9.0 and the use of level of detail expressions to address the problem of mixing aggregate and non-aggregate functions.']}, {'end': 20668.331, 'segs': [{'end': 19515.81, 'src': 'embed', 'start': 19489.678, 'weight': 0, 'content': [{'end': 19495.341, 'text': "It's a way in which Tableau will extract the data, keep it aside, optimize it for faster performance.", 'start': 19489.678, 'duration': 5.663}, {'end': 19501.644, 'text': 'There are certain formulas, additional formulas, which becomes available when you create an extract.', 'start': 19495.741, 'duration': 5.903}, {'end': 19503.184, 'text': 'So for example, COUNTD formula.', 'start': 19501.664, 'duration': 1.52}, {'end': 19504.065, 'text': "There's a typo here.", 'start': 19503.204, 'duration': 0.861}, {'end': 19506.806, 'text': 'It should be COUNTD, not COUNTED formula.', 'start': 19504.465, 'duration': 2.341}, {'end': 19508.207, 'text': 'It should be COUNTD formula.', 'start': 19506.826, 'duration': 1.381}, {'end': 19511.348, 'text': "And I'm talking about earlier versions of Tableau.", 'start': 19508.907, 'duration': 2.441}, {'end': 19515.81, 'text': "I'm not sure if it's available by default in Tableau 9.0 and above.", 'start': 19511.368, 'duration': 4.442}], 'summary': 'Tableau extracts optimize data for faster performance, offering additional formulas like countd.', 'duration': 26.132, 'max_score': 19489.678, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So19489678.jpg'}, {'end': 19559.689, 'src': 'embed', 'start': 19532.25, 'weight': 1, 'content': [{'end': 19539.174, 'text': 'If you make a live connection, data changes, your Tableau report changes if you have scheduled the refresh.', 'start': 19532.25, 'duration': 6.924}, {'end': 19543.457, 'text': 'In extract, you can control the refresh, allow users to refresh the data.', 'start': 19539.775, 'duration': 3.682}, {'end': 19544.845, 'text': 'based on their preference.', 'start': 19543.965, 'duration': 0.88}, {'end': 19546.666, 'text': 'Or you can schedule it also if you want to.', 'start': 19545.065, 'duration': 1.601}, {'end': 19551.067, 'text': "So there's a lot of control which you get on data refresh by using extract.", 'start': 19547.146, 'duration': 3.921}, {'end': 19554.748, 'text': 'Good feature especially improves the performance.', 'start': 19552.667, 'duration': 2.081}, {'end': 19559.689, 'text': 'How to refresh your visualization from your desktop environment.', 'start': 19556.168, 'duration': 3.521}], 'summary': 'Tableau extracts offer control over data refresh, enhancing performance and user convenience.', 'duration': 27.439, 'max_score': 19532.25, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So19532250.jpg'}, {'end': 19719.464, 'src': 'embed', 'start': 19686.748, 'weight': 2, 'content': [{'end': 19688.149, 'text': 'So this is again a common question.', 'start': 19686.748, 'duration': 1.401}, {'end': 19692.574, 'text': 'People may ask you, what is normal filter? What is quick filter? And then we have context filter.', 'start': 19688.25, 'duration': 4.324}, {'end': 19694.936, 'text': 'Context filter is when.', 'start': 19692.934, 'duration': 2.002}, {'end': 19700.799, 'text': 'So what happens in Tableau is when you are applying normal filter or quick filter.', 'start': 19695.997, 'duration': 4.802}, {'end': 19702.679, 'text': 'they are going to be independent of each other.', 'start': 19700.799, 'duration': 1.88}, {'end': 19706.1, 'text': "Let's say you have, again, HR data set.", 'start': 19703.299, 'duration': 2.801}, {'end': 19710.842, 'text': 'You are going to filter data based on gender.', 'start': 19706.62, 'duration': 4.222}, {'end': 19714.743, 'text': 'So you have applied a filter on female employees.', 'start': 19712.062, 'duration': 2.681}, {'end': 19719.464, 'text': 'Then you want to filter data based on geographical location.', 'start': 19715.463, 'duration': 4.001}], 'summary': 'In tableau, normal and quick filters are independent, while context filters can be combined. for example, filtering hr data by gender and location.', 'duration': 32.716, 'max_score': 19686.748, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So19686748.jpg'}, {'end': 20066.892, 'src': 'embed', 'start': 20039.961, 'weight': 3, 'content': [{'end': 20045.925, 'text': 'What are the difference between groups and set? Difference between group and set can be a bit confusing for some people.', 'start': 20039.961, 'duration': 5.964}, {'end': 20052.349, 'text': 'Actually, you know, you can improvise the functionality and make them, behave similar to each other.', 'start': 20046.205, 'duration': 6.144}, {'end': 20059.01, 'text': 'But essentially, groups is something when you club members, individual members together into a group.', 'start': 20052.749, 'duration': 6.261}, {'end': 20063.831, 'text': 'Set on the other hand will create an in and out sort of a feature for you.', 'start': 20059.15, 'duration': 4.681}, {'end': 20066.892, 'text': 'So for example, we have job title.', 'start': 20063.871, 'duration': 3.021}], 'summary': 'Groups are for clubbing members, sets offer in and out features.', 'duration': 26.931, 'max_score': 20039.961, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So20039961.jpg'}, {'end': 20312.858, 'src': 'embed', 'start': 20287.448, 'weight': 4, 'content': [{'end': 20292.27, 'text': 'Blend is used when you are getting data from different data sources.', 'start': 20287.448, 'duration': 4.822}, {'end': 20297.313, 'text': 'And joining is when you are getting data from same single source.', 'start': 20293.591, 'duration': 3.722}, {'end': 20299.715, 'text': 'So for example, all data coming from same Excel file.', 'start': 20297.333, 'duration': 2.382}, {'end': 20301.676, 'text': 'All data coming from CSV files.', 'start': 20300.035, 'duration': 1.641}, {'end': 20303.157, 'text': 'You use joins.', 'start': 20302.076, 'duration': 1.081}, {'end': 20305.078, 'text': 'One data is coming from CSV.', 'start': 20303.777, 'duration': 1.301}, {'end': 20307.139, 'text': 'Another data is coming from Excel.', 'start': 20305.218, 'duration': 1.921}, {'end': 20308.96, 'text': 'Another data is coming from Oracle.', 'start': 20307.6, 'duration': 1.36}, {'end': 20309.721, 'text': 'You use blending.', 'start': 20308.98, 'duration': 0.741}, {'end': 20312.858, 'text': "If you're given a choice, always go for join.", 'start': 20311.017, 'duration': 1.841}], 'summary': 'Blend for different sources, join for single source. prefer join if given a choice.', 'duration': 25.41, 'max_score': 20287.448, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So20287448.jpg'}], 'start': 19471.015, 'title': 'Tableau features and techniques', 'summary': 'Covers tableau extracts, including improved performance and additional formulas, differences between quick filter, normal filter, and context filter, and the distinctions between groups and sets in analytics. it also explains the usage of page shelf and motion charts, and the distinctions between join and blending in tableau.', 'chapters': [{'end': 19640.398, 'start': 19471.015, 'title': 'Tableau level of detail and extracts', 'summary': 'Covers the benefits of tableau extracts, including improved performance, availability of additional formulas such as countd, and better data refresh control, along with insights on data visualization techniques and its competitive advantages.', 'duration': 169.383, 'highlights': ['Tableau extracts improve dashboard performance by optimizing data for faster processing, and they provide access to additional formulas such as COUNTD, which is not available by default in live connections (Relevance: 5)', 'Using extracts allows control over data refresh, enabling users to refresh data based on preference or schedule, providing significant data management advantages (Relevance: 4)', 'Data visualization techniques allow for intuitive presentation of information, making data a competitive advantage and enhancing user-friendliness through visual representation (Relevance: 3)']}, {'end': 20038.961, 'start': 19640.999, 'title': 'Data visualization techniques', 'summary': 'Covers the differences between quick filter, normal filter, and context filter in tableau, the drawbacks of normal filters, and the use cases of context filters and data blending, as well as the distinctions between twb and twbx files.', 'duration': 397.962, 'highlights': ['The chapter focuses on the differences between quick filter, normal filter, and context filter in Tableau, highlighting their functionalities and use cases.', 'It discusses the drawbacks of normal filters, explaining how applying multiple normal filters starts from scratch for each filter and the potential impact on data visualization.', 'The use cases of context filters and data blending are explained, emphasizing their effectiveness in speeding up dashboards, handling top end values, and combining data from different sources.', 'The distinctions between TWB and TWBX files are outlined, clarifying that TWB contains instructions for Tableau to draw visualizations, while TWBX is a packaged workbook containing data and images in a zip file.']}, {'end': 20668.331, 'start': 20039.961, 'title': 'Groups vs sets in analytics', 'summary': 'Explains the differences between groups and sets in analytics, including their functionalities, creation process, and use cases, emphasizing the ability to improvise and use them together with formulas. additionally, it covers the usage of page shelf and motion charts, and the distinctions between join and blending in tableau, with a preference for joins over blending.', 'duration': 628.37, 'highlights': ['The difference between groups and sets lies in their functionalities, with groups clubbing individual members together into a group, while sets create an in and out sort of feature, enabling the creation of conditions and filters.', 'Page shelf in Tableau allows the creation of animation-like features by analyzing data and creating different pages of different situations, facilitating the visualization of trends and comparisons across different departments.', 'Joining is preferred when obtaining data from the same single source, while blending is used for data from different sources, with a recommendation to opt for join for its intuitive and centralized nature.', 'Data blending in Tableau allows bringing fields from different data sources together in one single view without changing the data, enabling innovative comparisons and aggregations, although it may require logical adjustments and creativity.', 'Blended axis in Tableau allows measures to share a single axis, creating a unified view of all marks on a single pane, and the possibility to blend the axes of different measures for synchronization and comparison.']}], 'duration': 1197.316, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So19471015.jpg', 'highlights': ['Tableau extracts improve dashboard performance and provide access to additional formulas like COUNTD (Relevance: 5)', 'Using extracts allows control over data refresh, enabling users to refresh data based on preference or schedule (Relevance: 4)', 'The chapter focuses on the differences between quick filter, normal filter, and context filter in Tableau (Relevance: 3)', 'The difference between groups and sets lies in their functionalities, with groups clubbing individual members together into a group, while sets create an in and out sort of feature (Relevance: 2)', 'Joining is preferred when obtaining data from the same single source, while blending is used for data from different sources (Relevance: 1)']}, {'end': 21601.97, 'segs': [{'end': 20738.079, 'src': 'embed', 'start': 20714.154, 'weight': 1, 'content': [{'end': 20720.859, 'text': "Let's say we're talking about HR dashboard, HR workforce analysis we have done of a company.", 'start': 20714.154, 'duration': 6.705}, {'end': 20727.051, 'text': 'First point you would like to say this is the workforce profile of our company.', 'start': 20722.02, 'duration': 5.031}, {'end': 20733.256, 'text': 'These many male employees are there, these many female employees are there, these are different employees working in these different grades.', 'start': 20727.371, 'duration': 5.885}, {'end': 20738.079, 'text': 'So you will create your first storyline, which is, this is our HR profile.', 'start': 20733.656, 'duration': 4.423}], 'summary': 'Hr dashboard presents workforce profile, gender distribution, and employee grades.', 'duration': 23.925, 'max_score': 20714.154, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So20714154.jpg'}, {'end': 20847.76, 'src': 'embed', 'start': 20801.461, 'weight': 0, 'content': [{'end': 20811.448, 'text': "It's like those slide shows which are available on Yahoo and different websites, where you click on that arrow and it takes you to the next picture.", 'start': 20801.461, 'duration': 9.987}, {'end': 20816.171, 'text': 'maybe some Bollywood story or some fancy story they want to share with you.', 'start': 20811.448, 'duration': 4.723}, {'end': 20819.343, 'text': 'Similarly, you can create a story in Tableau as well.', 'start': 20816.451, 'duration': 2.892}, {'end': 20822.625, 'text': 'Make sense? So these are story points.', 'start': 20819.803, 'duration': 2.822}, {'end': 20828.69, 'text': "And what is the difference between discrete and continuous in Tableau? It's actually a consistent difference.", 'start': 20823.006, 'duration': 5.684}, {'end': 20833.774, 'text': "It's like part of all around analysis, not just in terms of Tableau.", 'start': 20828.97, 'duration': 4.804}, {'end': 20840.86, 'text': 'What is discrete and what is continuous? Discrete is something which has limited number of values.', 'start': 20833.874, 'duration': 6.986}, {'end': 20847.76, 'text': 'Discrete values are counted as distinct and separate and can take individual values within a range.', 'start': 20841.477, 'duration': 6.283}], 'summary': 'Tableau allows creating interactive story points; discrete values are limited, continuous values are not.', 'duration': 46.299, 'max_score': 20801.461, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So20801461.jpg'}, {'end': 21030.281, 'src': 'embed', 'start': 20999.281, 'weight': 8, 'content': [{'end': 21001.322, 'text': "So for example here, I've done some data blending.", 'start': 20999.281, 'duration': 2.041}, {'end': 21004.683, 'text': "I've got two data sources here, if you remember.", 'start': 21001.782, 'duration': 2.901}, {'end': 21006.424, 'text': 'Two data sources, this and this.', 'start': 21005.223, 'duration': 1.201}, {'end': 21008.825, 'text': 'I go to data, edit relationship.', 'start': 21006.804, 'duration': 2.021}, {'end': 21011.929, 'text': 'one data source to second data source.', 'start': 21009.867, 'duration': 2.062}, {'end': 21015.951, 'text': 'You can define a custom relationship also if you want to or let it be automatic.', 'start': 21011.989, 'duration': 3.962}, {'end': 21019.654, 'text': 'Custom, I do not want my blending to be done on rating.', 'start': 21016.252, 'duration': 3.402}, {'end': 21027.019, 'text': "I just want it to be done on employee ID and then say okay, I'm sorry, this sheet 13.", 'start': 21019.694, 'duration': 7.325}, {'end': 21030.281, 'text': 'Data, edit relationship, this is what you want.', 'start': 21027.019, 'duration': 3.262}], 'summary': 'Data blending with two sources, custom relationship on employee id, sheet 13.', 'duration': 31, 'max_score': 20999.281, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So20999281.jpg'}, {'end': 21119.406, 'src': 'embed', 'start': 21092.862, 'weight': 3, 'content': [{'end': 21098.664, 'text': "I don't know if this might be a very relevant question for a Tableau developer, but yeah.", 'start': 21092.862, 'duration': 5.802}, {'end': 21106.247, 'text': 'How do you publish Tableau reports to Tableau server? To publish a report, go to server, choose this publish workbook option.', 'start': 21098.704, 'duration': 7.543}, {'end': 21110.408, 'text': 'It will ask you for your credentials, and you have to provide your credentials.', 'start': 21106.667, 'duration': 3.741}, {'end': 21112.209, 'text': 'You need to have access to a Tableau server.', 'start': 21110.448, 'duration': 1.761}, {'end': 21119.406, 'text': 'Okay, so first you need to probably click on this, sign in, provide your credentials, then choose publish workbook.', 'start': 21112.802, 'duration': 6.604}], 'summary': 'To publish tableau reports to tableau server, go to server, choose publish workbook, sign in, and provide credentials.', 'duration': 26.544, 'max_score': 21092.862, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So21092862.jpg'}, {'end': 21183.851, 'src': 'embed', 'start': 21155.702, 'weight': 5, 'content': [{'end': 21158.444, 'text': "It's very simple, all menu driven, very easy thing.", 'start': 21155.702, 'duration': 2.742}, {'end': 21161.792, 'text': "Define parameters in Tableau and they're working.", 'start': 21159.77, 'duration': 2.022}, {'end': 21164.215, 'text': 'Tableau parameters are defined variables values.', 'start': 21161.852, 'duration': 2.363}, {'end': 21173.984, 'text': 'What are parameters? Parameters are a way to accept inputs from your user and let them interact with your dashboard.', 'start': 21164.835, 'duration': 9.149}, {'end': 21181.268, 'text': 'You can place parameter controls onto your dashboard Users can pass on values through those parameters.', 'start': 21174.605, 'duration': 6.663}, {'end': 21183.851, 'text': 'You can use those values in calculation and filters.', 'start': 21181.348, 'duration': 2.503}], 'summary': 'Using tableau parameters allows user interaction and input for calculations and filters.', 'duration': 28.149, 'max_score': 21155.702, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So21155702.jpg'}, {'end': 21248.532, 'src': 'embed', 'start': 21204.658, 'weight': 4, 'content': [{'end': 21207.303, 'text': 'What are the difference between Tableau Desktop and Tableau Server?', 'start': 21204.658, 'duration': 2.645}, {'end': 21213.472, 'text': 'Tableau Desktop helps you create data visualization, workbook creation these kind of things it will help you do.', 'start': 21207.483, 'duration': 5.989}, {'end': 21218.672, 'text': 'Tableau Server is used to distribute these workbook to the end user.', 'start': 21213.773, 'duration': 4.899}, {'end': 21220.674, 'text': 'These workbook can be interactive.', 'start': 21218.732, 'duration': 1.942}, {'end': 21227.179, 'text': 'You can enable your users to apply filters, license the data pass value through parameters,', 'start': 21221.094, 'duration': 6.085}, {'end': 21231.042, 'text': 'and all of these functionality will be available through Tableau Server.', 'start': 21227.179, 'duration': 3.863}, {'end': 21232.183, 'text': 'It will be available.', 'start': 21231.423, 'duration': 0.76}, {'end': 21239.47, 'text': 'Just in case if you do not have access to Tableau Server, Does Tableau Desktop also become redundant to you? No, not at all.', 'start': 21233.024, 'duration': 6.446}, {'end': 21244.111, 'text': 'There is Tableau Reader, which you can still use for offline viewing of the file.', 'start': 21239.97, 'duration': 4.141}, {'end': 21246.911, 'text': 'So you can ask your end users to install Tableau Reader.', 'start': 21244.371, 'duration': 2.54}, {'end': 21248.532, 'text': "It doesn't involve any cost.", 'start': 21247.211, 'duration': 1.321}], 'summary': 'Tableau desktop for visualization creation, tableau server for distribution and interactivity. tableau reader for offline viewing. no cost for tableau reader.', 'duration': 43.874, 'max_score': 21204.658, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So21204658.jpg'}, {'end': 21541.742, 'src': 'embed', 'start': 21521.093, 'weight': 6, 'content': [{'end': 21530.602, 'text': 'And all of this company that you can see in front of you in the screen, they all use Tableau, starting from US Air Force to Burger King, Citibank.', 'start': 21521.093, 'duration': 9.509}, {'end': 21535.107, 'text': 'You can see these are all different companies, but they all use Tableau.', 'start': 21530.622, 'duration': 4.485}, {'end': 21541.742, 'text': 'Now these are a few of the comments made by the most influential people from a particular company.', 'start': 21535.899, 'duration': 5.843}], 'summary': 'Various companies, including us air force and burger king, use tableau for data visualization.', 'duration': 20.649, 'max_score': 21521.093, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So21521093.jpg'}], 'start': 20669.012, 'title': 'Tableau features and functionality', 'summary': "Covers tableau's story feature, discrete vs continuous data, tableau desktop vs tableau server, with examples of hr dashboard analysis, report automation, and success stories from various companies like us air force, burger king, and citibank.", 'chapters': [{'end': 20822.625, 'start': 20669.012, 'title': 'Tableau story feature', 'summary': 'Introduces the tableau story feature, a way to present findings in a step-by-step manner, allowing for a guided tour for users, with examples of an hr dashboard analysis and its various story points.', 'duration': 153.613, 'highlights': ['Tableau story feature allows for presenting findings in a step-by-step manner, guiding users through a sequence of worksheets and dashboards.', 'Example of an HR dashboard analysis is provided, with story points including workforce profile, gender bias comparison, identifying departments with gender bias, reasons for bias, and the impact on revenue and absenteeism.', 'The story feature in Tableau is compared to slide shows available on Yahoo and other websites, providing a guided tour similar to those slide shows.']}, {'end': 21204.558, 'start': 20823.006, 'title': 'Tableau: discrete vs continuous data', 'summary': 'Explains the difference between discrete and continuous data in tableau, including examples and uses, as well as demonstrating how to automate reports, blend database and flat file data, publish reports to tableau server, and define parameters.', 'duration': 381.552, 'highlights': ['The difference between discrete and continuous data in Tableau is explained with examples, such as discrete values like customer names and continuous values like age and height.', 'Automating reports in Tableau involves creating a dashboard, publishing it to Tableau Server, and scheduling the report refresh based on specific time intervals, enabling users to see new information automatically.', 'Data blending in Tableau involves pulling data from different sources, defining relationships, and analyzing the blended data, with the option to define custom relationships and perform analysis.', 'Tableau Server can run on Windows and Mac platforms, and publishing reports to Tableau Server involves signing in, providing credentials, choosing the workbook to publish, and setting user permissions.', 'Tableau parameters allow users to interact with dashboards by accepting inputs, passing values through parameters, and using those values in calculations and filters, providing user control and dynamic functionality.']}, {'end': 21601.97, 'start': 21204.658, 'title': 'Tableau desktop vs tableau server', 'summary': 'Explains the differences between tableau desktop and tableau server, including their functionalities, the availability of tableau reader for offline viewing, and the success stories of tableau, with examples from companies like us air force, burger king, and citibank.', 'duration': 397.312, 'highlights': ['Tableau Server is used to distribute interactive workbooks to end users, enabling them to apply filters and use all functionality, while Tableau Desktop helps in creating data visualizations and workbooks.', 'Tableau Reader can be used for offline viewing of files and does not involve any cost, allowing end users to interact with the data but not create new charts or formulas.', 'Companies like US Air Force, Burger King, and Citibank have experienced success with Tableau, as mentioned by influential individuals from these organizations, showing direct impacts such as reduced time spent on activities and increased sales.']}], 'duration': 932.958, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aHaOIvR00So/pics/aHaOIvR00So20669012.jpg', 'highlights': ['Tableau story feature allows for presenting findings in a step-by-step manner', 'Example of an HR dashboard analysis is provided, with story points including workforce profile', 'The difference between discrete and continuous data in Tableau is explained with examples', 'Automating reports in Tableau involves creating a dashboard, publishing it to Tableau Server', 'Tableau Server is used to distribute interactive workbooks to end users', 'Tableau parameters allow users to interact with dashboards by accepting inputs', 'Companies like US Air Force, Burger King, and Citibank have experienced success with Tableau', 'The story feature in Tableau is compared to slide shows available on Yahoo and other websites', 'Data blending in Tableau involves pulling data from different sources, defining relationships', 'Tableau Server can run on Windows and Mac platforms, and publishing reports to Tableau Server involves signing in', 'Tableau Desktop helps in creating data visualizations and workbooks', 'Tableau Reader can be used for offline viewing of files and does not involve any cost']}], 'highlights': ['Tableau professionals receive an average salary of $91,000 per annum and there is a high demand for Tableau experts on job portals like Indeed and AngelList.', "Tableau's wide range of connectivity options allows it to connect to any data source, including spreadsheets, databases, big data, cloud applications like Salesforce, and cloud databases like Amazon Redshift.", "Tableau has been consistently positioned as a leader in Gartner's Magic Quadrant, demonstrating its strong ability to execute and completeness of vision, making it a top contender in the BI tools market.", "Tableau's in-memory BI platform enables high scalability and rapid visualization, allowing users to work with large chunks of data efficiently, while QlikView lacks ETL tools and has constraints in handling big data, indicating Tableau's superiority in data handling capabilities.", 'The impact of browser choice on report retrieval time: Internet Explorer 7 took 11 seconds, while Firefox took 3 seconds, demonstrating the substantial difference in performance (quantifiable data).', 'Optimizing performance by revisiting visualizations to remove unused fields, utilizing features like hierarchy and context filters, and involving business people in dashboard design', 'Tableau extracts improve dashboard performance and provide access to additional formulas like COUNTD', 'Using extracts allows control over data refresh, enabling users to refresh data based on preference or schedule', 'The chapter focuses on the differences between quick filter, normal filter, and context filter in Tableau', 'The difference between groups and sets lies in their functionalities, with groups clubbing individual members together into a group, while sets create an in and out sort of feature']}