All organizations have data, sometimes very large. They are valuable sources of information when you are able to leverage them. Excel's PowerQuery and Power Pivot add-ins can help you make the most of your data to make informed and objective decisions. Reading data is also the door to unexpected findings that will improve efficiency or performance. During the training you will see how to import and process data with Power Query, how to model it with Power Pivot and how to analyze it with Excel pivot tables.
Objectives
At the end of the training, the participant will be able to use data using Power Query and Power Pivot.
Is it for you ?
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 tables
Your benefits
Content
Power Query Editor:
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
Power Pivot editor:
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)
Power Pivot Tables
Notes
This training will not cover the M language of Power Query
💡 Useful information
Our training sessions are offered in Montreal or Quebec City, in person or in virtual format. Dates and locations are provided when you select your session below. If you have any questions regarding registration, schedules, the language of instruction, or cancellation policies, please consult our FAQ .
Trainers
Private or personalized training
Do you have several employees interested in the same training course? Whether in person at your offices or remotely in virtual mode, we offer private training courses tailored to your team's needs. Group rates are available. Contact us for more details or request a quote online.
Request a quote