Upload Button Icon Add office photos

Filter interviews by

BT Group Business Intelligence Developer Interview Questions and Answers

Updated 23 Aug 2024

BT Group Business Intelligence Developer Interview Experiences

1 interview found

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

I was interviewed before Aug 2023.

Round 1 - Technical 

(4 Questions)

  • Q1. Diff between Union and Union All
  • Ans. 

    Union combines and removes duplicates, Union All combines without removing duplicates.

    • Union combines result sets and removes duplicates

    • Union All combines result sets without removing duplicates

    • Union is slower than Union All as it involves removing duplicates

    • Union All is faster than Union as it does not remove duplicates

  • Answered by AI
  • Q2. Sets and their uses in Tableau
  • Ans. 

    Sets in Tableau are custom fields that define a subset of data based on certain conditions.

    • Sets can be used to group related data together for analysis

    • Sets can be created based on dimensions or measures

    • Sets can be used in calculations, filters, and visualizations

    • Examples: creating a set of top customers, creating a set of high-value products

  • Answered by AI
  • Q3. Query to find 2nd highest salary
  • Ans. 

    Query to find 2nd highest salary in a database table

    • Use the ORDER BY clause to sort the salaries in descending order

    • Use the LIMIT clause to retrieve the second row

  • Answered by AI
  • Q4. Some more basic questions
Round 2 - Case Study 

Given some pointers, how will I manage the stakeholders and plan.

Interview Preparation Tips

Interview preparation tips for other job seekers - Revise the basics
Don't forget, it's not just you who need a job; it's the company as well that need you

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Hard
Process Duration
2-4 weeks
Result
No response

I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Difference between Data Warehouse, Data Lakes and Tables
  • Ans. 

    Data Warehouse stores structured data for reporting and analysis, Data Lakes store raw and unstructured data, Tables are basic data structures.

    • Data Warehouse is used for storing structured data from various sources for reporting and analysis.

    • Data Lakes store raw and unstructured data in its native format for future processing and analysis.

    • Tables are basic data structures used to organize and store data in a structured ...

  • Answered by AI
  • Q2. Query difference betweeen Group by and Partition by
  • Ans. 

    Group by is used to group rows that have the same values into summary rows, while Partition by is used to divide the result set into partitions to which the function is applied separately.

    • Group by is used with aggregate functions to group rows based on a column or set of columns.

    • Partition by is used with window functions to divide the result set into partitions.

    • Group by is used with SELECT statement, while Partition by...

  • Answered by AI
  • Q3. Machine Learning questions such as Regression, Trees etc

Interview Preparation Tips

Topics to prepare for Ericsson Data Scientist interview:
  • SQL
Interview preparation tips for other job seekers - Prepare the basics

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed in Jul 2024. There were 3 interview rounds.

Round 1 - Assignment 

Assignment on credit risk

Round 2 - Technical 

(1 Question)

  • Q1. Hyperparameter tuning
Round 3 - Technical 

(1 Question)

  • Q1. Case study for problem solving
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. SQL,Aptitude Questions
  • Q2. Logical Questions,case studies
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(4 Questions)

  • Q1. What is the difference between linear and classification?
  • Ans. 

    Linear regression is used for predicting continuous values, while classification is used for predicting discrete values.

    • Linear regression is used when the output variable is continuous, such as predicting house prices based on features like size and location.

    • Classification is used when the output variable is categorical, such as predicting whether an email is spam or not based on its content.

    • Linear regression aims to f...

  • Answered by AI
  • Q2. Explain example of outlier
  • Ans. 

    An outlier is a data point that differs significantly from other data points in a dataset.

    • Outliers can skew statistical analyses and machine learning models.

    • Examples of outliers include a person's weight being recorded as 1000 lbs, when the average weight is around 150 lbs.

    • Outliers can be detected using statistical methods like Z-score or IQR.

  • Answered by AI
  • Q3. Explain k mean algorithm
  • Ans. 

    K-means algorithm is a clustering technique that partitions data into k clusters based on similarity.

    • Divides data points into k clusters based on centroids

    • Iteratively assigns data points to the nearest centroid and updates centroids

    • Continues until centroids no longer change significantly

    • Example: Grouping customers based on purchasing behavior

  • Answered by AI
  • Q4. Explain the metrics for classification
  • Ans. 

    Classification metrics are used to evaluate the performance of a classification model.

    • Accuracy: measures the proportion of correctly classified instances out of total instances

    • Precision: measures the proportion of true positive predictions out of all positive predictions

    • Recall: measures the proportion of true positive predictions out of all actual positive instances

    • F1 Score: harmonic mean of precision and recall, balan...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Exptected salary
  • Q2. What do you expect for work
  • Ans. 

    I expect challenging projects, opportunities for growth, collaborative team environment, and work-life balance.

    • Challenging projects that allow me to apply my data science skills and learn new techniques

    • Opportunities for growth and advancement within the company

    • Collaborative team environment where I can share ideas and work together towards common goals

    • Work-life balance to ensure I can perform at my best both profession

  • Answered by AI
