Complete M Language From Scratch In Power Query For Power Bi

Complete M Language Training: From Beginner to Advanced in Power Query for Power BI.

What you'll learn

Learn M Language for Power Query from Scratch

Understand the Basics of M Language

Master Data Transformation Techniques

Build Custom Functions and Queries

Apply M Language in Real-World Power BI Projects

Requirements

Power BI Desktop (free download)

No paid software required

Description

Dive into the world of M Language in Power Query for Power BI with this comprehensive course, designed to take you from beginner to advanced levels. Whether you're new to Power BI or have some experience with data transformation, this course covers everything you need to Proficient M Language and unlock the full potential of Power Query.Course Highlights:Fundamentals Covered:Learn the basics of M Language to ensure a strong foundation for more advanced topics.M Language Basics:Understand the core concepts of M Language, including syntax, functions, data types and structure. Learn how to write basic queries and perform simple transformations to manipulate your data.Operations Covered: Arithmetic, Comparison, and More:Learn how to perform essential operations in M Language, including arithmetic (addition, subtraction, multiplication, division) and comparison (equal to, greater than, less than). Master these operations to manipulate and refine your data efficiently in Power Query.Conditional Logic & If Statements:Dive into conditional logic in M Language. Learn to create custom conditions using "if" statements to dynamically adjust your data transformations.Parameterization:Understand how to use parameters in Power Query to make your queries dynamic and reusable, streamlining your data transformation process.Custom Functions:Learn how to create and use custom functions in M Language to simplify repetitive tasks. Master the art of building reusable functions that enhance your Power Query workflows and improve query efficiency.Text, Number, and DateTime Functions:Master essential functions in M Language to manipulate text, numbers, and dates. Learn how to apply text functions (like concatenation and trimming), number functions (such as rounding and conversions), and DateTime functions (for calculating and formatting dates) to transform your data effectively.Working with Lists & Records:Master working with lists and records in M Language, allowing you to manipulate complex data structures with ease.List, Record, and Table Functions - Deep Dive:Explore advanced M Language functions for working with lists, records, and tables. Learn how to manipulate lists (filter, sort, and transform), work with records (accessing and modifying fields), and handle tables to perform complex data transformations in Power Query.Data Cleansing & Handling Errors:Learn how to identify and handle errors, missing values, and duplicate entries in your datasets.Error Handling & Debugging:Master error handling and debugging in Power Query, ensuring that your transformations are robust and reliable.Optimizing Queries:Learn strategies for optimizing your M queries to improve performance and reduce processing time when working with large datasets.Additional Features:Practical Exercises:Apply your learning with hands-on exercises designed to reinforce key concepts and techniques.

Overview

Section 1: Introduction and Course Structure

Lecture 1 Course Structure and Introduction

Lecture 2 What You’ll Learn in This Course

Lecture 3 Resource Download to get started

Section 2: Introduction to Power Query

Lecture 4 What is Power Query

Lecture 5 Importance of M Language

Section 3: Basics of Power Query

Lecture 6 Overview of Power Query Editor

Lecture 7 Connecting Data & Overview of Advanced editor, formula bar

Section 4: Basics of M Language

Lecture 8 Declaring Variables using let and in keyword

Lecture 9 Comments in M language

Section 5: Data types in M Language

Lecture 10 Number Data type

Lecture 11 Text Data type

Lecture 12 Boolean Data type

Lecture 13 null Data type

Lecture 14 Datetime Data type

Section 6: Basic Operators in M Language

Lecture 15 Arithmetic operation

Lecture 16 Logical operation

Lecture 17 Comparison operators

Lecture 18 Assignment - Basic operations in M language

Lecture 19 Solution - Basic operations in M language

Section 7: Conditional logic if else in M Language

Lecture 20 Basic Conditional expression if else

Lecture 21 Nested if else

Lecture 22 Handling null values

Lecture 23 Assignment - Conditional logic if else

Lecture 24 Solution - Conditional logic if else

Section 8: Parameter

Lecture 25 Creating a Parameter in Power Query

Lecture 26 Benefits of Parameter

Section 9: Custom Function in M Language

Lecture 27 What is Custom Function and Syntax of Custom Function

Lecture 28 Create Custom Function and Invoke Custom Function

Lecture 29 Custom Function to Classify Numbers

Lecture 30 Custom Function with Two Parameters

Lecture 31 Understanding Nested 'let' and 'in' Constructs with Custom Functions in M

Lecture 32 Assignment

Lecture 33 Solution

Section 10: Mid Level Project Assignment

Lecture 34 Mid Level Project Assignment

