MS401
Data and AI

PowerQuery and PowerPivot: leveraging your data to achieve your business goals

Process and model data to derive actionable information
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 tables
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
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
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

Request in-company 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.

Tell us more

Similar trainings

See all Data and AI trainings
Added to cart View my cart