Most used Power Query concepts and Data modelling in real time

[Gopal_PV]

Hi Friends,

I am very new to Power Query(I know Basic all avalable options) . I have used SSAS Analysis services live connection.

In all the interviews they are asking about Data Modelling and Power Query concepts.

Can you please help what are the most used requirements for Power Query.

Please hlep me if  Any Tutorial for Advanced Power Query and Data Modelling.

[Anonymous · Accepted solution]

Hi @Gopal_PV,

Thank you for reaching out in Microsoft Community Forum.

1. Below are the most used power query tasks;
Remove nulls, unpivot data, merge/append tables, extract values, create parameters/functions.

2.data modeling concepts:
Star schema, relationships, DAX context, calculated columns vs measures, role-playing dimensions

3. Below are the links to learn advance power query concepts;
https://learn.microsoft.com/en-us/power-query/

Please continue using Microsoft Community Forum.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.

[Omid_Motamedise · Accepted solution]

Most Common Power Query Requirements in Interviews are:
Data Transformation Basics => Importing data from different sources (Excel, CSV, databases, web, PDFs) / Cleaning data: removing duplicates, filtering rows, replacing values/ Changing data types properly

Advanced Power Query Skills => M language basics and writing custom functions / Parameterizing queries for dynamic filtering/ Combining data: merging and appending tables with different structures/ Handling errors and missing data (using try...otherwise, Table.HasErrors, etc.) / Grouping data and aggregation in Power Query (Table.Group) / Using List and Record functions for advanced transformations / Working with dates and text transformations / Optimizing query performance with buffering (Table.Buffer) and query folding awareness

[Anonymous]

Hi @Gopal_PV,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept  as  Solution" and give a 'Kudos' so other members can easily find it.

Thank you,
Pavan.

[v-lgarikapat]

Hi @Gopal_PV ,

If your question has been answered, kindly mark the appropriate response as the Accepted Solution. This small step goes a long way in helping others with similar issues.

We appreciate your collaboration and support!

Best regards,
LakshmiNarayana

[v-lgarikapat]

Since we haven't heard back from you, we are closing this thread. If you are still experiencing the same issue, please create a new thread, and we will be happy to assist you further.

Thank you for your patience and support.

If our response was helpful, kindly mark it as "Accepted Solution" and consider giving a "Kudos." Feel free to reach out if you need any further assistance.

Best regards,
Lakshmi Narayana

[Anonymous · Accepted solution]

Hi @Gopal_PV,

Thank you for reaching out in Microsoft Community Forum.

1. Below are the most used power query tasks;
Remove nulls, unpivot data, merge/append tables, extract values, create parameters/functions.

2.data modeling concepts:
Star schema, relationships, DAX context, calculated columns vs measures, role-playing dimensions

3. Below are the links to learn advance power query concepts;
https://learn.microsoft.com/en-us/power-query/

Please continue using Microsoft Community Forum.

If this post helps in resolve your issue, kindly consider marking it as "Accept as Solution" and give it a 'Kudos' to help others find it more easily.

Regards,
Pavan.