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.
- Import data from databases and text files
- Aggregate Excel worksheets
- Group and summarise data
- Transpose and unpivot complex data
- Automate refreshing
- Introduce Power Query formulas and the 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.