From the course: Complete Guide to Tableau for Data Scientists

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

Solution: Creating a data source

Solution: Creating a data source

(upbeat music) - [Instructor] Here's our first task in our new role as a data analyst. We need to connect to some data, create a workbook that we can refer to time and again, set some defaults, and then finally answer some questions. So first thing we need to do is actually connect to our data. Now, for this purpose, we're going to use the land and hotel property order info. Now that's an Excel sheet that we've already saved into our data sources folder. So I'm going to click on the Excel connector going to find the hotel property order info. Now that this only has one sheet, Tableau automatically pulls it in for us. Now, in the data pane, we can have a little look at our raw underlying data. We can see we've got an order ID and an order date. We've got a property ID and a product ID and a product name. The products all belong to a particular category, and we have a quantity. So the size of each one of the orders, the product price or the price per product. And then the order total is…

Contents