fbpx
[email protected] +1 203-349-9909 / +91-8080042523

Mastering Power Query with M Language

Learn Power Query M Language

It promises to help you in:

  • Analyzing Data and sharing important Business insights
  • Monitoring your business and getting quick answers with the help of rich and interactive dashboards available on every device
  • 45+ Video Lessons
  • 5+ Hour Duration
  • Lifetime Access
  • 30 Days Money Back

Mastering Power Query, M Language with MS Excel

Introduction Video

Explore and Master this collection of Power BI services online and learn to Optimize your data for Quick Insights in our Power BI Masterclass.

You'll Learn
Target Audience
Pre-requisites

 What you’ll get to Learn in Power Query with M Language?

Powerful Report Building: You can design and create Stunning and powerful Power BI Reports- with WOW effects Quickly in Power BI

Data Transformation: It will help you in the transformation of the messy data into the right format

Better Performance: Three fundamentals rules for normalizing your dataset for better performance

Decision making: It will help you in strategic decision making and creating competitive advantages

Create and Manage Relationships: One to Many, Many to One, Many to One relationship

Schema for Data Models: Star Schema, Snowflakes Schema, Top Down schema for Data Models

Representation of Dashboards and Reports: It will help you in the Improvement of the look and feel of your Dynamic Dashboard

 Target Audience of Mastering M Language?

If you use Excel for more than 2 hours then this course is for you

The ones who want to master self-service bi

If you want to prepare for Power BI certifications from Microsoft.

For all those who want to automate management reporting and wow their stakeholders.

You want to apply best practices and customization while Creating Dashboards and reports

What are the Pre-requisites to Power Query with M language?

Windows 7 onwards should be installed in your system so you can install the Power BI Desktop application

Complete interest to dive into the Data Analytics Jobs

If you’ve a great desire to learn and explore something new and fascinating about the Application of BI Tool in the market

Not suitable for Mac users, the Power BI Desktop tool can only be available for the PC

Excel 2010 onwards should be installed in your system in case you’re looking out for the Power BI Publisher for Excel add-in, although this is not mandatory for using Power BI

No prior Power BI or BI experience is required

Your willingness to learn and grow and explore new opportunities

Our Customers Love Us

Here’s a run-through of the comments of what Few of our Well-wishers think about us. 

peter-klugsberger

PETER KLUGSBERGER
-ex-McKinsey & Co. served various senior roles (CEO, COO) in various companies

I would like to tell you that I am very impressed with your courses so far – I particularly like the short videos that allow me to get to a topic quickly and then move on (your competitors mostly offer 20-30 min videos which is a bit much to keep one’s attention span). The other gem in your training are the shortcuts, I found no other course with the same insights.

David Hoey Student Of Yodalearning

BARBARA JONES
-Finance Professional

Because I use spreadsheets daily, I’m often using the Shift+down arrow to highlight and then manipulate data. Of course, this takes FOREVER! As I am advancing in my role at work, it is very important for me to learn more advanced Excel skills. I chose this video b/c it was short and condensed. I could literally watch it on my breaks at work and then use it right away. I really like that. Well done!

placeholder-face-big

PETER THOMAS
– Accounting Professional

I’ve been using Pivot Tables for a couple of years, so was expecting most of this to be familiar. But this course proved me wrong. From simple tips and keyboard shortcuts, to whole features I never knew existed, I constantly found myself muttering things like “oh wow, I had no clue about that”. Things that I can actually put into practice in my job. It’s a great feeling. Kudos to the team on a great course

Ready to get started?

All set to gain Expertise in Business Analytics Services? Master this Power BI and Power Query Course

Checkout the course outline below

Here is the roadmap from Zero to BI Expert

Module 1: HOW TO CONSOLIDATE AND APPEND DATA – 31:34 MIN
You’ll learn to Append, Consolidate and import Data in Power Query


✔️ How to Append Multiple Worksheets within the same Excel file
✔️ How to find the Relationship between Append, Duplicate/Replicate and Referencing of multiple Queries
✔️ Learn about Importing data from files in a folder
✔️ Learn about Importing data from multiple excel files in a folder
✔️ How to create Dynamic List of files stored in a folder
✔️ How to Change the file path for source data

