Upload Button Icon Add office photos

LatentView Analytics

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

LatentView Analytics Analyst 1 Interview Questions and Answers

Updated 26 Jul 2023

LatentView Analytics Analyst 1 Interview Experiences

1 interview found

Analyst 1 Interview Questions & Answers

user image Anonymous

posted on 26 Jul 2023

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Campus Placement and was interviewed before Jul 2022. There were 5 interview rounds.

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 Resume tips
Round 2 - Aptitude Test 

The test was for 1hr around. Topics: Quantitative Analysis, Verbal, Reasoning, and Basic Programming.

Round 3 - Group Discussion 

The group discussion was held on the topic of "Is online business a Boon or a Bane? Support or oppose the motion with reasons."

Round 4 - Technical 

(3 Questions)

  • Q1. SQL: 2nd max number from a column stored in a table.
  • Ans. 

    Use SQL query with ORDER BY and LIMIT to find 2nd max number from a column in a table.

    • Use SELECT MAX(column_name) to find the max number in the column.

    • Use SELECT column_name FROM table_name ORDER BY column_name DESC LIMIT 1,1 to find the 2nd max number.

    • Example: SELECT column_name FROM table_name ORDER BY column_name DESC LIMIT 1,1;

  • Answered by AI
  • Q2. SQL: Select all employees whose employee IDs are odd.
  • Ans. 

    Use SQL query to select employees with odd employee IDs.

    • Use the modulo operator (%) to check if employee ID is odd (e.g. id % 2 = 1)

    • Write SQL query like 'SELECT * FROM employees WHERE employee_id % 2 = 1;'

  • Answered by AI
  • Q3. SQL: Group all employees by department whose salary is greater than 50,000.
  • Ans. 

    Group employees by department with salary > 50,000 in SQL.

    • Use GROUP BY clause to group employees by department.

    • Use WHERE clause to filter employees with salary > 50,000.

    • Example: SELECT department, COUNT(employee_id) FROM employees WHERE salary > 50000 GROUP BY department;

  • Answered by AI
Round 5 - HR 

(1 Question)

  • Q1. It had mostly behavioral questions and salary expectations.

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. Why should the company choose you ?
  • Ans. 

    I have the necessary skills, experience, and passion to contribute to the company's growth and success.

    • I have a proven track record of achieving targets and delivering results.

    • I possess excellent communication and interpersonal skills, which enable me to work effectively with colleagues and clients.

    • I am a quick learner and can adapt to new technologies and processes easily.

    • I am passionate about my work and always striv...

  • Answered by AI
  • Q2. How are you suitable to the company?
  • Ans. 

    I have the necessary skills, experience, and passion to contribute to the company's growth and success.

    • I have relevant experience in the industry

    • I possess the required skills and knowledge for the job

    • I am a quick learner and can adapt to new situations easily

    • I am passionate about the company's mission and values

    • I am a team player and can work collaboratively with others

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: Though the paper was easy you have to score very high marks to qualify for the next round.
Duration: 30 minutes
Total Questions: 25

Round: Group Discussion
Experience: The GD round consisted of current affair topics. Since topics like these are very popular and everybody likes to talk about them, it is important that you start the topic so as to have a good hold over the group. If not just try and give a direction to the group with valid points so as to become noticeable. Do conclude the discussion.

Round: Interview
Experience: The interview was basically resume based. They asked me about my projects in the domain of finance and were quite impressed by it. They wanted me to discuss all my academic and internship projects in detail. The interview lasted for 30 minutes approximately.They also inquired briefly about me. They also asked me questions about my technical projects though it didn't have anything to do with the profile offered. Their main aim was to know whether I performed well in the tasks assigned to me even if they did not interest me.
Tips: Try not to mention anything about MBA if any one of you is planning to go for it.

College Name: IIT ROORKEE

Analyst Interview Questions & Answers

C5i user image Anonymous

posted on 22 Jan 2015

Interview Questionnaire 

3 Questions

  • Q1. Telephonic Interview
  • Q2. Present scenario of Indian cricket team and using stochastic to eliminate the worst and preserve the best
  • Ans. 

    Using stochastic to analyze Indian cricket team's current scenario and eliminate worst while preserving best.

    • Stochastic analysis can help identify the strengths and weaknesses of individual players and the team as a whole

    • It can also help in predicting the outcome of future matches based on past performance

    • Eliminating the worst performers and preserving the best can help improve the team's overall performance

    • For example...

  • Answered by AI
  • Q3. General HR Questions

Interview Preparation Tips

Round: Test
Experience: It was purely a quant based paper. I feel a freshie can crack it better than any other, provided their fresh math skills out of iit preparation.

Round: Interview
Experience: General questions.

Round: Interview
Experience: It was handled in the telephonic interview and the topic is too good.

Round: Interview
Experience: The last round of interview was again a telephonic based, where in hardcore HR questions were tested for your convincing skills which will definitely put you on the winning side.

General Tips: Just case studies grilling over with your friends should give you enough confidence to crack any non core company.

