When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Querying and Shaping Data in Power BI Using M
We all have to deal with dirty data. By using the M language, we can clean and prep our data for use in Power BI. M turns manual data cleanup into an automated process.
This Course Includes
pluralsight
4 (41 reviews )
2 hour 36 minutes 
english
Online - Self Paced
core courses
pluralsight
About Querying and Shaping Data in Power BI Using M
We all have to deal with semi-structured data that is scattered across multiple data sources. In this course, Querying and Shaping Data in Power BI Using M, you'll learn how the Power Query formula language known as M can automate data cleanup. First, you'll learn how to extract trapped data. Next, you'll discover how to massage and shape it. Finally, you'll explore how to work with text and date values. By the end of this course, you'll have a deeper understanding of the M language.
What You Will Learn?
- Course Overview : 0mins.
- Meet M, a Macro Language for Data Prep : 28mins.
- Extracting Your Trapped Data : 35mins.
- Molding Your Data into the Right Shape : 26mins.
- Combining and Merging Multiple Data Sources : 15mins.
- Cleaning up Messy Text Values : 27mins.
- Manipulating Dates and Times : 21mins.