Power Query M Language with Specialize in Web Scraping
Power Query M Language programming secrets to take you to the next level.
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
Requirements
-
There is no such prerequisites but knowledge of Power query would be helpful
Who this course is for:
- Excel users
- Data Analysts
- Business Intelligence constultants
- Data Engineers
- Data Scientists