Round 2 - Coding Test 

Topic was joining and calculating

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Asked about previous work experience
  • Q2. Explain about your skills

Interview Preparation Tips

Interview preparation tips for other job seekers - All the best

Senior Data Analyst Interview Questions & Answers

Maersk user image Suraj Sudhakar Salunkhe

posted on 31 Jul 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Questions on what you have worked on till now
Round 2 - Case Study 

Power BI case study to see the expertise in Power BI

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. What is the difference between AI, deep learning and machine learning
  • Ans. 

    AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart. Machine learning is a subset of AI that allows machines to learn from data. Deep learning is a subset of machine learning that uses neural networks with many layers to model and solve complex problems.

    • AI is the broader concept of machines being able to carry out tasks in a way that we would consider smart.

    • Machine ...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Basic DP, Array Questions

Round 3 - One-on-one 

(1 Question)

  • Q1. Resume Walkthrough and Discussion, Medium level coding questions
Round 4 - One-on-one 

(1 Question)

  • Q1. Discussion with Manager
Round 5 - HR 

(1 Question)

  • Q1. Normal HR round

BT Group Interview FAQs

How many rounds are there in BT Group Business Intelligence Developer interview?
BT Group interview process usually has 2 rounds. The most common rounds in the BT Group interview process are Technical and Case Study.
What are the top questions asked in BT Group Business Intelligence Developer interview?

Some of the top questions asked at the BT Group Business Intelligence Developer interview -

  1. Diff between Union and Union ...read more
  2. Sets and their uses in Tabl...read more
  3. Some more basic questi...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Infosys Interview Questions
3.7
 • 7.4k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.7k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Jio Interview Questions
3.9
 • 1.6k Interviews
Bharti Airtel Interview Questions
4.0
 • 806 Interviews
DXC Technology Interview Questions
3.7
 • 796 Interviews
Wells Fargo Interview Questions
3.9
 • 550 Interviews
Vodafone Idea Interview Questions
4.1
 • 538 Interviews
View all

BT Group Business Intelligence Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

2.0

Skill development

5.0

Work-Life balance

2.0

Salary & Benefits

5.0

Job Security

5.0

Company culture

3.0

Promotions/Appraisal

5.0

Work Satisfaction

Explore 1 Review and Rating
Associate
343 salaries
unlock blur

₹1.5 L/yr - ₹7 L/yr

Associate Engineer
268 salaries
unlock blur

₹2.8 L/yr - ₹6.9 L/yr

Financial Analyst
259 salaries
unlock blur

₹7.4 L/yr - ₹23 L/yr

Project Manager
230 salaries
unlock blur

₹6 L/yr - ₹25 L/yr

Network Engineer
220 salaries
unlock blur

₹2.8 L/yr - ₹8.7 L/yr

Explore more salaries
Compare BT Group with

Vodafone Idea

4.1
Compare

Bharti Airtel

4.0
Compare

Jio

3.9
Compare

Tata Communications

4.1
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview