Welcome to the most exciting and educational article on M code introduction. If you are a data enthusiast, then one or two skills in data analytics are not enough and you should always look forward to learning more skills to make yourself better competent in the data field.
Many students ask me what is the M code in power query and why do we need to learn when the work can be done through power query itself. You are lucky if your work can still be managed by Powerquery because real world of data reporting is not so soft and straight. I have personally seen especially in IT/Telecom/Bpo sectors where the data is so huge and it is never in the structured form. It’s always a super messy data -the most cruel data and while dealing with this type of data you will face many difficulties to restructure it , to transform it into a meaningful data. That is where you find even Powerquery is not helpful.
This is where you will need to use M code which is the enhanced version of a power query.
Let me give you one example. You know as we’ve VBA in excel to automate data , in the same way power query has M code through which we can do super powerful data transformations easily but note Mcode has no similarities with VBA technically. Both are very different but both helps in data transformation in their own way.
Topics we are covering in it.
-
What is the M code in PowerQuery.
-
Why M code is also called a Functional Language.
-
What is an Advance Editor.
-
Rules to remember in Mcode
-
How to write M code (Data transformation to a new level)
Sir I must admit that you have poured your heart out while explaining. Like you did explain even a tiny things like “,” though this is minor thing in seeing but has potential to ruin the whole written code….
Thank you so much for showing so much dedication while explaining every concept in depth.