Excel On Steroids: Power Query COMBO

Discovering and Exploring new Methods to Create efficient Data Transformation Techniques has always been our interest. 

  • Video Lessons = 74+ (6 Hrs)
  • Lifetime Access
  • Lifetime Support

What is Excel on Steroids: Power Query Combo

Discovering and Exploring new Methods to Create efficient Data Transformation Techniques has always been our interest.
→  Excel on Steroids: Power Query Combo is a Combination of Power Query and Power Query M Language. It will help you optimize and build highly flexible data mashup queries also the Course will let you work with the Power Query M language to import and transform data. Discovering and Exploring new Methods to Create efficient Data Transformation Techniques has always been our interest.

Reasons why you should choose Excel on Steroids: Power Query Combo

Situation: The Organizations these days have an island of Data to deal with. Agree? Or not?

Why employees are Frustrated:

  • The Undeniable fact is, ‘Most of the Managers lack the Technical Skills required for Data Problem Solving’
  • The amount of Manual Labor involved in pulling out a Report together

What’s the Way out: Power Query M-Language, comes with potential solutions to solve your organization’s data problems and in pulling out your Data Together

Bonus: Your Reports are now error free and you can save yourself some great amount of time. This lets you analyze the Report rather than compiling it.

Isn’t it a BIG WIN WIN Situation for the Company?

Definitely it is.

Excel on Steroids: Power Query Combo

=

“Improved Skills + Higher Job Performance + Career Growth + Standout Ability”

 

What Power Query can do?

Automatically clean your Data with Power Query

Before Power Query

How to sort data in Excel

Data Cleaning Arrow

After Power Query

Sorted Data

Top 7 Benefits of Excel on Steroids

Excel On Steroid

Become Smarter, Quicker & Faster

Life Of Regular Excel User

data science

Life After Excel On Steroid

data science

What you’ll learn from this ‘Excel on Steroids:
Power Query Combo’ Course

Do you know what is ultra-cool about Power Query? Once you have performed the steps. These steps are repeatable the next time you want to perform the earlier exercise. Much identical to the idea of a Macro but easier to use. Still confused in enrolling the power query online course?

1Extensive Knowledge:

In this Power Query M Language Course, The Trainer provides an extensive knowledge on the fundamentals of the Power Query’s M programming language which is an add on to your Current skillset

2Working on Advanced Editor:

It gives a Powerful Base to work with the Advanced Editor while designing the queries in Power BI Desktop

3Deploying of Power Query Logic:

You’ll learn how your new-found M programming skills can be used to step up your Working Game. With M Language, you’ll be able to develop Custom data connectors. These are helpful for the Organizations in authoring the shared query logic. Multiple Power BI Desktop projects later help in deploying and reusing this Query logic

4Challenges of a functional language:

You’ll learn to tackle the challenges of a functional language as opposed to an imperative language (VBA, C#). Once you’ll learn the advancements of using M Programming Language, you’ll be forever ready to Learn M

5Power of M:

You will learn that M language behind the scene of Power Query, is more Powerful than the Power Query’s graphical interface

6Features of Power Query M:

You’ll learn about the functions, generators, parameters, generators and other interesting features of this tool

7‘M’ the Scripting Language:

You’ll learn about ‘M’ the Scripting Language. It is a Data Transformation engine of Power BI. If you wish to do data preparation and data transformation before loading the Data into your Model, M Language will always stand out

COURSE CURRICULUM

14 Module & Over 6 hours of video

Power Query – M Language

Direct Power Query Limitations- Error Handling

  • 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

Power Query- Case Studies

  • 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

Deep dive into Advanced Power query editor concepts and Power query- M Language

  • 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

Custom M Functions – Dynamic (ready to use) Patterns

  • 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

+

Power Query (Basic To Advanced)

How to Consolidate and Append Data

  • 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

The beauty of Power Query

  • Understanding What is Power Query. Why to learn Power Query and what is Covered in Power Query

How to Import Data from External Data Sources into Power Query

  • How to Import Data from Excel File
  • How to Import Data from another files and folders

Loading and Refreshing Data

  • How to load and Refresh a query as per Data Modeling

Define the multiple Transformation Steps

  • How to do Column Transformation in Power Query
  • How to do Row Transformation in Power Query

How to do in built 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

How to use Merge feature to combine Multiple Joins 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

Fundamentals of M: The Formula Language for 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

Case Studies

  • 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,

Power Query Objects

  • 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

Advanced Case Studies

  • 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

Bonus

  • What are the Conditional Functions?
  • Using the Extract & Transform Column

Start Learning Today

No Frills

Lifetime Access [Early Bird Access]

74+ Course Lessons
$149
  • 74+ Course Lessons
  • Lifetime Support
  • LinkedIn-verifiable Certificate
  • Exclusive Webinars
  • 1200+ Office Productivity Tricks
Join now

Badges For YodalearningSecurity badges For YodalearningOnline Security Payment SuccesfullAdvanced Excel Payment Succesfull

30 days money back gauarantee

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.

Contact Me

Still confused on which Course to take?

 Email [email protected]

 Call Now!+1-203-349-9909