PowerQuery M code language Part2 (5 hours)

Name: PowerQuery M code language Part2 (5 hours)
Rating: 4.5 (147 reviews)

Powerquery Mcode, Data clearning, data transformation using M code functions, Practical case studies

Created byajay parmar

Last updated 4/2024

English

What you'll learn

You will learn about existing functions in powerquery - Real Project discussed.
How to create own functions and why we want them in M code world- Basics to Advance using real time based problems.
IF statements in detail from basic to advance. Like With single criteria to multiple criteria
How to tackle Errors in powerquery using Try and Catch method
Several projects which need great conceptual and analytical skills on the use of Table and List functions. Full on Fun.

Course content

1 section • 17 lectures • 4h 47m total length

What are we covering- A quick demo4:46
Let us take a quick look what are we covering in this M code Part 2.
From amazing projects to functions which includes user defined functions we are learning everything.
It is not for freshers. If you know M code or if you have seen Part 1 please go and check out this course. I bet you will not regret.
Introduction to IF FUNCTIONS7:02
Let us start with IF functions first. From basic to advance , you shall see in next IF function lectures that how much scope is there to play with data by using IF statements in m code window.
IF Functions Part211:08
IF Functions Part39:12
User-defined Functions - Create own functions - How and Why26:42
How about writing our own functions in PowerQuery. Different techniques (From simple to complex)
Leave the inbuilt Functions for a while and learn how do we develop our own functions
how to use or re-use the UDFs (User Defined functions)
Why are they so much important in PQ
User-defined Functions - Create own functions - How and Why - part217:23
User-defined Functions - Part349:03
Error handlers27:47
How do we control the errors when they appear in powerquery.
Let us see the try and otherwise statements and convert errors into meaningful messages.
A project for you- Top3 Salaries10:25
We are building a solution in this lecture which is giving us the Top salaries earned by employees.Through this project , we are not only learning more and more but revising the things so far done in Part1 and Part2
Super Project for you - Avoid irrelevant rows Example122:09
If you like to remove the undesired rows from powerquery in a dynamic fashion - how can we do it.
A project for you- How to avoid specific rows - its awesome36:47
Get Percentage of each column field- List functions use in a great Style10:44
A project or trick which will let you use single field value now. You can use it like a cell reference used in excel.
A project for you- Create Ranking for each of the category - So much learning8:52
What if we like to create ranking for different categories each time it appears in a data from serial no 1 to 2,3,4 etc.
This project is too good from knowledge perspective.
A project for you- Reverse and get the unique Author Books - Simple awesome15:49
What an incredible way to reverse the books rows with putting them in front of respective authors.
Introducing table.reverserows function
CountIF function - So much knowledge7:35
SumIF Function - More knowledge coming in your way13:59
Table Transform Column function - A boon to data analyst8:24
Quiz1
Quiz 2
Quiz3
Quiz4
Quiz5
Quiz6
Quiz7

Requirements

You should be well aware of M code because this course is not for beginners.
You may like to see part1 . This is a part2 in continuation to part1.

Description

This course is in continuation to M code part 1 which is already prepared by me. Course will not benefit if you do not know the M code . My advise is to first learn the basics in part1 and then continue with this part2.
We are talking about inbuilt M code functions which are very important in data trimming, structuring.
Functions related to dates and lists are being covered here which are the need to every data analysts while performing data trimming and data analysis.
We are learning about the User Defined functions (UDFs) as well. Why we need our own functions and how we can create our own M functions . How it helps in achieving the amazing results in few seconds without doing too much of the work.
Linking the excel inputs with powerquery using functions.
Discussion on IF functions is discussed in detail .
How we can handle the errors using try and otherwise error handler.
How to use Table transform column function which can save your tons of time, if you're planning to add extra columns with some conditions.
Interesting projects are also shared for real experience.
How to Create a ranking for each category
How to Get the unique author books
How to calculate the percentage of each column field.
How to avoid undesired, meaningless rows from the data.
Calculate the top 2 salaries

Who this course is for:

M code programmers who want to know more in -depth about M code functions and Data management.