WNS Data Analyst Interview Questions, Process, and Tips

Q1. Difference between Sum and Sumx
Ans. 
Sum calculates the total of a column, while Sumx calculates the total of an expression evaluated for each row.
• Sum is used to calculate the total of a column in a table.

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

• Sum: SUM('Table'[Column])

• Sumx: SUMX('Table', 'Table'[Column] * 2)
Answered by AI
Add your answer
Q2. How do u make groups and how bins are different from groups
Ans. 
Groups are created by categorizing data based on certain criteria, while bins are specific ranges used to group continuous data.
• Groups are created by categorizing data based on certain criteria, such as age groups or product categories.

• Bins are specific ranges used to group continuous data, such as age ranges or income brackets.

• Groups can be created based on qualitative data, while bins are used for quantitative data.

• E...read more
Answered by AI
Add your answer
Q3. Why do you prefer power bi over tableau
Ans. 
Power BI is preferred over Tableau for its seamless integration with Microsoft products and user-friendly interface.
• Seamless integration with Microsoft products like Excel, SharePoint, and Teams

• User-friendly interface with drag-and-drop functionality for easy data visualization

• Cost-effective solution for organizations already using Microsoft products

• Faster data processing and refreshing capabilities compared to Tableau

• ...read more
Answered by AI
Add your answer
Q4. Tell me about your roles and responsibilities
Ans. 
I have experience in data collection, analysis, and visualization to support decision-making.
• Collecting and cleaning data from various sources

• Analyzing data to identify trends and patterns

• Creating visualizations and reports to communicate findings

• Collaborating with stakeholders to understand business needs

• Using statistical tools and techniques to draw insights

• Presenting findings to non-technical audiences
Answered by AI
Add your answer

Q1. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot

• List is defined using square brackets [], tuple using parentheses ()

• Example: list - [1, 2, 3], tuple - (1, 2, 3)
Answered by AI
Add your answer
Q2. Nth highest salary
Ans. 
To find the Nth highest salary in a dataset, you can use SQL query with ORDER BY and LIMIT.
• Use SQL query with ORDER BY and LIMIT to sort the salaries in descending order and select the Nth row.

• For example, to find the 3rd highest salary in a table 'employees', you can use: SELECT salary FROM employees ORDER BY salary DESC LIMIT 2, 1
Answered by AI
Add your answer

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

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

• SUMX is often used with iterators like FILTER or RELATEDTABLE to perform calculations on a row-by-row basis
Answered by AI
Add your answer
Q2. How do you use Group By in Power Query?
Ans. 
Group By in Power Query is used to aggregate data based on a specific column or columns.
• Select the column(s) you want to group by

• Go to the 'Transform' tab and click on 'Group By'

• Choose the aggregation type and column to aggregate on

• Rename the new column if needed
Answered by AI
Add your answer

Very easy. Mcq based and easy to solve

Q1. One to one. Easy question. Everything on your resume
Add your answer
Q2. What are sql joins
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• SQL joins are used to retrieve data from multiple tables based on a related column between them

• Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one match in both tables

• LEFT JOIN returns all rows from the left table and the matched rows from the right ...read more
Answered by AI
Add your answer

Q1. Ml and AI algorithms
Add your answer
Q2. No hr. It was technical only. In depth technical questions
Add your answer
Q3. ML algorithms and technologies
Add your answer