Forum Discussion
Most used Power Query concepts and Data modelling in real time
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.
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 dimensions3. 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.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 properlyAdvanced 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
5 Replies
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 dimensions3. 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.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.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,
LakshmiNarayanaSince 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
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 properlyAdvanced 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
