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
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
Power BI Developer Jobs at S&P Global
Interview questions from similar companies
Anonymous
I appeared for an interview in Feb 2025, where I was asked the following questions.
- Q1. Write a DAX query to calculate the YTD running total ensuring that selection of the year should be through slicers & only one year at a time can be selected if more are selected the warning message should ...
- Ans.
DAX query for YTD running total with single year selection and warning for multiple selections.
Use the DATESYTD function to calculate the year-to-date total.
Implement a measure to check the number of selected years using COUNTROWS and VALUES.
Display a warning message using a conditional statement if more than one year is selected.
Example DAX measure: YTD Total = CALCULATE(SUM(Sales[Amount]), DATESYTD(Sales[Date]))
Examp...
- Q2. Write a SQL query to identify the payment id/ transaction ids made at the same merchant with same amount and with same order id using the same credit card however the timestamp in which the transaction hap...
(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
I applied via Naukri.com and was interviewed before May 2020. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. SQL Joins
- Q2. Swap 2 numbers without 3rd variable
- Ans.
Swapping two numbers without using a third variable
Use arithmetic operations to swap the values
Add the two numbers and store the result in the first variable
Subtract the second number from the result and store it in the second variable
Subtract the second variable from the first variable to get the original value of the second variable
Interview Preparation Tips
2nd Round : Technical Interview
3rd Round : Technical Interview and HR questions
Skills evaluated in this interview
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...
Skills evaluated in this interview
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.
Array,binary search, Aptitude
(1 Question)
- Q1. Coding Questions, java, Web development
(1 Question)
- Q1. Just normal Questions
Selected
I applied via Company Website and was interviewed in Jul 2022. There were 4 interview rounds.
Apt + coding questions, medium difficulty
(1 Question)
- Q1. Basics qs on oops and known programming language
(1 Question)
- Q1. In-depth of oops and live coding questions
(1 Question)
- Q1. Basics qs like y and what
S&P Global Interview FAQs
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 Financial Analyst Interview Questions
- S&P Global Research Associate Interview Questions
- S&P Global Software Developer 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 Apps Developer Interview Questions
- Backup Administrator Interview Questions
- Power Electronics Engineer 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.5k
salaries
|  ₹2 L/yr - ₹10.8 L/yr |
|
Data Researcher
845
salaries
| ₹2.5 L/yr - ₹7.6 L/yr |
|
Senior Software Engineer
701
salaries
| ₹11.5 L/yr - ₹40 L/yr |
|
Software Engineer
619
salaries
| ₹10 L/yr - ₹36.5 L/yr |
|
Lead Data Analyst
316
salaries
| ₹4.5 L/yr - ₹13.2 L/yr |
EXL Service
Access Healthcare
AGS Health
Straive
- Home >
- Interviews >
- S&P Global Interview Questions >
- S&P Global Power BI Developer Interview Questions
