Microsoft Power Query: An Excel User's Dream for Data Extraction and Cleansing

Self Service BI (Business Intelligence) is all about users being able to access their data and build reports/dashboards to fit their individual needs.  Data cleansing is an important part of getting timely and accurate information. In this hour I'll be using Power Query to extract, cleanse, and combine data that will allow me to build an Excel Report or a Microsoft Power BI Dashboard.  The best part is that using Power Query, all my work is completely refreshable. 

Note: This presentation will be using data from Microsoft Dynamics GP, but the focus is on extracting data from SQL Server and using Power Query, NOT on the GP data itself. So this session is for all Self Service BI folks, not just GP users.