Difference between Data Blending, Data Joining, RDBMS Source, File Sources, Oracle and Excel, SQL Server and Text Files, Cloud based Data, Inner Join, Outer Join, Left Outer and Right Outer.

Difference between ' Data Blending ' and ' Data Joining ' ?

Data Blending: Combining the data from two or more different sources is Data Blending. We can combine data between two more variety of sources such as Oracle, Excel, SQL Server and others.


Example: Combining the Oracle Table with SQL Server Table (OR) Combining Two Tables from Oracle Database (OR) Combining Two Sheets from Excel (OR) Combining Excel Sheet and Oracle Table and so on.


In Data Blending, each data source contains its own set of Dimensions and Measures.


Data Blending is useful when there is a need to combine the data from variety of sources such as Oracle, DB2, Sybase, SQL Server, Excel Files and others. We can NOT have common set of Dimensions and Measures which limits to create groups, formulas and other entities across the data.


Data Joining: Combining the data between two or more tables or sheets within the same Data Source is Data Joining.


Example: Combining Two Tables from the same Oracle Database (or) DB2 (or) Sybase (or) SQL Server and others. Combining two or more worksheets from the same Excel file.


In Data Joining, all the combined tables or sheets contains common set of Dimensions and Measures.


Data Joining is useful when there is a need to combine the data from single source but multiple tables or sheets and others, such as two or more Oracle tables or DB2 tables or Sybase tables or SQL Server tables or Excel Files and others. We CAN have common set of Dimensions and Measures which extends the ability to create groups, formulas and other entities across the data.


TABLEAU INTERVIEW QUESTIONS - INDEX

Differences between Tableau 9.3 and Tableau 10.0, 10.1, 10.2, 10.3 and 10.4 ( 9.x vs 10.x versions )

Differences between Tableau 8.3 and Tableau 9.2, 9.1, 9.0 versions ( 8.x vs 9.x versions)

Discuss Difference between 'Data Blending' and 'Data Joining'

Explain Tableau Architecture

MTD, YTD Reports using Tableau Table Calculations

Difference between RANK and INDEX

Types of Data Connections, LIVE vs EXTRACT (IN-MEMORY)

Difference between Individual, Dual and Blended Axis

Types of Filters Quick, Global, Context, At Source, On Dimensions and Measures

Differences between Tiled and Floating in Tableau Dashboard.

Custom Geocoding in Tableau.

Tableau File Types extensions .twb vs .twbx .tde .tdsx .tds .tbs

Tableau Automatic vs Custom Hierarchies Creation

Tableau Actions Difference Filter vs Highlight vs URL

Tableau Workbook Stories Dashboards Worksheets

Tableau Trend Analysis Forecast Models Difference

Summary of Tableau Desktop 9.2 new features (includes Tableau 9.2, 9.1 and 9.0)

Level of detail ( LOD ) expressions, Calculation,Cohort analysis