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.

Created by: Biztics Inc.
Passionate data expert in Business Intelligence field.

What Will I 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

Requirements

• Microsoft Power BI Desktop (free download)
• This course is designed for PC/Windows users (currently not available for Mac)
• Your willingness to learn and grow
• This is a Power Query and M Language Training for beginners to advanced

Target audience

• This course is for beginners. we focus on taking you from beginners to advance by working on business use cases
• If want to learn Power Query and M Language completely from scratch
• Non technical employee who is interested in solving business challenges without writing codes
• Anyone interested in business transformation using no/low code platform
• Anyone that needs to import and clean data to be analyzed
• Anyone who copies and pastes data into the same Excel spreadsheet on a regular basis in order to be able to continue their workflow
• Individuals interested in upskilling to become more competitive and productive at work
• If you know some Power Query and M Language skills but want to get better
• If you are good with Power Query and M Language and want to take your skills to the next level and truly leverage the full potential of Power Query and M Language
• Employees with repetitive task or seemingly manual processes and need to automate them
• Students who want to upskill in preparation for job placement
• Managers who is interested in what is possible with Power Platform
• Young Graduate who need to add more skills to their skillset for better job placement