Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by TCS Team. If you also belong to the team, you can get access from here

TCS Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 85.7k Reviews

Filter interviews by

TCS Business Intelligence Analytics Consultant Interview Questions and Answers

Updated 16 Nov 2023

TCS Business Intelligence Analytics Consultant Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected

I was interviewed before Nov 2022.

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 - Technical 

(5 Questions)

  • Q1. Differences between dence and sparse
  • Ans. 

    Dense data has most of the cells filled with data, while sparse data has many empty cells.

    • Dense data is more common in structured datasets, while sparse data is common in unstructured datasets.

    • Sparse data requires specialized techniques for analysis due to missing values, while dense data can be analyzed more easily.

    • Examples of dense data include sales transactions with all fields filled, while examples of sparse data ...

  • Answered by AI
  • Q2. Project explanation
  • Q3. Tell me about you are self
  • Q4. What is hyperion
  • Ans. 

    Hyperion is a business intelligence software suite by Oracle that includes tools for reporting, analysis, modeling, and planning.

    • Hyperion Essbase is a multidimensional database management system used for analytics and reporting

    • Hyperion Planning is used for budgeting, forecasting, and scenario modeling

    • Hyperion Financial Management is used for financial consolidation and reporting

    • Hyperion Interactive Reporting allows use

  • Answered by AI
  • Q5. What is smartview
  • Ans. 

    SmartView is a business intelligence tool used for reporting, analysis, and data visualization.

    • SmartView is a part of Oracle's Enterprise Performance Management (EPM) suite.

    • It allows users to create ad-hoc reports, dashboards, and analyses.

    • Users can connect to various data sources such as Oracle Essbase, Oracle Hyperion Planning, and Oracle Financial Management.

    • SmartView integrates with Microsoft Office applications li...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare better for better results

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Nov 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Quantitavtive logical verbal puzzles reasoning arithmetic

Round 2 - Coding Test 

DSA array string loops function and algorithms

Round 3 - Group Discussion 

Communication leadership teamwork

Round 4 - Assignment 

Fundamental of ai ml and also about nural network

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - Technical 

(3 Questions)

  • Q1. Over fitting and underfitting ?
  • Q2. What is P value and what is its significance?
  • Ans. 

    P value is a statistical measure that helps determine the significance of results in hypothesis testing.

    • P value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

    • A small P value (typically ≤ 0.05) indicates strong evidence against the null hypothesis, leading to its rejection.

    • A large P value (> 0.05) suggests weak evidence against the null hypothesis, leadi...

  • Answered by AI
  • Q3. Explain your projects. Explain about RAG
Round 2 - Coding Test 

Write a code to reverse a list. Write a code to add value to a dataframe and edit the value in data frame

Round 3 - One-on-one 

(2 Questions)

  • Q1. Tell about yourself.
  • Q2. Explain projects. How much will you rate yourself in technical knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - try to answer question in detail. Try to understand what actually they are looking for.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
-
Result
Selected Selected

I applied via Campus Placement

Round 1 - Aptitude Test 

It was a campus placement during my second year of Mtech. So they followed the usual standard format. Aptitude and personality quiz.

Round 2 - Technical 

(1 Question)

  • Q1. Tell me about yourself favourite subject Python Libraries Projects Data science (NLP)
Round 3 - HR 

(1 Question)

  • Q1. The usual tell me about yourself and some casual conversation.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Asked various ai related basic questions, algorithms and basics of python.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Aug 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic Computer Vision questions
  • Q2. What is convolution
  • Ans. 

    Convolution is a mathematical operation that combines two functions to produce a third function.

    • Convolution involves sliding one function over another and multiplying the overlapping values at each point.

    • It is commonly used in signal processing, image processing, and neural networks.

    • In image processing, convolution is used for tasks like blurring, sharpening, edge detection, etc.

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Hard
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. About tableau advance questions
  • Q2. Tableau lod related questions
Round 2 - One-on-one 

(1 Question)

  • Q1. Flexible to work and timings

I applied via Recruitment Consulltant

Round 1 - Not sure 

(1 Question)

  • Q1. Just personal questions

Interview Preparation Tips

Interview preparation tips for other job seekers - They take interview for other role and provide job in other role. They take interviews and show higher salary and promise you to send offer letter the other day and make you resign the present company. After this they offer you a role with less salary and that too they will attend calls keep promising to send offer letter and take 3-4 months to send offer letter.

Company is literally pathetic with its non Co Operative employee and also pathetic recruiting process

I applied via Recruitment Consulltant and was interviewed in Aug 2021. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. It was purely based on Power BI
Round 2 - Technical 

(1 Question)

  • Q1. It was purely based on SQL
Round 3 - Behavioral 

(1 Question)

  • Q1. It was to understand what you have worked on and to basically understand will you be a suitable fit for client interactions

Interview Preparation Tips

Interview preparation tips for other job seekers - Do prepare BI and SQL technical. Once you crack these two interviews, third one will be easy to crack.

I applied via LinkedIn and was interviewed in Mar 2021. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. On SSIS about the project,Incremental Load,Event Handler,Debugging Error,Variable and Parameters
  • Q2. SQL questions what is View, difference of Union and Union All

Interview Preparation Tips

Interview preparation tips for other job seekers - It was very great experience while getting interviewed with Panels from Genpact.They make you feel relaxed and they are to try understand you rather grill you.Just prepare the skills mentioned in Resume.

TCS Interview FAQs

How many rounds are there in TCS Business Intelligence Analytics Consultant interview?
TCS interview process usually has 2 rounds. The most common rounds in the TCS interview process are Technical and Resume Shortlist.
What are the top questions asked in TCS Business Intelligence Analytics Consultant interview?

Some of the top questions asked at the TCS Business Intelligence Analytics Consultant interview -

  1. Differences between dence and spa...read more
  2. What is hyper...read more
  3. What is smartv...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

Accenture Interview Questions
3.9
 • 8k Interviews
Infosys Interview Questions
3.7
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.5k Interviews
Cognizant Interview Questions
3.8
 • 5.5k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.6
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.7k Interviews
Genpact Interview Questions
3.9
 • 3k Interviews
LTIMindtree Interview Questions
3.9
 • 2.9k Interviews
IBM Interview Questions
4.1
 • 2.4k Interviews
View all
System Engineer
1.1L salaries
unlock blur

₹1 L/yr - ₹9 L/yr

IT Analyst
67.7k salaries
unlock blur

₹5.1 L/yr - ₹16 L/yr

AST Consultant
51.2k salaries
unlock blur

₹8 L/yr - ₹25 L/yr

Assistant System Engineer
29.9k salaries
unlock blur

₹2.2 L/yr - ₹5.6 L/yr

Associate Consultant
28.7k salaries
unlock blur

₹8.9 L/yr - ₹32 L/yr

Explore more salaries
Compare TCS with

Amazon

4.1
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

Accenture

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