Objectives of the training
At the end of the training, the participant will be able to use data using Power Query and Power Pivot.Targeted audience
This course is designed for professionals who want to develop data analysis models in management and who want to get the most out of Excel using the Power Query and Power Pivot add-ins.Prerequisite
Knowing pivot tablesTrainers
Course architecture
Query and data processing editor (Connect to data, Transform data and load processed data into Excel and/or Power Pivot).
- Merge columns
- Add custom columns (calculated), columns from examples, conditional columns (if functions), etc.
- Sort data, Extract characters from a sequence, Shift, lowercase, etc.
- Replace values, rounding, statistics, etc.
- Depivot columns
- Combine queries
- Add queries
Modeling tool (DAX language)
- Power Pivot Diagram View: Creating relationships (cardinalities) between data tables (dimension tables and fact tables)
- Power Pivot data view: Modeling with the DAX language:
- Introduction to the DAX language (Data Analysis eXpression)
- Create calculated columns (Data View)
- Creating measures (Data View)
Pedagogical details
Training architecture
Course with practical exercises and specific situations
Type of training
Training Notes
This training will not cover the M language of Power Query
Private or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quotePrivate or personalized training
If you have more than 8 people to sign up for a particular course, it can be delivered as a private session right at your offices. Contact us for more details.
Request a quote