WNS Denali Data Analyst Interview Questions and Answers

Quant, lr, di, basic english

Q1. Business round with india head of operation
Add your answer

Q1. What is data analysis?
Add your answer
Q2. What stack have you worked with
Ans. 
I have worked with a variety of stacks including Python, SQL, Tableau, and Excel for data analysis.
• Python

• SQL

• Tableau

• Excel
Answered by AI
Add your answer

Q1. How to clean the raw data
Ans. 
Raw data can be cleaned by removing duplicates, handling missing values, standardizing formats, and correcting errors.
• Remove duplicates by identifying unique identifiers and filtering out redundant entries.

• Handle missing values by imputing with mean, median, or mode values or removing rows with missing data.

• Standardize formats by converting data into a consistent format (e.g. date formats, units of measurement).

• Correct...read more
Answered by AI
Add your answer
Q2. How to give relationship for two tables.
Ans. 
To establish a relationship between two tables, use a common key or field that links the records in both tables.
• Use primary and foreign keys to establish relationships between tables.

• Primary key in one table should match the foreign key in another table.

• Types of relationships include one-to-one, one-to-many, and many-to-many.

• Examples: CustomerID in a Customers table can be linked to CustomerID in Orders table.
Answered by AI
Add your answer

Q1. Quants aptitude logical reasoning
Add your answer
Q2. Sales background and advanced excel
Add your answer

Q1. What is SQL server Architecture?
Add your answer

Q1. About experiences and college projects, excel formulas.
Add your answer

Q1. Just common questions on job location and expectations.
Add your answer