Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a reward of 150 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

Querying and Shaping Data in Power BI Using M

Querying and Shaping Data in Power BI Using M

1425
Start anytime
Self paced
English
Course by
PluralsightCourses from Pluralsight
Certificate awarded
Intermediate
Login to earn 150Edvicer reward coin150 coins = INR 150

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Discount offers - Edvicer

Limited Time Discount Offers

Save your money with Edvicer. Check out our premium courses with discount offers.

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Career Mapper - Edvicer

Map your Career

Not sure which job profiles this course will open for you? Check out our AI based tool to get a complete personalized career map.

Checklist

Certification

You will get a certificate on completing this course.

University

This course is not affiliated with any university.

Price

This course costs very less.

Edvicer's Rewards

You can get a reward of 150 coins on buying this course. These coins can be redeemed for 1 coin= 1Re.

Why should you choose this course?

Description

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.

Syllabus

Course Overview
What Problem Does M Solve?
M Is a Conveyor Belt for Your Data
Where Is M Used?
M Is Lazy
Demo - Lazy Evaluation
Demo - Query Folding
M Is Laid Back
Summary
Why Is Our Data Trapped?
Extracting from Flat Files
Demo - Extracting from CSV and Excel
Extracting from Hierarchical Data Sources
Demo - Extracting from XML and JSON
Extracting from Relational Databases
Demo - Extracting from Relational Databases
Extracting from Online Sources
Summary
Why Is Our Data Mangled?
Removing Data?
Demo - Removing Rows
Demo - Removing Columns
Demo - Splitting and Combining Columns
Twisting and Turning Data
Demo - Pivot And Transpose
Aggregating Data
Demo - Grouping Data
Summary
Breaking Down Data Silos
Merging and Appending Data
Demo - Appending Data
Demo - Merging Data
Demo - Loading Folders and Files
Summary
Why Is Unstructured Text a Problem?
Getting Rid of Junk
Demo - Extracting Portions of Text
Demo - Trimming Whitespace
Demo - Changing Capitalization
Demo - Filling up and Down
Creating Something New
Demo - Creating Custom Columns
Summary
Why Dates and Times Matter
Demo - Parsing Dates
Modifying Dates
Demo - Modifying Dates
Generating a Date Table
Demo - Generating a Date Table
Summary

What others say about this course

Write your review of Querying and Shaping Data in Power BI Using M

Facebook account of EdvicerLinkedin account of EdvicerInstagram account of Edvicer
Twitter account of EdvicerPinterest account of EdvicerYoutube account of Edvicer

30% off