Module 2: IMPORT DATA FROM EXTERNAL SOURCE, LOAD & REFRESH DATA, MULTIPLE TRANSFORMATION STEPS – 31:34 MIN
You’ll learn to IMPORT Data from Excel and other files, also, you’ll learn to Refresh a query, do Row and Column Transformation  


✔️ Understanding What is Power Query. Why to learn Power Query and what is Covered in Power Query
✔️ How to Import Data from Excel File
✔️ How to Import Data from another files and folders
✔️ How to load and Refresh a query as per Data Modeling
✔️ How to do Column Transformation in Power Query
✔️ How to do Row Transformation in Power Query

Module 3: HOW TO DO IN BUILT TRANSFORMATION IN POWER QUERY – 31:34 MIN
You’ll learn about Text, Numbers, Date and Conditional Column Transformation in Power Query


✔️ How to do Text Transformation
✔️ How to do Numbers transformation
✔️ How to do Date transformation
✔️ How to do Conditional Column transformation

Module 4: HOW TO USE MERGE FEATURE TO COMBINE MULTIPLE JOINS IN POWER QUERY – 31:34 MIN
You’ll learn about Text, Numbers, Date and Conditional Column Transformation in Power Query


✔️ What are the Multiple JOINS in power query
✔️ What are the Different Joins in Power Query
✔️ Learn how to create a Cross Joins and Cartesian Product Joins
with Power Query

Module 5: FUNDAMENTALS OF M: THE FORMULA LANGUAGE FOR POWER QUERY – 31:34 MIN
You’ll learn about M-Formula Language, the Text, Date, Conditional Functions in Power Query


✔️ Learn what are the roots of M, the Formula Language/ Power Query Formula Syntax
✔️ Learn about the Text functions in Power Query
✔️ Learn about the Date functions in Power Query
✔️ Learn about the Conditional Functions in Power Query

Module 6: CASE STUDIES – 31:34 MIN
You’ll learn about the Payroll Data, converting the Financial Statement Data and Row data set into a Tabular Format, about Multiple lookup Values etc.


✔️ Using Power Query to Convert the Financial Statement Data into a Table
✔️ Converting the Payroll Data into a Tabular format with Power Query
✔️ How to pull Stacked Data from the Address Book to the Excel?
✔️ How to apply Multiple filters on single column using Merge Query Option
✔️ How to Convert a Row data set into a Tabular Format using Power Query?
✔️ How to get data from Multiple lookup Values using Power Query
✔️ Invoice/Order data Modeling (Converting Pivoted Data using Unpivot Function) with Power Query
✔️ Shape and Combine Data from Multiple Sources in Power Query. Here, Sales analysis using MaxIF, MinIF

Module 7: POWER QUERY OBJECTS – 31:34 MIN
You’ll learn the important in Power Query object and functions, how to use it and How to Record as object in detail


✔️ List all the object and functions in Power Query and how it can be used
✔️ How to Record as object and details about the Record functions in Power Query
✔️ Table & other objects and Table functions in Power Query
✔️ Quick Recap on What are the Power Query Objects

Module 8: ADVANCED CASE STUDIES – 31:34 MIN
You’ll learn to Extract Data, Create a dynamic Calendar table and apply Multiple filters on single column


✔️ Learning to Extract only relevant data in Power Query
✔️ How to Create a dynamic Calendar table
✔️ Mode of Calculating and finding Individual sales to total sales percentage
✔️ How to apply Multiple filters on single column

Module 9: BONUS – 31:34 MIN
You’ll learn about Conditional Functions and Extract & Transform Column


✔️ What are the Conditional Functions?
✔️ Using the Extract & Transform Column

Module 10: DIRECT POWER QUERY LIMITATIONS- ERROR HANDLING – 31:34 MIN
You’ll learn about Error handling, renaming, Null Handling values and how to Merge queries & case sensitive Duplicates


