Upload Button Icon Add office photos

Filter interviews by

Dnata Business Intelligence Analyst Interview Questions and Answers

Updated 24 Jun 2023

Dnata Business Intelligence Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jun 2022. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Previous job description
Round 2 - One-on-one 

(3 Questions)

  • Q1. Questions related to Excel and power pivot
  • Q2. Power bi and power query
  • Q3. Visualization and data structures

Interview Preparation Tips

Topics to prepare for Dnata Business Intelligence Analyst interview:
  • Power Bi
  • Dax
  • Power query
  • Advanced Excel
  • Presentation Skills
Interview preparation tips for other job seekers - Just use basic formulas for daxes and you are good to go.

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Birla Institute of Technology and Science (BITS), Pilani and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Basics of linear regression
Round 2 - Technical 

(1 Question)

  • Q1. Machine learning in depth
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Aug 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain how did you handle the imbalance in data
  • Ans. 

    I handled data imbalance by using techniques like oversampling, undersampling, SMOTE, or using ensemble methods.

    • Used oversampling to increase minority class instances

    • Used undersampling to decrease majority class instances

    • Applied SMOTE (Synthetic Minority Over-sampling Technique) to generate synthetic samples for minority class

    • Utilized ensemble methods like Random Forest or Gradient Boosting to handle imbalance

  • Answered by AI
  • Q2. Write a sql query for the given problem statement. Can be solved using advanced concepts like lead and lag
Round 2 - Group Discussion 

Advanced sql and basics of data science

Interview Preparation Tips

Interview preparation tips for other job seekers - Not clear vision for the candidates joining as they don’t have the understanding of their future scope of the team. The interview will be fairly easy if you are well versed in sql. No questions asked on python. Project level understanding for data science only.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Basic coding questions

Round 2 - Technical 

(3 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
  • Q2. Python and sql coding questions - basic
  • Q3. Linear regression, xgboost, precision, recall, F1 Score,Correlation
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in Feb 2024. There was 1 interview round.

Round 1 - One-on-one 

(5 Questions)

  • Q1. Picks one of the Projects to discuss the structure and methodology.
  • Q2. Reverse a String
  • Ans. 

    Reverse a given string

    • Use built-in functions like reverse() or slice() in Python

    • Iterate through the string in reverse order and append characters to a new string

    • Convert the string to an array of characters, reverse the array, and join it back into a string

  • Answered by AI
  • Q3. Basic ML Questions about Resume Projects
  • Q4. What is Regularization?
  • Ans. 

    Regularization is a technique used to prevent overfitting in machine learning models by adding a penalty term to the loss function.

    • Regularization helps to reduce the complexity of the model by penalizing large coefficients.

    • It adds a penalty term to the loss function, such as L1 (Lasso) or L2 (Ridge) regularization.

    • Regularization helps to improve the generalization of the model by discouraging overfitting.

    • Examples of re...

  • Answered by AI
  • Q5. Basics about Forescasting.

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Feb 2024. There were 3 interview rounds.

Round 1 - Assignment 

Hackerank Assignment

Round 2 - Technical 

(1 Question)

  • Q1. Coding and ML questions
Round 3 - Technical 

(1 Question)

  • Q1. About projects and questions related to that

Data Scientist Interview Questions & Answers

Boeing user image Ashish Kumar Ray

posted on 1 Sep 2022

I applied via Approached by Company and was interviewed in Mar 2022. There were 3 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. What kind of project you have done give some brief. How you will avoid over fiting to model. How will you handle missing data points in a data frame. Why you want to join our company.
Round 2 - One-on-one 

(1 Question)

  • Q1. Behavioral question was asked by manager.
Round 3 - HR 

(1 Question)

  • Q1. CTC discussion was done

Interview Preparation Tips

Interview preparation tips for other job seekers - Try to give best and rest live on hands of God

Dnata Interview FAQs

How many rounds are there in Dnata Business Intelligence Analyst interview?
Dnata interview process usually has 3 rounds. The most common rounds in the Dnata interview process are Resume Shortlist, HR and One-on-one Round.
How to prepare for Dnata Business Intelligence Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Dnata. The most common topics and skills that interviewers at Dnata expect are Back Office, Business Intelligence, Data Analysis, Data Collection and Gap Analysis.
What are the top questions asked in Dnata Business Intelligence Analyst interview?

Some of the top questions asked at the Dnata Business Intelligence Analyst interview -

  1. Questions related to Excel and power pi...read more
  2. Visualization and data structu...read more
  3. Power bi and power qu...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Air India Interview Questions
3.8
 • 166 Interviews
Spicejet Interview Questions
3.6
 • 91 Interviews
Boeing Interview Questions
3.9
 • 82 Interviews
GMR Group Interview Questions
4.1
 • 75 Interviews
Qatar Airways Interview Questions
4.0
 • 59 Interviews
AirAsia Interview Questions
3.6
 • 31 Interviews
British Airways Interview Questions
3.1
 • 28 Interviews
View all
Dnata Business Intelligence Analyst Salary
based on 4 salaries
₹7.4 L/yr - ₹10 L/yr
At par with the average Business Intelligence Analyst Salary in India
View more details

Dnata Business Intelligence Analyst Reviews and Ratings

based on 1 review

2.0/5

Rating in categories

2.0

Skill development

2.0

Work-life balance

2.0

Salary

5.0

Job security

1.0

Company culture

2.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Travel Consultant
118 salaries
unlock blur

₹2.7 L/yr - ₹8 L/yr

Senior Travel Consultant
105 salaries
unlock blur

₹4 L/yr - ₹7.5 L/yr

Travel Executive
46 salaries
unlock blur

₹2.3 L/yr - ₹5.3 L/yr

Travel Assistant
31 salaries
unlock blur

₹2.7 L/yr - ₹4.5 L/yr

Team Lead
27 salaries
unlock blur

₹6.2 L/yr - ₹11 L/yr

Explore more salaries
Compare Dnata with

Celebi Airport Services India

3.6
Compare

Bird Group

3.2
Compare

GMR Group

4.1
Compare

GVK Group

4.1
Compare
Did you find this page helpful?
Yes No
write
Share an Interview