Remote training Excel Power Query: Importing and editing data with Power Query

  • Course types: Open webinar / Custom webinar
  • Duration: 1 day
  • Price: € 0 VAT excl. / Cheaper course?

Description

You often have to re-edit the data you enter into Power Pivot: splitting up the text into different columns, converting text to upper case, adding extra columns with certain calculations, filling up blank cells and much more. This means that you cannot use certain sources straight away, because you first need to delete unnecessary information. Or because that information has a different layout. With the aid of Power Query you can get around these problems without difficulty. You input the data, define what is to be done and then enter the optimised data, in Excel, or in the Power Pivot data model. And this without programming in VBA!

Choose a date and location

Objectives

After this remote training, you can easily:

  • Input different data sources in Power Query
  • 'Mould' data so that it is ready to be analysed
  • Load data into Excel or in the PowerPivot data model

Target Group

Anyone who ends up having to re-edit data before it can be used in Excel or in PowerPivot .

Prerequisites

A sound knowledge of Excel is required. Knowledge of PowerPivot is not required.

Content

  • Where is Power Query in the Power BI story?
  • Importing data from different sources (text, all files in one folder, Facebook, SQL, Excel, Mail…)
  • Converting data (American/European format, changing data types, eliminating duplications, removing records, filtering, standardising, aggregations, filling blank cells)
  • Adding columns (calculations, merging columns)
  • Expanding tables with data from other tables (compare Vlookup)
  • Comparing tables (what is common to all?, only in Table 1?, all of the tables)
  • Merging similar tables (arranging horizontally)
  • Introduction to the M-formula language to write more powerful queries
  • Loading the query into Excel or the PowerPivot data model

Choose a date and location

  • Dates
  • Days
  • Timing
  • Language
  • Location
  • Planning
  •  

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Practical info

The practical info and applicable cancellation conditions related to this training course.

 

Choose a date and location

€ 0 VAT excl.
Cheaper course?

Requesting a quotation

Would you like to organize this webinar for your employees? We transform your requirements into the perfect solution.

Request

Discount

SEVERAL PARTICIPANTS
If you enrol several employees for the same course on the same date, you will get a discount:

  • 2 employees: 15% discount on the 2nd subscription
  • 3 or more employees: 15% discount on the 2nd subscription and 40% on further participants

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com