Lecture 35 Mid Level Project Assignment Solution

Section 11: Text Functions in M Language

Lecture 36 Text Functions Introduction

Lecture 37 Text.Length Function

Lecture 38 Text.Upper & Text.Lower Functions

Lecture 39 Text.Trim Function

Lecture 40 Text.Start Function

Lecture 41 Text.End Function

Lecture 42 Text.Replace Function

Lecture 43 Text.Contains Function

Lecture 44 Assignment - Text Function

Lecture 45 Assignment Solution - Text Function

Section 12: Number Functions in M Language

Lecture 46 Number Functions Introduction

Lecture 47 Number.IsOdd Function

Lecture 48 Number.IsEven Function

Lecture 49 Number.Mod Function

Lecture 50 Number.Abs Function

Lecture 51 Number.Sign Function

Lecture 52 Number.FromText Function

Lecture 53 Number.ToText Function

Lecture 54 Assignment - Number Function

Lecture 55 Assignment Solution - Number Function

Section 13: DateTime Functions in M Language

Lecture 56 Datetime Function Introduction

Lecture 57 Basic Datetime Function

Lecture 58 DateTime.LocalNow & DateTime.Date Function

Lecture 59 Date.Year, Date.Month, Date.Day Function

Lecture 60 Time.Hour, Time.Minute, Time.Second

Lecture 61 Date.AddDays, Date.AddMonths, Date.AddYears

Lecture 62 Assignment - DateTime Function

Lecture 63 Assignment Solution - DateTime Function

Section 14: List

Lecture 64 List Introduction

Lecture 65 Basic Concept of List and Creating List

Lecture 66 Accessing Elements of a List

Lecture 67 Manipulating List

Lecture 68 Working with Nested Lists

Lecture 69 Combine nested list into single list

Lecture 70 Generating List of numbers and list of Alphabets

Lecture 71 Basic List Assignment

Lecture 72 Basic List Assignment Solution

Section 15: List Functions

Lecture 73 Table.Column List Function

Lecture 74 List.Distinct Function

Lecture 75 List.Transform Function

Lecture 76 List.Sort Function

Lecture 77 List.Select Function

Lecture 78 List.RemoveItems Function

Lecture 79 List.Sum Function

Lecture 80 List.Count Function

Lecture 81 List.Combine Function

Lecture 82 List.Contains Function

Lecture 83 List.FirstN and List.LastN Function

Lecture 84 List.Min and List.Max Function

Lecture 85 Text.Split List Function

Section 16: List Functions Assignment

Lecture 86 List Functions Assignment

Lecture 87 List Functions Assignment Solution

Section 17: Records

Lecture 88 Introduction to Record and Creating Simple Record

Lecture 89 Accessing Elements from a Record

Lecture 90 Modifying Record

Lecture 91 Nested Records

Lecture 92 Extract Record From Table

Section 18: Record Functions

Lecture 93 Record.Field Function

Lecture 94 Record.SelectFields Function

Lecture 95 Record.AddField Function

Lecture 96 Record.RemoveField Function

Lecture 97 Convert Record to a List using Record.ToList Function

Lecture 98 Convert Record to a Table using Record.ToTableFunction

Section 19: Table

Lecture 99 Understanding Tables

Lecture 100 Creating a Table using M language

Lecture 101 Accessing Data in Tables

Section 20: Table Functions

Lecture 102 Table.SelectColumns Function

Lecture 103 Table.ColumnNames Function

Lecture 104 Table.RowCount Function

Lecture 105 Table.Distinct Function

Lecture 106 Table.Sort Function

Lecture 107 Table.PromoteHeaders Function

Section 21: Advanced Table Functions

Lecture 108 Table.AddColumn Function

Lecture 109 Table.TransformColumns Function

Lecture 110 Table.SelectRows Function

Lecture 111 Table.Combine Function

Section 22: Error Handling and Performance Optimization

Lecture 112 Error Handling

Lecture 113 Performance Optimization

Section 23: Trick and Tips

Lecture 114 Combining files from Folder with uneven columns

Lecture 115 Congratulations on Completing the Course!

Section 24: Bonus Lesson

Lecture 116 Bonus Lesson

If you want to Learn M language for Power query and do the Data Transformation for your analysis,If you are a beginner and want to learn how to transform and manipulate data using M Language in Power Query for Power BI, this course is perfect for you.,Whether you're just starting with Power BI or looking to enhance your data transformation skills, this course will help you build a strong foundation from scratch.,This course is also ideal for those who want to improve their problem-solving skills in data manipulation and optimize their Power BI workflows.