Cardekho Business Analyst Interview Questions & Experience Guide

Interview Preparation
,
1

Cardekho Business Analyst Interview Questions & Experience Guide

2

Company Name: Cardekho

Position: Business Analyst

Application Process: I applied online for this job and later received a call informing me about the interview schedule. The interview was conducted telephonically.

Interview Rounds:

  • Round 1 - Telephonic Interview:
    • Questions Asked: The HR asked questions related to analytics.
    • Your Approach: I answered the questions based on my understanding of analytics and its applications in the business domain.
    • Outcome: The HR was excellent, and the round went well.

Conclusion:

The overall experience was smooth, and the HR was very professional. For future candidates, I would suggest brushing up on analytics concepts and being prepared to discuss their practical applications in business scenarios.

3

Company Name: Cardekho

Position: Business Analyst

Application Process: HR reached out directly for the interview process. The entire process, including both interview rounds and the offer, was completed in a very short time frame.

Interview Rounds:

  • Round 1 - L1 Interview:

  • Questions Asked: General interview questions related to the role of a Business Analyst. The specifics weren’t mentioned, but it was a standard screening round.

  • Your Approach: Answered the questions confidently, focusing on my relevant skills and experience.

  • Outcome: Cleared the round and moved to the next stage immediately.

  • Round 2 - L2 Interview:

  • Questions Asked: Similar to the first round, with a deeper dive into my analytical skills and problem-solving approach.

  • Your Approach: Provided structured answers, using examples from past experiences to showcase my abilities.

  • Outcome: Successfully cleared this round as well, and received the offer shortly after.

Conclusion:
The process was smooth and quick, which was a pleasant surprise. I would advise future candidates to be prepared for a fast-paced interview process and to ensure they can articulate their skills and experiences clearly. Being concise and confident in your responses is key!

4

Company Name: CarDekho

Position: Business Analyst

Location: [Not specified]

Application Process: [Not specified]

Interview Rounds:

  • Round 1 - Technical Round:
    • Questions Asked:
      1. Cohort Analysis in Google Analytics.
      2. Types of joins in SQL and their differences.
    • Your Approach:
      • For the Cohort Analysis question, I explained the concept and its significance in analyzing user behavior over time. I also mentioned how it can be implemented in Google Analytics.
      • For the SQL joins question, I listed the types (INNER, LEFT, RIGHT, FULL) and described each with examples to highlight their differences.
    • Outcome: [Not specified]

Preparation Tips:

  • Focus on understanding core analytical concepts like Cohort Analysis and practical SQL queries.
  • Practice explaining technical concepts clearly and concisely.

Conclusion:
The interview was straightforward and focused on technical skills relevant to the Business Analyst role. Preparing well for SQL and analytics concepts helped me answer confidently. For future candidates, I recommend brushing up on these areas and practicing real-world scenarios.

5

Company Name: Cardekho

Position: Business Analyst

Application Process: I applied through an employee referral, which made the process smoother and more personalized.

Interview Rounds:

  • Round 1 - Team Head Interview:

    • Questions Asked:
      • Guesstimates (e.g., estimating the number of cars sold in a city in a month).
      • HR questions (e.g., “Tell me about yourself,” “Why do you want to work here?”).
    • Your Approach: I stayed calm and structured my answers logically, especially for the guesstimates. For HR questions, I focused on aligning my skills and interests with the role and company values.
    • Outcome: Passed this round and moved to the next stage.

  • Round 2 - Final Interview:

    • Questions Asked:
      • More guesstimates (e.g., estimating the revenue of a car dealership).
      • Additional HR questions (e.g., “How do you handle pressure?”, “Describe a challenging situation you faced”).
    • Your Approach: I used a step-by-step method for guesstimates and backed my HR answers with real-life examples to showcase my problem-solving and adaptability.
    • Outcome: Successfully cleared this round and received the offer.

