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.
Overview
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.
Learning Outcomes
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.