Power BI serves analysts today with industry-leading data preparation capabilities using Power Query in Power BI Desktop.

With the addition with Power BI dataflows, this great tool now adds self-service data preparation capabilities into the Power BI online service, and significantly expanding the capabilities