Overview

Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs – in an easy to use, engaging, and no-code experience. Supported data sources include a wide range of file types, databases, Microsoft Azure services, and many other third-party online services

Intended Audience

Anyone tasked with acquiring and preparing data for analysis

Duration

8 Hours

Prerequisites

Completion of ‘PB-101-Introduction to Power BI’ training

Course Outline

  • Introduction to Power Query
  • Importing Data
  • Power Query Language Basics
  • Parameters
  • Combining datasets
  • Adding columns
  • Transforming data
  • Formatting data
  • Advanced Power Query usages
  • Algorithms & R integration

Event Fee

($500 + HST): $565 (Group Rate: $2250 + HST for up to 12 participants. Please email at training@dstrat.com to book a dedicated group session)

Go to Top