Upload Button Icon Add office photos

Filter interviews by

RedSeer Consulting Data Analyst Interview Questions and Answers

Updated 28 Jun 2021

RedSeer Consulting Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 28 Jun 2021

I applied via Referral and was interviewed in Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Personality based question and to present slide on a specific topic

Interview Preparation Tips

Interview preparation tips for other job seekers - Firstly the HR round for the intro, followed by the TL with personality based questions and lastly the presentation based round

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. What's your exposure to data science before this application
  • Ans. 

    I have exposure to data science through my academic background and previous work experience.

    • Studied data analysis and statistics in college

    • Worked as a data analyst for a marketing firm

    • Completed online courses in machine learning and data visualization

    • Participated in data-driven projects during internships

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Almost everything on Power BI
Round 2 - One-on-one 

(1 Question)

  • Q1. Behavioral skills
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Case Study 

Business problems were asked and analyzed the approach to solve the problem. Reading case studies would help you here

Round 2 - Technical 

(1 Question)

  • Q1. Few Statistics questions were asked. Some coding. And all about our resume in depth. Prepare your resume and Stats well.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare you resume and case studies well.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. What is the number of tourist per day in jaipur
  • Ans. 

    The number of tourists per day in Jaipur varies depending on the season and events happening in the city.

    • Tourist numbers fluctuate based on time of year (peak season vs off-peak season)

    • Events like festivals or cultural events can attract more tourists

    • Historical sites like Amer Fort and Hawa Mahal are popular attractions

    • Tourist numbers can be estimated based on hotel occupancy rates and ticket sales for attractions

  • Answered by AI

I applied via Recruitment Consultant and was interviewed in Jun 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. 1_ Why you feel perfect fit for the role applied
  • Q2. There are many answer to question just stick firmly to you point. Also patience and good preparation is must for mckinsey interview process
  • Q3. Explain your projects, challenges faced and how did you overcome them.
  • Q4. Are you open to travel frequently

Interview Preparation Tips

Interview preparation tips for other job seekers - It's long interviewing process, be calm and confident.
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
6-8 weeks
Result
No response

I applied via Walk-in

Round 1 - HR 

(1 Question)

  • Q1. Discuss About Project
Round 2 - Technical 

(2 Questions)

  • Q1. Your Experience and Out of box nonsense questions
  • Q2. Nothing Technical just nonsense quesions

Interview Preparation Tips

Interview preparation tips for other job seekers - My Personal Opinion Waste Of Time To Go For Interview.
They Never Reply or Come Back If You Are Not Selected.
Just Nonsense Recruiters.

I applied via Campus Placement and was interviewed in Jan 2016. There were 6 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Questions on resume
  • Q2. Small Case study ( statistics )
  • Q3. Why analytics and goal in life
  • Ans. 

    Analytics helps me make informed decisions and achieve my goals in life.

    • Analytics provides valuable insights and data-driven solutions to complex problems.

    • Setting goals helps me stay focused and motivated towards achieving personal and professional success.

    • By analyzing data and setting specific goals, I can track my progress and make necessary adjustments to reach my objectives.

    • For example, in my previous role as a mar...

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Dual Degree students with decent CPI, relevant projects and extras
Tips: Highlight subjects and projects involving data mining, machine learning, marketing research

Round: Test
Experience: PST had 26 questions to be done in an hour (3 cases) and 20 QUESTIONS in 30 mins general apti (level: 2-3 of Arun sharma)
Tips: practice!
Duration: 1 hour 30 minutes
Total Questions: 46

Round: Technical + HR Interview
Experience: Since my resume was filled with

College Name: IIT Kanpur

Interview Questionnaire 

6 Questions

  • Q1. CASE 1: A boiler manufacturer wants to go global, how should he go about doing it?
  • Q2. Tell me about yourself
  • Ans. 

    I am a highly motivated and detail-oriented business analyst with experience in data analysis and project management.

    • Experienced in data analysis and project management

    • Highly motivated and detail-oriented

    • Strong communication and problem-solving skills

    • Proficient in various analytical tools such as Excel, SQL, and Tableau

  • Answered by AI
  • Q3. Why consulting/business?
  • Ans. 

    Consulting/business offers diverse challenges and opportunities to solve complex problems and drive impactful change.

    • Opportunity to work with a variety of clients and industries

    • Ability to solve complex problems and drive impactful change

    • Continuous learning and development

    • Exposure to different business models and strategies

    • Opportunity to work with talented and diverse teams

  • Answered by AI
  • Q4. Why don't you want to do research?
  • Ans. 

    I never said I don't want to do research. In fact, research is an integral part of my job as a Business Analyst.

    • I never said I don't want to do research, I just want to clarify any misunderstandings.

    • Research is an essential part of my job as a Business Analyst.

    • I enjoy conducting research and analyzing data to provide valuable insights.

    • I believe that research is crucial in making informed decisions and driving business ...

  • Answered by AI
  • Q5. Don't you like aerospace?
  • Ans. 

    Yes, I do like aerospace.

    • I find the advancements in aerospace technology fascinating.

    • I enjoy learning about the different types of aircraft and their capabilities.

    • I appreciate the importance of the aerospace industry in our economy and national security.

    • For example, I recently read about the successful test flight of SpaceX's Crew Dragon spacecraft and was impressed by the level of innovation and engineering involved.

  • Answered by AI
  • Q6. CASE 2: Some airline flies from Mango to NY. Should it shift to some other route?
  • Ans. 

    It depends on various factors such as demand, competition, profitability, and operational feasibility.

    • Analyze the demand for the current route and potential demand for other routes

    • Evaluate the competition on the current route and other potential routes

    • Assess the profitability of the current route and potential routes

    • Consider the operational feasibility of shifting to another route

    • Examples of potential routes could be M

  • Answered by AI

