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
Business Intelligence Analytics
Gain insights into business intelligence tools and analytics techniques to optimize decision-making.
Learn Python for Data Science
Get started with Python for Data Science in this beginner-friendly skill path.
Data Scientist: Analytics Specialist
Data Analysts and Analytics Data Scientists use Python and SQL to query, analyze, and visualize data — and communicate findings.
Predictive Analytics for Business
Learn to predict future outcomes and trends through statistical modeling techniques.
Visualize Data with Python
Learn to make effective data visualizations in Python with Matplotlib and Seaborn.
Introduction to Data Analysis with Pandas and NumPy
Learn to use Pandas and NumPy libraries for data manipulation and analysis in Python.
There are no reviews yet.