Currently our citizen-developers manage their more complex multi-dataset analytics by creating a "dummy" workbook that has every relevant dataset in it, so they can use the "Data" tab to manage the blending for all other reports that use one (or more) of the datasets.

But as they continue to develop, anything new has the potential of breaking the current setup when auto-connections are built between datasets. This has been difficult for them to maintain.

There should be some kind of "dataset connection logic" in the Data tab where default logic can be built, and then workbook-specific logic can be created (using current setup) for unique use-cases.