WNS Data Analyst Interview Questions and Answers

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.

• Example: Grouping customers based on their purchase history...read more

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

• Robust DAX language for creating complex calculations and ...read more

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

SQL Server Architecture refers to the structure and components of the SQL Server database management system.

• SQL Server Architecture consists of three main components: Database Engine, SQL Server Agent, and SQL Server Browser.

• The Database Engine is responsible for storing, processing, and securing data.

• SQL Server Agent handles automation tasks, scheduling jobs, and managing alerts.

• SQL Server Browser helps clients locate and connect to SQL Server instances.

• SQL Server Architectu...read more

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)

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

There are approximately 10 million cars in Delhi.

• Delhi has a population of over 18 million people.

• The number of cars per household in Delhi is increasing.

• There are over 1,000 new cars registered in Delhi every day.

• Traffic congestion is a major issue in Delhi due to the high number of cars.

• The Delhi government has implemented measures to reduce the number of cars on the road, such as the odd-even rule.

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)