Careervira Logo
Careervira Logo

USD $

Courses

Roles & Skills

Lists

Learn Paths

Career Paths

Management
Star icon
Most Popular
Trending Arrow Icon
Trending
Hands on Training icon
Hands On Training
Star icon
Trending Arrow Icon
Hands on Training icon

Power Query Fundamentals

Course Cover
Corporate Finance Institute (CFI)

5

(3)

compare button icon
Course Report - Power Query Fundamentals

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

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

Case Studies,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

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

What You Will Learn

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

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

Extract information from fields that combine two or more values

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

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

Load transformed data into Excel for use as automated data feeds

Target Students

Business Intelligence Analyst

Data Scientist

Data Visualization Specialist

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course FAQs

Do you have the Excel files and financial modeling templates that I need to download?

What is the time commitment to complete the courses?

Is CFI officially accredited?

Are there additional costs or fees?

Which currency are your courses listed in?

How can I earn my certificates?

These courses will help me to advance my career?

Do you allow me to email the instructor with any questions?

How much is the subscription price?

What's included in the subscription?

Have more questions?

Course Cover
Home
Search
Wishlist