With Power Query, discover, connect to and import data into Microsoft Excel. Then, using PowerPivot, remodel and enhance the imported data by writing queries through Power Query M language.

Overview

With Power Query, discover, connect to and import data into Microsoft Excel. Then, using PowerPivot, remodel and enhance the imported data by writing queries through Power Query M language.

Program Content

  • Import data from databases and text files
  • Aggregate Excel worksheets
  • Group and summarise data
  • Transpose and unpivot complex data
  • Automate refreshing
  • Introduce Power Query formulas and the M language.

Learning Outcomes

Participants should be able to:

  • Connect to a variety of data sources and extract data
  • Clean and load the data into PowerPivot
  • Understand basic Power Query formulas.
Program Number
976
Skill Level
Advanced
Duration

Half-day

Time
Dates
    Location

    AIM WA Floreat

    * Minimum numbers are required for program to proceed

    Make a Booking
    NOT YET AN
    AIM WA MEMBER?
    DISCOVER THE BENEFITS  

    Similar Programs