title
Data Analyst Portfolio Project | Tableau Visualization | Project 2/4

description
Today we continue our Data Analyst Portfolio Project Series. In this project we will be taking some of the SQL queries we worked on in the first project and creating visualizations in Tableau. LINKS: First Portfolio Project: https://www.youtube.com/watch?v=qfyynHBFOsM Download Tableau: https://public.tableau.com/en-us/s/download Alex The Analyst Public Portfolio: https://public.tableau.com/profile/alexander.freberg#!/ SQL Queries for Tableau Project: https://github.com/AlexTheAnalyst/PortfolioProjects/blob/main/Tableau%20Portfolio%20Project%20SQL%20Queries.sql ____________________________________________ SUBSCRIBE! Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content! ____________________________________________ RESOURCES: Coursera Courses: Google Data Analyst Certification: https://coursera.pxf.io/5bBd62 Data Analysis with Python - https://coursera.pxf.io/BXY3Wy IBM Data Analysis Specialization - https://coursera.pxf.io/AoYOdR Tableau Data Visualization - https://coursera.pxf.io/MXYqaN Udemy Courses: Python for Data Analysis and Visualization- https://bit.ly/3hhX4LX Statistics for Data Science - https://bit.ly/37jqDbq SQL for Data Analysts (SSMS) - https://bit.ly/3fkqEij Tableau A-Z - http://bit.ly/385lYvN *Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!* ____________________________________________ SUPPORT MY CHANNEL - PATREON/MERCH Patreon Page - https://www.patreon.com/AlexTheAnalyst Alex The Analyst Shop - https://teespring.com/stores/alex-the-analyst-shop ____________________________________________ Websites: GitHub: https://github.com/AlexTheAnalyst ____________________________________________ *All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for* 0:00 Introduction 0:55 Downloading Tableau 2:44 Getting Data from SQL 9:05 Importing Data into Tableau 10:41 Building Our Visualizations 43:30 Building Our Dashboard 48:45 How to Share Dashboard