Interview Preparation Tips

Round: Case Study Interview
Experience: CASE 1:
I started by trying to get the prerequisites of going global demand, type and size of market, capital, project differentiation, management, logistics. My major mistake was delving too much into depth.

CASE 2:
He asked how you increased revenues?
I said....Everything depends on the elasticity of demand. You might want to increase sales or increase prices and reduce sales. Then he said, we increase prices or demand and assume the other to be constant.

How do you increase prices?
I said you just quote a higher price. Then he said that there are different seats in an airplane. That kind of tinkering you can always do even if you want to keep the revenues same
Tips: 1.In the about yourself questions you can either give an overview of your resume or tell them something more general.
2.You will be asked about your biggest academic achievment.
3.Don't be so cool to the extent of being casual.
4.Don't prepare answers.

General Tips: 1.Attend PPTs and listen very carefully.
2.Be sure to find out what you will be doing in the company.
3.Don't try and squeeze too much in your resume.
Skill Tips: 1. For case studies thereis a lot of stuff on the LAN and on the internet.
2. It's better to do these in groups.
College Name: IIT BOMBAY

Interview Questionnaire 

5 Questions

  • Q1. CASE 1: Estimate the consumption of vodka in bombay
  • Ans. 

    Estimate vodka consumption in Bombay.

    • Gather data on population demographics, alcohol consumption patterns, and sales data.

    • Use statistical analysis to estimate consumption based on available data.

    • Consider factors such as income levels, cultural attitudes towards alcohol, and availability of vodka.

    • Compare estimates to similar cities or regions for context.

    • Adjust estimates based on any unique factors specific to Bombay.

    • Co...

  • Answered by AI
  • Q2. Q1: Why consultancy?
  • Ans. 

    Consultancy offers diverse opportunities to work with different clients and industries, and to constantly learn and grow as a professional.

    • Consultancy provides exposure to various industries and clients, allowing for a diverse range of experiences and challenges.

    • Working as a consultant requires constant learning and adaptation to new situations, which can be intellectually stimulating.

    • Consultancy offers the opportunity...

  • Answered by AI
  • Q3. Q2: What will you do if all consultants die one fine morning?
  • Ans. 

    I would assess the impact on the project and identify alternative solutions.

    • Assess the impact of the loss of consultants on the project timeline and deliverables

    • Identify alternative solutions such as hiring new consultants, redistributing work among existing team members, or outsourcing work

    • Communicate with stakeholders and project sponsors to keep them informed of the situation and proposed solutions

  • Answered by AI
  • Q4. CASE 2: How to go about starting an airline
  • Ans. 

    Starting an airline requires extensive planning, research, and investment.

    • Conduct market research to identify demand and competition

    • Develop a business plan including financial projections

    • Obtain necessary licenses and permits

    • Acquire or lease aircrafts and hire staff

    • Establish partnerships with suppliers and vendors

    • Implement marketing and advertising strategies

    • Ensure compliance with safety regulations and industry standar

  • Answered by AI
  • Q5. Why not research?
  • Ans. 

    Research is important, but I am more interested in analyzing and solving business problems.

    • I enjoy working with data and finding insights to improve business processes

    • I am skilled in identifying patterns and trends in data

    • I prefer to focus on practical solutions rather than theoretical research

    • I believe my strengths lie in problem-solving and decision-making

    • For example, in my previous role as a business analyst, I anal...

  • Answered by AI

Interview Preparation Tips

Round: Case Study Interview
Experience: CASE 1:
I took a long time to do this one. The interviewer was not helpful and that slowed down my response. I had only discussed the consumption of vodka by women when she asked me to stop.

CASE 2:
There was no real case here. The interviewer wanted me to discuss how to go about starting an airline.He asked me to estimate the no. of passengers.

Round: HR Interview
Experience: 1. Questions regarding my projects and internships were asked.
2. A large part of the interview was devoted to "McKinsey vs its competition.

Skill Tips: 1.Attend PPTs of all the companies that you are interested in.
2.Don't exaggerate in your resume.
3.Case studies is a must for consultancies.
College Name: IIT BOMBAY

Tell us how to improve this page.

Interview Questions from Similar Companies

Huron Interview Questions
3.8
 • 33 Interviews
Thoucentric Interview Questions
3.9
 • 16 Interviews
MGB Interview Questions
3.1
 • 14 Interviews
Korn Ferry Interview Questions
3.3
 • 14 Interviews
View all
RedSeer Consulting Data Analyst Salary
based on 5 salaries
₹2.7 L/yr - ₹2.9 L/yr
56% less than the average Data Analyst Salary in India
View more details

RedSeer Consulting Data Analyst Reviews and Ratings

based on 3 reviews

3.8/5

Rating in categories

2.9

Skill development

3.1

Work-life balance

3.1

Salary

3.8

Job security

3.0

Company culture

2.2

Promotions

3.0

Work satisfaction

Explore 3 Reviews and Ratings
Associate Consultant
72 salaries
unlock blur

₹10.4 L/yr - ₹29 L/yr

Data Specialist
63 salaries
unlock blur

₹2.4 L/yr - ₹3.6 L/yr

Business Analyst
56 salaries
unlock blur

₹4.7 L/yr - ₹17.3 L/yr

Research Analyst
42 salaries
unlock blur

₹2.8 L/yr - ₹6.8 L/yr

Senior Consultant
37 salaries
unlock blur

₹16 L/yr - ₹45 L/yr

Explore more salaries
Compare RedSeer Consulting with

McKinsey & Company

3.8
Compare

Protiviti India Member

3.2
Compare

QDegrees

3.6
Compare

Coherent Market Insights

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