Upload Button Icon Add office photos

WNS

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

WNS Power BI Developer Interview Questions, Process, and Tips

Updated 28 Oct 2024

Top WNS Power BI Developer Interview Questions and Answers

View all 6 questions

WNS Power BI Developer Interview Experiences

5 interviews found

Power BI Developer Interview Questions & Answers

user image Govind Prajapat

posted on 28 Oct 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

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

  • Answered by AI

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(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? ...
Round 2 - HR 

(2 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Randomly asked

Power BI Developer Interview Questions Asked at Other Companies

asked in KPMG India
Q1. Types of joins in power Bi & SQL and how it works?
asked in KPMG India
Q2. Difference between Sum and Sumx? And also Summerize vs Summerized ... read more
Q3. what are the difference between page level and report level filte ... read more
asked in Infosys
Q4. What is difference between calculate column and measures?
asked in KPMG India
Q5. Difference between calculate and calculate table ?
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

(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

  • Answered by AI
  • 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
  • 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...

  • Answered by AI
  • 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
  • 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

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn about power bi and sql which will give you more chance to clear

Skills evaluated in this interview

I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Situation based question and Dax function,and security level question
Round 3 - Technical 

(1 Question)

  • Q1. Similar question in 3rd round as well
Round 4 - Client Interview 

(1 Question)

  • Q1. Client ask for job change , tell you about the role and responsibilities
Round 5 - HR 

(1 Question)

  • Q1. Family related question and salary expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on core concept of power bi, ready for situation based question and having good command over DAX

WNS interview questions for designations

 Developer

 (1)

 Software Developer

 (1)

 Backend Developer

 (1)

 Web Developer

 (1)

 VBA Developer

 (1)

 Data Engineer

 (5)

 Senior Associate Consultant

 (3)

 Programmer Analyst

 (3)

I applied via Naukri.com and was interviewed before Oct 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

English, maths, gk, reasoning

Round 3 - HR 

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - You doing only our knowledge,experience and key responsibilities.

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.

Round 1 - Aptitude Test 
Round 2 - Coding Test 
Round 3 - Technical 

(1 Question)

  • Q1. Sql and os related questions,Java based
Round 4 - HR 

(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

Interview preparation tips for other job seekers - Whoever seeing this.. you will acheive your goals

I applied via Naukri.com and was interviewed before Oct 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Technical 

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

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - My advice is without techinical knowledge plz Don't attend the interview.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain your overall experience.
  • Ans. 

    I have 5 years of experience as a Power BI Developer.

    • Developed interactive dashboards and reports using Power BI

    • Created data models and performed data analysis

    • Worked with various data sources such as SQL Server, Excel, and SharePoint

    • Implemented data transformations and data cleansing

    • Collaborated with business stakeholders to gather requirements and provide insights

    • Optimized performance and improved data visualization

    • Tr...

  • Answered by AI
  • Q2. Explain your recent experience.
  • Ans. 

    I have recently worked as a Power BI Developer, creating interactive dashboards and reports.

    • Developed interactive dashboards and reports using Power BI

    • Gathered requirements from stakeholders and translated them into data visualizations

    • Created data models and implemented data transformations

    • Collaborated with cross-functional teams to ensure data accuracy and consistency

    • Provided training and support to end-users for effe

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to score more than 75% to clear the online assessment.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Not Selected
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - HR 

(2 Questions)

  • Q1. 1. what is the current company?. 2. what is the current CTC and ECTC ? 3. are u contract are direct payrool?
  • Ans. 

    The current company is XYZ Corporation.

    • The current company is XYZ Corporation.

    • XYZ Corporation is a multinational technology company.

    • XYZ Corporation specializes in software development and data analytics.

    • XYZ Corporation has a strong presence in the Power BI industry.

  • Answered by AI
  • Q2. Where u work location?
  • Ans. 

    I work remotely from my home office.

    • I work from a dedicated home office space.

    • I have all the necessary equipment and tools to work remotely.

    • I communicate with my team and clients through online collaboration tools.

    • I am available for meetings and discussions via video conferencing.

    • I maintain a productive work environment at home.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It's very nice asking my interview question. some questions I don't have answer.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-

I applied via Job Portal

Round 1 - Technical 

(1 Question)

  • Q1. Introduction, about the Project , Complex Dax written in project
Contribute & help others!
anonymous
You can choose to be anonymous

WNS Interview FAQs

How many rounds are there in WNS Power BI Developer interview?
WNS interview process usually has 2-3 rounds. The most common rounds in the WNS interview process are Resume Shortlist, Technical and HR.
How to prepare for WNS Power BI Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at WNS. The most common topics and skills that interviewers at WNS expect are Power Bi, Data Analytics, Excel, Analytical Skills and Communication Skills.
What are the top questions asked in WNS Power BI Developer interview?

Some of the top questions asked at the WNS Power BI Developer interview -

  1. Define different type of filters available in power...read more
  2. Difference between sum and S...read more
  3. Define interaction mode in power...read more

Recently Viewed

REVIEWS

PEARCE SERVICES

No Reviews

INTERVIEWS

Tracxn

No Interviews

SALARIES

Tracxn

REVIEWS

Carwale

No Reviews

INTERVIEWS

Tracxn

No Interviews

JOBS

Iris Software

No Jobs

REVIEWS

Forbes Marshall

No Reviews

INTERVIEWS

Bajaj Auto

No Interviews

INTERVIEWS

Tracxn

30 top interview questions

INTERVIEWS

Uplers

No Interviews

Tell us how to improve this page.

WNS Power BI Developer Interview Process

based on 2 interviews

1 Interview rounds

  • Resume Shortlist Round
View more
WNS Power BI Developer Salary
based on 43 salaries
₹3.5 L/yr - ₹14.9 L/yr
32% more than the average Power BI Developer Salary in India
View more details

WNS Power BI Developer Reviews and Ratings

based on 7 reviews

4.5/5

Rating in categories

3.9

Skill development

4.3

Work-life balance

4.4

Salary

4.4

Job security

4.3

Company culture

3.4

Promotions

4.3

Work satisfaction

Explore 7 Reviews and Ratings
Senior Associate
13.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate
4.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Lead
3.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
3.1k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate Operations
2.9k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare WNS with

TCS

3.7
Compare

Infosys

3.6
Compare

HCLTech

3.5
Compare

Tech Mahindra

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview