AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
WNS Power BI Developer Interview Questions, Process, and Tips
Top WNS Power BI Developer Interview Questions and Answers
- Q1. Define different type of filters available in power bi
- Q2. Difference between sum and SUMX
- Q3. Define interaction mode in power bi
WNS Power BI Developer Interview Experiences
5 interviews found
Govind Prajapat
(2 Questions)
- Q1. Time intelligence functions
- 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...
Skills evaluated in this interview
Anonymous
(1 Question)
- 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? ...
(2 Questions)
- Q1. What is your expecting salary
- Q2. Is it possible relocate
Interview Preparation Tips
(5 Questions)
- 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
- 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%.
- 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...
- 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.
- 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
Interview Preparation Tips
Skills evaluated in this interview
What people are saying about WNS
I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 5 interview rounds.
(1 Question)
- Q1. Situation based question and Dax function,and security level question
(1 Question)
- Q1. Similar question in 3rd round as well
(1 Question)
- Q1. Client ask for job change , tell you about the role and responsibilities
(1 Question)
- Q1. Family related question and salary expectation
Interview Preparation Tips
WNS interview questions for designations
I applied via Naukri.com and was interviewed before Oct 2021. There were 3 interview rounds.
English, maths, gk, reasoning
(2 Questions)
- Q1. What is your current salary. What is your highest qualification.
- 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...
Interview Preparation Tips
Get interview-ready with Top WNS Interview Questions
Interview questions from similar companies
I applied via Campus Placement and was interviewed before Feb 2021. There were 4 interview rounds.
(1 Question)
- Q1. Sql and os related questions,Java based
(4 Questions)
- Q1. What are your salary expectations?
- Q2. What is your family background?
- Q3. Where do you see yourself in 5 years?
- Q4. Tell me about yourself.
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.
(2 Questions)
- Q1. Can you please explain previous experience?
- Q2. Can you explain about import model ?
- Ans.
Import model is a Power BI feature that allows you to import data from various sources and create a data model.
Import model is used to create a data model in Power BI.
It allows you to import data from various sources such as Excel, CSV, SQL Server, etc.
You can create relationships between tables, add calculated columns, and measures.
Import model is useful when you have large amounts of data that need to be transformed ...
Interview Preparation Tips
Vedant Sugandh
(2 Questions)
- Q1. ROW LEVEL SECURITY
- Q2. SUM, SUMIF SUMIFS AND DELETE TRUNCATE
Selected
I applied via Naukri.com and was interviewed in Feb 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Difference Between direct query mode and import mode
- Ans.
Direct query mode connects to data source in real-time, while import mode loads data into Power BI for faster analysis.
Direct query mode connects to data source in real-time, providing up-to-date data
Import mode loads data into Power BI for faster analysis, but may not always reflect real-time changes
Direct query mode is suitable for large datasets that require real-time updates
Import mode is suitable for smaller datas
- Q2. Define powerBI in layman poin of view
- Ans.
PowerBI is a data visualization tool that helps users analyze and visualize data to make informed business decisions.
PowerBI helps in creating interactive reports and dashboards
It allows users to connect to various data sources like Excel, SQL databases, and cloud services
Users can create custom visualizations and share insights with others
PowerBI can be used for data exploration, data modeling, and data storytelling
(1 Question)
- Q1. How the end user access the report
- Ans.
End users can access the report through Power BI Service, Power BI Mobile App, or embedded in other applications.
End users can access the report through Power BI Service by logging in with their credentials
End users can also access the report through Power BI Mobile App on their smartphones or tablets
Reports can be embedded in other applications using Power BI Embedded feature
Interview Preparation Tips
Interview Questionnaire
1 Question
- Q1. What is a power bi
- Ans.
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.
Power BI is a Microsoft product used for data analysis and visualization.
It allows users to connect to various data sources and create interactive reports and dashboards.
Power BI provides a wide range of visualizations, such as charts, maps, and tables, to represent data.
Users can create custom calculat...
Skills evaluated in this interview
WNS Interview FAQs
Tell us how to improve this page.
WNS Interviews By Designations
- WNS Senior Associate Interview Questions
- WNS Associate Interview Questions
- WNS Operations Associate Interview Questions
- WNS Associate Lead Interview Questions
- WNS Senior Associate Operations Interview Questions
- WNS Assistant Manager Interview Questions
- WNS Back Office Executive Interview Questions
- WNS 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 Electronics Engineer Interview Questions
- Power Apps Developer Interview Questions
- Backup Administrator Interview Questions
- Power Plant Manager Interview Questions
- Show more
WNS Power BI Developer Interview Process
based on 2 interviews
1 Interview rounds
- Resume Shortlist Round
Power BI Developer Interview Questions from Similar Companies
Fast track your campus placements
WNS Power BI Developer Reviews and Ratings
based on 7 reviews
Rating in categories
|
Senior Associate
13.4k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Associate
4.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Lead
3.3k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
3.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Associate Operations
2.9k
salaries
| ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
HCLTech
Tech Mahindra
- Home >
- Interviews >
- WNS Interview Questions >
- WNS Power BI Developer Interview Questions
