Collect & Transform Data Using Power Query in Excel & Power BI

The following is a list of available Collect & Transform Data Using Power Query in Excel & Power BI classes at ISInc. If you do not see the course you are interested in, please contact us. We can setup dedicated, online and onsite classes too! Minimum students required: 4, Maximum students: 15


Course Number: ISI-1522

Collect, combine and transform data

Description

Using Power Query you can import, reshape and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Power Query is embedded in Excel, Power BI and other Microsoft products. Discover how to eliminate time-consuming manual data preparation, solve commons problems, avoid pitfalls and more

Prerequisites

Before attending this course, students must have:

-Basic knowledge of the Microsoft Windows operating system and its core functionality.
-Working knowledge of relational databases.
-Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
-Basic knowledge of data analytics equivalent to having attended course 10994.

List Price

$1595.00