QX Global Group Power BI Developer Interview Questions and Answers

Q1. What is the DAX formula for calculating a running total?
Ans. 
The DAX formula for calculating a running total is using the CALCULATE function with the FILTER function.
• Use the CALCULATE function to evaluate an expression in a context modified by filters.

• Use the FILTER function to return a table that represents a subset of another table or expression.

• Combine CALCULATE and FILTER functions to calculate a running total.
Answered by AI
Add your answer
Q2. What is the DAX formula for replacing blank values with zero and vice versa?
Ans. 
The DAX formula for replacing blank values with zero and vice versa is IF(ISBLANK(), 0, BLANK())
• Use the IF function in DAX to check if a value is blank

• If the value is blank, return 0. If not, return blank()
Answered by AI
Add your answer
Q3. SQL Queries for the above scenarios
Ans. 
SQL queries are essential for data manipulation and retrieval in Power BI, enabling effective data analysis.
• Use SELECT statements to retrieve data: e.g., SELECT * FROM Patients;

• Implement JOINs to combine data from multiple tables: e.g., SELECT a.Name, b.Diagnosis FROM Patients a JOIN Diagnoses b ON a.ID = b.PatientID;

• Utilize WHERE clauses for filtering data: e.g., SELECT * FROM Appointments WHERE Date > '2023-01-01'...read more
Answered by AI
Add your answer

Q1. What are your previous work experiences?
Ans. 
I have 3 years of experience as a Power BI Developer in a consulting firm.
• Developed interactive dashboards and reports using Power BI

• Worked closely with business stakeholders to gather requirements

• Optimized data models for performance and efficiency
Answered by AI
Add your answer
Q2. Salary negotiations etc.
Add your answer

Q1. Core language and logical basic oops questions you have to learn
Add your answer
Q2. 1. Tell me about your self, 2. How many years of experience you have in which is your core language? 3. Explain me oops concepts? 4. Focus on inheritance & abstraction questions? 5. Give some logical codin...read more
Add your answer

General discussion checks communications

Basic logical program like palindrome

It was easy and u can do it very easily

Basically question were asked from tree, bst, greedy

Q1. Union and union all difference
Ans. 
UNION combines the results of two or more SELECT statements, while UNION ALL includes duplicates.
• UNION removes duplicate rows, while UNION ALL retains all rows including duplicates

• UNION is slower than UNION ALL as it performs a distinct operation

• UNION requires the same number of columns in the SELECT statements, while UNION ALL does not have this restriction
Answered by AI
Add your answer
Q2. What is generic and non-generic collections
Ans. 
Generic collections allow storing any type of data, while non-generic collections are type-specific.
• Generic collections can store any type of data, such as List or Dictionary.

• Non-generic collections are type-specific, like ArrayList or HashTable.

• Generic collections provide type safety and better performance compared to non-generic collections.
Answered by AI
Add your answer

Q1. OOPS & CORE JAVA CONCEPTS
Add your answer
Q2. Concepts such as Polymorphism and inheritance
Add your answer

Round duration - 126 minutes
Round difficulty - Hard

This round consist of coding questions as well as mcqs based on aptitude as well as some domain sections. This round is hard.

Q1. 
Maximum Path Sum in a Matrix
Given an N*M matrix filled with integer numbers, determine the maximum sum that can be obtained from a path starting from any cell in the first row to any cell in the last row...read more
Ans. 
Find the maximum sum path in a matrix from top row to bottom row by moving down or diagonally.
• Use dynamic programming to keep track of maximum sum at each cell.

• At each cell, consider the maximum sum from the cell above, left diagonal, and right diagonal.

• Add the current cell value to the maximum of the three possibilities.

• Repeat this process for all cells in the matrix to find the maximum sum path.
Answered by AI
Add your answer
Q2. 
Boolean Matrix Transformation Challenge
Given a 2-dimensional boolean matrix mat of size N x M, your task is to modify the matrix such that if any element is 1, set its entire row and column to 1. Specifi...read more
Ans. 
Modify a boolean matrix such that if any element is 1, set its entire row and column to 1.
• Iterate through the matrix to find elements with value 1

• Store the row and column indices of these elements

• Update the entire row and column for each element found to be 1
Answered by AI
Add your answer

Round duration - 45 minutes
Round difficulty - Easy

In this round the interviewer ask few questions related to domain and at last he ask some behavioral questions.

Q1. 
Intersection of Linked List Problem
You are provided with two singly linked lists containing integers, where both lists converge at some node belonging to a third linked list.
Your task is to determine t...read more
Ans. 
Find the node where two linked lists merge, return -1 if no merging occurs.
• Traverse both lists to find the lengths and the last nodes

• Align the starting points of the lists by adjusting the pointers

• Traverse both lists simultaneously until a common node is found
Answered by AI
Add your answer