Add office photos
WNS logo
Employer?
Claim Account for FREE

WNS

3.4
based on 12k Reviews
Video summary
Filter interviews by
Power BI Developer
Clear (1)

WNS Power BI Developer Interview Questions and Answers

Updated 28 Oct 2024

Q1. 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.

Add your answer
right arrow

Q2. 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 calculations by iterating over each row in a table.

View 1 answer
right arrow

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 visualizations or data points.

  • Interaction mode is useful for presen...read more

Add your answer
right arrow

Q4. 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 columns and hierarchies.

Add your answer
right arrow
Discover WNS interview dos and don'ts from real experiences

Q5. 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 interactive and customized user experience compared to a single...read more

Add your answer
right arrow

Q6. 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%.

Add your answer
right arrow
Contribute & help others!
Write a review
Write a review
Share interview
Share interview
Contribute salary
Contribute salary
Add office photos
Add office photos

Interview Process at WNS Power BI Developer

based on 2 interviews
1 Interview rounds
Resume Shortlist Round
View more
interview tips and stories logo
Interview Tips & Stories
Ace your next interview with expert advice and inspiring stories

Top Power BI Developer Interview Questions from Similar Companies

View all
Recently Viewed
INTERVIEWS
Tracxn
No Interviews
INTERVIEWS
Tracxn
No Interviews
INTERVIEWS
Tracxn
No Interviews
INTERVIEWS
Carwale
No Interviews
INTERVIEWS
Carwale
No Interviews
INTERVIEWS
Uplers
No Interviews
INTERVIEWS
Tracxn
No Interviews
INTERVIEWS
Tracxn
No Interviews
INTERVIEWS
Bajaj Auto
No Interviews
INTERVIEWS
WNS
No Interviews
Share an Interview
Stay ahead in your career. Get AmbitionBox app
play-icon
play-icon
qr-code
Helping over 1 Crore job seekers every month in choosing their right fit company
75 Lakh+

Reviews

5 Lakh+

Interviews

4 Crore+

Salaries

1 Cr+

Users/Month

Contribute to help millions

Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.

Follow us
  • Youtube
  • Instagram
  • LinkedIn
  • Facebook
  • Twitter