Confidence and body language in the interview. It depends on your resume too, but mostly on the time of the interview that will decide your fate in the selection process.
Skills: Confidence , Body language in interview
College Name: IIT MADRAS
Motivation: They were looking for the position of an analyst, and looking at my profile, I had done some high funda statistical modeling, which I think was the reason i got placed in that company.

I applied via Naukri.com and was interviewed in Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. About previous job role
  • Q2. Guesstimates & Puzzles
  • Q3. Case Studies

Interview Preparation Tips

Interview preparation tips for other job seekers - keep answering even when you don’t know the right answer, just keep going.

Interview Questionnaire 

1 Question

  • Q1. Interview proceas was very nice. They asked question based CV and the interviewers made very comfortable throughout the process

Interview Preparation Tips

Round: Resume Shortlist
Experience: If your have CGPA >7 and AIEEE rank is good then you will be shortlisted .

Round: Test
Experience: Test was similar to CAT there were 3 sections qunat, logical reasoning and verbal ...question were easy ...test was hosted at cocubes .
Tips: Don't try to open other tab during test because that will be recorded.
Duration: don't remember minute

Round: HR Interview
Experience: Interviewer was very straight forward, he ask many question and puzzles. One puzzle he asked was ... You have 2 rats and 4 glass. ..in each glass you have some liquid which is taste less, smell less cl,colorless ...but one glass contains poision... We are allowed to use rats only once and at the same time ...identity the poisened glass.
He also asked candel and bridge puzzle and sone question about me like why do you want to join our conpany, tell m le something about yourself etc

Round: Technical Interview
Experience: Interviewer asked 3 questions
1) you have 3 glasses each contain 1 balls of different color .. You have to identify which galss has which color ball .
I answered several time and he make changes every time. ..
1 coding question and 1sql query. I answered all the questions correctly

College Name: NIT Delhi

Interview Preparation Tips

Round: Test
Experience: An online test covering Quant, logical reasoning, DI and coding lasting for 1-1.30 hr. It also included essays on yourself

Round: Interview
Experience: Skype Interview of around 30-45 minInterview:Interview will consists of HR questions, project details and case studies.HR will be a standard affair and they will quiz you on BTP and internshipsOne of the last year case study was on ‟Amount of petrol used by Autos in Chennai‟.Other one was „calculate average salary of people in a room, who are not supposed tospeak about the salary‟.
Tips: Solve puzzles, quant and logical reasoning questions

College Name: IIT Madras

Interview Questionnaire 

4 Questions

  • Q1. What was your GRE score?
  • Ans. 

    I did not take the GRE exam.

    • I did not apply for a program that required GRE scores.

    • My focus was on gaining practical experience through internships and projects.

    • I have excelled in my academic and professional pursuits without a GRE score.

  • Answered by AI
  • Q2. How was CAT?
  • Ans. 

    CAT was challenging but I managed to do well.

    • CAT was a difficult exam but I prepared well for it.

    • I had to manage my time effectively during the exam.

    • I am confident that I did well in the exam.

    • The exam tested my analytical and problem-solving skills.

    • Overall, I am satisfied with my performance in CAT.

  • Answered by AI
  • Q3. Convince me that you won't go for higher studies?
  • Ans. 

    I am committed to gaining practical experience and contributing to the growth of the company.

    • I believe that practical experience is just as valuable as academic knowledge

    • I am excited about the opportunity to contribute to the growth of the company

    • I am committed to continuously learning and improving my skills through on-the-job training and professional development programs

  • Answered by AI
  • Q4. Project-related questions

Interview Preparation Tips

Round: Resume Shortlist
Experience: CPI cut-off was 8.0 and I easily cleared as I had a CPI of 9.4

Round: Test
Experience: Questions included:
1. Basic programming questions (to find output, basic SQL, java, C)
2. Basic stats questions (mean, median, mode)
3. Two essay questions (one was 'Why Axtria?').

Round: Other Interview
Experience: This was a skype interview conducted by IITK alum. By this time, I had enough experience of giving interviews so HR was well prepared. I didn't took GRE, so I said that. I didn't opted for CAT either as I didn't wanted to go for MBA. He said we are convinced with your quantitative and writing skills through test, just convince me that you won't go for higher studies-I justified, since I didn’t enabled the video feature so couldn’t know whether he was convinced or not. projects. My Interview was about to end, but I asked him some question and he started describing the work at Axtria and finally asked me to solve a case study.

General Tips: 1. Prepare HR well and before the actual Interview, give at least 2-3 dummy interviews.
2. Go through company website carefully; and prepare 2-3 good questions to ask in the end.
College Name: IIT KANPUR

Interview Questionnaire 

