Multiple data sources or connections in Tableau? No problem!, s1117 скачать в хорошем качестве

Multiple data sources or connections in Tableau? No problem!, s1117

Book sample: https://www.amazon.com/Tableau-at-Wor.... https://www.tableauatwork.com/connect... Have you wondered how to connect to multiple data sources? Confused about the difference between a Tableau Relationship and a Join? In this tutorial, we move beyond the basics to master the four primary ways to combine data: Relationships, Joins, Unions, and Blending. Using our If-Then-Why™ methodology, you'll learn when to stay in the Logical Layer and when you need to double-click into the Physical Layer for row-level control. We also dive into Data Blending to show you how to link completely separate data sources using primary and secondary connections. Whether you are prepping for the Tableau Desktop Specialist exam or building complex business dashboards, this guide ensures your data stays accurate, and your views stay fast." https://www.tableauatwork.com/connect... 00:00 Welcome 01:00 Drag tables (worksheets) onto the canvas. This is the logical layer. 01:00 Add second table 01:13 Orange line - Relationship 02:32 Data Pane with fields from the two tables 03:15 Relationships handle different aggregations 03:57 New file to create a join 04:14 Move from logical layer to the physical layer 04:26 In the left pane there is a choice for a New Union 04:46 Drag the second table onto the physical layer 05:00 Icon indicates an inner join was created 05:00 Click the icon to change the type of join to left join, right join, or full outer join 05:31 Right join introduced null values 05:51 With a left join there are now two rows of data 05:58 Close the physical layer window to return to the logical layer 06:36 Hide a field in the data pane 07:05 Add the Measure Names field to the Columns shelf and the Measure Values field to the Text tile on the Marks card. 07:17 A new Tableau workbook so we can look at a blend 07:43 Add a second data source 08:00 When I click the drop-down for the cylinder icon, you can see two data sources 08:05 Can’t create a join between two data sources 08:10 Combining the data from two data sources is done on a worksheet 08:16 This is like two data sources on a Tableau server 08:29 At the top of the Data pane, there are two data sources shown 08:49 The selected data source has a light gray background,d and a blue checkmark indicates that it is the primary data source 09:08 Add fields from the secondary data source to the view 09:20 Null values are added for fields that didn’t have related data 09:30 The QTY field on the Text tile has a brown checkmark indicating it’s from the secondary data source 09:39 At the top of the Data pane, there is an orange checkmark indicating that it is the secondary data source. 09:50 When the secondary data source is selected, Measure Names and Measure Values are grayed out. You can only use those fields from the primary data source. 10:15 Edit Blend Relationships on the Data menu. 11:39 Close the data source 12:14 Add a second connection within the same data source 12:43 Add a second table from the second connection as an inner join on the physical layer 13:13 Remove the second connection 13:54 Can’t combine two tables from two data sources within the Data Source canvas. You can’t do joins on different data sources. It can be different connections within the same data source, but it has to be the same data source 14:37 A new workbook for the People.xlsx file (to demonstrate row-level security) 15:00 Add a second connection to a different Excel file and worksheet. 16:27 Edit an existing connection to point to a new Excel file. I'm excited to share these video insights with you! They're inspired by my book, 'Tableau at Work.' If you find them helpful, consider grabbing a copy here: https://www.routledge.com/Tableau-at-... to support the channel and deepen your learning. #datafam #b2vb #tableau #TableauTraining #TableauTips #datavisualization