It is possible to perform set analysis using PowerPivot. What I mean is, In SQL Language, can I do Union, Except, Intersect OR do Inner Join, Left Outer Join between different Pivot Table ? Finally trying to get all the data in a form of Venn Diagram.
In PowerPivot, you are establishing relationships between tables (from a base table to a lookup table). As such, you are not really performing set operations over the datasets. However, you can do this as part of the data loading process you execute
to retrieve data into the Vertipaq engine. Also, you can compare datasets to find out common keys across tables, or keys that are missing from a table, for example. You would do this purely in DAX, and though it allows you to find,
for example, the keys that belong to the intersected population or rows among two tables, it won't produce the same behavior as the TSQL intersect (which outputs one resultset)