Dnata Data Analyst Interview Questions and Answers

Python, sql were asked, 1st round was resume based round

Q1. Power bi project experience, basics of sql, technical documentation
Add your answer

Q1. Discussion related to Salary and Date of joining
Add your answer

Basic coding questions

Q1. Explain in detail about current project? Reason for choosing the algorithm, evaluation metrics and analysis of data
Ans. 
Developed a predictive model for customer churn using logistic regression
• Chose logistic regression for its interpretability and ability to handle binary outcomes

• Evaluated model performance using accuracy, precision, recall, and F1 score

• Analyzed customer data including demographics, purchase history, and customer service interactions
Answered by AI
Add your answer
Q2. Python and sql coding questions - basic
Add your answer
Q3. Linear regression, xgboost, precision, recall, F1 Score,Correlation
Add your answer

Asked very specific questions on Google Cloud
Microservices
Python Coding Questions 2
SQL query 1

Q1. Questions about data factory
Add your answer

Q1. Tell me about a time when you went out of your way to contribute to a project
Add your answer

Q1. What is the difference between a tuple and a list in Python
Ans. 
A tuple is immutable and uses parentheses, while a list is mutable and uses square brackets in Python.
• Tuples are immutable, meaning their elements cannot be changed after creation

• Lists are mutable, allowing for elements to be added, removed, or modified

• Tuples are created using parentheses, while lists use square brackets

• Example: tuple = (1, 2, 3) vs list = [1, 2, 3]
Answered by AI
Add your answer
Q2. How do you access elements in a python dictionary
Ans. 
Access elements in a Python dictionary using keys
• Use square brackets [] with the key to access the value in the dictionary

• Use the get() method to access a value with a default return if the key does not exist

• Use the keys() method to get a list of all keys in the dictionary
Answered by AI
Add your answer

Q1. Name a time you had to resolve conflict in a team setting?
Ans. 
Resolved conflict in team by facilitating open communication and finding common ground.
• Encouraged team members to share their perspectives and concerns

• Acted as a mediator to help parties understand each other's viewpoints

• Facilitated a compromise or solution that addressed everyone's needs
Answered by AI
Add your answer
Q2. What is one of your biggest weaknesses?
Ans. 
One of my biggest weaknesses is my tendency to overthink and second-guess myself.
• I often spend too much time analyzing a problem before taking action

• I sometimes struggle with making decisions quickly

• I am working on trusting my instincts more and being more decisive
Answered by AI
Add your answer

Choose the best answer and question and answer

Tell the topic an send the assignment