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 - Tableau Tutorial
From the course: Complete Guide to Tableau for Data Scientists
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
How to connect to Excel sheets5m 17s
-
(Locked)
How to clean Excel data with the Data Interpreter4m 17s
-
(Locked)
How to connect to Google Sheets6m 1s
-
(Locked)
How to connect to PDF files and extract tables of data6m 26s
-
(Locked)
Setting up the default properties of your data source5m 27s
-
(Locked)
Saving your data sources for future use4m 46s
-
(Locked)
Challenge: Creating a data source1m 18s
-
(Locked)
Solution: Creating a data source6m 42s
-
-
-
-
-
-
-
-
-
-
-