Multiple Fact Tables Reconciliation

Looks like you just need to perform a few Merges in Power Query editor. Just merge all into 1 table using WorkerID, and for table 4, probably use FirstName combined with LastName.

BUT...one thing you need to be aware off, depending on the granularity of those tables, a merge may not be the right thing to do. Ideally (and simplified), 1 fact table should have 1 grain and address 1 business process..

If you have multiple grains and processes, it is fine to not merge all of them. You can still use a dimension ( example is you date table), to connect (relationship) to all the tables. This way you can still visualize all information from the different tables, based on your date selection in the date table.

If you need to filter by worker/firstname/lastname, create a dimension for workers. And relate this to all the tables.