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.
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.
Author Name: Eugene Meidinger
Author Description:
Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.
Table of Contents
- 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
User Reviews
Be the first to review “Querying and Shaping Data in Power BI Using M”
Related Products
Predictive Analytics for Business
Learn to predict future outcomes and trends through statistical modeling techniques.
Business Intelligence Data Analyst
BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings.
Analyze Data with R
Use R to process, analyze, and visualize data.
Learn R
Learn how to code and clean and manipulate data for analysis and visualization with the R programming language.
Data Science Foundations
Learn to clean, analyze, and visualize data with Python and SQL.
Business Analytics
Explore data analysis techniques to drive business performance and decision-making.
There are no reviews yet.