[MUSIC] Hello, okay now that we know the way around the workshop, it's time to start to get our hands just a little dirty. After this lesson you'll be able to import a data set into Tableau, and we'll perform some minor cleaning on it so we'll be ready to hit the ground running next week. We're going to use a data set from a weekly community project called Makeover Monday. The data is about London bus safety performance and was the project topic in week 51 of 2018. The grain of the data or what each row represents is one victim of a bus accident in London, UK between January 2015 and September 2018. Don't worry, the vast majority of them were minor enough to be treated on scene. So to get going, download the data file attached to this video as a resource and then open up Tableau public again. Let's start from the welcome screen. Our data is an Excel file hosted locally, so click the Excel file under the Connect section. Navigate to your file and click Open. This is now the data source screen. There are a bunch of things you can do here, and we'll cover the important ones as we go. First, on the left hand side, you'll see your data connection which tells Tableau where your file is on your computer and contains all the information it needs to locate that file. Below that, you'll see a very short list of sheets available in that Excel workbook. And this new union below that. The new union allows you to append sheets to each other if they're structured about the same. It's rules aren't quite as strict as the rules for unioning and SQL. But that does mean that you need to be more careful if you use it, which we won't be doing here. Notice that since there's only one sheet in our workbook, Tableau already guessed that we want to be using that. I want to show you how it works though. So why don't you grab that other incident of sheet1, that is in the large and otherwise empty area to the right, then just drag it over to the left and drop it. You can also click Remove from the drop down menu, but that's not nearly as much fun. You'll notice that now the lower right area's empty and the top right area says, Drop sheets here. So let's follow instructions, click on sheet1 on the left, drag it over, and drop it. Voila, the data comes back. We can now see below a little sample of rows from our file. On the bar dividing the top and bottom of the screen, there are a bunch of really useful bells and whistles. The first two buttons on the left allow you to toggle back and forth between the table view of the data sample and a list of info about the columns. I like this view a lot because I can easily rename the columns this way, and I find it easier to see what each columns data type is. The hash symbol indicates a numerical column. The calendar indicates a date, and Abc indicates a string. There are many other data types available, as you'll see later in the course in specialization. Let's do some of that minor cleaning now. First in the ListView, not the table view, double click the column name, date of incident, and change it to just date. Then press Enter. Let's also change Victims sex to Victim sex. And Victims age to Victim age. The drop down to the right of the table, and lists toggles allows you to sort what is showing. Either the table rows in table view, or the column names in the list view Now let's check out the upper right, where we can add filters that apply to the whole data source. Filtering out the data here actually reduces the file size of the extract, which can really help performance if you have a lot of data. And of course save space on your computer and Tableau public servers. For example, one of those gotchas I mentioned earlier is when you have total rows in your data, Tableau is perfectly capable of totaling the data for you. So you should filter those out here to make your life easier later. And to make sure you're not over counting anything. So now that we're done with our minor cleaning, we're ready to finish the import. In the lower left of the screen click on the highlighted sheet1, this is the Tableau sheet not the Excel sheet. To exit the data source screen and go to the work sheet screen. And now that we finished the import, we want to save so we can pick back up next week. To save to Tableau public server. As we must do, we can't actually publish an empty workbook. So go ahead and click and drag number of records out onto the sheet where it says, Drop field here. Now that you no longer have an empty sheet, go to File and Save your workbook to your Tableau public profile. It defaults to being hidden, so the only way people can find it, is if they have been given a link to it. I'm going to give it the fancy name of, Data Visualization With Tableau. And save it. And voila, you've imported data into Tableau, done a wee bit of cleaning and then saved a really rudimentary workbook to Tableau public. Great job.
