Data Visualization Intro: Build a Tableau Dashboard about Trump’s Twitter! | Dee Naidoo | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Data Visualization Intro: Build a Tableau Dashboard about Trump’s Twitter!

teacher avatar Dee Naidoo, Data Nerd

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

5 Lessons (1h 3m)
    • 1. Introduction to this course

      1:06
    • 2. Installing the Free Full Version of Tableau

      1:46
    • 3. Connecting to Data on Tableau

      10:01
    • 4. Building Charts and Creating Calculated Fields

      37:33
    • 5. Creating the Dashboard

      12:36
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

164

Students

1

Project

About This Class

This introduction in Data Visualization will introduce you to Tableau! Tableau is the data visualisation platform that thousands of companies use today! This short course will allow you to jump into data visualization with a hands-on exercise about analyzing Trump's Twitter Feed!

You'll learn to create a dashboard like the one below! 

020f2fd3

You'll learn all of the features in Tableau that will offer as a good introduction to Data Visualization. It will allow you to explore, experiment, fix, prepare, and present data easily, and beautifully.

By the end of this class, you will learn:

  • Create and format charts
  • Create a dashboard your user can interact with drill down for more detail
  • Create calculated fields
  • Use logic statements
  • Use Tableau functions such as CONTAINS
  • Creating Data Extracts in Tableau
  • Filtering data
  • Creating Sets

This course begins with the Tableau basics. You will navigate the software, connect it to a data file, and build a functional dashboard, so beginners will feel completely at ease! It will introduce you to the principals of data visualization to kick start your career in Data Analytics!

Dataset

https://databudd.com/s/trumptweets.xlsx
https://databudd.com/s/donaldtrump.jpg

Want to get updated data? You can access it through this website http://www.trumptwitterarchive.com/archive

View my other class on a more detailed introduction to Tableau and Data Visualization:

Meet Your Teacher

Teacher Profile Image

Dee Naidoo

Data Nerd

Teacher

Hello, I'm Dee! I am a Chemical Engineer specializing in Data Analytics.  

I've been using Tableau daily for the past couple of years. I love creating visualizations and letting the data speak for itself.