Preparation Tips:

  • Practice guesstimates regularly to improve your structuring and logical thinking.
  • Prepare for HR questions by reflecting on your experiences and aligning them with the role.
  • Stay confident and composed during the interview.

Conclusion:
Overall, the interview process was smooth and conversational. The key was to stay logical in guesstimates and authentic in HR answers. I’d advise future candidates to focus on clarity and confidence in their responses.

6

Company Name: Cardekho

Position: Business Analyst

Application Process: The application process was conducted through campus placements. Different slots were assigned to candidates, and the entire process took about half a day. The HRs were very friendly and informative throughout the process.

Interview Rounds:

  • Round 1 - HR Interview:

  • Questions Asked: General questions about my background, interest in the role, and why I wanted to work at Cardekho.

  • Your Approach: I focused on highlighting my relevant skills and experiences, and expressed genuine interest in the company and the role.

  • Outcome: Passed this round and moved to the next round.

  • Round 2 - Technical/Behavioral Interview:

  • Questions Asked: Questions about problem-solving scenarios, analytical skills, and how I would handle specific business situations.

  • Your Approach: I used the STAR method to structure my answers, providing clear examples from my past experiences.

  • Outcome: Successfully cleared this round as well.

Preparation Tips:

  • Brush up on basic business analysis concepts and problem-solving techniques.
  • Practice answering behavioral questions using the STAR method.
  • Research the company thoroughly to understand its business model and recent developments.

Conclusion:
The overall experience was smooth and well-organized. The HRs were supportive, and the questions were fair. I would advise future candidates to stay calm, be confident, and prepare well for both technical and behavioral aspects of the interview.

7

Company Name: Cardekho

Position: Business Analyst

Application Process: The application process details were not provided, but it seems the candidate went through an HR round directly.

Interview Rounds:

  • Round 1 - HR Round:
    • Questions Asked:
      1. Salary discussion.
      2. Expected salary vs what they can offer.
    • Your Approach: The candidate did not share their approach to answering these questions.
    • Outcome: The outcome of this round was not specified.

Top Skills Recommended:

  • Automation
  • Mining
  • MySQL
  • Python
  • Analytics
  • Business Analysis
  • Business Case
  • Catering
8

Company Name: Cardekho

Position: Business Analyst

Application Process: I applied via a job portal and was interviewed in August 2024.

Interview Rounds:

  • Round 1 - Coding Test:
    • Questions Asked: Written test where I was asked to write queries on paper for given questions.
    • Your Approach: I focused on writing clear and efficient SQL queries, ensuring they addressed the problem statements accurately. I double-checked my syntax and logic before submitting.
    • Outcome: Successfully cleared the round.

Preparation Tips:

  • Brush up on SQL queries, especially for data extraction and manipulation.
  • Practice writing queries on paper to simulate the test environment.
  • Familiarize yourself with business analysis concepts and tools like Advanced Excel.

Conclusion:
The interview process was straightforward, and the coding test was a good way to assess practical skills. I would recommend practicing SQL queries thoroughly and being comfortable with writing them by hand. Overall, it was a positive experience!

9

Company Name: Cardekho

Position: Business Analyst

Location: [Not specified]

Application Process: Applied via Naukri.com and was interviewed in January 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Questions Asked: N/A (Resume screening round)

  • Your Approach: Ensured my resume was concise and highlighted relevant skills and projects.

  • Outcome: Shortlisted for the next round.

  • Round 2 - One-on-one Round:

  • Questions Asked:

    1. Explain the GROUP BY clause with use cases.
    2. Explain the use cases of COUNTA, COUNTB, and COUNTIF in Google Sheets.

  • Your Approach:

    • For the GROUP BY question, I explained its purpose in SQL for aggregating data and provided examples like summarizing sales by region.
    • For the Google Sheets functions, I described how each function works and gave practical examples, such as counting non-empty cells (COUNTA) or specific conditions (COUNTIF).

  • Outcome: Successfully cleared the round.

  • Round 3 - HR Round:

  • Questions Asked:

    1. Where have you stayed? Why do you want to switch? What will be your priority—job or family?

  • Your Approach:

    • Answered honestly about my location and reasons for seeking a change (e.g., career growth).
    • Balanced my response about job and family priorities, emphasizing commitment to work while acknowledging personal responsibilities.

  • Outcome: Cleared the HR round.

