AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
S&P Global
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
S&P Global Power BI Developer Interview Questions and Answers
S&P Global Power BI Developer Interview Experiences
1 interview found
Meghana Simon
I applied via Referral and was interviewed in Dec 2023. There were 2 interview rounds.
(1 Question)
- Q1. Explain your project experience
(1 Question)
- Q1. Scenario based power bi questions
Interview questions from similar companies
Anonymous
(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...
- 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...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Feb 2023. There were 2 interview rounds.
(2 Questions)
- Q1. Normal questions on power bi, sql
- Q2. Normal questions on power bi, sql and service
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Project related questions
- Q2. DAX and SQL Query
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in Sep 2023. There was 1 interview round.
(1 Question)
- Q1. General data structure question based
Bisrat Walle Yigzaw
Data Structures and Algorithms
Data Structures and Algorithms
(1 Question)
- Q1. System Design Round
(2 Questions)
- Q1. Tell me about yourself?
- Q2. Why do you want to join our company?
(2 Questions)
- Q1. Two leetcode mid questions
- Q2. One leetcode mid question
(3 Questions)
- Q1. Tell me about yourself
- Ans.
I am a software developer with 5 years of experience in developing web applications using Java, JavaScript, and SQL.
5 years of experience in software development
Proficient in Java, JavaScript, and SQL
Developed web applications for various clients
Strong problem-solving skills
Excellent team player
- Q2. What is your roles and responsibilities
- Ans.
As a Software Developer, my roles and responsibilities include designing, developing, testing, and maintaining software applications.
Designing and developing software applications based on client requirements
Testing and debugging code to ensure functionality and performance
Collaborating with team members to brainstorm and implement new features
Maintaining and updating existing software applications
Staying up-to-date wi
- Q3. Explain about bug lifecycle
- Ans.
Bug lifecycle involves identification, reporting, fixing, retesting, and closing of software bugs.
Identification: Bug is identified by testers or users through testing or real-world usage.
Reporting: Bug is reported to developers with detailed information like steps to reproduce.
Fixing: Developers analyze and fix the bug in the code.
Retesting: Testers verify the fix to ensure the bug is resolved.
Closing: Bug is closed o
(2 Questions)
- Q1. Case study with the topic provided
- Q2. Questions on the resume
Skills evaluated in this interview
Interview Preparation Tips
Tips: * Easy technical questions
* Hiring procedure is more of technical assessment + personality assessment
Skills:
College Name: IIT Madras
SONELAL GUPTA
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.
- 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
- 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.
- 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.
- 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
- Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question
Interview Preparation Tips
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
S&P Global Interview FAQs
Recently Viewed
INTERVIEWS
Patel Infrastructure
No Interviews
INTERVIEWS
S&P Global
No Interviews
INTERVIEWS
S&P Global
No Interviews
INTERVIEWS
Medtronic
No Interviews
REVIEWS
Techno Electric & Engineering Company
No Reviews
INTERVIEWS
Patel Infrastructure
No Interviews
INTERVIEWS
S&P Global
No Interviews
INTERVIEWS
S&P Global
No Interviews
INTERVIEWS
Patel Infrastructure
No Interviews
DESIGNATION
Tell us how to improve this page.
S&P Global Interviews By Designations
- S&P Global Data Analyst Interview Questions
- S&P Global Data Researcher Interview Questions
- S&P Global Research Analyst Interview Questions
- S&P Global Software Engineer Interview Questions
- S&P Global Research Associate Interview Questions
- S&P Global Software Developer Interview Questions
- S&P Global Financial Analyst Interview Questions
- S&P Global Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Power BI Developer Interview Questions
- Power Programmer Interview Questions
- Power Plant Engineer Interview Questions
- MSBI and Power BI Developer Interview Questions
- Power Electronics Engineer Interview Questions
- Power Apps Developer Interview Questions
- Backup Administrator Interview Questions
- Power Plant Manager Interview Questions
- Show more
S&P Global Power BI Developer Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Data Analyst
1.4k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Data Researcher
844
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
681
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
615
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Lead Data Analyst
315
salaries
| ₹0 L/yr - ₹0 L/yr |
Moody's
Thomson Reuters
Bloomberg
Dun & Bradstreet
- Home >
- Interviews >
- S&P Global Interview Questions >
- S&P Global Power BI Developer Interview Questions
