Power Query M Language with Specialize in Web Scraping

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

Created by: Data Chunks
Senior Data Analyst

What Will I 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

Target audience

• Excel users
• Data Analysts
• Business Intelligence constultants
• Data Engineers
• Data Scientists