Preparation Tips:

  • Focus on strong foundational knowledge of MS SQL and advanced MS Excel.
  • Basic knowledge of Python can be beneficial.
  • If you’re a fresher, ensure you have end-to-end knowledge of the projects mentioned in your resume, as questions may arise from them.

Conclusion:
Overall, the interview process was smooth, and the questions were aligned with the role’s requirements. Being thorough with my resume and having clear, concise answers helped me perform well. For future candidates, I’d recommend practicing SQL and Excel extensively and being prepared to discuss your projects in detail.

10

Company Name: Cardekho

Position: Business Analyst

Application Process: The application process involved multiple stages, including a written test, group discussion, personal interview, and HR interview. Candidates who performed exceptionally well in the written test were directly moved to the personal interview round, while others proceeded to the group discussion round.

Interview Rounds:

  • Round 1 - Written Test:

  • Questions Asked: The test comprised analytical questions to assess problem-solving and logical reasoning skills.

  • Your Approach: I focused on solving the questions methodically, ensuring accuracy and clarity in my responses.

  • Outcome: I performed well and was directly moved to the personal interview round.

  • Round 2 - Group Discussion (for some candidates):

  • Questions Asked: Topics were related to current industry trends and business scenarios.

  • Your Approach: I actively participated, presenting clear arguments and listening to others’ viewpoints.

  • Outcome: Not applicable to me, as I skipped this round due to my performance in the written test.

  • Round 3 - Personal Interview:

  • Questions Asked: The interviewer asked about my analytical skills, problem-solving approach, and understanding of the business analyst role.

  • Your Approach: I structured my answers logically, providing examples from past experiences to demonstrate my skills.

  • Outcome: The interview went well, and I was selected for the HR round.

  • Round 4 - HR Interview:

  • Questions Asked: Questions revolved around my career goals, motivation for joining Cardekho, and cultural fit.

  • Your Approach: I answered honestly, aligning my aspirations with the company’s values and goals.

  • Outcome: I received positive feedback and was included in the final list of selected candidates.

Preparation Tips:

  • Practice analytical and logical reasoning questions for the written test.
  • Stay updated with industry trends to perform well in group discussions.
  • Prepare for behavioral and situational questions for the HR round.

Conclusion:
The overall experience was structured and insightful. Performing well in the written test gave me an advantage, and I focused on showcasing my analytical and communication skills throughout the process. For future candidates, I recommend thorough preparation for each stage and staying confident during interviews.

11

Company Name: Cardekho

Position: Business Analyst

Application Process: I applied via Naukri.com and was interviewed in July 2024.

Interview Rounds:

  • Round 1 - Coding Test:

    • Questions Asked: Write a Python program where if a number is divisible by 3, print “T”; if divisible by 5, print “F”; and if divisible by both 3 and 5, print “N”.
    • Your Approach: I wrote a simple Python script using conditional statements to check the divisibility of the number and print the required output.
    • Outcome: I passed this round.

  • Round 2 - Case Study:

    • Questions Asked: Analyze the reasons for Flipkart’s sales drop from last month to the current month.
    • Your Approach: I considered factors like seasonal trends, competitor activity, marketing strategies, and customer behavior to explain the drop in sales. I also suggested potential solutions to mitigate the issue.
    • Outcome: The interviewer seemed satisfied with my analysis, and I advanced further in the process.

Preparation Tips:

  • Prepare SQL and Python thoroughly, as these are key skills tested in the interview.

