Question 1
How can I link 4 to 5 slicers from various data source to have one central slicer controller. Keeping in mind the data used is coming from a SQL data source which needs to be refreshed daily. This particular slicer should be able to accommodate weekly changes without changing the framework of the pivot created.

Question 2:
Using Power pivot how can you create relationship connections that allow many to many connections.