MS553

Power Query and the M language

  • Duration 1 day
  • Regular fee 510
  • Preferential fee 460?
  • Locations
    • Montreal
    • Quebec City
  • New course
  • Laboratory
    course
SUMMARY
DETAILS

Objectives

Power Query is a tool that will greatly simplify data processing and allow you to replay data manipulation scripts after each update without having to be familiar with the programming language.

Targeted audience

Advanced user of Excel 2010-2016 and Power BI Desktop.

Prerequisite

Knowledge of SQL Server is not required. Ideally, participants should have basic knowledge of database terminology such as tables, views, columns, rows, relationships, etc.

Content

  • Interface: Integration into Excel
  • Interface: Integration into Power BI
  • Importing simple data
  • Combining tables
  • Importing all files of a folder
  • Importing from a database
  • Importing row data
  • Transposing data
  • Importing an unstructured text file
  • Understanding different types of data
  • Grouping data by operation
  • Working with multiple queries
  • Choosing a data destination
  • Refreshing data
  • Sharing queries
  • Discovering the M language through formulas
  • Understanding the M language
  • Creating your own functions

DATES*

*Unless stated otherwise, all sessions are in French.
  • Montreal

    January 18 2019

  • Quebec City

    March 29 2019

Trainer(s) assigned(s)

Other course(s) in this category