PowerQuery M code language Part2 (5 hours)

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

PowerQuery M code language Part2  (5 hours)
PowerQuery M code language Part2 (5 hours)

PowerQuery M code language Part2 (5 hours) free download

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