Conclusion:
The interview process was smooth, and the questions were aligned with the role’s requirements. I felt confident about my performance, especially in the case study round. For future candidates, I’d recommend focusing on problem-solving and analytical skills, as they are crucial for a Business Analyst role.

12

Company Name: CarDekho

Position: Business Analyst

Application Process: The application process began with a resume shortlist round, followed by multiple interview rounds.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Outcome: My resume was shortlisted based on my qualifications and experience.

  • Round 2 - HR Round:

  • Questions Asked:

    • What are your salary expectations?
    • Share details of your previous job.
    • Why are you looking for a change?
    • Tell me about yourself.

  • Your Approach: I answered honestly, aligning my expectations with industry standards and explaining my career transition clearly.

  • Outcome: I progressed to the next round.

  • Round 3 - Technical Round:

  • Questions Asked:

    • SQL, Tableau, and Excel-related questions were asked.

  • Your Approach: I focused on the basics of these tools, ensuring clarity in my explanations.

  • Outcome: The round was challenging, but I managed to clear it.

  • Round 4 - HR Round:

  • Questions Asked:

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

  • Your Approach: I reiterated my experience and maintained transparency about my expectations.

  • Outcome: The round went well, and I received positive feedback.

Preparation Tips:

  • Check technical interview questions on platforms like YouTube before the interview. Focus on SQL, Tableau, and Excel basics for technical rounds.

Conclusion:
Overall, the interview process was thorough but manageable. I could have prepared more rigorously for the technical round, but focusing on the basics helped. For future candidates, I recommend revising core technical skills and being transparent in HR rounds.

13

Company Name: Cardekho

Position: Business Analyst

Location: [Location not specified]

Application Process: Applied via Internshala and was interviewed in September 2023.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Questions Asked: Resume review for relevance and clarity.

  • Your Approach: Ensured my resume was concise and highlighted relevant skills and experiences.

  • Outcome: Passed to the next round.

  • Round 2 - Aptitude Test:

  • Questions Asked: Medium difficulty questions on pandas and SQL.

  • Your Approach: Reviewed pandas and SQL concepts beforehand and practiced similar problems.

  • Outcome: Cleared the test.

  • Round 3 - One-on-one Round:

  • Questions Asked: Coding interview with Python and pandas (medium difficulty).

  • Your Approach: Focused on writing clean, efficient code and explaining my thought process.

  • Outcome: Successfully answered the question.

Preparation Tips:

  • Prepare pandas thoroughly, as it was a key focus in the aptitude and coding rounds.
  • Practice coding problems involving Python and pandas to build confidence.

Conclusion:
The interview process was smooth, and the questions were aligned with the role’s requirements. I would advise future candidates to focus on pandas and SQL, as these were heavily tested. Practicing coding problems and ensuring your resume is well-structured will help you stand out.

14

Company Name: Cardekho

Position: Business Analyst

Application Process: I applied via a referral and was interviewed in September 2023.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: No specific questions were asked in this round. The focus was on reviewing my resume.
    • Your Approach: I ensured my resume was concise, relevant, and free of unnecessary details like photos, gender, age, or address.
    • Outcome: My resume was shortlisted for the next round.

  • Round 2 - Case Study:

    • Questions Asked: “What are the KPIs to be considered in order to monitor the e-diagnostics business?”
    • Your Approach: I analyzed the e-diagnostics business model and identified key performance indicators such as user engagement, diagnostic accuracy, turnaround time, customer satisfaction, and revenue growth. I presented my findings in a structured manner.
    • Outcome: I successfully cleared this round.

  • Round 3 - Cultural Fitment (Not Done Yet):

    • Questions Asked: This round is pending, and it might focus on cultural fit.
    • Your Approach: I plan to research the company culture and align my responses accordingly.
    • Outcome: Awaiting further details.

