Upload Button Icon Add office photos
Engaged Employer

i

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

CarDekho Group Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

CarDekho Group Business Analyst Interview Questions, Process, and Tips

Updated 26 Sep 2024

Top CarDekho Group Business Analyst Interview Questions and Answers

CarDekho Group Business Analyst Interview Experiences

3 interviews found

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

(2 Questions)

  • Q1. Cohort Analysis in google analytics
  • Ans. 

    Cohort analysis in Google Analytics helps track the behavior of specific groups of users over time.

    • Cohort analysis groups users based on a common characteristic or behavior, such as sign-up date or acquisition channel.

    • It helps in understanding user retention, engagement, and conversion rates for different cohorts.

    • Example: Analyzing the retention rate of users who signed up in a particular month compared to users who si

  • Answered by AI
  • Q2. Types of join in sql and their differences
  • Ans. 

    Types of joins in SQL include inner join, outer join, left join, right join, and full join.

    • Inner join: returns rows when there is a match in both tables

    • Outer join: returns all rows from both tables, filling in NULLs for missing matches

    • Left join: returns all rows from the left table and the matched rows from the right table

    • Right join: returns all rows from the right table and the matched rows from the left table

    • Full joi...

  • Answered by AI

Skills evaluated in this interview

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

(4 Questions)

  • Q1. What are your salary expectations?
  • Q2. Share details of your previous job.
  • Q3. Why are you looking for a change?
  • Q4. Tell me about yourself.
Round 3 - Technical 

(1 Question)

  • Q1. Sql, tableau, excel relates questions asked, it difficult but i focused on basics
Round 4 - HR 

(3 Questions)

  • Q1. Share details of your previous job.
  • Q2. What is your family background?
  • Q3. What are your salary expectations?

Interview Preparation Tips

Interview preparation tips for other job seekers - Check the technical interview questions from YouTube before going

Business Analyst Interview Questions Asked at Other Companies

asked in Evalueserve
Q1. You have 10 boxes of balls (each ball weighing exactly10 gm) with ... read more
asked in Infosys
Q2. What is your strong point in terms of technical knowledge? Like J ... read more
Q3. There are 100 people standing in a circle, the first person has a ... read more
asked in Paytm
Q4. Sum of Squares of First N Natural Numbers Problem Statement You a ... read more
asked in EXL Service
Q5. If I have 333 digits to number pages of a book, How many pages ca ... read more

I applied via Naukri.com and was interviewed in Jan 2022. There were 3 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 - One-on-one 

(2 Questions)

  • Q1. Explain group by clause with used cases
  • Ans. 

    Group by clause is used to group data based on a specific column in a table.

    • Used with aggregate functions like SUM, COUNT, AVG, etc.

    • Helps in analyzing data by grouping it based on a common attribute.

    • Can be used with multiple columns to create nested groups.

    • Example: GROUP BY department in a table of employees to get the total salary for each department.

  • Answered by AI
  • Q2. CountA,CountB,Countif used case in Google sheet
  • Ans. 

    CountA, CountB, Countif are functions used in Google Sheets to count cells based on certain criteria.

    • CountA counts the number of cells in a range that are not empty.

    • CountB counts the number of cells in a range that are not blank.

    • Countif counts the number of cells in a range that meet a certain condition.

    • Countif can be used with operators like >, <, =, and functions like AND, OR.

    • Countif can also be used with wildcards l

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Where have stayed...why want to switch...what will be your priority ..job or family

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview always on basic knowledge of MS SQL,and have strong knowledge on advanced MS Excel,basic knowledge on python,..but if you are fresher and showing projects on your resume.they can ask you from your project..So required end to end strong knowledge on the projects you have shown in your resume

Skills evaluated in this interview

Interview questions from similar companies

Interview Preparation Tips

Round: Test
Experience: it was a basic test, CAT level questions and can be easily cleared
Tips: keep your cool, don't panic
Duration: 60 minutes
Total Questions: 60

College Name: IIT BOMBAY

Business Analyst Interview Questions & Answers

Ola Cabs user image Vishnuvardhan Reddy Kotte

posted on 21 Feb 2015

Interview Questionnaire 

