Evaluating Power Query in Excel 365

Evaluating Power Query Usage in Microsoft Excel Is Power Query a viable component in a fully automated Microsoft Excel 365 Solution for Business? If so, in what capacity?  How far do you take Power Query; how do you leverage its POWER. Let's find out, via a few examples   What is Optimal Usage of Power [...]