{"id":370,"date":"2014-09-15T02:29:47","date_gmt":"2014-09-15T02:29:47","guid":{"rendered":"http:\/\/arunethan.com\/?p=370"},"modified":"2015-12-01T16:28:54","modified_gmt":"2015-12-01T16:28:54","slug":"tableau-data-blending-tips-and-best-practises","status":"publish","type":"post","link":"http:\/\/arunethan.com\/?p=370","title":{"rendered":"Tableau Data blending Tips and best practices"},"content":{"rendered":"

As of September 14th<\/sup> 2014<\/p>\n

Tableau data blending can be used to connect to two or more different data sources which contains related information.<\/p>\n

Examples: <\/span><\/h2>\n

Connecting the transaction information in Oracle DB server with the high level business information stored in Salesforce.<\/p>\n

Comparing the sales in states from a transactional system with the Sales projections stored in a excel workbook<\/p>\n

\"Data<\/a><\/p>\n

Primary data source is the data source, which we connect to when we create a new Tableau workbook(This is the default behavior, the data sources\u00a0added later can also be made as the primary data source using the Primary Data source drop-down as in the below screen shot) . We can add multiple secondary workbooks to it by adding new data connections to this workbook.<\/p>\n

Data > Connect to Data…<\/address>\n

Primary and secondary relationship can be customized by going to the Data tab<\/p>\n

Data > Edit Relationships…<\/address>\n
\u00a0<\/address>\n
\"Untitled\"<\/a><\/address>\n
\u00a0<\/address>\n
\u00a0<\/address>\n

The primary to secondary data source connection is always a LEFT JOIN (if right join behavior is required then the primary to secondary data sources must be switched)<\/p>\n

\"Untitled\"<\/a><\/p>\n

The data blending behaves well if only measures are pulled from the Secondary data source. If Dimension are required then it must be aggregated.<\/p>\n

i.e. If a measure like $ Sales is used from the secondary data source is used a SUM will be provided, if a dimension like Region is used then it must be aggregated to MAX(Region) or MIN(Region) function or other aggregation function.<\/p>\n

Avoid using Data blending if the data is present in the same Data source. Use the JOIN functionality provided in Tableau.<\/p>\n

\"rtaImage\"<\/a><\/p>\n

 <\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

As of September 14th 2014 Tableau data blending can be used to connect to two or more different data sources which contains related information. Examples: Connecting the transaction information in Oracle DB server with...<\/p>\n","protected":false},"author":1,"featured_media":371,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[59],"_links":{"self":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/370"}],"collection":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=370"}],"version-history":[{"count":4,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/370\/revisions"}],"predecessor-version":[{"id":378,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/posts\/370\/revisions\/378"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=\/wp\/v2\/media\/371"}],"wp:attachment":[{"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=370"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=370"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/arunethan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=370"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}