Hands On Training

Power Query Fundamentals Case Study

via

Corporate Finance Institute (CFI)

Course Features

Duration

1.5 hour

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Advanced

Teaching Type

Self Paced

Video Content

1.5 hour

Course Description

Examine the strength of your Power Query problem-solving skills with this brief case study based on challenges. From simple table manipulations up to more challenging problems that require dynamic solutions This case study will test a variety of abilities and strategies. Each challenge is presented with an outline of the requirements then a review of the best techniques, tips and tricks that help students to enhance their skills. Learning to master Business Intelligence is all about practicing. The Power Query challenge was designed to create exactly that kind of environment.

Course Overview

International Faculty

Case Based Learning

Post Course Interactions

Case Studies,Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Column splitting functions to extract data

Problem-solving dynamic scenarios with header rows

Problem-solving using grouped rows

Solving logical scenarios with conditional columns

Switching layouts by pivoting data

Extracting data from Excel and CSV files.

Target Students

If you have completed the Power Query Fundamentals course, or feel that you have a good grasp of Power Query functionality, this course is an appropriate next step for you to practice your skills.

Course Content

Expand all sections

Module 1: Introduction

Module 2: Grouping Rows

Module 3: Stacked Data

Module 4: Extracting Data

Course Instructors

Sebastian Taylor

VP, BIDA

Seb started his career in risk management, managing the implementation and operations of quantitative energy hedging strategies. Having since worked in several different industries, from finance to r...