Management
Star icon
Most Popular
Hands on Training icon
Hands On Training
Star icon
Hands on Training icon

Power Query Fundamentals

5

(3)

compare button icon

$41

Visit Course

Visit Course

Offer Percent Icon

2 Coupons Available

Login To View All

Course Features

icon

Duration

6 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

6 hours

Course Description

Power Query is a vital skill for Excel-focused analysts. It is also a valuable asset to Business Intelligence analysts. These skills will allow you to spend less time manipulating data and more time working on analysis projects.

This online Power Query Fundamentals course will teach you about data transformation and automation. Learn how to extract data from different sources and convert it into more suitable layouts for analysis. You will learn how to automate data connections, transformations, and how to extract and consolidate multiple files. We'll also discuss common mistakes.

Stop. Power Query will revolutionize your work.

You've probably worked with Excel data extracts and regular reports. If so, you know how tedious it can be to modify the layout, extract data, or lookup values from other tables. These tasks are repeated every week or monthly, depending on whether you receive a new report.

Stop wasting time manipulating data

Course Overview

projects-img

Personlized Teaching

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

check-card-img

There is no prerequisities available but having computer science degree is plus

What You Will Learn

check-card-img

Identify the characteristics of good and bad data using the principles of data normalization

check-card-img

Extract data from CSV and Excel files and automate basic transformations such as Pivot and Unpivot

check-card-img

Extract information from fields that combine two or more values

check-card-img

Transform datasets by grouping or combining data from different tables, or even multiple files from the same folder

check-card-img

Avoid, interpret and fix errors and exceptions that you experience in Power Query

check-card-img

Load transformed data into Excel for use as automated data feeds

Target Students

check-card-img

Business Intelligence Analyst

check-card-img

Data Scientist

check-card-img

Data Visualization Specialist

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

$41

Visit Course

Visit Course

Offer Percent Icon

2 Coupons Available
Get upto 10% Discount