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.
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.
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.