Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Power Query

Power Query M Language with Specialize in Web Scraping

Power Query M Language programming secrets to take you to the next level.
Rating: 4.2 out of 54.2 (30 ratings)
18,648 students
Created by Data Chunks
Last updated 8/2020
English
English [Auto]
30-Day Money-Back Guarantee

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

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

  • Preview02:16
  • Preview08:19
  • How to rename and sort all columns in Power query M language
    10:36
  • Power query list functions (Easy understanding)
    08:19
  • Power query group by aggregation using M functions
    15:47
  • Preview09:14
  • How to work with records in power query M language
    09:20
  • Iferror function in Power query M language using try otherwise
    05:31
  • Power query web scraping multiple pages
    13:50
  • Power query M language web scraping using lists
    14:50
  • Power query table creation using M language
    07:30
  • Nested let in power query and variable scope
    07:41
  • How to create functions in power query M language
    14:18
  • Index column with power query records to get value of previous row
    12:04
  • Power query index column by group to repeat values
    09:32
  • Power query transpose rows to columns using M language
    05:58
  • Power query M language project that include lot of functions & tricks
    14:22
  • Power query top n rows by each group (Easy method)
    12:02
  • Power query input parameters (Any value, List & Query) Secrets
    12:43
  • Power query web scraping for ali baba (Live case study)
    12:52
  • Power query web scraping with related searches on e-commerce
    13:30
  • Comma delimited column to rows in power query
    06:20

Instructor

Data Chunks
Senior Data Analyst
Data Chunks
  • 4.1 Instructor Rating
  • 288 Reviews
  • 37,815 Students
  • 5 Courses

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.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.