Microsoft is finally giving businesses what they really want: data types based on their own customer data.

TL;DR Key Takeaways : Power Query simplifies data consolidation by automating the process of combining Excel files with inconsistent sheet names, reducing errors and saving time.

Excel isn't going away, but it's going to stop accumulating extra tools like barnacles. Instead Power BI Desktop will become the self-service analytics hub.

Microsoft is leveraging its Power BI service to act as the connector to bring sources of data into Excel data types on the commercial side, allowing businesses to connect up a variety of data.