Power Query and Power Pivot in Microsoft Excel

Name: Power Query and Power Pivot in Microsoft Excel
Availability: InStock

Learn how to use Microsoft Excel’s Power Query and Power Pivot to model data in this free online data science course.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

Identify Power Query and Power Pivot as data modelling engines in Microsoft Excel
Outline the application of Power Query and Power Pivot tools in data analysis
Describe the advantages of the Power Query tool in data cleaning and task automation
Identify the arithmetic operators and logical functions used in Power Query
Select the appropriate Power Query operators and functions for your data analysis project
Analyse data via the performance measures and KPI features of the Power Pivot data model
List the key DAX query functions used for data analysis in the Power Pivot tool
Generate DAX query functions and logical statements for data analysis and manipulation
Create a single power pivot table using the tables obtained from multiple data sources

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.