Power Query M Language with Specialize in Web Scraping
Power Query M Language with Specialize in Web Scraping, available at $59.99, has an average rating of 3.9, with 22 lectures, based on 72 reviews, and has 18858 subscribers.
You will learn about 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 This course is ideal for individuals who are Excel users or Data Analysts or Business Intelligence constultants or Data Engineers or Data Scientists It is particularly useful for Excel users or Data Analysts or Business Intelligence constultants or Data Engineers or Data Scientists.
Enroll now: Power Query M Language with Specialize in Web Scraping
Summary
Title: Power Query M Language with Specialize in Web Scraping
Price: $59.99
Average Rating: 3.9
Number of Lectures: 22
Number of Published Lectures: 22
Number of Curriculum Items: 22
Number of Published Curriculum Objects: 22
Original Price: $99.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- Excel users
- Data Analysts
- Business Intelligence constultants
- Data Engineers
- Data Scientists
Target Audiences
- Excel users
- Data Analysts
- Business Intelligence constultants
- Data Engineers
- Data Scientists
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.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Course Introduction
Lecture 2: Introduction to power query m language
Lecture 3: How to rename and sort all columns in Power query M language
Lecture 4: Power query list functions (Easy understanding)
Lecture 5: Power query group by aggregation using M functions
Lecture 6: List.range function in power query to get Top N records
Lecture 7: How to work with records in power query M language
Lecture 8: Iferror function in Power query M language using try otherwise
Lecture 9: Power query web scraping multiple pages
Lecture 10: Power query M language web scraping using lists
Lecture 11: Power query table creation using M language
Lecture 12: Nested let in power query and variable scope
Lecture 13: How to create functions in power query M language
Lecture 14: Index column with power query records to get value of previous row
Lecture 15: Power query index column by group to repeat values
Lecture 16: Power query transpose rows to columns using M language
Lecture 17: Power query M language project that include lot of functions & tricks
Lecture 18: Power query top n rows by each group (Easy method)
Lecture 19: Power query input parameters (Any value, List & Query) Secrets
Lecture 20: Power query web scraping for ali baba (Live case study)
Lecture 21: Power query web scraping with related searches on e-commerce
Lecture 22: Comma delimited column to rows in power query
Instructors
-
Data Chunks
Senior Data Analyst
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 3 votes
- 3 stars: 12 votes
- 4 stars: 22 votes
- 5 stars: 35 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Language Learning Courses to Learn in November 2024
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024