Data in two excel files is imported to Tableau.

SalesData excel files has Fact Tables (2 sheets)

Dimension Tables excel file has Dimension Tables (4 sheets)

Redundant rows are removed using Data Interpreter

Order ID needs to be splitted. The first two letters are country, the four digits in the middle is year, and then an ID. We may hover the mouse on the header and then split, or may create a calculated column using SPLIT([OrderID],'-',1) formula where '-' is the delimiter and rename the new calculated column to Country of Manufacture. In the new column, we may assign Canada as Alias for CA, and United States as Alias for US.

Now, it is time to JOIN tables. There are 4 types of JOINs. JOIN is done between Fact and Dimension Tables

INNER JOIN

LEFT JOIN

Right JOIN

OUTER (FULL) JOIN

Fact Tables needs to be dragged to the Canvas and UNIONed. When it is clicked, we are navigated to physical layer where Dimension Tables can be dragged and physically JOINed to the master Fact Table. The details of JOINs and UNION are

On top of JOIN, we need to combine two Fact Tables into one because they have identical headers. This is done by UNION.