Preparation Tips:

  • Focus on building a clean and professional resume.
  • Practice case studies related to business analysis, especially in the e-commerce or healthcare sectors.
  • Brush up on KPIs and metrics relevant to the industry.

Conclusion:
Overall, the interview process was smooth, and the case study round was particularly insightful. I would advise future candidates to prepare thoroughly for case studies and ensure their resumes are tailored to the role. Researching the company’s business model beforehand can also be beneficial.

15

Company Name: Cardekho

Position: Business Analyst

Application Process: Approached by the company and interviewed in March 2022.

Interview Rounds:

  • Round 1 - Aptitude Test:

    • Questions Asked: Excel and aptitude test.
    • Your Approach: Focused on solving Excel-related problems and general aptitude questions.
    • Outcome: Cleared the round successfully.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. Case study on OYO rooms.
      2. Guesstimate on the number of delivery boys in Gurgaon.
    • Your Approach: For the case study, analyzed the problem logically and structured the answer. For the guesstimate, broke down the problem into smaller parts and estimated based on population and demand.
    • Outcome: Provided satisfactory answers and moved to the next round.

  • Round 3 - HR Round:

    • Questions Asked: Tell me something about yourself and your previous roles.
    • Your Approach: Highlighted relevant experiences and skills that align with the Business Analyst role.
    • Outcome: The round went well, and I received positive feedback.

Preparation Tips:

  • Practice aptitude and Excel online.
  • Understand the thinking process for guesstimates, which can be learned from YouTube.

Conclusion:
Overall, the interview process was smooth and well-structured. The technical round was challenging but manageable with proper preparation. Practicing case studies and guesstimates beforehand was very helpful. For future candidates, I’d recommend focusing on logical problem-solving and being clear about your past experiences during the HR round.

16

Company Name: Cardekho

Position: Business Analyst

Application Process: The application process involved multiple stages, starting with a written test. Applicants who performed exceptionally well in the written test were directly invited for the Personal Interview (P.I.), while others were sent to a Group Discussion round before proceeding further.

Interview Rounds:

  • Round 1 - Written Test:

  • Questions Asked: The test comprised analytical questions designed to assess problem-solving and logical reasoning skills.

  • Your Approach: I focused on solving the questions methodically, ensuring accuracy and clarity in my responses.

  • Outcome: I performed well and was directly invited for the Personal Interview round.

  • Round 2 - Group Discussion (for some candidates):

  • Questions Asked: Topics were general and related to current affairs or business scenarios.

  • Your Approach: I actively participated, shared relevant points, and ensured my contributions were concise and impactful.

  • Outcome: Not applicable to me, as I skipped this round due to my performance in the written test.

  • Round 3 - Personal Interview (P.I.):

  • Questions Asked: The interviewer asked about my analytical skills, problem-solving approach, and previous experiences relevant to the role.

  • Your Approach: I structured my answers using the STAR method (Situation, Task, Action, Result) to highlight my skills and experiences effectively.

  • Outcome: I advanced to the next round.

  • Round 4 - HR Interview:

  • Questions Asked: Questions revolved around my career goals, motivation for joining Cardekho, and how I handle teamwork and challenges.

  • Your Approach: I answered honestly, aligning my responses with the company’s values and the role’s requirements.

  • Outcome: I successfully cleared this round.

  • Round 5 - Final List:

  • Outcome: After all the rounds, I was selected for the Business Analyst role.

Preparation Tips:

  • Focus on strengthening your analytical and problem-solving skills for the written test.
  • Practice group discussions on diverse topics to improve communication and teamwork skills.
  • Prepare for behavioral and situational questions using the STAR method for the P.I. and HR rounds.

Conclusion:
The overall experience was rigorous but rewarding. Performing well in the written test gave me an advantage, but I also ensured I was well-prepared for the subsequent rounds. My advice to future candidates is to practice extensively for the analytical test and be confident in articulating your thoughts during interviews.