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.
Duration
1 day
Schedule
9h to 16h
Regular fee
$625
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$560
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
Power Query Editor:
Query and data processing editor (Connect to data, Transform data and load processed data into Excel and/or Power Pivot).
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)
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
Pedagogical details
Training architecture
Course with practical exercises and specific situations
Type of training
Skill development
Skill development and knowledge integration
Decision support
Basic knowledge
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 quoteDuration
1 day
Schedule
9h to 16h
Regular fee
$625
Preferential fee
A preferential rate is offered to public institutions, to members of certain professional organizations as well as to companies that do a certain amount of business with Technologia. To know more, please read the "Registration and rates" section on our FAQ page. Please note that preferential rates are not available for online training courses. Discounts cannot be combined with other offers.
$560
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 quote