Create Separate Excel Version Optimized for Power Query (ETL)
Create a "stripped" version of Excel or stand-alone version that is optimized for Power Query and focused on ETL tasks. This version would remove many traditional Excel features to free up resources, allow engine optimization, and expand current PQ capabilities.
Microsoft has a definite need of a high power data ETL tool and right now I am forced to use multiple Excel files to break up ETL tasks by having them reference the previous file in the chain (my company will not support other more expensive/specialized tools).
This finished file can then be used as a data source in regular Excel for Pivot Tables,graphs, etc.
We need more speed, more automation options, and a system that can handle more data transformations before performance is severely impacted.