Data in the real world is messy and never available in the exact form that users need for their analysis or reports. Data Analysts need to spend a significant amount of their time working on data preparation, before the data is ready to be visualized and analyzed. Power Query, together with the Mashup Engine, provide a best-in-market experience for importing, reshaping and combining data from a wide range of data sources. This Power Query experience surfaces in a wide range of Microsoft products and workloads including Power BI Desktop, Excel, Analysis Services and Common Data Service for Applications. Furthermore, you can leverage the Power Query SDK to create Custom Connectors that can be easily plugged into Power Query in order to extend its capabilities. In this session, we will teach you everything you need to know in order to start leveraging these capabilities and taking data to the next level.

For more tips like this, check out the working remotely playlist at www.youtube.com/FoetronAcademy . Also, if you need any further assistance then you can raise a support ticket and get it addressed.