AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Clear (1)
Cafe Coffee Day Advanced Analyst Interview Questions and Answers
Cafe Coffee Day Advanced Analyst Interview Experiences
1 interview found
Anonymous
(2 Questions)
- Q1. KkXk cbcbd dhdbd hdnd jddn?
- Q2. Lkclac kcn ccnc ncnc cnnc cncnc ndnd
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
Shobhit Shrivas
I applied via Campus Placement
Interview Questionnaire
7 Questions
- Q1. I was asked 2 questions from a course called principle of economics, such as what is elasticity etc
- Q2. It was again from my course work they asked me how to solve linear programming problem graphically
- Q3. Then they asked me to tell me about my self
- Q4. They asked me to estimate number of microwaves manufactured in india per year
- Q5. Then I was asked what is my biggest achivement till now
- Q6. Then I was asked if I have any question for them
- Q7. He gave me 15 min to convence him so that he hirs me for his company
Interview Preparation Tips
Experience: They were mainly looking for people who has or worked in Start ups or who has some good PORs. They also shortlisted students with CGPA of more than 7.5.
Tips: Try taking good PORs and maintain a healthy CGPA. Make a one page resume.
Round: Technical Interview
Experience: It was good. This was my first interview, I was bit nurvous for obvious reasons but controlled my emotions perfectly. As interview progressed things started becoming normal.
Tips: Be confidant of what ever you speak. Try hidding you nervousness, its okay if you are not able to answer any question but make strong comeback in next.
Round: HR Interview
Experience: I was very confidant of myself and told some 8-9 qualities that I have and gave examples of where I used them in past.
Tips: Again be very confidant. Its okay if you fumble in between but make strong comeback. look into the eyes of interviewer it shows you are confidant. Don't lie, be yourself.
General Tips: Keep working hard, there is no subsitute of hardwork, even in IITs. And don't forget sometimes you have to loose small battels to win Wars.
All the best:)
Skills:
Duration: 8-10weeks
College Name: IIT Madras
Motivation: Oyo is progressing very fast and I wanted to be the part of there amazing journey.
Funny Moments: I kept looking into the eyes of both of my interviewer just to show them I was very confidant but the reality is I was very nervous and I was bluffing them:). After interview I had a headache.
I applied via Campus Placement
Interview Preparation Tips
Experience: basic Guesstimation questtions,
for eg. estimate the no of sleeping all over the world right now.
Tips: Walk the interviewer through your thinking process.
donot make vague guesses.
Round: HR Interview
Experience: 1 Tell us 5 reasons why we should hire you.
2 being an electrical engineering student, why have you applied for a analytic s/operations job profile.
Skills: Ability To Cope Up With Stress, Guesstimation Cases
Duration: 2
College Name: IIT Madras
(5 Questions)
- Q1. What did you learn in your internship
- Q2. What's happening in the world , India or whats in the news
- Q3. Share a situation when you handled guest
- Q4. Tell us about the hotel where you trained
- Q5. What do you know about the Oberoi
(1 Question)
- Q1. Technical Questions department specific
Interview Preparation Tips
(2 Questions)
- Q1. What is your greatest ahievement?
- Ans.
My greatest achievement was leading a team to successfully launch a new product ahead of schedule and under budget.
Led a team to launch a new product ahead of schedule
Managed project under budget
Received recognition for successful project completion
- Q2. What is your name?
- Ans.
My name is John Smith.
Full name is John Smith
Common first and last name combination
Easy to remember and pronounce
Guesstimate and behavioral question
(2 Questions)
- Q1. Basic discussion around your experience
- Q2. Last internship or college extra currics
Interview Preparation Tips
There were some aptitude question, Pandas question, SQL queries.
(2 Questions)
- Q1. Use SQL to filter duplicate entries.
- Ans.
Use SQL query with DISTINCT keyword to filter duplicate entries.
Use SELECT DISTINCT column_name FROM table_name;
DISTINCT keyword removes duplicate values from the result set.
For example, SELECT DISTINCT name FROM employees;
You can also use GROUP BY clause to eliminate duplicates.
- Q2. Questions on Excel Shorcuts.
Skills evaluated in this interview
Selected
I applied via LinkedIn and was interviewed before Apr 2023. There were 3 interview rounds.
(1 Question)
- Q1. SQL Questions are asked, learn joins and aggregate functions
Simple Case Study was discussed
(1 Question)
- Q1. Company fit check and salary expectations
Interview Preparation Tips
Saket Bihari
SQL, General Aptitude Questions
10 minutes GD on general topics.
(2 Questions)
- Q1. Case study related tl hospitality industry
- Q2. Questions related to POR held in college
Interview Preparation Tips
I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.
Interview Questionnaire
2 Questions
- Q1. Extract the oyo from domain name in google sheets.
- Ans.
Extract 'oyo' from domain name in Google Sheets.
Use the formula =REGEXEXTRACT(A1, "oyo") where A1 is the cell containing the domain name.
This will extract the first occurrence of 'oyo' in the domain name.
If 'oyo' appears multiple times, use =REGEXEXTRACT(A1, "oyo", 2) for the second occurrence, and so on.
- Q2. Time. Time() in sql
- Ans.
Time() is a SQL function that returns the current system date and time.
Time() can be used in SELECT, INSERT, UPDATE, and DELETE statements.
The returned value is in the format 'YYYY-MM-DD HH:MI:SS'.
Timezone can affect the returned value.
Example: SELECT Time() AS CurrentTime;
Interview Preparation Tips
Skills evaluated in this interview
Cafe Coffee Day Interview FAQs
Recently Viewed
INTERVIEWS
Cafe Coffee Day
No Interviews
INTERVIEWS
Bank of Baroda
No Interviews
INTERVIEWS
Cafe Coffee Day
No Interviews
INTERVIEWS
Pragmatic Play
No Interviews
LIST OF COMPANIES
Cafe Coffee Day
Locations
INTERVIEWS
PUMA
No Interviews
INTERVIEWS
Barista Coffee Company
No Interviews
INTERVIEWS
ICRA Analytics
No Interviews
INTERVIEWS
Cafe Coffee Day
No Interviews
INTERVIEWS
ICRA Analytics
No Interviews
Tell us how to improve this page.
Cafe Coffee Day Interviews By Designations
- Cafe Coffee Day Cafe Manager Interview Questions
- Cafe Coffee Day Salesman Interview Questions
- Cafe Coffee Day Management Trainee Interview Questions
- Cafe Coffee Day Area Manager Interview Questions
- Cafe Coffee Day Manager Interview Questions
- Cafe Coffee Day Software Engineer Interview Questions
- Cafe Coffee Day Team Member Interview Questions
- Cafe Coffee Day Assistant Manager Interview Questions
- Show more
Interview Questions for Popular Designations
- Advanced Associate Interview Questions
- Advanced Software Engineer Interview Questions
- Advanced Tax Analyst Interview Questions
- Advanced Engineer Interview Questions
- Advanced Software Developer Interview Questions
- Advanced Financial Analyst Interview Questions
- Advanced Application Engineering Analyst Interview Questions
- Accountant Interview Questions
- Show more
Cafe Coffee Day Advanced Analyst Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Cafe Manager
274
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Assistant Manager
211
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Territory Sales Manager
136
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Brew Master
131
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Executive
112
salaries
| ₹0 L/yr - ₹0 L/yr |
Starbucks
Costa Coffee
Barista Coffee Company
Gloria Jean's Coffees
- Home >
- Interviews >
- Cafe Coffee Day Interview Questions >
- Cafe Coffee Day Advanced Analyst Interview Questions