4 Questions

  • Q1. What is your area of interest?
  • Ans. 

    My area of interest is artificial intelligence and machine learning.

    • I am fascinated by the potential of AI and ML to revolutionize various industries.

    • I enjoy exploring the latest advancements in deep learning and natural language processing.

    • I am particularly interested in the ethical implications of AI and the need for responsible development.

    • Some of my favorite examples of AI in action include self-driving cars, virtu

  • Answered by AI
  • Q2. What are the other companies you have applied for and how many rounds did you clear?
  • Ans. 

    I have applied to a few companies, but I prefer not to disclose the names. I have cleared multiple rounds in each of them.

    • I have applied to a few companies, but I prefer not to disclose the names.

    • I have cleared multiple rounds in each of them.

    • I believe that each company has its own unique hiring process and requirements.

    • I am confident in my abilities and qualifications, and I am open to exploring opportunities with any

  • Answered by AI
  • Q3. Explain transportation problem.
  • Ans. 

    Transportation problem is a linear programming problem that deals with minimizing the cost of transporting goods from sources to destinations.

    • It involves determining the optimal way to transport goods from sources to destinations

    • It considers factors such as cost, capacity, and demand

    • It can be solved using various methods such as the North-West Corner Method, Least Cost Method, and Vogel's Approximation Method

    • Example: A...

  • Answered by AI
  • Q4. How will you solve a trans-shipment problem in excel solver software?
  • Ans. 

    Trans-shipment problem can be solved in Excel Solver by setting up a linear programming model.

    • Define decision variables for the amount of goods to be shipped between each pair of locations.

    • Set up constraints to ensure that the supply and demand at each location are met.

    • Add constraints to limit the amount of goods that can be shipped through intermediate locations.

    • Define the objective function to minimize the total cost...

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: It was an “open to all branches” company. Around 70 students were shortlisted based on resume. Shortlisting was mainly on CGPA basis and on an average 5 top students were shortlisted from each branch.

Round: Test
Experience: The written test was on logical reasoning, verbal ability and quantitative aptitude. The test comprised of 2 sections. 1st section comprised of 3 HR questions:
Why do you want to join this company?
Tell us about yourself.
Describe a situation where you displayed leadership skills.
These 3 questions were to be typed in 150-200 words each in total of 20 min. 2nd section started immediately after this. 25 minutes, 35 multiple choice questions consisting of questions from various sections including 10 coding based questions.
Duration: 45 minutes
Total Questions: 38

Round: HR Interview
Experience: Interview was through a video call on Skype. The interview started with the basic HR question and then the interviewer asked about my area of interest. He asked 2 questions from that field and then asked one guesstimate question
The last question was related to what do I understand about data analysis.
Other candidates were asked some puzzles and several other HR questions as well.
My area of interest was Operations Research. So he asked me some technical questions as well.

College Name: IIT ROORKEE

Interview Preparation Tips

Round: Shortlisting based on AIEEE RANK and cgpa
Experience: they shortlisted 150 people based on the aieee rank and cgpa .

Round: Test
Experience: the test was on cocubes.com
Tips: do attempt each section to clear cutoff

College Name: MANIT,bhopal
Contribute & help others!
anonymous
You can choose to be anonymous

LatentView Analytics Interview FAQs

How many rounds are there in LatentView Analytics Analyst 1 interview?
LatentView Analytics interview process usually has 5 rounds. The most common rounds in the LatentView Analytics interview process are Technical, HR and Resume Shortlist.
What are the top questions asked in LatentView Analytics Analyst 1 interview?

Some of the top questions asked at the LatentView Analytics Analyst 1 interview -

  1. SQL: Group all employees by department whose salary is greater than 50,0...read more
  2. SQL: Select all employees whose employee IDs are o...read more
  3. SQL: 2nd max number from a column stored in a tab...read more

Recently Viewed

INTERVIEWS

SG Analytics

No Interviews

DESIGNATION

INTERVIEWS

Nokia

No Interviews

INTERVIEWS

IBM

No Interviews

INTERVIEWS

EXL Service

No Interviews

INTERVIEWS

ThoughtWorks

No Interviews

INTERVIEWS

LatentView Analytics

No Interviews

SALARIES

Gennext Plm

INTERVIEWS

ValueLabs

No Interviews

INTERVIEWS

Nokia

No Interviews

Tell us how to improve this page.

LatentView Analytics Analyst 1 Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Mu Sigma Interview Questions
2.6
 • 229 Interviews
Tiger Analytics Interview Questions
3.7
 • 222 Interviews
Fractal Analytics Interview Questions
4.0
 • 204 Interviews
Tredence Interview Questions
3.6
 • 123 Interviews
Axtria Interview Questions
3.1
 • 115 Interviews
Apisero Interview Questions
4.3
 • 64 Interviews
C5i Interview Questions
4.0
 • 46 Interviews
Credera Interview Questions
3.8
 • 40 Interviews
View all
LatentView Analytics Analyst 1 Salary
based on 7 salaries
₹6.7 L/yr - ₹7.5 L/yr
25% more than the average Analyst 1 Salary in India
View more details
Senior Analyst
333 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Analyst
299 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
240 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
239 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
121 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare LatentView Analytics with

Fractal Analytics

4.0
Compare

Mu Sigma

2.6
Compare

Tiger Analytics

3.7
Compare

Bridgei2i Analytics Solutions

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