detail
{'title': 'Data Analyst Portfolio Project | Tableau Visualization | Project 2/4', 'heatmap': [{'end': 818.885, 'start': 783.899, 'weight': 0.873}, {'end': 1256.459, 'start': 1221.481, 'weight': 0.779}, {'end': 2667.041, 'start': 2604.331, 'weight': 1}], 'summary': "Covers tableau projects, data management in excel and tableau, data visualization, dashboard formatting, map creation, time series data analysis, and creating tableau dashboards, emphasizing beginner-friendly techniques achievable in under an hour and a half, handling nulls in tableau data, and the impact on one's career by creating advanced dashboards.", 'chapters': [{'end': 248.28, 'segs': [{'end': 78.274, 'src': 'embed', 'start': 25.228, 'weight': 0, 'content': [{'end': 27.568, 'text': "And so I'll leave a link in the description if you want to do that.", 'start': 25.228, 'duration': 2.34}, {'end': 30.909, 'text': 'This project is all about creating visualizations in Tableau.', 'start': 27.928, 'duration': 2.981}, {'end': 33.11, 'text': "So we're going to create multiple visualizations.", 'start': 30.929, 'duration': 2.181}, {'end': 37.351, 'text': "We'll combine all of those to create our dashboard, and then we can share that dashboard.", 'start': 33.15, 'duration': 4.201}, {'end': 40.892, 'text': 'And you can put that on your resume, in your portfolio, or on your LinkedIn.', 'start': 37.651, 'duration': 3.241}, {'end': 45.157, 'text': 'I want to mention once again, I tried to make this as beginner friendly as I possibly could.', 'start': 41.272, 'duration': 3.885}, {'end': 52.065, 'text': 'So if you have no experience with Tableau at all, you should still be able to do this portfolio project and add it to your portfolio.', 'start': 45.557, 'duration': 6.508}, {'end': 55.269, 'text': "Without further ado, let's jump over to my screen and get started on the project.", 'start': 52.285, 'duration': 2.984}, {'end': 56.67, 'text': "So let's start the project.", 'start': 55.489, 'duration': 1.181}, {'end': 60.335, 'text': 'And the very first thing that we need to do is download Tableau Public.', 'start': 56.831, 'duration': 3.504}, {'end': 64.669, 'text': 'All you have to do is go to the link that I will leave in the description below.', 'start': 61.328, 'duration': 3.341}, {'end': 69.051, 'text': 'All you have to do is go in here, put in your email, click download the app.', 'start': 65.328, 'duration': 3.723}, {'end': 74.552, 'text': "Of course, I've already downloaded it and I checked multiple times and it works.", 'start': 69.811, 'duration': 4.741}, {'end': 78.274, 'text': 'Then you just go through the process to actually create an account.', 'start': 75.473, 'duration': 2.801}], 'summary': 'Create tableau visualizations, dashboard, and portfolio project for beginners.', 'duration': 53.046, 'max_score': 25.228, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ25228.jpg'}, {'end': 128.6, 'src': 'embed', 'start': 103.545, 'weight': 1, 'content': [{'end': 114.992, 'text': 'This is supposed to be more of a roadmap to how to get started, how to create your first dashboard, whether it is very simple like mine,', 'start': 103.545, 'duration': 11.447}, {'end': 119.135, 'text': 'which I would consider this pretty simple, one that I think we can do in under an hour and a half.', 'start': 114.992, 'duration': 4.143}, {'end': 128.6, 'text': 'Whereas I tried earlier to do one and I recorded for about three hours, and it was what I would consider much.', 'start': 120.453, 'duration': 8.147}], 'summary': 'A roadmap on creating a simple dashboard in under an hour and a half.', 'duration': 25.055, 'max_score': 103.545, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ103545.jpg'}, {'end': 226.508, 'src': 'embed', 'start': 186.021, 'weight': 2, 'content': [{'end': 188.203, 'text': 'Sometimes you download it for Excel for different reasons.', 'start': 186.021, 'duration': 2.182}, {'end': 190.865, 'text': "But we can't do that.", 'start': 189.544, 'duration': 1.321}, {'end': 192.807, 'text': "We're going to be using Excel for this.", 'start': 190.925, 'duration': 1.882}, {'end': 199.737, 'text': "So what I've done is I've created these queries used for Tableau project, and I've already saved this query.", 'start': 193.553, 'duration': 6.184}, {'end': 202.939, 'text': "I'm going to put it in the description so you have it.", 'start': 199.757, 'duration': 3.182}, {'end': 208.017, 'text': 'Um, I tweaked again, I went through and I tweaked some of the scripts that we worked through.', 'start': 203.715, 'duration': 4.302}, {'end': 209.338, 'text': "Um, it's very similar.", 'start': 208.038, 'duration': 1.3}, {'end': 213.361, 'text': "If you notice it's very, very similar to what we worked on in the first project.", 'start': 209.378, 'duration': 3.983}, {'end': 214.721, 'text': 'I tweaked them.', 'start': 214.181, 'duration': 0.54}, {'end': 215.602, 'text': 'These are the first four.', 'start': 214.881, 'duration': 0.721}, {'end': 219.484, 'text': "These are the only four visualizations we're gonna be doing nothing crazy.", 'start': 215.622, 'duration': 3.862}, {'end': 226.508, 'text': 'I promise you originally, and I kept the original queries in here in case you were curious and wanted to look at them and try to use them.', 'start': 219.564, 'duration': 6.944}], 'summary': 'Creating queries for tableau project, with four visualizations.', 'duration': 40.487, 'max_score': 186.021, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ186021.jpg'}], 'start': 0.169, 'title': 'Tableau projects', 'summary': 'Covers creating visualizations and building a dashboard using tableau, suitable for beginners, with the process achievable in under an hour and a half, and discussions on simplifying tableau projects for improved efficiency and learning experience.', 'chapters': [{'end': 102.905, 'start': 0.169, 'title': 'Tableau portfolio project', 'summary': 'Covers the second portfolio project in tableau, focusing on creating visualizations and building a dashboard using tableau public, which can be added to a resume, portfolio, or linkedin profile, suitable for beginners with no prior tableau experience.', 'duration': 102.736, 'highlights': ['The project involves creating multiple visualizations, combining them to form a dashboard, and sharing it, suitable for beginners with no experience in Tableau.', 'To start the project, the first step is to download Tableau Public by visiting the provided link, entering the email, and creating an account.', 'The project is designed to be beginner-friendly, allowing individuals with no Tableau experience to add it to their portfolio or resume.']}, {'end': 145.012, 'start': 103.545, 'title': 'Creating your first dashboard', 'summary': 'Discusses the process of creating a simple dashboard, achievable in under an hour and a half, after streamlining a more advanced, complex version that took about three hours to create.', 'duration': 41.467, 'highlights': ['The process involves creating a simple dashboard that can be completed in under an hour and a half, after streamlining a more advanced, complex version.', 'The initial attempt at creating a more advanced dashboard took about three hours, but was considered too complex and not very helpful.', 'The streamlined dashboard is described as simple and more accessible for a lot of people.']}, {'end': 248.28, 'start': 145.432, 'title': 'Tableau project simplification', 'summary': 'Discusses simplifying a tableau project by creating and saving queries for visualizations, reducing the number of visualizations from seven to four, and the benefits of trimming down the content for improved efficiency and learning experience.', 'duration': 102.848, 'highlights': ['The chapter discusses simplifying a Tableau project by creating and saving queries for visualizations.', 'Reducing the number of visualizations from seven to four for improved efficiency and learning experience.', 'The benefits of trimming down the content for improved efficiency and learning experience.']}], 'duration': 248.111, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ169.jpg', 'highlights': ['The project involves creating multiple visualizations, combining them to form a dashboard, and sharing it, suitable for beginners with no experience in Tableau.', 'The process involves creating a simple dashboard that can be completed in under an hour and a half, after streamlining a more advanced, complex version.', 'The chapter discusses simplifying a Tableau project by creating and saving queries for visualizations.', 'To start the project, the first step is to download Tableau Public by visiting the provided link, entering the email, and creating an account.', 'Reducing the number of visualizations from seven to four for improved efficiency and learning experience.', 'The project is designed to be beginner-friendly, allowing individuals with no Tableau experience to add it to their portfolio or resume.']}, {'end': 647.421, 'segs': [{'end': 276.273, 'src': 'embed', 'start': 248.32, 'weight': 0, 'content': [{'end': 252.021, 'text': "So all we're going to do is we're going to run this, let's execute it.", 'start': 248.32, 'duration': 3.701}, {'end': 258.264, 'text': "And we're going to hit up in this top left and we're going to do is control shift C.", 'start': 252.522, 'duration': 5.742}, {'end': 261.166, 'text': 'And what that does is it copies the data as well as the headers.', 'start': 258.264, 'duration': 2.902}, {'end': 263.127, 'text': "And that's, um, that's something we need.", 'start': 261.226, 'duration': 1.901}, {'end': 266.748, 'text': 'So, um, really quick, let me get out of these.', 'start': 263.767, 'duration': 2.981}, {'end': 270.27, 'text': 'This is from a previous attempt.', 'start': 266.768, 'duration': 3.502}, {'end': 276.273, 'text': "Um, let's go to Excel and we are going to insert this.", 'start': 271.451, 'duration': 4.822}], 'summary': 'The process involves executing and copying data with headers from a previous attempt into excel.', 'duration': 27.953, 'max_score': 248.32, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ248320.jpg'}, {'end': 413.537, 'src': 'embed', 'start': 382.088, 'weight': 1, 'content': [{'end': 385.948, 'text': 'If you look, I already have this sorted by highest to lowest.', 'start': 382.088, 'duration': 3.86}, {'end': 388.649, 'text': 'If we go down to the very bottom, there are these nulls here.', 'start': 385.988, 'duration': 2.661}, {'end': 390.429, 'text': "We don't want the nulls.", 'start': 388.829, 'duration': 1.6}, {'end': 397.51, 'text': "We want those to be zeros because then it will be numeric and it'll assign it a numeric data type.", 'start': 390.469, 'duration': 7.041}, {'end': 403.694, 'text': "And so what we're gonna do is we're gonna do control H And that's just habit.", 'start': 397.95, 'duration': 5.744}, {'end': 405.374, 'text': 'I almost always do that.', 'start': 404.414, 'duration': 0.96}, {'end': 413.537, 'text': "So we're gonna do null, and that just assigns it to not just one sheet, but if there's multiple sheets with nulls in it, we'll do that.", 'start': 405.634, 'duration': 7.903}], 'summary': 'Sorting data by highest to lowest, replacing nulls with zeros, and assigning numeric data type using control h.', 'duration': 31.449, 'max_score': 382.088, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ382088.jpg'}, {'end': 553.637, 'src': 'embed', 'start': 518.923, 'weight': 2, 'content': [{'end': 519.644, 'text': "No, that's fantastic.", 'start': 518.923, 'duration': 0.721}, {'end': 522.106, 'text': "Okay So we're good to go.", 'start': 519.804, 'duration': 2.302}, {'end': 526.429, 'text': 'We have, once we save this, we have our four changes.', 'start': 522.626, 'duration': 3.803}, {'end': 530.422, 'text': "I can't talk at the same time.", 'start': 529.321, 'duration': 1.101}, {'end': 535.105, 'text': "I can't talk and type Tableau table four.", 'start': 530.442, 'duration': 4.663}, {'end': 536.446, 'text': 'We have all of them ready to go.', 'start': 535.145, 'duration': 1.301}, {'end': 537.727, 'text': 'We have all of them set up.', 'start': 536.466, 'duration': 1.261}, {'end': 541.369, 'text': 'Now we need to actually get them into Tableau.', 'start': 538.287, 'duration': 3.082}, {'end': 544.591, 'text': 'And then we need to start building our visualizations.', 'start': 541.949, 'duration': 2.642}, {'end': 553.637, 'text': "So pull up Tableau with me, uh, click Microsoft Excel, and we're gonna go to table one and we're gonna open.", 'start': 544.751, 'duration': 8.886}], 'summary': 'Prepared four changes, ready to import into tableau for visualizations.', 'duration': 34.714, 'max_score': 518.923, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ518923.jpg'}], 'start': 248.32, 'title': 'Data management in excel and tableau', 'summary': "Covers manual data copy and insert process in excel, emphasizing the use of 'control shift c', and discusses handling nulls in tableau data with a step-by-step guide on replacing nulls with zeros using the 'control h' function to prevent potential data issues. it also involves cleaning and importing data into tableau, setting up multiple tables, and preparing to build visualizations.", 'chapters': [{'end': 351.628, 'start': 248.32, 'title': 'Data copy and insert process', 'summary': "Covers the process of manually copying and inserting data into excel, emphasizing the use of 'control shift c' to copy data with headers and the repetitive nature of the task.", 'duration': 103.308, 'highlights': ["The process involves manually copying data along with headers using 'control shift C' in Excel, which is highlighted as a necessary step for the task.", 'The speaker expresses the repetitive nature of the task, emphasizing the need for manual work and acknowledging that it may seem tedious.', 'The speaker emphasizes that while the process may be tedious, it is a valuable learning and bonding experience for the group, indicating a positive outlook on the task.']}, {'end': 486.496, 'start': 351.628, 'title': 'Handling nulls in tableau data', 'summary': "Discusses the importance of handling nulls in tableau data to ensure correct data type assignment and provides a step-by-step guide on replacing nulls with zeros using the 'control h' function, potentially preventing data issues in the future.", 'duration': 134.868, 'highlights': ['Tableau assigns data types to columns during data import, potentially mistaking nulls for strings. During data import, Tableau automatically assigns data types to columns and may mistake nulls for strings, leading to incorrect data type assignment.', "Demonstrates the process of replacing nulls with zeros using the 'control H' function in Tableau. Provides a step-by-step guide on using the 'control H' function in Tableau to replace nulls with zeros, ensuring correct numeric data type assignment.", 'Explains the necessity of separating data into multiple sheets in Tableau to enable proper data joining based on common attributes. Illustrates the importance of separating data into multiple sheets in Tableau to enable proper data joining based on common attributes like date, continent, or location.']}, {'end': 647.421, 'start': 486.516, 'title': 'Tableau visualization setup', 'summary': 'Involves cleaning and importing data into tableau, setting up multiple tables, and preparing to build visualizations.', 'duration': 160.905, 'highlights': ['Importing and setting up multiple tables in Tableau is demonstrated, ensuring the audience can follow along visually.', 'Cleaning and replacing null values with zero is performed on a dataset, resulting in 5,000 changes made.', 'The process of setting up four different tables in Tableau is detailed, with the speaker emphasizing the visual demonstration.', "The speaker prepares to start building visualizations, ensuring the audience's ability to track and understand the process.", 'The chapter involves cleaning and importing data into Tableau, setting up multiple tables, and preparing to build visualizations.']}], 'duration': 399.101, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ248320.jpg', 'highlights': ["The process involves manually copying data along with headers using 'control shift C' in Excel, which is highlighted as a necessary step for the task.", "Demonstrates the process of replacing nulls with zeros using the 'control H' function in Tableau. Provides a step-by-step guide on using the 'control H' function in Tableau to replace nulls with zeros, ensuring correct numeric data type assignment.", 'Importing and setting up multiple tables in Tableau is demonstrated, ensuring the audience can follow along visually.', 'The chapter involves cleaning and importing data into Tableau, setting up multiple tables, and preparing to build visualizations.']}, {'end': 1342.654, 'segs': [{'end': 697.852, 'src': 'embed', 'start': 670.637, 'weight': 0, 'content': [{'end': 675.48, 'text': "Oh, let's go over to table one, because we were just on table four, because we just imported that one.", 'start': 670.637, 'duration': 4.843}, {'end': 676.361, 'text': 'So we have total cases.', 'start': 675.5, 'duration': 0.861}, {'end': 678.302, 'text': "We'll make that a column.", 'start': 677.341, 'duration': 0.961}, {'end': 684.025, 'text': 'Total deaths and death percentage.', 'start': 679.743, 'duration': 4.282}, {'end': 689.028, 'text': 'Now, of course, this is not how we want it visualized at all.', 'start': 685.206, 'duration': 3.822}, {'end': 695.191, 'text': 'What we want to do is go over to the show me and then go right back up here for these text tables.', 'start': 689.048, 'duration': 6.143}, {'end': 696.552, 'text': 'So let me click on it.', 'start': 695.231, 'duration': 1.321}, {'end': 697.852, 'text': 'So right down here.', 'start': 697.032, 'duration': 0.82}], 'summary': 'Discussing data visualization for total cases, total deaths, and death percentage.', 'duration': 27.215, 'max_score': 670.637, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ670637.jpg'}, {'end': 768.448, 'src': 'embed', 'start': 723.737, 'weight': 4, 'content': [{'end': 726.099, 'text': "Let's expand this just a little bit so we can see each one.", 'start': 723.737, 'duration': 2.362}, {'end': 734.946, 'text': "Perfect There's a few things that we need to change in here to make it just more user-friendly, make it look better.", 'start': 726.159, 'duration': 8.787}, {'end': 743.093, 'text': "And once we actually put this into the dashboard at the end we'll probably have to come back here and change a few things anyways,", 'start': 735.787, 'duration': 7.306}, {'end': 745.294, 'text': "but it'll give us a pretty good start.", 'start': 743.093, 'duration': 2.201}, {'end': 754.326, 'text': 'So the very first thing that we want to do is just change the coloring, change some of the formatting and make it look a little nicer.', 'start': 746.636, 'duration': 7.69}, {'end': 756.669, 'text': "And then we'll do a little bit after that.", 'start': 754.346, 'duration': 2.323}, {'end': 763.705, 'text': "So, you know, you can if you see over here on these marks, there's color, size, text, detail, tooltip.", 'start': 757.441, 'duration': 6.264}, {'end': 768.448, 'text': "That's referring to these numbers right here or what is in these rows.", 'start': 764.566, 'duration': 3.882}], 'summary': 'Improve dashboard aesthetics and functionality for better user experience.', 'duration': 44.711, 'max_score': 723.737, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ723737.jpg'}, {'end': 818.885, 'src': 'heatmap', 'start': 783.899, 'weight': 0.873, 'content': [{'end': 786.941, 'text': 'I actually do want the size to be a little bit larger anyways.', 'start': 783.899, 'duration': 3.042}, {'end': 789.343, 'text': "So let's do that right now.", 'start': 788.242, 'duration': 1.101}, {'end': 790.404, 'text': "It doesn't hurt.", 'start': 789.363, 'duration': 1.041}, {'end': 793.687, 'text': "And let's pull this down a little bit.", 'start': 791.625, 'duration': 2.062}, {'end': 800.954, 'text': "So if we go up here to format and let's do shading, this is where we can get some of these colors.", 'start': 795.749, 'duration': 5.205}, {'end': 802.475, 'text': "Let's go over to columns.", 'start': 801.434, 'duration': 1.041}, {'end': 807.198, 'text': "And our header, I believe that's what these are, are our headers.", 'start': 804.016, 'duration': 3.182}, {'end': 809.059, 'text': "Let's go over to this color.", 'start': 808.099, 'duration': 0.96}, {'end': 810.48, 'text': "That's perfect.", 'start': 809.78, 'duration': 0.7}, {'end': 812.522, 'text': "Let's just keep it like that.", 'start': 811.161, 'duration': 1.361}, {'end': 815.263, 'text': "I think that's easy enough.", 'start': 813.302, 'duration': 1.961}, {'end': 818.885, 'text': "And let's see.", 'start': 816.364, 'duration': 2.521}], 'summary': 'Adjusting size and color in formatting, making it easy and perfect.', 'duration': 34.986, 'max_score': 783.899, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ783899.jpg'}, {'end': 949.074, 'src': 'embed', 'start': 922.514, 'weight': 3, 'content': [{'end': 926.897, 'text': "We have already completed the entire dashboard, but we're going to pretend that we have not.", 'start': 922.514, 'duration': 4.383}, {'end': 928.498, 'text': 'And we are still on sheet one.', 'start': 927.117, 'duration': 1.381}, {'end': 931.64, 'text': "What we're going to be looking at is this death percentage right here.", 'start': 929.099, 'duration': 2.541}, {'end': 938.245, 'text': "It says 2, as in 2%, but it's rounding to the nearest whole number.", 'start': 932.541, 'duration': 5.704}, {'end': 947.052, 'text': 'And for death percentage, we want to be a little bit more accurate than 2%, maybe 2.1103 or whatever that number is.', 'start': 938.706, 'duration': 8.346}, {'end': 949.074, 'text': 'We want to be a little bit better.', 'start': 947.492, 'duration': 1.582}], 'summary': 'The dashboard shows 2% death percentage, aiming for more accuracy.', 'duration': 26.56, 'max_score': 922.514, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ922514.jpg'}, {'end': 1021.107, 'src': 'embed', 'start': 988.917, 'weight': 8, 'content': [{'end': 994.018, 'text': 'And if we click on it, we can go to number custom and change the decimal place.', 'start': 988.917, 'duration': 5.101}, {'end': 999.719, 'text': "So as you can see right now, it's affecting every single column and we don't want that.", 'start': 995.058, 'duration': 4.661}, {'end': 1003.359, 'text': "And it's very easy to just specify what column you do want.", 'start': 999.939, 'duration': 3.42}, {'end': 1008.22, 'text': "So we're gonna go up here to fields, click the dropdown and go to sum death percentage.", 'start': 1003.379, 'duration': 4.841}, {'end': 1011.501, 'text': 'And now the only option we have is just numbers.', 'start': 1009.2, 'duration': 2.301}, {'end': 1012.541, 'text': 'So that makes it really easy.', 'start': 1011.561, 'duration': 0.98}, {'end': 1021.107, 'text': "We're going to click here, go to number custom and then it automatically goes to two, but you can go as specific as you'd like.", 'start': 1012.881, 'duration': 8.226}], 'summary': 'Customize decimal places for specific column data in a table.', 'duration': 32.19, 'max_score': 988.917, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ988917.jpg'}, {'end': 1119.887, 'src': 'embed', 'start': 1089.065, 'weight': 1, 'content': [{'end': 1092.108, 'text': 'You can either drop it down here as a column or drop it in here as a column.', 'start': 1089.065, 'duration': 3.043}, {'end': 1093.449, 'text': 'Either one works.', 'start': 1092.688, 'duration': 0.761}, {'end': 1102.436, 'text': "So it's Africa, Asia, Europe, North America, Oceania, South America.", 'start': 1095.951, 'duration': 6.485}, {'end': 1104.298, 'text': "Let's try to expand this a little bit.", 'start': 1102.576, 'duration': 1.722}, {'end': 1107.36, 'text': 'Okay, that was way too far.', 'start': 1105.419, 'duration': 1.941}, {'end': 1109.462, 'text': "Let's do like that.", 'start': 1107.781, 'duration': 1.681}, {'end': 1117.446, 'text': 'Perfect So we have our locations and what this one is going to be actually looking at is total death count.', 'start': 1109.602, 'duration': 7.844}, {'end': 1119.887, 'text': 'So the current global death count.', 'start': 1117.466, 'duration': 2.421}], 'summary': 'Discussion about global death count by continent.', 'duration': 30.822, 'max_score': 1089.065, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1089065.jpg'}, {'end': 1256.459, 'src': 'heatmap', 'start': 1172.928, 'weight': 2, 'content': [{'end': 1180.232, 'text': 'So Europe should be at the top then North America and then Asia.', 'start': 1172.928, 'duration': 7.304}, {'end': 1186.947, 'text': 'And then South America, oops, South America is before Asia.', 'start': 1181.963, 'duration': 4.984}, {'end': 1188.768, 'text': 'There we go.', 'start': 1188.108, 'duration': 0.66}, {'end': 1189.869, 'text': "Let's exit out of that.", 'start': 1189.068, 'duration': 0.801}, {'end': 1197.254, 'text': 'So we could keep it exactly how it is and it would be fine, but we want to make some additional changes to it.', 'start': 1190.509, 'duration': 6.745}, {'end': 1201.638, 'text': 'Um, I want to rename this location to continent.', 'start': 1197.474, 'duration': 4.164}, {'end': 1206.341, 'text': "Um, that's not right.", 'start': 1204.059, 'duration': 2.282}, {'end': 1207.522, 'text': "I think it's right here.", 'start': 1206.801, 'duration': 0.721}, {'end': 1210.175, 'text': "That's it.", 'start': 1209.795, 'duration': 0.38}, {'end': 1214.177, 'text': "So let's do, let's do, um, continent.", 'start': 1210.455, 'duration': 3.722}, {'end': 1216.638, 'text': "Is that how you spell continent? Yeah, that's how you spell continent.", 'start': 1214.337, 'duration': 2.301}, {'end': 1217.979, 'text': 'Perfect And then it changes up here.', 'start': 1216.918, 'duration': 1.061}, {'end': 1220.9, 'text': 'Um, super easy.', 'start': 1217.999, 'duration': 2.901}, {'end': 1226.083, 'text': 'Um, and if we do go, if we do this right here and we, oops, we change this to color.', 'start': 1221.481, 'duration': 4.602}, {'end': 1229.661, 'text': 'Then we can change the colors.', 'start': 1227.199, 'duration': 2.462}, {'end': 1233.343, 'text': 'These are our marks and we can change certain things about them.', 'start': 1229.781, 'duration': 3.562}, {'end': 1237.646, 'text': 'So the size, right? If we want to change the size, we can do that.', 'start': 1233.563, 'duration': 4.083}, {'end': 1241.168, 'text': 'I like to keep it pretty moderate, just a normal amount.', 'start': 1238.707, 'duration': 2.461}, {'end': 1245.972, 'text': "I don't want to get too crazy over here, right? I'm just trying to help.", 'start': 1241.268, 'duration': 4.704}, {'end': 1256.459, 'text': 'So if we do the color, you can do lots of different colors and you can do it in like an ascending order.', 'start': 1246.412, 'duration': 10.047}], 'summary': 'Discussing adjustments to visualization, including renaming location to continent and modifying colors and size for marks.', 'duration': 60.415, 'max_score': 1172.928, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1172928.jpg'}, {'end': 1304.9, 'src': 'embed', 'start': 1265.236, 'weight': 5, 'content': [{'end': 1267.237, 'text': 'You can do it in descending order if you want.', 'start': 1265.236, 'duration': 2.001}, {'end': 1269.038, 'text': 'That looks totally fine.', 'start': 1267.758, 'duration': 1.28}, {'end': 1275.781, 'text': 'You can keep a theme in your Tableau dashboard, which will be something that I probably talk about in my tutorials.', 'start': 1270.139, 'duration': 5.642}, {'end': 1281.784, 'text': "Speaking of, something I have not mentioned, and I'm just going to take a super quick break, like 30 seconds.", 'start': 1276.442, 'duration': 5.342}, {'end': 1287.947, 'text': 'Something I have not mentioned is if you have never done a Tableau project before.', 'start': 1282.324, 'duration': 5.623}, {'end': 1291.689, 'text': "a lot of this might be very confusing and I hope I'm not going through it too fast.", 'start': 1287.947, 'duration': 3.742}, {'end': 1298.076, 'text': "I'm coming into this with hopefully the, I hope I'm explaining it and going through it slow enough.", 'start': 1292.594, 'duration': 5.482}, {'end': 1303.139, 'text': 'I am going to be doing a complete Tableau series coming up very soon.', 'start': 1298.697, 'duration': 4.442}, {'end': 1304.9, 'text': "Like within the next two months, I'm starting it.", 'start': 1303.239, 'duration': 1.661}], 'summary': 'Upcoming tableau series in two months, slow-paced tutorials', 'duration': 39.664, 'max_score': 1265.236, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1265236.jpg'}], 'start': 647.621, 'title': 'Tableau data visualization and dashboard formatting', 'summary': 'Covers creating user-friendly text tables in tableau to present total cases, deaths, and death percentage, formatting death percentage to two decimal points, and creating a bar graph for global death count in different locations.', 'chapters': [{'end': 921.793, 'start': 647.621, 'title': 'Data visualization in tableau', 'summary': 'Demonstrated how to create user-friendly and visually appealing text tables in tableau by customizing coloring, size, shading, and grid lines to present total cases, total deaths, and death percentage.', 'duration': 274.172, 'highlights': ['The chapter demonstrated how to create user-friendly and visually appealing text tables in Tableau by customizing coloring, size, shading, and grid lines to present total cases, total deaths, and death percentage.', 'The speaker emphasized the importance of making the data visualization user-friendly and visually appealing, and mentioned that additional adjustments may be needed when putting the visualization into the dashboard.', 'The speaker showcased the process of customizing the text tables by changing colors, size, shading, and grid lines to improve the visual appeal and user-friendliness of the data presentation.']}, {'end': 1119.887, 'start': 922.514, 'title': 'Dashboard formatting and graph creation', 'summary': 'Discusses formatting the death percentage to two decimal points for accuracy and demonstrates creating a bar graph for the global death count in different locations on sheet two of the dashboard.', 'duration': 197.373, 'highlights': ['Formatting the death percentage to two decimal points The chapter emphasizes the need for accuracy in death percentage by formatting it to two decimal points, such as 2.11, instead of rounding to the nearest whole number.', 'Demonstrating how to specify column formatting in Tableau The chapter guides on specifying column formatting in Tableau by selecting the measure values and using the number custom option to set decimal places, ensuring accuracy for specific columns.', 'Creating a bar graph for global death count in different locations The chapter demonstrates creating a bar graph depicting the global death count in various locations, providing insight into the distribution of total death counts across different continents.']}, {'end': 1342.654, 'start': 1120.327, 'title': 'Tableau visualization tutorial', 'summary': 'Demonstrates creating a tableau visualization, including sorting data by highest to lowest, renaming categories, and adjusting colors, emphasizing the importance of tableau projects for learning.', 'duration': 222.327, 'highlights': ['The chapter demonstrates sorting data by highest to lowest, with Europe at the top, followed by North America and then Asia.', 'The tutorial emphasizes the importance of Tableau projects for learning, with upcoming complete tutorial series within the next two months.', "Instructions on renaming categories, such as changing 'location' to 'continent', are provided, showcasing easy modifications in Tableau.", 'The tutorial mentions the option to adjust colors in Tableau visualizations, with the advice to keep it moderate and maintain a consistent theme in the Tableau dashboard.']}], 'duration': 695.033, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ647621.jpg', 'highlights': ['The chapter demonstrated how to create user-friendly and visually appealing text tables in Tableau by customizing coloring, size, shading, and grid lines to present total cases, total deaths, and death percentage.', 'Creating a bar graph for global death count in different locations The chapter demonstrates creating a bar graph depicting the global death count in various locations, providing insight into the distribution of total death counts across different continents.', 'The chapter demonstrates sorting data by highest to lowest, with Europe at the top, followed by North America and then Asia.', 'Formatting the death percentage to two decimal points The chapter emphasizes the need for accuracy in death percentage by formatting it to two decimal points, such as 2.11, instead of rounding to the nearest whole number.', 'The speaker emphasized the importance of making the data visualization user-friendly and visually appealing, and mentioned that additional adjustments may be needed when putting the visualization into the dashboard.', 'The tutorial emphasizes the importance of Tableau projects for learning, with upcoming complete tutorial series within the next two months.', "Instructions on renaming categories, such as changing 'location' to 'continent', are provided, showcasing easy modifications in Tableau.", 'The speaker showcased the process of customizing the text tables by changing colors, size, shading, and grid lines to improve the visual appeal and user-friendliness of the data presentation.', 'Demonstrating how to specify column formatting in Tableau The chapter guides on specifying column formatting in Tableau by selecting the measure values and using the number custom option to set decimal places, ensuring accuracy for specific columns.', 'The tutorial mentions the option to adjust colors in Tableau visualizations, with the advice to keep it moderate and maintain a consistent theme in the Tableau dashboard.']}, {'end': 1907.908, 'segs': [{'end': 1397.802, 'src': 'embed', 'start': 1368.716, 'weight': 1, 'content': [{'end': 1372.337, 'text': 'Speaking of something like this, you can edit this axis.', 'start': 1368.716, 'duration': 3.621}, {'end': 1377.759, 'text': "Now, as of right now, it's doing tick marks or I think I'm going to call them tick marks.", 'start': 1372.377, 'duration': 5.382}, {'end': 1380.459, 'text': 'They are called tick marks of 100,000.', 'start': 1377.819, 'duration': 2.64}, {'end': 1382.76, 'text': "OK, you don't have to have it like this.", 'start': 1380.459, 'duration': 2.301}, {'end': 1387.001, 'text': 'You can change it and customize it however you want.', 'start': 1384.02, 'duration': 2.981}, {'end': 1392.678, 'text': "So, you know, if we want to make it Let me see if that's right.", 'start': 1387.682, 'duration': 4.996}, {'end': 1397.802, 'text': "Yeah, if we wanna make it like this, where it goes up a little higher, that's totally fine.", 'start': 1392.698, 'duration': 5.104}], 'summary': 'The axis can be customized to display tick marks of 100,000 or be adjusted higher.', 'duration': 29.086, 'max_score': 1368.716, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1368716.jpg'}, {'end': 1472.49, 'src': 'embed', 'start': 1439.143, 'weight': 5, 'content': [{'end': 1441.104, 'text': 'I might even change it to death count later on.', 'start': 1439.143, 'duration': 1.961}, {'end': 1443.625, 'text': 'But I think this looks nice.', 'start': 1442.364, 'duration': 1.261}, {'end': 1444.925, 'text': "It's in order.", 'start': 1444.185, 'duration': 0.74}, {'end': 1445.906, 'text': "It's simple.", 'start': 1445.345, 'duration': 0.561}, {'end': 1449.847, 'text': 'And visualizations should not be crazy hard to read.', 'start': 1447.026, 'duration': 2.821}, {'end': 1453.388, 'text': 'So that is the end of our second visualization.', 'start': 1450.127, 'duration': 3.261}, {'end': 1457.45, 'text': "We're gonna move on to our third one and arguably my favorite, which is the map.", 'start': 1453.408, 'duration': 4.042}, {'end': 1467.002, 'text': "So let's go to number three, let's go to table three, and let's go look really quick at what this looks like, just kind of like this.", 'start': 1459.532, 'duration': 7.47}, {'end': 1472.49, 'text': 'And I think how we have it or are going to do it is gonna be even better.', 'start': 1468.244, 'duration': 4.246}], 'summary': 'The speaker discusses visualizations, including a death count, and moves on to their favorite, the map.', 'duration': 33.347, 'max_score': 1439.143, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1439143.jpg'}, {'end': 1533.651, 'src': 'embed', 'start': 1506.188, 'weight': 0, 'content': [{'end': 1513.63, 'text': "i'm gonna go down right here to geographic role and we're gonna go down to country region and let's click on that.", 'start': 1506.188, 'duration': 7.442}, {'end': 1519.531, 'text': 'and as you can see down here, they just generated some longitude and latitude.', 'start': 1513.63, 'duration': 5.901}, {'end': 1523.572, 'text': 'so what we need to do for that is stick them right up here.', 'start': 1519.531, 'duration': 4.041}, {'end': 1526.313, 'text': "so there's our longitude, here's our latitude.", 'start': 1523.572, 'duration': 2.741}, {'end': 1530.83, 'text': 'Excuse me for a second.', 'start': 1529.77, 'duration': 1.06}, {'end': 1531.751, 'text': 'I just sneezed.', 'start': 1530.99, 'duration': 0.761}, {'end': 1533.651, 'text': 'It is allergy season for me.', 'start': 1532.311, 'duration': 1.34}], 'summary': 'Instructions for obtaining longitude and latitude for a country region.', 'duration': 27.463, 'max_score': 1506.188, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1506188.jpg'}, {'end': 1656.176, 'src': 'embed', 'start': 1629.047, 'weight': 3, 'content': [{'end': 1636.712, 'text': "So, um, there's a few things that I you know wanna mention or talk about before we actually start moving into this.", 'start': 1629.047, 'duration': 7.665}, {'end': 1639.734, 'text': 'one. tableau has their own whole section called map up here.', 'start': 1636.712, 'duration': 3.022}, {'end': 1642.916, 'text': "Um, and there's a lot of things that you can do with it.", 'start': 1640.235, 'duration': 2.681}, {'end': 1646.959, 'text': "We're not gonna be looking at everything today, but one thing I do wanna look at is just these background maps.", 'start': 1642.936, 'duration': 4.023}, {'end': 1649.681, 'text': 'Um, it whoops.', 'start': 1647.8, 'duration': 1.881}, {'end': 1656.176, 'text': 'It adds a little bit of depth, a little bit of, it can change the moods like this is a nighttime one.', 'start': 1650.953, 'duration': 5.223}], 'summary': 'Tableau has a dedicated map section with various features, including background maps for changing moods.', 'duration': 27.129, 'max_score': 1629.047, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1629047.jpg'}, {'end': 1856.872, 'src': 'embed', 'start': 1825.457, 'weight': 2, 'content': [{'end': 1828.738, 'text': "But I don't want people thinking this is some type of aggregate function.", 'start': 1825.457, 'duration': 3.281}, {'end': 1832.68, 'text': 'I just want people to know this is the percent of the population infected.', 'start': 1829.358, 'duration': 3.322}, {'end': 1847.107, 'text': "And speaking of, we should edit this to do, let's see, let's do percent population infected per country.", 'start': 1833.34, 'duration': 13.767}, {'end': 1851.129, 'text': "I don't know if that's where we had it in the last one, but that's where we're naming it in this one.", 'start': 1848.088, 'duration': 3.041}, {'end': 1856.872, 'text': 'All right, I think this one looks good.', 'start': 1853.27, 'duration': 3.602}], 'summary': 'Calculating percent population infected per country.', 'duration': 31.415, 'max_score': 1825.457, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1825457.jpg'}, {'end': 1913.995, 'src': 'embed', 'start': 1886.156, 'weight': 4, 'content': [{'end': 1888.917, 'text': 'that looks terrible, but you can do multiple things.', 'start': 1886.156, 'duration': 2.761}, {'end': 1896.68, 'text': 'so i can have a label here and, and i can do, you know the color down here i can do multiple things with it.', 'start': 1888.917, 'duration': 7.763}, {'end': 1903.804, 'text': 'so just know that if you want multiple, if you oh hey, i want to have a color on the location i also want to have a label on the location.', 'start': 1896.68, 'duration': 7.124}, {'end': 1904.324, 'text': 'you can do that.', 'start': 1903.804, 'duration': 0.52}, {'end': 1906.947, 'text': 'Um, you just have to add multiple things.', 'start': 1904.964, 'duration': 1.983}, {'end': 1907.908, 'text': 'that that marks.', 'start': 1906.947, 'duration': 0.961}, {'end': 1909.93, 'text': 'uh, teachable moments.', 'start': 1907.908, 'duration': 2.022}, {'end': 1913.995, 'text': 'Just trying to, just trying to keep it kind of keep trying to keep the learning alive.', 'start': 1909.97, 'duration': 4.025}], 'summary': 'You can do multiple things with labels and colors for better learning experience.', 'duration': 27.839, 'max_score': 1886.156, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1886156.jpg'}], 'start': 1345.239, 'title': 'Data visualization and map creation in tableau', 'summary': 'Covers customizing tick marks and axis, transforming location data into maps, and representing percent population infected. it discusses using tableau for map visualization, focusing on background maps, labels, color customization, and clear data presentation.', 'chapters': [{'end': 1628.107, 'start': 1345.239, 'title': 'Data visualization and mapping', 'summary': 'Covers the process of customizing tick marks and axis in a visualization, as well as transforming location data into a map using geographic roles and latitude and longitude coordinates, to represent percent population infected as color on the map.', 'duration': 282.868, 'highlights': ['The process of customizing tick marks and axis in a visualization is explained, with the ability to change and customize the tick marks and axis as needed. The speaker discusses the process of customizing tick marks and axis in a visualization, allowing for the ability to change and customize the tick marks and axis as needed, providing flexibility in data representation.', 'Transforming location data into a map using geographic roles and latitude and longitude coordinates is demonstrated, resulting in the generation of a map representation of the data. The process of transforming location data into a map using geographic roles and latitude and longitude coordinates is demonstrated, resulting in the generation of a map representation of the data, providing a visual geographical display of the information.', 'Representation of percent population infected as color on the map is discussed, with the addition of percent population infected as a color parameter to the map visualization. The discussion includes the representation of percent population infected as color on the map, achieved by adding percent population infected as a color parameter to the map visualization, enhancing the visual representation of the data.']}, {'end': 1907.908, 'start': 1629.047, 'title': 'Using tableau for map visualization', 'summary': 'Discusses using tableau for map visualization, focusing on background maps, labels, color customization, and multiple elements in marks, emphasizing personal preferences and the importance of clear data presentation.', 'duration': 278.861, 'highlights': ["Tableau's map section offers various functionalities for visualization, such as background maps, which can be customized to suit different data moods and preferences.", 'The choice of background map, label placement, and color scheme can significantly impact data presentation and should align with personal preferences for effective visualization.', 'Tableau allows for the addition of multiple elements in marks, enabling users to customize labels, colors, and other visual components for clear and comprehensive data representation.']}], 'duration': 562.669, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1345239.jpg', 'highlights': ['Transforming location data into a map using geographic roles and latitude and longitude coordinates is demonstrated, resulting in the generation of a map representation of the data.', 'The process of customizing tick marks and axis in a visualization is explained, with the ability to change and customize the tick marks and axis as needed.', 'Representation of percent population infected as color on the map is discussed, with the addition of percent population infected as a color parameter to the map visualization.', "Tableau's map section offers various functionalities for visualization, such as background maps, which can be customized to suit different data moods and preferences.", 'Tableau allows for the addition of multiple elements in marks, enabling users to customize labels, colors, and other visual components for clear and comprehensive data representation.', 'The choice of background map, label placement, and color scheme can significantly impact data presentation and should align with personal preferences for effective visualization.']}, {'end': 2553.016, 'segs': [{'end': 1960.335, 'src': 'embed', 'start': 1935.427, 'weight': 0, 'content': [{'end': 1942.268, 'text': "but I have a few that I'll show you in a little bit that I think are just not the most relevant but are really interesting.", 'start': 1935.427, 'duration': 6.841}, {'end': 1954.872, 'text': 'So what we need to do is we need to bring over the date and We want that to be on our column because we want it to show the progression over time.', 'start': 1943.768, 'duration': 11.104}, {'end': 1960.335, 'text': "The thing that we're going to be looking at is actually the percent of the population infected.", 'start': 1956.193, 'duration': 4.142}], 'summary': 'Analyze data to track progression of infection rate over time.', 'duration': 24.908, 'max_score': 1935.427, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1935427.jpg'}, {'end': 2044.894, 'src': 'embed', 'start': 2015.32, 'weight': 1, 'content': [{'end': 2018.043, 'text': "So it's breaking it out per month.", 'start': 2015.32, 'duration': 2.723}, {'end': 2019.886, 'text': 'Let me go back to make it small again.', 'start': 2018.544, 'duration': 1.342}, {'end': 2025.39, 'text': "It's breaking it up per month, and that's not what we want, and we don't quarter it either.", 'start': 2021.249, 'duration': 4.141}, {'end': 2028.07, 'text': 'We want to have it by year.', 'start': 2026.27, 'duration': 1.8}, {'end': 2036.412, 'text': 'We do want it separated by year because we want the distinction between 2020 and 2021 because those are not the same.', 'start': 2028.611, 'duration': 7.801}, {'end': 2040.473, 'text': "There's a continual time period from year to year.", 'start': 2036.452, 'duration': 4.021}, {'end': 2044.894, 'text': "So what we're going to do is go down here, and this is where we can adjust.", 'start': 2040.933, 'duration': 3.961}], 'summary': 'Data needs to be aggregated by year, not monthly.', 'duration': 29.574, 'max_score': 2015.32, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ2015320.jpg'}, {'end': 2346.045, 'src': 'embed', 'start': 2315.917, 'weight': 2, 'content': [{'end': 2321.38, 'text': 'update that in your tables to get the most recent data for may.', 'start': 2315.917, 'duration': 5.463}, {'end': 2326.343, 'text': "Um, so we have this and it's looking really good.", 'start': 2321.4, 'duration': 4.943}, {'end': 2330.386, 'text': 'There are obviously some things that we can do with this to make these better.', 'start': 2326.604, 'duration': 3.782}, {'end': 2339.52, 'text': 'Some things like, um, you know, we can add labels and, and excuse me.', 'start': 2332.034, 'duration': 7.486}, {'end': 2345.024, 'text': "Um, and if we do add labels really quick, why, why not? We'll add a locate another location.", 'start': 2339.54, 'duration': 5.484}, {'end': 2346.045, 'text': "Let's do label.", 'start': 2345.344, 'duration': 0.701}], 'summary': 'Updating tables for recent may data, improving with labels and additional locations.', 'duration': 30.128, 'max_score': 2315.917, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ2315917.jpg'}], 'start': 1907.908, 'title': 'Analyzing time series data and data visualization', 'summary': 'Delves into tracking the progression of population infection in specific countries through time series data analysis and also discusses data visualization techniques including breakdown by month and year, forecasting future trends, and enhancing visualization with labels and colors.', 'chapters': [{'end': 1985.786, 'start': 1907.908, 'title': 'Teachable moments in time series data', 'summary': 'Focuses on analyzing time series data to track the progression of the percent of the population infected in specific countries, aiming to keep the learning alive and relevant.', 'duration': 77.878, 'highlights': ['The chapter emphasizes the analysis of time series data to track the progression of the percent of the population infected in specific countries.', 'The instructor encourages selecting specific countries for analysis, aiming to keep the learning relevant and interesting.', 'The importance of displaying the data over time by bringing over the date and placing it in the column is highlighted.']}, {'end': 2553.016, 'start': 1986.227, 'title': 'Data visualization and analysis', 'summary': 'Discusses data visualization and analysis, including breaking down data by month and year, using different metrics such as average and forecasting future trends, and enhancing the visualization with labels and colors.', 'duration': 566.789, 'highlights': ['The analysis breaks down data by month and year, distinguishing between 2020 and 2021, and utilizes metrics like average and forecasting to predict future trends. The speaker discusses the importance of breaking down data by month and year, distinguishing between 2020 and 2021, and using metrics like average to analyze the data. Additionally, they demonstrate how to forecast future trends in the data.', 'The visualization is improved by adding labels and colors, which enhances the overall presentation of the data. The speaker demonstrates the process of enhancing the visualization by adding labels and colors, making the data presentation more visually appealing and easier to interpret.', 'The process involves adjusting the data based on location and specific countries, to provide a more focused analysis. The speaker explains the process of refining the analysis by adjusting the data based on specific countries, providing a more focused and targeted examination of the data.']}], 'duration': 645.108, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ1907908.jpg', 'highlights': ['The chapter emphasizes analyzing time series data to track the progression of population infection in specific countries.', 'The analysis breaks down data by month and year, distinguishing between 2020 and 2021, and utilizes metrics like average and forecasting to predict future trends.', 'The visualization is improved by adding labels and colors, enhancing the overall presentation of the data.', 'The importance of displaying the data over time by bringing over the date and placing it in the column is highlighted.']}, {'end': 3123.946, 'segs': [{'end': 2667.041, 'src': 'heatmap', 'start': 2604.331, 'weight': 1, 'content': [{'end': 2604.692, 'text': "I don't know.", 'start': 2604.331, 'duration': 0.361}, {'end': 2605.492, 'text': 'This seems better.', 'start': 2604.912, 'duration': 0.58}, {'end': 2610.417, 'text': 'So now we have our last visualization.', 'start': 2606.553, 'duration': 3.864}, {'end': 2612.479, 'text': "And now if we go down here, that's another sheet.", 'start': 2610.477, 'duration': 2.002}, {'end': 2615.142, 'text': "That's a new dashboard, which is new.", 'start': 2613.06, 'duration': 2.082}, {'end': 2618.385, 'text': 'So we have our new dashboard right here.', 'start': 2616.062, 'duration': 2.323}, {'end': 2620.427, 'text': "Let's change the size.", 'start': 2618.405, 'duration': 2.022}, {'end': 2626.049, 'text': 'Just do automatic makes it the largest.', 'start': 2623.905, 'duration': 2.144}, {'end': 2630.498, 'text': "Um, and let's start, let's start adding things.", 'start': 2627.232, 'duration': 3.266}, {'end': 2635.087, 'text': "I'm just gonna start adding them because while I can.", 'start': 2630.899, 'duration': 4.188}, {'end': 2650.514, 'text': "Um, and let's do, let's add this map and let's add this, um, just to, as a start, that's what we have and it's already looking pretty good.", 'start': 2638.269, 'duration': 12.245}, {'end': 2655.196, 'text': 'Um, I want this to come down next to this visualization or be attached to it.', 'start': 2650.854, 'duration': 4.342}, {'end': 2658.437, 'text': "So I'm gonna drag it right here.", 'start': 2655.696, 'duration': 2.741}, {'end': 2661.478, 'text': "Okay This one I'm gonna drag.", 'start': 2658.457, 'duration': 3.021}, {'end': 2664.34, 'text': 'Let me see if it, um, will stay, stay in here.', 'start': 2661.498, 'duration': 2.842}, {'end': 2667.041, 'text': 'Oh, that looks terrible.', 'start': 2665.42, 'duration': 1.621}], 'summary': 'Creating a new dashboard with visualizations and adjusting size, positioning, and elements.', 'duration': 62.71, 'max_score': 2604.331, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ2604331.jpg'}, {'end': 2757.193, 'src': 'embed', 'start': 2722.557, 'weight': 0, 'content': [{'end': 2725.038, 'text': 'Okay This is very close.', 'start': 2722.557, 'duration': 2.481}, {'end': 2731.681, 'text': 'I mean, we could get closer, but I mean, this is about it.', 'start': 2725.138, 'duration': 6.543}, {'end': 2737.983, 'text': "And let me stop right here and just say, if you've made it here, you're doing a really good job.", 'start': 2732.721, 'duration': 5.262}, {'end': 2747.25, 'text': "I don't know if I went too fast or too slow or what I did, but you know, we, Got the data into Tableau.", 'start': 2738.003, 'duration': 9.247}, {'end': 2749.071, 'text': 'We looked at our data.', 'start': 2748.011, 'duration': 1.06}, {'end': 2757.193, 'text': 'We then created each of the four visualizations and then put it into a dashboard.', 'start': 2751.251, 'duration': 5.942}], 'summary': 'Successfully completed data analysis and visualization in tableau, creating four visualizations and a dashboard.', 'duration': 34.636, 'max_score': 2722.557, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ2722557.jpg'}, {'end': 2856.556, 'src': 'embed', 'start': 2825.995, 'weight': 2, 'content': [{'end': 2827.816, 'text': 'I had to go back and look at my queries.', 'start': 2825.995, 'duration': 1.821}, {'end': 2834, 'text': 'In all actuality, this took me a week or probably the more advanced one, took me a week.', 'start': 2828.696, 'duration': 5.304}, {'end': 2839.023, 'text': "And so I don't want you to get this picture in your head like this is just only takes an hour and a half.", 'start': 2834.42, 'duration': 4.603}, {'end': 2841.805, 'text': 'Like legitimately, this could be weeks of work.', 'start': 2839.603, 'duration': 2.202}, {'end': 2849.074, 'text': 'to look at the data, make sure that the data is clean, to make sure that your visualizations do what you want.', 'start': 2843.452, 'duration': 5.622}, {'end': 2856.556, 'text': 'You may want to have some type of theme, some color theme along the way.', 'start': 2850.274, 'duration': 6.282}], 'summary': 'Analyzing queries can take weeks, not just hours, to ensure clean data and desired visualizations.', 'duration': 30.561, 'max_score': 2825.995, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ2825995.jpg'}, {'end': 2965.133, 'src': 'embed', 'start': 2936.679, 'weight': 3, 'content': [{'end': 2947.885, 'text': "We're gonna do save to public or tableau public as it's gonna basically say, what is it? And I'm gonna say, um, I'm gonna say COVID dashboard.", 'start': 2936.679, 'duration': 11.206}, {'end': 2951.286, 'text': "Uh, let's say tutorial.", 'start': 2949.265, 'duration': 2.021}, {'end': 2952.627, 'text': "You don't write that.", 'start': 2952.007, 'duration': 0.62}, {'end': 2954.188, 'text': "That's not how you spell tutorial.", 'start': 2953.107, 'duration': 1.081}, {'end': 2960.631, 'text': "Tutorial I am, uh, as you can tell, I talk to myself a lot when I'm spelling helps me sound things out.", 'start': 2955.068, 'duration': 5.563}, {'end': 2964.172, 'text': "So we're gonna save this and watch the magic.", 'start': 2961.031, 'duration': 3.141}, {'end': 2965.133, 'text': "It's amazing.", 'start': 2964.533, 'duration': 0.6}], 'summary': 'Saving to tableau public covid dashboard tutorial, witnessing the magic.', 'duration': 28.454, 'max_score': 2936.679, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ2936679.jpg'}, {'end': 3067.828, 'src': 'embed', 'start': 3039.059, 'weight': 1, 'content': [{'end': 3042.402, 'text': 'Somebody really likes his current dashboard, but do two, three, four, five.', 'start': 3039.059, 'duration': 3.343}, {'end': 3047.605, 'text': 'This is your Tableau portfolio right?', 'start': 3043.983, 'duration': 3.622}, {'end': 3049.866, 'text': 'Your portfolio for SQL.', 'start': 3048.405, 'duration': 1.461}, {'end': 3051.867, 'text': 'your portfolio for Python.', 'start': 3049.866, 'duration': 2.001}, {'end': 3056.48, 'text': "Those are gonna be in GitHub and you'll need multiple of those as well.", 'start': 3053.038, 'duration': 3.442}, {'end': 3063.865, 'text': "So don't just stop here with one, okay? Let this be a starting place and then you grow from here.", 'start': 3057.181, 'duration': 6.684}, {'end': 3067.828, 'text': "This should not, I don't think this should be your final product.", 'start': 3064.265, 'duration': 3.563}], 'summary': 'Encouragement to expand tableau, sql, and python portfolios on github for growth.', 'duration': 28.769, 'max_score': 3039.059, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ3039059.jpg'}], 'start': 2553.797, 'title': 'Creating tableau dashboards', 'summary': "Covers creating beginner and advanced dashboards in tableau, featuring visualizations for percent population infected, size adjustments, and map visualizations, taking a week to create an advanced dashboard and emphasizing the impact on one's career.", 'chapters': [{'end': 2797.799, 'start': 2553.797, 'title': 'Creating beginner dashboard in tableau', 'summary': 'Covers creating a beginner dashboard in tableau, including visualizations for percent population infected, size adjustments, and adding map and other visualizations to the dashboard, reaching a fairly good beginner dashboard.', 'duration': 244.002, 'highlights': ['The chapter covers creating a beginner dashboard in Tableau, including visualizations for percent population infected, size adjustments, and adding map and other visualizations to the dashboard, reaching a fairly good beginner dashboard.', 'The presenter acknowledges the need for new headers and adjustments, indicating areas for potential improvement.', "The presenter encourages and praises the viewer's progress, expressing appreciation for reaching this stage of the tutorial."]}, {'end': 3123.946, 'start': 2797.819, 'title': 'Creating tableau dashboards', 'summary': "Emphasizes the time and effort required to create tableau dashboards, highlighting that it took a week to create the advanced dashboard, and encourages creating multiple dashboards for a portfolio to impact one's career.", 'duration': 326.127, 'highlights': ['The process of creating a Tableau dashboard can take weeks, as demonstrated by the speaker spending a week on the more advanced dashboard, highlighting the significant time investment involved.', "The speaker emphasizes the importance of creating multiple Tableau dashboards for a portfolio, suggesting that having just one dashboard is not sufficient for making an impact on one's career.", 'The speaker acknowledges the imperfections and mistakes made during the dashboard creation process, emphasizing the need for continuous improvement and learning from errors.', 'The speaker demonstrates the process of saving the dashboard to Tableau Public, showcasing the simplicity of sharing the dashboard and obtaining a unique URL for sharing purposes.']}], 'duration': 570.149, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QILNlRvJlfQ/pics/QILNlRvJlfQ2553797.jpg', 'highlights': ['Creating a beginner dashboard in Tableau with visualizations for percent population infected, size adjustments, and map visualizations.', "Emphasizing the impact on one's career by creating multiple Tableau dashboards for a portfolio.", 'The process of creating a Tableau dashboard can take weeks, highlighting the significant time investment involved.', 'Demonstrating the process of saving the dashboard to Tableau Public, showcasing the simplicity of sharing the dashboard.']}], 'highlights': ['The project involves creating multiple visualizations, combining them to form a dashboard, and sharing it, suitable for beginners with no experience in Tableau.', 'The process involves creating a simple dashboard that can be completed in under an hour and a half, after streamlining a more advanced, complex version.', 'The chapter discusses simplifying a Tableau project by creating and saving queries for visualizations.', 'To start the project, the first step is to download Tableau Public by visiting the provided link, entering the email, and creating an account.', 'The chapter demonstrated how to create user-friendly and visually appealing text tables in Tableau by customizing coloring, size, shading, and grid lines to present total cases, total deaths, and death percentage.', 'The chapter emphasizes analyzing time series data to track the progression of population infection in specific countries.', "Emphasizing the impact on one's career by creating multiple Tableau dashboards for a portfolio.", 'The process of creating a Tableau dashboard can take weeks, highlighting the significant time investment involved.']}