3 Questions

  • Q1. Give some quantifiable factors you can use to rate( for comapny's purpose) among a repository of cab drivers we have?
  • Ans. 

    Quantifiable factors to rate cab drivers for company's purpose

    • Customer ratings and feedback

    • Number of completed trips

    • Average trip duration

    • Percentage of on-time pickups

    • Accident and traffic violation history

    • Vehicle cleanliness and maintenance

    • Driver punctuality and professionalism

  • Answered by AI
  • Q2. If you are on the selection committee of BCCI what would be your criterion for choosing between Yuvraj Singh and Stuart Binny for the World Cup squad?
  • Ans. 

    The criterion for choosing between Yuvraj Singh and Stuart Binny for the World Cup squad would be based on their recent performance, fitness, and team balance.

    • Evaluate recent performance of both players

    • Assess fitness levels of both players

    • Consider team balance and required skill sets

    • Analyze pitch and weather conditions of the tournament

    • Take into account the opposition teams and their strengths and weaknesses

  • Answered by AI
  • Q3. Some questions on programming (Pseudo Codes )

Interview Preparation Tips

Round: Test
Experience: There were questions on general aptitude like work and time, probability, and some questions were on data interpretation, coding and decoding, etc., most of the questions were very simple...but I felt the data interpretation questions to be a bit tricky (completely my opinion though).. ON THE BASIS OF THIS TEST THEY SHORTLISTED ROUGHLY 15 OUT OF 150 (again a rough figure)
Tips: Manage your time wisely...start with the type of questions you feel comfortable...try to attempt all the questions....improve your speed while practicing.
Duration: 45min minutes
Total Questions: 45

Round: Test
Experience: We were given 3 questions to solve in 30 min duration.Later we were told to walk them through our solution . Two of them were on probability(one random variables and the other on basic probability) and one was on estimating the area of an irregular figure , given some tools.
Tips: Get all the doubts regarding the questions clarified .As you have to explain your solution, it would be helpful if you could pen down all the steps clearly ( as it shows them that your thought process is an organised one). Use pictorial representation if needed. When they propose some other method be open to it and be open to any method they propose and be clear with the method you adopted. Even if you didn't arrive at the final answer, try to communicate your idea on solving the problem( most of the times they will listen to what you say).
Duration: 30min minutes
Total Questions: 3

Round: Other Interview
Experience: They were basically looking for quantifiable factors...so think of some quantifiable factors like the number of Times they are available to you in a day and the number of service providers they engage with. etc.,
For the second question again use quantifiable factors which make sense.
Tips: They patiently listened to what I said . So, be calm and don't be in a haste.

Skill Tips: Be a bit quick while solving the Aptitude questions....Know about the company before you go in for the interview process....No need of any prior knowledge in R language ...They just tested my Willingness to learn new things.
Skills: Aptitude Skills, Communication Skills, Structured thought process, Out of the box thinking, Basic programming skills ( very basic)
College Name: IIT KANPUR

I applied via Naukri.com and was interviewed before Aug 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Tell about yourself
  • Q2. What is your salary expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview wa easy and can crack it

I applied via Referral and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About personality

Interview Preparation Tips

Interview preparation tips for other job seekers - HR is very knowledgeable. The company want you to be very knowledgeable, smart and interesting.

I applied via Referral and was interviewed before May 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How can you understand the supply of restaurant in a particular area of a city ?
  • Ans. 

    To understand the supply of restaurants in a particular area of a city, we can use various methods.

    • Collect data from online directories like Yelp, Zomato, etc.

    • Conduct surveys to gather information about the number of restaurants in the area.

    • Analyze the population density and demographics of the area to estimate the demand for restaurants.

    • Check the number of restaurant permits issued by the local government.

    • Use GIS mapp...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand any city's demographics for instance. Take most busy road and assume that 70% supply will be on food -tech (MArket Standard). Open Sw / Zo and see the supply available in that area in peak time. There can be more than one way to solve for these question

I applied via LinkedIn and was interviewed before Jul 2021. There were 2 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 - One-on-one 

(1 Question)

  • Q1. Knowledge about data summarisation.and some tools like Power bi and advance excel.

Interview Preparation Tips

Interview preparation tips for other job seekers - Always speak first answer like perfect and effective answer without any hesitation...
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Sql Medium Level questions
  • Q2. Easy guesstimates were asked
Round 2 - Technical 

(2 Questions)

  • Q1. Caee Study was asked
  • Q2. Resume grilling was done
Round 3 - HR 

(2 Questions)

  • Q1. Why you want to join Ola ?
  • Ans. 

    I want to join Ola because of its innovative technology, market leadership, and potential for growth.

    • Ola is a market leader in the ride-sharing industry, which presents exciting challenges and opportunities for a business analyst.

    • I am impressed by Ola's focus on innovation and technology, which aligns with my passion for leveraging data and analytics to drive business decisions.

    • I believe Ola's fast-paced environment an...

  • Answered by AI
  • Q2. Salary Negotiation was done

Interview Preparation Tips

Interview preparation tips for other job seekers - Pretty easy Interview. Just brushup basics
Contribute & help others!
anonymous
You can choose to be anonymous

CarDekho Group Interview FAQs

How many rounds are there in CarDekho Group Business Analyst interview?
CarDekho Group interview process usually has 2-3 rounds. The most common rounds in the CarDekho Group interview process are HR, Resume Shortlist and Technical.
How to prepare for CarDekho Group Business 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 CarDekho Group. The most common topics and skills that interviewers at CarDekho Group expect are Business Analysis, Automotive, Customer Service, Analytics and Data Analysis.
What are the top questions asked in CarDekho Group Business Analyst interview?

Some of the top questions asked at the CarDekho Group Business Analyst interview -

  1. Explain group by clause with used ca...read more
  2. CountA,CountB,Countif used case in Google sh...read more
  3. Types of join in sql and their differen...read more

Recently Viewed

JOBS

Gushwork

14 jobs

JOBS

Browse jobs

Discover jobs you love

JOBS

GroundTruth

33 jobs

PHOTOS

Growisto

7 office photos

JOBS

TH Global Capital

No Jobs

JOBS

Browse jobs

Discover jobs you love

JOBS

Schneider Electric

No Jobs

SALARIES

CarDekho Group

INTERVIEWS

SAT n paper

No Interviews

JOBS

Caterpillar Inc

No Jobs

Tell us how to improve this page.

CarDekho Group Business Analyst Interview Process

based on 4 interviews

Interview experience

4.3
  
Good
View more
CarDekho Group Business Analyst Salary
based on 90 salaries
₹3.2 L/yr - ₹12 L/yr
25% less than the average Business Analyst Salary in India
View more details

CarDekho Group Business Analyst Reviews and Ratings

based on 14 reviews

4.1/5

Rating in categories

4.0

Skill development

4.3

Work-life balance

3.9

Salary

4.2

Job security

4.2

Company culture

3.8

Promotions

4.3

Work satisfaction

Explore 14 Reviews and Ratings
Business Manager
202 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Key Account Manager
183 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Retail Associate
119 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
94 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
91 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare CarDekho Group with

Udaan

4.0
Compare

Indiamart Intermesh

3.6
Compare

BigBasket

3.9
Compare

Swiggy

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