FR
EN
LU
DE
Details
Goals
Learn the basics for Power Query and PowerPivot
Prerequisite
Good Excel knowledge, especially PivotTables.
Contents
PowerPivot
- Introduction to relational schemas
- Connect to multiple sources
- Create relationships between data sets
- The PowerPivot window
- View the relationships diagram
- Add a calculated column
- Add a calculated measure
- Create a KPI
Power Query
- Introduction to Power Query
- How to connect to a data source
- Modify the data to better fit your reporting needs
- Append tables
- Merge tables,
- Create calculated columns,
- Use data from Power Query in PivotTables
- Use data from Power Query in PowerPivot
Sign up
Next session(s)
Need a custom training?
None of the trainings fit your requirements? You have specific needs? Key Job trainers are versatile and flexible. Contact us!