Power Query and M Language the easy way
Most complete and comprehensive course in Power Query and M Language with hands on exercises and demos step-by-step.
4.21 (157 reviews)
1,330
students
21 hours
content
May 2024
last update
$84.99
regular price
What you will learn
Understand Power Query and its components
Understand power query to connect and explore your data
How to Explore reshape and enrich your data
How to create calculated columns
How to Shape or transform data to match your data analysis requirements
How to Refresh a query to import the latest data into a table
How to Combine data from multiple data sources
How to Filter a table based on size, value, or condition
How to Sort a table ranked by a criteria, such as the alphabetical or numerical value of one or multiple columns, and by ascending or descending order.
How to Group rows in a table
How to Expand/Extend a column
How to Aggregate data from a column by group operation, including Sum, Count, Average, Min, and Max
How to Insert a custom column into a table — Insert an Index or Custom column
How to Combine multiple queries by merging or appending them
There is no coding required! Power Query allows you to do that but it's not necessary
Build complex and custom transformation
Write M code to add/delete/transform custom columns
Implement Best practice in Power Query and M language
Explore how the M language can be used to write your own customized solutions
Use custom functions to extend and enhance Power Query
Create your own formulas and functions to go beyond simple data imports
Gain effiiciency by reducing the time it takes to prepare data for analysis, and make informed decisions more quickly
Gain productivity by properly preparing data yourself, rather than relying on others to do it
Screenshots
Related Topics
4985738
udemy ID
11/19/2022
course created date
12/24/2022
course indexed date
Bot
course submited by