Other than that, I love food, movies rated less than 5/10 on IMDB and escape rooms. I sound like a major nerd until I tell you that my favourite music is Rap. I adore a great view, hate raw onions, and I think that pineapple on pizza is the best combo ever!

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction to this course: hi guys, how everyone is doing well and decision. We're going to be covering something a bit different. It is analyzing Donald Trump's tweets about the Corona virus. So it's something fun and interesting, and hopefully it would help you, then a little bit more about tableau. So sit back, relax and enjoy the station. Okay, so this is the dashboard we are going to be creating where it is analyzing Donald Trump's tweets. So this includes all his tweets from the first of January 2020. This is just tweets mentioning the Cove in 19 Crisis. These are popular phrases that he mentions a lot and his top five tweets. We also going to add actions. So if you click on a point in the dashboard and click on Click for Tweet details, it actually gives you the underlying data it was referencing, which is quite cool. So if you would like to take part in this tutorial boarding the stash board, then continue to watch 2. Installing the Free Full Version of Tableau: Hi and welcome to this. Listen, So this is just a little clip so we can install tableau and get it up and running. So open your Web browser and type the link. Www dot tableau dot com slash products slash tile So that's tableau dot com slash products slash trial. Right, And this is actually tableau desktop. It is the 14 day trial, and it's free. So it is the tableau with the full capabilities. So what you going to do is into your email address. You can use any email. It doesn't have to be a business email and click download free trial. Now just do not. If you are a student or teacher, you can get a one year free license if that applies to you as well. But I'm not a student or while technically, not a teacher. So I'm just gonna click download free trial, and we're good to go. Okay, and as you see, it shows up in your downloads. Its around 472 megabytes onda. Once the download is done, you can just double click on it and follow the instructions to get tableau up and running. So that's it's um I hope everything is set up for you. And in our next listen, we'll learn a book more on how to connect a data source to Tableau. So see, then. 3. Connecting to Data on Tableau: Hi, everybody. Welcome to this tutorial. We are going to cover quite an interesting little dashboard today. We're going to bold a tableau dashboard, and it is going to be about Trump's tweets, mainly around the covert 19 of crisis. So just before I begin, you can get the data set on my blawg, which is data but dot com It is linked below this video. And if you scroll down to the article, I linked the day to sit here, which you can download. It is on an Excel file, and also the Donald Trump picture I've used of Also think that so you condone noted as well and just a note I extracted this data from aside to called trump twitter archive dot com. So if you want to get fresh data, you welcome to extract the data again. Otherwise, you can just to use my link over here. Okay, cool. So let's open up tableau. Okay. So usually when you open up tableau, you're greeted with this window and it's pretty simple. On the left is the data sources that you can connect you and on the right is usually some training material provided by tableau and Generally, they are sample workbooks. That tableau have created for you to have a look at. But right now, what we're gonna do is we're going to connect to our Twitter data. So just remember where you saved those downloads. And what we're going to do is that since it's an excel file, we are going to select to a file and Microsoft Excel. So click on it and just navigate to wherever you saved it. So I saved it on my Twitter tableau file under Trump Tweets. It's a reasonably small file. Just 380 kilobytes. I've just extracted three months worth of data. So since January, the first you're welcome to extract more. Okay, Click open. Okay, great. So now we're on the data source pain. And this is where you can do some tricks with your data before actually bringing it in to tableau, the data visualization pane where we actually bought our charts. I'm just gonna do a brief tour off this. So on. You lived. You have your connections, pain and the data source. So you can see the Excel file was called Trump Tweets, and it's a Microsoft Excel file. You can't get it to this. If you want to, just click on the small arrow and you can rename it. And if you connecting to an Excel file, usually whatever sheets are in the file of Pierre here. So because there was only one sheet, one sheet is just appearing and you can see immediately Tableau brought it into this white space, and I'm going to rename it so to rename it just cover over it. And once you cuss, that changes to this double click and name it, so I'm just gonna name it from tweets. Also thing that's good practice to always are rename your sheets, especially when you bring it into tableau. Once you start boarding more complicated dashboard, you're gonna need a lot off data sources and naming them sheet one sheet to don't really work out OK, and you can see over here again and say sheet one trump tweets. Now, this actually refers to the whole data source. So again, I'm just gonna rename this so double click, select all and just backspace and I'm going to rename it Trump tweets underscore data source. Right. So let's look at the rial meat off the data source pain, which is the actual data. And the tutor data here is quite simple. So they have a source. So Trump tends to tweet a lot on his iPhone is the text. So this is the actual text of the tweet the created yet So this is a date off when the tweet was created, The retweet count. How many retweeted got paper counts or harmony likes got the is retweet field, which is a true false if you can see. So this is where the trump had made a retweet. This is your twitter I d. So ideas generally on your database are good for counts. If you want a county unique values and you can see there's some weird condoms here. So I brought this in on purpose, urges empty columns for us to get used to not only deleting them, but using a data interpreter on tableau. And before I covered that I just want to go over the types quickly. Okay, so let's just have a look at the types in your data source. So, for instance, of this column, you can see it is the text field and hints it has the ABC icon on it, So if you select it, so just click on it. It will tell you the type that selected, and you can also change it so you can change it to a date, a number, or even a geographic role. But this is correct, so we're just going to leave it now. If you have a look at created at which is a date format, it's actually reading this as the string, so we should change it. So click on the icon and change to a date in time because it does have a date and it does have a time. And now let's just deal with these last four columns. So sometimes when you work on Excel, you often get tables, which on structured properly so, for instance, sometimes is a random blank column, or sometimes is a random, blank role at the top. So what tableau has done is created this data interpreter function, and if you click on it, it cleans the Excel table and structures it properly, so let's kick on it. And as you can see, those columns have disappeared. And that's mainly because Tableau realized that they have no data in it, so it's probably a mistake. Okay, so we good to go And just two more things I wanted to chat about. So on the top right there is a filter function, and adding falters basically means seeing only a certain part off the database. So maybe you'd wanna only analyze Trump's tweets that are not to retweets. Then you can you use this diction him so it's pretty easy. You click on add and this pain pops up and you could go on ad. And if you only want to see Trump's tweets that he's written himself, so click on Israel Tweet, Okay and Eunice a false click on OK, click on OK again. And now all these tweets that are showing, ah, ones that Trump has risen himself and has not retreated. But I want to see everything, so I'm just gonna get rid of this. So click on it and just click on. This is Retweet, Walter, and remove it and click. OK, so you also can falter on maybe a specific year or a month. But remember, if we falter data on this level, you can't analyze it and create visualizations. And the last thing I wanted to talk about is the connection options. Do you ever option to connect to alive? Dead? Is it one extract? Now the extract function saves the data. Sit in a high performing file cold hypo. And it just keeps a copy of this on your local computer. So boarding your dashboards end up a lot more faster. So we are going to click on extract. And once you're ready, click on sheet one at the bottom. Over here, you can save the data source wherever you want to. Usually tableau defaults to the data source file under your repository. So I'm just gonna click. Save. Okay. And now this is your data visualization window. Now, if you deal with big data sets sometimes the data takes quite a while to load. Could just be aware of that. But because our tweet data set is quite small, it was near instant. Okay, so I am going to end off here and in our next listen, we are going to learn how to build charts and graphs on tableau. So see then, by 4. Building Charts and Creating Calculated Fields: Hi. Welcome back in this lesson. We are going to learn a little bit more about the tableau interface and start building some charts and graphs, so hope you enjoy. Okay, so this is the data pain window. It's where we are going to bold all our data visualizations and to start off. I think I just want to create a simple bar shot that displays how many tweets Trump has bean tweeting today. I just want to see if there's any trends or any spikes. Okay, So to do that, let's bring in created at on two columns. So on tableau, you just click on the field. You want to bring in, and we'll bring it into columns and straight away you can see that already The created at Field has some no dates to. This means that the dates of Blank and we'll sort it out soon. Now, the next step is to figure out how many tweets he sins, so to do that requires maybe a bit of logic. So, on a data set, we know that every role represents one tweet and tableau usually generates a handy field called number off records. So this is a tableau, auto generated field And all it does is it counts the number of rows. So technically, this is actually the number off tweets. So we're going to rename it and you rename a field. You can click on this little arrow and scroll to weigh it, say's rename. So instead of number off records, when a replaces to number off tweets, okay, and now to bring it into the state of pain, it's pretty simple. All you do is you double kick this and it doesn't job. So what Tableau has done is basically took this number off tweets and place it on top of the text card under the mark pain. OK, but remember I said I wanted a bar chart, and also I don't want this by year. I actually wanted by day, So let's change it into a bar chart, because this table isn't looking too great. So to do this, you just click on, show me it's at the top, right, And show me basically shows you what charter you can select. And the really cool thing about it is that when you hover over a specific chart, it actually tells you what you need Okay, So for bullet graph, you need zero or more dimensions and two or more measures now a dimension in a measure. What All they So what I mentioned generally is a character or category. It's something that you can't measure. So think about dates, product categories. Ticks off your tweets, etcetera. You can't measure that. You can't do a mathematical operation on it measures. On the other hand, you can so you can some missions to give up. You can't add them together, and that's generally big difference. Okay, so back to those who we are going to click on the bar chart tableau closet, the horizontal bars. So click on it once to get rid of Show me, just click on it once again and it disappears. Right? So now, at the want AEA actually want Damon Theo. So to do that, you can see what tableau is giving me. So on this blue pool, it's a zits, giving me only the year off the created at and that you usually with tableau defaults. So to change this click on the arrow and if you scroll down, you can see the one that selected. But I want to Damon Theo so scrolled on two way, you find it applicable, which is this one, and it's saying, Month, Day, Yeah, that's as good as we're going to get. So let's kick it, Okay, much better. So we have the date on the Y Axis and the number off tweets on the X, but I want to talk to round. So to do this is an icon that basically tells you it's swapping the rows and columns click on it, Brit. Okay, so the next thing I want to do is Are this colored by if it's a retweet or not? So, for instance, this bar I wanted split into whatever retweets and what aunt, because I just want to see an overall pattern off how much he's tweeting today. And does he retweet often? So to do that on tableau was pretty easy. Look for that is Retweet field. Click it and drag it on the color. There we go. So what this color legend is saying is that retweets on rid and original tweets that he's typed out himself per se fine orange and any now is in blue. Okay, so before this, we figured out that they are some dates that are now, so let's get rid of them. To do that, we are going to drag the created at field into folders, So click on it, drag it and drop it and click on years. Click on next and you can see no shows up you anyone to exclude. That's if you click on it. It will tell you selected one off three values, but we wanted excluded. So click on exclude and select. Okay, Okay, Cool. Now that that's sorted, we can look over here, and that is retreat way. It showed Blue as now is not disappeared, right? So let's do some formatting off this. So personally, I want these grid lines to disappear. And to do that just right, click anyway on this trucked and select format on this format, pain is basically whatever you need to do to make the chart look better, so you can change things like the front, the alignment. So whether you want it centralized or not, you have sheet color, a border on the dashboard, and finally, this icon is with grid lines, so the grid lines look like the horizontal, which are rose, so click on rose and you can see there's a faint grid line. So just click on it once and click on none and they disappear. Okay, and now I actually want to change the fund. I just wanted to or be tableau bold because that looks of a better. So click on the A icon and where roses selected Click on sheets and what stays worksheet Click on the front. So this basically is saying that it's been apply this 1 to 2. The whole worksheet Presidents click on the Blue Arrow and move one up to Tableau. Bold. Okay, it looks bit up, and lastly, I just want the background to not be white. I like it to have a bit of a gray color. So click on this full bucket where it's a sheet, click on worksheet and let's do this great here. So it's the 3rd 1 Okay, so the next step would be changing the color off the bars. So select color in your marks pain go to get it colors. So to change the false color, we gonna selected ones, and I'm gonna change to the blue here. Now, this is from the automatic color palette tableaux has different color palettes that you can have a look at. So if you select on here and you can see these old types of different colors But I am just gonna deal with this for knowledge is because I like the colors. So for true, I think I'm gonna go with a gray and disgraced He has Fine. Okay. And it's okay. Okay. So the next step is let's actually change this excess name because it saves day off created yet, which is a bit confusing. We can just make it's a date. So to do this right, click and say it had excess, and over here you can change it. So if you want a fixed access, you can where it only takes a specific range, you can reverse a scale. Over here is where you change access titles. So let's just change it to date. Okay? So you can just close this now it's changed. So the last thing we want to do is change this title. Okay, So to change the title, just hover over here and double click it and let's just backspace everything here and let's change it to tableau. Bold, maybe 14. Let's call it tweets since one Jan. 2020. Let's centralize it. Okay. And then the last thing on ad is just a small legend on the title. So a presenter and change of the fund size to 10 and its type in blue colon original comma gray colon Marie treat. And it's add some color. So it is blue colon original selected and change the color to blue. Somebody uses this blue here and where it says great colon retweet selected and change the color to gray. Somebody used to scrape e stood a Dhaka Okay. And apply. Okay, so now that we have this year, we can actually remove this legend. So click on the small arrow and say Hide cod. Well, okay. And the last tip would be renaming the sheet. So go down here and double click on it and call it tweet count. Okay, now, the next graph I'd like to create is something similar to this, but where I want to count tweets with Trump mentions covert 19. So, to do that, let's create a new sheet. So click on this icon with the chopped can see a She too is created. And what we're gonna do is in water to Con Tweets, which mention the Corona virus. We are going to create a calculated field and a calculated field is basically an extra column that you create with the new data set that has some logic and rules that apply to it . So let's do that way. It's a is dimensions. Just go across and click on this arrow and the first option create calculated field Click on it. So it is Calculation one. It's the name of the field, so let's next base that and say mentions Hold it 19. And how this calculation is going to work is that we're going to use a function cold contains. So if you type in contains pops appear and you can see it's telling you what we need to do . So we need to refer to a string and then a sub string. So the contains function basically such is a specific string for a would that you want. So in our example, we are going to such the text string so basically Trump's tweets. So in this example, we're going to search each role in the text field for Corona virus Covert 19 ex cetera and flag that Let's do one example. So contains the string is going to be fixed. Can see it shows up. Use a comma in the sub string Now because we are searching for a word, we're going to put it in quotation marks. So open your quotation mark and we're going to say Cove in 19. So covert Leszek over Dash 19. Close your quotation mark and close your brackets and let's just click. OK, let's received this works bringing text as Rose and say Add old members and just expand this A. But okay, now mentions Copan 19 field drag and drop it next to text on the Rose to a ball. Okay, and now I just want to exclude wherever it stays false. So basically wonderful to the data. And it's very easy to do it this way. So click on false and say exclude. Okay, let's have a look and see. So now it's saying that thes tweets here actually mentioned covert 19. So it's mentioned Hill that's mentioned there so pretty legit. Now I'm gonna Adam this. I also wanted to flag the Wood Corona virus as well. So let's get it. The field so. So click on our mentions. Covert 19 field click Slick it it. And to do this, it's gonna be a logical function. So type in or and let's do another contains. So contains. Open your brackets. The string is still going to be text comma. The sub string is going to be a Corona virus and close your records and let's click. OK, okay, so it's increased the tweet count by a lot to see if this is true. Um, okay, Corona viruses mentioned here, and it's flagged as true. So you do not just that If he capitalizes the Capital C, it's still flags it as true. It's because the contains function that we used is not case sensitive, which is pretty cool. It makes it a bit easier for us. And let's add one more, which he doesn't mention, and it's a bit controversial. So it is this field again and typing old and let's add Chinese virus cause he unfortunately say's that as well. So contains the string would be fixed, but the sub string would be Chinese virus and closed records and click OK, okay, so this jump to 204 records you can see this on the bottom left of your screen. Okay, so now we're going to create a graph. So to do that, let's duplicate this graph here. So on tweet counts selected, right, click and click duplicate And let's drag is retweet out and Wade says, mention covert. 19. Drag this into the Fulton's and pick on True and click on. OK, okay, right. Okay, so the next step is maybe once a label on each ball. So to do that, we can use a number off tweets as a label. So when you left pane select number of tweets and dragged his label, let's change this A. But it's rotated here. Let's just changed back to normal. So click on label where it stays alignment. Click on automatic, where there's direction, Click on this and let's change the color. So click on color and I'm gonna change to rid. Okay, and then the last thing we should do is maybe change this title so it's double click it. We don't need a religion because we just had one colors. Let's get rid of us. Just backspace it and let's call this tweets tweets mentioning sobered. 90. Okay, and it's changed this titles. Wade stays tweet. ConEd Double click it tech space and let's just call it tweets. Mention over 19. Okay, so now we have two charts. Let's creates another one. Create another sheet. So go to this SaiPan and ticket. Now this part shot. I just want to come to the number off times, Trump say's a popular phrase. So something like every time he mentions Democrats. And every time he mentions Covert 19. And every time he mentions a stock market, ex cetera have a few phrases built out that we all going to use, and we're gonna do it very similar to the mentions Covert 19 field. So let's duplicate this so kick on this field, right, tick and duplicate, you can see a copy gets created, and now we're gonna edit this. So click on it. And it that's rename this to mentions Democrats. Okay, and I think there's just generally two words he generally mentions when he talks about Democrats. So just two options so we can get rid of this. Okay, so now we're gonna do is just change the praises in thes quotation marks just to make it a bit easy and cost of us. So the first word he mentions when he talks about Democrats is obviously Democrats. It's at that nothing was sick and one is he say's dims to D E M iss. OK, but now something is a bit of what I'm gonna do is actually initiate account because I wanted to be displayed differently. So what I want to do is I want all of these phrases to actually be displayed on the same graph. And to do that we need one field, which counts what phrases trump makes popular. So we're actually gonna change this about So there's changes field, and it's call it popular phrases and what it's gonna be is an it function. So I'm just gonna into this a few times I can right here. So how it functions work is that if a certain scenario happens, then tableau needs to output a certain answer. And if a different scenario happens, then tableau needs to our put a different scenario. So, essentially, this is how the structure works. So if scenario one then tableau needs to give me on someone else If Scenario two then tableaux needs to give me answers, do else if Scenario three then te lo needs to give me bonds three end. Okay. It can go on to answer 100 if you want, but we are going to have a few phrases and this is a general structure. So my scenario one would be if my text contains Democrats or dims then I want popular phrases to output the world Democrats. So it's compass. So Kamande, XO control x and way. It's a scenario one. Just paste it in, replace okay and then on so one would be Democrats. So open up your quotation mark type in Democrats in close now to form in a bid on a press enter That doesn't do anything other than just help you structure your query. So let's press another inter here. Where else if iss Okay, so we are going to actually have eight different popular praises. So I am just gonna right the structure off this 48 raises, you can either jump a few seconds ahead or watch me do it. Okay, so now that I've created the structure off the query So what we all going to do is be going to write this Noro here and then cut it and paste it. Okay, so the next popular phrase is the one that we've done before, which is mentioning covert 19. So let's do that. So the scenario would be it contains. So does the text field contain province 19 or I'm just gonna copy and paste this phrase. And let's do Kobe 19 like that or again. Paste the phrase Nothing. Let's do Corona virus. Oh, Chinese virus. I don't know why he calls it that. Okay, so this is actually all scenario to said it's cut it. So control XO command ICS and replace it way taste in order to And our answer if we scroll would be grown a virus because of any off the text of his tweets mentions thes characters or these words. Then popular phrases must be corona virus. Don't know why this keeps changing names. Just gonna select apply. Okay, scenario three. So what's in our your three? I want to see if he mentions the stock market. So just copy apart off this So Sonora three would be stock market, um, space or wasted again. And I wont have say the doll just diode w because when he does say Dow. He's referring to the stock market. So let's select us. Cut it induced in order three. So it's pasted there and then on to three would be the stock market. So quotation marks the stock market close quotation marks. So the next scenario would be to make America great again. So let's gain paste the example. Oh, this mistake. You mean just backspace that And Okay, so his catch phrase make America great gay omega So I m a d a. You can see as you continue to bull these if statements it actually makes more sens that's cut it with the structure and paste it on scenario for then answer for would be a delicious do the whole phrase. So quotation marks make America great again the next Naro. He talks about fake news a lot, so let's do that. So just copy an example. So let's change this to fake news. I think that's all for fake news. So let's cut this and this is gonna be scenario five paces there onto five would be fake news. Okay, so the next scenario he mentions Joe Biden a lot. Biden is a computer off his in the next election. So I think that would be interesting to see how many times he mentions that. So let's create another scenario. So just copy the contains pot pasted there. So let's do nothing. Just a son named should be fine. So if you mentioned Biden, it's pasted in scenario six. The answer would be Joe Biden came. The next one would be so. He tends to mention the word loser a lot when he is referring to people that he does not like. So it would be interesting to also see, So let's do that a scenario. Seven. So just pasted the recent one in instead of Biden. Let us do you loser. Well, it's cut that and paste it in scenario seven and let's have the answer as a loser. And finally, the last scenario is Obama. So let's copy this. Placed it here and let's just do Obama. It's cut this into scenario eight. Paste it and it's quoted Obama, okay, and that is it. I'm just going to expand this so you guys can have a final look and pulls the video just to make sure everything is okay. Your calculation should be valid now, so everything's looking good and click. OK, okay. There was a huge calculation, but it is looking good. It's now let's create a bar chart with it. She was just duplicate this chart and why have duplicated is because we formatted this already. Just makes it a lot more simpler to do. So right? Click duplicate. And now let's just remove that there and the day created now, yeah, it remove the day created at gonna keep number of tweets And let's bring in popular phrases . Okay, that's great. And let's exclude now because that basically, is all his other tweets. So click on this and say Exclude okay and others looks better. I also wanted turned So click on this icon and I wanted sorted. So you can sort on these two icons the sorts of from smallest to largest so ascending and this is descending. It's good practice to generally store to your horizontal bars or you bar charts with descending okay, and let's change this. It's looking a bit small. So where it's a standard gotcha anti of you Great. The's vertical bars are showings. Let's get rid of that right click for Mitt and good lines. Or here in the last icon. Click on columns and you can t the faint grid line cheering up. So click on it. Select None Care. Let's change the color. Um, this training to a bit of a gray. So maybe this great here, Okay? And the last thing we're gonna do is change this title, so double click to change it. And let's call it popular phrases used by Trump hands looked ok. Okay, right. Interesting. Okay, so let's change the sheet name on the bottoms, a double click on it and call it popular razors. Okay, so the last thing I want displayed is Trump's top five tweets by the number off favorite counts. So to do that, little duplicated the sheet. So right, click duplicate and instead off some number off tweets. Bring in favorite count and just drop it right on top. Off it is some number of tweets. Make sure that is selected. Let's go. And now you can see it's changed to favorite Count this. Just remove this label as well. So instead of where it is popular phrases, it's replacing it with text so again and must be selected. Drop it and sick at all members. Okay, so this looks insane and it is because it's putting all the data in this one small sheet. So instead of saying anti of you, it's do foot with OK, but been up. Remove this popular phrases, Walter as well, and it's expand this A but okay, and let's sort out from largest to smallest. So this will sort out his tweets into the most liked tweets. As you can see, to know what I want is on the top five off this. And instead of just selecting the top five, there is a way you can do it on tableau, and it's called Creating a Set. And a sit is basically a set of logic or rules that govern your subset off the data. So to do that, we need to consider Okay, how are we calculating the top five tweets while we calculating it based on the text field ? And that's how we gonna create our sit. So go to the text field on the lift, right chick, go to create and clicks it. So a taste it to one. Let's rename this. Let's call it talk five tweets by favorite, okay and wait. His general condition. Click on top and taken by field. And it is top 10 by favorite count And the some which is quite close. But we want top five. So backspace in five and OK, and now you can see this fuel has been created understates. And now all we do is we drag it into the folds, his field, and there we go. So it's format this a but, um, we can put entire view now that defaulted out of data and this looks quite fine. We can get rid of this Hida. It's not really doing much so right click and hide field labels arose, and then I just want the favorite count as a label. So it tastes favorite count. Drag it as a label. Okay, it's renamed this so double kick. Thanks. Face everything and top five tweets by. They would count. Okay. And let's rename this worksheet top five treats. Okay, so now we're done with all our charts. We have four charts now. We ready to create a dashboard? Okay, so I think I'm going to end this. Listen here in the next section, we're going to finally learn how to build a dashboard and put all our charts together. So see you then. Bye. 5. Creating the Dashboard: Hi, guys. Welcome back in this final section, we are going to learn how to bowl the dashboard. So without further ado, let's get to it. So to create a dashboard, we click on this window looking icon, and this is the dashboard pain. Now I want to change the sizing. And you can do that by clicking on this size. And you can either. You can have it automatic. And this is where it re sizes to the current screen. So I'm gonna use a fixed size, and the width is 13 and the height would be 8 50 Okay. And one change the color off this dashboard. So click waits his dashboard, go to format and change the default shading to a grey thud on dog. Okay, Right. No, to fix your dashboard, you need to use containers and contain us. Yeah, they basically work as boxes which fix your charts. It makes it much easier to work with. So click on floating and let's click on the vertical box or container. I'm just gonna resize it, but okay. And a little bring in the first graph, which is tweet count. So how you do that is you kick it, you drag. And as soon as it's over this box of money to click shift and you can see it fixes to the container and let go. Okay, you know, do the same thing with tweets mentioning Cove it. So click it drag, and as soon as it's over this books, I want you to click shift and you can see what it's highlighter to the lift. Bring it to the bottom. Great. Now I want another container, so bringing a vertical container put it on to the right. Just resize it a bit. And where it say's popular phrases Click it dragged over this container pulled shift right on the last roughly days. Top five tweets. Click it, drag it over this container and right here, let's go. You can see there's a little formatting issue here, so you can just have a look at the sheet. So if you select this click on this arrow here and I just want you to bring it in a but more so just reduced the text sighs. Okay, click back on dashboard one. It should be fixed on, and they just put anti of you. Okay, so sometimes you do have to play with the formatting. I don't think this excesses necessary. We do have the labels here. It's just right. Click it and De Select Waits, a short video and the same with this graph. So select the graph hopper over the excess right ticket and D Select show Hidden. The last thing I'm gonna add to this dashboard is just a picture and hitting, so we're gonna create a horizontal container, dragons and hold shift. When it's around here and want its highlighted like this, they go. Don't worry about the sizing for everything. We're all going to sort it out soon, and it's a text. First it's a dragging text hold shift and did it go here? It's changed the fund to tableau Bold and let's make it 28. So let's call it two. Let's call it analyzing Donald Trump tweets. Let's make the phone, too. But doc Oh, so maybe that great here and you want a bit of color. So let's make Donald in blue and Trump in rid, okay? And when it at a picture. So let's bring an image. Drag it where it is. On top of analyzing tweets, pre shift and you can see this part of selected. So drop it. And now let's choose an image. So the image is the one that was included in the block article, so you can get your own image. So it's this immature. Open it. I'm gonna put and send it and check. Okay? And that's it. Think licious centralizes titles a double click on it, Select all and make it center. Okay, now, the last thing we're gonna do is put it all together. So click on the out and which is item hierarchy. This is a great way to select the full containers. So pass electors vertical. It selects everything in this container. And this vertical here six everything in this container so I'm just gonna resize is to make it quite small. I know it might just seem a bit weird, but there is method in my madness. Select the other vertical container and make this part small. Okay, Now, let's create one lost container. So go to dashboard and took on horizontal container and go back to lay out and select this vertical. Actually select the other one, this particle. And now you can see this little not sheer. Won't you duplicate and drag it so you can drag it around, Place it over this container and slick shift and it go similar with this container. So click it on your item hierarchy and here you can drag it once it's over. This slick shift and as soon as it's highlighted just like this and you drop it, okay? And now you have all your charts in one container. So if you go right to the top under horizontal, it should select everything and the last action you do ISS like this arrow de select floating. Now you get a nice fixed dashboard that you can play around with the sizing without affecting too much of it. Now there's one last thing we're going to do, and we're going to create a dashboard action. Before we do that, we need to create a quick worksheet. So pick on the new worksheet, which is this icon here, and this is gonna just be a list. Let's bring in the tweet I d click edl members and let's bring in created at Just plop it next to I D String on the Rose Field and let's click on the arrow. Let's bring in day now. Usually, whenever you do this, it changes it to measure and a graph format. But I wanted as a normal dimension. So click on this arrow and click on the street, and that makes it more off the table for Mitt. Let's bring in text, so place it next to the created at during adul members. And let's bring in favorite content. Retweet Constant is a measure you can just double click it. It will add it as a column and retweet con double click it. Okay, change this, so go to instead of scan it. Let's do fit with. And let's just edit this of boots, right? And let's remove the created at for now. So click on this and exclude Great OK, and now let's double click on the sheet title and it's called a tweet. Details. It's changing to tabla bold and centralize it okay, and it's renamed the Sheet to tweet details. And let's rename the dashboard to trump Twitter. Josh Cool, Okay, and why I created this worksheet is I actually want to use this as a drill down for detail . So, for instance, if the user selects on Democrats taking gets into the workbook, and they can't refer back to see the tweets that make up this 297. So to do that, all you do is go to dashboard select actions, and we're going to create an action. So click add action. It's going to be a photo, because what I want to do is click on Democrats, and they need to see those tweets. So click photo it's gonna be called click or Tweet details. And what this is is this just basically tells you where the user starts and we had The user must end. So the user's starts by kicking on any data point on the dashboard and they'll get send to the tweet details worksheet. So not this. Click on it. Go to tweet details. Okay, so if they use a slicks, any ball from popular phrases, you'll get sent to the tweet details. If the user slicks any bar from the top five tweets, he'll get sent to tweet details and clearing This filter will show everything as is. So take that okay and OK, so it's tried out. If I click on Democrats, it will say click for tweet details. And this is exactly the tweets that that bar to you can see over here. 297 records. And they all should either mention games or Democrats. Difficult back to my dashboard and d selected this photo. This would be the whole date. Is it okay? This tried out again. Okay, so on this day, the 10th of April, there were 17 tweets from Trump that want to retweet. What were these tweets someone has selected? I'm gonna say click for tweet details. And these were the 17 tweets that he sent. So it's quite interesting. It also gives you a view off drilling down for detail. And it's always good to add actions to your dashboard. And that's it from me. I hope you had a lot of fun building this and you got to learn a bit more about tableau. I also have another course on tableau building a dashboard relating to the Corona virus cases. So if you haven't checked that out, go ahead and Vima profile. Otherwise happy tableau building and all the best buy