✔️ Errors handling- While you Modify a Table / Delete a Table / Rename a Table
✔️ Dynamically rename columns while avoid errors
✔️ Perform a Case sensitive Advanced Filter
✔️ Identify/Keep/Remove – Power Query error Rows in the Data Frames
✔️ Null Handling values during query Results (addition / Multiplication / Division)
✔️ Merge queries & case sensitive Duplicates – JOINS
✔️ Solutions- Different Unpivot issues

Module 11: POWER QUERY : CASE STUDIES – 31:34 MIN
You’ll learn about the Business Value of ‘Leave Data’, Stack the un-stack Data, combine multiple row data into single cell, Excel Magic Trick and Date List


✔️ Date and Time – Convert for different time zone
✔️ Understanding the Business Value of ‘Leave Data Part 1’
✔️ Understanding the Business Value of ‘Leave Data Part 2’
✔️ Stack the un-stack Data which is Uneven – Part 1
✔️ Stack the un-stack Data which is Uneven – Part 2
✔️ How to quickly combine multiple row data into single cell using this Reverse trick
✔️ Power Query Ranking- Excel Magic Trick
✔️ Date List – Allocating Fixed cost on monthly Basis
✔️ Recording Prepaid Expenses each month

Module 12: DEEP DIVE INTO ADVANCED POWER QUERY EDITOR CONCEPTS & POWER QUERY – M LANGUAGE – 31:34 MIN
You’ll learn about Power Query Parameters, how to Create / edit / delete Parameters, Power Query Interface and Nested calculation in Power Query


✔️ Concept explained: M Language and Advanced query editor
✔️ Power Query Parameters – Introduction
✔️ Create / edit / deleting Parameters Using PQ interface
✔️ Introduction – Microsoft Power Query Custom M Functions
✔️ Microsoft Power Query Parameters and Power Query Interface -Custom M Functions
✔️ Microsoft Power Query using advanced editor – Custom M function
✔️ Nested calculation in Power Query- Power Query Conditional RANKIF based on custom M function
✔️ Show Query Dependency and Grouped Queries

Module 13: CUSTOM M FUNCTIONS – DYNAMIC (READY TO USE) PATTERNS – 31:34 MIN
You’ll learn about Dynamic (ready to use) Custom M Function, Vendor Ageing analysis and how to Calculates working days between dates using Power Query Custom M- Code


✔️ Introduction- Dynamic (ready to use) Custom M Function
✔️ Vendor Ageing analysis with Approximate Match in Power Query
✔️ Power Query Custom M- Code – Calculates working days between dates

Final Module: Graduation
Course Completion Certificate


 

Power Query with M Language

Learn Basic-Intermediate M Language
$99
  • 5+ Hours Of Videos
  • 45+ Video Lessons
  • Lifetime Access
  • Downloadable Sample Files
Get Instant Access

What Student Say?

The Course instructors at Yoda Learning are at Par. My only Weakness till date was Excel which is long gone now. Not only I’ve learned about Excel but I can confidently do VBA Coding and automate my Regular Excel Tasks. A colleague of mine made me watch a Couple of your Videos where you have taught Excel Tricks. And since it had a Lifetime Support it really motivated me to take your Course. Thank you so much for delivering your Best knowledge.

Peter Thomas
Peter Thomas
Sr. Consultant

I have all the courses from Yoda Learning. I consider it as one of the best platforms in making Learning easier for its Learners. The Courses here are comprehensive and one of the easiest Courses on the Online Platform in recent times. Professionally explained. I love the takeaways from the Course. It’s amazing especially the Money back Guarantee which gives you the Confidence to take the course.

Barbara_Kern
Barbara Pern
Data Analysis

safe_checkout1

30-days-money-back-guarantee

30 Days Money Back Guarantee

If you’re not satisfied, we offer a full no questions asked money back guarantee. Just send us a Support Ticket and we will take care of it for you.

You have absolutely nothing to lose, and everything to gain! So scroll back up & get started right away!

We know you’re going to LOVE IT!

Course Completion Certificate By Yodalearning

