Forum Discussion

Gopal_PV's avatar
Gopal_PV
Helper III
1 year ago
Solved

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 Powe...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    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's avatar
    Omid_Motamedise
    1 year ago

    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's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    v-lgarikapat
    Community Support
    1 year ago

    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's avatar
      v-lgarikapat
      Community Support
      1 year ago

      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