With Power Query discover, connect to and import data into Microsoft Excel. Then, using PowerPivot, remodel and enhance the imported data by writing queries through Power Query ‘M’ language.
Participants should be able to:
- Connect to a variety of data sources and extract data
- Clean and load the data into PowerPivot
- Understand basic Power Query formulas.