Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
5 Hour(s) 7 Minute(s)
Language
English
Taught by
ajay parmar
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
2 views
Course Overview
Data cleaning and structuring using Powerquery M Code
Please note that if you have seen previous Parts of M code series then only it will be a fun and clarity. This part 4 is not for beginers . If you know how to use lists, functions and how to write syntax in m code, pls go ahead and take this course.
M code Part4 is talking about List.genrate function and how to use it as a function in real life plus other functions also in focuss.
Introducing the list generate function in M code.
What is a list generate function and how its parameters work
What is the initial parameter, what is the conditional parameter and execution parameter?
How to use list generate function using two variables or even more than two variables and how to know the number of variables we have to use.
We have started from a beginning and have tried to explain the Concept of this function is clear step by step.
There is a 4th hidden parameter which students never see and infact , even they know they don't know how to use it and what is the use of same.
What is the role of an optional parameter in list generate function and how does it work.
How to know where do we use square brackets , commas especially in a code where it is using data.
How to convert list generate into a function which takes inputs and then connect it with the real data
Table sort function in real data
Table select column function
Table select rows function
How to combine two columns in a sequence using Mcode interface.
How to approach a problem - with function and without function - which one is better
Course Content
- 2 section(s)
- 21 lecture(s)
- Section 1 Introduction
- Section 2 Project using List Generate - Concatenate the columns pair
What You’ll Learn
- This is M code Part4 and this course will provide the information on List Generate and List Buffer type of functions
- This is an advance level and one should already know M code very well, especially about Lists and table functions.
- You will learn how to use recursive functions like a loop which can take different inputs every time it runs.
- Advance functions for data analysis and data structuring
Skills covered in this course
Reviews
-
AAlamir Alshafaey
Good Teaching I like it . Simple Way. Thank you
-
MM B
Yeah, at last I understand better List.Generate ! Thanks for your expertise.
-
BBhaskar Joshi
I greatly appreciate the instructor's expertise in explaining the Power Query M Code structure. However, there are a few areas that could be improved: 1. The editing seemed rather basic, and the screen wasn't sufficiently zoomed in, making it a bit challenging to follow along effectively. 2. The video quality was limited to 720p (expect the third last video), which resulted in a somewhat blurry experience when viewed on a laptop/desktop. 3. The lectures lacked engagement; incorporating PowerPoint presentations or video animations could have enhanced clarity and engagement. 4. A prepared script for the course would have made the content more organized and concise, potentially reducing gas from the course duration by 50%. 5. Some content appeared redundant and could be omitted to streamline the course. Despite these points, I managed to complete all 4 parts of the Power Query series within just 20 days and found it to be highly valuable. Now, I feel confident in M code.
-
JJohn Hackwood
Very good practical Power Query course. I have found myself now editing in the advanced editor much much more and using functions where needed. Thank you Vijay you are a good teacher :)
