when to blend and when to join based on your data and desired analysis It is generally preferable to avoid data blending when you can combine the two data sources outside of Tableau. If this is not an option, then you must identify at least one common variable shared by the two data sources you want to blend together. When possible, go for a join rather than a blend. If you need to combine two data sources and for whatever reason cannot manage to join the data outside of Tableau, your only option is a data blend. You can only use joining when your data comes form the same underlying source (for example, the same Excel file or Access file). If the data comes from different underlying files you will not be able to do a join within Tableau. I recommend preparing your data before importing it into Tableau (there are many great tools available, one being Alteryx, that can help with this). In my opinion blending and joining in Tableau should be a last resort for times when you are unable to shape your data into one coherent file for analysis. Joining your data can only be done when the data comes from the same source, for example from two sheet tabs within a single Excel file. If that same information was stored in separate Excel files you would need to do a data blend in Tableau. A blend is always required if the data is stored in two separate "data sources" within Tableau. So even if your data is very closely related and exists in two separate files or databases, you will have to do a data blend if you are combining the data in Tableau. When blending data, the first data source used in your view will dictate how your worksheet view in Tableau is built. The secondary (blended) data source will be able to contribute extra information, but will not be able to change the overall structure of the view. The secondary data source's values can be aggregated and applied to the existing view after you have established a "relationship" by assigning a variable that both the primary and secondary data sources have in common.
Views: 17921 Technology mart
In this video shows the process of distribution and publishing tableau reports very easy manner. Options for publishing and sharing Tableau workbooks and dashboards Tableau Server/Tableau Online Tableau Mobile Tableau Desktop Tableau Reader Tableau Public Sharing an image When determining the best option for publishing and sharing, you’ll want to take into account the following criteria: Device types used by your intended audience Whether users can install client-based software Whether the audience needs to edit or change the workbooks Your access to Tableau Server Licensing needs and the cost of them Security requirements 1. Tableau Server and Tableau Online are great options for publishing and sharing Tableau content. Tableau Server provides browser-based analytics without the need to download software. Tableau Online is the hosted SaaS version of Tableau Server and can also be used to publish and share dashboards and workbooks. If the Tableau Server administrator has granted the appropriate permissions, users can share their Tableau content from within Tableau Server. With Tableau Server, content can be organized into sites, projects and groups; providing a better collaboration environment. Content can be shared via the share icon in Tableau Server (shown below). The share icon can be used to email a link to the workbook or embed a URL on a web page. Users can then access the published Tableau content via a web browser. Users can also subscribe to workbooks or worksheets published on Tableau Server. These workbooks can be set up for automatic refresh, ensuring the latest view of the data. If end users are given edit permissions, they can make changes within Tableau Server's web authoring environment. As is the case for Tableau Mobile, users accessing this content will need the appropriate Tableau Server or Tableau Online license. 2. Tableau Mobile is an extension of Tableau Server that runs on mobile devices including iPads, iPhones, Androids and Chromebooks. This product can be used to view workbooks, worksheets and dashboards stored on Tableau Server or Tableau Online (the hosted version of Tableau Server). Tableau Mobile can’t open packaged workbooks in TWB or TWBX format (packaged workbooks). Users connecting to Tableau Server via Tableau Mobile require a Tableau Server or Tableau Online license. With Tableau Mobile, iPad users can view dashboards and workbooks published to Tableau Server, and if they have the proper permissions, they can edit them and create new worksheets using iPad native touch and drag capabilities. Content on iPhones, iPads, Chromebooks and Androids is fully interactive with regards to filters and dashboard/worksheet actions. The Tableau Mobile app is available to download from the Apple App Store and from Google Play. 3. Tableau Desktop is the most flexible option for sharing Tableau content. This product allows content editing, viewing and sharing. Tableau Desktop is available to download on Microsoft Windows and Mac, and provides a comprehensive authoring and viewing environment. In Tableau Desktop, users can open Tableau packaged workbooks, and connect to workbooks published on Tableau Server. One advantage of Tableau Desktop is that it allows for capabilities not present in Tableau Server, such as publishing, editing and creating new data sources. Because it is the most full-featured option, Tableau Desktop is the most expensive from a licensing standpoint. 4. Tableau Reader is a free option for viewing Tableau workbooks and dashboards created in Tableau Desktop. This product is fully interactive with regards to filters, tool tips and parameters. Tableau Reader only works with packaged workbooks (TWBX format). This means that the Tableau workbook and the data for the workbook are packaged together into a TWBX file, which could be an issue with security and/or file sizes. Tableau Reader can’t open Workbooks published on the Tableau Server. Tableau Reader can be downloaded from Tableau.com or the Tableau Public website and is supported on Microsoft Windows and Mac. . Tableau Public is another free option for viewing Tableau workbooks. Like Tableau Reader, Tableau Public is an installed application available for download from Tableau.com or the Tableau Public website. Tableau Public can be used to open local workbooks or workbooks on Tableau Public. Tableau Public is close in functionality to Tableau Desktop, and workbooks can be saved locally (see below for tips). Still, using a public tool and connecting to a public website can present a data privacy issue. But for workbooks with non-sensitive data, Tableau Public may be a valid option. 6. For sharing content that does not need to be interactive, you can create a static image to view Tableau content in one of the following ways: To create a BMP on Windows or a TIFF on a Mac Worksheet Copy Image On MS Windows, save the image as Enhanced Metafile (*.emf) Worksheet Export Image OR You can publish one or more.
Views: 375 Technology mart