Add office photos
Filter interviews by
WNS Denali Data Analyst Interview Questions and Answers
WNS Denali Data Analyst Interview Experiences
1 interview found
Anonymous
Phython test and certification was checked
(2 Questions)
- Q1. Self introduction and knowledge about wns
- Q2. Salary expectations and why should We hire you
Top trending discussions
Interview questions from similar companies
Sudheer Saladhi
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
(2 Questions)
- 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...
- 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.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
SQL based questions wer asked on joins , rank function,
Sonu Patel
(1 Question)
- Q1. What is SQL server Architecture?
- Ans.
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...
Skills evaluated in this interview
I applied via Walk-in and was interviewed before Dec 2023. There was 1 interview round.
(2 Questions)
- Q1. What is data analysis?
- Ans.
Data analysis is the process of inspecting, cleaning, transforming, and modeling data to discover useful information, draw conclusions, and support decision-making.
Data analysis involves examining raw data to find patterns, trends, and insights.
It includes cleaning and organizing data, performing statistical analysis, and creating visualizations.
Data analysis helps businesses make informed decisions, improve processes,...
- 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
I applied via Naukri.com and was interviewed before Nov 2020. There were 4 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Statistical Questions
- Q2. Market Mix modelling
- Q3. Assignment as detailed below
Interview Preparation Tips
CRM assignment - Evaluation will be done based on Visualization, out of box analytics and analytical thinking.
Call Forecasting - Forecast how many calls might come in the next month using data provided.
I had cleared all these. To my surprise having two rounds and then technical test was enough to talk some formalities and discuss CTC but here they came prepared with their scenario questions bucket which is not relevant to data analyst part. The main reason, they wanted to steal idea from a potential employee and implement them to their work as they feel being insignificant in their role. pathetic company to say the least.
Basic aptitude test maths and English
(1 Question)
- Q1. Excel, tableau, power BI and basic questions
VARSHA ROY
(1 Question)
- Q1. 1. What is filter? 2. What is your skills? 3. Some queries like :- In employees table find the name which employee_id is 152?
- Ans.
Filter is a tool used to sort and display specific data based on certain criteria.
Filters are commonly used in databases and spreadsheets to extract specific information.
They can be applied to columns or rows to display only the data that meets the specified criteria.
Examples of filters include sorting by date, alphabetical order, or numerical value.
In SQL, the WHERE clause is used to filter data based on specific cond
Interview Preparation Tips
Go through all the points which you have mention in your resume ,interviewer may ask you . listen carefully to your interviewer what they want to know from your side ...always keep in mind that the ball is in your hand ...if you don't know the answer directly say them i don't know, say them which topics you know very confidentially.
I applied via Campus Placement and was interviewed in Apr 2022. There were 3 interview rounds.
Python and Sql questions
(1 Question)
- Q1. Python, mongodb, project
Interview Preparation Tips
Interview Questionnaire
3 Questions
- Q1. Guesstimates - Cars in delhi
- Ans.
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.
- Q2. Case Interviews - toll cost
- Q3. General Aptitude - Maths
WNS Denali Interview FAQs
Tell us how to improve this page.
WNS Denali Interviews By Designations
- WNS Denali Senior Analyst Interview Questions
- WNS Denali Senior Associate Interview Questions
- WNS Denali Accountant Interview Questions
- WNS Denali Associate Interview Questions
- WNS Denali Back Office Executive Interview Questions
- WNS Denali Consultant Interview Questions
- WNS Denali Customer Service Executive Interview Questions
- WNS Denali Data Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Data Analyst Interview Questions from Similar Companies
WNS Denali Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Senior Analyst
98
salaries
|  ₹3.6 L/yr - ₹10 L/yr |
|
Senior Associate
46
salaries
| ₹4.8 L/yr - ₹18.4 L/yr |
|
Associate
43
salaries
| ₹4.8 L/yr - ₹13.2 L/yr |
|
Senior Procurement Analyst
41
salaries
| ₹4 L/yr - ₹8.5 L/yr |
|
Assistant Manager
31
salaries
| ₹8 L/yr - ₹15.4 L/yr |
Accenture
Genpact
TCS
Infosys
Calculate your in-hand salary
- Home >
- Interviews >
- WNS Denali Interview Questions >
- WNS Denali Data Analyst Interview Questions
