English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 4 Hours | 1.98 GB
Power Query M Language programming secrets to take you to the next level.
What is M formula language
One of the most critical and challenging tasks in any data analytics project is data transformation & data cleaning. We need to prepare the data to make it suitable for analysis to retrieve useful insights.
In the world of power bi, we have a Power query like an ETL for the data warehouse. Whenever we perform any operation on the data, the power query generates M code, a formula language. M formula language contains a rich set of different functions for data transformation & cleaning.
Why learn M formula language
In power bi, we have a graphical user interface that we use to perform different operations on the data. Still, unfortunately, this interface is minimal. We cannot perform all the data related operations on it by using a graphical user interface.
Almost every month, Microsoft releases new versions of Power BI, which have new graphical tools in the power bi ribbon. However, we still have to depend on the unique features of the power query graphical user interface.
We can overcome this dependency by learning the Power Query M language. M language is much more powerful than the Power query because the entire underlying auto-generated code will be in our hands.
In this course, You will learn all the building blocks of Power query M language to master it on your own.
This course will give you a clear path about the M language on how to implement any available function for data transformation.
New upcoming features & functions will be added in this course from time to time.
What you’ll learn
- Introduction to Power query M language
- Rename & sorting using M code
- Secrets of List functions in Power query M language
- M query for group by aggregation
- Top N records for each category dynamically
- How to do error handling
- Web scraping using lists
- Dynamic table creation using M language
- Nested Let & Variables scope
- M language Record functions
- Power query M language Index function secrets
- Input & dynamic parameters
- Web scraping projects using M functions
Table of Contents
Introduction
1 Course Introduction
2 Power query M language web scraping using lists
3 Power query table creation using M language
4 Nested let in power query and variable scope
5 How to create functions in power query M language
6 Index column with power query records to get value of previous row
7 Power query index column by group to repeat values
8 Power query transpose rows to columns using M language
9 Power query M language project that include lot of functions & tricks
10 Power query top n rows by each group (Easy method)
11 Power query input parameters (Any value, List & Query) Secrets
12 Introduction to power query m language
13 Power query web scraping for ali baba (Live case study)
14 Power query web scraping with related searches on e-commerce
15 Comma delimited column to rows in power query
16 How to rename and sort all columns in Power query M language
17 Power query list functions (Easy understanding)
18 Power query group by aggregation using M functions
19 List.range function in power query to get Top N records
20 How to work with records in power query M language
21 Iferror function in Power query M language using try otherwise
22 Power query web scraping multiple pages
Resolve the captcha to access the links!