PowerQuery M code language Part2 (5 hours)
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.
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.
Instructor
- 4.5 Instructor Rating
- 1,579 Reviews
- 7,666 Students
- 42 Courses
I have been teaching online from 13 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.