Realdolmen Education

Details

Excel Power Query and Power Pivot

This course is currently not scheduled on the open calendar, but can be organized on request.

Request Course

Duration

0.5 day(s)

MS Excel: Using Power Query and Power Pivot to analyze data

Duration

0,5 day

Audience

This course is aimed at users who want to process large amounts of external data in well-arranged Excel reports.

Prerequisites

A knowledge of basic Excel skills (input and edit data, use functions and formulas) is required. Being able to create, edit, sort and filter Excel tables. Being able to create and edit Pivot Tables and Pivot Charts.

Objectives

Learn to use Power Query and Power Pivot.

Methods

An interactive hands-on classroom-based training.

Description

Users can work with Pivot Table to analyze figures rapidly and efficiently. In Excel, the Power Query and Power Pivot tools can be used to use external data as the basis of PivotTables, charts, ...

We start with a brief introduction to relational databases. Then we learn how to use Power Query to analyze external data in Excel. Finally, we learn how to create a Power Pivot model based on external data sources and dynamic Excel tables, and how to use a Power Pivot model as the basis for PivotTables in Excel.

Contents

  • Introduction
    • What is Power Pivot? What is Power Query
    • Excel database principles
    • Excel database vs. relational database
  • Power Query
    • Link with external sources
    • Transform data
    • Combine data sources (Merge & Append)
    • Use data
  • Power Pivot
    • Start Power Pivot
    • Explore Power Pivot screen
    • The 4 elements of a Power Pivot model (input, calculations, output, variables)
    • KPI
    • Using the data model in Excel