PepsiCo Data Analyst Interview Questions and Answers

Case study based discussion related to product development

Q1. Introduce yourself
Add your answer
Q2. Tell about your favorite project
Add your answer

Excel assignment on dashboard and analysis

Tableau dashboard assignment and analysis

Q1. Technical question related to excel and tableau
Add your answer

Q1. Related to behavioural and salary discussion
Add your answer

Contains Arithmetic and reasoning questions around 20

Q1. Self Introduction
Add your answer
Q2. Current role and Responsibilities
Ans. 
I am currently working as a Data Analyst at XYZ Company, responsible for analyzing and interpreting complex data sets to provide insights and recommendations.
• Analyzing large datasets to identify trends and patterns

• Creating visualizations and reports to communicate findings

• Collaborating with cross-functional teams to drive data-driven decision making

• Developing and maintaining data models and databases

• Automating data col
Answered by AI
Add your answer
Q3. Business Questions and Data sources used
Add your answer
Q4. 5 Questions on Tableau mostly on LOD, Multiple data handling, Parameters, and Visualization
Add your answer
Q5. 5 Business questions. Difference between Small Stores and big Retailers, How can we attract Customers, Availability of Products in the Store
Add your answer
Q6. 2 Questions on SQL Query. on Joins with Examples
Add your answer

Q1. Self Introduction
Add your answer
Q2. Previous Employer, Why you left?
Ans. 
Seeking new challenges and growth opportunities.
• Desired career advancement

• Limited opportunities for growth at previous employer

• Seeking new challenges and experiences
Answered by AI
Add your answer
Q3. Do you know about our Company brands and Market
Ans. 
Yes, I am familiar with your company brands and market.
• I have researched your company's products and services

• I am aware of your target market and competitors

• I understand the current trends and challenges in the industry
Answered by AI
Add your answer
Q4. General Questions like where you live, Our office is in Mumbai will you comfortable in Hybrid work.
Add your answer
Q5. What is your Salary Expectations
Ans. 
I am looking for a competitive salary based on my experience and skills.
• Research industry standards for data analyst salaries

• Consider your level of experience and skills

• Factor in location and cost of living

• Be prepared to negotiate based on benefits and perks offered
Answered by AI
Add your answer

Excel,sql,advance excel

Sql,excel,advanced excel

Case study - marketing

Q1. About the case study
Add your answer
Q2. Nielsen fundamentals
Add your answer

It was DSA based. 2 questions were there on array & string.

Q1. Discussion on the skills mentioned on resume & on projects.
Add your answer

Q1. Basics such as Intro Relocation Skills Why do you want to switch why do you want to join us
Add your answer

Q1. About my work experience
Add your answer
Q2. About workday HCM
Add your answer