Upload Button Icon Add office photos

S&P Global

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

S&P Global Power BI Developer Interview Questions and Answers

Updated 12 Jun 2024

S&P Global Power BI Developer Interview Experiences

1 interview found

Power BI Developer Interview Questions & Answers

user image Meghana Simon

posted on 12 Jun 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Referral and was interviewed in Dec 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Explain your project experience
Round 2 - Technical 

(1 Question)

  • Q1. Scenario based power bi questions

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - One-on-one 

(2 Questions)

  • Q1. Explain the types of joins.
  • Ans. 

    Joins are used to combine data from two or more tables based on a related column.

    • Inner Join: Returns only the matching rows from both tables.

    • Left Join: Returns all the rows from the left table and matching rows from the right table.

    • Right Join: Returns all the rows from the right table and matching rows from the left table.

    • Full Outer Join: Returns all the rows from both tables, with NULL values in the columns where ther...

  • Answered by AI
  • Q2. Explain the type of relationships and their use case.
  • Ans. 

    Power BI supports three types of relationships: one-to-one, one-to-many, and many-to-many.

    • One-to-one: used when two tables have a unique relationship, such as a person and their social security number.

    • One-to-many: used when one record in the first table can have multiple matching records in the second table, such as a customer and their orders.

    • Many-to-many: used when multiple records in the first table can have multipl...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for DAX practical questions for the final round.

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Feb 2023. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Normal questions on power bi, sql
  • Q2. Normal questions on power bi, sql and service

Interview Preparation Tips

Interview preparation tips for other job seekers - They might call you at anytime and schedule the interview, be ready once you've applied.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Project related questions
  • Q2. DAX and SQL Query

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for various DAX and SQL. Power BI and Power Apps

Interview Questionnaire 

1 Question

  • Q1. How to invoke the xml file using LibXML?
  • Ans. 

    To invoke an XML file using LibXML, use the xmlReadFile() function.

    • Include the libxml/parser.h header file.

    • Use the xmlReadFile() function to read the XML file and create a xmlDocPtr object.

    • Use the xmlDocGetRootElement() function to get the root element of the XML document.

    • Use the xmlNodeGetContent() function to get the content of a node.

    • Use the xmlFreeDoc() function to free the memory allocated for the xmlDocPtr object...

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Core Java and aws

Interview Preparation Tips

Round: Technical Interview
Tips: * Easy technical questions
* Hiring procedure is more of technical assessment + personality assessment

Skills:
College Name: IIT Madras

Interview Questionnaire 

8 Questions

  • Q1. Find a number which occurs odd number of times and all number occurs even number of times
  • Ans. 

    Find an odd occurring number among even occurring numbers.

    • Use XOR operation to cancel out even occurring numbers and get the odd occurring number.

    • Iterate through the array and XOR each element with the result variable.

    • The final result will be the odd occurring number.

  • Answered by AI
  • Q2. Some discussion about my minor project
  • Q3. Spiral order of binary tree and mattrix, print it
  • Ans. 

    Print the spiral order of a binary tree and matrix.

    • For binary tree, use level order traversal and alternate direction for each level.

    • For matrix, use four pointers to traverse in spiral order.

    • Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9

    • Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

  • Answered by AI
  • Q4. Some question about os,dbms
  • Q5. Find pair which have a given sum in a given array
  • Ans. 

    Finding pairs in an array with a given sum.

    • Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.

    • Use a hash table to store the elements of the array and their indices for faster lookup.

    • If there are multiple pairs with the same sum, return any one of them.

    • If no pair is found, return null or an empty array.

  • Answered by AI
  • Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
  • Ans. 

    Find total number of k element with given avg in an array in minimum time complexity.

    • Use sliding window technique to traverse the array in O(n) time complexity.

    • Maintain a sum variable to keep track of the sum of elements in the window.

    • If the sum of elements in the window is equal to k times the given avg, increment the count.

    • Move the window by subtracting the first element and adding the next element in the array.

  • Answered by AI
  • Q7. Print all elements which in not boundary element in a given binary tree
  • Ans. 

    Printing non-boundary elements of a binary tree

    • Traverse the tree in any order (preorder, inorder, postorder)

    • Check if the current node is not a boundary node (not the first or last node in its level)

    • If it is not a boundary node, print its value

    • Recursively traverse its left and right subtrees

  • Answered by AI
  • Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question

Interview Preparation Tips

Round: Test
Experience: practice codes on paper
Tips:

Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail

Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks

Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal

Skills evaluated in this interview

I applied via Company Website and was interviewed in Feb 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. They asked python memory management, string manipulations, regex, and about my current project

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep strong hold on python basics and data structure

I applied via Naukri.com and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions on java8
  • Q2. Questions on multithreading
  • Q3. Questions on exception handling

Interview Preparation Tips

Interview preparation tips for other job seekers - First round was a coding round where interviewer asked questions randomly and were asked to optimise our code. Next round was a technical round where everyone needs to be thorough with their technical skills

S&P Global Interview FAQs

How many rounds are there in S&P Global Power BI Developer interview?
S&P Global interview process usually has 2 rounds. The most common rounds in the S&P Global interview process are Technical.

Tell us how to improve this page.

S&P Global Power BI Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

EXL Service Interview Questions
3.7
 • 740 Interviews
Morningstar Interview Questions
3.9
 • 241 Interviews
Mu Sigma Interview Questions
2.6
 • 229 Interviews
Access Healthcare Interview Questions
3.9
 • 208 Interviews
FactSet Interview Questions
3.9
 • 205 Interviews
Straive Interview Questions
3.4
 • 176 Interviews
AGS Health Interview Questions
4.0
 • 158 Interviews
Nielsen Interview Questions
3.7
 • 117 Interviews
View all
S&P Global Power BI Developer Salary
based on 6 salaries
₹6.5 L/yr - ₹12 L/yr
30% more than the average Power BI Developer Salary in India
View more details
Data Analyst
1.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Researcher
844 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
676 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
614 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Data Analyst
313 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare S&P Global with

Moody's

4.1
Compare

Thomson Reuters

4.1
Compare

Bloomberg

3.4
Compare

Dun & Bradstreet

3.3
Compare
Did you find this page helpful?
Yes No
write
Share an Interview