Unlock your completion certificate

  • Complete any premium course at Yoda Learning Solutions
  • You are awarded a completion diploma
  • The diploma can be verified via URL and exported to LinkedIn to boost your career and impress potential employers.

For Enquiry About Courses? Contact Us:
[email protected]
 +1- 203-349-9909

Feel free to call us for any query related to courses. Our support team will resolve your issue.

Frequently Asked Questions

FAQ

What is there in this Power Query with M Language?

If you are planning to get started with Power BI and your data analytics journey it is very important that you follow a proper path to learn various concepts about data analytics.

The important Components and elements covered in the Course are related to:

  1. Gathering the data- Perform your Extract > Transform > Load (ETL) activities.
  2. Modeling your data – Normalizing your data is one of the critical steps
  3. Relationship between data tables – To understand the flow of information
  4. DAX – Perform your data crunching and analysis
  5. Visual analytics – Not just numbers and but pictorial presentation

Why I should invest in Power Query with M Language?

  • It is a Combination of 4 Top Best and Popular Courses of 2019
  • Enjoy clear and concise step by step lessons from a bestselling instructor who is also a Power BI expert
  • You’ll get Support from our Experts
  • 172+ Video Lessons
  • 20+ Hour Duration
  • Lifetime Access
  • 30 Days Money Back Guarantee

What I’m going to learn in this Power Query with M Language?

  • How to import and transform data inside Power BI
  • Building foundation about Data Models and Various foundational concepts of Data Models
  • Relationships and DAX formulas in Power BI and the relationship that’s not covered in any other course
  • Normalized and de-normalized datasets – advantages and difference
  • Three fundamentals rules for normalizing your dataset for better performance
  • Blend and transform raw data into beautiful interactive dashboards
  • Various Schemas such as: Star, Snowflakes and Top Down schema needed for the Data Models
  • Relationship Building (One to Many, Many to One)
  • Simple and easy to understand approach explaining complex concepts of Power BI DAX
  • Design and implement the same B.I. tools used by professional analysts and data scientists
  • How to extract relevant stories from data by performing Data Analysis using DAX
  • Analyze data from different data sources and create your own datasets
  • Comfortably work with the different tools of the Power BI learn about how the different tools work together
  • Build professional-quality business intelligence reports from the ground up

Do I’ve to be a Power BI User to take this Course?

The Course is not just for Power BI users but anyone want to take this Course. The Course is especially for the ones who want to establish their Data Analytics Career

  • You should have a computer with Windows as operating system
  • You should be a Regular Excel User
  • You should be keen to learn more concepts about Power BI DAX
  • Ensure that you have latest version of Power BI Desktop installed
  • Basic understanding of what data analysis is
  • You should have a basic understanding of selected tools of the Power BI and know how these tools work together
  • You should be willing to understand the basic concepts of Power BI regarding the creation of customized visuals using the Power BI Developer Tools

How can I decide if this Course is for me or not?

  • Anyone who is interested to learn about how to connect the different Power BI tools with each other
  • Students who are interested to Learn about Power BI Query editor and want to learn more about DAX, DAX Calculations and Functions
  • People who’ve never worked on this Tool and want to have a clear Understanding about Power BI
  • If you’re keen to get Power BI certifications from Microsoft
  • People who want to understand how to create customized visuals with the Power BI Developer tools
  • If you want to automate management reports and wow their stakeholders from the impressive Report Building
  • If you want to Perform your data analysis quickly using DAX Function

Do we get Course Completion Certificate?

Once you’re done with Data Modelling, Relationships and DAX and you’ve have completed the above course you’ll be getting a Course Completion Certificate which is LinkedIn Verified. You can use it to impresses your Bosses and attract better Job Opportunities.

What if I’m not happy with the Course?

There is a 30-Days Money Back Guarantee. If you’re not satisfied with our Product, write to us and get your Money Back. Read

What if I’ve a Doubt in any of the sections from the Module?

You get the Support from our industry Experts and Course instructors in case you’re not sure about any question or if you’ve got a doubt from any of the Section in the Modules