Power Query M Language with Specialize in Web Scraping

Name: Power Query M Language with Specialize in Web Scraping
Rating: 4.3 (80 reviews)

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

Created byData Chunks

Last updated 8/2020

English

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

Course content

1 section • 22 lectures • 3h 46m total length

Course Introduction2:16
Introduction to power query m language8:19
How to rename and sort all columns in Power query M language10:36
Power query list functions (Easy understanding)8:19
Power query group by aggregation using M functions15:47
List.range function in power query to get Top N records9:14
How to work with records in power query M language9:20
Iferror function in Power query M language using try otherwise5:31
Power query web scraping multiple pages13:50
Learn to scrape city populations from the web with Power Query, using a custom function to fetch data for India, USA, and Pakistan, then combine results into a single table.
Power query M language web scraping using lists14:50
Power query table creation using M language7:30
Nested let in power query and variable scope7:41
How to create functions in power query M language14:18
Index column with power query records to get value of previous row12:04
Power query index column by group to repeat values9:32
Power query transpose rows to columns using M language5:58
Power query M language project that include lot of functions & tricks14:22
Power query top n rows by each group (Easy method)12:02
Use Power Query M to compute the top two subcategories per category by total products, by joining tables, counting products, sorting in descending order, and extracting the top records.
Power query input parameters (Any value, List & Query) Secrets12:43
Power query web scraping for ali baba (Live case study)12:52
Power query web scraping with related searches on e-commerce13:30
Comma delimited column to rows in power query6:20

Requirements

There is no such prerequisites but knowledge of Power query would be helpful

Description

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.

About me

My name is Muhammad Asif, and I will be your instructor in this course. I have more than ten years of experience in data & analytics with one of the world's leading organizations. I am a Microsoft certified solution expert in data analytics & management.

I have developed several data models, dashboards & reports for a different line of services. You can learn from my experience, and I will share each and everything. I aim to spread the knowledge by simplifying hard concepts.

I wish you all the best for your journey in Power BI & M formula language.

Who this course is for:

Excel users
Data Analysts
Business Intelligence constultants
Data Engineers
Data Scientists