PowerQuery M code language Part2 (5 hours)

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

• 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