Power Query M Language with Specialize in Web Scraping
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
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
Course content
- Preview02:16
- Preview08:19
- 10:36How to rename and sort all columns in Power query M language
- 08:19Power query list functions (Easy understanding)
- 15:47Power query group by aggregation using M functions
- Preview09:14
- 09:20How to work with records in power query M language
- 05:31Iferror function in Power query M language using try otherwise
- 13:50Power query web scraping multiple pages
- 14:50Power query M language web scraping using lists
- 07:30Power query table creation using M language
- 07:41Nested let in power query and variable scope
- 14:18How to create functions in power query M language
- 12:04Index column with power query records to get value of previous row
- 09:32Power query index column by group to repeat values
- 05:58Power query transpose rows to columns using M language
- 14:22Power query M language project that include lot of functions & tricks
- 12:02Power query top n rows by each group (Easy method)
- 12:43Power query input parameters (Any value, List & Query) Secrets
- 12:52Power query web scraping for ali baba (Live case study)
- 13:30Power query web scraping with related searches on e-commerce
- 06:20Comma delimited column to rows in power query
Instructor
I am Muhammad Asif Microsoft® Certified Solutions Expert- Data management and analytics with more than 10 years of experience in the field of business intelligence & Data analytics.
My expertise lies in assessing complex business requirements, compiling market and trend data, designing and testing software to accelerate efficiency and revenue growth. I have expertise in Microsoft Business Intelligence stack, visualization & analytical tools like SSRS and Power BI to analyse massive dataset. Analyses datasets with the help of python and DAX programming to extract actionable insights that will help drive business decisions.
I have completed M.Sc. in Computer Science from Linköping University, Sweden in order to augment my qualifications. With a proven track record of successfully aggregating business data and developing solutions to improve business processes, I am confident to teach my students and can deliver ground level industry knowledge & expertise.