Revealed: Power Query Advanced Tips And Tricks

Revealed: Power Query Advanced Tips And Tricks, available at $49.99, has an average rating of 3.9, with 37 lectures, 1 quizzes, based on 117 reviews, and has 549 subscribers.

You will learn about Create data analytics like world-class companies Executive Case Study: you will clean, analyze and document a project data set ; includes video instructions and downloadable Excel file solutions to insure you're learning Write If-Then-Else statements within conditional columns and create embedded functions in custom columns Reference the Power Query Formula Language to find and use unique functions to transform your data Build using the 'M' language Advanced Editor and Query Manager to control your processes and work faster This course is ideal for individuals who are Those who want to learn an in-demand business skill and increase their career opportunities or Those who want to improve their data analytics and Power Query talents or Those who are willing to try Power Query in new ways It is particularly useful for Those who want to learn an in-demand business skill and increase their career opportunities or Those who want to improve their data analytics and Power Query talents or Those who are willing to try Power Query in new ways.

Enroll now: Revealed: Power Query Advanced Tips And Tricks

Summary

Title: Revealed: Power Query Advanced Tips And Tricks

Price: $49.99

Average Rating: 3.9

Number of Lectures: 37

Number of Quizzes: 1

Number of Published Lectures: 37

Number of Published Quizzes: 1

Number of Curriculum Items: 40

Number of Published Curriculum Objects: 40

Original Price: $59.99

Quality Status: approved

Status: Live

What You Will Learn

Create data analytics like world-class companies
Executive Case Study: you will clean, analyze and document a project data set ; includes video instructions and downloadable Excel file solutions to insure you're learning
Write If-Then-Else statements within conditional columns and create embedded functions in custom columns
Reference the Power Query Formula Language to find and use unique functions to transform your data
Build using the 'M' language Advanced Editor and Query Manager to control your processes and work faster

Who Should Attend

Those who want to learn an in-demand business skill and increase their career opportunities
Those who want to improve their data analytics and Power Query talents
Those who are willing to try Power Query in new ways

Target Audiences

Those who want to learn an in-demand business skill and increase their career opportunities
Those who want to improve their data analytics and Power Query talents
Those who are willing to try Power Query in new ways

3rd in my series of Udemy courses on mastering data cleaning in the age of big data

Every day is a training day for your next job opportunity. Prepare by making data transformations that are simple to use and quick. People notice, and you will have a solid career. Microsoft has the right tool for this. It’s called Excel Power Query. Want to use it like a pro?

Advanced Excel Power Query Will Strengthen Your Data Analytics Career

‘Learn by doing’ with downloadable exercise files, step-by-step video demonstrations and three-part ‘Case Study’ assignment that reinforces the knowledge you gained
Custom columns, the Power Query Formula Language (‘M’ code), embedded functions and much more
Dozens of tips & tricks focused on Power Query’s best features

Control Your Data Instead Of Letting It Control You

I designed this course for data users of all levels. There is something here for everyone. We’ll solve some of the most common data cleansing problems encountered by data analysts. You’ll walk away with first-rate knowledge valued in the job market. It’s essential for developing your data career.

Companies are moving to Excel Power Query for next generation data analysis power. Let me prepare you for the career that companies need.

By taking this course, you will say “Wow. It didn’t know I could do that with Power Query!”

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the fun

Lecture 2: Data career thoughts

Lecture 3: My Power Query beliefs

Lecture 4: A few words about this course

Lecture 5: All about the exercise files

Chapter 2: How To Get The Most From This Course

Lecture 1: What you need to know

Lecture 2: Versions of Excel that run Power Query

Lecture 3: How To Install (Or Update) Power Query

Chapter 3: How to Use Power Query: Do More In Fewer Steps

Lecture 1: Look for patterns

Lecture 2: Why fewer steps are better

Chapter 4: How to Use Conditional & Custom Columns

Lecture 1: Conditional & custom columns overview

Lecture 2: Conditional columns basics

Lecture 3: Conditional columns – training exercise

Lecture 4: Conditional columns – training exercise solution

Lecture 5: Custom columns basics

Lecture 6: Custom columns – training exercise

Lecture 7: Custom columns – training exercise solution

Lecture 8: Differences and similarities (conditional and custom columns)

Chapter 5: How to Use Manual Queries

Lecture 1: Good – Manual queries

Lecture 2: Manual queries – training exercise

Lecture 3: Manual queries – training exercise solution (1 of 2)

Lecture 4: Manual queries – training exercise solution (2 of 2)

Chapter 6: How to Use Advanced Queries

Lecture 1: Functions and formulas

Lecture 2: Finding functions #1 – Power Query formula reference

Lecture 3: Finding functions #2 – reference sheet

Lecture 4: Finding functions #3a – formula bar (=#shared)

Lecture 5: Finding functions #3b – custom query

Lecture 6: Finding functions #3c – follow along

Lecture 7: Finding functions #3c – share across workbooks

Chapter 7: How to Use Waterfall Queries

Lecture 1: Waterfall queries

Lecture 2: Waterfall queries – more examples

Chapter 8: How to Take Advantage of 'M' Code

Lecture 1: How to read 'M' code

Lecture 2: Rename your steps to simplify 'M' code

Lecture 3: Add comments to your 'M' code

Lecture 4: Query Manager in Query Editor

Chapter 9: Case Study (Assignments)

Lecture 1: Part 1 – Clean Your Data

Lecture 2: Part 1 – Clean Your Data Solution

Instructors

Doug Burke
Financial Systems Leader and Experienced Teacher

Rating Distribution

1 stars: 5 votes
2 stars: 4 votes
3 stars: 21 votes
4 stars: 40 votes
5 stars: 47 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu