Power Query M Language programming secrets to take you to the next level

[mitsumi]

Power Query M Language programming secrets to take you to the next level
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.35 GB
Genre: eLearning Video | Duration: 17 lectures (2 hour) | Language: English

About This Class

In this class, you will learn all the building blocks of Power query M language programming.

You will learn the following topics.

- Introduction to Power query M language

- How to rename & sort columns dynamically

- Secrets of List functions in power query M language

-Group by aggregation in M Formula language

- Error handling

- Secrets of record function in power query M language

- Nested let and variables in M language

- Dynamic table creation

Power Query M language is like an ETL for the data warehouse. It is used to transform the data before loading it into the power bi data model for ongoing data analysis.

You can also use ribbon on power query but it has limited functionalities that are not enough to work freely in data transformation. To overcome the graphical user interface functionalities limitation, you need to learn the Power Query M language.

Whenever we perform any operation on the data inside the power query, the power query generates M code in the background. Power Query M language is also called M formula language or Data mashup language.

If you want to build stunning dashboards in the Power BI, you need to prepare data accordingly and for the preparation of the data, you need to be good in Power Query M language.

In this class, you will learn all the building blocks for power query M language that will develop a solid background, so that you can implement any function in the Power Query M language without any issue.

In the end, I wish you all the best.

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction