WNS Data Analyst Interview Questions and Answers

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

What are the company data analytics