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.
Course info
Rating
(19)
Level
Intermediate
Updated
Sep 11, 2019
Duration
2h 36m
Table of contents
Course Overview
Meet M, a Macro Language for Data Prep
Extracting Your Trapped Data
Molding Your Data into the Right Shape
Combining and Merging Multiple Data Sources
Cleaning up Messy Text Values
Manipulating Dates and Times
Description
Course info
Rating
(19)
Level
Intermediate
Updated
Sep 11, 2019
Duration
2h 36m
Description

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.

About the author
About the author

Starting out as an accidental DBA and developer, Eugene Meidinger now focuses primarily on BI consulting. He has been working with SQL Server for five years now, and is certified in Querying and Administering SQL Server 2012. He regularly presents at various SQL Saturday events.

More from the author
Handling Streaming Data with Azure Event Hub
Intermediate
2h 23m
May 15, 2020
Distributing Excel Workbooks
Advanced
1h 29m
Jan 22, 2020
More courses by Eugene Meidinger
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone, my name is Eugene Meidinger, and welcome to my course Querying and Shaping Data in Power BI using M. I'm a business intelligence consultant working for myself. And M is idea for automating cleanup tasks that you might normally do by hand. In this course, we're going to look at a few things. First, extracting data, then shaping your data, third, combining different data sources, and finally, working with text and date values. By the end of this course, you'll know how to automate your data cleansing using M. Before beginning this course, you should be familiar with basic data preparation. So I hope you'll join me on this journey to learn Power Query and the formula language M with the Querying and Shaping Data in Power BI Using M course at Pluralsight.