Add office photos
i
CarDekho
Compare
Filter interviews by
CarDekho Business Analyst Interview Questions, Process, and Tips
Top CarDekho Business Analyst Interview Questions and Answers
- Q1. Explain group by clause with used cases
- Q2. CountA,CountB,Countif used case in Google sheet
- Q3. Types of join in sql and their differences
CarDekho Business Analyst Interview Experiences
3 interviews found
Anonymous
(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
- 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...
Skills evaluated in this interview
gazi wasim Ahmad
(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.
(1 Question)
- Q1. Sql, tableau, excel relates questions asked, it difficult but i focused on basics
(3 Questions)
- Q1. Share details of your previous job.
- Q2. What is your family background?
- Q3. What are your salary expectations?
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Jan 2022. There were 3 interview rounds.
(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.
- 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
(1 Question)
- Q1. Where have stayed...why want to switch...what will be your priority ..job or family
Interview Preparation Tips
Skills evaluated in this interview
What people are saying about CarDekho
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Oct 2024. There were 3 interview rounds.
It was based on 4 sql questions of medium to hard level and 24 mcqs based on sql,aptitude,excel.
(1 Question)
- Q1. They give you some questions and you have to write sql queries for them
(1 Question)
- Q1. You are given case study and come sql questions based on that
I applied via LinkedIn and was interviewed in Aug 2024. There were 2 interview rounds.
Technical + Analytics
I gave my coding test this august 2024, it was purely based on SQL coding
8 question, 3 easy, 3 intermediate and 3 hard.
(2 Questions)
- Q1. Introduction and explain any one of the projects plus what was the analytics you used
- Ans.
Implemented a project to optimize marketing campaigns using predictive analytics
Developed a predictive model to identify the most effective marketing channels
Utilized data from past campaigns to train the model
Used techniques such as regression analysis and decision trees to analyze the data
Generated insights on customer behavior and preferences to improve campaign targeting
- Q2. SQL coding, shared screen and was asked to find cumulative sum of cost for a table.
Interview Preparation Tips
(2 Questions)
- Q1. SQL Question using window functions
- Q2. Guesstimate on Number of McD orders
- Ans.
The number of McDonald's orders can be estimated based on factors like location, time of day, and day of the week.
Consider the population density of the area where the McDonald's is located
Take into account the time of day - more orders during meal times
Factor in the day of the week - weekends may have higher order volumes
Look at historical data or industry averages for similar locations
Consider any promotions or speci
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Case study questions based on Logistics & Porter business.
- Q2. More Case study & porter business questions
(2 Questions)
- Q1. Some medium SQL Queries
- Q2. Some medium python codes
Selected
I applied via campus placement at Indian Institute of Technology (IIT), Guwahati and was interviewed before Jan 2024. There was 1 interview round.
We had an aptitude test which involved 60 questions in 15 minutes. Of course, no one can solve this fast, but it was about the hit rate / accuracy and volume. Subsequent followed with two guesstimate based rounds and final as HR round which involved asking about college projects, extra curricular experiences and so on.
I applied via Job Portal and was interviewed in Aug 2024. There was 1 interview round.
Written test, asked to write queries on paper for given questions
vivek duggal
(2 Questions)
- Q1. Salary discussion
- Q2. Expected salary vs what they can offer
CarDekho Interview FAQs
Tell us how to improve this page.
CarDekho Interviews By Designations
- CarDekho Sales Executive Interview Questions
- CarDekho Software Engineer Interview Questions
- CarDekho Assistant Manager Interview Questions
- CarDekho Business Analyst Interview Questions
- CarDekho Senior Retail Associate Interview Questions
- CarDekho Business Manager Interview Questions
- CarDekho Dealer Success Manager Interview Questions
- CarDekho Evaluator Interview Questions
- Show more
Interview Questions for Popular Designations
- Business Development Executive Interview Questions
- Business Development Manager Interview Questions
- Business Development Associate Interview Questions
- Senior Business Analyst Interview Questions
- Business Associate Interview Questions
- Business Development Interview Questions
- Business Executive Interview Questions
- Business Manager Interview Questions
- Show more
CarDekho Business Analyst Interview Process
based on 4 interviews
Interview experience
Business Analyst Interview Questions from Similar Companies
Fast track your campus placements
CarDekho Business Analyst Reviews and Ratings
based on 14 reviews
Rating in categories
|
Business Manager
199
salaries
|  ₹2.3 L/yr - ₹5 L/yr |
|
Key Account Manager
144
salaries
| ₹2.8 L/yr - ₹9.3 L/yr |
|
Senior Retail Associate
119
salaries
| ₹3.3 L/yr - ₹5.5 L/yr |
|
Assistant Manager
94
salaries
| ₹3.5 L/yr - ₹11.5 L/yr |
|
Business Analyst
91
salaries
| ₹3.2 L/yr - ₹12 L/yr |
Udaan
Swiggy
BlackBuck
Myntra
- Home >
- Interviews >
- CarDekho Interview Questions >
- CarDekho Business Analyst Interview Questions
