KPMG India MSBI and Power BI Developer Interview Questions and Answers

Q1. What is calculated col and measure
Ans. 
Calculated columns are columns created in Power BI by using DAX formulas, while measures are calculations based on the data model.
• Calculated columns are static and stored in the data model, while measures are dynamic and calculated on the fly.

• Calculated columns are used for adding new data to a table, while measures are used for aggregating data or performing calculations.

• Examples of calculated columns include adding a...read more
Answered by AI
Add your answer
Q2. What is numerical range parameter
Ans. 
Numerical range parameter is a parameter that defines a range of numerical values for a specific variable or function.
• It is used to specify a range of numerical values that a parameter can take.

• It helps in filtering data based on a specific numerical range.

• For example, a numerical range parameter can be used to filter sales data for products with prices between $50 and $100.
Answered by AI
Add your answer
Q3. What is field parameter
Ans. 
A field parameter is a variable that is used to pass values to a function or method.
• Field parameters are used to customize the behavior of functions or methods.

• They can be used to filter, sort, or group data in Power BI reports.

• Examples include filtering data based on a specific date range or sorting data by revenue.
Answered by AI
Add your answer

Q1. Online technical round for 20 mins MCQs (Moderate level)
Add your answer

Power BI Report Development - Hands on for 1 hour (Intermediate to Advance level)

Q1. Technical F2F for 30-40 mins (Intermediate level)
Add your answer

Q1. Technical F2F for 30 mins (Advance level)
Add your answer

Q1. What is the need of inactive relationship?
Add your answer
Q2. Explain various roles in power BI service
Add your answer

Q1. DAX ? WHAT ARE TIME INTELLIGENCE FNCS
Ans. 
Time intelligence functions in DAX are used to perform calculations based on dates and times.
• Time intelligence functions help in comparing data over different time periods.

• Functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATESBETWEEN are commonly used for time intelligence.

• They can be used to calculate year-to-date totals, compare values with previous periods, and more.
Answered by AI
Add your answer
Q2. FOCUS ON SQL AND DAX
Add your answer

Q1. Introduction questions
Add your answer
Q2. Technical questions
Add your answer

Q1. Introduction questions
Add your answer
Q2. Salary description
Add your answer

Q1. All filter in Power BI
Ans. 
Filters in Power BI allow users to slice and dice data to focus on specific information.
• Filters can be applied at report, page, or visual level

• Types of filters include slicers, cross-filtering, and drill-through filters

• Filters can be based on specific values, ranges, or conditions
Answered by AI
Add your answer

Q1. Sumx difference between sum
Ans. 
SUMX calculates the total of an expression evaluated for each row in a table, while SUM calculates the total of a column.
• SUMX is an iterator function in DAX that allows you to iterate over a table and perform calculations on each row.

• SUMX is commonly used to calculate a total based on a formula or expression applied to each row.

• SUM, on the other hand, simply calculates the total of a column without any iteration over r...read more
Answered by AI
Add your answer