Concentrix Corporation Power BI Developer Interview Questions and Answers

Q1. Difference between sum and SUMX
Ans. 
SUM calculates the sum of a column or expression, while SUMX calculates the sum of an expression evaluated for each row in a table.
• SUM is used to calculate the sum of a column or expression in Power BI.

• SUMX is used to calculate the sum of an expression evaluated for each row in a table.

• SUM is typically used with columns, while SUMX is used with tables or filtered tables.

• SUMX can be used to perform more complex calculat
Answered by AI
View 1 more answer
Q2. Define ROS in power BI
Ans. 
ROS stands for Return on Sales in Power BI.
• ROS is a financial metric used to measure the profitability of a company.

• It is calculated by dividing the net income by the total revenue.

• ROS is expressed as a percentage and is used to evaluate a company's efficiency in generating profits.

• For example, if a company has a net income of $100,000 and total revenue of $1,000,000, the ROS would be 10%.
Answered by AI
Add your answer
Q3. Define interaction mode in power bi
Ans. 
Interaction mode in Power BI allows users to interact with visualizations and explore data in a more dynamic way.
• Interaction mode can be accessed by clicking on the 'Focus mode' button in the top right corner of a visualization.

• In interaction mode, users can hover over data points to see more information, filter data, and drill down into details.

• Users can also use the 'Selection pane' to show or hide specific visualiza...read more
Answered by AI
Add your answer
Q4. Define different type of filters available in power bi
Ans. 
Power BI has various types of filters such as visual, page, report, drill-through, and slicer filters.
• Visual filters apply to a single visual or chart.

• Page filters apply to all visuals on a single page.

• Report filters apply to all visuals in a report.

• Drill-through filters allow users to navigate to more detailed data.

• Slicer filters allow users to filter data across multiple visuals.
Answered by AI
Add your answer
Q5. Define schema for n power bi
Ans. 
Schema for n Power BI is the structure of the data model used to organize and connect data sources.
• Schema defines the relationships between tables, columns, and measures.

• It helps in creating a logical model of the data.

• Schema can be created using Power BI Desktop or Power BI Service.

• Example: A schema for sales data may include tables for customers, products, and sales transactions.

• Schema can also include calculated col
Answered by AI
Add your answer

Q1. 1.whawhat are the challenges faced in your project? 2.what is difference between active & inactive relationship & explain detailed with 1 example? 3.what is star schama & snow flake schema & give example? ...read more
Add your answer

Q1. What is your expecting salary
Add your answer
Q2. Is it possible relocate
Add your answer

English, maths, gk, reasoning

Q1. What is your current salary. What is your highest qualification.
Add your answer
Q2. When you join our company
Ans. 
I will bring my expertise in Power BI development and contribute to the success of the company.
• I have extensive experience in creating interactive dashboards and reports using Power BI.

• I am proficient in data modeling, DAX calculations, and data visualization techniques.

• I have a strong understanding of business requirements and can translate them into effective Power BI solutions.

• I am familiar with connecting to variou...read more
Answered by AI
Add your answer

Q1. Situation based question and Dax function,and security level question
Add your answer

Q1. Similar question in 3rd round as well
Add your answer

Q1. Client ask for job change , tell you about the role and responsibilities
Add your answer

Q1. Family related question and salary expectation
Add your answer

Q1. Time intelligence functions
Add your answer
Q2. Difference between Power BI Report and Power BI App
Ans. 
Power BI Report is a single report page, while Power BI App is a collection of multiple reports and dashboards.
• Power BI Report is a single page report with visualizations and data insights.

• Power BI App is a collection of multiple reports, dashboards, and datasets organized together.

• Power BI Report can be shared individually, while Power BI App is shared as a package of related content.

• Power BI App allows for more inter...read more
Answered by AI
Add your answer

Strictly know about advanced coding languages like python.

Be focus on aptitude and reasoning too....