Bridge table (s)

I should also mention, the tables that I have brought in already don't contain data such as sales data or anything like that.  It more of only dimension tables really.  All the data in all the tables answers who, what, where, when, how. For example all the huge tables include only info such as: where is the geography, what is the market, brands, categories, dates to ship, who is person owning project, etc. 

So I took these tables in the data hub and extracted the common columns across all. Then I unioned them into one column for each of those dimensions.  The reason I did this was to create the bridge on building the relationships between all the tables.  And the reason I did this was because the raw tables are not separated by each project but rather by tabs on where the data was entered.  And some

of the tabs share common data (i.e. the tables I created).